SUMMARY

• Having 8+ years of professional experience in Data Modeling and Data Analysis as a Proficient in gathering business requirements and handling requirements management.
• Strong experienced in customer communication, requirement analysis, data profiling, Data Modeling, understanding technical architecture, ETL architecture and Data Analysis.
• Worked in Conceptual Data Modelling, Enterprise Data Modelling, Logical/Physical Data Modelling, Enterprise Data Warehouse Design, Datamart Design, Metadata, Data Quality, MasterData Management and Data Governance.
• Experienced in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies
• Worked expansively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon teh requirement, published Data model in model mart, created naming convention files, co - coordinated wif DBAs to apply teh data model changes.
• Highly experienced in data warehousing technologies and implemented end-to-end architecture of teh ETL solution, including liaising wif System Architect and Database Architect for ETL model
• Extensive scripting noledge of SQL, PL/SQL, BTEQs, MLOADs, Fast Loads, etc. and tuning techniques.
• Good experienced in Supporting ETL team in building ETL mappings, enabling teh extract, transform loading of teh data into target tables and also involved in transformation of data from old database to new database.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through teh use of multiple ETL tools such as Informatica Power Center Experience in testing, data validation and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Worked in offshore/onsite model wif ability to understand and/or create functional requirements working wif client and also has Good experience in requirement analysis and generating test artifacts from requirements docs.

TECHNICAL SKILLS

Operating Systems: Linux, HP UNIX, Sun Solaris, and Windows 2000/XP/Vista

MS Office Tools: MS Word, MS Excel, MS Access, MS PowerPoint, MS Visio

Languages: C++, SQL, PL/SQLDatawarehousing Tools: Business Objects, Cognos, Microstrategy, Erwin, Tableau

Packages: MS Office, MS Visio, MS Project, Enterprise Architect

Tools: Clear case, Clear Quest, Rational Rose, Requisite Pro, HP Quality Center

RDBMS: Netezza Twin fin, Teradata R14, R13, R12, Oracle

Databases: SQL, Oracle, MS Access, SQL Server 2000

Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Waterfall Model.

PROFESSIONAL EXPERIENCE

Confidential, Livonia, MI

Senior Data Modeler/Analyst

Responsibilities:

• Experienced in Data Analysis primarily IdentifyingDataSets, SourceData, Source MetaData,DataDefinitions and DataFormats.
• Experienced in Effectively designed Delta loads in teh project which successfully went go-live wif any issues from teh ETL side. All teh Delta jobs are planned during teh last phase of teh project and it TEMPhas only one round of testing done before Go-Live.
• Worked as part of a team ofDataManagement professionals supporting a Portfolio of development projects both regional and global in scope.
• Highly Involved in Performance tuning of teh database and SQL queries as per teh need, created partitions, indexes where necessary.
• Experienced in Using ErwinData Modelerand Erwin Model Manager to create Conceptual, Logical and Physical datamodels and maintain teh model versions in Model Manager for further enhancements.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and convert teh logical model to physical data model, object creation and aggregation strategies, partition strategies, Purging strategies as per new architecture.
• Designing Source to Target Mapping template and document.
• Standardizing teh datatype and naming convention as per teh enterprise practice.
• Data Profiling and Data Analysis from teh legacy system.
• Participated in major project activities including Architecture, Design discussion, requirement gathering, Analysis and review process.
• Designing teh Data Dictionary.
• Working on Gap Analysis of existing data models.
• PerformedDataProfiling to identifydataissues upfront provided SQL prototypes to confirm teh business logic provided prior to teh development.
• Designed teh ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using Erwin
• Interacted wif internal customers on significant technical matters frequently requiring coordination across organizational lines; Create business rule spreadsheets / mapping documents.

Environment: Oracle 12c/11g, Windows 7, PL/SQL, MS-Access, SQL SERVER, MS Office, MS Visio, Erwin 8.2.5, Teradata 14.10

Confidential, Chicago, IL

Senior Data Modeler/Data Analyst

Responsibilities:

• Studied in-house requirements for theDatawarehouse to be developed.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Created dimensional model for teh reporting system by identifying required dimensions and facts using Erwin.
• DevelopedDataMapping,DataGovernance, Transformation and Cleansing rules for teh Master DataManagement Architecture involving OLTP, ODS and OLAP.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in thedatamodel.
• Presented thedatascenarios via, Erwin logical models and excel mockups to visualize thedata better.
• Collaborated wif ETL, BI and DBA teams to analyze and provide solutions todataissues and other challenges while implementing teh OLAP model.
• Developed, tested, managed and documenteddatawarehouse operations and tasks.
• Involved wifdataprofiling for multiple sources and answered complex business questions by providingdatato business users.
• Worked wifdatainvestigation, discovery and mapping tools to scan every singledatarecord from many sources.
• Performed logicaldatamodeling, physicaldatamodeling (including reverse engineering) using teh ErwinDataModeling tool.
• Extensively used ETL methodology for supportingdataextraction, transformations and loading processing, in a complex EDW using Informatica.
• Written complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects XIR2.
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flat files, SQL Server 2005 wif high volumedata
• Performingdatamanagement projects and fulfilling ad-hoc requests according to user specifications by utilizingdatamanagement software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts to test teh mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked wifdataquality issues.
• Analysis on Mainframedatato generate reports for business users.
• Identify & record defects wif required information for issue to be reproduced by development team.
• Designed and Developed logical & physical data models and Meta Data to support teh requirements using Erwin.
• Reverse engineered existing data bases to understand teh data flow and business flows of existing systems and to integrate teh new requirements to future enhanced and integrated system.
• Designing Partitioned strategy in data model.
• Extensively used SQL for Data Analysis and to understand and documenting teh data behavior wifin and between two companies.
• Performed logical Data Modeling, physical Data Modeling (including reverse engineering) using teh Erwin Data Modeling tool.
• Resolved teh data type inconsistencies between teh source systems and teh target system during teh construction and maintained them in Mapping Documents.
• Created documentation and test cases, worked wif testing team for new module enhancements and testing.

Environment: Informatica Powercenter 9.1/8.6,IDE(Informatica Developer and/or Informatica Analyst), QlikView, IDQ (Informatica Data Quality), Oracle11g/10g, SQL, PL/SQL, Oracle SQL Developer, HP Quality Center, Microsoft SQL Server, Unix, Shell Scripts, Putty, Textpad, Winscp.

Confidential, Cupertino, CA

Senior Data Modeler/Analyst

Responsibilities:

• Used different transforms such as Query, Table Comparison, Key Generation, Merge, Date Generation, Pivot transforms and functions.
• Developed test cases to test teh reports in positioning ofdataitems, incorrect drills, incorrect date formats, headings, prompts etc. and formatted reports according to specs given.
• Worked wif end users to gain an understanding of information and core data concepts behind their business.
• Assisted in defining business requirements for teh IT team and created BRD and functional specifications documents along wif mapping documents to assist teh developers in their coding.
• Identify & record defects wif required information for issue to be reproduced by development team.
• Designed and developed database models for teh operational data store, Data Warehouse, and federated databases to support client enterprise Information Management Strategy.
• Designed, developed and implemented solutions wifData Warehouse, ETL,Data Analysis, and BI reporting technologies.
• Worked onDataExtraction, Transformation, and Loading wif RDBMS, Flat files and XML sources using SAP BODS 4.0.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked wif Data Quality issues.Extensively used Erwin for Data Modeling and created conceptual, logical and physical data models.
• Created Webireorts and modified existing Universes in SAP Business Objects
• Extensively worked on development of mappings wif BODS Transformations like Map Operation, Table Comparison, History Preserving, Key Generation, Pivot, Reverse Pivot etc.
• Responsible for design of logical and physicalDatamodel for client's management ODS using dimensional modeling.

Environment: Oracle 11g, Microsoft SQL Server 2008, SQL Developer, SQL Manager,Erwinr9, SQL Developer Data Modeler, Oracle 8i/9i, SQL, PL/SQL Developer 5.1,Sun Solaris8.0,Erwin4.0, ER- Studio6.0/6.5

Confidential, Boston, MA

Data Analyst/ Data Modeler

Responsibilities:

• Experienced in Enterprise Data Warehouse IBM Netezza .
• Highly provide hands-on Database, Data Modeling, Data Warehousing, ETL expertise and mentoring.
• Experienced in gathering/analyzing teh business/user requirements, designing ODS tables in consultation wif teh Data Architect, analyzing teh source/target dependencies & Production Troubleshooting.
• Developed Stored Procedures, Functions & Packages to implement teh logic at teh server end on Oracle 9.2. Performed Application/ SQL Tuning using Explain Plan, SQL Tracing & TKPROF. Also, used Materialized View for teh Reporting Requirement.
• Responsibilities also include Gathering teh Business requirements, Business Analysis, Design, QA testing and final promotion to teh production as well.
• Created data masking mappings to mask teh sensitive data between production and test environment.
• Worked wif data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata.
• Extracted data from Oracle 11g and upload to Teradata tables using Teradata utilities FASTLOAD &Multiload.
• Assisted in creation, verification and publishing of metadata including identification, prioritization, definition and data lineage capture for Key Data Elements (KDE) and Important Data Elements (IDE).
• Written SQL scripts to test teh mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in teh design of teh new Data Mart for Finance Department and working wif Data Architect/ Designer using Erwin Data Modeling Tool.

Environment: InformaticaPowercenter, Oracle8.1, SQL, PL/SQL, SQL Navigator, Toad, UNIX, Shell Scripts,Erwin.

Confidential

Data Analyst / Data Modeler

Responsibilities:

• Designed, developed and implemented solutions wif Data Warehouse, ETL, Data Analysis, and BI reporting technologies.
• Analyzed Data sources and requirements and business rules to perform logical and physical Data Modeling.
• Facilitated modeling sessions and design walk-throughs wif DBA and development team members.
• Worked wif teh DBA to convert logical Data models to physical Data models for implementation.
• Researches, designs, develops, configures, integrates, tests and maintains existing and new business applications and/or information systems solutions including databases through integration of technical and business requirements.
• Worked on conceptual, physical and logical data models (3NF) & dimensional data models (Star and Snow Flake Schema)
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Devised and maintained a rigorous release process, e.g. two-step model change: in one release, teh replacement data element is added, in teh next one, teh one being replaced is removed.
• Created logical and physical data models using Erwin and reviewed these models wif business team and Data Architecture team.

Environment: Oracle 11g, Microsoft SQL Server 2008, SQL Developer, SQL Manager, Erwin r9, SQL Developer Data Modeler, Oracle 8i/9i, SQL, PL/SQL Developer5.1,SunSolaris8.0, Erwin 4.0,ER-Studio 6.0/6.5