We provide IT Staff Augmentation Services!

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

  • SQL Server 2014/2012/2008 R2/2008 Enterprise
  • SSIS/SSAS, PerformancePoint
  • T - SQL
  • Performance Tuning
  • Capacity Planning
  • Installation, Upgrade, & Migration
  • ODBC, OLE DB
  • GUI Power Builder, VB, VC++, VC#, VJ++ 6.0
  • Turbo Analyst, Erwin

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:

  • 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

Hire Now