PROFESSIONAL EXPERIENCE

Hitech Industry [*+ billion in revenues] · 2007-Present

(AUTODESK Inc.)

Data Warehouse Administrator(Build Engineer) & Release Manager

(Build & Release team) – Informatica & Business Objects

As a Data Warehouse Administrator & Build Engineer –

· Responsible for setting up various non-production landscapes/environments which also includes installing Informatica & Business Objects & upgrading

· Developed Bo Universes for various Marts(Eg. Revenue Marts, COGS, PIPS, etc

· Installed and configured BO SAP BW Integration Kit for XIR2 version on BO Windows and Solaris servers

· Installed & configured Informatica 8.6.1 and applied the Hotfixes

· Creating & setting up various users & providing different type of accesses in BO & Informatica

· Doing DW builds(Informatica & Business Objects) from DEV to QA from the build docs submitted by various DEV teams

· Worked on automating the builds to reduce the manual build time spent by the build Engineers

· Post the build calendar in shared point for reference to QA & DEV teams

As a Release Manager -

· Direct project and program releases for major applications with budgets up to $30 million.

· Coordinate with various project managers and work on the complete Project plan for the various Releases

· Open RFCs & ERFCs through IT Change Management and get their approvals during the Mock-GoLives & Go-Lives

· Post the project plan and release dates with the release calendar on the shared point site for others to access

· Leverage waterfall and agile methodologies to plan project releases.

· Oversee release of applications into target environments. Monitor all application environments.

· Coordinate both onshore and offshore development teams to drive successful release of web-based products and packaged applications.

Conduct brown bag sessions to ensure dissemination of knowledge.

Great-West Life & Annuity now CIGNA 2001 - 2007

Denver CO

Lead Developer

As a Data Warehouse Developer – Informatica – conversion of FACETS data

· Interacted & Coordinated with Systems Analysts & Business Users in analyzing & gathering the

Business requirements.

· Created 38 database views using TOAD and used them as source tables. Also identified Target

tables and designed, developed and did testing of ETL Mappings according to Business Rules using

various Informatica Transformations.

· Extensively created Re-usable Transformations, 38 Mappings/Mapplets, Workflows/Worklets to

standardized Business logic.

· Extracted data from Oracle database and various Flat files.

· Converting/implementing Facets data to the current system/environment and integrate/retrofit this data into the current applications for the Members, Group and Claims data.

· Extracted millions of claims data from Oracle database.

· Wrote Shell Scripts to insert/move data into different databases for testing purposes.

As a Web Developer – C# & .NET - Licensing to SFDC (SalesForceDotCom)

· Designed & Developed the Licensing to SalesforceDotCom (SFDC) extract.

· The data for Brokers & Brokerages Licensing data is extracted for Oracle database and

inserted/updated into SFDC website (www.salesforce.com) using C# and Web Services.

As a Web Developer – C# & .NET – Production support of www.mygreatwest.com

· Involved in designing and developing the Web Applications for the Members Portal site,

www.mygreatwest.com and www.greatwesthealthcare.com/providers , Secured Provider Portal site.

· Did various dynamic web content, forms & reports on both the website applications to display members

and providers data.

· Did development and support these web applications. The develpement tickets were handled through

PR Tracker system and the support tickets were handled through the AR Remedy User.

Oracle Corporation 2000 - 2001

Senior Consultant

As a Senior Developer – Oracle DB, Oracle Applications

· Worked on Oracle Reports for HR & Payroll module – conversion project from PeopleSoft HR to Oracle HRMS

· Wrote PL/SQL scripts and SQL*Loader scripts for Financials and Accounting to change Financials calendar

· Worked on Billing Conversion project with various Oracle tools to load the data

· Worked on Outbound Interfaces from Payroll to GL

SYSTEL, INC., Farmington, Michigan 1999-2000

IT consulting services provider

Developer - GTE Internet Working, Boston

(Oracle, Actuate Reporting - Conversion from Oracle Applications to SAP)

Circuit Tracking System (CTS) & Asset Tracking System (ATS):

· designing and developing new reports and customizing the existing reports using the Actuate Reports

and Libraries and the database used is Oracle. T

· the various reports are the AOL, Planet and the Drill down Invoiced Cost Reports running for the GL Accounts

and the different Report Categories. Here, the Actuate reports are converted into HTML Reports and run in

HTML including the Java Applets into the HTML Reports.

· the Circuit, City and the top level drill-down reports are processed and generated for all cost variations

and summarizing the various costs. Each report is allocated to different libraries and assigning

different parameters to the different library modules.

· these changes include the conversion from Oracle Applications to SAP, running on different databases.

Developer - Aurora Public Schools, Denver

(Oracle-HR, Oracle Reports 2.5, PL/SQL 2.3)

· Designed and developed the reports in Reports 2.5 for Payroll and the Benefits Departments and

registering the reports in the Oracle Applications using the API’s.

· Defining the parameters and the value sets for the new reports as well as for the customized reports and

was also responsible for the AOL and the System Administration using the API.

· Doing the FTP for the existing reports and the modified reports from the custom directory to the

Oracle Applications in the UNIX Server.

Infosystems, Bombay, India (Off-Shore project) 1998

Developer - PeopleSoft HR Implementation for India’s International Airlines (Air India)

· Analysed the requirements and implemented the PeopleSoft Human Resources 7.0 for Air India.

· Created Records, Panels and Panel Groups using the various PeopleTools, PeopleCode (programming

language in PeopleSoft) & SQL Talk as backend.

· Designed, developed and implemented different Reports for the Payroll application using SQR Reports

as the reporting tool.

· Implemented PeopleSoft Workflow created and integrated the different Business processes and

Business Processes Maps for HR & Payroll Modules.

· Responsible for the System Administration to give the privileges to different users.

ESSAR STEELS, Bangalore 1997 – 1998

ORACLE 7.1, DEVELOPER/2000 & NT SERVER

ENTERPRISE RESOURCE PLANNING –

· Designed and developed the integration of the modules.

· This system is an integrated set of modules working together to provide comprehensive planning,

control and management tools for achieving Computer Integrated Production System.

· This system consists of the following modules: Purchase order, Inventory, Invoicing, Sales, Payroll,

Debtors Ledger, MRP

· Develop reports using Forms 4.5 & Reports 2.5 - participated in user meetings to gather the requirements

and created specifications Designing and System documentation.

Created documents in detail for the modules developed.

HINDUSTAN PETROLEUM & CHEMICALS, Bangalore 1997

ORACLE 7.1, DEVELOPER/2000 & NT SERVER

FINANCIAL ACCOUNTING –

· Designed with the object of simplifying the tedious task of financial accounting. This software is used to maintain the balance sheet and profit and loss account of a company.

· Reports are generated from the various vouchers maintained by the company which are Cash Voucher, Bank Voucher, Sales Voucher, Journal Voucher, Ledgers, Trial Balance, Trading, Profit and Loss Account helps in determining the Net Profit and Net Loss.

· Involved in creation of user-interface screens for Form modules, LOV’s and various billing Reports

(Internship) - VISAKHAPATNAM PORT TRUST 1996

Oracle 7.1, Forms 3.0, Reports 1.1, Menus 5.0, Pro*c with IBM RS-6000 with AIX

Export & Import Application on shipping –

· Designed to accomplish the function of maintenance, queries, reports.

· Reports are generated at different stages for query of data, user help is also prepared to assist user with the functioning of application developed under different divisions.

· The system provided user interface screens for maintenance and generation of reports. The bills are prepared once the cargo is discharged from the berth.

· Tracking the cargo and creating the SQL tables with referential integrity.

· The queries were developed using SQL*Plus. Developed stored procedures and the cargo handled should not exceed the limits.

FORMAL EDUCATION

Master of Computer Applications

Andhra University, Visakhapatnam, India

Bachelor of Science, Computer Applications

Andhra University, Visakhapatnam, India

TRAINING COURSES

Release 11 Inventory Module at Oracle University, San Francisco, CA

Enterprise DBA Part 1A (Architecture and Administration) at Oracle University, San Jose, CA

Informatica 8.6.1 (For Admins)

C# .NET for Developers

IT Change Management

Project Management Professional (PMP) Certification - Project Management Institute (in progress)

Oracle RAC seminar and training

Contact this candidate