Profile

• 8 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals
• 5 yrs experience in Informatica, involved in system study, design, development, maintenance and testing stages of various projects
• 2 yrs experience in Mainframe with Informatica
• Proficient in analyzing and translating business requirements to technical requirements and architecture
• Having Experience as a Tech Lead/ Programmer Analyst/Onsite Coordinator
• Understanding of all phases of Project Life Cycle/SDLC including Requirement gathering, Analysis, Design, Development, Implementation and Testing
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
• Strong experience in Data Warehousing and ETL using Informatica Power Center 9.1
• Strong experience in developing the complex SQL queries, unions and multiple table joins
• Worked on UNIX shell scripts to run the Informatica workflows and controlling the ETL flow
• Experience with dimensional modeling using star schema and snowflake models
• Excellent ability to determine appropriate system test scenarios, create end-user Business procedure guides, and provide hands-on guidance and training where necessary
• Have a sound knowledge on estimation of the project using the Function Point counts

Skill Set

• Operating System : UNIX, Windows
• Programming Languages : UNIX Shell scripting, SQL
• Database skills : Teradata, Oracle
• Tools : PL/SQL developer, Autosys
• ETL Tool : Informatica
• Processes : Clear Quest
• Estimation : Function Point Counting

Professional Experience

Confidential

Informatica Developer

Responsibilities:

• Analyze the requirements from the customers and coordinating with the technical team and providing resolution of any technical issues
• Provide current application design, architecture and application details for ICD-10 and System replacement project for CA-MMIS
• Created the system functional design document and Technical design document
• Worked on ETL programs using Informatica to implement the business requirements
• Extensively worked on Informatica Power Center 9.1 - Data extraction, Transformation and loading data from various sources like Oracle and Flat files
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTF connections and relational connections
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup and optimizing the Mapping
• Created shell scripts to fine tune the ETL flow of the Informatica workflows
• Used debugger to identify bugs in existing mappings by analyzing data flow, evaluating transformations
• Performed unit testing at various levels of the ETL and actively involved in team code reviews
• Mentored new team members to help them understand the application better and quickly

Environment: Informatica, Oracle

Confidential

Informatica/Mainframe Developer

Description : Confidential is the Revenue Usage Sourcing System and its business function is for Sales and Marketing Needs Analysis Utilizing a RUSS Tracking Database for bill cycle validation and a RUSS month-end reconciliation process, the system is responsible for collecting all billed revenue and minutes of use data for ABS AT T Business Services . It directly interfaces and is dependent on information from a various number of ABS billing systems to include the Data Warehouse DW system, which receives information from other ABS billing systems and the Tailored Journals system. Files are received almost daily from among 34 billing systems that have one or more number of billing cycles in a month

Responsibilities:

• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Coding, code reviews and testing with Unit test case preparation and execution.
• Develop implementation and test plans and deliver the product to System Analyst for system testing.
• Reviewed the design, test case records and stored in Rational Portfolio Management RPM and PRISM tools for tracking purpose.
• Month end process, creation of file processing reports, error file processing reports etc
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Teradata and Delimited Flat files
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup and optimizing the Mapping
• Effectively worked on Onsite and Offshore work model
• Performed unit testing at various levels of the ETL and actively involved in team code reviews
• Developed Teradata, Fastload, Multiload and Bteq scripts

Environment: Teradata, Informatica

Confidential

Application Developer

Description : Confidential leading telecommunications carrier and a world-class fully integrated, full service provider across wire line, ADSL, HFC, satellite and digital wireless networks and platforms. Telstra has more than 10 million household, business and wholesale customers. The application MICA is the biggest application in this account. It is a Mobile Application which includes activations, deactivations, and service transfers, call pricing, billing, Payment Filtering, calculating dealer commission.

Responsibilities:

• Self and independent testing of enhancements made in the system with respect to the new business requirements
• Utilized COBOL, JCL and CICS in the coding and testing data extraction
• RPM is being used to track every phase of the projects assigned
• Analyzed and tested new systems using Xpediter, IBM Utilities, and Eztrieve
• Created reporting programs which eliminated erroneous and redundant submission
• Developed CICS online update and inquiry screens

Environment: COBOL, COOL: Gen, DB2, CICS