Software Designer / SSIS Lead Resume

SUMMARY

10+ years of database analyst / application developer experience in SQL Server databases
Experienced SSIS Lead
Experienced SQL Server Data Warehousing Lead developer
Used power BI tools for reporting like Power Pivot, Power View, Power Query
Used Erwin tool and ErStudio for Data Modeling
Migration of Access applications to SQL Server
Performed TFS administration and customization to support business requirements
Worked using .Net and Matlab code to Work on Ride Handling Metrics for GM Vehicles
Used Third Party Tools Red Gate SQL Server SQL Compare and SQL Data Compare
Can work independently and can learn new technologies on my own and also help other team members on the same.
Participating in SOX Audit for SQL Server Databases in Confidential Worldwide
Part of SOX Planning team and SOX Automation team
Good team leader and team player
Worked on Projects using Waterfall and Agile Methodology

AREAS OF EXPERTISE

PROFESSIONAL EXPERIENCE

Confidential

Software Designer / SSIS Lead

Responsibilities:

Primary designer for all databases developed by the Configurable Services Tools Automation (CSTA) team.
Primary interface for the metrics and reports required.
Design, implement and maintain database schemata across multiple versions.
Lead the analysis, design, development, troubleshooting, debugging and maintenance of high-volume, transactional systems.
Provide hands-on insight into system architecture, data software development and architectural design.
Evaluate the need for live site enhancements which improve performance, availability, reliability and customer satisfaction.
Ensure overall solution-level integrity of applications.
Perform quality assurance on all new code from inception through integration, staging and production environments.

Tools: RDBMS/DBMS: MS-SQL Server 2008/2012/2014 , SSIS, SSAS, SSRSData Modelling Tool: Erwin, ErStudio

Programming Languages: T-SQL

Confidential

Programmer Analyst

Responsibilities:

ETL Design for Loading to SSAS and SQL Server Database Engine using SSIS
ETL Design for Processing SSAS Cube using SSIS
Data Transformation and Integration
Performance and Query tuning
Documenting Installation Guide and Quick Run Book
ETL Design using Erwin Data Modelling tool
Generating create / alter schema generation scripts from Data Model
Developing ETL using SSIS 2008 R2 and TFS 2010 for source code control
Scripting using C#.Net as part of ETL to transform the data from SharePoint to normalised SQL Server Tables
Comparing databases using Visual Studio 2010 for Moving Development to Pre-Production
Brainstorming team during meetings to get consensus on new ideas.

Confidential

Programmer Analyst

Responsibilities:

Data Administration
Data Transformation and Integration
Performance and Query tuning
Supporting Development team on need basis
Designing and Developing ETL package to load data from Flex-net software to SharePoint
Ensure that the Server and databases were up and running and the throughput is at acceptable level

Confidential

Programmer Analyst

Responsibilities: