• Having over 10 years of experience in design and development in information systems for various commercial applications. Having sound foundation in relational and object design methodologies and is well versed in BI and ETL Technologies, Windows NT/Linux and client/server environments. Willing to learn and adapt to new challenges. Having excellent communication skills and strong interpersonal skills which provide the ability to interact, a quick learning and team playing. Having excellent work ethics, and is team oriented with strong analytical and leadership qualities.
• 4Extensive expertise in using ETL tool like Informatica 9.1.
• 4Extensive expertise in designing, coding and testing in PL/SQL, Shell Scripts, FTP.

Experience:

• Domain experience in finance, manufacturing and the service industry.
• Experience in gathering user requirements and translating them into technical and system specifications. Managing clients, vendors, and partner relationships.
• Extensive experience as a solution architect/Support Lead for business information systems, focusing on database architecture, data modelling, data analysis, software design, programming and application integration.
• In-depth knowledge of large database design techniques experience in data analysis, data cleansing, and data transformation and migration using ETL tools
• Experience with Informatica Power Center -Designer, Workflow Manager, Workflow Monitor and Repository Manager including administering, designing, developing, deploying and supporting ETL processes.
• Experience in UNIX and Windows environments, as well as operating system specific shell scripting.

PROFESSIONAL EXPERIENCE

Confidential

Environment : Informatica 9.1, Oracle 10G

Description :

• GE Aviation HQ plays a big role in collecting Spares/Repair/Sales data from different Shops and consolidating the data in a warehouse where all the analytic teams use the data in tracking revenue and forecasting the sales.
• Responsibilities:
• Involved in requirement, analysis and understanding of business requirements identify the flow of information and analysing the existing systems.
• Analysed the source data coming from Oracle, Flat Files, and many Datamarts, coordinated with data warehouse team in developing Dimensional Model.
• Created shell scripts to run daily jobs and extract the files from remote location for data loads.
• Created reusable Mappings, Mapplet, Transformations and Parameter files for Data Quality Plan.
• Extensively used Oracle partitioning range/hash/list , indexes bitmap, B-tree, and various join types to improve the performance.

Confidential

Environment : Informatica 8.6, Cognos, Oracle 10

Description :

As a Data Architect checking the Integrity of the data that flows in to the AERO data marts and newly enchased dimensions are plugged to the existing marts. Provide technical guidance and direction in defining the data architecture strategy for individual projects. Work with senior management, technical and client teams in order to determine data requirements and best practices for advance data manipulation, storage and analysis strategies in a data warehouse environment.

Responsibilities:

• Applying strategies for data acquisition, warehouse implementation, and archive recovery.
• Offer supervision on data management, migration and normalization.
• Coordinate with Business Leaders and Project Managers to assure the solutions are complying with business strategies and are according to the IT strategic plan.
• Developed strategies for archive recovery, data acquisitions, and implementation of database.
• Design standards for using normalized data structures, de-normalized structures, and dimensional structures. Defines common design patterns for modelling various types of relationships.
• Transformation and Load ETL strategy, design and implementation. Includes ETL across different platforms.

Confidential

Environment : Informatica 8.6, Business Objects 6.5, Oracle 10

Description :

GE TFS business is mainly involved in Leasing and renting of the cargos, Trucks, Tankers and many other trailers to their vendors.

Responsibilities:

• Responsible and accountable for the coordinated management of multiple related
• Projects directed toward strategic business and other organizational objectives.
• Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.
• Define and initiate projects, and assign Project Managers to manage cost, schedule, and performance of component projects, while working to ensure the ultimate success and acceptance of the program.
• Maintain continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.
• Coach, mentor and lead personnel within a technical team environment.
• Present periodic Dashboard reports on the current program, future opportunities and client issues.
• Managed client engagement services and solution implementations.
• Maintained the customers existing revenue spend and strategically up sell additional products and services.
• Direct the coordination of all implementation tasks involving third party vendors as well as provide consultation to clients on system implementation.
• Manage transition of client from Solutions Implementation to Client Support. Manage the development and maintenance of implementation portions of project.

Confidential

Environment : Informatica 7.1.3, Business Objects 6.5, Oracle 8i

Description :

Production support and the enhancement were involved in the project, the idea behind this is to stabilize many datamarts. ICOMS is the main source for all the datamarts in COX which contains Customer's/Sales related/Financial data, approx. 700 MB will be loaded every night to update the set of dashboard which are in Business objects, trouble shooting of datamarts like IVR, CRM calls, Remedy, HR etc loads data to different reports. Understanding the business terminologies of different businesses and to integrate in a datamart was the major challenge, Initiatives were taken to improve the data quality of the customer's customer and number of Root Cause Corrective Analysis were taken which has later helped us to stabilize the process.

Responsibilities:

• Deliverables from offshore of all the applications.
• Cross-trained new members in the project.
• For creating the documents and stream lining the processes.
• Root cause corrective actions were taken and eventually there were a cut off in
• Number of cases.
• Understanding the Business and creating complex mappings.
• Administration of the servers and allocating space accordingly.
• Creating Indexes/partitions to improve the performance.
• Creating Cron jobs for automated validation of Data.
• Quality initiatives were taken to find long running jobs by measuring the run time of previous runs from repository and sending an alert to the group for any spike in run time of a job.
• Clearing up the cache files and log files often.
• Migrating of Business flows and Scheduling as per the CRs
• Informatica Server Maintenance bouncing, clearing unwanted files after loading the data.
• Ensuring the timely populate the data in all the fact tables each day.
• Reloading of data in erroneous month partition and History reloads.
• Constant interaction with different support teams helped us to streamline the process.
• Discussing the issues with customer's customer to understand the issue.
• Prioritizing the Issues and providing the customer's customer with the right data.
• Month End tasks such as loading data from Indirect files, Running a Datamart
• created in SQl ensuring the correct numbers in the report.
• Cross training the off shore team to troubleshoot any kind of issue in different applications.

Confidential

Environment : Business Objects 6.5, Oracle 8i.

Description :

S1, S2 and OpPlan are the plans where users estimate the revenue in coming years. In every plan the rate and the duration of leased Cars are assigned to the Account Managers. Expire, Embed and Expired ET are the classifications which will determine the period of a leased car. Inclusive of these logic at universe level, cut down the number of filers from reports, using Aggregate, Derived tables helped to tune the performance. We had to over come the problems created by BCA servers like untimely refresh and failure of large number of reports.

Responsibilities:

• Analysing the Source, debugging the Universe, Rationalising the repository.
• Enhancement for reducing the Bugs and managing the Reports.
• Managing BCA Console, Scheduling Reports through WebI.

Confidential

Environment : Informatica 7.1, Oracle 8i, SQL Server 2000.

Description :

This project is an Enterprise wide data warehouse for entire GECIS. GECIS as such doesn't have enterprise wide view of various processes. So the initiative has been taken to implement Enterprise wide data warehouse which would have the view of all metrics across all the processes. Informatica 7.1 was used to extract from various sources like Flat files, Oracle 9.1 SQL server 2000, CMS etc. and load into data warehouse. Attrition, Product Deep Drive and Collections are the few important products among the existing. Metadata is for each and every mapping has been mentioned right in the beginning of the project From these product the Metric will be taken out by using the standard formulae, Update strategies were used in the main table to trap day to day metrics. Cognos 7.1 was used for building Cubes and Standard Reports.

Responsibilities:

• Collect the Data and to know the formulae for the metrics.
• Building Mappings and Testing.
• Developed mappings, mapplets, transformations, sessions, workflows, and worklets.
• Creating Partitions on the mappings to improve the performance.
• Exporting the mappings from development, Integration to Production.

Confidential

Environment : Oracle 8i/PL/SQL.

Reporting : Business Objects 5.1.7

Description :

This Project is to Migrate from OPM 11.0.3, GEMMS, ESS, and Fujitsu Mainframe to OPM 11i. As an enhancement in GE Plastic OPM11i was implemented and the Structure of the database was changed thus the Impact on the universes and on the reports were very huge, As a corrective measure As-Is and To-Be documents has been designed as a primary step, later the replacement of the existing table and adding up the tables has been done by knowing the business logic. Interaction with the OFA team of GE Energy helped us to determine and to implement the same logic as previous. Our Team and I have successfully closed all the issues and by exporting the reports to corporate documents after the UAT.

Responsibilities:

• Interaction with the users and with the OFA team.
• Getting sign off from the owners of the reports.
• Analysing the source, debugging the Universe to redesign.

Confidential

Environment : Oracle 11i/PL/SQL.

Reporting : Business Objects 5.1.7

Description :

Wave 1 in the project is the migration of the universe that is pointing to Oracle 11.0.3 to 11.0.5 and has the major changes in the table structure. Impact Analysis has been done before making the changes and took the corrective action. A new BCA server has been set up for GE Energy Users to refresh the reports and to push them to a Virtual folder of IIS in HTML format so that the users can see the HTML pages, Single Sign on Ids which are in LDAP server helped us to restrict a user or to deal with security problems. Development of Universe has been done in Wave 2. Fine-tuning the Report's refresh time by cutting down the time from 10 minutes to 3 4 minutes. The bulk Network Monitors will be sending to their clients in the USA and Europe and the data will be collected in Oracle 11i. All the Clients are given access to ZABO and WebI Reports.

Responsibilities:

• Enhancement for reducing the Bugs and managing the Reports.
• Managing BCA Console, Scheduling Reports through WebI.
• Analysing the Source, debugging the Universe, Rationalising the repository.
• Development of a Universe and ad hoc Reports

Confidential

Environment : Oracle 8i, PL/SQL.

Reporting : Business Objects 5.1.7

Description :

The project is related to enhance the existing project, analyse and studying the root cause for the problem facing currently across the world. There are around 22 application running on 6 different databases in the project, these DW set up has done through different vendors in the beginning and the set up is also included in BI servers which are running across the world for different Poles like US, UK, Asia, India. The Poles are divided to reduce the load for BI and all the process are made automated to run the scripts. These scripts will run according to the schedules made. The data could fail due to different reasons which are monitored and gathered, these failures are analysed for the RCCA Root Cause Corrective Analysis and enhancing the bugs to run without errors. Similarly the BI part is studied and couple of schedules are under change request and non-satisfaction from users for reports. These are the major change in universes.

Responsibilities:

• Enhancement for reducing the Bugs and managing the Reports.
• Managing BCA Console, Scheduling Reports through Webi.
• Analysing the Source, debugging the Universe to redesign. Rationalising the BCA Servers, Supervisor.

Confidential

Environment : MS SQL Server, MS OLAP, DTS.

Reporting : Pivot Table

Description :

Application has been developed to grab the required Rows from different databases to an excel sheet, for which parameters are passed by the users. Using stored procedures users can give parameters, after the changes data will be saved in the respective databases, users been shown the reports using Pivot table for their ease to forecast the sale in future. In this project, the Concurrency and the Minimum usage of the system Resources have been tested.

Responsibilities:

• Designing, Programming in Excel using VBA.
• Review, integration testing and coordination and leading the team during the implementation phase.
• Developed packages in DTS to load the Data and scheduled the same.

Confidential

Tools : MS SQL Server, Informatica 4.7

Reports : Business Objects 4.x

Description :

Aim of this project is to develop a common Data mart for whole HP Asia pacific region by dragging the data from the different parts of Asia pacific to DSS, from DSS to Local database using Informatica. This will connect all the departments in HP viz CBO, BCO, APDF, S M and provided a common data integration which will be used by all Internet Related Application. Basically the data is pulled from the legacy systems like SAP, K2 an in-house application for HP , IJMS and SOLID from Korea. We have used Stored procedures and ActiveX Scripting in SQL Server to enable smooth data migration and perfect dimensions cubes and Fact table. Tuned Complicated data into a simple and understandable Multidimensional reports .The reports were generated using Business Objects using various functionalities such as Master-details, creation of filter objects as part of resolving loops, creating functions for complex functionalities and drill down reporting.

Responsibilities:

• Involved in study of Business process.
• Involved in coding and scheduling the Stored Procedures.
• Developed mappings, mapplets, transformations, sessions, workflows.
• Scheduling the ETL tool to pull data from different part of Asia pacific.

Confidential

Tools : MS SQL Server, MS-OLAP, Informatica 4.7

Environment : VBA, ASP, Java script, VB Script

Reports : Business Objects

This is an Intranet site developed for APDF. This site is to grab the required Rows from different databases to an excel sheet, for which parameters are passed by the users. After the necessary changes done by the users, data will be saved in the respective databases, In this project, the Concurrency and the Minimum usage of the system Resources have been tested. Built Pivot reports have been changed to business objects later because of its limitations.

Responsibilities :

• Designing and Development the Application.
• Developed mappings, mapplets, transformations, sessions, workflows.

Confidential

Tools : MS Sql server, DTS

Environment : VBA, ASP, Java Script, VB Script, SQL Server

Reports : Business Objects 4.1

This is an Intranet site developed for the HP Asia Pacific region to forecast the future sales by analyzing the past sales, this site is to maintain the 18 months rolling forecast for the various product lines. Rolling forecast are assessed for every Quarter, which are divide in a year, Users are again categorized into three hierarchy groups CMDs, MDMs and Management. All the CMD Country managers will be able to access the units forecasting tool where as MDMs and Management were given access to pricing and units forecast.