Home

Kartheek Ravella - Informatica Lead

[email protected]

Location: Columbus, Ohio, USA

Relocation: Yes

Visa: H1B

Kartheek Ravella Informatica Lead 614 787 9625 [email protected] Columbus, OH Yes H1B PROFESSIONAL SUMMARY: Twelve years of IT experience in the Analysis, Design, Development, Testing, and Implementation of business application systems for Telecom, Food and Beverage, Pharmaceutical Sectors using Informatica power center, BI, Oracle ICS. Strong experience in the Analysis, design, development, testing, and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, BI, Client/Server applications. Strong Data Warehousing ETL experience of using Informatica Power Center Client tools - Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor. Expertise in Data Warehouse/Data mart implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation, production support and Agile (Scrum) methodology. Experienced in scheduling ETL jobs using Shell scripts, Crontab, Control M. Experienced in working for the post development cycle and applications in Production Support. Experience in Creating ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, Oracle into a common target area such as Data Warehouse. Experience in Oracle Integrated Cloud Service (ICS). Integration Experience with RESTFUL and JSON services. Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center. Experience using ODI ELT tool, Obiee. Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions. Have worked on Business Analytical Reporting using BI Tools like Obiee. Experience in Different Types of Layers like Physical, BMM, Presentation Layer in OBIEE 11g. Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, cubes and reports. Worked on Adapters like REST/SOAP/FTP/Database/Oracle ERP Cloud/EBS/Salesforce in OIC. Working on Oracle Integration service (ICS/OIC) with SOAP services, REST API s and Agents. Experience with Performance tuning using Query optimizer, Explain plan, Execution plans, Indexes and HINTS. Experienced in designing customized interactive dashboards in OBIEE using drill down, prompts, filters, and variables. EXPERIENCE SUMMARY: Working as Consultant for JPMC, Ohio from June 2022 to till date. Worked as Staff IT for CommScope, Bengaluru from Sep 2014 to April 2022. Worked as Senior Software Engineer for Mercury Technosoft Pvt.Ltd, Bengaluru from Mar 2013 to Aug 2014. Worked as a Software Engineer for Mavinsolutions,Hyderabad from Feb 2010 to Feb 2013. EDUCATION QUALIFICATION: Bachelor of Technology from JNTU, Hyderabad in 2008. PG Diploma from C-Dac Chennai in 2010. TECHNICAL SKILLS: ETL Tools : Informatica Power Center 8.X/9.x/10.x, ODI 11 BI Tools : OBIEE 11.1.1.5.x/11.1.1.6.x/11.1.1.7.x Database : Oracle, SQL Server Languages : C, SQL, Shell Scripting, Scala, Python. Integration tools : Oracle ICS, Web methods, IICS Big Data : Hadoop, Sqoop, Hive, HBASE, Apache Spark. Other Applications : Control M, MKS Integrity, Git, Toad, JIRA, ServiceNow. EXPERIENCE: JPMC, Plano, TX (Remote) June 2022 to till Date ETL Informatica / Data Engineer/ Lead Chase Management Services deliver domain data to all downstream applications. Create financial data from settlement to Transaction History and reporting. Deliver transactional data to key systems RMS, EIS, ROL. Process transactional data for aggregated rollups, billing, and analytics. Responsibilities: Documenting Functional and Technical Design Specs based on the Business Requirements. Strong SQL knowledge for performing the data analysis and assisting business for analysis. Validate the data in source and target systems using PL/SQL queries. Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions. Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules. Used various transformations like Source Qualifier, Joiner, Lookup, Sql, and router, Filter, Expression and Update Strategy. Ran both Full Load and Incremental Loads in Lower Environments. Involved in code migration from Informatica power center to IICS. Unit testing Informatica power center objects migrating using migration factory (IICS). Environment: Informatica Power Center 10.4.1, Informatica Metadata Manager 10.4.1, Oracle 19c, SQL, Perl, Control M, JIRA, MKS Integrity, ServiceNow, Git, IICS. Project Qmart (Arris) Aug 2018 to April 2022 ETL Lead/ SME Qmart is Data warehouse, reporting via a tool called PQL(Obiee). It has interfaces into other tools PSCRM, RDW(Repair), Jira (Software bugs), High Jump (Warranty), Oracle OM(Orders). Manage warranty reserve through the deployment of warranty & exposure analytical models. (AFFR, Warranty forecasting, R(t).). QMART reporting of 12 TL9000 categories across Business, Customer, Technology, & product dimensions. Responsibilities: Involved in the Integration of data into Qmart during the Acquisition of the companies by Arris. Involved in the Data Analysis with the Business users. Documenting Functional and Technical Design Specs based on the Business Requirements. Following the entire SDLC Process i.e., Development, Unit Testing, Regression Testing, UAT, Production and Postproduction Support and Agile (Scrum) methodology. Modified existing mappings for enhancements of new business requirements. Monitor system integrity through daily system checks, to ensure a high standard of service is provided. Used Debugger to evaluate the mappings and fixed the bugs. Strong SQL knowledge for performing the data analysis and assist business for analysis. Validate the data in source and target systems using PL/SQL queries. Experience in using Automation Scheduling tools like Crontab. Used SQL queries and UNIX Shell scripts to check the database integrity. Involved in code migration testing from Informatica Power Center 9.5.1 to 10.2.0 HF1. Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions. Collaborate with and mentor current development staff in the use of Business Intelligence (OBIEE), Informatica Power center, and Oracle coding language based on prior development activities in these environments. Configured Object Level and Data Level Security in the reports. Configurations for delivering reports using Oracle BI Delivers component of OBIEE. Configuring Request of drill-down and drill up capabilities in OBIEE. Designed and customized data models for Data warehouse supporting data from multiple sources in real time. Involved in building the ETL architecture and Source to Target mapping to load data into the Data warehouse. Done the Migration of all the Mappings and Workflows from DEV to TEST, TEST to UAT and UAT to Production Environments. Environment: Informatica Power Center 9.5.1/10.2.0 HF1, OBIEE 11.1.1.9, Oracle 11g, SQL, UNIX, SQL Developer. Project RDW (Arris) Mar 2017 to Aug 2018 ETL Lead Responsibilities: Gathering Business Requirements or Enhancements to tweak the existing Mappings during the conversion in Informatica. Documenting Functional and Technical Design Specs based on the Business Requirements. Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes. Designed and developed Mappings used Informatica Transformations like Source Qualifier, Joiner, Expression, Router, Aggregator, Lookup, Update Strategy. Providing Technical and Functional assistance to team members for issues/queries. Requirements gathering meetings with key project stakeholders. Worked during the whole life cycle of the project from requirements gathering to deployment. Created and refined user stories for the development work. Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts. Environment: Informatica Power Center 9.5.1, OBIEE 11.1.1.6, Oracle 11g, SQL, UNIX, SQL Developer. Project PACE Integration (Arris) Jan 2016 to Mar 2017 Sr. Informatica ETL Developer. Responsibilities: Gathering Business Requirements or Enhancements to tweak the existing Mappings during the conversion in Informatica. Documenting Functional and Technical Design Specs based on the Business Requirements. Following the entire SDLC Process i.e., Development, Unit Testing, Regression Testing, UAT, Production and Postproduction Support. Ran both Full Load and Incremental Loads in Lower Environments. Improved and enhanced various jobs in different cycles by creating reusable and common job techniques, extensively used parameters at run time to push in job related parameters. Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes. Designed and developed Mappings from OLTP to Stage and Stage to DWH and effectively used Informatica Transformations like Source Qualifier, Joiner, Expression, Router, Aggregator, Lookup, Update Strategy etc. Worked with SQL Override in the Source Qualifier and Lookup transformation. Validate the data in source and target systems using PL/SQL queries. Extensive use of ETL process to load data from different RDBMS and flat files. Used Informatica Designer to design mappings and coded it using reusable mapplets. Involved in capturing the incremental changes in the source systems for updating in the staging area and data warehouse, respectively. Environment: Informatica Power Center 9.5.1, OBIEE 11.1.1.6, Oracle 11g, SQL, UNIX, SQL Developer. Project COMSC (Arris) Aug 2014 to DEC 2015 Sr. Informatica ETL Developer. Responsibilities: Involved in the Data Analysis with the Business users. Involved in the Integration of data into during the Acquisition of the companies by Arris. Conduct impact assessment with business in order and determine high level design and size of effort based on requirements. Drive design and determine the ETL requirements for BI projects. Done the Migration of all the Mappings and Workflows from DEV to TEST, TEST to UAT and UAT to Production Environments. Setting up ODBC Connections in both (TEST and Production) Informatica Boxes and in all the 4 Environments of Informatica. Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping. Enhanced Performance on Informatica sessions using large data files by using partitions. Worked in Agile environment to effectively meet the deliverables. Worked with SQL Override in the Source Qualifier and Lookup transformation. Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter. Validate the data in source and target systems using PL/SQL queries. Environment: Informatica Power Center 9.5.1, OBIEE 11.1.1.6, Oracle 11g, SQL, UNIX, SQL Developer. Client - Dunkin Donuts Bengaluru July 2013 to July 2014 Informatica Developer Dunkin Brands has engaged an external vendor (Epsilon) to provide a loyalty platform for guests to earn rewards based on purchased made with their Dunkin stored value card. The loyalty platform will allow guests to earn points based on the dollar amount of their purchases, as well as bonus points based on conditional offers as part of larger marketing campaigns. Proficy Datamart reaches deep within manufacturing operations across the business to provide a single, unifying view into operational performance, reducing the time, cost, and complexity of developing sophisticated ad-hoc reports and analysis. Responsibilities: Understanding existing business model and customer requirements. Worked on Source Analyzer, Mapping Designer and Transformations, Informatica Repository Manager and Workflow Manager and Monitor. Worked with various transformations in designing the mapping like aggregator, expression, update strategy, filter, joiner, sequence generator and lookup transformation. Evaluated the Mappings with Unit Test Cases and involved in code reviews. Involved in the Shell script development for download and validate files from Epsilon Site Involved in code migration testing from Informatica 9.0.1 to 9.5.1. Involved in the Shell script development for download and validate files from mymicros. Involved in code migration testing from Oracle to Oracle Exadata. Worked extensively in Informatica by building Mappings and Workflows. Environment: Informatica Power Center 9.0/9.5.1, OBIEE 11.1.1.6, Cygwin, Oracle 11g, SQL, UNIX, SQL Developer. Client - Timex Bengaluru March 2013 to July 2013 BI Developer The objective is to improve business decisions via improved financial analysis and reporting. And implement a dashboard solution to provide increased visibility to product bookings actual and forecast information. The project involves the development of Data warehouse system developed for this information. Responsibilities: Extensively used OBIEE Administration tool for customizing and modifying physical, Business and Presentation layer of the repository. Design and customization of Obiee Analysis, Reports and Dashboards. Developed a report with Filters, Pivot Table, and other views. Creating Presentation Catalogs with measures from Multiple Fact Tables. Unit Testing of Analytics reports, along with data validations using queries for the correctness of data Environment: OBIEE 11.1.1.6, Informatica Power Center 9.0, OBIA 7.9.6.3, Oracle 11g, SQL, UNIX, SQL Developer. Client - Hetero Hyderabad Feb 2010 to March 2013 BI Developer Hetero is a research based global pharmaceutical company focused on development, manufacturing, and marketing of Active Pharmaceutical Ingredients (APIs), Intermediate Chemicals & Finished Dosages. The project involves the development of Data warehouse system developed for this information. Informatica power center was the primary ETL tool and OBIEE was the reporting tool. Responsibilities: Extensively used OBIEE Administration tool for customizing and modifying physical, Business and Presentation layer of the repository. Developed report with Filters, Column Selector, View Selector, Charts, Narrative, Gauge views, Pivot Table, and other views. Created Dashboards Prompts, Pages, Link, Embedded content, Text, Folders and Guided navigation links. Worked on Creation of Prompts and Filters. Worked and Configured with a Pivot Table, Narrative View, and Charts. Worked on Source Analyzer, Mapping & Mapplet Designer and Transformations, Informatica Repository Manager and Workflow Manager and Monitor. Used DAC and Informatica to load data from OLTP (On-Line Transaction Processing) to OLAP (On-line Analytical Processing) staging and then to the final Data Warehousing Tables for reports. Developed mappings using Informatica Power Center Designer to load data from various source systems to target database. Evaluated the Mappings with Unit Test Cases and involved in code reviews. Environment: OBIEE 11.1.1.6, Informatica Power Center 8.6, Oracle11g, SQL, UNIX, SQL Developer. Awards: Star performer awards for the projects COMSC, Pace Integration, Business 2.0. Applause from the business users for the providing an alternate solution. Keywords: cprogramm business intelligence active directory rlang information technology procedural language Ohio Texas