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 the requirement, published Data model in model mart, created naming convention files, co - coordinated with DBAs to apply the data model changes.
• Highly experienced in data warehousing technologies and implemented end-to-end architecture of the ETL solution, including liaising with System Architect and Database Architect for ETL model
• Extensive scripting knowledge of SQL, PL/SQL, BTEQs, MLOADs, Fast Loads, etc. and tuning techniques.
• Good experienced in Supporting ETL team in building ETL mappings, enabling the extract, transform loading of the 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 the 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 with ability to understand and/or create functional requirements working with client and also have 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/SQL

Datawarehousing 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

Roles & Responsibilities:-

• Experienced in Data Analysis primarily IdentifyingDataSets, SourceData, Source MetaData,DataDefinitions and DataFormats.
• Experienced in Effectively designed Delta loads in the project which successfully went go-live with any issues from the ETL side. All the Delta jobs are planned during the last phase of the project and it has 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 the database and SQL queries as per the need, created partitions, indexes where necessary.
• Experienced in Using ErwinData Modelerand Erwin Model Manager to create Conceptual, Logical and Physical datamodels and maintain the model versions in Model Manager for further enhancements.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and convert the 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 the datatype and naming convention as per the enterprise practice.
• Data Profiling and Data Analysis from the legacy system.
• Participated in major project activities including Architecture, Design discussion, requirement gathering, Analysis and review process.
• Designing the Data Dictionary.
• Working on Gap Analysis of existing data models.
• PerformedDataProfiling to identifydataissues upfront provided SQL prototypes to confirm the business logic provided prior to the development.
• Designed the 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 with 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

Roles & 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 the reporting system by identifying required dimensions and facts using Erwin.
• DevelopedDataMapping,DataGovernance, Transformation and Cleansing rules for the 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 with ETL, BI and DBA teams to analyze and provide solutions todataissues and other challenges while implementing the OLAP model.
• Developed, tested, managed and documenteddatawarehouse operations and tasks.
• Involved withdataprofiling for multiple sources and answered complex business questions by providingdatato business users.
• Worked withdatainvestigation, discovery and mapping tools to scan every singledatarecord from many sources.
• Performed logicaldatamodeling, physicaldatamodeling (including reverse engineering) using the 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 with 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 the 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 withdataquality issues.
• Analysis on Mainframedatato generate reports for business users.
• Identify & record defects with required information for issue to be reproduced by development team.
• Designed and Developed logical & physical data models and Meta Data to support the requirements using Erwin.
• Reverse engineered existing data bases to understand the data flow and business flows of existing systems and to integrate the 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 the data behavior within and between two companies.
• Performed logical Data Modeling, physical Data Modeling (including reverse engineering) using the Erwin Data Modeling tool.
• Resolved the data type inconsistencies between the source systems and the target system during the construction and maintained them in Mapping Documents.
• Created documentation and test cases, worked with 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, CA

Senior Data Modeler/Analyst

Roles & Responsibilities:-

• Used different transforms such as Query, Table Comparison, Key Generation, Merge, Date Generation, Pivot transforms and functions.
• Developed test cases to test the reports in positioning ofdataitems, incorrect drills, incorrect date formats, headings, prompts etc. and formatted reports according to specs given.
• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Identify & record defects with required information for issue to be reproduced by development team.
• Designed and developed database models for the operational data store, Data Warehouse, and federated databases to support client enterprise Information Management Strategy.
• Designed, developed and implemented solutions withData Warehouse, ETL,Data Analysis, and BI reporting technologies.
• Worked onDataExtraction, Transformation, and Loading with 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 with 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 with 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

Roles & 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 the business/user requirements, designing ODS tables in consultation with the Data Architect, analyzing the source/target dependencies & Production Troubleshooting.
• Developed Stored Procedures, Functions & Packages to implement the logic at the server end on Oracle 9.2. Performed Application/ SQL Tuning using Explain Plan, SQL Tracing & TKPROF. Also, used Materialized View for the Reporting Requirement.
• Responsibilities also include Gathering the Business requirements, Business Analysis, Design, QA testing and final promotion to the production as well.
• Created data masking mappings to mask the sensitive data between production and test environment.
• Worked with 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 the 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 the design of the new Data Mart for Finance Department and working with Data Architect/ Designer using Erwin Data Modeling Tool.
• Designed, developed and implemented solutions with 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 with DBA and development team members.
• Worked with the 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, the replacement data element is added, in the next one, the one being replaced is removed.
• Created logical and physical data models using Erwin and reviewed these models with 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