Ravi Sudheer Chavali
- BI Developer-SSIS, SSRS/SQL Developer
- Wilson, NC
- Member Since May 23, 2023
Candidates About
Ravi Sudheer Chavali
BI Developer - SSIS/SSRS SQL Developer
-------------------------------------------------------------------------------------------------------------
|
|
PERFORMANCE SUMMARY: v A result-oriented professional with over 10 Years’ experience in application development & Enhancement, delivery and client relationship management in banking domain. v Extensive experience in business information systems primarily focusing on developing database solutions with business Intelligence tools using SQL Server 2014/ 2012 as a developer / Integration / Reports/Data ware house developer. v Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML). v Experience in Trouble Shooting, Performance tuning of reports and resolving Report issues. v Great interpersonal skills, exceptional problem-solving ability. v Excellent understanding of SDLC and Agile methodologies and best practices. v An excellent team player & technically strong person who have capability to work with business users, project managers, team leads and architects to maintaining healthy environment in the project.
Technical Skills:
Education:
• Bachelor of Technology – Electrical & Electronics Engineer.
|
||||||||||
|
|
|
|
|||||||||
WORK EXPERIENCE
BB&T Bank Aug 2014 - Till Date
Wilson, NC
BI Developer-SSIS, SSRS/SQL Developer
Recovery Management System (RMS) maintains information on accounts that have been charged-off. This information includes account number; charged-off and collected balances by category; customer name and demographics; and employer information. RMS also maintains Legal, Bankruptcy and Probate information of each account.
Role and Contribution:
Ø Actively involved in the gathering and analysis the requirements and responsible for writing Business Approach Documents (B.A.D) and Technical documents for projects.
Ø Creating SSIS packages and/or build solutions as per requirements in Development/Maintenance projects.
Ø Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
Ø Conducting peer review meetings with Clients to review the build solutions.
Ø Supporting System Integration testing and User Acceptance Testing.
Ø Carrying out Conference calls with Project Stakeholders for Status updates.
Ø Preparing appropriate Testing Environment and Testing of developed code and Preparation of Test Result Documents.
Ø Deployment of the application solutions in the production environment.
Ø Providing Post Implementation Support.
Ø As part of Maintenance projects, responsible for troubleshooting and fixing the existing issue and Enhancements.
Ø Prepare and manage documentation on TFS.
Ø Creating Knowledge Transfer (KT) documents on various complex business processes, which are very helpful for understanding the Business to the Clients as well as Team members.
Development Environment: MS SQL Server 2014/2012, SQL Server BIDS: Integration Services (SSIS), Reporting Service (SSRS), TFS, MS Excel, Microsoft Outlook, CA Workstation.
American Express Technologies Feb 2012 - Jul 2014
Plantation, FL
SQL Server & Data Warehouse Developer
GRMS is the part of AMEX GRS (Global Risk Systems). This application provides individual risk assessments based on a Customers' relationship with the American express products. GRMS weighs information across all accounts under a customer to determine and predict a customer’s ability to pay. The models also analyze customer data over an 18-month period, weighing what happened in the past to predict what is likely to happen in the future. This application interfaces with other risk applications such as CAS (Credit Authorizations Systems) and WCC (Worldwide Credit Collection)
Role and Contribution:
Ø Gathered requirements from stakeholders for implementing Data Integration.
Ø Implemented various PDI Steps and Jobs in cleansing and load the data as per the business needs.
Ø Using SOAP Web Services and REST Services calls data gets load into OLTP Database tables.
Ø Designed custom processes to import data into database and ETL.
Ø Created ETLs to fetch data from OLTP databases and load into Staging Tables. Further, creating outbound files to Downstream Applications.
Ø Used the data Integration tool for designing ETL jobs in the process of migrating data from SQL Server to Warehouse.
Ø Involved in Code reviews for testing the converted data along with QA team.
Ø Involved in preparing test plans, unit testing, system integration testing.
Ø Responsible for scheduling the jobs in Test and Production Environments.
Ø Involved in creation of various automation processes to existing system.
Development Environment: MS SQL Server 2014/2012, Integration Services (SSIS), T-SQL, CA7, Informatica, SharePoint
Bank of America (BOA) Jan 2011 - Jan 2012
Hyderabad, India
Mainframe Developer
Bank of America, one of the leading banks in the United States of America, with its world headquarters located at Charlotte, North Carolina, USA. Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses management and other financial and risk management Products and Services.
Batch monitoring tool is a single integrated view of the current status, functionality, historic metric and overall health of the Jobs/Process across CIS Application and its purpose are
§ Monitoring of current status of a Job.
§ Generates Alerts to the users for the Jobs that are failed in the last 90 Minutes.
§ Generated the Alerts to the user when a job is running for more than the usual time i.e. Long running job alerts.
§ Provides a facility to generate Automated Reports on batch Jobs/Processes execution at any point of time.
Role and Contribution:
Ø Involved in the development of COBOL Programs for CIS –Batch Monitoring tool.
Ø Preparing Approach documents and Low Level design document (LLD).
Ø Preparing Test Scenarios.
Ø Unit Testing of Developed code.
Ø Promoted components to deploy them into Production using Changeman.
Ø Preparing the Automated tools, this will reduce the Manual efforts and tedious process.
Development Environment: COBOL, JCL, REXX, Easytrieve, DB2, FILE AID, SPUFI, DFSORT.
National Securities Depository Limited Aug 2007 - Dec 2010
Mumbai, India
Mainframe Developer
NSDL is the first depository system in India jointly promoted by three premier financial institutions of India, namely, Unit Trust of India (UTI), Industrial Development Bank of India (IDBI) and National Stock Exchange of India Ltd. (NSEIL).
Role and Contribution:
Ø Analyzing the Design Documents and business requirement documents.
Ø Developing the application as per the requirement documents.
Ø Testing the code changes.
Ø Scheduling and monitoring the jobs in production.
Ø Support the application by providing production support 24x6.
Ø Preparing the Adhoc Queries and generating the reports as per business requirements.
Ø Acted as the Module Lead for the CA/ACA Benpos Application which is a team of 5.
Ø Preparing the Automated tools, this will reduce the Manual efforts and tedious process.
Environment: COBOL, JCL, CICS, REXX, DB2, TSO/ISPF, VSAM, DFSORT SPUFI, QMF.