Project Data
Resume:
*********@*****.*** AVNI LAD 469-***-****
**** ****** ***** *****, ******, TX - 78729
SUMMARY:
• A result oriented professional with 5+ years of experience working with IBM in Systems development and Process compliance
• Performed end-to-end Informatica configuration and UNIX server migrations which includes Informatica administration, application configuration and metadata management
• Performed automation for critical applications (used for market based transaction) to reduce manual intervention using UNIX scripting
• Lead and managed client’s critical applications, handling team’s co-ordinate with Offshore and onshore in United states and India
• Extensive experience in working with Informatica ETL, advanced ETL transformations, UNIX shell scripting, creating Cognos reports using combination of SQL queries
• Worked on technical evaluation of development project requirement, performs cost and benefit analysis to provide Project estimation hours
• Created complex ETL mappings using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics using Informatica
• Worked with 3rd party vendors, contractors or suppliers for application support, maintenance, upgrades and implementations
• Experience in handling huge amount of data for millions of customers
• Maintained 100% compliance on business guidelines, change control process, SDLC and code development standards.
• Scheduled ETL Jobs (created based on the requirement) using UNIX script through Expresso CAWA scheduler
• Provided 24*7 support to Oncor’s market facing critical applications by having quick resolutions to high priority incidents, enhancements of applications and operating environments to align them with latest Business requirements, application monitoring and control
• Automated process of data translation and validation for multiple business applications using Informatica, Shell scripting and SQL
• Extensively worked and in-depth knowledge on Power Center components such as Power Center Designer, Power Center Repository Manager, Workflow Manager, Workflow Monitor, Repository Manager and Admin Console.
• Have worked on Requirement gathering, Designing, Development, Validation and Implementation for Data warehousing, Data Migration and Data Integration projects
• Performed project architectural planning, data modelling, development, concepts, testing and code deployment
• Worked directly with application owner and clients to get requirements as per business needs.
• Experience in maintaining business relationship with clients and customers to achieve quality product and service norms by resolving their service related critical issues
• Worked on analysis and troubleshooting of long running issues in production system
• Created and maintained various ETL process to extract data from various source systems like Oracle, SQL server, Informix server studio, flat files and load them to Data warehouse
• Established specific solutions and lead the efforts including code design, development and testing, resulted in client’s acceptance
• Worked on performance tuning and code enhancements to achieve better performance for various processes
• Assisted team in building ETL source to Target mappings and workflows by understanding business requirements
• Extensively worked on ETL code validation based on business needs to ensure data integrity
• Successfully up-graded and deployed Informatica power center 9.6 from 8.1 including Informatica software installation, configuration and ETL code migrations
• Involved in Knowledge sharing sessions with various development teams and assisted them in deployments/defect fixes
• Created Infrastructure diagram, Application flow, Informatica start – stop, Server build application, HA Orchestration, Local Resilience, Risk Analysis, Business requirement document for ETL application using MS Visio
• Performed root cause analysis of troubled production code or newly created ETL code as per business requirement
• Created various Unix Shell Scripts to automate pre- and post-session processes
• Have ability to work dynamically fast under high pressure environment and can handle multiple tasks simultaneously CERTIFICATIONS
o IBM Certified Designer- Cognos 10 BI Reports
o IBM certified solution Developer – Infosphere DataStage v8.5 o IBM Design Thinking Practitioner
TECHNICAL SKILLS
o Databases: Oracle, SQL Server, PL-SQL, Informix Server Studio, My SQL, Teradata SQL Assistant o BI Tools: Cognos 10 BI Report Studio, MS Visio 13.1, Tableau o DW Tools: Informatica PC (Version- 8.1,9.1,9.6), Informatica PWX, Informatica Cloud, Ab Initio o Scripting & Scheduling Tools: Unix shell Scripting and Expresso CAWA Scheduler, MS Excel o Other Tools: BMC Remedy, JIRA, PowerPoint, Tortoise SVN, IBM Rational Tools, Hadoop PROFESSIONAL EXPERIENCE
IBM, Oct 2012 - Oct 2017
Informatica Developer Jan 2017 - Current
Project: CCB (Customer Care and Billing System) – Mainframe replacement project Description: The main objective of the project is to replace existing mainframe system by CCB system. As a part of ETL team, we need to perform analysis, code changes, testing, etc for all downstream and upstream applications so that changes to mainframe system would not affect Oncor existing market.
Responsibilities:
• Performed detailed analysis of existing production code to accommodate the changes coming after CCB migration.
• Modified existing ETL code and shell scripts to accumulate all the upcoming changes.
• Updated and modified data structure to accommodate changes in data coming from CCB.
• Performed multiple rounds of testing of the updated code to ensure there is no impact on functionality and performance.
• Deployed updated ETL code and shell scripts in various lower environments to ensure business functionality, as we were working on critical production database which can directly impact customers and oncor’s business.
• Validated data on multiple levels to ensure data integrity and adhere Oncor business policy. Informatica Admin & ETL Analyst Jan 2016 – Dec 2016 Project: Disaster Recovery
Description: The main objective of Disaster Recovery project is to ensure that Oncor AMS production systems are always available to process market transactions without impacting its customers. This project is to build Oncor new data center and migrate applications to it, if Oncor data center is inaccessible due to some disaster, or due to some planned and unplanned outage. The new DR system should be able to process all interfaces like Incoming/Upstream systems as is done currently and generate data required for Outbound/ downstream systems for all applications as exists in current production. The failover and switch time to access application across data center should be done in 60 minutes.
Responsibilities:
• Involved in requirement gathering, analysis, developing and deployment phases of this project.
• Worked on documentations and analysis of each ETL production application which are involved in DR projects.
• Created various documents depending on actual production applications like: Infrastructure diagram, Application flow, Informatica start – stop documentation, Server build form, HA Orchestration for ETL application, Risk Analysis, Business requirement document for ETL application using MS Visio.
• Worked with environment management team to Review Installation and Configuration document of Informatica applications which is used to automate Informatica automatic installation through script.
• Worked with Veritas team and Oracle team to prepare design documents for VIOM, VRP and data guard configuration of ETL applications.
• Worked with Unix team, to validate firewall connectivity across systems, NFS/CFS file systems and mount locations configured in production application.
• Interacted with production support and testing team at the times new DR systems were migrated from one datacenter to another, and helped them in performing application and server level validations. Informatica Lead Nov 2013 - Current
Project: ETL application maintenance and Support
Description: This project mainly dealt to maintain applications which are involved in data loading, reporting, monitoring production systems.
Responsibilities:
• Worked as a team member to provide application maintenance and support to Oncor’s 4 critical applications: AMS R3
(Advanced Metering System Release-3), CDW (Customer Data ware house), HRIDS (HR- Interim Data source), and TDM
(Transmission data mart) system.
• Established specific solutions and lead the efforts including programming and testing resulted in client’s acceptance.
• Extensively worked on ETL code validation based on business needs to ensure data integrity.
• Worked on performance tuning and code enhancements to achieve better performance for various processes
• Performed automation for critical applications (used for market based transaction) to reduce manual intervention using UNIX scripting
• Involved in Knowledge sharing sessions with various development teams and assisted them in deployments/defect fixes.
• Worked on UNIX to navigate around the system and check for specific files, contents and assign privileges
• Collaborated with different teams across department to expedite and resolve issues quickly
• Created number of UNIX shell scripting to automate process of data translation and validation for various business applications.
• Provide 24x7 application maintenance and support to Oncor’s business critical application, quick resolution to high priority incidents, enhancements of applications and operating environments to align them with latest Business requirements, application monitoring and control.
• Involved in unit testing, code debugging and fixing of defects. Informatica Developer Jun 2014 – Apr 2015
Project: AMS ETL Informatica Migration from 8.1 to 9.6 Description: The objective of the project is to migrate running production ETL application from Informatica 8.1 version to Informatica version 9.6. In current production application, there were some performance and compatibility issue with Informatica 8.1 and our job was to migrate existing jobs to new Informatica 9.6 to resolve issues. Responsibilities
• Worked with Informatica support on compatibility of existing production application and Informatica version.
• Done analysis of existing jobs running on Informatica version 8.1 to make them compatible with the new Informatica version.
• Created functional specification, requirement gathering, high-level and low-level documentation, test plan for the code migration.
• Worked on Informatica 9.6 installation, configuration and code migration from 8.1 to 9.6
• Fixed bugs, performed root cause analysis, and updated code post migration by providing 24x7 support with quick resolution
(turn-around time within 4 hours) to high priority incidents.
• End to End testing of the migrated code to check functionality as per current production.
• Performed data validation after running migrated code ETL by comparing data and its structure from test environment and production database extract.
Informatica Developer Nov 2013 – May 2014
Project: Stacker Upgrade
Description: The Stacker is a java based middle layer application that enables Oncor to meet the requirements for the MIMO (i.e. MOVE IN and MOVE OUT) Solution. It allows Oncor to accept (and process) multiple, non-sequential Registration transactions on a single premise. This transaction information is sent to Polaris database using DB link functionality. In this project stacker supporting DB version was upgraded to Oracle12c, whereas the connecting Polaris DB version was Oracle 9i. Because of non-compatibility of Oracle Version in source and target DBlink functionality was broken. Now, to process this transactions to Polaris, we have replaced DBlink code with ETL logic.
Responsibilities:
• Involved in requirement gathering, analysis, developing and deployment phases of this project using ETL specifications.
• Created ETL mapping and workflows to load the data from Stacker database to the Polaris database by replacing DB link functionality as per business requirement.
• Developed UNIX shell script to check on source/target DB connectivity, trigger ETL maps which will load data from one system to another.
• Worked with database team to create tables, procedures and views needed for ETL code as per new requirement.
• Created SQL queries which is used in ETL code as per business requirement.
• Performed Unit testing for the ETL mapping and UNIX scripts code created.
• Prepared high level, low level, business requirement, UTP and technical design documentation of the developed code.
• Enabled and migrated created code in IBM Rational tool to maintain code versioning and updates.
• Worked across department team to schedule created code with a job using CAWA scheduler.
• Involved in knowledge sharing session with the support team to deploy created code functioning in production. Informatica Developer Mar 2013 – Nov 2013
Project: Contract Remaining Balance
Description: The objective of this project is to process Contract invoice related information to EEPM system. In this project, we need to get all the contract related information from Maximo system whenever invoice related changes on contract are maintained for any account or development project in Oncor. We need to extract all the contract related information from Maximo and store them in DWH tables. We than need to generate files which are sent to EEPM and accounting team for their work. Generated files help Oncor finance management to check and validate contract invoice and billing information for future investments in development projects and to keep track of past projects and their amounts.
Responsibilities:
• Involved in requirement gathering, analysis, developing and deployment phases of this project using ETL specifications.
• Performed connectivity tests between the vendor server and enabling the firewall connections to deploy project successfully.
• Created ETL mapping and workflows to extract and generate files as per requirement and sent to EEPM team using SFTP/FTP interface.
• Developed UNIX shell script to trigger ETL maps and enables SFTP functionality to transfer file to external systems.
• Performed Unit testing for the ETL mapping and UNIX scripts code created.
• Prepared high level, low level, business requirement, UTP and technical design documentation of the developed code.
• Enabled and migrated created code in IBM Rational tool to maintain code versioning and updates.
• Worked across department team to schedule created code with a job using CAWA scheduler.
• Involved in knowledge sharing session with the support team to deploy created code functioning in production. Informatica Developer Oct 2012 – Mar 2013
Project: CRIP Rewrite
Description: The purpose of the project is to enhance functionality of CRIP for REPs and ONCOR Internal users. The CRIP would be updated to incorporate new codes and description so that user can understand the portal. In this project, we need to consume those data from LCIS mainframe system to load into EDW Oracle database and to generate Cognos reports on the top of this data. Responsibilities:
• Involved in requirement gathering, analysis, developing and deployment phases of this project using ETL specifications.
• Created ETL mapping and workflows to load the data from mainframe systems to EDW database using various transformations to meet the business requirement.
• Developed UNIX shell script to trigger ETL maps which will load data from mainframe systems to EDW.
• Worked with database team to create tables, procedures and views needed for ETL code and Cognos reports.
• Created SQL queries which was used by reporting team to generate reports for the users.
• Performed Unit testing for the ETL mapping and UNIX scripts code created.
• Prepared high level, low level, business requirement, UTP and technical design documentation of the developed code.
• Enabled and migrated created code in IBM Rational tool to maintain code versioning and updates.
• Worked across department team to schedule created code with a job using CAWA scheduler.
• Involved in knowledge sharing session with the support team to deploy created code functioning in production. EDUCATION
Bachelor’s in Computer Science and Engineering, RGTU, India June 2012 LEADERSHIP, ACHIEVEMENT AND SOCIAL ACTIVITIES
• Won multiple awards in IBM including client recognition and IBM deep skills
• National player of sports game Kho-Kho, lead university team multiple times
• Active member of Vibha – Organization help educate and empower underprivileged children.
Contact this candidate