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
• Excellentknowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle and Teradata.
• Experienced in various Teradata utilities like Fastload, Multiload, BTEQ, and Teradata SQL Assistant.
• Excellent experience in writing SQL queries to validatedatamovement between different layers in datawarehouse environment.
• 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 troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Experience in Data Warehousing Design, ETL and Business Intelligence with expertise in TALEND Integration Suite, TALEND Data Integration, Platform Setup on Windows, MICROSTRATEGY and its components like Architecture, Report Development and Report Services for Dash boarding, Reporting/visualization and MS SQL server experience with SSIS and SSRS
• Developed and Scheduled Jobs in Talend Integration Suit.
• Experienced in using Excel and MS Access to dump the data and analyze based on business needs.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Have good exposure on working 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.
• Excellent in creating various artifacts for projects which include specification documents, data mapping and data analysis documents.
• Over 6 years of experience in the fields of IT and Business applications.
• Able to architect the Re - org of BW objects to maintain standards
• 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.
• Wrote and executed SQL queries to verify thatdatahas been moved from transactional system to DSS,Datawarehouse,datamart reporting system in accordance with requirements.
• Implement best practices and methodologies in data analysis, design and modeling.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL. Performance tuning and query optimization techniques in transactional and data warehouse environments.

TECHNICAL SKILLS

DataModeling: Erwin r9.5/8x/7x, ER/Studio 9.7/9.0/8.0/7. xDataModeling Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

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

ETL/Datawarehouse Tools: Informatica, SAP Business Objects XIR3.1/XIR2, Web Intelligence, Pentaho, Talend, Tableau.

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

Operating System: Windows, Unix, Sun Solaris

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

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

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Data Modeler/Sr. Data Analyst

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.
• Supported field sales team to assist in CRM management.
• Wrote and executed SQL queries to verify that data has been moved from Data warehouse, data mart reporting system in accordance with requirements.
• Troubleshoot test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Convert models from CA ERwin to ER/Studio 7.5 (ERStudio); Developed numerous macros.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSIS and SSRS.
• Implemented Hybrid Architecture comprising Inmon and Kimball approaches implementing Inmon at integrated layer and Kimball at the Semantic layer which is the best suited for Teradata.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Responsible for different Data mapping activities from Source systems to Teradata
• Responsible for analyzing various data sources such as flat files, Relational Data (Oracle, DB2 UDB and MS SQL Server) from various heterogeneous data sources.
• 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.
• Performed in depth analysis in data & prepared reports by using SQL & UNIX.
• Performed as a member on projects where Business Objects infrastructure expertise was required.
• Implement CRM enhancements based on organizational business needs.
• Involved in extensive DATA validation by writing several complexes 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.
• Performed Business Objects Reports and Universe architecture and design.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Analyzed the physical data model to understand the relationship between existing tables. Cleansed the unwanted tables and columns as per the requirements as part of the duty being a Data Analyst.

Environment: PL/SQL, Business Objects XIR2, ETL Tools Informatica 9.5, Oracle 12c, Teradata 13.10, SQL, TOAD, PL/SQL, Flat Files, Teradata

Confidential, Charlotte, NC

Data Modeler/Sr. Data Analyst

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
• Analyzed business requirements, system requirements and data mapping requirement specifications interacting with client, developers and QA team.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Produced both Logical and Physical Data Models utilizing ERStudio on an Oracle 9i Database.
• 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.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• 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 in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server with high volume data
• Worked with Excel Pivot tables.
• Designed flow diagrams which explain the process flow of Semantic development.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Worked on building up a SQL query for extraction of data from the warehouse for a reporting schedule.
• Writing UNIX shell scripts for processing/ cleansing incoming text files.
• Designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Developed strategies and loading techniques for better loading and faster query performance.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle and Netezza
• Conducted performance analysis and created partitions, indexes and Aggregate tables.
• Developed SQL scripts for loading the aggregate tables and rollup dimensions.

Environment: Oracle 12c, SQL Server 2012, Teradata 14, MS Access, Teradata,Datastage, Erwin 9.3, Windows 7, MS Excel, Business Objects XI, SSIS,Excel, Informatica 9.5

Confidential, Atlanta, GA

Data modeler/Sr. Data Analyst

Responsibilities:

• Actively involved in creating Physical and Logical models using Erwin.
• Presented thedatascenarios via, Erwin logical models and excel mockups to visualize thedata better.
• 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.
• Developed tools for automated testing of batches with database validations with UNIX and shell commands.
• Wrote and executed SQL queries to verify thatdatahas been moved from transactional system to DSS,Datawarehouse,datamart reporting system in accordance with requirements.
• Data Modeling with ErStudio (the standard at Countrywide and J.d. Powers).
• 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.
• DevelopedDataMapping,DataGovernance, and Transformation and cleansing rules for the MasterData 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, Oracle 10g, Toad, Oracle Designer, SQL Server 2008, Oracle SQL developer 2008, Crystal Reports 9, Teradata, SQL 2008, SQL Server

Confidential, SFO, CA

Data Modeler/Sr. Data Analyst

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document)
• Involved in extensiveDatavalidation using SQL queries and back-end testing
• Designed and developed ETL processes using Informatica ETL tool for dimension and fact file creation
• DataAnalysis primarily IdentifyingDataSets, SourceData, Source Meta Data, Data Definitions and Data Formats.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle and Teradata
• Involved in Migrating thedatamodel from one database to Teradata database and prepared a Teradata staging model.
• Using Erwin modeling tool, publishing of adatadictionary, review of the model and dictionary with subject matter experts and generation ofdatadefinition 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 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 with high volumedata
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• 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.
• Developed, enhanced and maintained Snow Flakes Schemas withindatawarehouse and datamart with conceptual datamodels.
• Involved inDatamapping specifications to create and execute detailed system test plans.

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

Confidential, Chicago, IL

Data Analyst/Data Modeler

Responsibilities:

• Analyzed and interpreted statisticaldatato identify significant differences in relationships among sources of information.
• Reported results of statistical analysis, including information in the form of graphs and models.
• Datamapping work of thedataexist on the warehouse.
• Performed User Acceptance testing (UAT) for fewdataintensive reconciliation modules the system
• Performeddataanalysis for the existingdatawarehouse and changed the internal schema for performance.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Extensively used SQL for accessing and manipulating database systems
• Prepared business flow diagrams and defined the workflows.
• Maintained a close and strong working relationship with team mates and management staff to achieve expected results for the project team.
• Worked extensively on the MS-SQL environment to run out the queries and explore the Databases.
• Created and executed SQL queries (using Rapid SQL and MS Access) and scripts to validatedata movement and generate expected results for UAT.
• Managed full SDLC processes involving requirements management, workflow analysis, source data analysis,datamapping, metadata management,dataquality, testing strategy and maintenance of the model.
• Prepared High level logical data models and BRDs (business required documents) supporting the documents containing the essential business elements and the description between the entities.
• Perform Data Profiling and Data Quality Analysis to analyze and to support data quality standards.
• Identified the Entities and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Created Source to Target mappings and Transformations. Mapped data between Source and Targets.

Environment: Windows XP, Windows 2003 Server, Power Pivot, UNIX, SQL Server 2008, SSRS, SSIS, MS Office, UML, Rational Clear Quest, Teradata, SAS, MS Access, MS Excel, XSLT, XML, ASP.NET