Manager Developer

Srinivas Karangula

Fremont, CA

Cell: 510-***-****

**********@*****.***

Professional Summary

IT Professional with 15 years of strong experience in Analysis, Design, Development, Maintenance and Production Support of Database, Data Warehousing ETL processes and Data Architecture.

Core Qualifications

Extensive experience in Data Warehousing ETL tool (Informatica Power Center and Data Integration Hub).

Worked extensively in Oracle SQL/PLSQL, Developed Packages, Stored Procedures, Functions, Triggers, Cursors and PL/SQL components.

Extensively worked on data extraction, Transformation and loading data from various sources like Oracle and Flat files etc.

Expertise in UNIX commands and shell scripts.

Hands on experience in tuning Informatica power center mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Experienced in working for the post development cycle and applications in Production Support.

Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.

Excellent interpersonal and communication skills for efficient client interaction.

Experience in leading teams, handled multiple roles, Technical and functional assistance to team members.

Experience in SDLC –Water Fall and Scrum (Agile)

Motivates team to meet development goals

Provides mentorship to junior programmers

SKILLS

RDBMS: Oracle 11g/10g/9.x/8i/7.x, SQL Server 6.5/7.0

ETL Tools: Informatica Power Center 8.6/9.1/10/1, Informatica Data Integration Hub 10.1

ERP: Oracle Applications 11.x

Operating System: MS-DOS, Linux, UNIX, Windows XP

Languages/Utilities: C, SQL, PL/SQL

GUI Tools: Developer 2000 (Oracle Forms & Reports 6i)

Scheduling tool: Stone branch UAC.

Other Software: TOAD,SQL Developer

Education

Bachelor of Engineering

Osmania University

Experience

Technical Lead, EPAM Systems 12/2003 – 10/2018

Projects

1.Technical Lead, Hachette Book Group, NY 06/2016 – 10/2018

Participating in requirement meetings and design walkthroughs to understand the business requirements and created specification documents

Providing estimation for the scope of the work

Designed conceptual data model as per project requirements.

Developed Logical and Physical database models.

Extensively worked on Design and Development of Oracle Procedures, Functions and Packages.

Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle and Flat files and loaded into Oracle.

Conducting peer review for the scope items developed by team members

Conducting code and design walkthrough of modules developed with the client

Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.

Created Deployment of workflows to higher environment using Informatica power center Import Export Utility.

Performed mapping Review using Informatica Code Review Tool.

Deliver new and complex high quality solutions to clients in response to varying business requirements

Designed the logical and physical data modeling

Providing support for Defect handling, Bug fixes, and production tickets

Scheduled Informatica power center jobs using Stone branch UAC

2.Technical Lead, Radian Insurance Inc. PA 05/2011 – 05/2016

Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle and Flat files and loaded into Oracle.

Created technical design documents and mapping documents for ETL.

Created data model and ETL design according to requirements and developed Informatica power center workflows

Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.

Created Informatica power center mappings, sessions and workflows.

Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica power center Designer.

Debugged and fixed bugs in Informatica power center Mappings.

Involved in requirements gathering (Reports/Dashboards), analysis, design, used various data sources, development and implementation of the project.

Provided production support to resolve production issues.

Deployment of ETL and DB changes to higher environments.

Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for ETL.

Extensively used ETL to load data from source systems like Flat Files into staging tables and load the data into the target database Oracle.

3.Technical Lead, Portico Systems, PA 08/2007 – 04/2011

Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.

Extensively worked on Design and Development of Oracle Procedures, Functions and Packages.

Developed new DB objects like stored procedures, packages, functions and triggers as per the business requirements.

Developed scripts for data conversion and referenced data.

4.Technical Lead, Staples, MA 06/2005 – 07/2007

Responsible for managing scope, planning, tracking, change control, aspects of the project Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Leading the offshore team and Coordinating with the onsite team.

As an on-site coordinator, closely interacted with end users and client employees in fixing production issues.

Identify recurring issues and perform Root Cause Analysis reporting

Involved in development of Technical Design Specification (TDS) documents and development and testing of reports in AP, AR, FA and GL.

5.Developer, Lion Apparel, OH 12/2004 – 05/2005

Deliver new and complex high quality solutions to clients in response to varying business requirements

Developed Custom Budget form to maintain budget information for customers

Defined Customer hierarchy using customer relationships.

Customized Sales Order form to display budget for customers and calculate allowances accordingly.

Developed Custom Invoice report to display budgeted items and allowance details.

6.Developer, McDonalds, IL 09/2004 – 11/2004

Communicating with clients for gathering business requirements

Developed SQL scripts for Data Migration from Access to Oracle

Used htp and htf packages embedded in PL/SQL for developing forms

Tested and implemented all developed forms

Worked on implementation and production support.

7.Developer, Igloo Corporation, TX 12/2003 – 08/2004

Data conversion of Material Cost from legacy system to Oracle.

Developed Custom Sales Order form and interface program to import the Sales Orders

Developed Custom Scrap transaction form and interface program for scraping of items

Developed Price Adjustment discounts package to find out duplicate discounts

Developed various reports according to the client specifications in AP, AR, PO, OM modules using reports 6i and discoverer

Senior Software Engineer, Zensar Technologies 04/2003 – 12/2003

8.Developer, Electronic Arts, CA

Upgrading of Oracle Applications from 11.0.3 to 11.5.9

Migration of Forms 4.5 to 6i and Reports 2.5 to 6i

Migration of Views, Functions, Procedures, Triggers, Packages

Designing, developing and customizing Forms, Reports, Packages, Procedures, Triggers and Functions using Oracle tools

Involved in registration/migration of concurrent programs, executables, Creation of responsibilities, request groups, sets, menus, values sets, request sets, forms, functions in System Administration & AOL

Contact this candidate