SUMMARY

• Around 8+ years of expertise in Data Modeling, Data Analysis for Online Transaction Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Dimensional Data Modeling, Building Star and Snowflake schemas, OLAP tools.
• Expert in using Erwin 7.0s tool, worked extensively on ERwin in several projects in both OLAP and OLTP applications.
• Knowledge of data modeling like ERStudio 8.5, Power Designer 15.0
• Experienced in Normalization/Denormalization techniques for optimum performance in OLTP and OLAP environments
• Experience in using Accurev tool for promotion of scripts.
• Knowledge and experience in the Oracle development tool set (Including PL/SQL, SQL*Plus, SQL Loader)
• Worked with various RDBMS like Oracle 11g, SQL 2008, DB2, and Teradata.
• Proficient in creating Conceptual, Logical and Physical Data models as per the client project requirements
• Expertise in ETL tools like Informatica and SSIS; Created source to target mapping documents for the ETL developers and helped them understand complex transformations involving business input.
• Hands on experience with creating cubes using SQL Server 2005 Analysis services and development of reports using SQL Server Reporting Services (SSRS)
• Successfully managed technical teams and gained broad expertise in mission and requirement’s analysis and process modeling (JAD) structured development methodologies.
• Excellent analytical skills and problem solving techniques as a data modeler
• Experience with gathering business requirement and requirements analysis
• Extensive experience in analyzing and documenting business requirements and working with business analysts.
• Exceptional communication and presentation skills and established track record of client interactions

TECHNICAL SKILLS

Operating Systems: HP - UX 11.11, RH Linux 7.1/8/AS 3.0, IBM-AIX, 5.6/5.7,Windows 2003 / XP / 2000 / NT 4.0

RDBMS: Oracle 10g / 9i / 8i, SQL Server 2005/2000/2008 , Sybase ASE 12.0/12.5,MySQL 4.x/5.x, MS-Access 2000, Teradata

Business Tools: Rational Suite, MS Visio, Crystal Report, MS Project

Languages: C, C++, Java Script, VB Script, VB.NET, ASP.NET, HTML, XML, SQL, PL/SQL

Tools: ERwin, Oracle Designer 2000, Sybase Power Designer, BPwin, Rational Rose, MS Visio, ER Studio

Management: Clear Case, Perforce, CVS, VSS, Model Mart

Others: MSOffice 2007,2010 (Word, Excel, PowerPoint, Access), MS Project, XML

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, Washington

Data Architect / Data Analyst

Responsibilities:

• Translate enterprise or business requirements into long-termdataarchitecture solutions including conceptual, logical and physical models.
• Gathering of Data, Business Rules, Transformation rules, statistical models supporting campaign identification and suppression target populations
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data in both Type1 and Type2 Dimensional Models.
• Define and clarify solution scope and objectives through research and analysis.
• Responsible for transforming requirements into architecture and design documents that was used by the team to implement solutions.
• Document all technical requirements and design technical solutions utilizing enterprise architecture standards including documenting all solution components and configurations.
• Design and build appropriate datarepositories anddatamovements (dimensional databases) to ensure that business needs are met.
• Work closely with business team and clients to resolve data and performance issues.
• Design and review logical and physicaldatamodels for OLTP and OLAP in compliance with corporate standards.
• Work with IT ETL and Report Developers to communicate database designs
• Design and oversee the implementation ofdatatransformation and change processing procedures to ensure thatdatafrom multiple sources is aggregated, normalized and updated and then published to multiple target environments
• Work with functional analysts, developers and development managers to ensure that all solutions are deployed within agreed timelines and supported after delivery.
• AppliedInformaticaData Quality standards, guidelines and best practices on the various sources.
• Understand existing DQ landscape to provide key insights on the scope and magnitude of DQ issues and supporting Processes and procedures.
• Identified theBottlenecks, Removed the Bottlenecksandimplemented performance tuning logicon targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Exported the valid and invalid documents to data stewards and business analyst to understand the data.
• Applied data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities in IDQ (Informatica Data Quality)
• Cleansed, standardized, labeled and fix the data gaps in IDQ where it checks with tables to fix major business issues.
• Performed tuning of Informatica Mappings and sessions for optimum performance.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
• Analysis of production issues and designed the detailed solution.
• Performed performance tuning at functional and map level for better production performance.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables and relational connections.
• Used Debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.
• Used various transformations like expression, transaction control, aggregator, Router, Unconnected Lookup, Filter, and Sorter.
• Created new mapping design using various tools in Informatica designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Involved in extracting the data from flat files and relational databases into staging area.
• Prepared Technical design documents and test cases and also performed unit testing.
• Extensively worked on SQL server and developed complex T-SQL Queries Implementation of Scrum methodologies/ SDLC framework to support the efficient development of project.

Environment: Teradata, Oracle 10g, DB2, Erwin, ER Studio, Power Designer, Accurev, MS Visio, SQL, PL/SQL, ODBC, HTML, TOAD, SQL * LOADER, UNIX, MS OFFICE.

Confidential, Tampa, FL

Data Architect

Responsibilities:

• Gather the various reporting requirement from the business analysts.
• Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
• Reverse Engineering, using Erwin, the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schemas for the detailed data marts and Plan data marts involving shared dimensions (Conformed) ;
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models;
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
• Worked Closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic
• Create ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server usingSSIS,
• Create and load Staging and Dimensional databases usingSSIS,
• Create and deploy UDM Cubes for Sales Analysis using SQL Server Analysis Services.
• Create and deploy reports using SSRS.

Environment: Teradata, Oracle 10g, SQL Server 2008, Unix,, Erwin 7.2,SAP Power Designer V12, XML, Microsoft Access, Microsoft Excel

Confidential, Plano, TX

Data Modeler

Responsibilities:

• Working with the Business Analyst and DBA, conducting team meetings and JAD sessions for technical requirements gathering, business analysis, testing and project coordination
• Analyze and evaluate existing system for assessing how it supported functions from the Use Case diagrams and UML diagrams
• Developed Logical data model using Erwin 7.2 and created physical data models using forward engineering
• 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.2
• Participate in updating the dimensional model, and identify the Facts and Dimensions
• Employed process and data analysis to model a Customer Information Business System.
• Produced functional decomposition diagrams and defined logical data model.
• Coordinated with ETL team for analysis and reporting needs.
• Developed data migration strategies and impact analysis for database
• Design, plan and program data conversion procedures from old to new databases
• Responsible for data lineage, maintaining data dictionary, naming standards and data quality
• Model a database to store customer demographic and other data.
• Work with Business analyst to design weekly reports using a combination of Cognos Impromptu and Power play multidimensional, to deliver reports to CEL and Marketing groups.
• Design complex reports like aging analysis, invoices generation, profit/loss, balance sheet etc.
• Involved in design and development of standard and ad-hoc reporting using SQL
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to in corporate the new calculations.
• Involved in overall data mart testing and different team review meetings.

Environment: Erwin 7.2, Oracle 10g, SQL, Unix, Erwin 7.2, XML, Microsoft Access, Microsoft Excel Project 2000, UNIX, and SQL

Confidential, Bethlehem, PA

Data Modeler

Responsibilities:

• Responsible for migrating the data and data models from SQL server environment to Oracle 10G environment.
• Designed Data Flow Models for better communicate the design to the business users.
• Responsible for Relational data modeling(OLTP) using ERwin (Logical and Physical) and MS Visio (Conceptual)
• Worked with ERwin model mart.
• Analyzing source data sets to capture Meta Data, Data Formats and Data Types
• Also responsible for creating, documenting and maintaining the metadata.
• Reviewed the existing database to propose necessary changes.
• Responsible for logical and physical modeling as per business requirements using ERwin
• Responsible for physical modeling as per database and performance requirements
• Interacted with the business team to clarify the requirements
• Responsible for oversight of the Data Architecture and Data models.
• Responsible for profiling source data
• Participated in High Level Detail design ETL review
• Created Source to Target mappings and Transformations using Informatica PowerCenter.
• Was responsible for designing the Workflows using Informatica Workflow Manager.
• Modeled data preparation layer or landing layer accordingly to match source data structures
• Responsible for maintaining the data mapping document.
• Analyzed source system data to identify gaps
• Extensively worked on the naming standards which incorporated the enterprise data modeling standards and generated reports to verify the model against the pre-defined enterprise standards
• Designed the physical model for implementing the model in to Oracle 10G physical data base.

Environment: Erwin 7.2., Data Stage, SQL Server 2005, Oracle 10g, MS Office, Lotus Notes, MS Visio, ER Studio.

Confidential, Tucson, AZ

Data Modeler

Responsibilities:

• Utilized Reverse Engineering feature to map the ER diagram for the existing database using Erwin
• Designed a Star Schema based Data warehouse model to accomplish building the central Data warehouse
• Developed the central repository, populated the metadata and also maintained the proper working of the system
• Comprehended the existing data model and recognized design for improved performance of the system and documented it
• Trained two team Members to use Erwin
• Arranged brain storming sessions with project focus groups
• Identified KPI(Key Performance Indicators) for decision support making use of aggregator stages

Environment: DB2, MS Access, Erwin 4.0,Windows NT, Informatica Power Center/Power Mart, MS Visio, MS Office