Summary

To obtain a challenging position with a people oriented and growth minded firm, utilizing skills and knowledge in Software Engineering.

3+ Years of experience in IT with expertise in Client Server, OLTP database systems.

Designed and developed Data Warehouses and Business Intelligence applications using Informatica, Cognos, Oracle and Teradata.

Extensive experience in developing Data Warehouse using Cognos, Informatica, Hyperion Essbase, Oracle, Teradata, Sybase and DB2.

Good skills in OO application development using Java, VB Script

Expert level skills in SQL, MS Access and crystal reports.

Expertise in Web Application Development in Lotus Notes and IBM Web sphere.

Expertise in the concepts of ER Modeling, Dimensional Modeling, Data marts, Fact and Dimension Tables.

Proficient in analysis, design, configuration, customization, upgrade and production support.

Worked with Peopletools 8.47 Peoplecode, application engine, SQR, component interface, PS Query, Data mover and process scheduler.

Worked with different businesses on HR, Finance, Manufacturing and Automotive solutions.

Working Knowledge of data architecture, modeling and database programming.

Support, Development and Administration of Informatica, Business Objects.

Responsible for Setting up User access, File support, Universe etc.

Recommended and implemented design changes to warehouse fact tables and indexes to improve query performance.

Experience in integration of various data sources with Multiple Relational Databases like Oracle, Sybase, SQL Server, MS Access, DB2 and Worked on integrating data from flat files, CSV files, COBOL files and XML files.

Good level of exposure to CMM concepts and Quality.

Software Skills and Knowledge

Skills
PL/SQL, Informatica Power center, Business Objects, Crystal Reports, Cognos Impromptu 7.1, Cognos Power Play 7.1, Impromptu web reports, Perl, Erwin Model, Visio, Unix Scripting, Lotus Script, Java, Peopletools 8, PeopleCode, Application Engine, SQR
RDBMS
Oracle, DB2, Sybase

VB Script, VBA, ADO, SQL, Crystal Enterprise, MS Access 2003, Java, Java Script, ACL, Java Script, XML, Arbortext EPIC, Cognos Impromptu Reports and Report Net, Duration
Oct 2006 - Ongoing

Requirement Analysis, Client Interaction, Design, development and User Training.

Prepares MIS reports by retrieving from different sources of data from SQL Server, Oracle MS Access 2003 and Excel.

Imported and exported data into Microsoft Access databases and debugged VBA scripts linked to the databases

Consolidates data from various sources and created tables for MIS reporting.

Creates reports using EXCEL, Crystal reports. Prepares data using stored procedures and SQL statements.

Developed and customized various LMS End User Reports and Administrator Reports like Course Enrollment, Transcript History and Activity component Register etc.

Designed and developed a database in support of administrative accounting

Writes and maintains process documentation for new or modified processes.

Writes and maintains process documentation for new or modified processes.

Support and Enhancement of Arbortext Authoring Tool using ACL, Java Script, Java.

Worked on Idiom World Server application.

Provided security for Cubes of various User classes. Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.

Customization work in ACL and Javascript

Supported end users in the use of the system.

Modified the existing functionality as per business request.

Involved in testing idiom world server, the global authoring tool.



Employment

2004 -  2006
Consultant

Involved in the analysis, design and development of all the interfaces using Informatica Powermart tools in interface team and interfaced with all the other tracks for business related issues.

Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment

Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse

Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

Involved in developing source to target mappings and scheduling Informatica sessions.

worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences etc.

Involved in designing the Data mart and entire data warehousing life cycle.

Development and enhancement of Crystal Reports.

Involved in Installing Crystal Enterprise 10 in the Maconomy Server.

Developing and modifying existing Reports.

Analyze customizations after running compare reports.

Run upgrade scripts using upgrade assistant.

Retrofit customization in PeopleCode, SQR.

Converted various customized panels in HRMS 7.5 to pages in 8.3

Apply required patches for installed modules.

Gathered requirements from end-users and prepared functional and detailed technical specifications for the implementation of new customizations

Provide production support after the project delivery.

Used SQL and Stored Procedures and automated the reports in Visual Cut tool.

User training and Documentation

Installation of oracle databases, importing the client databases, SQL coding of procedures, triggers, views, other database objects as per client specifications.

SQL Scripts and manupulating data as per business requirements.

Involved in System analysis, designing, coding, unit testing and Functional Testing.

Developing various reports for invoices, quotations, orders etc. using Crystal Reports, as per the business logic.

Was part of scripting team for shell script to automate and migrate data from ODS to Data warehouse.

Development of web based customer service application for ordering of financial documents by partner organizations.

Supported Retail Portal, a multilingual shopping portal developed in Java J2EE. The system runs on IBM Web sphere and Oracle as the Backend Database. Designed data structure according to primary design system, built up tables, views, forms and reports ; coded triggers and PL/SQL blocks and tested programs. Loaded information from a legacy system using SQL*LOADER.

Provided production support for Executive Management Information System, a web reporting portal to Hyperion Essbase and ORACLE data sources. Modified Hyperion Essbase OLAP Server database outlines using the Outline Editor in the Hyperion Essbase Application Manager. Loading text data files using load rules into Hyperion Essbase Microsoft Access and VBA. Developed preprocessing system in Microsoft Access using VBA taking raw sales data output from 4 different systems to create input files for Hyperion Essbase system.

Assignment 3

2004 -  2004
Consultant

Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.

Created standard and Ad hoc reports using Cognos Impromptu. Created Lists, Groups and Cross-tab reports with Drill-through functionality.

Created Multidimensional reports by implementing Multi Dimensional Cubes using Power Play and Transformer.

Provided security for Cubes of various User classes. Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.

Created Impromptu Web Reports and published them on the web server and later on Upfront.

Migrated Crystal Enterprise reports to Impromptu.

On Call Production Support of the files in 24/7

Loading of data through SQL LOADER.

Monitoring and tuning the stored procedures and Project Related SQL queries.

Assignment 4

2003 -  2004
Software Consultant Parish Partner

Education

Miscellaneous

Developed web based Workflow system used to automate the various processes. This system has to work in tandem with the existing ORACLE data warehouse with the front end as Notes so that each and every employee will have access to system. Crystal Reports Enterprise XI is used as a reporting tool to extract data, Oracle data ware house and Lotus Notes.

Developed multi-database Lotus Notes application that downloads data from back end mainframe system. Involved in Integrating Lotus Notes System with Backend RDBMS database using Notrix and Notes SQL tool. Developed and supported Crystal reports tools and integrated with Lotus Notes Databases. This system is web-based application to maintain the workflow for any organization. This application is useful to get the current productivity of each employee and helpful to increase the productivity by taking necessary steps. This application is managing the resources and assets of any organization, Attendance and Leave management, Pay roll Management, Inventory Management system, Asset and Resource management system.

Page 2 of 4