Associate In Data Warehousing Resume
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