Application Development Team Lead Resume

SUMMARY:

10+ years of diversified experience in data technologies.
Extensive experience in Data Warehouse Design & Development.
Microsoft technologies including Microsoft BI (SSIS, SSRS), Microsoft SQL Server, PDW.
Microsoft Azure Data Warehouse.
Experience on Power BI.
Experience working on onshore/offshore highly complex projects.
Experience working in Agile development environment.
AZ900 certified

TECHNOLOGY EXPERIENCE:

Microsoft SQL Server Integration Services

Microsoft SQL Server Reporting Services

Microsoft SQL Server

Microsoft Azure Data Warehouse

Microsoft Parallel Data Warehouse

Team Foundation Server

Power BI

PROJECTS UNDERTAKEN:

Confidential

Application Development Team Lead

Responsibilities:

Requirement Understanding
Database design
Development of SSIS Packages/ SQL Server Stored Procedures for reporting
Power BI Report enhancements
Maintenance of infrastructure & security for the server

Technologies: SQL Server, SSIS, Power BI.

Confidential

Senior Software Engineer

Responsibilities:

Developing Streamsets pipelines to collect JSON Data to Amazon S3
Developing AWS Redshift scripts using Wherescape Red to apply transformations on data to prepare fact and reporting layer
Prepare ad - hoc reports using complex business logic for the business.

Technologies: AWS Redshift, Streamsets, Wherescape Red.

Confidential

Senior Software Engineer

Responsibilities:

Requirement understanding and feasibility study
Developing effective and efficient code
Performing Unit Testing and code Reviews
Provide support to other team members on understanding different modules of the product.
Troubleshoot and fix customer reported issues.
Perform monthly data loads

Technologies: Microsoft Azure Data Warehouse, Microsoft SQL Server, SSIS, TFS.

Confidential

Software Engineer

Responsibilities:

Lead the team of ETL Developers in the UK.
Designed ETL solution for the project.
Worked on development activities.
Performed code reviews.
Worked with the product owner to analyze the NHS data for understanding the requirements.

Technologies: Microsoft SQL Server, SSIS, SVN

Health Population Manager

Confidential

Responsibilities:

Only database support person in team in the UK.
Took over from DEV team after production release.
Did the monthly data loads, supported many enhancements, fixed user reported defects and data load issues.
Assisted Product owner and other stakeholders in analyzing data needs to add new clients.

Technologies: Microsoft SQL Server, SSIS, SVN

Confidential

Software Engineer

Responsibilities:

Requirement understanding and feasibility study.
Creating complex functions in Greenplum to load data.
Creating Datastage jobs.
Working with QA team for any clarifications required by them regarding the requirements.

Technologies: DataStage, Greenplum

Confidential

Lead Engineer

Responsibilities:

Communicate with the MS Access DB owner and BA to understand existing data and requirements for the new database.
Developed ETL packages for migrating current data and to have scheduled data load from the sources.
Migrating existing Select / Append table / Make table queries of MS Access to SQL Server SPs.
Created Solution Summary document.
Creating Data Dictionary.

Technologies: Microsoft SQL Server, SSIS, MS Access

Confidential

Lead Engineer

Responsibilities:

Requirement understanding/analysis
Development of SSRS reports.
Development of database objects related to reports.
Migration of 2005 reports to 2008.

Technologies: SSRS, Microsoft SQL Server

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship