SUMANA NUTALAPATI

SUMMARY

Highly motivated, quality oriented, friendly, ORACLE, PL/SQL, Informatica, ETL, Data Warehouse, Data mart, OLAP Cubes and Business Intelligence, Performance Point Dashboard developer, Data Modeler, Solutions Architect, with excellent knowledge of project management principles, techniques, and processes with a Master’s degree in Science and vast hands on experience at midlevel management positions.

Ms. Nutalapati has 19 years of experience in Oracle and DB2 data bases and 15 years of ETL experience with a wide variety of other programming skills and languages on an assortment of hardware platforms meeting Sarbanes Oxley requirements including ten years of expert Informatica Power Center skills using Control M scheduler.

Background includes successful Life cycle implementation of marketing and sales Data Warehouses resulting in being considered as subject matter expert on several projects and appointed technical/functional lead/midlevel manager on several projects.

Combines a superior work ethic with excellent communication, team work and interpersonal skills. Willing to learn and constantly adjusting skill set with minimal learning curve to the cutting edge technology in the market place.

TECHNICAL SKILLS

Environments: UNIX, AIX, Windows 95/98/NT/2000/XP, LINUX, DOS, Mainframe, WWW

ETL Tools: Oracle, Informatica Power Center 5.x, 6.x, 7.x, 8.x, 9x, 10v, TIBCO, AIX- Import Export, FTP

Schedulers: SQL*Loader, Control M, Crontabs, Oracle

Languages: UNIX shell, SQL, PL/SQL, Perl, Pro*C, C/C++, Java, RPG, HTML, DHTML, Java Script, AVS Script, .NET C #, MDX

Tools: M.S project, Business Objects, WEBI, Telnet, Qlikview, Microsoft C++, Access, Excel, Visual Basic, Open Link, Source Control software (VSS), TIBCO BW 5.x, TIBCO EMS, BMC Patrol, Microsoft Visio 2010, SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS) for OLAP Cubes, Microsoft Visual Studio 2010, SharePoint 2010 (Performance point Dashboard Designer)

Databases: Oracle V 7.x, 8, 8i, 9i, 10G, 11G, SQL Server 2008, Access, DB2, AS/400, MVS, NETEZZA

Data Management Tools: SQL*Plus, Toad, Detail Navigator, SQL Navigator, PLSQL Developer

Data Modeling Tools: ERWIN, ER Studio, Microsoft Visio 2010

PROFESSIONAL EXPERIENCE

Amsys International, Houston, TX Dec 12 –Current

Lead/Architect

Responsibilities:

Lead on a well integrated information system for Sales & Marketing department of a Houston based oil and gas giant.

Submit project proposals to architecture group with a well conceptualized, fact based, project stream that are simple enough for the executives to visualize the advantages of executing the projects and approving them.

Used PMO Project Management Methodology, and work with project team members to help plan projects from start to finish, with built-in contingencies, aligning to the other project plans within the portfolio to manage projects, develop proje ct documentation for time and budget.

Evaluate employees, stream line year end team goals to align with company goals and analyse areas for improvement.

Escalate project issues as appropriate to executives, provide updates to keep everyone in the loop about project progress.

Present recommendations on team members to magement for consideration of bonus, pay raise and other company recognitions and incentives.

Assign roles to team to monitor and maintain various processes Accepting Customer Purchase Order, Customer History Maintenance, Comparative analysis, Customer Feedback, Customer Follow-up, Analysis of Lost Order, etc. in a real time production support environment

Develop/Supervise development of PLSQL code and Informatica mappings for the project to handle all the activities regarding sales and marketing and streamlining the information flow between various data marts.

Find best options and possibilities for including new jobs to run on an already tight production schedule to generate various daily/weekly/monthly transaction reports.

Responsible for Overall: System Study, Analysis [SRS], Design [SDD], Resource allotment, Employee evaluation, offshore-onshore coordination, Coding, Unit Testing, System Testing, Regression Testing, Implementation and Documentation.

British Petroleum, Houston, TX Apr 12 – Nov 12

Solutions Architect

The main aim of this Energy giant’s project is to enhance/rebuild the existing traction application (HSSE) to make it more flexible and easy to understand the risks across the organization to prevent recurrence of incidents. Reporting system and Dashboards were created for capturing KPIs on top of the new Data Mart. It is used for recording Injuries, occupational Health/Illnesses and Road accidents that occur during the course of working activities.

Responsibilities:

Worked directly with clients and BAs to understand and envision future requirements

Gathered Functional specifications in addition to the incompletely documented requirements.

Conducted Data Profiling and Data Analysis on the Common data model that supplies data to the data mart and contributed to the HLD for it.

Designed a dimensional model data mart incorporating the old system’s best features, new requirements and envisioning enhancements.

Created a slightly denormalized Data mart with Fact tables, bridge tables and Dimensional tables (both standard, and hierarchical tables) maintaining all referential integrity, designed to support a global Reporting BO Dashboard across all subsidiaries based on specs from an existing small scale favorite dashboard.

Contributed to the Detailed Design for ETL Solutions.

Wrote PLSQL procedures and packages with complex SQL logic in Oracle 11g as well as Informatica 9.0 .1 mappings to populate the tables using industry defined and data base driven best practice sequence of population.

Contributed to the Detailed Design for Dashboarding Solutions and Reporting Solutions (Standard Adhoc) using Business Objects 6.0

Worked with Architects of related systems for peer reviews and solution analysis

Presented the data mart design to client SMEs and explained/impressed and defended design decision forks.

AIG_VALIC, Houston, TX Jun 11 – Apr 12

Sr. Consultant

In one of the largest life insurance organizations in the United States based on over $236 billion of admitted assets as of June 30, 2011. Serving over 18 million customers, comprising of several leading life insurance and retirement services businesses. The unified businesses offer a comprehensive suite of life insurance, retirement savings products and guaranteed income solutions through an established multi-channel distribution network that includes banks, national, regional and independent broker-dealers, career Financial Advisors, wholesale life brokers, insurance agents and a direct to consumer platform.

Overcame challenges associated with the understanding the business user requirements, scoping the project, providing accurate estimates, building a quality solution, & meeting the estimated deadlines.

Responsibilities:

Key contributor on project initiatives. This includes all aspects of the software development life cycle including requirements analysis, systems design analysis, system’s design documentation, programming, performing unit/systems/integration testing, supporting user acceptance tests, and releasing the solution into production. Provide smaller scale enhancements to systems supported by the Architecture.

The Data warehouse Architecture team supports approximately 90 tools. Demonstrated minimal learning curve associated with learning those tools, the business, and processes and procedures. Learned the tools and applications supported by the Data warehouse team and demonstrated capability of providing production support, troubleshooting, and issue resolution during on-call rotations with limited guidance including troubleshooting, incident resolution, & error remediation.

Designed Fact tables and Dimension tables for Data marts for data to be reported in OLAP Cubes including MDX calculations and KPIs in SQL Server Analysis Services application (BIDS) and via simple Excel spread sheets catering to all levels of user capabilities. Published the reports in Performance point Dashboards on SharePoint sites.

Populated the tables using PLSQL packages / procedures / functions / objects incorporating advanced SQL like analytic functions.

Created, supported, maintained, and enhanced a variety of proprietary web systems, tools, and applications using Oracle technologies (while migrating from 10 to 11), Visual Studio, SQL Server Analysis Services Business Intelligence Development Studio (BIDS) & SharePoint - Performance point Dashboards.

Present basic to mid level reports to display the data mart data and KPIs using Business Objects Full client.

MX Energy, Houston, TX Feb 11 – Apr 11

Sr. Integration Analyst

At this natural gas and electricity retail supplier primarily monitors incoming and outgoing data. Primary responsibility is application support including reading code and troubleshooting from a development perspective. Works on finding trends with error logs and makes code fixes. On receipt of data, would troubleshoot and resolve issues related to overall application health. Identifies issue trends and patterns and works on developing solutions to prevent future issues of the TIBCO middleware system Interfacing with Lodestar, UDS and SIEBEL downstream & GIS system upstream.

This company implements Agile methodology for project management.

Responsibilities:

Duties include design and coding of new enhancements, daily monitoring of transaction flow and responding immediately to service tickets. Additionally, coordinating any product upgrades and communications with the vendor is required.

Monitored files and transactions to and from utility in middleware. Troubleshoot missing or late files on a newly developed web based Dash board written in heavy java based silver light. Job needed research in hands on work queue search and data base search via advanced SQL.

Worked on system enhancement and project development efforts thru creating fresh and debugging existing PL/SQL packages and TIBCO mappings.

Participated in an on-call rotation for application support during non business hours or upgrades.

Performed all job functions within the established internal controls framework for the area, including the key controls identified for Sarbanes-Oxley compliance.

Ensured that any known internal control problems/issues/concerns are identified & communicated on a timely basis to immediate supervisor - a senior director.

Amsys International, Houston, TX Jul 09 – Jan 11

Sr. Consultant

Responsibilities:

Oracle Projects: Healthcare:

Wrote PL/SQL packages to calculate Missing Information and Determining Eligibility in the processing of a Medical/Health Families Application.

Functional Lead of a team of developers and analysts responsible for the creation and maintenance of reporting applications for a mid-size health care insurance organization in a mixed Oracle environment.

Worked with project managers to give work estimates and advised on design. Trouble shoot, fixed, and implemented bug fixes and enhancements within tight deadlines.

Wrote Advanced Queuing database package to send messages to clients based on events.

Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling. Documented business rules, functional and technical designs, test cases, and user guides.

Retail:

Gathered business requirements & designed Order Entry Data Mart for a large retail organization.

Designed and developed a series of Informatica ETL processes to allow for the addition of new capabilities to a 10 TB data warehouse in an engagement that came in on time and well under budget.

Mentored client development staff in the effective use of PL/SQL and SQL optimization.

Wrote SQL scripts and developed BI solutions using BI tool called Qlikview.

Designed and developed SQL and PL/SQL code, to enhance performance of ETL jobs.

Designed Fact tables and Dimension tables for Data marts for data to be reported in BO Dashboards. Populated the tables using Informatica.

Energy: Endur Project:

Endur consultant on an integrated Energy application, meeting the most demanding business and technical requirements and, providing highly customized straight-through processing (STP) solution to cover each component of a transaction's life cycle for the oil/gas commodities traded enabling client to make precise, comprehensive and timely decisions.

Provided the Global Energy Back-office (GEB) solution focusing on productivity improvement and cost reduction by streamlining back-office processes and workflows and eliminating manual workarounds throughout the entire life-cycle of transaction management, from start to finish.

The Endur-based back office automated and optimized (by Debugging legacy AVS scripts) an extensive range of traditional back-office tasks such as trade confirmations, settlements, accounting and end-of-day reporting, (sub-ledger posting, standard system reports and integrated third-party reporting tools).

Helped manage cash forecasting, profit & loss attribution, reserve calculation and/or distribution, regulatory reporting, tax calculations, balance generation and financial settlement details.

Sysco Corporation, Houston, TX Feb 00 – Jun 09

Programmer/Analyst

Worked on the Executive Information System, on an Oracle data base while simultaneously working as an ETL and Informatica developer on a Data Warehouse project for almost 9 and half years.

Joined the company as an Oracle developer, supporting an Oracle database on AIX system with AS/400 (RPG) and Mainframe (MVS) as source systems using business objects as the front end reporting tool. This used to be the functional data warehouse of the corporate office until an official data ware house was implemented in 2001. Continued supporting this system as part of production support, maintenance and was on On-call rotation even after being absorbed into the data ware house project proving the ability to multitask at every level.

Responsibilities:

Executive Information System (EIS) System:

Worked in Decision Support Group (DSG) on Oracle production support team and on-call support simultaneously on many life cycle projects

Considered subject matter expert (SME) on EIS

Worked as functional lead on many projects that are related to this Oracle system

Gathering the functional requirements from users and converting them into Technical requirements & get sign-off from Manager/DBA/Architects to maintain a database for a reporting system on the Business Objects front end (full client) and a VB front end called SOLAR connected to the Oracle data base thru ODBC.

Performed SOLAR production support along with being on the 24/7 on call rotation.

Created DB tables in Oracle, altered tables with new data types. Created database packages, procedures, functions, triggers, views using Oracle PL/SQL.

Debugged and rewrote existing PL/SQL packages and stand alone stored procedures and functions to help fine tune them.

Consistently performed fine tuning on the PL/SQL objects to enhance performance and for efficient data fetch.

Analyzed performance of database objects and suggesting DBA for Indexes, schema gathering, and Explain Plan

Employed table partitioning based on fiscal year as a performance enhancer on huge database tables running up to billions of records

Used table partitions to create smaller and more manageable pieces of data for faster access of data and reduced recovery time.

Used SQL* Loader and export/import mechanism for data migration for bulk upload at both the table level and partition level.

Implemented PL/SQL to perform application security and batch job scheduling

Wrote Unix shell scripts for data files handling, FTP and executing the SQL*Loader.

Migrated PL/SQL Code from Oracle 7.34 to 8.0 and implemented Object types.

Actively involved with DBA in migrating the Oracle 7.3.4 database on Windows NT platform to Oracle 8 on AIX platform and deployment of objects to production environment.

Worked with other teams like financial, operations and Supply Chain to help out during lax times gaining knowledge of the team mechanisms for better utilization of knowledge.

Performed thorough Unit testing, System Testing and User Acceptance Testing in development environment for the result of error free and smooth migration process and provided quality work for functional users.

AFNA Report:

Considered subject matter expert (SME) on the AFNA reports

Gathering the functional requirements from AFNA (Air Force –non appropriated) customers and converting them into Technical requirements and get sign-off from relevant Manager / DBA / Architects.

Worked with DBA team to Create DB tables in Oracle.

Created database packages, procedures, functions, triggers, views using Oracle PL/SQL while analyzing performance of database objects & suggesting DBA for Indexes on appropriate tables.

Used if/then/else statements extensively in the packages to ensure customer requirements and exceptions are handled appropriately.

Ensured end user satisfaction thru direct contact and exceptionally patient communication.

Customer Transfer Process:

Since the company is a food distribution company with 64 warehouses all over the USA and Canada, when customers transferred from one Territory to another, new customer numbers were assigned but their sales history was transferred to the new warehouse to be able to run This year-Last year reports and Forecast reports.

Considered subject matter expert (SME) on Customer transfer process

Worked as functional lead on the customer transfer project

Gathering the functional requirements from users to understand the process in depth.

Debugged some legacy stored procedures written by Anderson Cooper consultants.

Responsible for writing fresh stored procedures, functions and packages to help with the efficiency of the process, to maintain the integrity of the data and the user friendliness of the project so other programmers could easily take on the project.

Ensured the correctness of data after transfer from one Oracle data base on UNIX to another Oracle database on UNIX server on the Business Objects front end (full client) and a VB front end called SOLAR by checks and balances

Designed a project that collects data from one Oracle data base to another on one AIX platform to another via Export/Import, FTP, SQL* Loader PLSQL packages.

Conducted knowledge transfer sessions among team to facilitate rotation of duties.

EOY Project:

Considered subject matter expert (SME) on End Of Year (EOY) project in EIS system

Worked as functional lead on the End Of Year (EOY) project

Debugged stored procedures and error handling processes of marketing and sales system dealing with downloading data from the source system (AS/400) and massaging the data to reflect ITEM-CATEGORY changes and uploading data back to the master system

Implemented the scheduling strategy

Participated in unit and system test process

Organized a complete life cycle process of the project every year from June 1st week to usually 10 days past the designated financial year end

Performed troubleshooting and providing resolutions to issues

Develop, test and implement break/fix change tickets

Develop, test and implement enhancement requests

Respond to calls from users who checked data on the Business Objects front end (full client) and a VB front end called SOLAR.

Provide on-call 24x7 support to 67 operating companies (Sysco warehouses)

ETL & Informatica developer on a Data Warehouse project. Primarily using Informatica PowerCenter 8.2, 7.1, 6.2 and 5.1 to maintain and enhance corporate Data Warehouse. Has Been with the company to have seen the Installation of a data ware house from the conceptual stage to, business requirement gathering, to installation, configuration, development and maintenance of a data warehouse. Has been on the primary and secondary on-call cycles thru the entire process. Designed testing requirements and code modules according to specifications and standards (SOX compliant). Prepared test plans and modules. Worked within a team to contribute to the successful delivery of a data warehouse from the ground up thru the creation, development, maintenance and enhancement of a corporate Data Warehouse with Business Objects front end (both full client and web based BI). Worked with data sourced from several disparate data sources including real-time and legacy AS/400 databases.

ETL & PowerCenter developer on a full-lifecycle Data Warehouse project on an AIX server. Migrating using Informatica PowerCenter 8.2 to develop and enhance programs to migrate data sourced from third party customer compliant software to reporting data marts.

Responsibilities:

ETL and Informatica developer on Data Warehouse project utilizing Informatica PowerCenter 8.2, 6.2 and 5.1 to maintain and enhance corporate Data Warehouse.

Designed testing requirements and code modules according to specifications and standards (SOX compliant).

Contributed to the successful delivery of a data warehouse from the ground up thru the creation, development, maintenance and enhancement of a corporate data warehouse with Business Objects as front end (both full client and web based BI).

Data sourced from several disparate data sources including real-time and legacy AS/400 databases.

Migrated data utilizing Informatica PowerCenter 8.0 to develop and enhance programs to migrate data sourced from third party customer compliant software to reporting data marts.

Primary customer side contact to Informatica customer service representing Sysco to trouble shoot system installation problems and patch installations

Hepled install and manage NETEZZA on LINUX

Reviewed prototypes and developed iterative revisions with business partners

Responsibilities included working with the Data Warehouse Architect to perform source system analysis and identification of key data issues via analysis of the data profiling queries and results

Supported data marts supplying data to the dashboards displaying key metrics and KPIs.

Involved in analyzing requirements for data mart design and creation.

Assisted in the creation of ETL design specifications

Developed Informatica mappings, mapplets, workflows and worklets

Designed and developed error handling processes

Responsible for the implementation of the scheduling strategy

Scheduled and monitored jobs on a scheduling tool called Control M and oncall monitoring on BMC Patrol

Participated in unit and system test process as well as in Regression test processes

Developed, tested and implemented break/fix change tickets and enhancement request

Provided on-call 24x7 support to 67 operating companies (Sysco warehouses)

Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental jobs to provide data for data warehouse using many systems like Informatica, export import and FTP

Created complex jobs to populate Marketing-and-Sales data mart to prepare reports for new sales campaigns.

Created complex jobs to populate historical data to enable this year/last year comparisons as part of the Decision Support Group’s Marketing-and-Sales data mart.

Migrated data sourced from relational sources like legacy Oracle data base, legacy AS/400 System and from two mainframe systems.

Loaded data from flat files, XML files and other cached sources.

Developed and maintained DB2 stored procedures to run automated processes to reflect the customer transfers taking place at the Sysco warehouses.

Created and maintained numerous UNIX Shell/PERL Scripts for data migration.

Primarily responsible for ETL of several large Oracle tables (billion plus rows) into relational data warehouse model.

Populated production warehouse data utilizing UNIX shell scripts, Telnet, SQL, Perl with DB2 and DB2 stored procedures.

Replicated existing production AS/400 objects/members into DB2 tables during ETL thru Informatica mappings.

Created programs to extract data from former Excel system using UNIX shell scripts and AWK and SED.

Created database packages, procedures, functions, triggers, views using Oracle PL/SQL.

Analyzed performance of database objects and suggesting DBA for Indexes, schema gathering, table partitioning and Explain Plan.

Utilized SQL* Loader and export/import mechanism for data migration for bulk upload.

Implemented Cron jobs on AIX to perform application security and batch job scheduling

Migrated PL/SQL Code from Oracle 7.34 to 8.0 and implemented Object types.

Actively involved with DBA in migrating the DB2 6.0 database to DB2 7.x on AIX platform and deployment of objects to production environment.

INSYS Inc., Harrisburg, PA Feb 96 – Feb 00

Senior Programmer

Converted data from non-oracle Systems to Oracle databases by using stored procedures and functions. Created numerous stored Procedures and functions to perform repetitive jobs.

Responsibilities:

oDeveloped scripts and procedures in the development and support of an Oracle system. Worked in various team sizes performing cross-functional roles.

oRequired substantial development in creating stored procedures, PL/SQL Packages, Triggers and Functions.

oUtilized the knowledge in Oracle cursor management and exception handling. Worked on supporting accounting operations using Forms 3.0/ Reports 2.5.

oCreated numerous custom reports and forms using Oracle Reports 2.5 and Oracle Forms 3.0. These custom reports and forms are then incorporated into the Applications.

SABOO Automotive, India Jul 93 – Oct 95

Junior Developer

Junior Oracle developer on Supply chain project. The job involved experience in Oracle Forms and Reports, extensive use of Oracle PL/SQL, SQL on UNIX platform.

Responsibilities:

Worked in various team sizes performing cross-functional roles. Required substantial development in creating stored procedures, PL/SQL Packages, Triggers and Functions.

Utilized the knowledge in Oracle cursor management and exception handling.

Supported a Contract Management System application using Visual Basic 4.0 as the front end, running on Windows and Oracle as back-end running on Unix.

Created stored procedures to generate One month and Twelve month Starmail Reports for IVR customers.

Developed shell scripts to automate the report generation process.

Maintained crontab jobs Converted the crontab jobs into Appworx (Job Scheduling Software).

Interacted with users and customer of 2 different applications to resolve problems

EDUCATION

Post Graduate Diploma from National Institute of Information Technology – 1994

Master of Science – 1993

Bachelor of Science - 1991

TRAININGS

Amsys International - Open Link, updates on several technologies already working in – 2010 -2013

Sysco Corporation UNIX, db2, Informatica, Business Objects, control M, Crystal Reports & Numerous Other on Job Trainings – 2000 – 2009

Comp-u-learn Institute of Technology Oracle Upgrade – 1996

Contact this candidate