We provide IT Staff Augmentation Services!

Team Lead Resume

SUMMARY

  • 7 years of experience in Reports, Packages development, analysis, design and testing and implementation.
  • 3 years of coding experience in multiple languages like C#, VB Script, VB 6.0.
  • Having extensive working experience on SSRS, SSIS, SQL and having knowledge in Cube designing in SSAS.
  • Good experience in designing the complete data ware housing solution including implementation of BI technology in achieving better Reporting.
  • Experience in extracting the data from heterogeneous sources, transforming and loading (ETL) process using SQL Server 2012/2008/2005 Integration Services.
  • Experience in creating SSIS Packages with various Tasks and Containers in SSIS Control flow for Data Cleansing
  • Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Union All, Merge Join and OLEDB Command to load data into SQL Server destination.
  • Experience in SSIS packages execution, Applying security and deploying packages to servers.
  • Experience in creating configurations files, log files, error handling, Check points etc. for SSIS Packages.
  • Experience in creating the Jobs for the SSIS Packages as per the business requirement using SQL Server agent.
  • Experience in developing Tabular, Matrix, Ad - hoc Reports and charts using SQL Server 2012/2008 /2005
  • Experience and knowledge in testing Data Quality using the tool IFL.
  • Proficient in using databases SQL Server 2012/2008/2005 , SQL programming i.e., views, Stored Procedures and Packages, understanding on Indexes, performance tuning.
  • Experience in Production Support including deployment and migration activities from Development through Testing in production environment.
  • Analyzing and fine tuning the complex SQL queries which we use in Reports and SSIS Packages.
  • Can play the role as a Team leader and can maintain the team with good coordination with the team members.
  • Strong & Active team player, flexible to adopt new technologies and environment, Posses excellent understanding, grasping, interpersonal and presentation skills.
  • Hands on experience in leading teams and developing C# .NET, ASP.NET coding
  • Excellent problem solving skills.

TECHNICAL SKILLS

BI TOOLS: SSIS 2012, 2008, 2005

REPORTING TOOLS: SSRS 2012, 2008, 2005

DATABASES: SQL Server 2012,2008,2005,2000

PROGRAMMING: C#, VB.NET, Vbscript, JavaScript

DOMAIN KNOWLEDGE: Banking, Health Management Services, Insurance, CPG, Judiciary.

PROFESSIONAL EXPERIENCE

Confidential

Team Lead

Environment: SSIS, SSRS, SQL 2012, TFS

Responsibilities:

  • Collect the requirements from the clients and doing the initial step of documentation.
  • Prepare the technical and business documents and getting sign-off from the client.
  • Build DB structure and table attributes as per the requirement documents.
  • Build SQL Server Integration Services (SSIS) packages as per the requirements to load data from files to staging and then applying business rules.
  • Create SQL server Agent jobs and schedule the jobs to load data on a regular basis.
  • Build the Stored Procedure, Functions and views which are required for the process.
  • Analyze the execution plan of queries and stored procs to create indexes.
  • Fine tune the queries for getting faster results.
  • Major step of the process is creating reports to generate EPDL files.

Confidential

TEAM LEAD

Environment: SSIS, SSRS, SQL 2012, TFS

Responsibilities:

  • Design reports for the existing data according to the levels of services.
  • Build reports in excel for immediate purpose, doing the cosmetic changes and delivering the client.
  • Apply the enhancements to the existing reports in Medcompass.
  • Loading data from various OLTP databases to staging and cleansing the data using business rules.
  • Define the required dimensions and facts for the DataMart and design them.
  • Create SSIS packages to load data and schedule them on a regular basis.
  • Analyze the execution plan, verify more dense points and create required indexes.

Confidential

TEAM LEAD

Environment: SSIS, SSRS, SSAS, .NET, SQL 2012, MS-ACCESS 2012, TFS

Responsibilities:

  • Creating Tables, Views, and Stored procedures.
  • Optimizing queries.
  • Creating and scheduling jobs in SQL server.
  • Pulling data from other databases and importing to SQL Server
  • Extensively used ETL Components to Extract Data from Different Sources
  • Using design documents and mapping documents developed dtsx packages.
  • Created templates to save the time in developing the packages.
  • Created UNIT test cases and prepared technical specifications for SSIS packages.
  • Implemented CDC Techniques.
  • Writing stored procedures and T-SQL.
  • Applying standards like logging check points, and package configurations.
  • Involved in deployment.

Confidential

TEAM LEAD

Environment: SSIS, SSRS, SQL 2012, MS-ACCESS 2012, TFS

Responsibilities:

  • Analyzing the existing reports in CSW, CCW Applications.
  • Exploring the data of reports in DataMarts.
  • Checking with the Mainframe team for the verification of correct data.
  • Creating and doing the amendments in SSIS packages to load the data in datamarts for reports.
  • After data verification process is done and got approval from architect, redesigning the reports in SSRS which are existing in MS-ACCESS.
  • Communicating with End Users regarding their Requirements if any changes needed
  • Providing security to the reports depending on the department.
  • Deploying the reports in report server and verifying with the users.

Confidential

Developer cum Lead.

Environment: SSIS, SSRS, SQL 2008, PVCS

Responsibilities:

  • Coordinate with Client in gathering requirement and share the work among team members.
  • Design and Develop reports using SSRS and including the features whatever users are requesting.
  • Take the responsibility and ownership of the tasks which are assigned.
  • Understand and analyze the client requirements
  • Design and Develop ETL’s using SQL Server Integration Services (SSIS) as per the requirements that are provided by the client.
  • Apply the enhancements in the reports i.e. .rdl file (SSRS).
  • Developing the Stored Procedure and Functions as per the requirements that are provided by the client.
  • Testing the reports and T SQL Code to satisfy all the requirements / instructions provided in TSG Service Now Tool.
  • Fixing the issues that are occurred at any phase.
  • Timely Completion of Assignments with Quality.
  • Deliver the assignments in a timely manner and follow set standards and procedures.

Hire Now