SUMMARY:

• Over 8+ years of IT professional experience with strong background in Data base development, Data analysis and designing ofdatamodels for different domains.
• Strong Knowledge of SDLC methodology including analysis, design, development, testing and maintenance.
• Experienced as a Data Analyst and Data Modeler with solid understanding of Business Requirements Gathering, Business Process Mapping Evaluating Data Sources, Data Mapping, Translating Requirements into Specifications, Application Design.
• A good experience in Developing Data governance model and standard operating procedures to manage over 10,000 data elements being tracked by dashboards
• A Good experience in Data Warehousing and in OLTP systems.
• Exert in building Enterprise Data Warehouse or Data warehouse appliances from Scratch using both Kimball and Inmon Approach.
• Expertise in creating DDL scripts for implementing Data Modeling changes.
• Expertise in Creating ERWIN reports in HTML, RTFformat depending upon the requirement, Published Data model in model mart, created naming convention files, co - coordinated with DBAs' to apply the data model changes.
• Expertise in 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 Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/ Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing Erwin diagrams, analyzing data sources and creating interface documents.
• Expertise in SQL Performance Tuning and Optimization (Design, Memory, Application, IO) and using Explain plan, Tracing and TKPROF.
• Extensive experience on forward and reverse engineering processes using tools like Erwin.
• Expertise in creating DDL scripts for implementing Data Modeling changes.
• Experienced in generating and documenting Metadata, while designing OLTP, ODS and OLAP systems environment.
• Excellent knowledge in SQL and coding PL/SQL Packages, Procedures.
• Worked on different platforms such as Windows 8/windows7/XP and UNIX, Sun Solaris, AIX, HP
• Experienced on SAP modules using Business Objects / Crystal Reports based upon business requirements.
• Experienced in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.

TECHNICAL SKILLS:

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

DataAnalysis: 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, Little Rock, AR

Sr. Data Analyst/Data Modeler

Responsibilities:

• Involved in data analysis and creating data mapping documents to capture source to target transformation rules.
• Create logical and physical data models using Erwin to meet the needs of the organization's information systems and business requirements.
• Used Erwin to transform data requirements into data models.
• Utilized SQL server's reporting services SSRS and SSIS to support reporting requirements.
• Performed extensive task which include Data Quality Analysis, Data lineage and Data Standardization data structures, data base design, data warehouses, business intelligence/analytic tools, SQL, ETL tools, and data integration methods.
• 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 SQL Server concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Datamapping, logical data modeling, used SQL queries to filter data with in the Oracle and Sybase.
• Used the Agile Scrum methodology to build the different phases of Software development life cycle.
• Performed data mining on data using very complex SQL queries and discovered pattern.
• Successfully Integrated data across multiple and high volumes of data sources and target applications.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN.
• Used extensive SQL for data profiling/analysis to provide guidance in building the data model

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

Confidential, Shelton, CT

Sr. Data Analyst/Data Modeler

Responsibilities:

• Actively involved in creating Physical and Logical models using Erwin.
• Extensively used complex SQL for DataAnalysis.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Worked on creating SQL queries and performance tuning of queries
• Developed a Conceptual model 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 Physical data base models to design OFFLTP system for different applications
• Created dimensional model 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 target Netezza database.
• Worked on data warehousing, ETL, SQL, scripting and big data (MPP + Hadoop).
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the LogicalDataModel
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
• Involved with data cleansing/scrubbing and validation.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLATFILES) using Informatica to load it into a single data warehouse repository.

Environment: PL/SQL, Informatica, Oracle 11G, Netezza, ERWIN, UNIX, SQL, DB2, MS Excel, MS Visio, Rational Rose.

Confidential, Buffalo, NY

Sr. Data Analyst/Data Modeler

Responsibilities:

• Worked on dataArchitecture, logical and physical Modeling for OLAP systems.
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Developed Snowflake Schemas 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 SQL queries and Involved in back-end testing and worked with data quality issues.
• Used ERWIN Studio CW Erwin tool for modeling logical models.
• Normalization techniques to arrive at effective Relational Schemas.
• Involved in capturingdatalineage, table and columndatadefinitions, valid values, and others necessary information in thedatamodels.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• 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 Pentaho Data Integration and SSIS.

Environment: Erwin, Teradata, SQL, Business Objects, Oracle, 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.
• 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 spread sheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping, inclusive of logical names, physical names,datatypes, domain definitions, and corporate meta-data definitions.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Responsible for different Data mapping 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 Physical Data Model sessions with the ETL Developers. Worked with them on day-to-day basis to resolve any questions on Physical Model.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in ETL mapping documents in data warehouse projects.

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

Confidential, Baltimore, MD

Data Analyst

Responsibilities:

• Performed data profiling in the source systems that are required for Data Marts.
• Performed data analysis and data profiling using complex SQL on various sources systems
• Created SQL scripts to find data quality issues and to identify keys,data anomalies, andd ata validation issues.
• Involved in defining the source to target data mappings, business rules, and data definitions.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (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
• Involved in data warehouse design.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Used data analysis techniques to validate business rules and identified low quality missing data in the existing Amgen enterprise data warehouse (EDW)

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