Data Informatica

Location:

Coppell, TX

Posted:

October 06, 2020

Contact this candidate

Resume:

BABUJAGAN MOHANA RAO VEERAMALLU

Mobile Ph: 214-***-****

adgqfq@r.postjobfree.com

Coppell, Texas

Sixteen years of diversified experience in the field of Information Technology and Data warehousing / Data Hub using Informatica PowerCenter. Developing Strategies for Extraction, Transformation and Loading (ETL) mechanism-using Informatica.

Experience in Testing for Data warehouse, ETL, BI, SQL, ORACLE, Web based, Client/Server applications using Manual testing tools.

Experience in Data Warehouse projects, ETL testing.

Experience in writing complex SQL's to validate data against Oracle Database.

In depth technical knowledge and understanding of Data Warehousing, Data Validations, SQL.

Strong knowledge of test methodologies.

Experience in writing test scripts, testing DataStage Mappings and creating SQL scripts.

Developed advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic.

Generated server side PL/SQL scripts for data manipulation and validation for remote instances.

Involved in creating Unix Shell and Perl Scripting.

Extensive experience in complete Software Development Life Cycle (SDLC) including System Requirements Analysis, Design, Development, Testing, Maintenance and Enhancement in variety of technological platforms with special emphasis on Data Warehouse and Business Intelligence applications.

Complete understanding of Soft Ware Development methodologies like waterfall, Agile etc.

Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica PowerCenter.

Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.

Good knowledge in OLAP and OLTP process.

Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources.

Strong in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies

Extensively provided end to end 24/7 Production Support by monitoring data into a complex high volume environment using Quick Base ticket logging system.

Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multi-dimensional modeling.

Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions

Experience in Performance tuning of the Informatica and Oracle.

Expertise in implementing complex Business rules by creating complex mappings / mapplets, shortcuts, reusable transformations and Partitioning Sessions.

As part of OAT (Operational Acceptance Testing), moving processing Prod data to different lower level UAT environments (Other Production like Environments) as requested by the clients.

Extensively worked on L1 & L2 production support related issues and analyses issue priority and address to L3 team with details and follow up on items.

Responsible for creating conference calls for groups to discuss incidents that are production related, time or scheduled related incidents.

Coordinate with DEV teams and work with support teams to move fixes to production.

Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer

Experience in working with Informatica Admin team on installing Informatica server, power center client in Development, QA and Prod machines.

Experienced with working on Onshore Offshore Support Model and shifts.

Experience in working with production support team and Change management and Incident Management and Deployment Management teams.

Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.

Extensively worked on various databases including Oracle 10g, SQL Server, DB2, and Teradata.

Experience in Integration of various data sources like Oracle, SQL Server, and Flat Files

Extensively worked with SQL loader for bulk loading into the oracle database.

Experience in Perl scripting

Proficient in understanding business processes / requirements and translating them into technical requirements.

Ability to work independently or in a team environment or in a rapid pace environment.

Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels.

Working experience

Software Developer with Orabase Solutions LLC from Nov’2018 to Till Date.

(Working as a contractor for Verizon, Irving, TX, USA)

Systems Engineer –III with Pyramid Consulting Inc from July’2018 to Oct’2018

(Worked as a contractor for Verizon, Irving, TX, USA)

Senior Integrations Developer with Logan Data Inc, Westford, MA from Nov’2017 to June’2018.

(Worked as a contractor for Fresenius Medical Care, Lexington, MA, USA)

Technical Lead with Verizon Data Services India Pvt Ltd, Hyderabad from Sept 2011 till Aug 2017.

Module Lead with Verizon Data Services India Pvt Ltd, Chennai from Aug 2006 till Aug 2011

Analyst with Verizon Data Services India Pvt Ltd, Chennai from Feb 2004 till July 2006

Informatica Certified Designer

Informatica Certified in Architecture and Administration Power Center 7

Informatica Certified in Advanced Mapping Designer PowerCenter 7

Informatica Certified in Mapping Designer PowerCenter 7

AWS Certification

Amazon Web Services Solutions Architect for Associate level.

Awards

Key Contributor Award for getting CMMI Level for VDSI in 2007.

On the Spot award several times in Verizon Data Services India Pvt Ltd.

Project Name BOS - ONE FIBER

Duration July’ 2018 – Till Date.

Client Verizon, Irving, TX

Designation Systems Engineer –III

Business Office Solutions is a turnkey office solution that provides small business customers with the tools they need to run essential office functions including high speed low cost internet service (symmetrical speeds up to 1G) with LTE backup, office phone service, basic security services, and tech support. The One Fiber deployment enables Verizon to expand its reach into underserved customer segment, stretch Verizon beyond traditional lines and wireless devices, and enter into SMB security space new to Verizon.

Responsibilities:

Developed and Tested mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center 10.2.0

Tested performance tuning to increase performance of the mappings, sessions & workflows.

Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.

Performed project management duties including analysis, design, and implementation of Extraction, Transformation and Loading methodologies.

Environment: Informatica Power Center 10.2.0, Teradata, MS UNIX, Perl Script, Win CVS.

Project Name NHSN

Duration Nov’ 2017 – June’2018.

Client Fresenius Medical Care, Lexington, Massachesetts

Designation Senior Integrations Developer

Fresenius Medical Care is a German company specializing in the production of medical supplies, primarily to facilitate or aid renal dialysis. As part of the Dialysis to the patients, its required to provide detailed reports of the number of patients treated in their clinics to the Federal Governments. NHSN is part of that reports, which can take care of those details

Responsibilities:

Developed and Tested mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center 10.1.1

Tested performance tuning to increase performance of the mappings, sessions & workflows.

Environment: Informatica Power Center 10.1.1, Oracle 11g, SQL Assistant, MS UNIX, Perl Script, Win CVS, Putty, SQL Developer, XML files, Flat files.

Project Name Customer Profile Migration

Duration Aug 2012 – Aug 2017.

Client Verizon

Designation Technical Lead

The current E2Ei (End-to-End) program strategy is addressing new customers and needs to plan for the migration of the existing base into the E2Ei environment with minimal customer impact. The migration environment will have all the E2E Ordering, Provisioning and Billing systems and the central staging database. The extract provided by legacy systems will go through a normalization process before data is loaded in the Legacy Staging database. The Legacy staging database will have its own unique logical database schema that is different from the legacy systems schemas and accommodates the requirements of Ordering, provisioning and Billing systems impacted by the migration.

Responsibilities:

Developed ETL mappings, Transformations and Loading using Informatica Power Center 9.6.1.

Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center 9.6.1

Worked on ETL for VES business intelligence portal reports published under vesbi.verizon.com portal (http://intelligence.verizon.com/VESBIHome/Default.aspx)

Conducted performance tuning to increase performance of the mappings, sessions & workflows.

Used PL/SQL with Informatica Power Center 9.6.1 for Oracle 11g database.

Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.

Performed project management duties including analysis, design, and implementation of Extraction, Transformation and Loading methodologies.

Worked with complex mappings, mapplets, worklets and transformations

Implemented SQL/PLSQL Stored Procedures/Functions.

Developed advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic.

Generated server side PL/SQL scripts for data manipulation and validation for remote instances.

Involved in creating Unix Shell Scripting. Defragmentation of Tables, Partitioning, compressing and Indexes for improved performance and efficiency.

Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, testing of Informatica Sessions, and the Target Data using the debugger.

Developed, implemented and enforced ETL best practices standards.

Performance tuning and bottleneck resolution.

Created and Implemented Reusable tasks like E-mail.

Involved in logical and physical data modeling and analyzed and designed the ETL processes

Involved in the documentation of the project like TDD( Technical Design Document)

Prepared the change request Plan and update the status of the change request to the onshore with progress and achievements.

Worked in different support activities when needed.

Environment: Informatica Power Center 9.6, Oracle 11g, SQL Assistant, MS UNIX, Perl Script, Win CVS, Putty, SQL Developer, MS Xcel, Flat files.

Project :Decision Support System

Duration : Jan 2011 – July 2012.

Client : Verizon

Designation :Technical Lead

The Decision Support System (DSS) Data Warehouse is used by the organization to identify opportunities to increase revenue and market share and to develop deal analysis capabilities. It supports Marketing and Pre and Post –Sales activities to create new incremental revenue, retain existing revenue. It gives the various teams within Wholesale organization Marketing and Sales the analytics they need on their customers to do their day-to-day business transactions. The specific information that the clients could get from the reports is the billing data which is summarized at a certain level. DSS specifically contains detailed billing information extracted from the Bill Data Tapes (BDT). BDTs are received on a bill round by bill round basis, extracted, and transformed to be loaded.

Responsibilities:

Worked closely with the Business analysts and attended meetings to gather and discuss the requirements for enhancements and defect fixes for various projects

Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.

Resolved Production issues and helped in promoting the code to different environments for testing needs and participated in the deployment group.

Participate in project status meetings, peer reviews and other events with developers to get the status of the deliverables.

Analyzed and Identified the Tables/Views, Procedures and ETL objects that need to be migrated and prepared necessary Documentation.

Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.

Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production in order to meet the SLA's.

Provided support and quality validation through test cases for all stages of Unit and Integration testing.

Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.

Developed mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.

Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance. Understand the business needs and implement the same into a functional database design.

Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

Involved in migrating objects to different environments using Deployment groups and Labels.

Prepared various documents like ETL Specification doc, Technical Design doc, Run Book etc.

Worked with Informatica Partitioning when dealing with huge volumes of data and worked on parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.

Creating and modifying existing Technical Design Specification document and other client deliverables for different releases.

Coordinated and interacted with other teams to maintain integrity in performing the tasks and execution of the loads appropriately in a timely manner.

Environment: Informatica Power Center 9.1, Oracle 11g, SQL Developer, UNIX, Notepad+ +, WinCVS, Putty, Flat files.

Project : Sigs to XRM Database Migration

Duration : January 2009 – Dec 2010.

Client : Verizon

Designation :Module Lead

XRM is a solution designed to automatically generate service orders for the Local Service Requests (LSRs) submitted by Competitive Local Exchange Carriers (CLECs).XRM exists with East states, where as SIGS exists with WEST states.

Here is the requirement to make both East, West states into single application, which is the existing XRM application. So need to migrate the entire SIGS database, which is existing now in Informix to Oracle database, which is XRM database.

Responsibilities:

Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouse.

Participated in reviewing requirements during analyze and ensuring that sufficient details is available going into the design phase.

Developed ETL Mappings using Informatica PowerCenter 8.1 involving extraction and loading of data from Informix Database to Oracle.

Worked with Informatica PowerCenter-server, Repository Manager, Designer, server Manager, Informatica Server.

Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor

Test the Informatica mapping and workflows against the specifications on the detailed design.

Participate in project status meetings, peer reviews and other events with developers to get the status of the deliverables.

Creating and modifying existing Technical Design Specification document and other client deliverables for different releases.

Extensively worked in the Performance Tuning of the programs, ETL Procedures and processes.

Developed Pre-Session and Post-Session UNIX scripts to automate the data load processes to target Data warehouse.

Extensively used parameter files to avoid hard-coding in mappings to facilitate possible future changes thereby saving migration times.

Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.

Defects were tracked, reviewed and analyzed.

Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.

Monitoring the ETL production jobs and resolved the issues/bugs.

Identified sources, targets, mappings and sessions and tuned them to improve performance.

Environment Informatica Power Center 8.1, Informx, Oracle 10g, SQL Developer, UNIX, Notepad+ +, WinCVS, Putty, Flat files.

Project : Network Metrics Platform

Duration : June 2004 – December 2008

Client : Verizon

Designation :Analyst

Telecom is a regulated business in USA and the genesis of the project lies in the Central telecommunication Regulation act of 1996. This act opened the local telephone market for competition giving rise to the competitive local exchange carriers (CLEC). The bandwidth providers were mandated to provide service to these smaller telecom service providers who would collect their customers by offering discounts and use the bandwidth and services provided by carriers. The FCC therefore asked the incumbent local exchange carriers (ILECs) to produce metrics validating that the CLECs were being provided same level of service as any other customers of ILECs. The Network Metrics Platform (NMP) is an initiative to bring this data on a central platform. This entails extracting data from several existing systems feeding this data to the data warehouse, building data marts to support the reporting requirements, doing the number crunching and producing the required reports.

Responsibilities