SUMMARY:

• Over 8 years of Industry experience as a DataAnalyst with solid understanding of DataModeling, Evaluating DataSources and strong understanding of DataWarehouse/DataMartDesign, ETL, BI, OLAP, Client/Server applications
• Expert in writing SQL queries and optimizing the queries in Oracle, SQLServer, Netezza&Teradata.
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• ExcellentknowledgeinDataAnalysis,DataValidation,DataCleansing,DataVerification and identifyingdatamismatch.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle, Netezza and Teradata.
• Excellent experience on TeradataSQLqueries, TeradataIndexes, Utilities such as Mload, Tpump, Fastload and FastExport.
• Experience in DimensionalDataModeling experience usingDatamodeling, RelationalDatamodeling, ER/Studio, Erwin, and SybasePowerDesigner, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logicaldatamodeling.
• Highly proficient inDataModeling retaining concepts of RDBMS, Logical and PhysicalDataModeling until 3NormalForm (3NF) and MultidimensionalDataModeling Schema (Star schema, Snow - Flake Modeling, Facts and dimensions).
• Managed full SDLC processes involving requirements management, workflow analysis, sourcedataanalysis,datamapping, metadata management,dataquality, testing strategy and maintenance of the model.
• Extensive experience with Normalization (1NF, 2NF, 3NF and BCNF) and De-normalization techniques for improved database performance in OLTP andDataWarehouse/DataMart environments.
• Expert in developing transactional enterprisedatamodels that strictly meet normalization rules, as well as EnterpriseDataWarehouses using Kimball and InmonDataWarehouse methodologies.
• Excellent experience in writing SQLqueries to validatedatamovement between different layers indatawarehouse environment.
• Strong experience in using Excel and MSAccess to dump thedataand analyze based on business needs.
• Excellent experience in trouble shooting SQLqueries, ETLjobs, datawarehouse/datamart/datastore models.
• Experience in generating DDLscripts and creating indexing strategies.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL. Performance tuning and query optimization techniques in transactional anddata warehouse environments.

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.6.1/9.5/8.6.1/8.1/7.1, Data Stage 7.5, Ab Initio, Talend, Pentaho

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, CognosPowerplay, Tableau, TibcoSpotfire

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, AWK

Databases: MS SQL Server 2008/2005/2000, Oracle11g/10g/9i/8i, DB2 V9.5, Teradata R14/R13/R12, 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

Data warehouse Tools: 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

Reporting Tools: Crystal reports XI, Business Intelligence, SSRS, Business Objects 5.x / 6.x,Cognos7.0/6.0.

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

PROFESSIONAL EXPERIENCE:

Confidential, Overland Park, KS

Sr. Data Analyst/Data Modeler

Responsibilities:

• Worked ondataanalysis,dataprofiling,datamodeling,datamapping and testing for a given task
• Worked with DBA to create the physical model and tables.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for an effective Data Warehouse and Data Mart.
• Involved with impact assessment in terms of schedule changes, dependency impact,code changes for various change requests on the existing Data Warehouse applications that running in Production environment.
• Created logical and physical data models using Erwin and reviewed these models with business team and data architecture team.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Worked onOptimization of the application and the designing of the database tables with the right partitioning keys using the DPF feature of hash partitioning and range partitioning.
• Established and maintained comprehensivedatamodel documentation including detailed descriptions of businessentities, attributes, anddatarelationships.
• Developed mapping spreadsheets for ETL team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
• Helped the BI, ETLDevelopers, Project Manager and end users in understanding theDataModel,dataflow and the expected output for each model created
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprisedatastores within a metadata repository
• Extensively used Erwin as the main tool for modeling along with Visio
• Used SQL on a wide scale for analysis, performance tuning and testing

Environment: PDM, SAP, JD Edwards, Teradata 13.10, Microsoft SQL Server 2012, SQL Manager, SAP Logon, Erwin 8.0, Visio, Informatica, Business Objects XI, Teradata SQL Assistant

Confidential, Chicago,IL

Sr. Data Analyst/Data Modeler

Responsibilities:

• Used Erwin, created Conceptual, Logical and Physicaldatamodels.
• Indulge in Power designer tool, Informatica (Repository Manager, Designer and Workflow Manager.
• Translated logicaldatamodels into physical database models, generated DDLs for DBAs
• Worked withdatainvestigation, discovery and mapping tools to scan every singledatarecord from many sources.
• Performed cross-platform database migration for development & Production databases running on Sun OS to LINUX using utilities such as db2move and db2look.
• Transformed Logical Data Model to Physical Data Model ensuring the Primary Key and Foreign Key relationships in PDM, Consistency of definitions of Data Attributes and Primary Index Considerations.
• Implemented Data Archiving strategies to handle the problems with large volumes of data by moving inactive data to another storage location that can be accessed easily.
• Worked closely hand in hand with the Business Analytics manager, who was also a part of the design/data modeling team
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using star and snowflakeSchemas
• Extensively used ETL methodology for supportingdataextraction, transformations and loading processing, in a complex EDW using Informatica.
• Wrote ad-hoc SQL queries and worked with SQL and Netezza databases
• Collaborated with thedatawarehousing team, ensuring thatdatainfrastructure supports the needs of analytics team and validatingdataquality.
• Written SQLscripts 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.
• Used CAErwinDataModeler(Erwin) fordatamodeling (datarequirements analysis, database design etc.) of custom developed information systems, including databases of transactional systems anddatamarts.
• Tested the ETL process for both beforedatavalidation and afterdatavalidation process. Tested the messages published by ETLtool anddataloaded into various databases

Environment: Informatica9.5,DataFlux, Erwin 8, Quality Center 9.2, SQL, TOAD, PL/SQL, Flat Files, Teradata, dataFlux, Oracle 12c, SQL

Confidential, Menomonee Falls, WI

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 extensiveDatavalidation using SQLqueries and back-end testing
• Used SQL for Querying the database in UNIXenvironment
• Developed separate test cases for ETLprocess (Inbound & Outbound) and reporting
• Designed and developed ETLprocesses using InformaticaETLtool for dimension and fact file creation
• Performeddataanalysis anddataprofiling using complexSQL on various sources systems including Oracle and Netezza
• Involved in Migrating thedatamodel from one database to Teradata database and prepared a Teradata staging model.
• Developed ER and DimensionalModels using PowerDesigner advanced features. Created physical and logicaldatamodels using Power Designer.
• Successfully created and managed a conversion testing effort which included adataquality review, two system test cycles, and user acceptance testing.
• Using Erwin modeling tool, publishing of adatadictionary, review of the model and dictionary with subject matter experts and generation ofdatadefinition language.
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Managed full SDLC processes involving requirements management, workflow analysis, source dataanalysis,datamapping, metadata management,dataquality, testing strategy and maintenance of the model.
• Wrote complex SQLqueries for validating thedataagainst different kinds of reports generated by Business ObjectsXIR2.
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flat files, SQLServer2005 with high volumedata
• Involved in extensiveDatavalidation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and tested the testing programs.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

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

Confidential, Charlotte, NC

Sr. Data Analyst/Data Modeler

Responsibilities:

• Interacting with business users to understand the business requirements.
• Coordinating with Business analysts to understand the business challenges anddatafor reporting.
• Designed Starschema for Risk Retail reporting for credit card portfolio subject area.
• Created and maintained Logical and Physicalmodels for thedatamart, which supports the Credit, Fraud and Risk Retail reporting for credit card portfolio.
• Created partitions and indexes for the tables in thedatamart.
• Maintained metadata (datadefinitions of table structures) and version controlling for thedatamodel.
• Conducted design reviews with business analysts, Enterprisedataarchitect and solution lead to create proof of concept for the reports.
• Developed SQLscripts for creating tables, Sequences, Triggers, views and materialized views.
• Developed SQLscripts for loadingdatafrom staging area to target tables.
• Conducted performance analysis and created partitions, indexes and Aggregate tables.
• Developed SQLscripts for loading the aggregate tables and rollup dimensions.
• Performed unit testing, system integrated testing for the aggregate tables.
• Performeddataanalysis on the target tables to make sure thedataas per the business expectations.
• Studied the existing BIarchitecture and analyzed the existing systems to propose the alternate solutions.
• Proposed the EDWdatadesign to centralize thedatascattered across multiple datasets. The proposal also address thedataduplications,datain consistencies,dataquality management etc.
• Proposed BI solution by migrating the existing reports to Business Objects (crystal reports/Universe design).
• Performed theDataMapping,Datadesign (DataModeling) to integrate thedataacross the multiple databases in to EDW.
• Migrated critical reports using PL/SQL&UNIX packages.
• Involved in the creation of reporting universes in Business Objects.

Environment: Oracle, Toad, Toad Data Modeler 3.4, SQL Plus, Erwin Data Modeler, Erwin Model Manager 7.3, MS Visio, Source Offsite (SOS), Windows XP, QC Explorer, Business Objects, Share point workspace 2010, Oracle SQL Developer

Confidential

Data Analyst / Data Modeler

Responsibilities:

• Designed the dimensionalDataModel of thedatawarehouse.
• Responsible for DimensionalDataModeling and Modeling Diagrams using ERWIN.
• Createddatamodel report for consumers
• Worked with DBA to create Physical Model and tables from the logical model.
• Tuned SQLqueries for better performance.
• Physicaldatamodeling for proposed OLAPERWIN.
• Developed conceptual, logical, and physicaldatamodels using PowerDesigner for the Client'sData Layer.
• Involved in preparing Logical and PhysicalDataModels and conducted controlled brain-storming sessions with project focus groups.
• Designed and documented physicaldatamodels using PowerDesigner and Oracle Designer for numerous upgrade releases.
• Conducted JAD sessions with management, vendors, users and other stakeholders for open and pending issues to develop specifications.
• Defined the calculations based on the reporting needs and the sourcedataavailable
• Worked with DBA group to create Best-Fit PhysicalDataModel from the LogicalDataModel using Forward engineering using Erwin
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and PhysicalDataModels, designing database, documenting and rolling out the deliverables

Environment: Erwin DataModeler, InformaticaPower Center 7.1.2, Oracle 10g, Sybase, Windows, Toad, PL/SQL, Oracle 9i, SQL Server 2000, SQL*Loader, UNIX, Windows 2000