OBJECTIVE:

To become a successful professional in the field of Information Technology and work in an innovative and competitive environment. To further improve my technical knowledge through experiences.

SUMMARY:

• 8+ Years of experience in Data warehousing, MDM, BI, .Net, VB and VBA.
• Design and Implement end to end BI Solution across all verticals.
• Extensive work experience in Data warehousing concepts, MS SQL, SSIS, SSRS, SSAS, Qlikview Informatica, Oracle 9i&10i, Excel VBA, VB 6.0, .Net 2005, Excel Pivot
• Good Knowledge in Business intelligence projects involving Design, Development and Testing of Data Warehouse/Marts.
• Strong knowledge in the Data Modeling and Data analyzing in MS SQL Server and good knowledge in query optimization also.
• Has Experience in MDM. Data cleansing, Parsing, and finding Duplicates.
• Good Domain Knowledge in Healthcare, Purchase, Sales, Real Estate Solution, Receivable & Payable Management and Production
• Extensively involved in Extract, Transform and Load raw data into tables as part of Data Warehouse development using Informatica, SSIS, Confidential Tool
• Strong Experience in developing Reports using Microsoft Reporting Services, Confidential DW and IReports
• Strong experience in creating cubes based on user requirements by SSAS 2005 & 2008 and writes MDX queries for reporting and calculated measures.
• Done several presales activities and give direct demo to customers.
• Develop application in Dot net and Customize Confidential Products.
• Worked more than 1 year in client place and Managed to successfully handle pressures, to meet deadlines ands satisfy the Clients requirements.
• Good in analytical and problem solving skills.
• Highly self motivated, Excellent Communication and interpersonal skills.

TECHNICAL SKILLS:

Database: MS SQL 2000, 2005, Oracle 9i, PL\SQL

ETL Tools: BI, SSIS, Informatica 7.1

OLAP Reporting Tools: RDW,Crystal Reports, SSRS, SSAS, BO,Cognos 8.5,Precision BI

Dev. Tools: VB.NET,ASP.NET, VB 6.0

Programming Language: C,C ++,Java, XML

Web Technologies: Html, Dhtml, ASP, VB & Java Scripts.

Multimedia Tools: Photoshop, CorelDraw, Swish

Verticals: Cement, Banking, Construction, Retail

PROFESSIONAL EXPERIENCE:

Confidential

Associate in Data Warehousing

Responsibilities:

• Analysis user requirement and create Data Warehouse and Data marts
• Involved in the development of Hedis Reporting as a product.
• Expert in Data Modeling and Dimensional Modeling.
• Creating SSIS Package and Performance tuning in the existing package.
• Creating complex Reports using Precision BI and SSRS.
• Creating Cubes and KPI using SSAS.
• Doing L2 Support for ETL Packages.
• Creating complex reports in Cognos 8.5

Environment: MS SQL Server 2000, 05 & 08,SSIS, SSAS 2000, 05 & 08, SSRS 2005 & 08, Oracle 8i&9i, Cognos 8.5, Informatica, Precision BI and Qlikview.

Confidential

Analyst Programmer in Data Warehousing

Responsibilities:

• Analysis user requirement and create Data Warehouse and Data marts
• Implementation of end - to-end BI Solution across all verticals.
• Expert in Master Data Analysis and Provide MDM Solution.
• Create Packages using SSIS, Confidential BI to extract data from different Servers and transform and load into MS SQL.
• Create Cubes using SSAS and Write MDX Queries to get results.
• Create various Kinds of reports like list, cross tab, AR, ER and Sub Reports using IReports, SSRS, Confidential DW.

Environment: MS SQL Server 2000 & 2005,SSIS, SSAS 2000 & 2005, SSRS 2005, Confidential BI, Confidential DW, Confidential MDM, I Reports, Oracle 8i&9i, PL/SQL

Confidential

Environment: MS SQL 2008, SSIS, SSRS, C#.Net, Qlikview

Team Lead

Responsibilities:

• Worked as an architect in new Data Modeling, ETL Packages and Reports.
• Converting Existing SSRS Reports to Qlikview.
• Enhanced existing Qlikview Reports.
• Creating new reports in Qlikview.
• Involved in the design and development of Enterprise warehouse.
• Also Create SSIS Packages and extract data from different Servers
• Coordinating with Client for issues related to Production Support and provides warning to avoid a possible outages or system slowdown.
• Optimizing the performance of the Query and execution time of Stored Procedures and ETL Packages.
• Successfully Handle 20 member offshore team.

Confidential

Environment: MS SQL 2008, SSIS, SSRS, C#.Net2008, Precision BI,Informatica

Team Lead

Responsibilities:

• Worked as an architect in new Data Modeling, ETL Packages and Reports.
• Involved in the new version change of EEHR Analytics Product.
• Responsible for analyze the user requirements and change the existing packages, Reports and Data Model.
• Extract data from different source and made cleaning and processing and finally load in warehouse
• Gave L2 Support for SSIS Package and Precision BI.
• Involve UAT with customer and do the changes effectively in time.
• Involved in improving the performance of reports, stored procedures and ETL packages.
• Involved in the requirement analysis of the new proposed solution and transform that into technical design document and coordinates with the offshore team for the development activities

Confidential

Environment: MS SQL 2005, SSIS, SSRS, Qlikview

Team Lead

Responsibilities:

• Translation of business requirements into technical specifications.
• Creation of Data Model for HEDIS Reporting.
• Creation of ETL and Report Design Document for the solution definition document.
• Development of Stored Procedures based on report logic.
• Development of SSIS Packages based on ETL design document.
• Development of SSRS Reports for NCQA Measure Format.
• Handled a six member team for ETL and Reporting.
• Unit test case preparation and execution
• Optimizing the performance of the Query and execution time of Stored Procedures and ETL Packages.

Confidential

Environment: MS SQL 2005, Confidential DW, Confidential BI, SSAS,SSIS, SSRS, VB.Net 2005, ASP

Team Lead

Responsibilities:

• Responsible for analyze the source data and creating reports in Purchase, Production, Real estate and Sales Modules
• Extract data from different source and made cleaning and processing and finally load in warehouse
• Also Create SSIS Packages and extract data from different Servers
• Create Cubes & partition it and MDX Query based on user requirement.
• Create Analytical, Enterprise and Excel Reports.
• Customize the Confidential product according to the user requirement.
• Develop Complex reports - Cross Tab and Dynamic.
• Handled the customers after post installation and UAT for 3 months.
• Create Tool in .Net 2005 to back up and restore the product and cubes when crash or shipment in the live server.
• Involve UAT with customer and do the changes effectively in time.
• 3 Months post installation support in the client place (Delhi, Gurgoan)

Confidential

Environment: MS SQL 2005, Confidential DW, Confidential BISSIS, SSAS,ASP

Developer

Responsibilities:

• Extract data from different source and made cleaning and processing and finally load in warehouse
• Also Create SSIS Packages and extract data from different Servers
• Create Data Marts for the user requirement
• Onsite Customer support. - Involved in taking requirements from Business users and design to meet the customer requirements.

Confidential

Environment: MS SQL 2005, Confidential DW, Confidential MDM,SSIS

Team Lead

Responsibilities:

• Integrated with ERP, to maintain the master data information
• Responsible for Creating Business Policy to ensure the data integrity.
• Analyze the master data created by customer and strengthen the rules.
• Create Transformation for standardize the data and finding duplicates.
• Create SSIS Package for Fuzzy lookup and Fuzzy grouping Transformation
• Responsible for Developing MDM Analytical Reports.
• Customize the product according to the user requirement.

Confidential

Environment: MS SQL 2005, Confidential DW, BI, MDM, SSIS

Team Lead

Responsibilities:

• Design the entire logic for how to parse the master data.
• Using regular expression for parse the data.
• Responsible for Creating Business Policy to ensure the data integrity.
• Create Transformation for standardize and parse the data.

Confidential

Environment: SSAS,SSIS, SQL 2005, Confidential DW, Confidential BI

Module Lead

Responsibilities:

• Responsible for Creating ETL Packages using Confidential BI.
• Design the logic for the reports in Purchase and Sales module according to Business Logic
• Creating complex reports such as Enterprise, Analytical and Cross tab