PROFESSIONAL SUMMARY

• 8+ years of experience in data modeling and data analysis, production support, database management, strategic analysis, requirements gathering, application and decision support.
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERWIN and Power Designer.
• Proficient in data mart design and creation of cubes using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Well versed in Normalization / De-normalization techniques for optimum performance in relational and dimensional database environments.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experienced in developing Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like ERWIN, ER/Studio and Power Designer.
• Hands on experience with modeling using ERWIN in both forward and reverse engineering cases.
• A good familiarity and experience in the work environment consisting of Business analysts, Production/ Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Experienced with DDL and DML including Joins, Functions, Indexes, Views, Constraints, Primary Keys and Foreign Keys.
• Extensive experience in Data warehouse loads, determining hierarchies, building various logics to handle Slowly Changing Dimensions.
• Expertise in working with business users as part of requirements gathering and converting them into technical solution.
• Good knowledge in the SDLC process having worked in Waterfall as well as Agile RUP and SCRUM environments.
• Hands-on experience with MMIS, ACA, HIX, HIPAA, and HL7 processes.
• Expertise in designing the data warehouse using Ralph Kimball's and Bill Inmon techniques.
• Developed processes to support the ERP system with SSIS, SQL Stored procedures.
• Developed custom dashboards/reports using Tableau.
• Expertise in Normalization techniques for data consistency and Flexible Database design.
• Expertise database normalization method defined by E.F CODD (3NF-Third Normal Form)
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relational data modeling.
• Designed the PL/SQL procedures for getting the data from all systems to Data Warehousing system.
• Experienced in Data transformation and Data mapping from source to target database schemas and also data cleansing.
• Excellent understanding and exposure to SQL queries and PL/SQL stored procedures, triggers, functions and packages.

TECHNICAL SKILLS:

Frame work and methodologies: Data Modeling (ER & Dimensional), Database Design, Requirement Analysis, ETL Design, Object Oriented Design, Development, Testing, Data Mapping, Metadata Management, Master Data Management, Data Profiling, Deployment, Documentation, Project Management.

Data Modeling Tools: Erwin r7.1/7.2, Erwin 8.x/9.x, ERStudio 9.x, Power Designer Embarcadero ER/Studio, Oracle Designer, Sybase, Power Designer.

Reporting Tools: Cognos 8 / 10, Oracle Reports, Tableau, Business Objects, IDQ.

Other Tools: SQL Navigator, TOAD, Informatica Power Center, Teradata SQL Assistant, SAS Enterprise Guide, SAP ECC and Panorama Web Service

Databases: Oracle7/8i/9i/10g/11g, SQL Server2000/2005/2008/2012, Sybase, Teradata, DB2.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr. Data Modeler / Data Analyst

Responsibilities:

• Created logical data model from the conceptual model and it's conversion into the physical database design using ERWIN.
• Mapped business needs/requirements to subject area model and to logical enterprise model.
• Worked with DBA's to create a best fit physical data model from the logical data model.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Developed the data warehouse model (star schema) for the proposed central model for the project.
• Created the conceptual model for the EDW (Enterprise Data Warehouse) and get it reviewed by business users.
• Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
• Reviewed of client documentation within the business units and ensured information is consistent with BSA/AML Policy and Procedures and satisfies regulatory requirements.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using ERWIN tool.
• Created data structure to store the dimensions in an effective way to retrieve, delete and insert the data.
• Prepared data migration plans including migration risk, milestones, quality and business sign-off details.
• Worked on Metadata exchange among various proprietary systems using XML.
• Involved in the part of production team and worked on the issues in ETL to make some changes while loading the database.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Created high level ETL design document and assisted ETL developers in the detail design and development of ETL maps using Informatica.
• Responsible for creating the staging tables and source to target mapping documents for the ETL process.
• Involved in writing queries and stored procedures using MySQL and SQL Server.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Helped in migration and conversion of data from the Sybase database into Oracle database, preparing mapping documents and developing partial SQL scripts as required.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Used ERWIN for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Participated in performance management and tuning for stored procedures, tables and database servers.

Environment: Windows 7, Teradata 14, Teradata SQL Assistant. ERWIN r9.2, SQL server 2012/2014, Business Objects XI, MS Excel 2010, Informatica 7.3

Confidential, Indianapolis, IN

Data Modeler / Data Analyst

Responsibilities:

• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
• Created Logical and Physical models by using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Understood the AML compliance requirements by interacting with compliance department and SME experts in the laws/act of compliances.
• Created Stored Procedure, Trigger for database access and events.
• Designing data models for development of a data warehouse and data marts.
• Developed the Teradata stored procedures and scripts based on the technical design documents and implemented the ETL logic as per the design specifications.
• Responsible for all aspects of strategic analysis and tactical operations associated with allocation of Commercial resources, including sales, marketing, and business development programs.
• Primary duties included reviewing and analyzing pharmacy benefit plans and reported findings to benefit design team for certification and/or further evaluation.
• Developed a customized macro to automate the formatting of routine daily reports, thereby saving a collective 5+ hours each week on the reporting running process.
• Maintained personal patient information and followed all HIPAA regulations.
• Proficient in Creating, Configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler and Database Engine Tuning advisor.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Responsible for defining the naming standards for data warehouse.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Developed ETL System using SSIS and Stored Procedures to migrate Staging data to an Operational Data Store and finally to a Data.
• Good experience with Teradata.
• Participated in data anomaly resolution, data cleansing and development of cleansing rules for ongoing data synchronization.
• Conducted impact analysis for changing business requirements as per user needs.
• Analyzed existing insurance application versions along with design and technical teams to create Gap Analysis Documents.
• Studied in-house requirements for the Data warehouse to be developed.
• Participated in performance management and tuning for stored procedures, tables and database servers.
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation phase.
• Developed necessary support documentation for end users, operations and testing teams.

Environment: Teradata 14, ERWIN 9.1, SQL, Teradata SQL Assistant, Informatica 8.6, Adobe Reader, MS Office, MS Access, DB2.

Confidential, Los Angeles, C

Data Modeler / Data Analyst

Responsibilities:

• Data Analysis, logical and physical Data Modeling for OLAP systems.
• ER Modeling - Developing Entity Relationship Diagrams (ERD).
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Experienced with MMIS, ACA, HIX, HIPAA, and HL7 processes.
• Implemented and maintaining DR strategy for BCP-DRP (Business Continuity Plan - Disaster Recovery Plan).
• Effectively coordinated patient's care by working closely with other departments including BV, Adjudication, Nursing, Billing and Pharmacy.
• Received and coordinated various information; calls, faxes, etc., properly and according to hospital procedure and in compliance with HIPAA laws and regulations.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Design & Implementation of Data Mart, DBA coordination, DDL & DML Generation & usage.
• Played key role in defining all aspects of Data Governance - data architecture, data security, master data management, data archival & purging and metadata.
• Metadata & Data Dictionary Management, Data Profiling, Data Mapping.
• Normalization techniques to arrive at effective Relational Schemas.
• Applied Data Governance rules (primary qualifier, Class words and valid abbreviation in Table name and Column names).
• Involved incapturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• Maintained and documented all create and alter SQL statements for all release.
• Designing Data Flows & System Interfaces.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Documenting using Interface Diagrams, Flow Charts & Specification Documents.

Environment: Teradata V2R6, ERWIN 8.0, SQL, Business Objects, MS Office, MS Access, Oracle 11g.

Confidential, Hampstead, NC

Data Modeler / Data Analyst

Responsibilities:

• Actively involved in the Design and development of the Star schema data model.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Involved in understanding Logical and Physical Datamodel using Erwin Tool.
• Analysis of functional and non-functional categorized data elements for dataprofiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Excellent acknowledge of Banking and Regulatory Compliance, Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP) and Fixed Income Clearing Corporation (FICC) compliance rules.
• Designed the database in Teradata and worked with Data Architect to implement it in the data model.
• Extensively performed Data Profiling, Data Cleansing, De-duplicating the data and has a good knowledge on best practices.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail & Pivot reports.
• Implemented very advanced and complex queries in DDL and DML involving Joins, Sub queries. Alter Table etc.
• Active involvement in Optimization Process through database capacity planning, creation of materialized views, partitions, tables, views, indexes as tuned and optimized SQL statements.
• Prepared complex T-SQL queries, views and stored procedures to load data into staging area.
• Created T-SQL stored procedures to improve the performance of aggregate queries dynamically.
• Designed and Developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Extensively worked on the ETL mapping, source data analysis, source to target mapping and documentation of OLAP reports requirements.
• Worked with Tableau Report Writers to test, validate data integrity of reports.
• Used Power BI to design interactive reports and data visualization.
• Worked in AGILE software development methodology.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.

Environment: Teradata 13, Microsoft SQL Server 2012, Agile, SQL Manager, Erwin 8.0, Informatica, Tableau, Teradata SQL Assistant

Confidential, Torrance, CA

Data Analyst

Responsibilities:

• Performed Logical & Physical Data Modeling - ER Modeling & Dimensional Modeling.
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Worked with data compliance teams, Data governance team to maintain data models, Metadata, Data Dictionaries; define source fields and its definitions.
• Worked in an agile development environment.
• Participate in biweekly technical huddle meeting with development and DBA team. Participate in weekly data analyst meting and submit weekly data governance status.
• Rapid Audit of the requirements and existing systems; Requirements & Business Process Analysis.
• Design & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
• Created artifacts such as Use Cases, Prototypes, and Business Flows and Work Flow diagrams for effective plans.
• Convert models from CA Erwin to ER/Studio 7.5 (ERStudio), developed numerous macros.
• Compiles and maintains the Enterprise Schema across all applications. Enforces principles of good canonical data design.
• Implemented very advanced and complex queries in DDL and DML involving Joins, Sub queries. Alter Table etc.
• Effectively created Data Dictionaries, XML mapping spreadsheets for interface requirements based on design solution.
• Worked as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.
• Worked on Forward Engineering to enhance the Data Structures of the Existing Database and Creating New Schemas.
• Created and implemented Semantic Data Models.

Environment: Oracle 11g/ 10g, Toad, Business Objects, Informatica, IDQ, Embarcadero ER/Studio 7.5 (ER Studio).

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Created a logical design and physical design in Erwin.
• Created Entity/Relationship Diagrams, grouped and created the tables, validated the data, identified PKs for lookup tables.
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Developed internal auxiliary web apps using Python Flask framework with CSS / HTML framework.
• Sound Knowledge on RDBMS concepts and extensively worked with Oracle, SQL Server 2008, MYSQL.
• Developed SQL Queries, Stored Procedures, and Triggers Using Oracle, SQL, PL/SQL.
• Developed SQL scripts involving complex joins for reporting purposes.
• Fine Tuned (performance tuning) SQL queries and PL/SQL blocks for the maximum efficiency and fast response using Oracle Hints.
• Performed Normalization, Indexes Tuned and Optimized the existing database design.
• Maintained data mapping information and documented properly.
• Worked extensively with XML schema generation.
• Extensively used Erwin for developing data model using star schema methodologies.
• Created Unix Shell Scripts for automating the execution process.

Environment: PL/SQL, Oracle, MS-Excel, MS-Word, SQL Server 2008, ERWIN data modeler 7.2.