SUMMARY

• Around 8 yearsof total IT experience in Data Warehouse, Data Modeling, Data Analyst, Data design & development of BI solutions, ETL Informatica, Client/Server and Web applications on Windows, UNIX & Linux platforms.
• Worked as a team lead responsible for a team of 5 other analysts.
• Extensive data warehouse expertise in OLAP and relational modeling (3NF/OLTP) with a wide repertoire of domain experience in Government, Retail, Banking& Finance etc.
• Consummate knowledge in Conceptual, Logical and Physical Database Design by leveraging tools like Erwin and ER Studio.
• Good experience in Teradata performance tuning using Join indexes, Partitioning, Temporary tables and statistics analysis.
• Designed Data models for Multi - Terabyte Systems and built Enterprise Data Warehouses (Ex: Confidential .

TECHNICAL SKILLS

• Business Objects
• C/C++
• ERStudio 8.5
• ERwin 4.1
• 8.x9.x
• Informatica 7.2.1/9.5/9.6.1
• Business Intelligence
• Unix/Linux
• Business Intelligence
• WINDOWS 10/8/7 98/2000/ NT/XP
• MySql
• Oracle 11g/10g/9i/8i/8.x/7.x
• PL/SQL
• SQL
• SQL Assistant
• Teradata 13/14
• Teradata Profiler
• MS Excel
• Metacenter
• Teradata SQL
• Oracle

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

Sr.Data Modeler/Data Analyst

Responsibilities:

• Collaborated with the stake holders efficiently in conducting the JAD sessions to address all the key business ambiguities which arise while identifying key Indicators.
• Identified quantifiable measures after understanding the Confidential processes.
• Ensured that data aspects of projects were fully addressed and consistent in approach by introducing and integrating data considerations into existing Object Oriented methodology and system development life-cycle.
• Constructed data models, designed schemas, generated DDL and worked with development team members on the implementation of project.
• Defined and developed specific standards encompassing Data Modeling and Physical Database Design, Change Management, Business Objects Universe Design.
• Integrated new subject areas and business units such as OSMIS, JET, FSSP in an effort to lay foundation for the SOM enterprise data warehouse.
• Ensured all the physical modeling practices are adhered to before the DDL’s are created in DRBC.
• Designed and implemented (POC) proof of concepts after identifying the scope of the project and before development design so as to understand the feasibility, guestimate efforts.
• Strong understanding of Indexing, partitioning and other Teradata V2R13 specific applications like BTEQ, TPT, FLOAD, Indexing wizard, Viewpoint etc.
• Well Versed with different SQL Development Tools like TOAD, Oracle,Teradata Sql Assistant and Teradata Bteq.
• Experience in handing slowly Changing Dimensions using TPT utility and fast loading into empty Target tables.
• Experience in application enhancements. Developed, tested and deployed Teradata scripts.
• Strong experience with UNIX Shell Scripting, SQL, PL/SQL, DBA,Oracle, Coding & scripting.
• Skilled in Automation, Optimization, and Performance Tuning of Teradata SQL’s and Oracle.

Environment: ERwin 8.x, SQL, Teradata database,Teradata 13, Teradata SQL Assistant, SAS,VB 6, Oracle, PL/SQL,DB2,Excel, XML,Unix, MS Excel, Informatica.

Confidential, Beaverton, OR

Data Modeler /Data Analyst

Responsibilities:

• Interacted with the BSA’s & Business partners to collect data specifications & artifacts.
• Understood traceability matrix & DDS to ensure source data is aligned to requirements.
• Co-ordinate with the Architectural team and come up with proposed design & possible solutions.
• Made key decisions on proposed design structure, which can possibly serve as a purpose and answer all the KBQ’s.
• Created the attributes for the dimensions/Fact tables based on the traceability matrix & source systems.
• Modeled logical & physical data models based on the KBQ’s collected.
• Implemented the Data Modeling for BI environment using Erwin 7.x
• Conducted model walk through sessions with the business partners.
• Implemented enterprise guidelines for data modeling and data asset management.
• Designed the physical data models using data provisioning and consumption techniques in a Teradata environment.
• Research and recommend changes where technology can be better used within the overall systems environment to improve efficiency, lower costs, and enhance the quality of business applications.

Environment: ERwin 7.x/ERStudio 7.5,Teradata database, SQL, PL/SQL,Oracle,Teradata V2R6,VB, Teradata SQL Assistant, Oracle,SAS,DBA,MS Excel, Unix, XML.

Confidential, Thousand Oaks, LA

Data Modeler /Data Analyst/ ETL Informatica Developer

Responsibilities:

• Understood traceability matrix document to ensure source data is aligned to requirements.
• Created the attributes for the dimensions/Fact tables based on the traceability matrix & source systems.
• Modeled logical & physical data models based on the KBQ’s collected.
• Conducted model walk through sessions with the business partners.
• Implemented enterprise guidelines for data modeling and data asset management.
• Produced data model solutions meeting technical specifications and business requirements according to the established designs.
• Expert in ER/Studio Repository Management and administration.
• Day to day admin tasks associated to ER/Studio Repository like granting user access, creating roles, working with DBAs for Repository database performance issues and merging models, coding new macros and customizing canned ER/Studio Macros.
• Configuration Management and Version control of ERwin Model Mart and ER/Studio Repository.
• Provide capacity estimates for database design planning and performance tuning suggestions to DBA.
• Modeling activities included LDMs for Business Intelligence, Data Warehouse and Applications domain.
• Extension of Operational Data Store (ODS) and Parsing XML structures to create Hierarchical model.
• Generated the CDMA out of ERStudio to generate the source target-mapping template.
• Updated the definitions & physical names based on the Confidential & Teradata standards.
• Worked in conjunction with Database Administrators and Development teams to come up with an efficient database design.
• Generated & reviewed DDL & DQ scripts s using ERStudio before communicated to the DBA for the implementation.
• My role was to migrateERwin changes to ERStudio master data model in very tight timelines.
• Created Source to Target worksheet for ETL processes in Informatica using CDMA.

Environment: ERStudio 7.5, SQL, Teradata 13,VB, Teradata SQL Assistant,Informatica, MS Excel, Oracle,PL/SQL,SAS, Unix, XML.

Confidential, Chicago, IL

Data Modeler/ Data Analyst/ Informatica Developer

Responsibilities:

• Understood and validated the project requirements.
• Created and maintained Business Process Models, Process flow Models, Data Flow models & conducted walk through sessions with Business partners.
• Reviewed and understand the data analysis artifacts.
• Contributed in data profiling & data mining.
• Created and converted the Logical data models in to Physical.
• Migrated several data models from ERwin 4.1 into ERStudio 7.5/8.5 as per the naming standards.
• Created the data Lineage mappings using the source to target mapping document.
• Supported Business Process Analyst, Designers, and Architectural Experts with enterprise and process area modeling, workshops, documentation, training and user support.
• Participated in technical reviews and inspections related to business process models.
• Conducted review walk through of data models involving SME, developers, testers and analysts.
• Generated & reviewed DDL & DQ scripts s using ERStudio before communicated to the DBA for the implementation.
• Involved in database designing and administration in IBM DB2 UDB, Teradata, MS SQL Server and Oracle.
• Supported Business Process Analyst, Designers, and Architectural Experts with enterprise and process area modeling, workshops, documentation, training and user support
• Creative in solving governance issues.
• PROFESSIONAL EXPERIENCE - Continued
• Name released the data models to publish the metadata to Metacenter to make it available to the users.
• Contributed in filling the S-T mapping templates for the data models.
• Contributed in upgrading the ERStudiodev& prod repositories from 7.5 to 8.0 & from 8.0 to 8.5.
• Grant access to the new users & assign role names on as needed basis.
• Implemented the new Metacetnter Materialized views every time ERStudio repository was upgraded.
• Released the locks on data models that are no longer used & checked out by the other users.
• Used undo checkout operation on the data models to revoke the changes in the repository.

Environment: ERwin 4.1/ERStudio 8.5, SQL, PL/SQL DB2,Oracle,Teradata V2R6, DBA,Oracle 10g, Teradata SQL Assistant, Informatica,Lotus Notes, Metacenter 3.8,AIX,VB 6, SAS,MS Excel,Unix, XML.

Confidential, Schenectady, NY

Data Modeler/ Sr.Informatica Developer

Responsibilities:

• Prepared the Technical Architecture documents, Project Plan and Technical Design documents.
• Collaborated with analysts to decide the ETL methods and overall data flow Design.
• Prepared the Fact Dimension Matrix for conceptual modeling of ODS.
• Used ERwin .nsm& .dsm files to follow the naming standards in while designing the database.
• Identified the data requirements and the impact analysis on the existing schema.
• Generate the conceptual, logical, physical, staging, enterprise & database layers.
• Created and converted the Logical data models in to Physical.
• Contributed in the data cleansing & profiling before the ETL process.
• Developed Informatica mappings to push the data into ODS.
• Performed data and date conversions using Informatica Transformations.
• Designed and developed the mappings, sessions, and workflows.
• Monitored/reviewed other ETL programmer’s deliverables on a team share basisto ensure that adherence to uniform application development practices.
• Developed the Cognos 8 reports on top of ODS.

Environment: Informatica Power Centre 8.1/7.1.2/6.5 , Cognos8, ERwin 4.1.4, Excel Add-In, TOAD, Oracle 9i, Windows 2000/NT, Sun Solaris 5.8./Erwin, SQL, PL/SQL, Oracle,MS Excel, Informatica,SAS,DB2, Unix, XML.