ETL DEVELOPER Resume

SUMMARY:

Detail - oriented, efficient and organized professional with 4-year experience in financial and managerial accounting systems.
Organized, take-charge professional with willingness to fill in as needed, eagerness to quickly self-learn new technologies, exceptional follow through abilities and detail orientation; a drive and dependable performance to doing things right.
Possess strong analytical and problem solving skills, with teh ability to make well thought out decisions.
Excellent communication skills in data management, listening and assessing requested desires, and assisting to satisfy needs.

WORK EXPERIENCE:

ETL DEVELOPER

Confidential

Responsibilities:

Installed, upgraded, and configured SQL Servers from SQL Server 2005 to SQL Server 2017 R2 enterprise edition and enabling SSIS/SSRS/SSAS on Client machines, Development, Production servers.
Created stored procedures, views, triggers and constrains to implement teh database consistency and integrity.
Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
Created SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.
Scheduled SSIS packages Created as Agent jobs using SSMS.
Did performance tuning at source, transformation, target, and workflow levels.
Analyzed and executed teh test cases for various phases of testing - integration, regression and user
Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using SSIS to extract teh data from multiple source systems that comprise databases like SQL Server 7.2, flat files to teh Staging area, EDW and tan to teh Data Marts.
Created stored procedures using SQL Server management Studio to carry out required task.
Prepare Change Orders for monthly Deployments to Production Environment.
Create, INSERT and UPDATE tables within teh lower environments and push for deployment into Production environment.
Captured business information needs from stake holders and translated into requirements and functional specifications. Evaluated and recommended best form of delivery - report manager report, refreshable Excel spreadsheets, or SSAS Cube.
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

BRANCH SUPERVISOR

Confidential

Responsibilities:

Review business trends and advice customers to make informed financial decisions related to expected Fluctuations; participate in loans, insurance, mortgages, wealth management sales.
Advise commercial customers on their financial problems and use their feedback to develop future financial Prospects for teh bank.
Present bank's competitive services to targeted clients to meet their individual financial needs.
Evaluate costs and revenue of agreements of bank's expenses and income to make informed future decision on profitability.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship