Summary:

• 8 years of excellent experience as a Data Analyst and Data Modeler plus experienced in database management, strategic analysis, requirements gathering, application and decision support, which plays a key role in software development life cycle SDLC .
• Excellent in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.
• Experience in Dimensional Data Modeling experience using Data modeling, Relational Data modeling, ER/Studio, Erwin, and Sybase Power Designer, Star Join Schema/Snowflake modeling, FACT Dimensions tables, Conceptual, Physical logical data modeling.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm 3NF and Multidimensional Data Modeling Schema Star schema, Snow-Flake Modeling, Facts and dimensions . Complete knowledge of datawarehouse
• Managed full SDLC processes involving requirements management, workflow analysis, source data analysis, data mapping, metadata management, data quality, testing strategy and maintenance of the model.
• Proficient in Software Development Life Cycle SDLC , Project Management methodologies, and Microsoft SQL Server database management.
• Experience in developing Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like Erwin, ER/Studio and Power Designer.
• Expert in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading ETL and SQL Server, ORACLE and other relational and non-relational databases.
• Experience in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Extensive experience with Normalization 1NF, 2NF, 3NF and BCNF and De-normalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio.
• Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• An excellent team player technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

Technical Skills:

• Analysis and Modeling Tools: ERwin 7.2/7.0, 8.0, r9, Sybase Power Designer, Oracle Designer, BPwin, Rational Rose, ER/Studio, MS Visio
• ETL Tools: Informatica Power Center 9.5/8.6.1/8.1/7.1, Data Stage 7.5, Ab Initio, Talend
• OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, CognosPowerplay
• Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX Shell Scripting, C, C , AWK
• Databases: MS SQL Server 2008/2005/2000, Oracle11g/10g/9i/8i, DB2 V9.5, Teradata V2R6.1, MS Access 2000
• Operating Systems: Windows XP/2000/98, UNIX Sun Solaris 10
• Project Execution Methodologies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process RUP , Rapid Application Development RAD , Joint Application Development JAD
• Tools Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant
• Tools: MS-Office suite Word, Excel, MS Project and Outlook , VSS

Work Summary

Confidential

Sr. Data Modeler/Analyst

Responsibilities

• Worked on discovering entities, attributes, relationships and business rules from functional requirements
• Used Erwin R9.0, created Conceptual, Logical and Physical data models.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Wrote ad-hoc SQL queries and worked with SQL and Netezza databases
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data
• Responsible for analyzing various data sources such as flat files, ASCIIData, EBCDIC Data, Relational Data Oracle, DB2 UDB, MS SQL Server from various heterogeneous data sources.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data Oracle, DB2 UDB, MS SQL Server from various heterogeneous data sources.
• Preparation of various test documents for ETL process in Quality Center.
• Created and executed test cases for ETL jobs to upload master data to repository.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.

Environment: Informatica9.5, Business Objects, SQL, Teradata R14.10 MLOAD, FLOAD, FAST EXPORT, BTEQ , TeradataSQL Assistant 14, Toad, UNIX, Shell Scripting, TP 9.2, Test Director 7.x, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting

Confidential

Sr. Data Modeler

Responsibilities:

• Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports inHTML, 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.
• Generated a separate MRM document with each assignment and shared it on SharePoint along with the PDF of updated data models
• Created a list of domains in Erwin and worked on building up the data dictionary for the company
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
• Worked on Unit Testing for three reports and created SQL Test Scripts for each report as required
• Extensively used Erwin as the main tool for modeling along with Visio
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Worked on Metadata Repository MRM for maintaining the definitions and mapping rules up to mark
• Used Graphical Entity-Relationship Diagramming to create new database design via easy to use, graphical interface.
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.
• Extensively used SQL for performance tuning.
• Developed and executed queries in SQL for reporting using SQL Manager

Environment: ER Studio 9.1.0, Teradata, Netezza, EMC Greenplum, Oracle RAC 11g, IBM DB2, Business Objects XI 3.1,DbVisualizer 8.0.10, PDM, SAP, JD Edwards, Teradata 13.10

Confidential

Data Analyst / Data Modeler

Responsibilities

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.

• Used Erwin r7.3 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Responsible as a member of development team to provide business data requirements analysis services, producing Logical and Physical data models using Power Designer 12.0.
• Worked with DBAgroup to create Best-Fit Physical Data Model from the Logical Data Model using Forward Engineering.
• Developed Data Migration and Cleansing rules for the Integration Architecture OLTP, ODS, DW
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Utilized Power Designer's forward/reverse engineering tools and target database schema conversion process.
• Documented logical, physical, relational and dimensional data models. Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Developing reusable objects like PL/SQL program units and libraries, database procedures and functions, database triggers to be used by the team and satisfying the business rules
• Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD Object oriented Design using UML and Visio.

Environment:PowerDesigner, Oracle10g, SQL server, MS Excel, MS Visio, Rational Rose, Requisite Pro, Rational, Oracle 8i, Windows XP, PL/SQL, , Sql Server, MS Office, MS Access, MS Visio.

Confidential

Data Analyst / Data Modeler

Responsibilities

• Part of the team responsible for the analysis, design and implementation of the business solution.
• Developed the logical data models and physical data models that capture current state/future state data elements and data flows using ER Studio.
• Translate business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using ER Studio.
• Extensively used Normalization techniques up to 3NF .
• Responsible for data modeling and building a star schema model in ER Studio.
• Responsible for physical modeling per database and performance requirements.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
• Create and deploy reports using SSRS.
• Designed the physical model for implementing the model into oracle 10g physical data base.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Handled performance requirements for databases in OLTP and OLAP models.
• Worked with ad-hoc reporting using Crystal Reports 9 and T-SQL.

Environment: Erwin r9, SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Oracle 10g, Business Objects XI, Rational Rose, Data stage, MS Office, MS Visio

Confidential

Data Analyst / Data Modeler

Responsibilities

• Involved in creating Physical and Logical models using Erwin.
• Created and maintained Database Objects Tables, Views, Indexes, Partitions, Synonyms, Databasetriggers, StoredProcedures in the data model.
• Worked on building the data model using ER Studio as per the requirements, discussion and approval of the model from the BA.
• Provided subject matter expertise as appropriate to ETL requirements, information analytics, modeling design, development, and support activities.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Worked on Data Quality Framework design, logical physical model and architecture.
• Worked with Data Warehouse Extract and load developers to design mappings for Data Capture, Staging, Cleansing, Loading, and Auditing.
• Developed, enhanced and maintained Snow Flakes and Star Schemas within data warehouse and data mart conceptual logical data models.
• Communicated data needs internally and externally to 3rd parties. Analyzed and understood the data options and documented data dictionary.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• In depth analyses of data report was prepared weekly, biweekly, monthly using MS Excel, SQL UNIX.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.

Environment: Oracle, Erwin 9x, DB2, Information Analyzer, Informatica, MDM, Quality centre, Excel, MS-Word, ETL Tools Informatica