Mangala Tripathi

Mangala Tripathi Senior Systems Engineer Address: 39600 FREMONT BLVD. Contact No - - APT 17, FREMONT, CA - 94538. Email –- Visa Status – Applied for H4. Summary: 4 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power Center. 1 year of experience in using BODS. 1+ years of experience in Reporting tool Business Objects. Rich experience in Financial Domain. Worked on projects in Waterfall and Agile methodology. Proficiency in developing SQL with database like Oracle. Knowledge in Full Life Cycle Development of Data Warehousing. Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center. Experience with dimensional modelling using star schema and snowflake models. Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies. Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks. Independently perform complex troubleshooting, root-cause analysis and solution development. Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills. Team player, Motivated, able to grasp things quickly with analytical and problem- solving skills. Education: Qualification Major/Board Institution CGPA/PERCENTAGE B.Tech Computer Science Engineering Gandhi Engineering College, India 8.00/10.00 12th C.B.S.E. Kendriya Vidyalaya, India 83.2% 10th C.B.S.E. Kendriya Vidyalaya, India 80.6% Experience: Infosys Limited (CLIENT - L’OREAL; Bangalore, India) February 2018- December 2018 Project: Boost ANZ -Senior Systems Engineer Designed, built and deployed effective mappings and workflows. Implemented stored procedures and effectively used oracle queries. Translated requirements from the business and analyst into technical code. Identify and test for bugs and bottlenecks in the ETL solution. Ensure the best possible performance and quality in the packages. Provide support and fix issues in the packages. Accenture (CLIENT - ABINBEV; Bangalore, India) January 2017 – January 2018 Project: Moonwalk Legacy -ETL Production Support Engineer Supported moonwalk application of the HR module which refreshed 6 critical down streams used by the client. Co-ordinated with the global admins for the clean flow of the data across applications. Interacted with the clients directly for continuous improvements, suggestions and issues. Learnt the basic info types of SAP to check the source data on own. Mentored the new members of the team about the application and technology involved. Accenture (CLIENT - AUTODESK; Kolkata, India) April 2015 – December 2016 Project: Financial Revenue Reporting System - ETL Developer Gathered requirements and provided the solution to the client. Worked on various technologies as INFORMATICA 9.1.0, ORACLE, SAP BO 3.1. Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer to extract the data from multiple source systems that comprise databases like Oracle to the Staging area then to the Data Marts. Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer. Effectively used Informatica parameter files for defining mapping variables, parameters and workflow variables. Fixed the invalid mappings and troubleshoot the technical problems of the database. Created and monitored sessions using workflow manager and workflow monitor. Managed the process of troubleshooting and debugging the bugs or issues found during test execution. Involved in incorporating new changes as per business requirements. Developed Reports in SAP BO InfoView for the different data sources. Experienced in modifying and maintaining Universes in SAP BO. Experienced in creating new classes and objects of BO Universe based on the business requirements. Have considerable knowledge on SAP. I have used SAP as one of the sources in Informatica. Have knowledge on some of the t-codes used in SAP and can reprocess the orders with its accounting documents as per the business requirements. Experienced in creating Oracle queries which is highly used in Informatica. Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database. Experienced in working with Project Management Tools as Rally and JIRA. Skills & Knowledge ETL: Informatica PowerCenter 9.1.0, SAP BO Data Services (BODS) BI: SAP BO 3.1(Business Objects) Database: Oracle 11g/10g Operating Systems: Windows, Unix(Basics) Languages: C, C++, Java, HTML, XML, SQL, PL/SQL. Software / Applications: MS Word, MS Excel, MS PowerPoint, Outlook, Visual Studio. Tools: Eclipse, NetBeans, Notepad++. Declaration: I hereby declare that all the information given here are true to the best of my knowledge. Date: 15-Apr-20 (Mangala Tripathi)