PROFESSIONAL SUMMARY:

• 10 years of overall IT experience which includes detailed technical knowledge and experience of Build Engineering and Configuration Management processes, tools and best practices.
• Extensive hands - on experience in the creation of robust, flexible, automated solutions for Build and Deployment processes and Environment Management across the Financial, Broadcast and Media Sectors.
• In-depth knowledge of Apache Subversion (SVN) and Jenkins/Hudson/Build Forge Continuous Integration, Server - Installation, Configuration, Design and Administration, plus experience of extending and integrating these tools with other systems, platforms and processes using Java, Shell Scripting etc.
• Experienced in data modeling and data normalization.
• Define Business Process, identify the risk, doing risk analysis and providing baseline acceptance criteria and deliverables.
• Expertise in providing Analytical Support to key business Applications /solutions
• Problem Analysis and Support.
• Extensively involved in setting up Geneos software across apps on all non-prod servers.
• Strong technical skills with Unix/Linux systems.
• Extensive UNIX Shell Scripting knowledge.
• Developing Ant and Maven scripts to automate the compilation, deployment and testing of Web and J2EE applications to the above platforms.
• Experience in client-server application development experience using Visual Basic.
• Excellent communication skills and ability to learn new things and be highly motivated
• Ability to work under stringent deadlines with team as well as independently.

TECHNICAL SKILLS:

DWH Tools: Informatica-Power Center 9.1/8.6/ 8.1 Business Objects, SQL Developer, TOAD, ERWIN, Autosys, Quality Center.

Operating Systems: Windows XP, UNIX,IBM-AIX,Linux.

Languages: Visual Basic, Clear Basic, ASP, SQL,PL/SQL, T-SQL.

Database: Oracle 11g, 10g, SQL Server 2008,UDB-DB2,DB2 8.0

Data Modeling Tool: Erwin, ER Studio

CRM Tools: Clarify 8.0/7.0

Version Control Tool: Subversion

Scheduling/Monitoring: Tidal Scheduler 2.5/5.3,Autosys,ITRS Geneos Tools

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

Applications Support Analyst

Environment: Informatica Power Center 9.6.0, IBM-AIX,DB2, UnixShellScripting, Red hat Linux, HP Service Manager, WinSQL, Subversion, Control M, ITRS Geneos.

Responsibilities:

• Worked on the build phase for the new data center migration of TAC project.
• Involved in implementing change management process while fixing the existing code to enhance the code or bug fixing.
• Worked on the build phase for the new data center migration of TAC project.
• Troubleshooting the issues in Informatica.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in setting up Geneos software across apps on all non-prod servers.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.
• Managed web Apps (FE/ME/BE) by installing/upgrading, deploying war files, configuring/updating Data source connections and config property files on all non-prod servers.
• Supported AS400/iSeries applications, starting/stopping hub jobs, clearing queues and logjams.
• Improve availability and timeliness of test environments.
• Performed ETL configuration and troubleshooting.
• Expertise working with Tomcat, Apache, Control M, SVN, CVS, Build forge, DB2, Hudson, Jenkin, Control M, Informatica, Maven, LDAP, Unix scripting.
• Worked with Web/MQ teams to trouble shoot/resolve the Fast Apps/MQ queues connection issues.
• Involved in Building Test Environments, deployments and Refreshes.
• Supported release activities and prepared deployment tasks.
• Worked with Secuirty Analyst to upload the unix script into Dynamic Password Lookup tool to securely access the application credentials.
• Managed SSL renewals for Web/MQ apps.
• Created lftp/sftp scripts to secure transfer the files into the remote servers.
• Migrated the repository objects (workflows) between the folders of different repositories.
• Strong technical skills with Unix/Linux systems.
• Used DB2 Load utility to load the data from FDW table into the file.
• Managed ETL Domain/Repository/Integrations services and workflows (Stop/Start) when ever the database servers are bounced.
• Worked with DBA to create the derived tables required for ETL development.
• Used UNIX Shell Scripting on linux platforms to automate the loading process and to generate restart tokens for cold starting the workflows.
• Experienced working with ITIL service lifecycle.
• Worked closely with Unix SAs for troubleshooting OS related issues with applications and servers maintenance activities.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions.
• Worked with different teams to trouble shoot the workflows/Control M jobs failures due to db and network issues.

Confidential, Dallas,TX

Support Analyst

Environment: Informatica Power Center 9.1.0, Oracle 11g,SQL, PL/SQL, IBM-AIX,DB2, UnixShellScripting, Red hat Linux, HP Service Manager, TOAD,SQL Developer, Subversion, Autosys, ITRS Geneos.

Responsibilities:

• Involved in implementing change management process while fixing the existing code to enhance the code or bug fixing.
• Coordinated with the DBA Teams, Source systems and offshore for different data loads (System test Load, Integration System Test Load, UAT Load and Pre production deployment load) and identified the bugs, new requirement changes and Data Quality Issue.
• Worked on the build phase for the new data center migration of collateral central project.
• Troubleshooting the issues in Informatica.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in setting up Geneos software across apps on all non-prod servers.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.
• Managed Fast Apps (FE/ME/BE/BRMS/TC) by installing/upgrading, deploying war files, configuring/updating Data source connections and config property files on all non-prod servers.
• Improve availability and timeliness of test environments.
• Performed ETL configuration and troubleshooting.
• Expertise working with Tomcat, Apache, Terracotta, Autosys, SVN, CVS, Build forge, Oracle 11g, MS SQL 2005, Hudson, Jenkin, Autosys, Informatica, Maven, LDAP, Unix scripting.
• Worked with Web/MQ teams to trouble shoot/resolve the Fast Apps/MQ queues connection issues.
• Involved in Building Test Environments, deployments and Refreshes.
• Supported release activities and prepared deployment tasks.
• Managed SSL renewals for Web/MQ apps.
• Migrated the repository objects (workflows) between the folders of different repositories.
• Supported AS400/iSeries applications, starting/stopping hub jobs, clearing queues and logjams.
• Strong technical skills with Unix/Linux systems.
• Managed ETL Domain/Repository/Integrations services and workflows (Stop/Start) when ever the database servers are bounced.
• Test environment access administration.
• Worked closely with Unix SAs for troubleshooting OS related issues with applications and servers maintenance (patching/rebooting) activities.
• Provided out of hours coverage to support environments maintenance activities.
• Used UNIX Shell Scripting on linux/AIX platforms to automate the loading process and to generate restart tokens for cold starting the workflows.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions.
• Worked with different teams to trouble shoot the workflows/Autosys jobs failures due to db and network issues.
• Prepared Test preparation and execution plans for different entities and executed the testing with team and Involved in Integration testing.

Confidential, Palo Alto, CA

Informatica Developer

Environment: Informatica Power Center 8.6.1, Oracle 11g,SQL, PL/SQL, IBM-AIX, UnixShellScripting, TOAD,SQL Developer, Business Objects, Autosys, Erwin.

Responsibilities:

• Involved in gathering business user requirements, understanding the business model (E-R Diagrams) and database tables.
• Developed Technical design documents (TDD) from user requirements and functional requirements documents (FRD).
• Involved in ETL designing and architecting.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations etc.
• Used Surrogate keys in the Data Ware house tables to manage the Slowly Changing Dimensions (SCD) properly and easily.
• Extracted data from multiple sources such as Oracle, XML, Flat Files and loaded the transformed data into targets in Oracle, Flat Files.
• Worked extensively on Mapping Designer to design and create mappings, transformations to implement transformation logic.
• Extensively used the features of Informatica Version 8.6 including Designer, Workflow manager and Workflow monitor.
• Worked with SQL statements for storing, retrieving, and manipulating data in a relational database.
• Created partitions on the sources to improve the performance.
• Used stored procedures for truncating the tables and deleting the rows from error logs.
• Created Sessions and Workflows to carry out the ETL process, configured sessions and connection parameters.
• Involved in deployment of SCD Type 2 mappings to keep track of historical data.
• Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.
• Developed reusable transformations and mapplets, which were used in other operations.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Developed Unit test cases and Unit test plans to check data is correctly loading.
• Worked on software engineering/SDLC tools, particularly Microsoft Team Foundation Server (TFS), to document and track work items from initial request through production deployment.
• Conducted Informatica performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Used UNIX Shell Scripting to automate the loading process.

Confidential, St.Louis,MO

Informatica Developer

Environment: Informatica Power Center 8.5.1, Oracle 11g,SQL, Red hat Linux,MS SQL Server 2008, UnixShellScripting, TOAD, Business Objects, Autosys, Erwin, MS Access.

Responsibilities:

• Participated in build of the Data Warehouse which includes the Design of Data mart using Star Schema.
• Integrated various sources in to the Staging area in Data warehouse for Integrating and Cleansing data.
• Involved in Analysis/Design/Development and Implementation and successfully completed all the work involved in converting the company’s Operational data Store from SQL to Oracle database and deployed the systems in Production, with full Production Support.
• Interacted with business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations etc.
• Responsible for creating and effectively executing deployment plan to move all the objects, tables, mappings, workflows, SQL scripts and created new jobs and their dependencies in Production
• Involved in Control-M Implementation, Extensively used the scheduling tool Control M to schedule jobs and their dependencies in production.
• Conducted Informatica performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Completely involved and alert in Easily Solved variety of issues during Production Support, ensuring smooth completion of data loading process.
• Worked with DBA to fine tune complex SQL’s, do regular Run-Stats on the tables, drop and re-create indexes to decrease run times of various Informatica mappings which process large volume of data.
• Fine-tuned the Informatica Server and Mappings.
• Participated in Design and Code walkthroughs to discover defects in the design or code and improve the overall quality of the product.
• Involved in full SDLC to implement the Clinical Effectiveness & Outcomes Datamart.
• Extensively worked in planning the Metadata strategy and responsible for maintaining of the Metadata in the Enterprise Data Warehouse (EDW).
• Involved in working with the Data Modeler in Data Modeling.
• Provided support to projects for new applications / report needs.

Confidential, Orange, CA

Informatica Developer

Environment: Informatica Power Center 8.1.1, Oracle 11g,SQL, PL/SQL, IBM-AIX, UnixShellScripting, TOAD, Business Objects, Autosys, ER Studio, MS Access.

Responsibilities:

• Involved in gathering business user requirements, understanding the business model (E-R Diagrams), database table and query design, extracts and use of report query tools and Identify technical risks, assumptions, and dependencies.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule it.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations etc.
• Used Surrogate keys in the Data Ware house tables to manage the Slowly Changing Dimensions (SCD) properly and easily.
• Extracted data from multiple sources such as DB2, Oracle, XML, Cobol, Flat Files & MS Access and loaded the transformed data into targets in Oracle, Flat Files.
• Worked extensively on Mapping Designer to design and create mappings, transformations to implement transformation logic.
• Extensively used the features of Informatica Version 8.6 including Designer, Workflow manager and Workflow monitor.
• Experience in dimensional modeling (star schemas, snowflake schemas /ROLAP, OLAP, MOLAP) .
• Worked with SQL Server SQL statements for storing, retrieving, and manipulating data in a relational database.
• Involved in Data migration, extraction, Data cleansing and Data Staging of operational sources using ETL processes.
• Created partitions on the sources to improve the performance.
• Extensively used Change Data Capture (CDC) approach efficiently to capture only the changed data.
• Used stored procedures for truncating the tables and deleting the rows from error logs.
• Created Sessions and Workflows to carryout the ETL process, configured sessions and connection parameters.
• Worked with the scheduling tool UC4 to schedule the workflow jobs.
• Used UNIX Korn Shell Scripting to automate the loading process.
• Developed reusable transformations and mapplets, which were used in other operations.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Worked on software engineering/SDLC tools, particularly Microsoft Team Foundation Server (TFS), to document and track work items from initial request through production deployment.
• Conducted Informatica performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Developed Unit test cases and Unit test plans to check data is correctly loading.

Confidential, Indianapolis, IN

Informatica Consultant

Environment: Informatica Power Center 7.1.1, Oracle 9i, SQL, PL/SQL, Business Objects, Suse Linux, Rational Rose, Clear Case, PVCS.

Responsibilities:

• Participated in build of the Data Warehouse which includes the Design of Data mart using Star Schema.
• Integrated various sources in to the Staging area in Data warehouse for Integrating and Cleansing data.
• Involved in Analysis/Design/Development and Implementation and successfully completed all the work involved in converting the company’s Operational data Store from SQL to Oracle database and deployed the systems in Production, with full Production Support.
• Interacted with business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Extensively used Change Data Capture (CDC) approach efficiently to capture only the changes.
• Responsible for creating and effectively executing deployment plan to move all the objects, tables, mappings, workflows, SQL scripts and created new jobs and their dependencies in Production
• Involved in Control-M Implementation, Extensively used the scheduling tool Control M to schedule jobs and their dependencies in production.
• Completely involved and alert in Easily Solved variety of issues during Production Support, ensuring smooth completion of data loading process.
• Worked with DBA to fine tune complex SQL’s, do regular Run-Stats on the tables, drop and re-create indexes to decrease run times of various Informatica mappings which process large volume of data.
• Extensively worked in planning the Metadata strategy and responsible for maintaining of the Metadata in the Enterprise Data Warehouse (EDW).
• Involved in working with the Data Modeler in Data Modeling.

Confidential, Madison, WI

Informatica Consultant

Environment: Informatica Power Center 6.1, Business Objects 5.0, Oracle 9i,10g, MS SQL Server 2000,Red hat Linux, Erwin, UNIX Shell Scripting.

Responsibilities:

• Business Analysis and Requirements Gathering.
• Involved in logical and physical data modeling.
• Analysis and Design of ETL processes.
• Extensively used Business Objects for BI reports.
• Created and managed Universes.
• Extraction, Transformation and Loading of the data Using Informatica Power Center’s Designer and Server Manager.
• Worked on Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer and Transformation Developer.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Different sessions were run in the Server Manager and the log was studied to modify the mappings to obtain correct result from the transformation.
• Used ETL to load data from source to Oracle database.
• Worked on Data Conversion and Data Analysis. Stored data in the Data Warehouse about Claims, Customers, and Accounts.