SUMMARY

• 7+ years of professional experience in data modeling, business and data analysis, requirements gathering, application and decision support and Data Warehousing for Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Experience of working with different SDLC methodologies like Waterfall and Agile (Scrum, RUP).
• Extensive experience in creating reports for Process Flows, Workflow Analysis, Functional Decomposition Analysis, design User interface(UI) using wireframe/prototype and Unified Modeling Language (UML) Diagrams like Class diagram, Use Case, Swim - lane, ER and Activity, process flow Diagrams using Rational Rose, Microsoft Visio and Gliffy. Help Project lead to make project chart.
• Strong Knowledge of ETL, Business Intelligence and Reporting Architecture.
• Experience in designing ODS architecture by using tools like Erwin, Power Designer, Embarcadero E-R Studio and Microsoft Visio.
• Expertise in the development of Physical Data Model for multiple platforms i.e. SQL Server, DB2, Oracle, Teradata, Netezza.
• Proficient in Normalization (1NF, 2NF, 3NF and BCNF)/ Denormalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Experience working with Zachman framework, Ralph Kimball and Inmon approaches.
• Experience with requirement gathering, conducting Joint Application Development (JAD) and Joint Requirement Planning (JRP) sessions, User Acceptance Testing (UAT), Gap analysis.
• Efficient in analyzing and documenting Business Requirement Documents (BRD) and Functional Requirement Document (FRD) along with Use Case Modeling and UML.
• Experienced in design of Relational and Dimensional Data Modeling using data modeling tools like Erwin data modeler, Embarcadero ER studio, Power Designer and also implementing RDBMS specific features.
• Strong knowledge in Data mapping from source to target database schemas, Data Profiling, Data Cleansing, Data Mining (big data) and programming of data conversion and researching complex data problems.
• Hands on experience on IBM MDM (Master data Management) and identifying the Facts and Dimensions from the Enterprise Architecture for designing Star Schema and Snowflake Schema.
• Strong Database experience using Oracle, DB2, Sybase, Teradata, Netezza PL/SQL, Stored procedures, triggers and cursors.
• Proficient in oracle tools and using utility tools like SQL developer, Toad for Data Analyst.
• Very Good exposure to ETL tools like Informatica, IBM Data Stage and Micro Strategy.
• Building reports using SQL SERVER Reporting Services (SSAR) and SQL Server Analysis Services (SSAS), SAP Crystal Reports and Cognos.
• Experience in using and maintaining Metadata Management Tools for maintaining Business and Technical Metadata.
• Proved excellence in negotiating skills, multi-tasking, people management, project implementation, time management.
• Working knowledge on Release management and Change management.
• Excellent communication skills, self-starter with ability to work with minimal guidance.

TECHNICAL SKILLS

Data Modeling Tools: Erwin r7.1/7.2, Erwin R8, R9, Rational System Architect, IBM Infosphere Datastage, Data Architect ER Studio and Oracle Designer

Project Design & Architecture: MS Visio, Gliffy, Rational Rose and Enterprise Architect 8.0

Business Intelligent/ Reporting Tools: Cognos 8, Business Objects XI, SAP Crystal Reports, Actuate Reports 10,OBIEE, SAS, MS Share Point and MS SSRS.

OLAP Tools: Microsoft Analysis Services, and Crystal Reports 9

ETL Tools: Microsoft DTS/SSIS and Informatica 7.1.3

Programming Languages: SQL, PL/SQL, T-SQL, HTML, CSS, XML, ASP.NET, C++. C #

Debugging/Defect tracking Tool: Bugzilla, Rational Clear Quest, JIRA

Testing Tool: Quick Test Professional (QTP), Quality Center (QC), Load Runner & WinRunner

RDBMS: MS & SQL servers 2000/2005/2008 , Oracle 9g/10g/11g, MS Access 2003/2007/2010 , Teradata, DB2, Netezza, TOAD 9, IBM Data Stage XE 390, Queryman 5/6, Informatica 8, SQL*Plus,TD SQL Assistant.

Wireframe/ Prototype Tools: Rational Requisite pro, Just in mind, Axure RP 6.5, OmniGraffle

Other Tools: VM ware, Toad, Putty

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior Data Modeler

Responsibilities:

• Followed Agile (scrum) methodology for the development throughout the project.
• Interacted with Project Manager and Business Analysts to gather the user requirements and participated in data modeling JAD sessions.
• Developed a Conceptual model using ERWIN based on requirements analysis and developed normalized Logical and Physical database models to design OLTP system.
• Created 3NF business area data modeling with de-normalized physical implementation; data and information requirements analysis
• Created dimensional model for the reporting system by identifying required dimensions and facts using ERWIN.
• Created ER diagrams (Entity - Relationship diagrams) using ERWIN and created logical and physical models as well.
• Used Forward engineering to develop physical model with DDL based on the requirements gathered from a logical model in ERWIN.
• Conducted updates and enhancements to existing data models as required with ERWIN.
• Identified the Facts and Dimensions.
• Used Teradata utilities such as Fast Export, MLOAD for handling various tasks. Used SAP MDM (Master data management) for solution architect.
• Using 3rd NF created metadata collection and validation; standards compliance verification; ODS schema maintenance; database-to-database data type.
• Coordinated with DBAs and generated SQL codes from data models and used DB2 database for retrieving some information data.
• Used SQL Server Reporting Services (SSAR) to generate reports. Hands on experience on Data Mining by using Data mining Wizard in SQL server data tools (SSDT).
• Configured report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Generated scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experienced in generating and documenting Metadata while designing OLTP and OLAP cube system environment.
• Involved in non-transactional data entities of an organization of IBM MDM (Master Data Management) that has the objective of providing processes for collecting, aggregating, matching, consolidating, quality-assurance, persistence and distribution.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables and columns as part of the Source Data Analysis responsibilities.
• Performed legacy application data cleansing, data anomaly resolution and developed cleansing rule sets for ongoing cleansing using IBM data Stage.
• Developed the data warehouse model (Kimball’s) with multiple data marts with conformed dimensions for the proposed central model of the Project.
• Implemented Star Schema methodologies in modeling and designing logical data model into dimensional Models.
• Worked with Database Administrators (DBAs) to finalize the physical properties of the tables such as Partition key, based on volumetric.
• Exposure to implementing Extraction mapping in Informatica (Mapping Designer).

Environment: Oracle 11g, Teadata, SQL Server 2005/2008, DB2, Mainframe DB, Microsoft Transaction Server, Erwin, IBM Data Stage, SAP Crystal Reports, SSAR/SSAS, Informatica power center, MS-SQL server manager, Microsoft Access, OBIEE, XML, HTM, CSS.

Confidential, Detroit, MI

Data/Business Analyst

Responsibilities:

• Generated Agile SCRUM modeling methodologies for modeling and documentation. Interacted with multiple Stakeholders, gathering and analyzing requirements.
• Liaison between the business line, operations, and the technical areas throughout the project cycle at the delivery level.
• Prepared Business Specifications, Functional Specifications, Requirement Traceability Matrices (RTM) with Project manager.
• Organized architectural artifacts using Zachman’s framework.
• Designed and documented Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object Oriented Design) using UML and Visio.
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Used ERWIN’s Forward Engineering tool to create tables and columns.
• Generated DDL statements for the newly generated objects (tables, views, indexes and packages) and used oracle E-Business Suite version 11i.
• Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models
• Worked on the Snow-flaking the dimensions to remove redundancy.
• Used ETL methodology for data extraction, transformations and loading in a complex Enterprise Data Warehouse (EDW) by using Informatica 9.6.
• Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, text, csv files, and SAS datasets and also created enterprise architecture by using SAP Master Data Management tools.
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse content.
• Worked closely with Data Governance team, which worked on end-to-end process and data quality framework for assessing decisions that ensure the suitability of data for its intended purpose.
• Assisted in Data Stage Server jobs to load data from sequential files, flat files and MS Access.
• Used Data Stage Manager for importing metadata from central repository.
• Involved in extracting, cleansing, transforming, integrating, and loading data into different Data Marts using Data Stage Designer.
• Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access, Oracle and Teradata, to connect to existing database and create graphical representation (E-R diagram) using Erwin7.3.
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard and predictive modeling.
• Developed mappings in Informatica Power center 9.6 to load the data from various sources includes SQL server, DB2, Oracle, Flat files into the Data Warehouse, using different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation,Rank Transformations, Expressions, Aggregator, Sequence Generator.
• Associate project manager to conducted User Acceptance Testing (UAT) on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
• Prepared the documentation of Data Acquisition and Interface System Design.

Environment: Teradata, ERWIN 7.3, Informatica Powercenter 9.6, Oracle EBS, Netezza, SQL server, SSAR, MS Excel, MS Visio, Rational Requisite Pro, Data Stage,DB2 UDB, SAP Crystal report, Windows NT, T-SQL.

Confidential, CA

Data Modeler/Business Analyst

Responsibilities:

• Interacted with users and business analysts to gather requirements.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues, and come to an agreement quickly.
• Conducted weekly status meetings with Project Manager, BA and other IT team after collecting status of development progress.
• Played a substantial role in defining processes and in gathering business and functional requirements.
• Created use-case documents and identified preconditions, post conditions, triggers, assumptions, and special requirements of each use case.
• Utilized Requisite Pro for preparing the Business requirements document.
• Analyzed of system requirements and Use cases involved in the product development for writing of Test cases.
• Reverse engineered from Toad database to Power designer and generated SQL script through forward engineer in Power designer.
• Worked along with architecture team to get metadata approved for the new data elements that are added for this project
• Assisted the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes
• Involved in extensive Data Analysis on the Teradata and Oracle Systems querying and writing in SQL and TOAD
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis pertaining to all company products
• Used SQL joins, aggregate functions, analytical functions, group by, order by clauses and interacted with DBA and developers for query optimization and tuning
• Worked on indexes, partitioning and materialized views by interacting with DBA
• Worked with ETL team using SSIS packages, to plan an effective package development process, and design the control flow within the packages
• Interacted with SSRS reporting team to gather reporting requirements, and review summary tables.
• Involved in doing Regression Testing across new builds and releases.
• Recognized source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
• Created Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW). Also involved in Data mining by creating mining structure and models using relational data sources.
• Worked with ETL team to produce PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
• Worked with testing team to performed UAT on the application.

Environment: Erwin, Power designer, Informatica, SSAR, DB2 UDB, SQL Server 2005/2008, SSAS, XML, HTML, Oracle, Toad for Oracle, Rational rose.

Confidential, Bloomington, IL

Data Modeler

Responsibilities:

• Performed source to target mappings for identifying the elements which are useful to the new system from existing system.
• Created Conceptual, Logical, and Physical data models using ER studio for new system
• Reporting claims through an application has some dynamic interview questions for which customers have to fill in the appropriate details in them to finish a claim. Leveraged RIAK as a temporary storage solution in order to store the dynamic interview questions.
• Created Data flow diagrams for current system.
• Developed a data topology based on the data storage, various replications, and movements of data.
• Documented various requirements based on the changes that occur day to day.
• Performed Data Quality analysis to identify the quality of data which is being stored.
• Transform data from source format to target format as expected for internal consumption of data.
• Conducted various high level reviews for the artifacts created.
• Created Technical Mapping documents for the development team to develop mapping workflows.
• Checked for all the modeling standards including naming standards, entity relationships on model and for comments and history in the model. Conducted design walk through with project team and got it signed off.
• Created entity / process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Created Technical Mapping documents for the development team to develop mapping workflows.
• Conducted several meetings with business and systems regarding project.
• Interacted with ETL developers for making them understand the movement of required data.
• Worked with Data architects and IT architects to understand the movement of data and its storage.
• Suggested effective implementation of the applications which are being developed.

Environment: ER studio 8.5, Netezza,DB2,Informartica V 8.6, Microsoft Access, Microsoft Visio, SQL Server 2000, SSAR, MS PowerPoint, MS Access, Lotus Notes, Microsoft Excel.

Confidential

Data Modeler

Responsibilities:

• Gathered and transferred business and functional requirements.
• Interacted with business users and studied available documents/application to understand the requirements.
• Worked with large sets of data to find rate flow trends and patterns, identify and fix data anomalies.
• Used Erwin r7.0 for creating tables using Forward Engineering
• Designed the prototype of the Data mart and documented possible outcome from it for end-user.
• Involved in business process modeling using UML.
• Developed and maintained data dictionary to create metadata reports.
• Identified facts and dimensions and designed the Star Schema.
• Designed logical/ physical model using Erwin data modeler for SQL Server database platform.
• Cleansed, extracted and analyzed business data on daily basis and prepared ad-hoc analytical reports using Excel and T-SQL.
• Done SQL Server configuration database size estimation, database creation logins & user’s creation, granting object level permission, estimation of indexes on tables.
• Helped ETL team in understanding the complex transformation rules and creating ETL maps.
• Developed Data Mapping, Data Governance, and Transformation and Cleansing rules.
• Involved with reporting team to generate ad-hoc reports using SAP Crystal Reports 9.

Environment: Erwin r7.1, SQL Server 2000/2005, Windows NT, MSVisio, XML, Crystal Reports 9.

Confidential

SQL Developer/Data Modeler

Responsibilities:

• Involved in the entire System study, analysis and Design.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Associate with Project lead to make project charter and dashboard.Involved in the analysis of how the purchase order process was organized.
• Created SQL tables with referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL.
• Involved in writing Triggers which internally called procedures and functions.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Involved in documenting the entire technical process.
• Supported technical teams involved with ORACLE issues and operations.
• Involved in the maintenance of the database.

Environment: Oracle 8.0, Oracle Designer, UNIX.