SUMMARY

• 8+ years of extensive Information Technology experience in all phases of Software development life cycle including System Analysis, Design,Data Modeling, Dimensional Modeling, implementation and Support of various applications in OLTP andDataWarehousing.
• Excellent experienced in Data Modeler with strong Conceptual, Logical and PhysicalData Modeling skills,DataProfiling skills, MaintainingDataQuality, experience with JAD sessions for requirements gathering, creating datamapping documents, writing functional specifications, queries.
• Worked on Gathering and Analyzing Information Requirements, Data Analysis, Data Architecture, Business (E - R) modeling, Dimensional Modeling, ETL Design.
• Experienced in implementingDatawarehousing solutions involving Dimension modeling and Snow flake schema implementation (3 NF).
• Experienced in integration of variousdatasources with multiple Relational Databases like SQL, Teradata, Oracle and DB2.
• Excellent experienced in System Analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Good Experienced in modeling with both OLTP/OLAP systems, Kimball and Inmon Data Warehousing environments.
• Experienced 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 data ware house.
• Strong Experienced in 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.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK, SED

Data Modeling: ERwin r9.5/7x/6x/5x, ER/Studio 9.7/9.0/8.0/7. x

Databases: Oracle11g/10g/9i/8i/7.x, Teradata, DB2 UDB 8.x/7.x, DB2 Z/OS 9.x/8.2, SQL Server 2008/2005/2000, MySQL, MS- Access, Flat Files, XML files.

Operating Systems: Win 95/NT/98/2000/XP, LINUX, Sun Solaris 2.X/5/7/8, IBM AIX 5.3/4.2, HP-UX, MS-DOS

Scheduling Tools: Autosys, Maestro (Tivoli)

Other Tools: Teradata SQL Assistant Toad 9.7.2/7.4/7.3, DB Visualizer 6.0, Microsoft Office, Microsoft Visio, Microsoft Excel, Microsoft Project

ETL/Data warehouse Tools: Informatica 9.5/9.1/8.6.1/8.1, SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pentaho Data Modeling Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, ERwin

Tools: & Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Livonia, MI

Sr. Data Analyst/Data Modeler

Responsibilities:

• Involved in extensive DATA validation using SQL queries and back-end testing.
• Experienced in Creating and executed test cases for ETL jobs to upload master data to repository.
• Experienced in Data Transformation and Data Mapping from source to target database schemas and also data cleansing.
• Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.
• Created tables, views, sequences, triggers, table spaces, constraints and generated DDL scripts for physical implementation.
• Created Erwin template to support the organization standards and Database standards.
• Reviewed the model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Experienced in Creating and executing test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Experienced in Using SQL for Querying the database in UNIX environment.
• Experienced in testing the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Experienced in Identifying & record defects with required information for issue to be reproduced by development team.

Environment: DB2, CA ERwin 7.0, Oracle 11g, VISIO, MS-Office, SQL Architect, TOAD Benchmark Factory, SQL Loader, PL/SQL, SharePoint, NFORMATICA, VISIO, Oracle, MS-Excel

Confidential, Greenville, SC

Sr. Data Analyst/Data Modeler

Responsibilities:

• Involved in all phases of SDLC including analysis, designing, developing, testing and maintenance.
• Good knowledge In-depth worked with business analysts/DataModeler(DM) in the process of requirements gathering for various application specific databases.
• Initiated and conducted JAD sessions inviting various teams to finalize the requireddatafields and their formats.
• Worked on multiple projects with different business units including Insurance actuaries.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Conducted Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Worked on Metadata Repository (MRM) for maintaining the definitions and mapping rules up to mark.
• Applieddatacleansing/datascrubbing techniques to ensure consistency amongstdatasets.
• Created DMR mapping spreadsheets, Source to Target mapping documents including the transformation rules.
• Developed the logicaldatamodels and physicaldatamodels that confine existing condition/potential statusdatafundamentals anddataflows using ER-Studio.
• Experienced inDataTransformation andDataMapping from source to target database schemas and alsodatacleansing.
• Resolved thedatatype inconsistencies between the source systems and the target system using the Mapping Documents.

Environment: DB2, CA ERwin 7.0, Oracle 11g, VISIO, MS-Office, SQL Architect, TOAD Benchmark Factory, SQL Loader, PL/SQL, SharePoint, ERWIN, VISIO

Confidential, Mission, KS

Sr. Data Analyst/Data Modeler

Responsibilities:

• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Netezza.
• Extracted data from various sources like Oracle, Netezza and flat files and loaded into the target Netezza database.
• Experienced in Testing 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.
• Experienced in Tuning and optimization of Teradata Queries Created the ETL data mapping documents between source systems and the target data warehouse.
• Experienced in writing complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2.
• Experienced in Designing both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas
• Utilized the new T-SQL features added in SQL Server 2005 such as Data partitioning, Error handling through TRY-CATCH statement and Common Table Expression (CTE).
• Assisted in the oversight for compliance to the Enterprise Data Standards, data governance and data quality
• Experienced in Using CA ERwin Data Modeler (ERwin) for Data Modeling (data requirements analysis, database design etc.) of custom developed information systems, including databases of transactional systems and data marts.
• Worked with the project management team to ensure the quality and schedule of the applications. Addressed and resolved internal and production issues.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Java, Business Objects XIR2, ETL Tools Informatica 8.6, SSIS, Oracle 11G, Teradata R13, Teradata SQL Assistant

Confidential, Washington DC

Data Analyst/Data Modeler

Responsibilities:

• Developed the logicaldatamodels and physicaldatamodels that capture current state/future state dataelements anddataflows using ER Studio.
• Developed a Conceptual model usingERwinbased on requirements analysis.
• Worked on ERwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Involved inDataMapping activities for thedatawarehouse.
• Experienced in Produced PL/SQL statement and stored procedures in DB2 for extracting as well as writingdata.
• Conducted extensive requirement analysis using Rational requisite pro
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Performed Gap Analysis of the processes to identify and validate requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Ensured production databeing replicated intodatawarehouse without anydataanomalies from the processing databases.
• Developed Star and Snowflake schemas based dimensional model to develop thedatawarehouse.
• Enforced referential integrity in the OLTPdatamodel for consistent tables and efficient database design.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Developed and maintaineddatadictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Experienced in Preparing analytical and status reports and updated the project plan as required.

Environment: ERwin R8.2.5, MS Visio, Oracle 11g, Toad, Oracle Designer, SQL Server 2008, Oracle

Confidential 

Data Analyst

Responsibilities:

• Experienced in Creating and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) 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.
• Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats
• Experienced in creating data masking mappings to mask the sensitive data between production and test environment.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Involved with in extensive DATA validation using SQL queries and back-end testing
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Experienced in Testing the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Designed and developed cubes using SQL Server Analysis Services(SSAS) using Microsoft Visual Studio 2008
• Troubleshoot test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Experienced in Monitoring scheduled stored procedures and backup jobs to insure successful completion.
• Excellent Experienced as a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by Management and the team.

Environment: PL/SQL, Business Objects XIR2, ETL Tools Informatica, Oracle, Teradata, Teradata SQL Assistant 12.0, Netezza, Power Designer, ERwin