Candidates About

               

                  Veera Reddy                                                

SUMMARY OF QUALIFICATIONS

• 7+ Years of professional experience with expertise in Support, Design, Development, Maintenance, Data Conversion and Implementation of Data warehouse applications and Database business systems.
• Expert level skills in the Integration tools such as Informatica Power Center, Informatica Cloud, IBM DataStage and MuleSoft.
• 5+ Years of Experience in Informatica PowerCenter Administration 9.x/1.0. x.
• 2+ Years of Experience in working with Informatica products such as Informatica Cloud, Cloud Real-time, IDQ, and Proactive monitoring tool.
• 1+ Year experience in MuleSoft Administration.
• 1+ Year experience in IBM DataStage and IBM Change Data Capture.
• Strong Experience in Windows server administration.
• Strong experience in Informatica PowerCenter installations, version upgrades, migration of repositories and code deployments.
• Strong Experience in setting-up and administering Informatica cloud environments.
• Experience in building the MuleSoft environment such as managing the users and roles, deployments and configuring high availability.
• Strong experience in working of authentication mechanisms for web services and middleware systems.
• Strong experience in configuring and maintaining the SSL endpoints.
• Experience on typical integration technologies such as HTTP, JDBC, REST, and SOAP.
• Experience in working with Scheduling tools such as Informatica scheduler, Autosys, Control-M, Tivoli, and Redwood.
• Experience in working with version control tools such as SVN and IBM ClearCase.
• Base level experience on database query tools such as SQL Assistant, SQL Plus, and SQL studio.
• Base level experience in Salesforce Administration.
• Experience in 24X7 production support, ETL executions and resolving root causes.
• Strong Experience in Onsite-Offshore Model.
• Versatile team player with excellent analytical, communication and presentation skills.

 

EDUCATION

B. Tech, Computer Science Engineering

Jawaharlal Nehru Technological University, Kakinada                                                                                

 

 

TECHNICAL EXPERTISE

Integration tools:                    Informatica Power Center 1.0.X,9.X, Informatica Cloud(ICS) and Cloud Real-time(ICRT), Informatica Power Exchange, Informatica Data Quality, Informatica proactive monitoring tool, IBM DataStage, IBM CDC, MuleSoft.

Database and related tools:   Oracle 10g/9i, MS SQL Server, Teradata, MS Access 2000, SQL Assistant, SQL Server Management Studio.

BI and Scheduler tools:           Informatica Scheduler, Cognos 10.x/8.X, Tivoli, Redwood and         

                                                     Control-M.

Programming:                         SQL, SQL*Plus, C, UNIX shell scripting

Operating Systems:                 UNIX (Sun Solaris 5), AIX (5.X)/AIX 6.1, Windows (2008 R2/ 2012

                                                      R2)

Web Development:                  XML, JSON, HTML, SOAP and REST

Other:                                      Splunk, Bamboo

                       

 

PROFESSIONAL EXPERIENCE

The Warranty Group, Chicago, IL                                                                           Mar 2016- Till Date          

Informatica Administrator/MuleSoft Admin

 

·         Involved in the Requirements Gathering, Analysis, and support of Data Warehousing efforts.

·         Installed Informatica 9.5.1, 9.6.1 and 10.1 on Windows platform.

·         Upgraded Informatica PowerCenter from 9.5.1 to 9.6.1, 9.6.1 to 10.1.0 and 10.1.0 to 10.1.1 and configured High Availability to the environments.  

·         Installed and configured IDQ 10.1.1.

·         Installed and configured Informatica proactive monitoring tool.

·         Informatica Cloud Administrator role, Installed and configured ICS secure agent, created users and grant privileges to the users.

• Experience in working with Informatica Cloud Agent Installations, code deployments, patches Installation and production jobs support.

·         Installed different patches to the Informatica PowerCenter servers and Informatica Cloud security agent based on the requirement.

·         Performed the code migration between different environments in ICS, ICRT, and PowerCenter and used SVN version control tool for PowerCenter deployments.

• Experience in building the MuleSoft environment such as creating business groups, managing the users and roles, and integrating the monitoring tool Splunk to MuleSoft.
• Experience in deploying the applications and API’s between different environments in Anypoint platform.
• Configured the load balancers to the VPC’s and mapped the applications to LB.

·         Extensively worked on setting up secure connections to third-party FTP using SSL mutual Authentications and SSH Authentication.

·         Extensively worked as Production support developer to identify and fix the problems in Informatica cloud and cloud real time.

·         Handling the issues in the Informatica level.

 

Environment: Informatica Power Center 10.1/9.X, Power Exchange for Salesforce, Informatica Cloud ICS, Informatica Cloud Real Time, PMPC, AZURE/MS SQL SERVER, DB2/AS400, Salesforce, MuleSoft, Windows 2012 R2, SharePoint.  

 

 

Southern California Edison, Los Angeles, CA                                                                   July 2014- Feb 2016           

Informatica Administrator/Developer

 

·         Involved in the Requirements Gathering, Analysis, and support of Data Warehousing efforts.

·         Installed Informatica 9.x

·         Upgraded Informatica 9.1.0 to 9.5 and 9.5 to 9.6.1

• Handling the issues in the Informatica level
• Creation of folders and maintained Users, Groups, Roles, and Privileges.
• Configured Master node and Backup nodes under High Availability Environment.
• Responsible for Installation of patches and upgrades.
• Handling other Informatica administration activities

·         Modified existing mappings for enhancements of new business requirements.

·         Worked with the DB team to put database changes in place for the mappings to run.

·         Used the ETL standard’s to load the Dimension and Fact tables daily to the Teradata Datawarehouse by scheduling the workflow using Informatica scheduler.

·         Used Autosys scheduler to schedule the jobs and have an email mechanism in the production to keep the team posted when job’s failure.

·        Extensively worked as production support developer to identify and fix data problems in IBM DataStage, IBM CDC and Informatica.

·        Have good knowledge on Troubleshooting and providing the speedy solution in case of failure of the applications.

·        Resolved the network issues between the Teradata server and Informatica Server.

·        Created technical support documentation for the team for production support.

·         Worked on the three-tier model (DEV, TEST, and PRODUCTION).

·         Followed standard procedures to deploy the mappings from Development to Test and Production environments.

 

Environment: Informatica 9.5/9.6, IBM DataStage 8.0.1/8.1, Change Data Capture (CDC), Autosys, Tivoli, Redwood, Teradata SQL Assistant, Windows XP.

 

Xerox State Healthcare LLC, Atlanta, GA                                                            Sep 2013- June 2014           

Informatica Administrator/Developer

 

·         Involved in the Requirements Gathering, Analysis, and support of Data Warehousing efforts.

·         Designed various mappings using Informatica Designer to load Dimensions and Facts.

·         Installed Informatica 9.x

·         Upgraded Informatica 9.0.1 to 9.1.0, 9.1.0 to 9.5 and 9.5 to 9.5.1,9.5.1 to 9.6.1

·         Installed/Configured Informatica IDQ, TDM 9.x

·         Upgraded Informatica IDQ and TDM from 9.5.0 to 9.6.1

·         Developed Data Masking Rules and IDQ Rules/Projects

·         Hands on experience in object versioning and its features such as check-in, check-out, undo-checkout, Viewing History, Setting the object status, etc.

• Handling the issues in the Informatica level
• Creation of folders/user permissions.
• Extensively worked on Performance Tuning of Informatica Server and Repository Server.

·         Created Mapplets to use them in different mappings.

·         Used existing ETL standards to develop these mappings.

·         Created various Workflows, Worklets and Sessions for the mappings to run.

·         Modified existing mappings for enhancements of new business requirements.

·         Worked with the DB team to put database changes in place for the mappings to run.

·         Used Autosys and Contol-M Scheduler to load the Datawarehouse Dimension and Fact tables.

·         Deploying the changes, Enhancements, Upgrades, etc. through the various Environments.

·        Extensively worked as production support developer to identify and fix data problems.

·        Created technical support documentation for the team for production support.

·         Used the email task in the Production to keep the team posted when session’s fail.

·         Created store procedures to implement the logics and using them in Informatica.

·         Extensively used environments to create a shell script and maintaining the logs of Informatica admin console.

 

Environment: Erwin, Informatica Power Center 9.x, IDQ, TDM, Power Exchange, Control-m, DB2, Autosys, Flat files, TOAD, Oracle 10g, UNIX and Windows 2010.  

 

UBOC (Union Bank of California), Orange County, CA                                         Feb 2012- July 2013            

Informatica Administrator

 

·                     Worked as Informatica Administrator

·                     Define the Naming Standards and Standard process for Informatica.

·                     Provided Best recommended solutions/change the process to minimal the Cost for the projects.                

·                     Installed Informatica 8.5.1, 9.0.1 and 9.6

·                     Installed/Configured Informatica IDE

·                     Upgraded Informatica IDE

·                     Developed Data Masking Rules and IDE Rules/Projects

·                     Installed Control-M servers and agents

·                     Upgraded Informatica 8.1.1 to Informatica 8.5.1 and 9.0.1, 9.5

·                     Applied Patches to the Informatica Servers

·                     Developed complex mappings in Informatica to support for Health Care Enterprise application.

·                     Developed complex scripts for the follow the Business requirements

·                     Troubleshooting the issues in Informatica

·                     Migrating the Cognos reports from one environment to another environment

·                     Troubleshooting the issues in Cognos reports

·                     Involved and resolving the issues (Tickets) in Informatica Power center.

 

Environment: Informatica Power Center 9.1.0, Cognos, Tivoli, SQL Server 2008, XML, PL/SQL, SQL*Plus, TOAD, Windows XP, AIX.

Credit –Suisse, Houston, Texas                                                                              Aug 2010- Jan 2012                       

ETL/Data Warehouse Developer

 

• Worked as an ETL Developer/Production support
• We are testing the Informatica code per the new releases
• We are handling 3 test environments for testing the code in parallel.
• Transformed data from source system to target.
• Writing the queries on metadata level to figure it out the standards
• Implemented the standards in the release basis.
• Migration of objects from DEV-ST, and ST – PROD
• Handling the issues in the Informatica level
• Creation of folders/user permissions.
• Supporting other Informatica administration activities
• Upgrading the Informatica Repositories from 8.x to 9.x.
• Giving L2/L3 Support for all applications.
• Giving 24/7 Production Support for all application.
• Involved and resolving the issues (Tickets) in Informatica Power center.

Environment: Informatica Power Center 9.1.0, Tivoli, SQL Server 2008, XML, PL/SQL, SQL*Plus, TOAD, Windows XP, AIX