Manoj Manda

Sr Data Integration developer

adhkv8@r.postjobfree.com

830-***-****

Professional Summary

Responsible and highly motivated professional with 10 + years of Data warehousing, ETL experience and Over 3 years of experience in BI tools (BI Apps/ OBIEE/ Siebel Analytics).

Expertise in complete SDLC of Analysis, Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses, Data Vault and Data Marts.

Experience Domains in Insurance, Banking, Financial and Retailers.

Extensively used Informatica Power Center Informatica Power Center 10.x/9.x/8. x. for Extract, Transform and Loading of data from multiple data sources to Data Warehouse and creating various mappings, sessions, and Workflows, Also Hands-on experience on other ETL tools like SAP BODS and IBM DataStage.

Experience in various data integration like Mainframe, Power Exchange, Flat files and Databases like Oracle, Teradata, Netezza and IBM DB2 and External Source Integration like AWS Aurora, S3 and Metadata Manager.

Hands on experience in ETL coding to build a request for a SOA Service and after the SOA service call the ETL to receive the response detail from OIPA via SOA Service.

Experience in Data profiling, Data Balancing and Data quality.

Practical knowledge in SCD - slowly changing dimension types (1,2 and 3) and CDC- change data capture.

Good practical understanding of Logical and Physical Data Model design process in Star Schema and Snowflake Schema Methodology, relationship between Fact and Dimension tables. Understanding of primary, foreign, compound, and surrogate keys relationship.

Expertise in designing and developing the OBIEE/Siebel Analytics Metadata Repository (.rpd) using OBIEE/Siebel Analytics Server Admin tool.

Expertise in creating, modifying, and administering OBIEE/Siebel Analytics Intelligence Dashboards using OBIEE/Siebel Answers, creating iBots using OBIEE/Siebel Delivers.

Worked in PERL and Shell Scripting on UNIX & Linux platform.

Experience in Test Automation using Ruby

Automated Unit testing of informatica code using Rspec framework in Ruby mine.

Experienced in writing Acceptance Criteria and converting them to Gherkins

Experienced in using Continuous Integration Server like Jenkins to trigger Ruby tests with any change in Subversion, GITHUB.

Used ATDD, TDD for test automation

Experience in Urban Code Deploy for the Code deployment.

Hands on experience in agile methodologies like SCRUM.

An innovative team player proven to work under tight deadlines, adaptable to any new software technologies, quick learner and can work efficiently as an individual.

Excellent knowledge and experience in Technical Design, Mapping document and Documentation.

Excellent communication skills, ability to meet tight deadlines and prioritize tasks.

Experience on Production support.

Hands-on experience on huge XML’s and SOAPUI webservices

Designed, developed maintained and tested Tableau report for Impact Analysis of ETL data mapping documents

Maintained Python script to bring in updated Data mapping document while reports are running. Education: Master’s in software engineering

Manda/Page 2

Certifications:

AWS Certified Solutions Architect – Associate

https://www.certmetrics.com/amazon/public/transcript.aspx?transcript=XG9N2RH12EBE1B3Y Neo4j certified professional

LinkedIn: http://linkedin.com/in/manoj-k-manda-03a889133 Professional Experience

g2o/ICC – Sr Data Integration developer

Nationwide Insurance, Columbus OH Oct 2018 – Till date Alliance Data services, Easton OH April 2018 – Sept 2018 Nationwide Insurance, Columbus OH Sept 2016 - March 2018 NetJets, Columbus OH May 2016 – Sept 2016

IBM – Bank of the West, Dublin OH Feb 2015 – May 2016 Responsibilities:

Involved in gathering and analyzing the requirements and preparing business rules.

Translated requirements and high-level design into detailed Data mapping specifications.

Attend project estimation meetings with business.

Designed Complex Informatica mappings with transformations such as Http, xml parser, Expression, Joiner, Filter, Union Transformation, connected/unconnected Lookups, Update Strategy

Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle and Flat files and loaded into downstream databases.

Developed and supported web services jobs to build a request for a SOA Service and after the SOA service call the ETL to receive the response detail from OIPA via SOA Service.

Designed and implemented Staging, data vaults and data marts incorporating SCD Type-2 logic

Involved in writing Post-session UNIX scripts for implementing audit framework and enabling delta data loads. Developed Python scripts for building automated mappings for extracting staging data from source

Designed implementation plan and data load scheduler for migrating ETL objects to Production and supervising post go-live support.

ETL Tools

Informatica 10/9.1/9.5/8.1/6 (Workflow Manager, workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer, SAP BODS, IBM Data Stage Data Modeling Erwin 3.5, Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snowflake, FACT, Dimensions) Databases Oracle 11g/10g SQL Server 2000, DB2, MySQL, MS SQL Server, Netezza. Web Design PHP, Java Scripts, Perl, HTML.

Programming

Languages C & Data Structures, C++, Java, SQL, PL/SQL, Ruby, Perl, Python Job Scheduling &

Other tools CA Autosys, Maestro, Quest Central for DB2, SQL* Loader, DAC, ESP Operating Systems Windows 98/2000/XP/VISTA, Linux

Administration System and Network Admin

Manda/Page 3

Hands on experience in developing mappings of Facts, Dimensions, satellites, Hub and facts in accordance with the respective STTMs

Architected ETL design of dimensions and satellites to strategize data load

Migrated Existing SAP BODS mappings to Informatica and achieved same output in all the target tables.

Developed mappings to load into staging tables and then to Dimensions and Facts.

Developed mapping parameters and variables to support SQL override.

Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

Designed the EDW load process for CCAR in discussion with the Data Modelers and Data architects.

Developed data quality checks as per the Fed Edit Check requirements of FRB as part of capital planning.

Computed complex SQL queries involving multiple tables with joins for source qualifier and to unit test the results of IDQ & Power center mappings.

Participate in all stages of project life cycle including Design, Development, Testing, Pre-production activities and production deployment.

Involved in creating new table structures and modifying existing tables to fit into the existing Data Model.

Integrating testing, maintained warehouse metadata, naming standards and warehouse standards for future application development, Parsing high-level design specifications to simple ETL coding and mapping standards.

Followed ATDD and TDD for Test suit development.

Automated Unit testing of informatica code using Rspec framework in Ruby mine.

Merge the automations scripts with source code by using Git as version control.

Utilized Jenkins for continuous integration and continuous deployment operations. Scheduled jobs to execute specs on server on daily basis

Utilized Jenkins Verify the test results of headless tests on Jenkins build.

Developed Tableau report for Data mapping impact analysis and developed python script to pull updated document when report is being requested.

Performed pre-session and post-session scripts in Informatica mappings

Worked extensively on the Data Balancing and Data quality shell scripts and metadata for accuracy of the data delivered.

Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.

Used Maestro/ESP for Job scheduling, ran and maintained schedules across Unix/windows servers.

Took ownership of the code, Responsible for the code maintenance in GITHUB.

Onboarding the new team members.

Used Urban Code Deploy for the automating the code deployment

Has been leading a team of 8 developers in a tier 1 Project Oracle Insurance Policy Administration

(OIPA).

Performed the Peer Reviews for the Test Designs and suggested required modifications

Worked with business users, testing team and application development teams on analyzing, resolving, and documenting the defects using HP ALM tool

Conducted design meetings with team members.

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

Extensively working on Agile Methodology.

Technologies: Informatica Power Center 10.2, Informatica Power Exchange, SAP BODS, Oracle 11g Netezza, Microsoft SQL server, Flat Files, SQL, Toad, DBweaver ESP Changeman,Netezza Bulk Reader/Writer, XML, CSV, UNIX Shell, Perl Scripts, Python, JetBrains Ruby Mine, Tableau Desktop, Quality center and Jira

Manda/Page 4

United Health Group April 2014 – Dec 2014

Informatica/BI Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, analysis, ETL design and development for extracting data from the heterogeneous source systems.

• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.

• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.

• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.

• Created Stored Procedures to transform the data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into SQL Server database.

• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.

• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers and Scheduling AGENTS (IBOTS) in OBIEE 11g.

• Creating aggregate tables such that it allows for drilldowns in the OBIEE reports combining various measures to improve performance.

• Developed and debugged many Dashboards using different Analytics Views (Pivot, Table, Chart, and Column Selector, View Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters. Environment: Oracle BI 10G, Informatica 8.6, TOAD, Siebel 8.1, Oracle, Sql, Excel Comcast Englewood, CO March 2013 – April 2014

Informatica/BI Developer

• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis. Designed Source to Target Mapping specification Documents.

• Created complex mappings and reusable transformations. Made use of mapping variables, mapping parameters.

• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, SQL transformation and sequence generator.

• Created mappings for various sources like Oracle, SQL server, flat files, and XML files to load and integrate data to warehouse.

• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.

• Worked with pre and post sessions and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.

• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance

• Wrote SQL, PL/SQL codes, stored procedures and packages.

• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager

• Developed Unix Shell scripts and Perl Scripts to Migrate data from different legacy systems in databases.

Manda/Page 5

• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.

• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.

• Security management for users, groups and web-groups using the various authentication systems

(Database table, Dashboard / Report-level security).

• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.

Environment: Informatica 8.6, (Oracle Business Intelligence Suite) OBIEE 11.1.6/11.1.5, Oracle 10g/11g, BI Publisher, TOAD, SQL, SQL Server 2000/2005, Windows 7, Unix, Linux, and Windows 2003.

Ventura Foods Brea, CA April 2010 – March 2013

Informatica Developer

Responsibilities:

Provided analysis of the source data and coordinated with Data Warehouse team in developing Relational Model.

Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.

Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering.

Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.

Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations.

Designed and developed Aggregate, Expression, Filter, Join, Router, Lookup and Update transformation rules.

Cleanse the source data, then Extracted and Transformed data with business rules, and built Mapplets using Informatica Designer.

Created staging area to cleanse the data and validated the data.

Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.

Implemented Slowly Changing Dimension methodology for accessing the full history. Created Several Informatica Mappings to populate the data into dimensions and fact tables.

Created the JDE month end Inventory balance report in BI to compare the legacy inventory and JDE Integration.

Created the Legacy Audit report for Inventory sales and transportation for unprocessed orders if they not processed more than HR (Using the JDE Time Stamp) for Legacy and JDE integration process.

Environment: Informatica Power Center 6.1, OBIEE 10g, Oracle, JD Edwards, BI Applications 7.9.6.3, DB2, TOAD, Visio.

Contact this candidate