ETL Developer Resume

SUMMARY

Around 10+ years of extensive IT professional experience with expertise in Database Development, Database modeling, Design and Technical Management.
Extensive experience in migrating Data from Excel, Flat file to MS SQL Server by using MSSQL Server SSIS.
Hands on experience in SSRS in generating reports of day - to-day transactions.
Experience in Designing, Creating, and managing multidimensional structures using SSAS.
Experience in development the Microsoft Analysis services cubes.
Extensive knowledge of Relational Database Management Systems.
Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Temporary tables, user defined data types and functions.
In-depth knowledge of T-SQL, MS SQL (DDL, DML, and DCL).
Hands on experience in troubleshooting database issues.
Experience in setting and monitoring Backups\Restore, Database Mirroring, Log shipping and Replication.
Maintained Database authentication modes, created users, configuring permissions and assigning roles to users.
Experience in installation and configuration of MS SQL Server 2008/2005/2000 Versions
Used Microsoft Source Safe for version control and configuration management.
Excellent experience in designing, developing and debugging SAS Programs and SAS Macros to access, extract, merge and analyze data, and output statistical analysis files and reports.
Experienced in producing Excel, RTF, HTML and PDF formatted files using SAS ODS to produce ad-hoc reports for presentation and further analysis.
Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2005/2008, R2, 2012

ETL Tools: SSIS, INFORMATICA POWERCENTER

Database Tools: Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, SSIS, SSRS, SSAS

Programming Languages: SAS, SQL, TSQL,SP, ASP.NET,C#, HTML, XML, Java, Python.

Scripts: Java Script, VB Script, HTML

Applications: Microsoft office, vss and Visual Studio

Reporting Tools: SSRS, Tableau, SAS

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

Data Staging for FundSuiteArc.
Performed major role in understanding the business requirements and designing and loading the data into FundSuiteArc.
Design SSIS Packages using BIDS to bring data from different sources to Data Arc.
Create FundSuiteArc environment and set up connections for Automation.
Set up data profiler for FundSuiteArc for error detection.
Create Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and Functions.
Writing T-SQL Programming for implementing Stored Procedures.
Create custom report for shareholders clients using SSRS.
Used ETL (SSIS) to load data from source to Staging table.
Created complex mappings using Lookup, Sorter, Aggregator, Union for populating target table.
Created SQL queries, Packages, Functions, Procedures, Views, and Database Triggers.
Expertise in configuration, performance tuning, installation & integration of various data sources/targets like Oracle, MS SQL Server, Flat files and Design ETL processes that span multiple projects.

Environment: MS SQL Server 2016, Management Studio, BIDS/SSRS/SSIS, Visual Studio2016, VSS

Confidential

MS SQL Developer

Responsibilities:

Actively involved in writing T-SQL Programming for implementing Stored Procedures.
Worked with SSIS to import/export and transform the data between the linked servers.
Create Varity types of reports in SSRS for analysis purposes.
Designed SSIS Packages to transfer data across different platforms,
Set up SQL Agent to Automate the SQL jobs.
Created interactive Dashboard for C level decision making steps.
Setting up Automated Report subscriptions to our members.
Actively involved in Creating and Migrating databases across many servers.
Automate and implemented SQL server maintenance jobs.
In-Depth working knowledge of ODBC.
Created many complex Stored Procedures / Functions and used them in to generate reports on the fly.

Environment: MS SQL Server 2016, Management Studio, BIDS/SSRS/SSIS, Visual Studio2016

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship