Resume

Resume Details
S. P.
Location	Cincinnati, OH
Contact	Click to View Contact
Source	Direct Candidate
Salary	N.A.
Rate	N.A.
Resume

Professional Summary:

Thirteen years of extensive experience in Information Technology with special emphasis on design  development of Database, Data Warehousing, Informatica Administration and Development, Client-Server and e-commerce applications.
Eight years of experience in gathering requirements for data warehouse projects, perform gap analysis and create Physical-Logical Models using dimensional data modeling techniques.
Nine years of extensive experience in installation, configuration, maintenance, upgrade and administration of Informatica Powercenter 5.1-6.1-7.1.3-8.6-9.1 on Windows-Unix and Linux Platforms, have a good understanding of informatica architecture.
Good understanding of SOA (Data Integration) architecture. Defining the best practices to improve the Data Integration and quality of data in organization.
Extensive working experience in all the phases of the Data warehouse life cycle involving design, development and deployment of Data warehouses using ETL, Data Modeling, and Online Analytical processing tools.
Mastery over the *ETL process* with many years of experience in extraction of the data from various source systems ranging from Oracle, Informix, SQL Server, Flat files to RDBMS like Oracle and Teradata. 
Practical understanding of the Data modeling concepts like Star-Schema Modeling, Snowflakes Modeling, hands on experience in developing logical  physical models using ERWIN 3.5-4.0 and Power Designer 12
Extensively used ETL methodology in Data Extraction, Transformations and Loading process, in a corporate-wide-ETL Solution using INFORMATICA (Power Mart- Center 5.1-6.1-7.1.3-8.6-9.1 - Repository Manager, Designer, Server Manager-Workflow manager, Server Administration Console).
Extensive working experience in doing Data Profiling and Data quality operation using Informatica Data Quality or Informatica Data Analyst 9.1 
Strong experience in LINUX-UNIX working environment in writing shell scripts for job execution, scheduling and server maintence.
Good Knowledge about Online Analytical Processing tool (OLAP) such as Business Objects, Cognos, IBI Webfocus, SSRS, SSAS and Business Intelligence Web Application.
Extensive work experience in SQL, PL-SQL, Functions, Stored procedures development, Triggers, Packages and Performance Tuning.
Experience in Relational Databases - Oracle 8.0-8i-9i,10G,11G,SQL Server 2000, Informix, Teradata.
Extensive Work experience using ERWIN 3.5-4.0 and Power Designer as data modeling tool.
Evaluation of new data integration tools like Informatica Cloud.
Ability to handle multiple tasks and work independently as well as in a team.
Have Strong analytical skills with ability to follow project standards and decision-making capability.
Exceptional ability to quickly master new concepts and applications.
Self-motivated and have excellent Communication and interpersonal skills.
Always keeps up to date with current trends in BI and Data warehousing space.


Education  Training

B.S in Computer Science and Engineering
Informatica Architecture and Administration Certified


Skills
Databases                   : Oracle 8.0-8i-9i,10G,11G, SQL Server 2000, Informix, DB2, Teradata, 
  MS Access 2000
ETL Tools                          :  Informatica Power Mart - Power Center - 5.1-6.1-7.1.3-8.6-9.1-9.5 (Repository 
Manager, Designer, Server Manager- Workflow Manager-Server Administration Console), Informatica Power Exchange, Informatica Data Profiling, Informatica Data Quality, Informatica Cloud
Database Tools     :  TOAD, SQL Navigator 
OLAP  Reporting Tools:  Business Objects 5.0-6.1 (Supervisor, Designer, Business Object)
Data Modeling Tools        :  Erwin 3.5-4.0, Power Designer 12
Data Warehouse               :  Dimensional Modeling (Star Schema, Snowflake Schema).
Languages                      :  C, Java (JDK1.2), Shell Programming, SQL, PL-SQL
Operating Systems           :   Windows 95-98-NT-2000-XP, MS-DOS, UNIX, LINUX.
Front End Tools               :   Visual Basic 6.0
Web Server                       :   Java Web Server 2.0, IIS, Tomcat.
Web Programming          :   HTML, Java Script, VB Script, ASP
Web Tools                         :   Visual Interdev, Front Page, Dream Waver


Projects Experience       

Bank Of America, NC                          May*12-Till date
Role: Informatica Architect and Administrator

Bank of America has one of the Largest Informatica Implementations. ETL center of excellence team supports 300 applications in Seven Environments. ETLCOE team does Architect, Install, Configure and Support Informatica Platfom. 
  
Responsibilities:
Providing estimates to the project managers for the Informatica Build Projects.
Architect Informatica Platform Build
Plan and execute Informatica Upgrade
Work with off shore teams in Informatica Build and Upgrade Projects.
Informatica Installation and Configuration on Unix, Linux and Windows.
Informatica Administration and Support.
Installation and Configuration of Informatica Power Exchange 
Prepared standards document for Informatica Build. 
Prepared Informatica Naming Conventions and Coding Standards document.
Did POC on various informatica connectors and provide Coding Standards to application teams.
Trained off shore and onsite associated in Informatica Development and Administration.
Written shell scripts for Informatica Server Administration and Support.
Created shell scripts to integrate informatica with VCS Monitoring.
Configured geneos to monitor informatica environment.
Written wrapper scripts for scheduling jobs in Autosys, complete job schedule are maintained in the 
Custom oracle tables, which enabled restart ability and better performance.
Written and Used Unix Shell Scripts to run Workflows using pmcmd command
Used deployment group for migrating Informatica Objects between environments.
Gathered performance statistics for the mappings, identified the bottlenecks and resolved them to improve the performance of the mapping.

Environment: 
Oracle 10 G, Oracle 11G,Oracle 9i, SQL SERVER 2000, Informatica Powercenter 9.5-9.1-8.6-7.1.3 (Repository Manager, Designer, Server Manager, Server Administration Console), Informatica Data Quality - Analyst,  Informatica Power Exchange 9.1, SQL, PL-SQL, Shell Scripts, Sun Solaris, Win NT, TOAD, Autosys, Techtia, Geneos.


Fidelity Investments, KY                          Sep*05- May*12
Role: Informatica and Data warehouse Architect

Fidelity Investments is one of the world*s largest financial service providers. During these years at fidelity investments I have worked on various projects and integrated various systems with data warehouse. 
Main objective in building an Enterprise Data Warehouse is to provide the inbound and outbound operational managers with intraday and historical data so that they can make decisions by facts and to maintain a single version of the truth across the organization. 

Installed and configured Informatica Powercenter 7.1.3-8.6-9.1 on Linux-Unix operating system. 

Integrated Image capture system with the data warehouse by processing data to staging, ODS, Data warehouse and Data mart, various dashboards and scheduled reports are generated using this data for the inbound mangers to analyze the operator productivity and forecast the work and plan accordingly. 

Share holder mailing application, CM and ERP systems are integrated with data warehouse to reconcile all the requests that are processed as per the regulatory compliance.

Informatica Powercenter 7.1.3(Linux) upgrade to Powercenter 8.6 (64 Bit UNIX) and Powercenter 8.6 (64 Bit UNIX) upgrade to Powercenter 9.1(64 Bit UNIX).   
  
Responsibilities:
Providing estimates to the project managers for the Infrastructure and Integration Projects.
Gathered requirements for multiple data integration projects and documented the requirements.
Performed gap analysis and created data models using the Dimensional Modeling (Star Schema) techniques.
Performed data profiling and identified data quality issues and set standards to fix the issues across the systems that are integrated with data warehouse.
Generated database creation scripts from physical models.
Evaluated Informatica Cloud and Informatica Power Exchange CDC for Oracle and provided recommendations for implementation. 

Worked with DBA*s in sizing the database, creation of table spaces, creating roles-privileges and maintenance of Data warehouse databases. 
Defined informatica environment architecture.
Developed reports using IBI Webfocus
Analyzed the IBI Webfocus reports that are used by users and formed the business requirements.
Installation, configuration and administration of Informatica Powercenter 7.1.3-8.6-9.1 On LINUX and Unix operating systems.
Upgrade of Informatica Powercenter 7.1.3 (Linux 32 bit) to Informatica Powercenter 8.6 (64 bit) on UNIX and Upgrade of Informatica Powercenter 8.6 (64 bit) to Informatica Powercenter 9.1 (64 bit)
Created Naming conventions and coding standards documents.
Created specification and mapping design documents based on the data models, data availability in source systems.
Lead offshore development team in Infrastructure and Integration Projects.
Conduct code reviews to make sure the development is done with good standards.
Developing Mappings as per the Design Document with proper naming Conventions for Transformations and Mapping Variables.
Created Mappings Using various transformations like Expressions, Aggregators, Joiners, Ranking, Stored Procedures, Look Up and Update Strategy transformation using Informatica Tools.
Used reusable transformations, mappings and sessions, which enable ease of maintenance and lesscoding. 
Used external procedure transformation for calculating the check sum for the values in a row.
Created sessions and workflows to run the various mappings for loading the data using workflowmanager in Informatica.
Written wrapper scripts for scheduling jobs in cron, complete job schedule are maintained in the customoracle tables, which enabled restart ability and better performance.
Written shell scripts for Informatica Server Administration and Support.
Used parameter files extensively to pass values to Mapping variables.
Written and Used Unix Shell Scripts to run Workflows using pmcmd command
Used server variables while specifying the session log, workflow log and cache file paths.
Used deployment group for migrating Informatica Objects between environments.
Gathered performance statistics for the mappings, identified the bottlenecks and resolved them to improve the performance of the mapping.
Used SQL over rides to improve the performance of the sessions.
Used new features of SQL in Oracle 10 G, 11G in ranking and year to date summarizations.
Maintained detailed documentation of all the activities.
Trained off shore and onsite resources in Informatica Administration , development and 
Data warehouse development.

Environment: 
Oracle 10 G, Oracle 11G,Oracle 9i, SQL SERVER 2000, Informix, Flat files, Informatica Powercenter 9.1-8.6-7.1.3 (Repository Manager, Designer, Server Manager, Server Administration Console), Informatica Data Quality - Analyst,  SQL, PL-SQL, Erwin 4.0, Power Designer 12.0,IBI Webfocus, Shell Scripts, Sun Solaris, Win NT, SQL Navigator.


Electronic Arts, CA                          Feb*05-Aug*05
Role: Sr. Data warehouse Developer
Electronic Arts is one of the top game development companies. This Project involved ETL Operation to fulfill its vision of providing end-users with access to a single source of data that will facilitate consistent reporting by implementing the Enterprise Data Warehouse (EDW).  The EDW is a data repository that uses common data assignment processes and utilities to facilitate reporting and to provide access to accurate and consistent data for end users and applications.  
Responsibilities:
Analyzing and Understanding Sources of IBM Mainframes COBOL Copybooks, FaltFiles, Oracle, DB2 Tables and Target with Sql Server.
Involved in developing Logical and Physical Data Models based on functional design using Erwin Data Modeler.
Worked closely with Business Analysts and Data Modelers on Mapping Document Design Process for various Sources and Targets.
Extensively worked in extraction, transformation and loading of data from the different sources like COBOL Copybooks, FaltFiles, DB2 Tables Using Informatica. 
Worked intensively on the Informatica tools - Source Analyzer, Warehouse Designer, Mapping designer, Mapplet designer and Transformation Developer.
Complex mappings-mapplets were developed using Expressions, Aggregators, Joiners, Ranking, 
Stored Procedures, Normalizer and Update Strategy transformations.
Extensively used Mapping Parameters-Variables in order to best fit the business logic.
Involved in troubleshooting the Mappings and performance enhancements.
Extensively used Unix Shell scripts and pmcmd commands.
Developing Tasks-Sessions and Workflows as required with Session variables using Workflow Manager In Informatica.  
Performing Unit Test, Volume Test for Mappings and documenting the test plans.
Designed, Built and maintained Reports in SSRS and SSAS.
Map reporting requirements to build report.
Design and tune reports and SQL queries

Environment:
SQL Server 2000, Oracle 9i, DB2, ETL-Informatica 6.1-7.1(Repository Manager, Designer, Workflow Manager), SSRS, SSAS, Erwin 4.0, SQL, Win NT, Sun Solaris, Sql Server Studio, Microsoft Report Builder.

Providian Financials, CA                       May*04 - Jan*05
Role: Data warehouse Developer
Providian Financials is giant in the fields of Finance, Credit Card providers. This Project involved ETL Operation on Financial Data sourcing from Flat Files-DB2 and loading to an Oracle Warehouse. 
Responsibilities:
Analyzing and understanding Sources of Fixed width Flat Files, DB2 Tables and Target with Oracle      9i.
Developing Mappings as per the Design Document with proper naming Conventions for Transformations and Mapping Variables.
Created Mappings Using Expressions, Aggregators, Joiners, Ranking, Stored Procedures, Look Up and Update Strategy transformation using Informatica.
Worked with huge tables that consisted of around 256 columns and 100 million records per each table. 
Used complex data transformations with around 25 transformations for each mapping
Developing Performance Tuning Strategies using Bottle Neck method and in termsof 
Expression and Aggregator transformations.
Created sessions and workflows to run the various mappings for loading the data using workflowmanager in Informatica.
Performing Unit Test and Volume Test for Mappings.
Written and Used Unix Shell Scripts to run Workflows using pmcmd command
Writing PL-SQL procedures for processing business logic in the database.
      Tuning of SQL queries for better performance.

Environment: 
Oracle 9i, DB2, Flat files, ETL-Informatica 6.1 (Repository Manager, Designer, Server Manager), 
 SQL, PL-SQL, Erwin 3.5,Shell Scripts, Sun Solaris, Win NT, Toad.

 TATA Teleservices Ltd., India       Feb*03 - Apr*04
Role: ETL Developer
Tata Teleservices Ltd is one of the largest telecom operators in India. Data warehouse is built to maintain a single source of data, for consistent reporting.  This Project involved ETL Operation on Flat Files and oracle source systems and loading data to an Oracle Warehouse. 
Responsibilities:
Analyzing and understanding Sources of Fixed width Flat Files, Oracle tables and target with Oracle      9i.
Involved in designing the Dimensional Modal Using Erwin Data Modeling tool.
Identified all the confirmed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
Created various data marts by integrating different source systems to data warehouse.
Created various mappings and mapplets using Mapping Designer in Informatica  
Improved the performance of the mappings by moving the filter transformations early into thetransformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations.
Identified and tracked the slowly changing dimensions-mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
Created sessions and batches in workflow manger using Informatica to run the various mappings andscheduled them for loading the data.
Responsible for monitoring all the sessions that are scheduled, running completed and failed. 
Involved in debugging the Mappings that failed.
Unit testing is done for all the Mappings by loading the test data and documented the process.
Writing PL-SQL procedures for processing business logic in the database.
      Tuning of SQL queries for better performance.
Designed, Built and maintained Universes in Business Objects.
Map reporting requirements to BO universes
Design and tune BO reports and SQL queries
Environment: 
Oracle 9i, Flat files, ETL-Informatica 5.1 (Repository Manager, Designer, Server Manager), 
Business Objects 5.0(Supervisor, Designer, Business Object), Erwin 3.5,SQL, PL-SQL, Shell Scripts, 
Sun Solaris, Win NT, Toad.


 TATA Teleservices Ltd., India       Apr*02 - Jan*03  
Project: NIRDISTA
Role : Module Leader 
This system serves all the needs of a HR Department. This system consists three modules Recruitment, Employee Development and Employee Relations. Using Recruitment module Offer letters are generated, employee details are rerecorded and post employment activities (Increment, Transfer, Promotion) are recorded and letters are generated. Reports are generated based on the   captured details. Head office can view the over all manpower status in all the locations.
Using Employee development module the training needs of the employee are captured, based on the needs the programs are scheduled, after conducting the programs feedback is captured. Reports are generated for analysis based on the   captured details.
Using Employee relation module list of contractors and their license details are captured. Check List details with respect to various acts are captured and reports are generated.
Responsibilities: 
Involved in Analysis of the project.
Involved in client discussions.
Involved in technical documentation.
Involved in designing the database.
Involved in Building Data flow diagrams.
Involved in project planning with Project Leader.
Created forms Using VB 6.0 Components.
Created Reports In Excel Using OLE Components In Vb6.0.
Created stored procedures in database Using PL SQL.
Created different types of Reports by using SQL queries extensively. 
Environment: 
Visual Basic 6.0, Oracle 9i, Excel, SQL, PL-SQL, Data Reports, Windows NT




TATA Teleservices Ltd., India                                                                          Sep*01 - Mar*02
Project: Planettatatel
Role: Module Leader
Intranet system that helps the employee to know about the happenings in the company and in the world, Daily news, news articles about the company and group company information display of employee birthdays, organizational announcements, job postings, training calendar, provisions to take pay slip and view tax details, provision to take salary, No objection, address proof and service certificate. In the entertainment section happenings about various sports, movies, live cricket score, recipes, cartoons, games, personality tests and playing music online are there.There is a provision to search for an employee, which shows his personal and contact details. Employee can post the rentals and sale information on the net. Company policies and procedural forms are displayed in the intranet.
Responsibilities:
Involved in Analysis of the project.
Involved in client discussions.
Involved in conceptualizing the intranet.
Involved in technical documentation.
Involved in designing the database.
Involved in Building Data flow diagram
Involved in project planning with Project Leader.
Configuring IIS Server and Creating root folder for the site.
Created Web pages Using Html, Asp and Java Script
Created stored procedures in database Using PL SQL.
Oracle procedures are scheduled to load data into intranet system
Environment:
Html, ASP, Javascript, DereamWaver, Adobe Photoshop, Flash, Oracle 9i, SQL, PL-SQL, Windows NT, IIS

Air Port Authority of India, Delhi, India           Apr*00 to Aug*01
Project: Air traffic Billing System 
Role:    Application Developer
ATBS is the system that helps Air Traffic Management (ATM) Directorate of AAI, which is managing the total air traffic of Indian space to generate the traffic billing automatically for every flight movement based on various facilities provided like landing, parking, housing, take-offs, route navigation facilities for over flying aircrafts. The objective of this system is to generate bills based on the information captured from the flight movements in the Logs. Complete details of revenue receipts will be maintained for operators separately. This system is to provide you with a quick and easy access to information pertaining to arrivals  departures of flights. This system also maintains logs and registers, which would form a basis for billing by the finance department.
Responsibilities:
Involved in Analysis of the project.
Involved in client discussions.
Involved in technical documentation.
Involved in designing the database.
Involved in Building Data flow diagrams Using ERWIN.
Created VB Forms In VB 6.0.
Created reports Using Data Reports.
Created stored procedures in database Using PL SQL.
Created different types of Reports by using SQL queries extensively.
Environment:
Vb 6.0, Oracle 8i, Data Reports, SQL, PL-SQL, Erwin 3.5, Windows NT.
<< Back
Resume

Similar Candidates
