Summary:

• Over 5 years of total IT experience in the Analysis, Design, Modeling, Development, Implementation and Testing of Data Warehouse applications and acquired excellent analytical, co-ordination and interpersonal skills for leadership.
• A Data Warehouse developer, Data modeler, Data Analyst with more than 5 years of experience in all phases of Software development life cycle (SDLC) including System Analysis, Design, Data Modeling, Implementation and Support and maintenance of various applications in both OLTP and OLAP systems.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities
• Extensive Experience working with business users as well as senior management.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Strong experience with Database performance tuning and optimization, query optimization, index tuning, caching and buffer tuning.
• Extensive experience in relational Data modeling, Dimensional data modeling, logical/Physical Design, ER Diagrams and OLTP and OLAP System Study and Analysis.
• Extensive experience in Enterprise Information Management and Architecture technologies including Information Lifecycle, Master Data Management and Business Intelligence.
• Extensively used ERWIN and PowerDesigner to design Logical and Physical Data Models, to forward and reverse engineering data models and publishing data model to acrobat PDF files.
• Excellent leadership, organization skills and requirement gathering skills such as JAD.
• Strong experience in Database such as Microsoft Access, Oracle 11g/10g/9i/8i, SQL Server, DB2, Teradata, on Windows 2000/NT/98/95 platforms and latest.
• Experienced in writing Toad and PL/SQL Stored Procedures, Triggers and Functions.

Technical Skills:

Datamodelling Tools: ERwin, PowerDesigner
Project Management: MS Project
Methodologies: SDLC, JAD Sessions, Ralph Kimball Methodologies
Databases: Oracle, MS Access, SQL Server, Teradata
ETL Tools: Informatica PowerCenter 
Reporting Tools: BO, OBIEE
Languages: PL/SQL, SQL, HTML
OS: Windows
Others: MS Project, MS Office, TOAD

Education:

• Bachelor of Engineering, Electrical and Computer.
• MBA in Project Management

Professional Experience:

Confidential, MN November 2011 – Present
Data Analyst

Participated on an enterprise wide group of senior management, technology leaders, business group management and others to identify and resolve business and system impacts as the organization moves towards retirement of multiple prime SOR legacy systems after a long service life and multiple large mergers and integrations. The task was to identify data stewardship, consumption and look-alike data within legacy systems. Contribute to create a solution to maintain synchronization between the transactional systems and the subsequent processing and reporting systems. Worked various data warehouse project in WFHM (wells Fargo home mortgage) business unit.

Technical Environment:PowerDesigner 15.0, Oracle 10g, Oracle SQL Developer, Rational ClearQuest, MS Excel and Access.

Responsibilities:

• Created and analyzed business requirements to compose functional and implementable technical data solutions.
• Identified integration impact, data flows and data stewardship.
• Created new data constraints and or leveraged existing constraints for reuse.
• Created data dictionary, Data mapping for ETL and application support, DFD, ERD, mapping documents, metadata, DDL and DML as required.
• Anticipated JAD sessions as primary modeler in expanding existing DB and developing new ones.
• Evaluated and enhanced current data models to reflect business requirements.
• Generated, wrote and run SQL script to implement the DB changes including table update, addition or update of indexes, creation of views and store procedures.
• Consolidated and updated various data models through reverse and forward engineering.
• Compared different WFHM DB environments and determined, resolved and documented discrepancies.
• Analyzed DB discrepancies and synchronized the Staging, Development, UAT and Production DB environments with data models.
• Reviewed and revised data models for soundness of data structures and adherence to client standards.
• Restructured Logical and physical data models to respond to changing business needs and to assured data integrity using PowerDesigner.
• Created naming convention files and co-coordinated with DBAs to apply the data model changes.

Confidential,NJ April 2011 - October 2011
Data Analyst

The goal of the client was to re-engineer their current systems that supported their credit and debit card transaction processing. Enterprise Data warehouse–CREDIT (EDWC) is implemented on a data model called REDW (Retail Enterprise Data Warehouse) developed by IBM. Data was extracted from the EDWC data warehouse for data marts like Credit arrangement, Bank check, Billing Cycle, Custom data, Transaction, Disclosure group, Debt cancellation, Collection. Merrill Lynch Business areas access to near real time data and historical data to perform reporting and analytics by utilizing EDWC data model. This solution will continue to give Merrill lynch the Necessary business intelligence tools to perform ad-hoc analysis and monthly reporting. EDWC deals with processing and transferring sensitive credit related information like credit card account number, expiry date, SSN on disparate systems.

Technical Environment: ERWIN 4.0, Oracle 8i/9i, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, Informatica Power center.

Responsibilities:

• Consulted with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives.
• Involved in information-gathering meetings and JAD sessions to gather business requirements, deliver business requirements document and preliminary logical data model.
• Performed requirements gathering and design analysis for customer contact history for customer relationship management.
• Worked as business requirements analysts with subject matter experts to identify and understand requirements.
• Supported data warehouse projects with logical and physical data modeling in Oracle environment and assured accurate delivery of DDL to the development teams.
• Documented the data requirements and system changes into detailed functional specifications.
• Took ownership of Source to Target Mapping and tracked and maintained changes.
• Performed Extraction, Transformation and Loading (ETL) using Informatica power center.
• Designed and implemented data profiling and data quality improvement solution to analyze, match, cleanse, and consolidate data before loading into data warehouse.
• Extensively used ERWin to design Logical, Physical Data Models, and Relational database and to perform forward/reverse engineering.
• Responsible in designing new FACT or Dimension Tables to existing Models.
• Implemented stored procedures, functions, views, triggers, packages in PL/SQL.

Confidential,Dallas, TX September 2009 - March 2011
Data Analyst

The project involved creating an application that takes care of online account services which included Bill paying, Checking the bill history, collection, Account status. The data mart layer for this project is a UDB database schema. Data from warehouse is processed, transformed and loaded into the data marts for the users to generate reports.

Technical Environment: Informatica Power Center v 8.6.1, Power Exchange, IBM Rational Data Architect, MS SQL Server, Teradata, PL/SQL, IBM Control Center, TOAD, Microsoft Project Plan.

Responsibilities:

• Identify business, functional and Technical requirements through meetings and interviews and JAD sessions.
• Define the ETL mapping specification and Design the ETL process to source the data from sources and load it into DWH tables.
• Designed the logical and physical schema for data marts and integrated the legacy system data into data marts.
• Integrate Data stage Metadata to Informatica Metadata and created ETL mappings and workflows.
• Designed mapping and identified and resolved performance bottlenecks in Source to Target, Mappings.
• Developed Mappings using Source Qualifier, Expression, Filter, Look up, Update Strategy, Sorter, Joiner, Normalizer and Router transformations.
• Involved in writing, testing, and implementing triggers, stored procedures and functions at Database level using PL/SQL.
• Developed Stored Procedures to test ETL Load per batch and provided performance optimized solution to eliminate duplicate records.
• Provide the team with technical leadership on ETL design and development best practices.

Confidential, Charlotte, NC January 2007 - July 2009
Data Analyst

Confidential, is a risk management organization with a full range of products and services, focused on specialty program business. The major line of business is funds management. Data warehouse was created to give the desired report to different clients.

Technical Environment: Informatica, Repository Manager, Workflow Manager, ERWIN 3.0, Oracle 10g/9i, Teradata, TOAD, UNIX and Shell scripting.

Responsibilities:

• Worked with Data Warehouse team in developing Dimensional Model and analyzing the ER-Diagrams
• Identified and analyze stakeholders and subject areas.
• Participated in Business Analysis, talking to business Users and determining the entities and attributes for Data Model.
• Identified and determined physical attributes and their relationships through cross-analysis of functional areas.
• Identified and analyzed source data coming from Oracle, SQL server and flat files.
• Extensively used ERWIN to design and restructure Logical and Physical Data Models.
• Evaluated and enhanced current data model as per the requirements
• Performed forward and reverse engineering, applying DDLs to database in restructuring the existing data Model using ERWIN
• Designed ETL specification documents to load the data in target using various transformations according to the business requirements.
• Used Informatica- Power center for extracting, transforming and loading
• Performed Data profiling, Validation and Integration.
• Created materialized views to improve performance and tuned the database design.
• Involved in Data migration and Data distribution testing.
• Performed testing, knowledge transfer and mentored other team members.