We provide IT Staff Augmentation Services!

Tech Lead Resume

Phoenix, AZ

Professional Summary

  • Around 9 plus years of IT experience as a Project Lead / Software Engineer involved in development, Production support.
  • Expertise in Entire Software Development Life Cycle.
  • Hands on experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).
  • Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, Excel , MS Access, CSV, flat file
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experience in Performance Tuning in SSIS packages by using Block and Unblock Transformations.
  • Creating Package dependencies by calling Child packages from the parent Package using SSIS.
  • Hands on experience in tuning packages to identify and eliminate performance Bottlenecks and Error Handling Mechanisms.
  • Experience in handling large volumes of data in Production environment.
  • Hands on experience in SQL Server Reporting Service (SSRS)
  • Experience in creating drill down, drill through and linked reports using SSRS (SQL Server Reporting Services) .
  • Knowledge of Dimensional Data Model concepts, Dimension and Fact tables,
    Surrogate keys, Star and Snow Flake Schema.
  • Expertise in implementing business logic using Triggers, Views and Stored Procedures.
  • Proficient at Performance Tuning with a solid knowledge of Optimizing Code.
  • Experience in solving Real Time issues with DBCC checks, Query Tuning, Error and Event Handling.
  • Experience in creating Indexes for faster performance
  • Experience in developing applications using C#.NET 2.0/3.0, ASP.NET 2.0/3.0 and .NET Framework 2.0/3.0/3.5.
  • Provided in-depth analysis to resolve production and application issues.
  • Proactively monitoring the jobs and avoid the incident and Troubleshoot business facing issues and resolving incident.
  • Coordinate with multiple teams for incident resolution and break fixes.
  • Provide 24x7 support to all production issues on holidays and weekends
  • Ability to work with all levels of management, willingness to learn and implement new ideas quickly and to be a collaborative team player.
  • Excellent analytical, communication, documentation and interpersonal skills.
  • Highly motivated resourceful team player that takes a positive approach to problem resolution.

Technical Skills

Data warehousing tools: SSIS,SSRS

Languages: C, C++, SQL, Java Script

Web: ASP.NET 3.0, C# , WWF

RDBMS: Oracle 10g, 9i/8i, MS SQL Server 2008/2005, DB2 8.0, MS Access

Operating System: MSDOS, Windows 95/98/2000, Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Tech Lead

Confidential is a global services company. The Company's principal products and services are charge and credit payment card products and travel-related services offered to consumers and businesses worldwide.

Roles & Responsibilities:

  • Proactively monitoring the jobs and avoid the incident.
  • Troubleshoot business facing issues and resolving incident.
  • Daily support, troubleshooting, monitoring, optimization and tuning of SQL Server Jobs, Packages and SQL server environments across entire system.
  • Coordinate with multiple teams for incident resolution and break fixes.
  • Implemented MERGE statement for improving the stored procedure performance.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Tested packages and fixed bugs using SQL 2008 R2 Business Intelligence development studio.
  • Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages
  • Rerun the failed jobs and send the files to downstream.
  • Written T- SQL, Pl/SQL queries for data retrieval.
  • Created and modified complex TSQL batches / stored procedures. Involved in creating new Stored Procedures and Optimizing existing queries and Stored Procedures.
  • Performing query plans and making sure each and every query is using appropriate useful Indexes
  • Rebuilding Indexes and Tables as part of performance tuning exercise.
  • Fine tuned SQL queries for maximum efficiency and performance.
  • Validated change requests and made appropriate recommendations. Standardized the implementation of data.
  • Used SFTP tasks when required.
  • Setting up User Permissions.
  • Hold and release the jobs when planed CMR happened.
  • Provide 24x7 supports to all production issues on holidays and weekends.

Environment: SSIS 2008, SSRS 2008, SQL Server2008.

Confidential, Louisville , KY

Senior Software

Confidential is one of the nation’s largest health care providers of individual & family, group, Medicare, dental, vision and life insurance products. Humana's diverse lines of business work to serve all types of consumers. From families to seniors to military members to self-employed individuals, there is a plan to meet many unique needs.

Roles & Responsibilities:

  • BSPM is the application that completely automated process.
  • Systems and processes to support the identification, evaluation, and routing of members into interventions.
  • Enabled and Disabled Indexes and Tables as part of performance tuning.
  • Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
  • Implemented MERGE statement for improving the Package performance.
  • Deployed the created SSIS packages in Development and Testing environments.
  • Developed SSIS packages as per requirements and extracted and loaded data using FTPs.
  • Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to different databases.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Tested packages and fixed bugs using SQL 2008 R2 Business Intelligence development studio.
  • Worked on SSIS performance tuning using error handling, event handling, re-running of failed SSIS packages using checkpoints.
  • Designed Complex SSIS ETL packages to load the data from different sources like OLEDB, EXCEL and FLAT Files.
  • Configured Checkpoints on SSIS packages so that the package would restart from the point of failure.
  • Configured SQL mail agent for sending automatic emails when SSIS package fails or succeeds.
  • Fine tuned SQL queries for maximum efficiency and performance.
  • Created Configuration files with XML documents to support the SSIS packages in different environments.

Environment: SSIS 2008, SSIS 2012, ASP.NET, WWF, SQL SERVER 2008, ORACLE.

Confidential, Phoenix , AZ

Senior Software

Confidential in partnership with Confidential , develops and delivers high-quality training for their products and solutions. Confidential University’s priorities include Confidential ’s product launches, sales force and channel enablement including solution and executive selling, certification and associate skills development. Confidential University supports and maintains the Confidential Learning Centre where both Confidential Professional Certification and Learning Program content can be found.

Roles & Responsibilities:

  • Involved in Technical Document Design Based on Functional Specification.
  • Development of packages according to the ETL specifications for the staging area.
  • Pull the data from Staging Area to Data Sync Tool.
  • Creating master and child packages, package configurations Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Email Task, and Data Flow Task.
  • Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data in and from Guide Wire OLTP Data Warehouse and Data Mart.
  • Created packages in SSIS with error handling and Worked with different methods of logging in SSIS
  • Configured SQL mail agent for sending automatic emails when SSIS package fails or succeeds.
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts, Pie Charts.
  • Developed report parameters and performed Parameterized and cascading parameterized reports and sorting the data, defining subtotals for the reports using SSRS in Visual Studio
  • Designed complex reports like Drill-Down Reports, Drill-Through Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
  • Involved in writing stored procedures, functions and created the reports (SSRS).
  • Responsible for creating Tabular, Matrix and Drilldown Reports using SSRS.

Environment: Windows XP, SSIS 2005, SSRS 2005, SQL Server2005

Confidential

Senior Software

Confidential International is one of the world's leading professional recruitment consultancies. The Group has operations in the UK, Continental Europe, Asia-Pacific and the Americas. Confidential core vertical markets are FMCG, Healthcare, Media, IT/Telco, Financial Services, Business Services and Manufacturing, Campaign Management..

Roles & Responsibilities:

  • Created different ETL packages using SSIS from UK and Non UK source to Sql server as destination. Development of packages according to the ETL.
  • Development of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server 2005.
  • Development of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server 2005.
  • Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Email Task, and Data Flow Task.
  • Created SSIS packages by testing and cleaning the standardized data by using tools in Data Flow Transformation (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for the existing and new packages.
  • Used different control flow and data flow tasks for creating SSIS packages, used different kinds of transformations for data conversion, sorting and data cleansing from different sources into company’s formats
  • Applied various data transformations like aggregate, sort, Multicasting, Conditional Split, Derived Column etc

Environment: Windows XP, SSIS 2005, SQL Server 2005

Confidential

Software Engineer

Confidential are the World’s leading publishing company with more than 700 stores in America. Barnes & Noble.com is the Web's premier destination for Books, DVD, Music, PC & Video Games, Children's titles, Toys & Games, Gift Cards, and more. The project is to create different SSIS Packages, which migrates the data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different SSAS Cubes. The project was also to design and develop the database for the Sql server 2005. Our Team was also responsible for scheduling the packages using Batch files every night and generating Sales Ranking reports using SSRS.

Roles & Responsibilities:

  • Created different ETL packages using SSIS from Oracle source to Sql server as destination Requirement/ design document.
  • Creation of database, tables and procedures to update and clean the old data.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages. Configures SQL Mail agent for sending automated alerts/email.
  • Configured SQL mail agent for sending automatic emails when SSIS package fails or succeeds.

Environment: SSIS 2005, SQL Server 2005

Confidential

Software Engineer

Confidential is involved in telecommunication business. Confidential is one of the UK's leading provider of high speed broadband internet, offering digital TV, telephone and internet services for the home. As a result of Confidential acquiring a number of companies they have inherited a number of different IT systems. Harmony project aims at doing away with all the different IT systems and coming up with a single platform.

Modules of the Confidential Harmony Project:

  • SOE (Sales Order Entry)
  • Tariff Module
  • Link and Merge
  • Features

Roles & Responsibilities:

  • Involved in coding & development of the SOE module.
  • Involved in writing Business Components.
  • Involved in writing stored procedures.
  • Developed the module in full integration with VSS & Source Offsite

Environment: C#, ASP.NET, SQL Server 2000

Confidential

Software Engineer

This project is related to Real Estate business. Project has been divided into Extranet and Website. Extranet is basically for Admin users who can enter the details and this is accessible only for the client. And website is for Realtors and also for the End user.

Roles & Responsibilities:

  • Involved in coding & development of the extranet module.
  • Involved in writing Business Components.
  • Involved in writing stored procedures.
  • Involved in writing a NUNIT test cases.

Environment: C#, ASP.NET, SQL Server 2000

Hire Now