SUMMARY:

• Skilled I.T professional with 6+ years of expertise in Data Modeling, Data Analysis for Online Transaction Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications. Experience in Pharmaceutical, Financial, Telecommunication, Healthcare and Banking sectors.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Datawarehousing environments.
• Dimensional Data Modeling, Building Star and Snowflake schemas, OLAP tools.
• Expert in using Erwin 7.0s tool, worked extensively on ERwin and Powerdesigner in several projects in both OLAP and OLTP applications.
• Experience in data modeling tools like ERStudio 8.5, Power Designer 15.0
• Experienced in Normalization/Denormalization techniques for optimum performance in OLTP and OLAP environments
• 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
• Proficient in creating Conceptual, Logical and Physical Data models as per the client project requirements
• Expertise in ETL tools like Informatica, Business Object and SSIS; Created source to target mapping documents for the ETL developers and helped them understand complex transformations involving business input.
• Experience with Teradata utilities such as Fast Export, MLOAD for handling various tasks
• 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.
• Knowledge and experience of designing and implementing dashboards using various reporting tools like idashboards, SSRS and Business Object
• Knowledge and experience with slowly changing dimensions
• Exposure and knowledge to performance tuning using Oracle and SQL servers
• 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, Sun Solaris 7/8/9, 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/7, Sybase ASE 12.0/12.5,MySQL 4.x/5.x, MS-Access 2000 Business Tools: Rational Suite, MS Visio, Crystal Report, MS Project

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

Tools: Oracle Designer 2000, Embarcardero ER Studio 6.6,9, ERWin4-7s, Embarcardero DBArtisans 5.4, Embarcardero Rapid SQL, Toad, SQL Navigator, Informatica 6.x/7.xEmbarcadero DT/Studio 2.3/3.0, Power Designer 15.0

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

Other: MSOffice 2007 (Word, Excel, PowerPoint, Access), MS Project, XML, XSLT, Rational Rose, UML

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Data Analyst

Responsibilities:

• Gather the various reporting requirement from the business analysts/sourcing teams.
• Involved with integration team to implement mapping for new elements being added to the data warehouse forward Engineering, using Power Designer, the reports and identified the Data Elements (in the source systems. added elements from main frame system to sourcing layer using Power Designer(Physical model)
• Conduct Design discussions and meetings to come out with the appropriate design for the data warehouse
• Conducted meeting with the business and the DSO’s to understand business requirements if the requirements were not implemented correctly in the data warehouse
• Conducted data analysis on source and target data to understand problem/PAC ticket/issues in the data warehouse(MIDE)
• Conduct Design reviews with the integration analysts and data modelers to create a proof of concept.
• Ensured the feasibility of the physical design models by doing model walk through with data modelers and
• ETL team
• Performed data analysis in order to fix issues in the data warehouse
• Worked on Production support to resolve production issues.
• Worked on re-mapping existing table to resolve issue as well as worked new mappings for new design being implemented.
• Worked with the integration team to ensure a smooth transition from the design to the implementation phase
• Worked Closely with the ETL Developers to explain the complex Data Transformation using Logic
• Created DFD to track changes and implement work flow diagrams to be used by the ETL

Environment: Teradata SQL Assist, Oracle 10g, Windows XP Data, Informatica, Cognos PowerPlay 7.2,Power designer 15, XML, Microsoft Access, Microsoft Excel, Sharepoint, Ab-Initio, PAC2000

Confidential

Data Modeler/ Data Analyst

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
• f 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 using SSIS,
• Create and load Staging and Dimensional databases using SSIS,
• Create and deploy UDM Cubes for Sales Analysis using SQL Server Analysis Services.
• Create and evaluate reports and dashboards using SSRS and Idashboards.
• Exposed to several other Idashboards products like dashboards

Environment: Teradata SQL Assistant, PowerDEsigner 15, PAC 2000, AB-Initio, Sharepoint, Microsoft

Confidential

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
• Used BTEQ for SQL queries, and TPump for loading data from source into teradata tables
• Used teradata utilities such as Fast Export, MLOAD for handling various tasks
• 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, and balance sheet using
• SSRS and Business Object.
• Involved in design and development of standard and ad-hoc reporting using SQL
• Involved in performance tuning procedures to improve efficiency of data retrieval s
• 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,11g, SQL server 2008, Unix, Data Flux, Business Object, Cognos

Confidential

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, .NET, J2EE, Business Objects XI, MS

Confidential

Data Modeler

Description

• Smart Strategy System (SSS): The Goal of the project was to build an enhanced data warehouse and reporting application to monitor Qwest’s activities. The Business Objects report generator provides Qwest with an overview
• f all product areas. The data warehouse built resulted in a drastic drop in IT costs and provided better information to make better decisions
• 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
• Performed data cleansing using PERL scripts and using the Informatica tool
• Comprehended the existing data model and recognized design for improved performance of the system and documented it
• Generated reports using Business Object to ensure the database to function properly
• Trained two team Members to use Power Designer 15.0
• 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, PowerDesigner 15.0 (Sybase),Windows NT, Informatica Power Center/

Confidential

Database/ Reports Developer

Responsibilities:

• Developed Stored procedures and Triggers working closely developers, Business Analysts, stake holders to generate audit reports and troubleshoot query and connectivity problems
• Designed the Logical and Physical design and developed the main Relational database
• Installed and configured SQL server
• Created Stored Procedures, Triggers, Views by identifying the needs, interacting with developers, business analysts and end users
• Developed Scripts for data validation

Environment: SQL server, Erwin 2.5, Windows NT, Crystal Reports

Confidential

 Database Developer/ Quality Assurance

Responsibilities:

• Updating database, keep track of billing transactions, develop website
• Computerized all hand book on to tally for a manufacturing plant(automobile components)
• Created a database for over 500 clients associated with the company using Oracle
• Trained 15 people on Tally(bookkeeping) software
• Trained manager to update, manipulate and edit the data base using Oracle
• Overlooked the manufacturing aspect for the company for quality control
• Worked closely with the owner of the company to deploy company’s website
• Coordinated and enforced scheduling policies to increase efficiency
• Streamlined/developed finished product packaging effectively by emphasizing on quality check to increase markets and sales
• Completed all production and marketing related tasks requested by the General Manager/Owner