SUMMARY:

• 14+ years of experience in Business Intelligence & Data Warehousing domain.
• Experienced in design, development, implementation & support of large Enterprise Data Warehouses, Data Marts, Data Integration and Data Migration projects.
• Working in North America for over a decade (since 2004) for many large companies in different roles & responsibilities as Data Modeler, Data Analyst, Data Architect, Solution Designer, ETL Developer/Lead, Report Developer, etc.
• Extensive Data Modeling and Data Architecture experience in design and implementation of large Dimensional and Third - Normal Form (3NF) Data Models (both Logical and Physical).
• Worked on industry standard data models like Teradata’s Financial Services Logical Data Model (FSDM/ FSLDM) & Communications Logical Data Model (CDM/CLDM) and IBM’s Insurance Information Warehouse (IIW) Data Model.
• Designed and implemented end-to-end Data Warehousing solutions starting with business requirements gathering, data extraction from different data sources to loading data into target using ETL tools and final data presentation to Business with creation of Reports & Dashboards.
• Hands on experience in Data Modeling, ETL Development and BI/Report Development.
• Insurance, Banking & Financial Services, Retail, Healthcare & Telecom industry experience.
• Working experience in both Waterfall and Agile methodologies like Scrums, Sprints, Kanban, etc.
• Educational Qualification: Bachelor of Engineering Degree (Electronics/Nagpur University 2002).
• Professional Certification: Oracle Certified Associate (OCA).

TECHNICAL SKILLS

Data Modeling: ERwin and ModelMart.

Databases: Teradata, Oracle, SQL Server, etc.

Data Analysis/ Data Profiling: Trillium and other standard SQL tools.

ETL: Informatica PowerCenter, DataStage, Teradata Utilities, Shell Scripts, etc.

Job Scheduling: Autosys, Control-M, Tivoli Workload Scheduler, etc.

BI/Reporting: MicroStrategy, Tableau

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst

Responsibilities:

• Primarily responsible for the development, maintenance & support of the Enterprise Data Warehouse.
• Ensure consistency and accuracy of data loaded from source system FACETS into different subject areas of the Data Warehouse like Medical and Pharmacy Claims, Membership, Product, Billing, Provider, Network, etc.
• Collaborate with different teams like customers, vendors, business analysts and application development project teams to resolve information flow and content issues.
• Facilitate meetings with clients to gather and document new business requirements and explore potential solutions.
• Translate these requirements into conceptual Data and Process Models, prepare Business Requirements Documents, and create Source-to-Target Mapping documents.
• Participate in technical reviews of Data Models and Design Documents about any enhancements or changes being incorporated in the Data Warehouse.
• Primary Software/Tools used: Erwin, Oracle, Toad, etc.

Confidential

Senior Data Modeler

Responsibilities:

• Worked as a Data Modeler at Capital One Financial under Agile Methodology.
• Worked closely with the business, source system SMEs and other stakeholders to understand the requirements & objectives of bringing new data into the Data Warehouse environment.
• Profiled data from new sources and/or history data from legacy systems.
• Based on the business requirements and the results from data profiling, designed the Logical & Physical Data Models following Data Architecture/Data Modeling best practices and standards.
• Designed normalized 3NF Data Model for Base Layer and Dimensional Model for Presentation Layer.
• Presented data models for review and approval to a Data Model Review Committee.
• Prepared Source-to-Target Data Mapping Documents for ETL Development Team to work on.
• Maintained all Metadata in a centralized Metadata Hub (MDH).
• Assisted Business Objects & Tableau Report Developers with creation of Reports & Dashboards.
• Primary Software/Tools used: Erwin, ModelMart, Teradata, SQL Assistant, etc.

Confidential

Solution Designer

Responsibilities:

• Worked as Solution Designer for Roger’s MediaMart Data Warehouse project.
• Worked closely with business and other stakeholders to understand and define business requirements.
• Designed and implemented the MediaMart Logical and Physical Data Models following Data Architecture best practices and standards.
• Created Data Mapping and Technical Design Documents for Development Teams to work on.
• Designed ETL processes for data extraction from disparate data sources and subsequent data movement through the Landing, Staging and ODS layers to the target Data Mart.
• Implemented ETL logic for data cleansing and data accuracy/consistency checks.
• Presentation Layer was built using database views to fulfill immediate business reporting needs.
• Primary Software/Tools used: Erwin, Informatica, Oracle, Teradata, Control-M, Unix, etc.

Confidential

ETL Tech Lead

Responsibilities:

• Worked closely with Sales, Finance, Merchandising, Marketing, Campaign teams and other business stakeholders to understand and define business requirements.
• Managed ETL processes for data extraction, staging, transformation, aggregation and loading of data to data warehouse checking data consistency, cleanliness and accuracy.
• Designed solutions and processes that combine disparate data into meaningful reporting and analysis that can be easily understood by business.
• Worked with team to produce a variety of reports, graphs, summaries and presentations that convey analytic results and align with business needs.
• Managed onshore & offshore team members ensuring successful design, development, implementation and support/maintenance of Enterprise Data Warehousing Projects.
• Involved in Project Planning, Revenue Forecasting, Resource Planning & other Management activities.
• Primary Software/Tools used: Teradata, Aster Discovery Platform, MicroStrategy, SQL Server, Unix.

Confidential

Data Architect

Responsibilities:

• Worked for Business Analytics at Michaels (BAAM) BI group as Data Architect.
• Analyzed Project requirements and developed technical designs & specifications in accordance.
• Ensured proper data mapping and data movement from Source to the Target.
• Determined how to best implement specific Data Architecture best practices with client’s specific environment and requirements.
• Addressed data-related problems in regards to systems integration and data flow.
• Analyzed legacy applications and prepared road-maps for integration or migration.
• Designed schema, application and configuration objects in MicroStrategy to support end-user reporting.
• Developed Reports and Dashboards in MicroStrategy based on specific business needs.
• Provided reporting status of technical design deliverables & issues to Project Managers and Business.
• Primary Software/Tools used: IBM InfoSphere DataStage, MicroStrategy, Netezza, Oracle, etc.

Confidential

ETL Developer

Responsibilities:

• Worked as ETL Developer in Confidential MDW 2.0 Project.
• Involved in the enhancement, support and maintenance of the Kaiser Membership Data Warehouse environment.
• Worked closely with the business users to understand new requirements and implemented the same through redesign of existing architecture and processes.
• Ensured proper functioning of the Data Warehouse end to end including Production Support.
• Developed and suggested new strategies for maintenance and improvement of exiting processes.
• Reviewed, diagnosed and resolved issues pertaining to the Data Warehouse operation.
• Worked towards implementation of information management best practices (such as defining policies for data archival, master data management, and metadata management).
• Primary Software/Tools used: Informatica Powercenter, Oracle, etc.

Confidential

Senior Data Analyst

Responsibilities:

• Worked as a Data Analyst at Humana for the Service Fund Datamart Project.
• Worked closely with business stakeholders and source teams to understand new requirements.
• Performed extensive Data Profiling & Data Analysis on source data before bringing it into the Datamart.
• Prepared Business Requirements Documents/Functional Design Documents based on findings.
• Prepared Source-to-Target Mappings with Transformation Logic as well as the High Level Technical Design Documents.
• Ensured proper functioning of the Datamart through analysis, testing and quality control procedures.
• Maintained ETL metadata and documentation of all business rules and processes.
• Worked with Offshore Development Team and assisted them as needed.

Confidential

Data Modeler/ ETL Tech Lead

Responsibilities:

• Worked on the overall architectural design and development of the Enterprise ODS and EDW.
• Based on business/functional requirements, designed Logical and Physical Data Models (both normalized and dimensional models) using Erwin as data modeling tool.
• Created Source-to-Target Mappings Documents & designed & developed ETL jobs using Informatica.
• Ensured proper functioning of the data warehouse through analysis, testing and regular quality control processes like cross validation of claims and membership data with the Source Systems.
• Involved in coding, debugging & troubleshooting of the Informatica mappings, sessions, and workflows.
• Followed data modeling and data quality standards and best practices during design and development.
• Involved in end-to-end implementation of full life cycle of the projects.
• Assigned work/coordinated with Offshore Development Team and assisted them as needed.
• Primary Software/Tools used: Erwin, Informatica Powercenter, Oracle, etc.

Confidential

Data Modeler

Responsibilities:

• Redesigned the existing Hartford Commercial Lines Data Warehouse environment.
• Implemented the Enterprise Data Warehouse Bus Matrix with conformed dimensions and facts.
• Worked on building the new ETL Architecture Framework using IIW (normalized data structures) in the atomic layer and dimensional Datamarts for presentation layer.
• Focused on enterprise-wide data modeling & database design that can function across business units.
• Performed extensive data modeling, data mapping & data analysis to build the Enterprise Data Model.
• Ensured adherence to company’s data architectural guidelines, principles and standards in all project milestones and deliverables.
• Primary Software/Tools used: Erwin, Trillium, Oracle, etc.

Confidential

Data Modeler

Responsibilities:

• Designed and implemented the Enterprise Data Warehousing solution for Citi-REL using Teradata Financial Services Logical Data Model (FSLDM).
• Performed extensive customization of the industry standard Data Model (FSDM) to retrofit it to the organization’s business requirements.
• Analyzed and consolidated business requirements from across teams and multiple data sources to design a common data model for the Real Estate Lending line of business.
• Stringently followed Data Architecture and Data Modeling best practices and standards like object naming conventions, data quality checks, data standardization, data archival strategies, etc.
• Reviewed Data Models with the Review Committee for their final approval.
• Managed and maintained the metadata repository containing all object definitions, business rules, source-to-target mapping logic and data transformation rules, data lineage, etc.
• Worked as an onshore tech lead handling an offshore team of developers.
• Supported developers in ETL design and documentation of data flows and interfaces.
• Worked with Report Developers in creation of Cognos Cubes, Reports and Dashboards.
• Developed partitioning and indexing strategies for performance improvement of Reports.
• Performed volumetric analysis for storage and capacity planning.
• Primary Software/Tools used: Erwin, ModelMart, Oracle, Teradata, etc.

Confidential

Data Analyst

Responsibilities:

• Worked as Data Analyst for the Enterprise Data Warehouse (EDW) Implementation Project for Confidential Services at California and Kolkata, India.
• Performed source system analysis and data profiling to identify and highlight data issues.
• Analyzed business requirements and translated them into detailed design documents.
• Prepared SQL Scripts for creation of Database Objects and Schema development.
• Developed new and enhanced existing source-to-target mapping logic and transformation rules.
• Worked on metadata management involving data & object definitions, transformation & validation rules.
• Collaborated with application owners/stakeholders to address any data quality concerns or issues.
• Primary Software/Tools used: Oracle, SQL Developer, TOAD, etc.

Confidential

ETL Developer

Responsibilities:

• Worked as Developer with some shared responsibility of Development DBA.
• Participated in requirement gathering meetings with Business Analysts and ETL Architects to understand the technical requirements.
• Developed ETL jobs for movement of data from the operational and external environments to the data warehouse environment, using Informatica as ETL Tool.
• Created database objects such as tables, views, indexes, constraints and table partitions in Development and QA regions.
• Performed Unit Testing and System Integration Testing to troubleshoot and resolve any Development defects or issues.

………………………………………………………………………………………….……………………