SUMMARY

• Over 8+ years of experience indatamodeling, business anddataanalysis, production support, database management, strategic analysis, requirements gathering, application and decision support.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Used Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle, Netezza and Teradata.
• Experienced in various Teradata utilities like Fastload, Multiload, BTEQ, FastExport, TPT and Teradata SQL Assistant.
• Excellent experience on Teradata SQL queries, Teradata Indexes such as JI, UPI, NUPI, SI and various concepts on Teradata
• Excellent experience in writing SQL queries to validatedatamovement between different layers in datawarehouse environment.
• Expert in creating Use Cases, Use Case Diagrams, Class Diagrams, Sequence Flows using MS Visio and Rational Rose using UML concepts.
• Experience on Data profiling, Data Analysis, Data Cleansing and Data Masking.
• Solid experience with IBM Informatiion Analyzer, Informatica IDE/IDQ and data profiling tools.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Experience in designing error and exception handling procedures to identify, record and report errors.
• Excellent experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Solid knowledge and experience with data modeling techniques on OLTP and dimensional data models.
• Strong experience designing various normalized and de - normalized data models

TECHNICAL SKILLS

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

Databases: Oracle 11g/10g/9i, Teradata R12 R13, R14, MS SQL Server 2005/2008/2012, MS Access, Netezza

Tools: MS-Office suite (Word, Excel, MS Project and Outlook), VSS

Testing and defect tracking Tools: HP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe

Operating System: Windows, Unix, Sun Solaris

ETL/Datawarehouse Tools: Informatica 9.5/9.1/8.6.1/8.1, SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pentaho, DataModeling 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, Warren, NJ

Sr. Data Analyst/Data Modeler

Responsibilities:

• 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.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Wrote and executed SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.
• Troubleshoot test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Responsible for different Data mapping activities from Source systems to Teradata
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB) from various heterogeneous data sources.
• 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
• 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 with data quality issues.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Analysis on Mainframe data to generate reports for business users.
• Identify & record defects with required information for issue to be reproduced by development team.

Environment: PL/SQL, Business Objects XIR2, ETL Tools Informatica 8.6/9.1 Oracle 11G, Teradata V2R12/R13.10, Teradata, SQL, TOAD, PL/SQL, Flat Files, Teradata

Confidential, Buffalo, NY

Sr. Data Analyst/Data Modeler

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool.
• 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 with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers and QA team.
• Extensively test the reports for data accuracy and universe related errors
• Tested several dashboards and deployed them across the organization to monitor the performance.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Worked on Teradata Appliance Backup Utility (ABU) and ARC to backup data to and from Teradata nodes.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2005 with high volume data
• Worked with Excel Pivot tables.
• Identify & record defects with required information for issue to be reproduced by development team.
• Flexible to work late hours to coordinate with offshore team.

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

Confidential, MN

Sr. Data Analyst/Data Modeler

Responsibilities:

• Actively involved in creating Physical and Logical models using Erwin.
• Presented thedatascenarios via, Erwin logical models and excel mockups to visualize thedata in a better way
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in thedatamodel.
• Involved withDataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData, Data Definitions andDataFormats
• Developed Star and Snowflake schemas based dimensional model to develop thedatawarehouse.
• 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
• Designed an Industry standarddataModel specific to the company
• Translated the business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling
• Wrote and executed SQL queries to verify thatdatahas been moved from transactional system to DSS,Datawarehouse,datamart reporting system in accordance with requirements.
• Created the test environment for Staging area, loading the Staging area withdatafrom multiple 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.
• Developed Data Mapping, Data Governance, transformations and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions todataissues and other challenges while implementing the OLAP model.
• Developed and maintaineddatadictionary to create metadata reports for technical and business purpose.
• Assisted the application team in determination and clarification of businessdatarequirements and also identified problems at thedatamodeling/design level and recommend solution to problems.

Environment: Erwin R8.2.5, MS Visio, Oracle 11g, Toad, Oracle Designer, SQL Server 2008, Oracle SQL developer 2008, Crystal Reports 9, Teradata, SQL 2008, SQL Server 7.0, SQL Server7.0

Confidential, Jacksonville, FL

Sr. Data Analyst/Data Modeler

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document)
• Involved in extensive Data validation using SQL queries and back-end testing
• Designed and developed ETL processes using Informatica ETL tool for dimension and fact file creation
• Data Analysis primarily Identifying DataSets, SourceData, Source MetaData,DataDefinitions and Data formats.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Netezza
• Involved in Migrating the datamodel from one database to Teradata database and prepared a Teradata staging model.
• Using ErWin v8.2 modeling tool, publishing of adatadictionary, review of the model and dictionary with subject matter experts and generation of data definition language.
• Managed full SDLC processes involving requirements management, workflow analysis, source data analysis,datamapping, metadata management,dataquality, testing strategy and maintenance of the model.
• Wrote complex SQL queries for validating the data against 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
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Reviewed the model with application developers, ETL Team, DBAs and testing team to provide information about thedatamodel and business requirements.
• Designed 3rd normal form targetdatamodel and mapped to logical model.
• Had brain storming sessions with application developers and DBAs to discuss about various de-normalization, partitioning and indexing schemes for physical model
• Resolved thedatatype inconsistencies between the source systems and the target system using the Mapping Documents.
• Used SQL for Querying the database in UNIX environment
• Developed the Star Schema for the proposed warehouse model to meet the requirements.
• Identified the objects and relationships between the objects to develop a logical model using ERWin and later translated the model into physical model.
• Worked withDataWarehouse Extract and load developers to design mappings forDataCapture, Staging, Cleansing, Loading, and Auditing.
• Developed, enhanced and maintained Snow Flakes and Star Schemas within data warehouse and data mart conceptual & logical data models.
• Involved inDatamapping specifications to create and execute detailed system test plans. Thedata mapping specifies whatdatawill be extracted from an internaldatawarehouse, transformed and sent to an external entity.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Java, Business Objects XIR2, ETL Tools Informatica 8.6/9.1/9.5, SSIS, Oracle 11G, Teradata R13, Teradata SQL Assistant, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting