SUMMARY

• Senior Data Modeler/Analyst with 7+ years of experience in data analysis and modeling, with excellent understanding of Data Warehouse and Data Mart designing.
• Experience in understanding various business process, gathering business requirements, implementing business processes, identifying risks, doing impact analysis and UML modeling
• Experience in carrying out the entire Software Development Life Cycle (SDLC).
• Experience in working with business users/SMEs(Subject Matter Experts) as well as senior management.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Conceptual/Logical/Physical Modeling using 3NormalForm (3NF), Star Schema modeling, Snowflake modeling using tools like Erwin, ER - Studio.
• Conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN crystal reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, coordinated with DBAs' to apply the data model changes.
• Extensively used ERWIN for REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.
• Developed Data dictionary and maintained Metadata for each model.
• Good understanding of Teradata SQL Assistant, Teradata Administrator and data load/ export utilities like BTEQ, Fast Load, Multi Load, Fast Export.
• Experienced in data access optimization, writing complex SQL queries and PL/SQL blocks like stored procedures, Functions, Triggers, Cursors and ETL packages.
• Experience working on creating models for Teradata master data management.
• Worked and extracted data from various database sources like Oracle, SQL Server, DB2, and Teradata.
• Loaded huge volumes of data into empty Teradata tables in the Datamart for the initial load, using Teradata Fast Load utility.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Conducted GAP analysis and User Acceptance Testing (UAT).
• Skilled in System Analysis, E-R/Dimensional Data Modeling, Database Design and implementing RDBMS specific features.
• Participated in performance management and tuning for stored procedures, tables and database servers.
• Improving the Performance of the SQL Queries, Functions, Procedures, Packages and Database Objects by creating Normal, Unique.

TECHNICAL SKILLS

Database Specialties: Database Architecture,DataAnalysis, EnterpriseDataWarehouse, Database Design and Modeling,DataIntegration and Migration, ETL Architecture and Design,DataWarehouse, OLTP, OLAP

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

Databases: My SQL Server 2008/R2/12 Oracle PL/SQ, MS Access

Programming Languages: SQL, PL/SQL.

Operating Systems: Windows, UNIX, MS DOS.

Reporting Tools: Crystal reports XI, Business Intelligence, SSRS, Business Objects 5.x / 6.x, Cognos7.0/6.0., Tableau, Informatica Power Center 7.1/6.2, Ab-Initio,DataStage

Project Execution Methodologies: Ralph Kimball and Bill Inmondatawarehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD).

Tools: MS-Office suite (Word, Excel, MS Project and Outlook), TOAD, BTEQ, Fast Load, Multi Load, Fast Export.

PROFESSIONAL EXPERIENCE

Data Modeler/Data Analyst

Confidential, Austin, TX

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Involved in meetings with SME (subject matter experts) for analyzing the multiple sources.
• Extensively used Star Schema methodology in building and designing the logical data model.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Conducted data model walkthroughs and validation.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Prepared business case for the data mart and then developed and deployed it.
• Documented, clarified, and communicated change requests with the requestor and coordinated with the development and testing team.
• Used ERwin to transform data requirements into data models.
• Performed Reverse Engineering of the current application using ERwin, and developed Logical and Physical data models for Central Model consolidation.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Worked extensively in data analysis by querying in SQL and generating various PL/SQL objects.
• Involved in back-end testing and worked with Data Quality issues.
• Managed the metadata repository containing data elements, semantics and business rules.
• Collaborated the data mapping document from source to target and the data quality assessments for the source data.

Environment: SQL server 2008, Linux, Windows XP, ERwin, MS Visio, TOAD, Microsoft Office.

Data Modeler/Data Analyst

Confidential, Irving, TX

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.
• Created the conceptual model for thedatawarehouse using Erwindatamodeling tool.
• Reviewed the conceptual EDW (EnterpriseDataWarehouse)datamodel with business users, App Dev and Information architects to make sure all the requirements are fully covered.
• Worked on rationalizing the requirements across multiple product lines.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Implemented Agile Methodology for building an internal application.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about thedatamodel and business requirements.
• Worked with ETL to create source to target mappings (S2T).
• Participated in the MasterDataManagement (MDM) effort; provide technical advice and support toward the development of strategic and tactical plans for client masterdatamanagement strategy, datainventories,datagovernance,datamanagement, storage, and distribution alternatives in support of client MDM strategy.
• Worked with DBA to create the physical model and tables.
• Worked on Mercury Quality Center to track the defect logged against the logical and physical model.
• Conducted brain storming sessions with application developers and DBAs to discuss about various demoralization, partitioning and indexing schemes for physical model.
• Worked on Requirements Traceability Matrix to trace the business requirements back to logical model.

Environment: Erwin, SQL Server 2008, Oracle 11g SQL*Loader, Mercury Quality Center 9, Informatica Power Center 8.1.

Data Modeler/Data Analyst

Confidential, Pleasanton, CA

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Performed gap analysis between the presentdatawarehouse to the futuredatawarehouse being developed and identifieddatagaps anddataquality issues and suggested potential solutions
• Created the conceptual, Logical and Physical Model for thedatawarehouse with emphasis on insurance (life and health), mutual funds and annuity using Erwindatamodeling tool.
• Created functional requirement documents for the impacting projects that were agreed upon to be implemented in the current release.
• Updated the impacted MS Access tables.
• Worked with relational database (Oracle 10g), Flatfiles, Unix (AIX) and various tools like SQL Nav, Toad, FTP Client, Putty etc.
• Created Source to target Mapping Matrix for the ETL developers in loading thedatato Dimensions and Fact Tables using SAS.
• Documented existing business process using UML based activity diagrams.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define theDataFlow Diagrams (DFD).
• Designed Star and SnowflakeDataModels for EnterpriseDataWarehouse using ERWIN
• Analyzed web site usability usingdatagathered from the existing website.
• Organized Joint Application Development (JAD) sessions withdatasteward and ETL teams while having walkthroughs for mapping documents.
• Created physical and logicaldatamodels using ERWin.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Reviewed test results and coordinated with testing and development team to correct the issues.
• Developed timelines for project delivery, and managed projects/resources

Environment: ERWin 7.2, Microsoft Office Suite, Microsoft Visio, Unix, Documentum, ETL, MS Word, MS Access, MS Excel, MS Visio, Windows NT/XP, SAS, Oracle, SQL, SQL Server, Sybase, VBScript, C#, Business Objects, LoadRunner.

Software Engineer

Confidential

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Created a logical design and physical design in ER/STUDIO.
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Extensively used ER/Studio for developingdatamodel using star schema methodologies.
• Maintained security anddataintegrity of the database.
• Created Unix Shell Scripts for automating the execution process.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Designed Logical and Physical models of Relational Database.
• Built strong relationships with key business and technology partners inside and outside the platform and infrastructure team.
• Partnered with finance, MIS teams, and accounting to ensure the consistency and accuracy of dataand reporting.
• Created Entity relationship diagrams, Function relationship diagrams,dataflow 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 thedataand maintenance of security and integrity of database.
• Created scheduled batch jobs using PL/SQL for downloadingdatainto temporary tables to generate thedatarequired for some of the reports.
• Worked with the team of business analysts, developers and end users for generating audit reports and troubleshoot the related queries and fix the connectivity issues.

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