SUMMARY

• Over 10 years of IT professional experience with strong background in Database development,Data analysis and designing ofdatamodels for different domains.
• Strong Knowledge of SDLC methodology including analysis, design, development, testing and maintenance.
• Experience in the field ofData/ Business analysis, ETL Development,and Project Management.
• Experience as a Data Analyst and Data Modeler with solid understanding of BusinessRequirements Gathering, Business Process Mapping Evaluating DataSources, DataMapping, Translating Requirements into Specifications, Application Design.
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL databasedata warehouse processes.
• Expertise in broad range of technologies, including business process tools such as MicrosoftProject, MSExcel, MSAccess, MSVisio, technical assessment tools, Micro StrategyDataWarehouseDataModeling and Design.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/PhysicalDesign, ERDiagrams, Forward and ReverseEngineering, Publishing Erwindiagrams, analyzing data sources and creating interface documents.
• Created, documented and maintained logical and physicaldatabase models in compliance with enterprise standards.
• Expertise in SQL Performance Tuning and Optimization (Design, Memory, Application, IO) and using Explain plan, Tracing and TKPROF.
• Excellent knowledge in SQL and coding PL/SQL Packages, Procedures.
• Expert in leading the team and in collaborating across different functions and departments.
• Worked extensively on forward and reverse engineering processes using tools like Erwin.
• Created DDLscripts for implementingDataModeling changes.
• Experienced in generating and documenting Metadata, while designing OLTP, ODS and OLAP systems environment.
• Worked on different platforms such as Windows8/windows7/XP and UNIX, SunSolaris, AIX, HP
• Created reports from SAPmodules using BusinessObjects / CrystalReports based upon business requirements.
• Competent in Creating Unified Modeling Language (UML) diagrams such as UseCaseDiagrams, ActivityDiagrams, ClassDiagrams and Sequence Diagrams.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and BusinessObjects

TECHNICAL SKILLS

Operating System: UNIX, Linux, Windows, Windows XP pro

Data Analysis: Requirement Analysis, Business Analysis,DataFlow Diagrams, Business Rules,DataModeling.

Database: Oracle 8i/9i/10g, 11g, 12c, MS Access, SQL Server, Sybase and DB2.

DataModeling Tools: Erwin, Rational Rose and MS Visio Star and Snowflake Schemas Modeling, Facts & Dimensions.

Languages: SQL, PL/SQL, ASP, Visual Basic, XML, Java Scripting

Applications: Toad for Oracle, Oracle SQL Developer, MS Word, MS Excel MS Power Point, Teradata, Designer 6i

ETL Tools: Informatica Power Center 7.x/8.x,9.x, SQL * Loader

Reporting Tools: Oracle Business Intelligence

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Lead Data Modeler/Data Analyst

Responsibilities:

• Involved in data analysis and creating data mapping documents to capture source to target transformation rules.
• Create logical and physicaldata models using Erwin to meet the needs of the organization's information systems and business requirements.
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user Acceptance testing and loading history data into Teradata.
• Used Erwin to transformdatarequirements intodatamodels.
• Utilized SQLserver's reporting services SSRS and SSIS to support reporting requirements.
• Used Erwin and Visio to create 3NF and dimensional data models and published to the business users and ETL / BI teams.
• Performed extensive task which include DataQualityAnalysis, Data lineage and Data Standardization datastructures, data base design, datawarehouses, business intelligence/analytic tools, SQL, ETLtools, and data integration methods.
• Head the review and validation meetings with stakeholders.
• Developed conceptual/logical/physical data models using Erwin according to requirements.
• Worked on creating role playing dimensions, fact less Fact, snowflake and starschemas.
• Worked on SQLServer concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Datamapping, logicaldatamodeling, used SQLqueries to filterdatawithin the Oracle and Sybase.
• Used the AgileScrum methodology to build the different phases of Software development life cycle.
• Performed data mining on data using very complex SQL queries and discovered pattern.
• Involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the reports.
• Successfully Integrateddataacross multiple and high volumes ofdatasources and target applications.
• Mentoring the Team of 13 members on technical issues and providing appropriate design solutions and delegating the individual tasks on a daily basis.
• Extensive experience in Relational and DimensionalData modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN.
• Used extensive SQL fordataprofiling/analysis to provide guidance in building thedatamodel

Environment: Erwin 9x, DB2, Oracle, Information Analyzer, Informatica, MDM, Quality centre, Excel, MS - Word, SQl.

Confidential, Stamford, CT

Lead Data Modeler/Data Analyst

Responsibilities:

• Actively involved in creating Physical and Logical models using Erwin.
• Extensively used complex SQL forDataAnalysis.
• Designed ERdiagrams, logicalmodel (relationship, cardinality, attributes, and, candidate keys) and physicaldatabase (capacity planning, object creation and aggregation strategies) as per business requirements.
• Worked on creating SQL queries and performance tuning of queries
• Developed a Conceptualmodel using Erwin based on requirements analysis.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Developed normalized Logical and Physicaldatabase models to design OLTP system for insurance applications
• Created dimensionalmodel for the reporting system by identifying required dimensions and facts using Erwin.
• Extracted data from various sources like Oracle,Mainframes, flat filesand loaded into the targetNetezzadatabase.
• Mentored a Team of 10 members.
• Worked on data warehousing, ETL, SQL, scripting and big data (MPP + Hadoop).
• Used forward engineering to create a PhysicalDataModel with DDL that best suits the requirements from the LogicalDataModel
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetchdatafrom legacy DB2 and SQLServer database systems.
• Involved with datacleansing/scrubbing and validation.
• Attending weekly governance meetings and providing detailed status report to the client and offshore team etc.
• Extracteddatafrom the databases (Oracle and SQLServer, DB2, FLATFILES) using Informatica to load it into a singledatawarehouse repository.

Environment: PL/SQL, Informatica 9.x, Oracle 11G, Netezza, Aginity, ERWIN data modeler, UNIX, SQL, Oracle10g, DB2, MS Excel, MS Visio, Rational Rose.

Confidential, Buffalo, NY

Sr. Data Analyst/Data Modeler

Responsibilities:

• DataArchitecture, logical and physicalModeling for OLAP systems.
• Normalizing the tables/relationships to arrive at effective RelationalSchemas.
• Identifying the facts&dimensions; grain of fact, aggregate tables for Dimensional Models.
• Developing SnowflakeSchemas by normalizing the dimension tables as appropriate.
• Responsible for designing, testing, deploying, and documenting the data quality procedures and their outputs.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Developed, Implemented & Maintained the Conceptual, Logical&PhysicalDatamodels.
• Involved in extensive DATA validation by writing several complex SQLqueries and Involved in back-end testing and worked with data quality issues.
• Used ERWIN Studio CWErwin tool for modeling logical models.
• Normalizationtechniques to arrive at effective Relational Schemas.
• Involved in capturingdatalineage, table and columndatadefinitions, valid values, and others necessary information in thedatamodels.
• Performance Tuning (DatabaseTuning, SQLTuning, Application/ETLTuning).
• Developed Logical and Physicaldatamodels that capture current state/future statedataelements and dataflows using Erwin / Star Schema.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support using PentahoDataIntegration and SSIS.

Environment: Erwin, Teradata, SQL, Sybase Power Designer 12.5/ 15, Business Objects, Ab Initio, MS office, MS Access.

Confidential, Columbus OH

Sr. Data Analyst/Data Modeler

Responsibilities:

• Performeddataanalysis and profiling of sourcedatato better understand the sources.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Experience using data cleansing techniques, Excelpivottables, formulas, and charts.
• Created SAS datasets by extracting data from Excel, Flat Files.
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Involved in mapping spreadsheets that will provide theDataWarehouseDevelopment (ETL) team with source to targetdatamapping, inclusive of logical names, physical names,datatypes, domain definitions, and corporate meta-datadefinitions.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Performed dataanalysis and dataprofiling using complex SQL on various sources systems including Oracle and Teradata.
• Responsible for different Datamapping activities from Source systems to Teradata
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data.
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model.
• Tuning the Informatica Mappings for optimum performance and scheduling ETL Sessions.
• Conducted several PhysicalDataModel training sessions with the ETLDevelopers. Worked with them on day-to-day basis to resolve any questions on Physical Model.
• Involved in extensive DATAvalidation by writing several complex SQLqueries and Involved in back-end testing and worked with data quality issues.
• Involved in ETL mapping documents indatawarehouse projects.

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

Confidential, Atlanta, GA

Data Analyst/Data Modeler

Responsibilities:

• Performeddataprofiling in the source systems that are required forDataMarts.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems
• Created SQL scripts to finddataquality issues and to identify keys,dataanomalies, anddatavalidation issues.
• Involved in defining the source to targetdatamappings, businessrules, anddatadefinitions.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, RelationalData (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
• 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.
• Involved in Performance Tuning of the database which included creating indexes, optimizing SQL statements & monitoring the server.
• Reverse engineered all the Source Databases using Erwin
• Performed data analysis and dataprofiling using complex SQL on various sources systems including Oracle and Teradata.
• Involved indatawarehouse design.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Useddataanalysis techniques to validate business rules and identified low quality missingdatain the existing Amgen enterprisedatawarehouse (EDW)

Environment: Oracle 9i, MS Access 2003, MS Excel 2003, MS Word 2003, MS Outlook 2003, CA Erwin, Crystal Reports, PowerPoint 2003, SharePoint