SUMMARY:

• Over 8 years of IT experience as a retional DataAnalyst,DataWarehouse, DataModeler andDataProfiler.
• Extensively worked on source systems like Oracle, Teradata, Netezza, Access, Flat files, XML and Mainframe.
• Solid Software Development Life Cycle (SDLC) experience including Requirements and Specifications Analysis/Design
• Solid Experience in OLTP/OLAP system study, Analysis and modeling, developingdatawarehouse schemas like Star and Snowflake Schema used in dimensional and multi - dimensional modeling.
• Solid experience in customer communication, requirement analysis,dataprofiling,datamodeling, understanding technical architecture, ETL architecture anddataanalysis.
• Good Experience inDatamodeling using Erwin & PowerDesigner, logical and physicaldata model
• Good Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL
• Good Experience designingdatamodels for Sql, Oracle 10g, Oracle 11g, Netezza and Teradata database technologies.
• Strong understanding knowledge ofDataModeling concepts, Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and LogicalDataModels
• Good working Experience in Conceptual, Logical and Physical Modeling techniques
• Excellent experience with Normalization (1NF, 2NF, 3NF and BCNF) and De-normalization techniques for improved database performance in OLTP andDataWarehouse/DataMart environments.
• Hands-on experience indatawarehouse design,datamodeling and database administration activities
• Expertise inDataCleansing andDataProfiling based on standards.
• Excellent experience in ER Modeling and also Dimensional Modeling (Star & Snow-flake)
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Ab Initio, Data Stage and Informatica PowerCenter
• Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Experience in automating and scheduling the Informatica jobs using UNIX shell scripting configuring Korn-jobs for Informatica sessions.
• Excellent knowledge on creating reports on SAP Business Objects, Webi reports, Tableau for various types of reports.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Strong experience in using ER modeling tools such as ERwin and ER/Studio.

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.1/9.5/8.6/7.1.2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS, IDE, IDQ, Data Cleansing, data profiling, Data Stage 8.x, SAP Business ObjectsXIR3.1/XIR2, Talend, Web Intelligence

Reporting Tools: Business Objects6.5, XIR2, TableauData Modeling Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Relational data modeling, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

RDBMS: Oracle 11g/10g/9i/8i/7.x, MS SQL Server, Tomcat, UDB DB2 9.x, Teradata V2R6/R12/R13, MS Access 7.0

Programming: SQL, PL/SQL, MySQL, UNIX Shell Scripting, VB Script, SAS 9.2 and 9.3, Java

Environment: Windows (95, 98, 2000, NT, XP), UNIX

Other Tools: TOAD, MS-Office suite (Word, Excel, Project and Outlook), BTEQ, weblogic, Teradata V2R6/R12/R13 SQL Assistant

WORK EXPERIENCE:

Confidential, Gardner, KS

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Processing complex, large scaledatasets used for modeling,datamining, and research Designing and implementing statisticaldataquality procedures for newdatasources
• DataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData,DataDefinitions and DataFormats
• Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Responsible for supporting analytic initiatives requiringdatamining, detailed statistical analysis, and light development and automation
• Designed and Developed logical & physicaldatamodels and MetaDatato support the requirements using Erwin
• Provide some ad hoc profiling using SQL queries on DB2 to Business
• Participated in meetings with Technical and Business SME's and provided solutions in various aspects
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Created data masking mappings to mask the sensitive data between production and test environment.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g and Teradata
• Participated inDataValidation discussions withDataArchitects
• Understand theDatamodel of the various source systems used which uses Customer dataand interacts with MDM
• Designed the ER diagrams, logical model and physical database for Oracle and Teradata as per business requirements using Erwin
• Created SQL scripts to finddataquality issues and to identify keys,dataanomalies, anddata validation issues

Environment: Oracle 11g, ER Studio, SQL Developer, DataModeler, Visio,SAP Business Objects, Informatica, Crystal Reports

Confidential, Bronx, NY

Sr. Data Analyst/Data Modeler

Responsibilities:

• Use MS Access to link SQL servers and create, maintain, and develop queries
• ImplementedDataModel using Erwin 8.2
• Performeddataprofiling in the source systems that are required forDataMarts
• Extensively used Erwin as the main tool for modeling along with Visio
• Developed Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes
• Useddataanalysis techniques to validate business rules and identified low quality missingdatain the existing Amgen enterprisedatawarehouse (EDW)
• Comprehensive knowledge and experience in process improvement, normalization/denormalization,dataextraction,datacleansing,datamanipulation
• Designed Logical and physicalDatamodeland worked with DBAs for physical implementation in database
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data mining on data using very complex SQL queries and discovered patterns and projections.
• Worked as SME for the project to explain the end to enddataflow with business requirement to development team
• Developed a thorough knowledge by working on Full Life Cycle of the Software Development Life Cycle (SDLC) phases namely Analysis, Design, Coding and Testing

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

Confidential, Colorado Springs, CO

Sr. Data Analyst

Responsibilities:

• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Worked hands-on with the Enterprise Data Warehouse (EDW).
• Involved with Design and Development team to implement the requirements.
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Worked with data source systems and Client systems to identify data issues, data gaps, identified and recommended solutions.
• Performed data modeling and data analysis as required.
• Worked on database features and objects such as partitioning, change data capture, indexes, views, indexed views to develop optimal physical data model
• 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
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Designed and developed Business Intelligence dashboards/workbooks in Tableau
• Created of SQL/HQL queries that are efficient, precise and easily modifiable
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Worked on Teradata and Oracle to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Windows XP, Informatica Power Center 6.1/7.1, QTP 9.2, Test Director 7.x, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting

Confidential, Buffalo, NY

Sr. Data Analyst/Data Modeler

Responsibilities:

• Identified Objects and relationships between objects to develop Conceptual, Logical and Physical model in Erwin tool and later translated model into physical model using Forward Engineering technique in Erwin tool.
• Created and implemented the OLTPdatamodels.
• Analysis of functional and non-functional categorized data elements for Data Migration, data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Experience developing data transformation and cleansing rules for migration using ETL tools
• Identify/analyze business requirements from documents and end-user discussions which involved review of Service Oriented Architecture (SOA) and design ofdatamodels which include staging in datawarehouse.
• Worked on daily basis with leadDataWarehouse developers to evaluate impact on current implementation, redesign of all ETL logic
• Reduce bandwidth and execution time and also applying conditional logic, stored procedures are introduced in respected DBMS.
• Wrote 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
• Conducted JAD sessions, design discussions and SOS meetings to impart appropriatedatamart.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems
• Defined enterprisedatalocation architectures for ODS, DataMart, andDataWarehousedata.
• Applieddatacleansing/datascrubbing techniques to ensure consistency amongstdatasets.

Environment: ER Studio, DataStage, Microsoft SQL Server 2008,IBMDataStudio, Oracle RAC 11g, IBM DB2, Business Objects XI 3.1,pgAdmin III, DbVisualizer 8.0.10

Confidential

Data Analyst

Responsibilities:

• Developed DimensionalDataModels (Star Schema) to support the Risk Warehouse and MIS Reporting of Risk Analytics, in addition to logical and physical models to support end-to-end development.
• Extensively designeddatamapping and filtering, consolidation, cleansing, integration, ETL, and customization ofdatamart
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• 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, XML and RDBMS tables to target tables.
• Responsible for different Data mapping activities from Source systems to EDW, ODS & data marts.
• 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, and Relational Data from various heterogeneous data sources.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Worked on daily basis with the main frame team and leaddatawarehouse developers to evaluate impact on current implementation
• Extracteddatafrom the databases (Oracle and SQL Server) using Informatica to load it into a single datawarehouse repository of Teradata
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements
• Worked with report developers for building OLAP CUBEs for ad hoc reporting.

Environment: MS Office 2007, MS Visio 2003, Windows XP, AFS, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQL Server, Erwin, Business Objects, MS Outlook