Module Lead Resume

OBJECTIVE:

To pursue an intellectual and challenging career, which synergies conceptual skills with practical insights, required enhancing my talent with hard work and determination to grow as a highly qualified person in the field of Data warehousing.

SUMMARY:

Software professional with 8+ YRs of experience in Development, implementation and product support of applications using client server Confidential and web Confidential .
Hands on Experience in SQL server 2012,SSIS 2012, SSRS 2008, Power Pivot, Performance Point
Hands on Working in data modeling using the tool ERWIN, EA.
Handled a complete module for MIS, named Work Order and Asset Management WAM in Infosys for BESCOM DataWarehouse
Having the experience to handle/manage the team and coordinate with the client/manager

PROFESSIONAL EXPERIENCE:

Confidential

Technologies: SQL SERVER 2008R2, BIDS, SSRS 2008R2, SSIS

Responsibilities:

As a Module Lead, interacting with Onsite team and gathering the requirements for the project.
Configuring and Designing wide range of ssis packages on SQL Server Integration Services as per the client requirements.
Creating the design document for the team having details about the Database structure, Design of the solutions
Stored Procedure design for the complex brokerage requirements
Writing and reviewing the complex Stored Procedures, Functions and DDL’s .
Review the codes and check for the performance issues

Confidential, GA

Technologies: SQL SERVER 2008R2, BIDS, SSRS 2008R2,SSIS

Responsibilities:

As a Module Lead, interacting with Onsite team and gathering the requirements for the project.
Configuring and Designing wide range of reports on SQL Server Reporting Services 2008R2 as per the client requirements.
Creating the design document for the team having details about the tables, fields to be used
Automated Reports to clients using Data - driven Subscriptions on SQL Server Reporting Services.
Writing and reviewing the complex Stored Procedures, Functions and DDL’s .
Review the codes and check for the performance issues
Creating cubes using SSAS 2008 R2 based on the client requirement

Confidential

Technologies: IBM Data stage 8.5, Erwin Data Modeling tool, DB2

Responsibilities:

Requirement Analysis
Preparation of Design Diagrams, Documents
Design, and Documentation of the requirements
Data Modeling for the module Work order and Asset unit WAM
Data Mapping between the EDW tables and the input source files
Mentoring the sub ordinates to develop the ETL in accordance with Design document
Test the ETL developed, for functional and technical compliance.

Confidential

Technologies: SQL Server 2005, SSIS,SSRS 2005

Responsibilities:

The Marketing Data mart project leverages rich data from ESH Extended Stay hotels systems and processes. It provides essential marketing reporting by de duping and cleansing data and housing it in a centralized data warehouse; by defining clear roles and procedures for maintaining this data; and by enabling flexible reports through end-user reporting controls. Furthermore, a centralized Data mart ensures the data is accurate and timely and is the source for the enterprise data reporting.