SUMMARY:

• Overall 8+ years of Industry experience as a Data Analyst wif solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Worked in writing SQL queries and optimizing teh queries in Oracle, SQL Server 2008, Netezza and Teradata.
• Good experienced inDataModeling andDataAnalysis as a Proficient in gathering business requirements and handling requirements management.
• Experienced in logical/physical database design and review sessions to determine and describedataflow andData mapping from source to target databases coordinating wif End Users, Business Analysts, DBAs and Application Architects.
• Experienced in Possess strong Documentation skill and knowledge sharing among Team, conducteddatamodeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL. Performance tuning and query optimization techniques in transactional anddata ware house environments.
• Experienced in Teradata EnterpriseData Warehouse (EDW) andDataMart.
• Experienced in writing SQL queries and optimizing teh queries in Teradata, Netezza, Oracle and SQL Server.
• Proficient in identifying Facts and Dimensions, Star Schema and Snow Flake Schema and ODS architecture for modeling aData Warehouse in Relational, Dimensional and multidimensional modeling.
• Highly Efficient inData Mart Design and creation of cubes using dimensionaldatamodeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Experienced in understanding teh ETL framework metadata to understand teh current state ETL implementation.
• Worked expansively on forward and reverse engineering processes. Created DDL scripts for implementingData Modeling HTML, RTF format depending uponchanges. Created ERWIN reports in
• Experienced in Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML)
• Good experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modifieddatabase design document wif detailed description of logical entities and physical tables.
• Experienced in Strong in Source to Targetdatamapping, Standardization Document Slowly Changing Mapping Creation, Star/Snowflake Schema Mapping Creation, RDMS, BuildingDataMarts and MetaData Management.

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.5/9.1/8.6/7.1.2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS, Data Stage 8.x

Reporting Tools: Business Objects6.5, XIR3, Tibco Spotfire, Tableau

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, ERWIN, PowerDesigner

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server, UDB DB2 9.x, Teradata, MS Access 7.0

Programming: SQL, PL/SQL, UNIX Shell Scripting, VB Script

Environment: Windows (95, 98, 2000, NT, XP), UNIX

Other Tools: TOAD, MS-Office suite (Word, Excel, Project and Outlook), BTEQ, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata.
• Experienced in Analysis of functional and non-functional categorizeddataelements fordataprofiling and mapping from source to targetdataenvironment. Developed working documents to support findings and assign specific tasks.
• Used ETL methodology for supportingdataextraction, transformations and loading processing, in a complex EDW using Informatica.
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flat files, SQL Server 2005 wif high volumedata
• Good Experienced in Testing teh ETL process for both beforedatavalidation and afterdatavalidation process. Tested teh messages published by ETL tool anddataloaded into various databases
• Responsible for analyzing variousdatasources such as flat files, ASCIIData, EBCDICData, RelationalData(Oracle, DB2 UDB, MS SQL Server) from various heterogeneousdatasources.
• Involved in Uploading Master and Transactionaldatafrom flat files and preparation of Test cases, Sub System Testing.
• Experienced in Testing teh database to check field size validation, check constraints, stored procedures and cross verifying teh field size defined wifin teh application wif metadata.
• Responsible for differentData mapping activities from Source systems to Teradata.
• Experienced in creating teh test environment for Staging area, loading teh Staging area wifdatafrom multiple sources.
• Excellent experienced in troubleshooting test scripts, SQL queries, ETL jobs,Data Warehouse/data mart/datastore models.
• Excellent in creating various artifacts for projects which include specification documents,Data mapping anddataanalysis documents.
• Excellent team player& technically strong person who has capability to work wif business users, project managers, team leads, architects and peers, thus maintaining healthy environment in teh project.

Environment: Teradata SQL assistant 13.10, ER StudioDataArchitect 9.0, MS Visio 2010, MS Access 2010, Microsoft Excel 2010, Micro Strategy, TSO, MSAT, All Word, IBM Information Analyzer, DataStage, SQL Server 2012, SharePoint.

Confidential, Short Hills, NJ

Sr. Data Analyst/Data Modeler

Responsibilities:

• Performed teh mapping effort for various development teams by mapping their applicationdatarequirements to teh model and providing consistent standardized language for communication between teh development teams.
• Experienced in Gathering and analyzed existing physicaldatamodels for in scope applications and proposed teh changes to thedatamodels according to teh requirements.
• Refined teh existing model resulting from project teams mapping theirdatarequirements for existing systems to thedatamodels as a part of teh SDLC project methodology.
• Worked wif teh Business and teh ETL developers in teh analysis and resolution ofdatarelated problem tickets and other defects.
• Generated and DDL (DataDefinition Language) scripts using ERWIN and assisted DBA in Physical Implementation ofdataModels.
• Used reverse engineering to connect to existing database and created graphical representation (E-R diagram) using ERWIN
• Worked wifdatain teh tables to analyze and modify by writing DML scripts.
• Experienced in Creating Source- Target SQL scripts for all teh transformation rules mentioned in teh mapping document.
• Analyzeddatafrom different perspectives and summarized it into useful information byDataMining Techniques.
• Experienced in Periodic checking of all databases wif DBCC commands for maintainingdataconsistency and integrity.
• Coordinated wif back-end programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.
• Created functional decomposition diagrams and Context Diagrams.
• Extensively used MS Visio for representing existing and proposeddataflow Diagrams.
• Participated in JAD sessions to solve teh revolving issues between teh executive teams and developers.

Environment: ERWIN, Power Designer 12.5, DATAFLUX 6.1, PL/SQL Developer, Oracle 9i, SQL/PL SQL, SQL Navigator, Windows NT 4.0, UNIX, Microsoft Access, Microsoft Visio, SQL Server 2000, MS PowerPoint, MS Access, Microsoft Excel.

Confidential, Windsor, CT

Sr. Data Analyst/Data Modeler

Responsibilities:

• Experienced in 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
• Worked on various business areas related data and extracted data from various sources such as flat files, Oracle and Mainframes.
• 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 and Teradata.
• Experienced in Writing several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking teh log files and cleanup process.
• Worked on Metrics reporting, data mining and trends in halpdesk environment using Access
• Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management 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 wif data quality issues.
• 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.
• Good knowledge in Identify & record defects wif required information for issue to be reproduced by development team.
• Experienced in Designed and developed database models for teh operational data store, Data Warehouse, and federated databases to support client enterprise Information Management Strategy.

Environment: - MS SQL Server 2008 client & SERVER, MS office, Legacy - Mainframes, Titanium, Rational Clear Quest, Clear Case.

Confidential, Minneapolis, MN

Sr. Data Analyst/Data Modeler

Responsibilities:

• Experienced in 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
• Involved wif data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked wif data investigation, discovery and mapping tools to scan every single data record from many sources.
• Created DML code and statements for underlying & impacting databases.
• Performed data reconciliation between integrated systems.
• Extensively used MS Access to pull teh data from various data bases and integrate teh data.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Responsible for different Data mapping activities from Source systems to Teradata
• Assisted in teh oversight for compliance to teh Enterprise Data Standards
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 wif high volume data
• Worked wif Excel Pivot tables.
• Created and Monitored workflows using workflow designer and workflow monitor.
• Good experienced in Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Wrote 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.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Business Objects XIR2, ETL Tools Informatica 8.6, Oracle 10G, Teradata V2R12, Teradata SQL Assistant 12.0

Confidential, Minneapolis, MN

Sr. Data Analyst/Data Modeler

Responsibilities:

• Experienced in Gathering Business requirements by organizing and managing meetings wif business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Responsible for teh analysis of business requirements and design implementation of teh business solution.
• Experienced in developing Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like ERWIN, ER/Studio and Power Designer.
• Experienced in Using ERWIN r7.3 for TEMPeffective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Identified Facts and Dimensions from teh business requirements and developed teh logical and physical models using ERWIN
• Highly generated comprehensive analytical reports by running SQL queries against current databases to conductdataanalysis.
• Experienced in Using Teradata Fast Export utility to export large volumes ofdatafrom Teradata tables and views for processing and reporting needs.
• Experienced in Handled performance requirements for databases in OLTP and OLAP models.
• Involved inData mapping activities for theData Warehouse.
• Developed complex Stored Procedures for SSRS (SQL Server Reporting Services).
• Experienced in Created database objects like tables, indexes, synonyms, views, materialized views etc.
• Documented ER Diagrams, Logical and Physical models, business process diagrams and process flowdiagrams.
• Created complex SQL server 2008 and Oracle stored procedures and triggers in support of teh applications wif Error handling.
• Experienced in Creating mappings, mapplets and reusable transformations in Informatica. Also used several transformations like expression, Aggregator, Lookups, Joiner, Normalizer, Router, update strategy, Filter, Union, Sequence Generator, Stored Procedure, Source qualifier, XML transformation, etc.
• Fine-tuned teh mappings using push down optimization, session partitioning, bulk load, fast load, etc.

Environment: Informatica Power Center, Teradata V6, Oracle 9i, Microsoft SQL Server 2008, SVN tool, Sybase Power Designer 16.1, BTEQs, MLoads, Fast Load, UNIX scripting, PLSQL Programming