SUMMARY

• Around 8 years of professional experience in Data Analysis as a Proficient in gathering business requirements and handling requirements management.
• Solid experience in customer communication, requirement analysis, dataprofiling, datamodeling, understanding technical architecture, ETL architecture and data analysis.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML)
• Extensive working experience in ER Modeling and also Dimensional Modeling (Star & Snow - flake)
• Good experience with Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for improved database performance in OLTP and DataWarehouse /DataMart environments.
• Working experience in developing data-marts, operational and analytical environments
• Developed Source to target mapping to loaddatain slowly changing dimensions
• Good Experience in Teradata Enterprise Data Warehouse (EDW) and Data Mart.
• Good experience with Normalization (1NF, 2NF and 3NF) and De-normalization techniques for improved database performance in OLTP, OLAP,Data Warehouse and DataMart environments.
• Extensively worked source systems like Oracle, Teradata, Access, Flat files, XML and Mainframe.
• Expert in writing SQL queries and optimizing the queries in Oracle, Netezza and TeradataV2R6/R12/R13.
• Strong understanding of KPI's, data relationships, reporting schemas, data transformations
• Solid Experience in data analysis and problem solving with large amounts of data
• Solid Experience in data architecture, data warehousing, master data management, enterprise information integration and ETL.
• Excellent experience with data analysis, modeling and design specific to a data warehouse
• Expertise in Data Cleansing and Data Profiling based on standards.
• Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin, Power Designer and ER Studio Data modeling tools.
• Worked expansively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
• Created ERWIN reports in HTML, RTF format depending upon the requirement, published Datamodel in model mart, created naming convention files, co-coordinated with DBAs to apply the datamodel changes.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.

TECHNICAL SKILLS

Data Warehousing: Informatica 9.5/9.1/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, Web Intelligence

Reporting Tools: Business Objects6.5, XIR2, Tableau, Tibco spotfire

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, 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

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

Sr. Data Analyst/Data Modeler

Responsibilities:

• Conducted datamodeling working sessions to gather requirements, validate datasources, identify datarules and drive consensus on various subject areas.
• Responsible for supporting analytic initiatives requiringdatamining, detailed statistical analysis, and light development and automation.
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
• Processing complex, large scaledatasets used for modeling,datamining, and research Designing and implementing statisticaldataquality procedures for newdatasources
• Worked extensively with the DataWarehouse team to Design, Develop, Enhance and maintain its systems.
• Create and maintained Metadata, including table, column definitions
• Developed Conceptual, Logical and Physical datamodels for central model consolidation.
• Developed 3-NF and dimensional datamodels to support an enterprise DataWarehouse initiative. The dimensional model included Customer and Product related dimensions.
• Conducted datamodeling JAD sessions and communicated data-related standards.
• Designed and Developed logical & physical datamodels and MetaDatato support the requirements using Erwin
• Used TIBCO Collaborative Information Manager (MDM) application to understand customerdata source,datarules and used that for developing the Customer Dimension for the datawarehouse.
• 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
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using Erwin

Environment: Oracle 11g, Microsoft 2008, SQL Developer, SQL Manager, ER Studio, SQL Developer DataModeler, Visio, OracleDataIntegrator(ODI), SAP Business Objects, Informatica, Crystal Reports

Confidential, Jersey City, NJ

Sr. Data Analyst/Data Modeler

Responsibilities:

• Created ETL Mappings, Sessions, Workflows, Worklets and Maplets in Informatica.
• Worked on data analysis,dataprofiling,datamodeling,datamapping and testing for a given task
• Involved in designing Datamarts by using Star Schema and Snowflake schema.
• Closely worked with ETL process development team.
• Extensively used Erwin as the main tool for modeling along with Visio
• Worked in an agile environment and used JIRA Agile which is an agile project management tool for software development teams.
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization,dataextraction,datacleansing,datamanipulation
• Demonstrated the capabilities of Rational Software Architect product by using it to generate UML diagrams from WSDLs anddatamodels.
• Created and implemented ER models and dimensional models (star schemas)
• Collaborate with unit managers, end users, development staff, and other stakeholders to integrate datamining results with existing systems.

Environment: Power Designer 12.0, Teradata, Oracle11g, SSIS, Informatica Power Center, Crystal Reports 9

Confidential, New York, NY

Sr. Data Analyst / Data Modeler/Data Architect

Responsibilities:

• Used and supported database applications and tools for extraction, transformation and analysis of raw data
• Understood business processes, data entities, data producers, and data dependencies
• Developed, managed and validated existing data models including logical and physical models of the data warehouse and source systems utilizing a 3NF model
• Developed and programmed test scripts to identify and manage data inconsistencies and testing of ETL processes
• 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
• 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 and Netezza.
• Written several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• 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.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Flexible to work late hours to coordinate with offshore team.

Environment: - Oracle 10g, MS office, Business Objects, Clear Quest, Clear Case, Netezza

Confidential, Atlanta, GA

Sr. Data Analyst

Responsibilities:

• Physical implementation of logical models on Teradata, DB2, Green Plum, SQL server and Oracle platforms.
• Worked on building up a SQL query for extraction ofdatafrom the warehouse for a reporting schedule(Call Report) for Federal Government
• Ensured accuracy and level of information supporting business requirements, as well as subsequent development activities comparingdataloads between new EDW (Enterprise Data Warehouse) production systems and retiring system.
• Created and implemented the OLTPdatamodels.
• Create stored procedures/macros to handle performance of database and to separate server side functions from the client side.
• Conducted GAP analysis anddatamapping to derive requirements for existing systems enhancements for a project.
• Defined enterprise datalocation architectures for ODS, DataMart, and DataWarehouse data.
• Worked in the Waterfall SDLC methodology process.
• Worked on two sources to bring in required data needed for reporting for a project by writing SQL extracts
• 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.
• Designing and customizingdatamodels forDatawarehouse supportingdatafrom multiple sources on real time

Environment: AllFusion Erwin 4.1, Power Designer, ER/ Studio, Informatica Power Center 7.1.1, 7.1.4, Oracle 9i / 10g, DB2, SQL Plus/ PLSQL, Perl, Teradata 12, Quick Test Pro 6.0,, UNIX, AS/400.

Confidential, Freemont, CA

Data Analyst

Responsibilities:

• Developed Data Mapping,Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Developed SQL Queries to fetch complex datafrom different tables in remote databases using joins, database links and Bulk collects.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Analyzed, developed, documented, and communicated architectures/designs using UML for large scale full life cycle projects of on online reporting system. Conceptual modeling using use cases and UML design and E-R models.
• Developed Conceptual, Logical and Physical datamodels for Central Model consolidation.
• Design and govern dataservices messaging constructs in XSD format.
• Created logicaldatamodel from the conceptual model and it's conversion into the physical database design using ERwin
• Developed normalized Logical and Physical database models to design OLTP system for banking applications.
• Worked with report developers for building OLAP CUBEs for ad hoc reporting.

Environment: s: ERWIN r7.3, DB2 Version 9.0, Teradata 6.2, Oracle 10g, Microsoft Visio.