SUMMARY

• Data modeling experience for Enterprise Data Warehouse Implementations utilizing Ralph Kimball Star Schema Dimensional Modeling methodology/ Bill Inmon Relational Modeling methodology.
• Specialization in Erwin 9.5.2.
• Retail/Insurance Domain Experience working on complete Oracle Retail Suite (Retail Merchandizing Analytics) with data feed and integration from sources like ReSA (Retail Sales Audited), SOMA (Supply Order Management), RMS PISL
• 11 years of Experience in Data Analysis, Data Modeling, Data Warehouse and Business intelligence.
• Experience in leading design sessions with Data Architecture, Application Development and business teams.
• Implementations in the Industry Domains of Retail, Insurance, Banking, Telecom, Energy & Utilities and Media & Advertising.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like Erwin, IBM Info sphere and Good Data.
• Experienced in all phases of the software development life cycle (SDLC), from requirements through implementation and support.
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables including Physical, Logical data modeling.
• Extensive experience in implementing slowly changing dimensions.
• Experienced in Data Conversion, Data Quality, Data Profiling, Performance Tuning and end - user support.
• Expertise in writing complex SQL queries to perform end-to-end ETL, validations and supporting ad-hoc business requests.
• Experienced with Business Process Modeling, Process Flow Modeling and Data flow modeling.
• Expertise in implementing security models (LDAP/HR) for Dashboards, Row level, object Level, Role Level, and Dashboard Level.
• Excellent experience in Normalization and De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snow flake schema used in relational, dimensional and multidimensional modeling.
• Excellent experience in Extract, Transfer and Load process using ETL tools like Oracle Data Integrator, Informatica, for Data Warehousing projects and Oracle Customer Care and Billing for Data migration projects.
• Experienced in the development of Data Warehouse, Business Intelligence architecture that involves data integration and the conversion of data from multiple sources and platforms.
• Expertise in Data Analysis using SQL on Oracle, MS SQL Server, DB2 and Teradata.
• Experienced in writing, testing and implementing SQL, Stored Procedures, Materialized Views, Triggers and Functions.
• Excellent experience in trouble shooting SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Experience in automating privilege grants through UNIX scripts.

TECHNICAL SKILLS

• ERWIN 9.5.2.
• IBM Rational Data Architect 2.0
• Good Data (Cloud) Designer
• Teradata 15
• SQL Server 2008/12
• Oracle 12c
• ORMA (Oracle Retail Merchandizing Analytics)
• ORMS (Oracle Retail Merchandizing Systems)
• ReSA (Retail Sales Audit)
• Personal Insurance certified (CPCU)
• Property & Liability Insurance certified (CPCU)
• Teradata V2R5 SQL Specialist certified.
• Mainframe z/os Programmed ETL
• Clover ETL Programming
• Oracle Data Integrator
• UNIX

PROFESSIONAL EXPERIENCE

Confidential

BI Data Modeler

Responsibilities:

• Lead design workshops and liaise with Enterprise Architects/ Application Development and Business Teams.
• Design/maintain BI data model.
• Integrate data flow from various source like ReSA (Sales Audit)/ RPAS (Pricing Module)/ RMS PISL (Perpetual Inventory and Stock Ledger)/ ADW (ecommerce business)/ SOMA (Supplier Order Management)/ POM (Purchase Order Management). Create/maintain BI data model.
• As part of EDA (Enterprise Data Architecture) team, work closely with DBA team to improve performance of Oracle Framework. Design optimal framework for better performance considering partition, index maintenance parameters.
• Participate in complex design discussions with various teams utilizing BI Warehouse capabilities.
• Single point of contact for BI data modeling needs.

Confidential

ERWIN Data Modeler

Responsibilities:

• Data Discovery - Sampling/ Functional Analysis - Data Requirements, Data Profiling - Gaps, Map to Business Rules/ Review & Validation, Overall ETL Architecture - Data Acquisition, Integration, Validation, Design/Development - Map, Extract, Transform, Format, Load Sequence Plan/Set Up - Automation, Load/Cut Over and Confidential Data Testing/ Reconciliation.
• Conduct design workshops and liaise with business leads on Data Migration Strategy.
• Data Migration Lead Activity.

Confidential

Data Modeler

Responsibilities:

• Business Requirement Analysis: Interact with Business Analysts to get the functional requirements.
• Interact with end users and find the reporting needs.
• Development of Data Model: Create standard abbreviation document for logical, physical and dimensional data models. Document the logical, physical and dimensional data models.
• Report Generation: Generate reports from the data model and validate against the sample client data.
• Review: Review the data model with functional and technical teams.
• Physical Data Model: Create SQL code from the data model and co-ordinate with DBAs to create development, testing, regression and production databases. Check to see data models and database are in sync.
• Support and Maintenance: Assist developers and end users to understand the model. Maintain change log for each data model.
• Enhance: Evaluate new techniques for enhanced functionality and design strategy for history data.
• Enable Cloud Services: Build and enable real time access and ad hoc reporting using Good Data BI.
• Create Cloud capability and provide end-end support for all issues pertaining to the reporting data.

Confidential

Data Modeler/Admin (ERWIN)

Responsibilities:

• Assist in the transition of the logical data model to a physical data model.
• Answers questions about the physical requirements of the implementation.
• Consults on patterns for loading and unloading data.
• Represents the logical data model.
• Informed of physical data design activities.
• Reviews the physical data design.
• Provides opinion to Client Data Architect if the transformation into the physical data design is correct and represents the business rules and requirements as stated in the logical model.
• Actively participates in decision-making process on aspects of the physical design that impact the logical design.
• Completes a data model QA review.
• Data Design Reviews: Liaise with Subject matter experts as part of design review including the Data Architect (DA), the DBA.
• Erwin Administration: Perform Erwin Administration activities.

Confidential

Data Modeler

Responsibilities:

• Analyze the source data coming from Genesys Info Mart.
• Design the data model based on reporting observations and source data analysis.
• Support development activity after the completion of the Physical Data Model implementation
• Support data quality and end user reporting concerns.

System Duty Analyst/Lead

Confidential

Responsibilities:

• Monitor SLA driven ETL runs on 4 different hosts along with a team of 19.
• Maintain and support data quality, where data is coming in from different ERP, Finance and other OLTP systems.
• Generate weekly/daily system metrics based on performance parameters and touch base with client/DBA
• Backing up the data on weekly basis on tapes with support of DBA.
• Cisco Month End Book Closure Activity to tally book keeping (monthly/quarterly/annually)
• CR Management/support.
• Password Management (monthly).
• End User data concerns/ad hoc queries.
• Server Space Management across all managed hosts.
• Data Management on Disaster Recovery Box (through GG/DM data replication tools).

Confidential

Senior ETL Developer

Responsibilities:

• Identify business data separation logic through discussion with SMEs.
• Convert SME provided business logic into SQL code for business data separation (JLR from Confidential ).
• Write JCLs (Mainframe Job Control Language) and standardize/schedule through CA7 scheduler.
• Identify/create test business data based on business logic.
• Trail run the data (in 3 dry run phases) and presents the results to business SME for validation.
• Consolidate the results in documented format.
• For the next dry run, consolidate results again and validate against previous runs.
• Encrypt the near actual data (flat file encryption) for the final dry (test) run.
• Perform the final cutover activity.
• Participate in functional testing/business validation process.
• Group 7 services (Marketing services) to follow the same execution model.

Confidential

ETL Developer

Responsibilities:

• Obtain business logic from functional specification/detailed design documents.
• Write the SQL code and create JCLs for job entry.
• Perform unit testing of the JCL code/SQL script.
• After unit testing, ship/handover the JCL to Job scheduler team for scheduling.
• Provide job support during scheduled job run.
• Document the results and hand-over to SIT team (System Integration Testing) for further testing.
• CR support.

Confidential

System/Functional Testing

Responsibilities:

• Discuss with business SMEs and document module understanding as functional documents.
• Based on the functional understanding, prepare functional test cases.
• Prepare execution plan for Integration testing after code migration.
• Perform functional testing/Integration testing and report any failures.
• During this project, I have gained a lot of functional understanding (completed 2 Insurance certifications).