Project Engineer

MANI PEPAKAYALA

303-***-**** • abnr3s@r.postjobfree.com

DATA WAREHOUSE RELEASE ENGINEER / SENIOR ORACLE CONSULTANT

Highly skilled Data Warehouse Administrator & Developer, Release Manager, and Build Engineer. Proven track record

successfully leading all phases of project management through the software development lifecycle to ensure timely

and accurate product releases. Excellent analytic skills and strong talent for uniting development teams.

Worked in Healthcare industry as well.

AREAS OF EXPERTISE

Business Skills

Release Management • Oracle Development • Data Warehouse Administration/Developement •

Web Development • Data Integration • Application Installations • Quality Assurance

Technical Skills

Informatica 7 & 8.16, Business Objects XIR2/XIR3, Oracle 11i/RAC, SAP BW, Actuate, OLAP, ETL, ERP, Shell Scripting,

TOAD, SQL, PL/SQL, SQL*Loader, LoadRunner, C# .Net, C, HTML, JavaScript, UNIX, COBOL, AS/400, ISO 9001, Crystal

Reports, Dreamweaver, MS Project, MS Visio, MS Exchange, MS Excel, MS FrontPage, MS Outlook, MS PowerPoint, PR

Tracker, AR Remedy User, AR IT Change Manahement, Mercury Quality Center, Shared Point, Oracle Applications (HR,

AP, Accounting, OE)

PROFESSIONAL E XPERIENCE

Release Manager & Data Warehouse Administrator/Build Engineer

Autodesk Inc., San Rafael CA 2007 - present

Autodesk is a world leader in 2D and 3D design software, which allows customers to visualize and predict product

performance. Currently hold a varied role which included data warehouse administration, build engineering and

release management.

Release Manager

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

project managers to successfully complete project plans for various new releases. Post project plans and release

dates along with information and specifications to the SharePoint intranet site for group access.

Coordinate both onshore and offshore development teams to drive successful release of web-based

•

products and packaged applications.

Leverage Waterfall and Agile methodologies to plan project releases.

•

Oversee and monitor release of applications into target environments.

•

Conduct informal training sessions to ensure dissemination of knowledge.

•

Data Warehouse Administrator/Build Engineer

Install and upgrade Informatica and Business Objects applications. Set up new users and provide various levels of

access to team members. Build high performance data warehouses using build documents submitted by

development teams.

Automate builds to reduce manual build time spent by engineering team.

•

Conduct rigorous quality assurance (QA) to ensure accuracy and reliability of builds.

•

Post build calendar in SharePoint as a reference for QA and Development teams.

•

____________________________________________________________________________________________________

Data Warehouse and Web Lead Developer

CIGNA, formerly Great-West Life & Annuity Inc., Denver, CO 2001 - 2007

Worked as Informatica Data Warehouse Developer to convert FACETS data and also served as Web Developer using

C#.NET to create new applications. Interacted with systems analysts & business users to gather and analyze

requirements. Designed, developed and tested ETL Mappings/Workflows according to business rules, using various

Informatica transformations.

…(continued)Data Warehouse and Web Lead Developer

CIGNA, formerly Great-West Life & Annuity Inc., Denver, CO

Data Warehouse Developer - Informatica

Created 38 database views that ultimately became source tables using TOAD.

•

Successfully created re-usable transformations, mappings/mapplets, and workflows/worklets in

•

order to standardize business logic.

Extracted large volumes of vital claims data from Oracle database and various flat files.

•

Converted Facets data to current system environment and integrated data into members, group

•

and claims applications.

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

•

Web Developer – C# & .NET

Designed & developed the licensing for a Salesforce.com (SFDC) extract.

•

Extracted data for insurance brokers & brokerages licensing from an Oracle database and inserted it

•

into Salesforce.com website using C# and Web Services.

Created dynamic web content, forms, and reports within existing website applications designed to

•

display insurance member and provider data.

Worked on the design and development of web applications for portal sites

•

http://www.mygreatwest.com/ and http://www.greatwesthealthcare.com/providers

Handled development tickets using PR Tracker system and managed support tickets using AR Remedy User.

•

Senior Consultant

Oracle Corporation, Denver, CO 2000 - 2001

Worked with Oracle Databases and created Oracle applications. Actively participated in a conversion project from

PeopleSoft HR to Oracle HRMS using the Oracle Reports for HR & Payroll module.

Wrote PL/SQL scripts and SQL*Loader scripts for Financials and Accounting, designed to

•

change financials calendar.

Worked on Billing Conversion project using various Oracle tools and loading large amounts of data.

•

Successfully created Outbound Interfaces from Payroll to GL.

•

Oracle Consultant

Systel, Inc., Farmington, MI 1999 - 2000

Worked on various IT consulting assignments on behalf of this full service provider of comprehensive, integrated

information technology services and business solutions.

Data Warehouse Conversion Project

Converted an Oracle/Actuate reporting system to SAP at GTE Internetworking in Boston, MA. Designed and

developed new reports for Circuit Tracking System (CTS) and Asset Tracking System (ATS). Customized existing

reports using Actuate Reports and Libraries with an Oracle Database.

Modified Invoice Cost Reports for GL accounts and converted them into HTML reports running Java Applets.

•

Created top-level drill-down reports that processed cost variations and generated summaries of vital data.

•

Allocated reports to different libraries and assigned varying parameters to different library modules.

•

Oracle Development Project

Participated in a data warehouse project for the Aurora Public Schools, Denver, CO system using Oracle HR,

Oracle Reports 2.5 and PL/SQL 2.3. Designed and developed for payroll and benefits departments. Registered

reports in Oracle applications using the API’s.

Defined parameters and value sets for new reports as well as for the customized report modifications.

•

Managed AOL and System Administration using the API.

•

Used FTP to transfer reports from custom directory to Oracle Applications on the UNIX Server.

•

ADDITIONAL EXPERIENCE

Developer – PeopleSoft HR Implementation for Air India

InfoSystems Ltd., Mumbai, India 1998

Oracle 7.1 Developer – 2000 & NT Server (ERP Project)

Essar Steel Ltd., Bangalore, India

1997 - 1998

Oracle 7.1 Developer – 2000 & NT Server (Financial Accounting Project)

Hindustan Petroleum & Chemicals Ltd., Bangalore, India 1997

Oracle Application Development Intern

Visakhapatnam Port Trust, India 1996

EDUCATION & TRAINING

Master of Computer Applications – MCA

Andhra University, India

Bachelor of Science, Computer Applications – BS

Andhra University, India

Project Management Professional (PMP) Certification (in progress)

Project Management Institute, Newtown Square, PA

Oracle Release 11 Inventory Module

Oracle University, San Francisco, CA

Oracle Enterprise DBA Part 1A

Architecture and Administration

Oracle University, San Jose, CA

Additional Coursework

Informatica 8.6.1 & 7.1 for Administrators & Developers(Power Center, Power Connect)

C# .NET for Developers

Oracle RAC Seminar/Training

Contact this candidate