SUMMARY

• Skilled I.T professional with 7+ years of exposure in Data Modeling/ Data Analysis with 2+ years of extensive managerial and overall handling of jobs experience in Governmental, Financial, Telecommunication, Healthcare, Hospitality and Banking sectors.
• Over SEVEN years of strong experience in Data Modeling, Data Analysis for Online Transaction Processing (OLTP)/(OLAP) Online Analysis Processing, Design, Development, Testing and Maintenance of various Data Warehousing and Business Intelligence (BI) applications in complex Business environments.
• Strong experience in Data modeling - Conceptual, Logical/Physical, Relational and Multi-dimensional modeling, Data analysis for Decision Support Systems (DSS), Data Transformation (ETL) and Reporting.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Strong Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Strong working experience in Extract/Transform/Load (ETL) design and implementation. Experience with Teradata utilities such as Fast Export, MLOAD for handling various tasks.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Good working knowledge of building Reports using standard industry Reporting tools, and Business Objects.
• Excellent experience with writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Strong Database experience using Oracle 10g/9i, DB2, Sybase, Teradata, PL/SQL, Stored Procedures, triggers and cursors.
• Very good understanding of Object Oriented Programming and Professional GUI designing.
• Good working experience with Autosys Job Scheduler to automate/schedule ETL jobs, testing methodology, build and deployment.
• Excellent problem solving and analytical skills with exceptional ability to learn and master new technologies efficiently with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Excellent communication, presentation, team support, team member, database, and interfacing skills.
• Possess detailed knowledge of business and/or project management along with report writing.

TECHNICAL SKILLS

Data Modeling Tools: ERWin, Embarcardeo ERStudio Data Architect, Rational Rose, MS Visio, Sybase Designer, ERStudio Software Architect, Oracle Designer 2000, SQL Navigator, Informatica, Embarcadero DT/Studio, Power Designer

ETL Tools: AbInitio & SSIS, Data Profiler, EME, Data Stage SQL Server, DTS/Integration Services, SQL*Loader, Informatica Power Center /Power Mart, Power designer

Programming Languages: C, C++, Java, SQL, PL/SQL, HTML, UMLs, Java Script

RDBMS: Oracle 10g/9i, SQL Server, MS Access, IBM DB2 UDB, Teradata, Sybase

Reporting Tools: Cognos 8, Crystal Reports, Business Objects

Operating Systems: UNIX AIX/Solaris, MVS, Windows XP/NT/2000

Others: SAP(Financial and Controlling Module), Autosys, ClearQuest, ClearCase, Toad, MS Office 2007 Suite(Word, Excel, PowerPoint, Access), Visio, MS Project, XML, Rational Rose

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Data Modeler/Data Analyst

Responsibilities:

• Interacted with Business Analysts to gather the user requirements and participated in data modeling JAD sessions.
• Performed data analysis and profiling of source data to better understand the sources.
• Created 3 NF business area data modeling with de-normalized physical implementation; data and information requirements analysis.
• Created E/R Diagrams, Data Flow Diagrams, grouped and created the tables, validated the data, identified PK/ FK for lookup tables.
• Using 3rd NF created metadata collection and validation; standards compliance verification; ODS schema maintenance; database-to-database data type.
• Involved in non-transactional data entities of an organization of MDM 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 Data Analysis responsibilities.
• Performed legacy application data cleansing, data anomaly resolution and developed cleansing rule sets for ongoing cleansing and data synchronization.
• 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 the logical data model into Dimensional Models.
• Conducted design sessions with Business Analysts and ETL developers to come up with a design that satisfies the organization’s requirements.
• Worked with Database Administrators (DBAs) to finalize the physical properties of the tables such as Partition key, based on volumetric.
• Analyzed the data from the sources, designed the data models and then generated scripts to create necessary tables and corresponding records for DBAs using Informatica.
• Exposure to implementing Extraction mapping in Informatica (Mapping Designer).
• Developed number of Data correction scripts using PL/SQL to handle any manual adjustments/corrections in System.
• Member of Data model and Design Review group that oversees data model changes and system design across Enterprise Data Warehouse.

ENVIRONMENT: ERWIN 7.3/4.1.4, INFORMATICA POWER CENTER 6.0/POWER MART 6.0, PL/SQL, TERADATA 12.0, TERADATA SQL ASSISTANT 6.1, ORACLE 10G/ 9I, DB2 7.1, BUSINESS OBJECTS, CRYSTAL REPORTS 10/11, MS VISUAL STUDIO 2008, SQL Server 7 BIDS, XML, HTML

Confidential, AL

Data Modeler/Data Analyst

Responsibilities:

• Involved in requirement gathering and data analysis for MIDAS.
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Normalized the data up to 3rd Normal form.
• Created Entity/Relationship Diagrams, grouped and created the tables, validated the data, identified PKs for lookup tables.
• Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages
• Designed data flows that extract, transform, and load data by optimizing SSIS performance
• Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.
• Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic
• Developed mappings, sessions and batches for relational & flat file sources and targets. Loaded data into target database from sources using Workflow Manager.
• Worked on stored procedures for processing business logic in the database.
• Performance query tuning to improve the performance along with index maintenance.
• Worked on the reporting requirements for the data warehouse.
• Created support documentation and worked closely with production support and testing team.

ENVIRONMENT: ERWIN 7.3/3.5.2, ORACLE 10G, SSIS, PL/SQL, AUTOSYS, CLEARQUEST, CLEARCASE, CRYSTAL REPORTS 10/11, BUSINESS OBJECTS, MS VISIO 10.0

Confidential, NY

Data Modeler/ Data Analyst

Responsibilities:

• Involved in all phases of SDLC including analysis, designing, developing, testing and maintenance.
• Performed in-depth analysis on the business objectives.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Used class diagrams (UML) to model the logical data models and then to physical data model.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models
• Normalized the data up to 3rd Normal form.
• Mapped the data between Source and Targets.
• Gained experience in Data Extraction and Conversion and in preparing the Gap Analysis.
• Used ER/Studio to generate SQL code for creating database.
• Maintained Design document and performed testing.
• Converted Data stored in flat files into Oracle tables.
• Used MS Visio for Creating Process flow diagrams.
• Worked with the implementation team from the design to the implementation phase.
• Provided architecture/development for initial load programs to migrate production databases from Oracle data marts to Teradata data warehouse.

ENVIRONMENT: ERWIN, INFORMATICA 6.0, PL/SQL, TERADATA, ORACLE 10G/ 9I, DB2 7.1, BUSINESS OBJECTS, CRYSTAL REPORTS 9/10, MS VISIO 10.0, ER STUDIO 7.6

Confidential, AL

Data Modeler/ Data Analyst

Responsibilities:

• Interacted with users (students, teachers, and medical staff etc) using the existing system and participated in sessions to gather and interpret business requirement and prepare DTD by attending Data Requirements sessions.
• Performed Reverse Engineering of the legacy application using DDL scripts in ERwin, and developed Logical and Physical data models for Central Model consolidation
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the reverse engineering Erwin tool.
• Conducted LDM walkthroughs and validation for EDW, EDW Staging & Data mart models.
• Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the departments.
• Developed data mapping documents for integration into a central model and depicting data flow across systems & maintain all files into electronic filing system.
• Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.
• Worked and extracted data from various database sources like DB2, CSV, XML and Flat files into the Data Stage.
• Worked on DB2 UDB that provides graphical administration, Java and JDBC support & provided performance tuning and capacity planning on Oracle in order to help scale the system and optimize performance.& techniques for parallel processing
• Involved in building various logics to handle Slowly Changing Dimensions, Change Data Capture, Upserts and Deletes for Incremental Loads in to the Data warehouse.
• Developed number of AbInitio Graphs based on School requirements using various AbInitio Components like Partition by Key, Partition by round robin, Reformat, Rollup, Join, Scan, Normalize, Gather, Replicate etc.
• Used Cobol-To-DML utility to generate Ab Initio DMLs using mainframe copy books.
• Metadata mapping from source system to target database fields and involved in creating AbInitio DML’s using input Table components.
• Involved in designing fact, dimension and aggregate tables for Data warehouse Star Schema.
• Involved in updating metadata repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• Used AbInitio to create Summary tables using Rollup and Aggregate components.
• Created Multi File Systems, Multifiles (MFS) to run graphs in parallel for better performance.

ENVIRONMENT: ERWIN 7.3/4.1.4, AB INITIO GDE 1.12.6.1, PL/SQL, MVS, TERADATA 12.0, ORACLE 9I, DB2 7.1, HP UNIX, CRYSTAL REPORTS 10.

Confidential

Data Modeler/ Data Analyst

Responsibilities:

• Created database, updated database, kept track of Accounting transactions, and involved in development of the organizations website.
• Computerized all hand books on to tally for contractors, consultants, and NHA and ADB officials.
• Created a database for over 500 clients associated with the company using Oracle.
• Trained 10+ employees on Tally (bookkeeping) software.
• Trained manager to update, manipulate and edit the data base using Oracle.
• Overlooked the operational aspect for the organization for quality control.
• Worked closely with the General Managers of the organization to deploy organizations website.
• Coordinated and enforced scheduling policies to increase efficiency.
• Streamlined/developed finished projects effectively by emphasizing on quality check to increase efficiency of the organization.

ENVIRONMENT: ERWIN, INFORMATICA, PL/SQL, ORACLE 10G/ 9I, DB2, BUSINESS OBJECTS, CRYSTAL REPORTS 9, MS VISIO 6.0

Confidential

Data Modeler/ Data Analyst

Responsibilities:

• Involved in gathering user requirements along with Business Analyst.
• Created the Source System Analysis documents and Architectural Solution documents.
• Extensively used the dimensional normal form for the data ware house design.
• Normalized the data up to 3rd Normal form.
• Involved in many of the integration projects.
• Created a logical design and physical design of the relational database.
• Used MS Visio for relational database design.
• Wrote Database packages, stored procedures, functions and database triggers.
• Maintained security and data integrity of the database.
• Developed several forms & reports using Crystal Reports.
• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.

ENVIRONMENT: ORACLE 9i/8i, WINDOWS NT, WINDOWS 2000, MS VISIO 6.0, CRYSTAL REPORTS 10, HTML, JS