SUMMARY:

• Over seven years of professional experience in data modeling, designing, and data analysis with Conceptual, Logical, and Physical modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Extensive experience in teh Data Warehousing implementations for Retail, Financial, Insurance and Banking Industries
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin 7.0/4/0, Power Designer, Embarcadero E - R Studio and Microsoft Visio.
• Experience and skills in Behavior Modeling, Predictive Modeling for Insurance.
• Experience working on creating models for Teradata master data management.
• Experience in handling business and technical issues & communicating with both business users and technical users.
• Experience working on Kettle scripting/ Pentaho for loading data to RDBMS, Graphical manipulation of data and processing data retrieved from multiple sources and pushed to multiple destinations
• Strong understanding of dimensional and relational modeling techniques. well versed in Normalization / De-normalization techniques for optimum performance in relational and dimensional database environments
• Experience with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration
• Experience in developing transactional enterprise data models which meet teh normalization rules strictly and understanding of enterprise data warehouses by using Ralph Kimball Data warehouse methodologies.
• Involved in implementing teh Referential Integrity by using Primary and Foreign key relationships
• Good Knowledge in designing teh data marts using Ralph Kimball's and Bill Inmon Dimensional Data Mart Modeling techniques.
• Installation of Informatica patches and upgrades, user access management, deployment activities, on-call support and capacity planning.
• Good experience in building reports with Business Objects XI 2/XI3 and Tableau desktop.
• Experience in developing ETL process for Data warehousing using ETL tool Informatica.
• Well versed with teh concepts of Forward Engineering and Reverse Engineering for teh existing databases for teh Conceptual and Logical/Physical models using Erwin tool
• Involved in implementing teh Referential Integrity by using Primary and Foreign key relationships
• Good Knowledge in designing teh data marts using Ralph Kimball's and Bill Inmon Dimensional Data Mart Modeling techniques.
• Identified Slowly Changing Dimensions, Role Playing Dimensions and Hierarchies in dimensions.
• Good Knowledge on SQL queries and creating database objects like stored procedures, triggers, packages and functions using SQL and PL/SQL for implementing teh business techniques.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD/JAR sessions
• Quick learner, self-motivating and enthusiastic to work with new technologies. Good team player and have strong ability to work under high stress environments.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in teh technology arena

TECHNICAL SKILLS:

Data Modeling Tools: Informatica Power Center 8.x/7.x/6/x, Erwin Data Modeler 7.0, Data Governance, Rational Rose 2000, ER Studio, Tableau, Power Designer, MS Visio

Reporting Tools: Oracle Reports, Business Objects, Crystal Reports 2008

Databases: Oracle7/8i/9i/10g/11g, MS SQL Server2000/2005, MS Access, Teradata, DB2, Teradata, Hadoop

Operating Systems: Windows NT, 2000 & XP, Vista, UNIX

Languages: SQL, PL/SQL, T-SQL, HTML, C, C++, XML, Visual Basic, Java

Others: MS Office, TOAD, SQL Navigator

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. Data Modeler

Responsibilities:

• Working as a Data Modeler as part of IDW project under Agile DevOps Methodology.
• Interacting with Business Analysts to get teh functional reporting requirements and Interacting with End users to find out teh reporting needs.
• Involved in sessions with Clients in finalization of teh Business Requirements.
• Understand teh requirement thoroughly and finalize teh reporting attributes.
• Conducted one-to-one sessions with Source SME to gather Source Mapping for teh reporting attributes.
• Identify Source systems, set up access to teh systems and document source application coverage’s.
• Performed Data Profiling on teh attributes which helps in reducing teh project risk by identifying data quality issues that must be handled in teh code that moves data from teh legacy system to teh Target(new)system and identifying data issues that may require a change to teh Target(new) system.
• Have done Data Mapping to Identify teh Subject Area, Target table name and Target Column name to which teh Source attribute should fall under.
• Configure model design tool (Power Designer), metadata repository (Informatica Meta Manager), and analytical/reporting tool (Business Object) and set up Environment.
• Developed a Conceptual model using Power Designer based on requirement analysis.
• Created Logical and physical data models using best practices to ensure high data quality and reduced redundancy with teh IDW Standards and Guidelines.
• Generated DDL Scripts in HIVE and TD using teh Model design tool (Power Designer) for teh core tables.
• Developed Views private and public views with masking technique for sensitive attributes and Tokenization to ensure consistency.
• Conducted Internal Review sessions with Architect team and external review sessions with Business Team and take sign off.
• Updated teh Data Dictionary with Reporting Attributes, business description of teh attribute, Source Mapping and Target Mapping.
• Using Agile Central (Rally) to enter tasks and associated hours for each task.
• Using GitHub and Accurev to actively manage and promote DDLs
• Working with different source systems like RPX, Samson, Chub, Ericsson etc.

Environment: Power Designer 16.5, Oracle SQL Developer, Microsoft SQL Server 2008, Hue, Teradata SQL Assistant, Jira, Confluence, AccuRev.

Confidential, Pleasanton, CA

Sr. Data Modeler

Responsibilities:

• Worked with Business Analysts team in requirements gathering and in preparing functional specifications and translating them to technical specifications.
• Extensively involved in developing logical and physical data models that fit in exactly for teh current state and teh future state data elements and data flows using Erwin
• In order to document business names and descriptions for tables and columns, relationships among datasets and data types, business rules and domains used ER/Studio.
• Using Kettle Scripting/ Pentaho processed data from one table and replaced some values, filtered some values and also syncing two data sources.
• Utilized existing Informatica, Teradata, and Sql Server to deliver work and fix production issues on time in fast paced environment.
• Defined teh key columns for teh Dimension and Fact tables of both teh Warehouse and Data Mart.
• Interacted with teh End users frequently and transferred teh noledge to them.
• Conducted and participated JAD sessions with teh Project managers, Business Analysis Team, Finance and Development teams to gather, analyze and document teh Business and reporting requirements.
• Worked with Model Manager and multiple data marts, involving multiple Subject Areas simultaneously, domains and Naming Standards.
• Conduct Design discussions and meetings to come out with teh appropriate Data Mart at teh lowest level of grain for each of teh Dimensions involved
• Designed a STAR schema for teh detailed data marts and Plan data marts involving shared dimensions (Conformed).
• Worked on Infomatica Data Quality to resolve customers address related issues.
• Created and maintained Logical Data Model (LDM) for teh project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated teh appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Conduct Design reviews with teh business analysts and content developers to create a proof of concept for teh reports.
• Ensured teh feasibility of teh logical and physical design models.
• Collaborated with teh Reporting Team to design Monthly Summary Level Cubes to support teh further aggregated level of detailed reports.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during teh project.
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring teh warehouse data integrity checks and shell scripts to balance teh data between source and target tables after each ETL process
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating with various teams to decide on teh appropriate action to be taken.
• In order to generate efficient security solutions based on event correlation, logical reasoning and data visualization used SIEM technology.
• Maintain change log and history tables for each data model and solved teh production issues by debugging teh code.
• Performed Data Validation and Unit Testing before handing over teh data for production and Quality Testing.

Environment: Informatica Power Center 8.x/7.x/6/x, Oracle 10g, PL/SQL, Erwin 7.2, ER/Studio, Microsoft Excel, MS Word, SIEM Technology, Power Point, TOAD for Oracle Version 8.6.0.38, and SQL developer for Oracle

Confidential . Somerset, NJ

Data Analyst

Responsibilities:

• Responsible for project management, logical and physical OLTP database and data warehouse modeling, ETL mappings, data analysis and integration, XML schemas, and functional and technical specifications
• Implemented and maintaining DR strategy for BCP-DRP (Business Continuity Plan - Disaster Recovery Plan)
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy
• Optimized and updated logical and physical data models to support new and existing projects
• Designed XML layouts and data movement strategies in compliant to ACORD standards
• Implemented Referential Integrity using primary key and foreign key relationships
• Maintained conceptual, logical, and physical data models along with corresponding metadata
• Created Mappings for Type2 and slowly changing dimensions for updating and inserting of records and in turn maintaining history
• Worked with ER/Studio to create business glossaries with consistent terms and to definitions to ensure that data models and databases are aligned to an organizational usage.
• Maintained high-level data architecture documentation, which illustrates teh source and destination of data to and /or from approved data sources
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models
• Recommended opportunities for reuse of data models in new environments
• Performed reverse engineering of physical data models from databases and SQL scripts
• Evaluated data models and physical databases for variances and discrepancies
• Involved in logical and physical database designs and data mappings between cross functional application and used SQL queries to filter data.
• Performed Data Analysis for building teh reports and building Enterprise Data warehouse(EDW)
• Defined timelines for project delivery and provided teh status update to teh client team on a regular basis
• Created entity/process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams
• Interacted with ETL developers for making them understand teh movement of required data
• Assisted with project and problem analysis, TEMPeffectively communicated with management and adhered to firms policies and procedures

Environment: Erwin 7.2, ER/Studio, SQL Server 2008, DB2, Microsoft Access, SQL Server 2000, MS PowerPoint, MS Access, Lotus Notes, Microsoft Excel

Confidential, New York, NY

Data Modeler

Responsibilities:

• Documented logical, physical, relational and dimensional data models. Designed teh Data Marts in dimensional data modeling using star and snowflake schemas
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during teh project
• Coordinated with DBA on data base build and table normalizations and de-normalizations
• Understanding clients’ information needs, business objectives, and market sectors and implementing appropriate data analysis strategies
• Recognized and extracted critical indicators from large and complex data sets and interpreted and expressed those indicators in teh business context
• Designed and maintained processes for measurement, tracking, reporting, and analyzing traffic and user experience
• Maintained teh quality of data analysis, researched output and reporting, and ensured that all deliverables met specified requirements
• Communicated directly with clients to clarify requirements and present research findings and ensured clients received coherent service
• Developed SQL and PL/SQL scripts to perform data cleansing and PL/SQL procedures to populate date and time dimensions
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring teh warehouse data integrity checks and shell scripts to balance teh data between source and target tables after each ETL process
• Created mapping specification spreadsheets to document teh transformation logic
• Worked with Model Manager and multiple data marts, involving multiple subject areas simultaneously, domains and Naming Standards
• Conducted and participated in JAD sessions with teh project managers, business analysis team, finance and development teams to gather, analyze, and document teh business and reporting requirements

Environment: Oracle 9i/10g, MS SQL Server, DB2, Oracle SQL Developer, PL/SQL, Business Objects, Erwin, MS office suite

Confidential

Data Analyst/Developer

Responsibilities:

• Analyzed teh business requirements of teh project by studying teh Business Requirement Specification document.
• Created a logical design and physical design in ER/STUDIO.
• Maintained security and data integrity of teh database
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Participated in Performance Tuning using Explain Plan and Tkprof.
• Extensively used ER/Studio for developing data model using star schema methodologies.
• Created Unix Shell Scripts for automating teh execution process.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for teh new programs.
• Built strong relationships with key business and technology partners inside and outside teh platform and infrastructure team
• Partnered with finance, MIS teams, and accounting to ensure teh consistency and accuracy of data and reporting
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer
• Created SQL tables with referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL
• Wrote stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems
• Involved in developing scripts for validating teh data and maintenance of security and integrity of database
• Created scheduled batch jobs using PL/SQL for downloading data into temporary tables to generate teh data required for some of teh reports
• Worked with teh team of business analysts, developers and end users for generating audit reports and troubleshoot teh related queries and fix teh connectivity issues.

Environment: Erwin, SQL Server, Crystal Reports, MS Office, Windows 2003, Oracle 8i, SQL, PL/SQL, ER/STUDIO, SQL*Loader, Perl, TOAD and UNIX.