Balasubrahmanyam Irusumalla

Profile:

. *+ Years of IT experience

. 7+ Years of Informatica Architect/Lead experience

. 9+ Years of Oracle PL/SQL experience

Summary:

. SDLC: 9+ years of experience in all phases of Software Development Life

Cycle involving analysis, design, development, testing, documentation,

deployment, implementation & maintenance of application.

. Informatica: 7+ years of hands-on experience in designing, developing and

debugging Informatica processes in Data Conversion and Data Integration

environments. Extensive knowledge in Flat files and Relational table's

conversions using Informatica Power Center.

. Extensive experience in tuning of Informatica processes at the mapping,

workflow and server levels.

. Excellent knowledge on third party schedulers like OpCon Scheduler.

. Proven expertise in analyzing business needs of clients, developing

effective and efficient solutions and ensuring client deliverable within

committed deadlines.

. Posse's excellent knowledge and experience in executing informatica

workflows through batches.

. Very strong relational Database skills that include build/maintain PL/SQL

scripts, User Defined Types (UDT's), Stored Procedures, Triggers,

Packages and Functions.

. Been a primary Informatica contact to clients for all develop, support,

upgrade and post-production deployment issues.

. Involved in numerous successful Go-Lives under demanding situations.

. BI: Worked on Cognos ReportNet and Business Objects.

. Database: 9+ years of Database experience on Oracle, SQL and PL/SQL.

Specialized in client server environment with Oracle PL/SQL and UNIX.

. Languages and Tools: Excellent experience in VB, ASP, VB Script, Toad,

Benthic.

. Strengths include strong customer interface and problem-solving skills,

requirement analysis, designing and programming.

. Good team player with excellent Organizational, Analytical, Project

management and Communication skills.

Education Qualification:

. Bachelors in Computer Applications

. Masters in Computers Application

Technical Skills

ETL tools Informatica PowerCenter 8.6.1/8.1.1/7.1

Databases Oracle, SQL Server, MS Access

Reporting Tools Business Objects, Cognos ReportNet

Languages & Tools VB6.0, ASP, SQL, PL/SQL, VBScript, .Net, Toad,

Benthic

BI Tools Cognos Reportnet, Siebel Analytics

Professional Experience:

PA DPW (Pennsylvania Department of Public Welfare), CampHill, PA.

Dec'08-Current

Informatica Architect

Worked on 2 projects of PA DPW (iCIS Incremental Renewal Phase IV-B and

iCIS Incremental Renewal Phase III)

PA DPW - iCIS Incremental Renewal Phase IV-B

Dec'09-Till Date

o Client Notice Redesign - IV-B

o CIS Conversion and Integration

o CHIPRA

PA DPW - iCIS Incremental Renewal Phase III

Dec'08-Dec'09

o Targeting Logic

o Client Notice Redesign

o Workload Dashboard Reporting

Responsibilities:

. Manage a team of business and technical analysts.

. Design functional and technical requirements for various conversion and

integration management projects.

. Assist in the development of scoping and planning deliverables for the

various Integration management projects.

. Develop preliminary technical specs based on future vision and

current business processes.

. Analyze business requirements and design multi-scenario process flows.

. Perform all aspects of the SDLC including project planning, requirements

gathering and analysis, systems design, implementation, integration and

testing, quality assurance, deployment, and maintenance.

. Develop use cases, testing plans and project specifications for both new

applications and ongoing development phases of existing applications.

. Defined and implemented project requirements ensuring market

competitiveness, while meeting client and consumer needs throughout the

product lifecycle.

. Lead cross-functional teams in setting strategy, direction for

development, and release of the product.

. Provided guidance and support on the implementation and re-architecture

of the existing systems.

. Participate in validation of application architecture design and made

recommendations for production release based on client requirements and

inherent risk factors

. Create functional and technical specifications for system design.

. Work with senior management to develop project resourcing plans.

. Coordinate problem resolution efforts with the technical analysts and

subject matter experts including client when necessary.

. Determine best approach to optimally resolve issues in expected

turnaround time.

. Effectively manage relations with multiple teams including technical,

business analysts, account managers, testers and client teams.

. Manage software releases.

Environment: Informatica 8.6.1, Informatica 8.1.1, Oracle PL/SQL, Windows

2003, UNIX

PADPW (Pennsylvania Department of Public Welfare), CampHill, PA.

Feb'07-Dec'08

Technical Lead

PA DPW - iCIS INCREMENTAL RENEWAL PHASE III - Data Exchanges,

Responsibilities:

. Involved from Detailed System Design of the project to the Go-Live.

. Responsible for interacting with the client in all phases of project.

Mainly during DSD, Go-Live and Stabilisation period.

. Heavily involved in knowledge transfer to the Client managers, business

owners and developers on PowerCenter architecture, Migration

methodologies, Error handling methodologies and best practices.

. Shown Leadership skills in managing the account for Informatica, status

reporting, developer training, maintaining issue logs, requirement

analysis and interaction with the business.

. Responsible in creating deisgn documents and visios as part of DSD.

. Responsible in building maps by uses various transformations like

Normalizer, Source Qualifier, Expression, Aggregator, Rank, Joiner,

Lookup, Update Strategy, Stored procedure Transformations based on the

requirement.

. Wrote the PL/SQL procedures for facilitating data extraction,

transformation and loading.

. Involved in documenting data mappings, Transformations and Informatica

Sessions.

. Involved in monitoring the sessions, workflows and worklets using

Workflow Monitor to ensure the data is properly loaded into the

Enterprise Data Warehouse.

. Involved in the error checking and testing of ETL Procedures using

Informatica Session log and workflow logs.

. Involved in manual testing, functional testing and Integration testing.

. Responsible for documenting the bugs during testing and reporting the

same to leads and peers.

. Responsible for performing root cause analysis and reporting.

. Involved in the environment set up for TFP and Production.

. Responsible for migrating code from DEV environment to INT and then to

SAT and finally to Production.

. Responsible for scheduling the workflows using third party scheduler like

OpCon, using DOS batch files and UNIX executable files.

. Migrated from Informatica 7.1 to Informatica 8.1.1.

Environment: Informatica 7.1, Informatica 8.1.1, Oracle PL/SQL, Windows

2003

Agilent Technologies, CA

Nov'06-Feb'07

Senior Informatica Developer

EAST

Responsibilities:

. Updating all the existing technical documents of the ASPEN DW project.

. Preparing the Power Point presentations for facilitating the transition.

. Giving seminars and class room sessions for knowledge transfer.

. Conducting lab sessions.

. Conducting evaluation tests and sessions.

Environment: Informatica 6.1, Siebel Analytics 7.8, Oracle PL/SQL, Windows

2000

Agilent Technologies, CA

Jun'06-Nov'06

Senior Informatica Developer

ASPEN DW

Responsibilities:

. Development of ASPEN DW Change Requests involving Informatica, mappings,

workflows, Production batch-files, SQL - queries, Production Scripts.

. Preparing the environment for ETL, Installation, configuration, access

management, Mock- runs, Exracts.

. Full Load Incremental loading of Dataware house.

. Monitoring the data extracts and data warehouse refresh process on daily

basis, resolving all the failure/issue during the monitoring.

. Handled the various change requests related to Informatica (ETL) and

Analytics for various releases.

. Involved in performing reviews of work items prepared at various stages

of the project.

. Preparation of scripts for efficient error resolution.

Environment: Informatica 6.1, Siebel Analytics 7.8, Oracle PL/SQL, Windows

2000

Johnson and Johnson, CA

Aug'05-Jun'06

Informatica Developer and Oracle DBA

Ethicon Endo-Surgery Enterprise Data Warehousing (EES-EDW)

Responsibilities:

. Involved in performance tuning, Query optimization and technical trouble

shooting in databases.

. Used Informatica PowerCenter for migrating data from various OLTP

servers/databases to the data mart.

. The data migration included identifying various databases where the

information/data lay scattered, understanding the complex business rules

that need to be implemented and planning the data transformation

methodology.

. Used relational sources and flat files to populate the data mart.

. Translated the business processes into Informatica mappings for building

the data mart.

. Created complex Informatica mappings to load the data mart and monitored

them. The mappings involved use of transformations like Aggregator,

Filter, Router, Expression, Joiner, Sequence generator.

. Used Lookup Transformation to access data from tables, which are not the

source for mapping and also used Unconnected Lookup to improve

performance.

. Used Session parameters, Mapping variable/parameters and created

Parameter files for imparting flexible runs of workflows based on

changing variable values.

. Configured the mappings to handle the updates to preserve the existing

records using Update Strategy Transformation.

. Defined Target Load Order Plan and Constraint based loading for loading

data correctly into different Target Tables.

. Used Debugger to test the mappings and fix the bugs.

Environment: Informatica 6.1, Cognos ReportNet, Oracle PL/SQL, Kalido,

Mercury Quality Center

Agilent Technologies, CA

Feb'05-Jul'05

Informatica, Oracle SQL, PL/SQL Developer

SPARC, ORCA, Chips

Responsibilities:

. Involved in performance tuning, Query optimization and technical trouble

shooting in databases.

. Completed development task (Change Request/Project on Request) with in

defined time frame successfully.

. Automated and Scheduled manual process using Oracle jobs.

Environment: Informatica, Oracle PL/SQL, SQL Server, VB, Siebel

ICICI Bank

Mar'04-Jan'05

Informatica, Oracle SQL, PL/SQL Developer

Credit Card Management Information System (CCMIS),

Responsibilities:

. Involved in performance tuning, Query optimization and technical

trouble shooting in databases.

. Created ad-hoc queries as per the user requirements.

. Automated and Scheduled manual process using UNIX Cron jobs.

. Participated in all type of support activities for technical

programmers and business analysts of CCMIS

Environment: Informatica, Oracle PL/SQL, UNIX

GEAM (General Electric's Asset Management),

Nov'03-Feb'04

SQL Server Developer

Real Estate and Financing

. As a team member I was responsible for Code development, test cases

creation and testing.

Environment: VB 6.0, ASP, SQL Server 7.5

Developed for Administrative Staff College of India,

Mar'03-Oct'03

VB and Oracle SQL PL/SQL Developer

Frontiers Prevention Project

. As a programmer I was responsible for Code development and testing.

Environment: VB, Oracle, SQL, PL/SQL

ONGC, Rajahmundry

Sep'00-Feb'03

VB and Oracle SQL PL/SQL Developer

Refinery Production & Dispatch Information System

. As a programmer I was responsible for Code development and testing.

Environment: VB, Oracle, SQL, PL/SQL

Contact this candidate