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

TECHNICAL SKILLS:

Database: SQL Server 2014/2012/2008 R2/2008 EnterpriseSSIS/SSAS, PerformancePointT - SQLPerformance TuningCapacity PlanningInstallation, Upgrade, & MigrationODBC, OLE DBGUIPower Builder, VB, VC++, VC#, VJ++ 6.0Case ToolsTurbo Analyst, Erwin

PROFESSIONAL EXPERIENCE

Confidential - Houston, TX

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.
• Attended requirement and data gathering sessions using Agile Methodology
• Used Erwin tool for database and dimensional modelling
• Designed, documented, reviewed and implemented the Database Design using Erwin and SQL Server 2012 / SQL Server 2014
• Designed, documented and reviewed the ETL design using Erwin and SSIS
• Designed, documented and reviewed the cube design using Erwin and SSAS
• Designed, documented and reviewed the reports
• Used TFS 2012 and TFS 2013.
• Administered TFS, created projects and managed users
• Upgraded and Migrated TFS to another server in a non-trusted domain
• Customized work items in TFS to store helpdesk tickets in TFS
• Used Visual Studio
• Lead development of BI projects
• Integration Services
• Analysis Services
• Reporting Services
• Used Data Tools to compare schema and data of Servers

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

Confidential - Plano, TX

Programmer Analyst

Responsibilities:

• Attended requirement and data gathering sessions
• Used Visual Studio
• Develop SSIS Projects
• Develop SSAS Projects
• Develop SSRS Projects

Tools: RDBMS/DBMS: MS-SQL Server 2008/2012, SSIS, SSAS, SSRSData Modelling ToolErwin, ErStudio Programming Languages: T-SQL

Confidential

Programmer Analyst / SSIS Lead

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 - BAPWarren, MI

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 - Internal ProjectBangalore, India

Programmer Analyst

Responsibilities:

• Data Administration, Transformation and Integration
• Supporting Development team on need basis
• Working on SSIS to load HR and Bluebook data
• Ensure that the Server and databases were up and running
• Patching as and when required with 24 hours advance downtime notification
• Migration of SQL Server to new 64 bit hardware as and when required

Confidential

Programmer Analyst

Responsibilities:

• DB object design, migration of objects, capacity planning
• Performance Tuning, Space Management
• Confirm backups are running regularly & successfully
• Ensure high availability & DR solutions are in place
• Change management, Problem Management, Release management