SUMMARY

• Data Analyst/Modeler with 7+ years of experience in data analysis and modeling, with excellent understanding of OLTP, OLAP, BI tools on various domains like Financial, Banking, Insurance and Retail.
• Experience in understanding various business process, gathering business requirements, implementing business processes, identifying risks, doing impact analysis.
• Extensive experience in designing the Data models for OLTP & OLAP database system.
• Extensive experience in Database Design, Normalization, Denormalization, Forward/ Reverse Engineering of Applications, Conceptual, Logical and Physical data modeling using Erwin, E/R Studio, Sybase Power Designer.
• Implemented Domains, Naming Standards using Erwin etc.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Conceptual/Logical/Physical Modeling using 3NormalForm (3NF), Star Schema modeling, Snowflake modeling
• Comprehensive knowledge of software development methodologies such as Waterfall, RAD, RUP and AGILE SCRUM.
• Good understanding of Microsoft SQL Server, Oracle, Teradata.
• Created DDL scripts for implementing Data Modeling changes.
• Created ERWIN crystal reports in HTML format depending upon the requirement, Published Data model in model mart, created naming convention files, coordinated with DBAs' to apply the data model changes.
• Excellent knowledge in Data Analysis, Data Validation, Data profiling, Data Cleansing, Data Verification and identifying data mismatch.
• Performed extensive datacleansing, data manipulations and date transforms and data auditing.
• Worked on Master DataManagement (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Proficient in eliciting and analyzing businessrequirement from subject matter experts (SME) and communicating them to technical stakeholders for implementation.

TECHNICAL SKILLS

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse, Database Design and Modeling, Data Integration and Migration, ETL Architecture and Design, Data Warehouse, OLTP, OLAP.

Modeling Tools: Erwin 9.x, ER/Studio, MS Visio.

Databases: MS SQL Server, Oracle, Teradata, MS Access.

ETL Tools: Oracle Warehouse Builder, Informatica, Power Center 6.0/7.1/8.1.1, Power Mart 6.0, DTS

Programming Languages: SQL, PL/SQL, UNIX shell scripting, PERL.

Operating Systems: Windows, UNIX.

Web technologies: HTML, DHTML, XML, CSS.

Scripting Languages: VBScript, JavaScript

PROFESSIONAL EXPERIENCE

Confidential - Downers Grove, IL

Sr. Data Analyst/Modeler

Responsibilities:

• Participated in JAD session with Business Users and Sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Participated inbrain storming sessionswith application developers and DBAs to discuss about variousde-normalization, Partitioning and Indexing Schemesfor Physical Model.
• Created theConceptual Modelfor the Data Warehouse usingErwinData Modeling tool.
• Reviewed theConceptual EDW (Enterprise Data Warehouse)Data Model with Business Users, App Dev. and Information Architects to make sure all the requirements are fully covered.
• Identifiedthe Facts & Dimensions Tables and established the Grain of FactforDimensional Models.
• Created Logical & Physical Data Modes using Entity Relationship Diagrams.
• Worked onRequirements Traceability Matrixto trace the business requirements back toLogical Model.
• Reviewed the Physical Data Model withApplication Developers, ETL Team, DBAsandTesting Team to provide information about the Data Model and business requirements.
• CreatedMulti-Way Aggregate Fact Tablesas a specific summarization across dimensions of product, region and date.
• CreatedSnowflake Schemasby normalizing the dimension tables as appropriate, and creating aSub Dimensionnamed Demographic as a subset to the Customer Dimension.
• Createdrefined data modelspertaining to reassessed business requirements conforming to applicable data standards and successfully documenting the existing system model and changes proposed/applied to the model.
• DevelopedScripts that automated DDL and DMLstatements used in creations of Databases, Tables, Constraints, and updates.
• Extensively usedMetadata & Data Dictionary Management; Data Profiling; Data Mapping.
• AppliedData Governance rules(primary qualifier, class words and valid abbreviation in Table name and Column names).
• Involved in capturing Data Lineage, Table and Column Data Definitions, Valid Valuesand others necessary information in the data models.

Environment: MS VISIO 2010, Erwin R9.6, Oracle 11g,JIRA, Toad, Oracle Designer,SQL Server 2014, Oracle SQL developer 2014, Crystal Reports 9, Teradata, Red Gate

Confidential - Lisle, IL

Sr Data Analyst /Modeler

Responsibilities:

• Attended and participated in information andRequirements Gatheringsessions.
• Ensured thatBusiness Requirementscan be translated into Data Requirements.
• CreatedBusiness Requirement documents (BRD’s), such asSRS & FRSand integrated the requirements and underlying platform functionality.
• Translated Business Requirements into workingLogical and Physical Data Models.
• Developed the Logical and physical data model and designed the data flow from source systems toTeradata tablesand then to the Target system.
• Designed the technical specifications document forTeradata ETLprocessing of data into master data ware house and strategized the integration test plan and implementation.
• Developed complex Multi load and Fast Load scripts for loading data intoTeradatatables from legacy systems.
• Used advanced data modeling concepts such Confirmed Dimensions, and Bus Matrixin order tohandle complex situations.
• Designed and DevelopedUse Cases, Activity Diagrams, andSequence DiagramsusingUnified Modeling Language (UML).
• Involved in the analysis of the existing claims processing system, mapping phase according to functionality and data conversion procedure.
• PerformedNormalizationof the existing OLTP systems (3rd NF), to speed up the DML statements execution time.
• DesignedStar and Snowflake Data ModelsforEnterprise Data WarehouseusingER Studio.
• Data modeling in Erwin; design of target data models for enterprise data warehouse (Teradata).
• Created and MaintainedLogical Data Model (LDM)for the project. Includes documentation of allEntities, Attributes, Data Relationships, Primary and Foreign Key Structures, Allowed Values, Codes, Business Rules, Glossary Terms, etc.
• Worked extensively on Transactional- grain,Periodic snap shotgrain andAccumulating snap shotgrain while designing dimensional models.
• Validated and updated the appropriateLDM\'s to Process Mappings, Screen Designs, Use Cases,Business Object Model,and System Object Modelas they evolve and change.
• Designed theDatabase Tables & Created TableandColumn Level Constraintsusing the suggested naming conventions for constraint keys.
• Worked on optimizing and tuning theTeradataviews and SQL’s to improve the performance batch and response time of data for users.
• Developed and designed automated solution usingTeradata macros, stored procedures and excel macros for business users to load reference data directly to tables.
• MaintainedData Model and synchronizedit with the changes to the database.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Attendantarchitecture meeting and data governance meetingto understand the project.
• Identified and mapped various data sourcesand their targets successfully to create a fully functioning data repository.
• Also, part of production support team and resolved issues.

Environment: IBM-Rational Rose, MS Visio, Oracle, Informatica, Teradataand Erwin 8, Access, JIRA.

Confidential

Data Analyst consultant

Responsibilities:

• Performed BusinessAcceptance Testing and assisting user and partners in User Acceptance testing
• Acted as liaison between owner and businesspartners, clients, employees, staff and vendors.
• Created High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the entities to analyze and document business data requirements
• Reverse Engineered to redefine entities, relationships and attributes in the data model using ERWIN.
• Involved in understanding and translating the business requirements and to High Level and Low-level design for ETL processes in Teradata.
• Prepared behavioral UML diagrams (such as Use Cases, Activity and sequence diagrams).
• Developed normalized Logical and Physical database models to design OLTP system.
• Working along with ETL team for documentation of transformation rules for data migration from OLTP to warehouse for purpose of reporting.
• Involved in different stages of SDLC such as translating business requirements to high level and low-level design, Coding, Unit testing, deployment and post-deployment support activities
• Involved in the generation of DDL and DML scripts.
• Created source to target mappings for all the requirements.
• Worked on Data Profiling, Data Cleansing and Master Data Management.
• Developed Star schema for proposed central model and normalized star schema to snow flake schema.
• Involved in the design review of the finalized database model.
• Organized sessions with architects, business and development teams to understand the Change Requests (CR's)
• Created and maintained Database Objects (Tables, Views, Indexes and Partitions)
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.
• Ensured the quality, consistency, and accuracy of data in a timely, effective and reliable manner.

Environment: ERWIN 7.3, Oracle10g, SQL server, MS Excel,Informatica, MS Visio,Informatica, JIRA, Rational Rose, Requisite Pro

Confidential

Data Analyst/Modeler

Responsibilities:

• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
• Analyzed business/system requirements using requirement arbitrage and assigned appropriate priorities.
• Applied Unified Modeling Language (UML) notations and methodology in developing models that accurately represent the business process and workflows to communicate effectively them to the stakeholders.
• Worked with ETL teams to create source and target definition.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• Extensively built programs for different requirement to make the process more automated for data migrations and minimize the duplicated efforts.
• Worked on designing the OLAP Model/Dimension model for BI Reporting sourcing from SAP Transactions.
• Conducted Knowledge Session within Team to train in the Project.
• Managed the implementation of new hierarchy design into enterprise data warehouse(Teradata)
• Worked on PL/SQL collections, index by table, arrays, bulk collect, FOR ALL, etc.
• Performed updates and enhancements to the already existing data models as required by using ERWIN.
• Developed logical data model from the conceptual model using ERWIN.
• Transformed project data requirements into project data models for OLAP and OLTP systems using Erwin.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.
• Generated DDL statements for the newly generated objects (tables, views, indexes and packages).

Environment: ERWIN 8.2, Oracle10g, SQL server, MS Excel, MS Visio, Rational Rose, Informatica, ETL, Requisite Pro, SAP R/3, ECC 6.0

Confidential

Data Modeler Intern

Responsibilities:

• Worked with senior Data Modelers as part of trainings.
• Developed Conceptual model using ERWIN based on requirements
• Worked on the Forward Engineering (F.E) of the logical models to generate the physical model using Erwin.
• Analyzed business needs, created and developed new functionality to meet real time data integration that facilitated decision.
• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements and participated in data modeling JAD sessions.
• Created tables, views, sequences, indexes, constraints and generated SQL scripts for implementing physical data model.

Environment: ERWIN r7. 3, SQL Server 2000/2005, PL/SQL, Informtica, Windows XP