Summary of Experience:

• Over 9 years of comprehensive experience in Data Warehouse/ Business Intelligence technologies helping clients align IT strategies with corporate strategic objectives across departments.
• Business Intelligence experience includes, working with major clients like Wells Fargo, Honeywell Aerospace, CSX which helped gain business knowledge in Banking, Manufacturing and Transport respectively.
• Expertise in design, development, and implementation of Extraction, Transformation and Load ETL techniques using Informatica Power Center.
• Extensive experience in Creating Universe and Generating Reports/Dashboards using Business Objects Web Intelligence , Crystal Reports.
• Ability to effectively communicate with all levels of management and lead complete project life cycles, from Requirements gathering, initial planning to User acceptance testing and deployment of ETL and Reporting systems.
• Seasoned Experience in Relational and Dimensional Data Modeling and data warehousing Architectures.
• Expertise in database design and methodology from multiple perspectives user, designer, and developer
• Excellent client-facing skills and worked on complete SDLC of the projects.
• Over 15 months of experience in working with end-users for Business Objects Universe Creation and Reporting requirements definition, development and support at Honeywell Aerospace, Tempe, AZ.
• Over 18 months of experience working directly with banking clients using Informatica Power Center, Performance Tuning and Code Optimization at Wellsfargo , San Leandro, CA.
• Good experience developing SQL, PL/SQL Stored Procedures, Packages, Functions, Cursors and Triggers.
• Extensive experience in Working with Informatica Power Center involving Workflow Manager, Work flow Monitor, Repository Manager, Source Analyzer and developed Source and Target layout, Mappings, Mapplets, Worklets and Transformations.
• Extracted data from Homogenous sources, Heterogeneous sources which includes RDBMS, Flat files - Fixed Width and delimited files.
• Experience in working with Various Informatica Tasks as in Session, Command, Email, Assignment, etc.
• Worked in Unix environment to create and execute scripts and to monitor the behavior of applications running at the back end snapshots , perform and monitor load utilities.
• Additional experience and knowledge in SSAS, SSIS projects.
• Excellent technical, interpersonal/communication skills with great team ethics.

Technical Skills

• Application Development : Informatica Power Center Version 9.5, Business Objects XI R3 SSAS , SSIS, SSRS 2005
• Operating System : WINDOWS NT, XP,VISTA, 7 , UNIX
• Databases / DB Tools : Oracle 8,9i,10g,11g , SQL Server
• Methodologies / Techniques : Relational and Dimensional Data
• Modeling, Data Warehouse and Data Mart Design, Universe,
• Reports/Dashboards using Business Objects
• Network Software / Communications : Citrix, VPN
• Testing Tools : Knowledge in Manual DW Testing using SQL
• Languages : SQL, PLSQL , Unix Shell Scripting
• Scheduling Tools : AUTOSYS
• Other : Configuration - Pac2000, Microsoft Visual Source Safe VSS , Share point

roject Details

Confidential

Confidential

Team size : 8-member team.

Role : Sr. ETL Developer

Environment : Informatica 9.5, Oracle, SQL, PL/SQL, Unix

Description:

Confidential files that are used during the DDA conversion process of Wachovia to Confidential to overlay the default Enterprise DDA mapping with settings necessary to support Wholesale accounts and Wholesale managed products that cannot be set with the standard Enterprise Mapping rules.The Confidential translate process applies the WHASEL overlay mapping specifications during the Conversion process and can make some mapping determination based on WHASEL overlaid fields.The WHAFAM file generated by the WHASEL process is used during a separate Enterprise conversion step to establish the family structures within DDA.

Responsibilities:

• Designed and Implemented the Extraction, Transformation, and Load ETL techniques built using Informatica, SQL, PL/SQL and Unix Shell Scripting.
• Prepared the Logical Flow Diagrams as per Business requirement Document.
• Prepared the Technical design documents as per Business requirement Document.
• Developed Active and Passive Transformations in Informatica like Source Qualifier, Lookup, Router, Stored Procedure, Aggregator, Filter, Joiner, Expression and Sorter as per functional requirements.
• Developed mappings, workflows and Shell Scripts to extract, validate, transform data according to the business rules.
• Designed and developed the sessions for the relevant mappings or Informatica jobs and organized them as sequential / concurrent sessions.
• Scheduled the main workflows as per the business rules using the Informatica scheduler and done UNIX shell scripting for some of the existing data jobs.
• Developed Functions and Stored procedures for automating the backup of the target tables loaded after every run.
• Prepared the Table Scripts and loaded the data into the tables using data files.
• Performance tuning of the Informatica code .
• Automated the informatica jobs using UNIX shell scripting.
• NDM the Whasel and Whafam files from UNIX to Main Frame Sever.

Confidential

Role : Sr. BO Developer

Environment : Business Objects XI R3, Informatica, Oracle

Description:

This project is aimed at creating a Business Objects Reports to support CSX HR Admin, Finance and Commercial from a cost and budgets standpoint, Keep business partners and stakeholders up-to-date with their current spending and facilitate in forecasting their expenses going forward, helping them to come up with initiatives to save money to meet current and future spending goals.

Responsibilities:

• Involved in requirements gathering and analysis for the entire application.
• Involved in complete SDLC of the application
• Analysis of requirements for designing the Universe for report creation.
• Analysis of requirements to convert the metrics to Web Intelligence reports.
• Designed the Universe for creating the Web Intelligence reports.
• Designed security and Involved in the creation of the Web Intelligence reports and Dashboard from Universe.
• Complete system testing of the reports and dashboard developed against the database.
• Developed and Reviewed design documents, test plans, user documentations and promotion documents.
• Responsible for carrying out the process/management related work of the entire module.

Confidential

Team size : 3-member team.

Role : Sr. Developer

Environment : SSAS,SSIS,SQL Server

Description:

Confidential Keane Resource Management team receives 2 allocation reports. The first report comes from the Legacy Keane containing resource allocation data. Second report comes from Legacy Caritor. Resource Management team then manually combines this data to generate the Combined Allocation Report which is being sent to the Senior Management.This project is aimed at creating a Combined Allocation Report using data from two reports to get rid of the manual process involved in current situation.

Responsibilities:

• Analysis of requirement to create the final Common Allocation Report for India.
• Developed a process to load the Keane and Caritor data from flat files to data warehouse tables using SSIS components like Sequence Containers, Data Flows, File System, FTP tasks, jobs using SQL Server Agent.
• Involved in the System testing of the ETL process and the report developed using SSRS.

Confidential

Team size : 5-member team.

Role : Team Lead

Environment : Business Objects XI R2 Designer, Web Intelligence, SQL Server, Oracle

Description:

Confidential Decommissioning projects were initiated to design Business Objects universe for the Confidential and Greer sites which were about to decommission the legacy system. Requirement included building the capability for the legacy users to generate the reports even after the legacy application gets decommissioned and the sites move to SAP. Reports were developed in Business Objects XI and backend database was Oracle.

Responsibilities:

• Involved in requirements gathering and analysis for the entire application.
• Involved in complete SDLC of the application.
• Analysis of requirements for designing the Universe for report creation.
• Analysis of requirements to convert the metrics to Web Intelligence reports.
• Involved in the design and creation of the Business Objects Universe using Designer and creation of Web Intelligence reports from this Universe.
• Complete system testing of the Universe and the reports developed.
• Co-ordination with the Onsite Export Control resources for the creation and testing of Export Controlled reports.
• Responsible for managing the team and carrying out the process/management related work of the entire project.

Confidential

Role : Sr. Developer

Environment : Business Objects XI R2, Informatica, Oracle, SQL, PL/SQL.

Description:

• Confidential is a leading global provider of integrated avionics, engines, systems and service solutions for aircraft manufacturers, airlines, business and general aviation, military, space and airport operations. Honeywell Aerospace delivers a diverse range of commercial and defense and space products, systems and services across the aerospace industry.
• In Aerospace information warehouse AIW the SAP data is pulled into rapid mart tables through Data Integrator jobs on a daily basis for business level reporting by high level managers that would be used in critical decision making. This enabled a universal insight of the Honeywell analytics across plants. For each of the SAP sources, the Data marts are categorized into different subject areas that pertain to the manufacturing of parts and systems data.
• Data marts are built for each Subject Area that include Accounts Payable, Accounts Receivable, Clear Track, Cost Accounting, Engineering, Inventory, Labor, Master Data, Plant Maintenance, Production Planning, Profitability, Project Systems, Purchasing, Sales, Quality and Summary Metrics. Based on each subject areas Honeywell had separate universes built to have corresponding reports related to these subject areas.
• The system required extensive Maintenance and Support activities that was achieved through performance of enhancements made to the Informatica, Data Integrator and PL/SQL procedures based on the change in business requirements.

Responsibilities:

• Analysis of requirement to create the final Common Allocation Report for India.
• Involved in the design, development and support of Business Objects reports.
• Involved in the development of changes required in the Universe for the data marts of different Subject Areas.
• Interacted with the customer/Honeywell Subject Matter Expert SME to gather new requirements for the development and enhancement tasks.
• Estimated new requirements given by the customers.
• Conducted weekly status meeting to discuss with the customers about the project proceedings, issues handled and current enhancements executed in the project.
• Conducted weekly meeting with all the US Business Objects users to update the status of report issues.
• Involved in preparation of Functional Specifications FS which captures the detailed requirements discussed with the Honeywell SME.
• Involved in the preparation and review of Technical Specification TS .
• Worked on creating a process workflows using Informatica to load the data from Certido Internal ticket tracking database to the Reporting Data Mart.
• Provided maintenance and support for the Production Environment of the Aerospace databases for the Codes Developed using Informatica, DI and Procedures.
• Involved in creation of Business Objects reports for the SLA Metrics of Certido tickets.
• Analysis of requirements to convert the metrics available in spreadsheet to Web Intelligence reports
• Created Universe using Business Objects Designer and reports for daily, monthly metrics.
• Coordinate with the offshore team to assign tasks and help them with their clarifications on issues.
• Review of the offshore deliverables.
• Involved in regression testing and coordinating with customers for QA and production testing of reports.

Confidential

Role : Informatica BO Developer

Environment : Informatica, Business Objects Designer and Web Intelligence, Crystal Reports, Oracle

Description:

• Confidential Space Positions Data warehouse as its backbone for its ATLAS CRM and its allied systems. Realizing that it could improve its operations on CRM systems by leveraging data residing in separate legacy systems, Honeywell developed and maintains Data warehouses to make its data available for enterprise wide analysis and applications. The main objective of this Project is getting data from the legacy systems, enterprise wide, and store in OLAP tables for business intelligence reports generation.
• The Enabling IT applications include: Siebel CRM, Siebel Analytics, ADW systems, Profiler, Contract Manger, Export Predominance and Markets IT websites.
• Keane is involved in Maintenance and Support engagement for Honeywell's next generation Business applications addressing various business/functional needs of In light of change in business scenario, market growth etc. these applications need regular enhancements/up gradation. The M S activity will precisely address this.

Responsibilities:

• Involved in requirements gathering and analysis for the entire application.
• Designing the Snowflake schema for loading the data for adequate reporting.
• Developed the Mappings, Sessions and Workflows in Informatica to populate the Star schema.
• Developed Universes using Business Objects Designer XI to suit the need for reporting.
• Created the Web Intelligence reports in Info view.
• Tested the mappings and the Web Intelligence reports.
• Worked in customizing browser based third party application iMany Contract Manager Application .
• Involved in system enhancement and maintenance support of Contract Manager and Export Predominance systems.
• Identification of systems requiring enhancements updating in light of changing business needs.
• Imparting Changes/Enhancements to such identified applications.
• Worked on creating a process workflows using Informatica to load Sales Order data from Phoenix, Tempe, Torrance, and Tucson to an Oracle database.
• Monitoring daily, weekly and monthly jobs running in remote systems.
• Fixed the defects faced while monitoring, using Oracle queries, stored procedures and Informatica scripts.

Confidential

Role : Application tester

Environment : Oracle, Power builder

Description:

Confidential systems is one of the leading company that provides Banking and Payment solutions to various banks in India. They develop and maintains core banking systems for its clients.

Responsibilities:

• Involved in Application testing of banking solutions product.
• Involved in Preparation of Test plans and Documentation of Test results.