­­­­­

SUMMARY:

• Specialized in translating the Business requirements / problems into Technical specifications by proposing different design proposals for implementing the robust ETL and BI process.
• Expertise in scratch implementations in Data Extraction, Transformation & Loading into Enterprise Data Warehouse / Marts and building different analytical Reports, Dashboards, Pages and Views.
• Proficient in Data Integration and Migration experience in Scoping, Impact analysis, Design, Developing ETL mappings and scripts using Informatica Power Center v9.X.X/8.X/7.X using Designer (Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor clients.
• Extensively worked on various transformations like Lookups, Router, Filter, Expression, Aggregator, Joiner, Stored Procedure, Update Strategy, XML, Qualifier, Normalizer, Union and Sequence to develop the complex scenarios of Slowly Changing Dimensions (SCD).
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Developed Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation.
• Experienced on working on various Data warehousing tools (Informatica, ODI, Teradata, SSIS) and Business Intelligence tools (OBIEE, SAP BO, COGNOS & Tableau).
• Hands on Installing and Upgrading Informatica on UNIX/LINUX Platform with their new software versions and maintaining Patch/Hot fix levels on all environments.
• Used Informatica cloud to setup the users, roles, campaigns and perform ETL activities to Salesforce.
• Good understanding of SQL, PL/SQL scripts, views, indexes, stored procedures and other components of database applications. Expertise in Universe designing, developing and generating complex dashboards, List of values along with User Acceptance Test and data accuracy.
• Worked on various large databases like Teradata 12.0, Netezza, Oracle 11g/10g and SQL SERVER on various operating systems like UNIX, LINUX and Windows XP/NT.
• Possess good experience on Data warehousing Concepts, scoping, defining and design the Dimension Modeling Schemas like Star, Snowflake and Galaxy.
• Experience in using the Informatica command line utilities like PMCMD to execute workflows in non - windows environments. Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX / Linux environments.
• Member of the Hadoop Core team, actively participating in defining various Hadoop design standards and getting them implemented in client infrastructure.
• An enthusiastic and project-oriented team player with solid Analytical, Communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Experience in various Business Domains like Healthcare, Insurance, Banking and Manufacturing.

TECHNOLOGIES:

ETL Tools: Informatica (Tools, MDM), ODI 11g/12c, Teradata 14.0

BI Tools: BI Apps, OBIEE 11g/10g, BI Publisher, BO, Tableau

Distributed Computing: Apache Hadoop, HBASE, HIVE, IMPALA, NOSQL

Databases : Oracle, Teradata, SQL Server, DB2

Programming Languages : C, SQL, PL/SQL, JAVA, Shell Scripting

Scheduling Tools : DAC, AUTOSYS, Control-M, JAMS

Operating System : LINUX, AIX, UNIX and Windows

PROFESSIONAL EXPERIENCE:

Sr. ETL & BI developer 

Responsibilities:

• Gathering and understanding the requirements by conducting the Mock up meeting, preparing the impact & risk analysis and assessing the effort estimations.
• Review and translate the business requirements into High level and Low level Tech design
• Building the ETL & Reporting solutions using Oracle Data Integrator (ODI), OBIEE 11g, Oracle R12
• Implemented modules like Financials, Fixed Assets by leveraging the OTB (Out of the Box) functionality or by developing the new Custom Packages and Interfaces as per the business.
• Build and implementation include stand-alone and Java EE agents, ODI data services, ODI console, ODI studio and other appropriate development tools.
• Proficient in applying the ODI Product patches/bugs and upgrading activities on client instances
• Worked with Oracle product development team for fixing various Load performance issues, Patches and other Product bugs through Service requests.
• Performed administration (OBIEE) activities like creating users, roles, responsibilities and backups for master and work repository, bouncing the servers, topology setups, and maintaining the session logs, extracting the load statistics.
• Customize and administrate the Physical layer, Business Model Mapping layer and Presentation layer of the OBIEE repository.
• Adhered to the client standards and Oracle best practices while implementing the solutions
• Implement the Performance tuning techniques in ODI and DW to improve Extract & Load performance for both OTB and Custom packages.
• Developed complex business logic through ODI and then scheduling the packages in Load plan
• Conduct Peer-peer code reviews, prepared Unit test scripts and executing them
• Prepared detail migrations tasks for the code migration from Lower to Higher instances
• Troubleshooting the load performance, data issues and then providing detail root cause analysis
• Scheduling and monitoring of the Full and Incremental load cycles from Console and through ODI operator navigator.
• Effective coordination with Source, DBAs and other Up/down stream teams during Implementation and support phases.

Environment:BI Apps modules 11.1.1.8.1, BI Apps Patches we are in bundle patch PB6, Platform Linux OLE6 ODI Version/Patches: 11.1.1.7, OBIEE 11.1.1.7.1 , Oracle Apps (EBS) 12.1.3, OLTP (DB) version 11.2.0.4, OLAP (DB) version 12.1.0.2.0 , Java EE agents, Application Lifecycle Management (ALM), TOAD, Hyperion, DRM, CES, Financial Accounting Hub (FAH), PL/SQL, SQL, UNIX.

Sr. ETL Developer

Responsibilities:

• Prepared the Estimations and Design specifications for the requirements by having proactive discussions with the Business Analysts, Data Analysts and End users.
• Modeling the database schema based on the new client data and executing the database scripts
• Designed and build the Informatica mappings, mapplets, workflows and worklets based on the technical design proposal by adapting to the client standards.
• Extracted data from wide variety of data Sources like Flat files, XML’s, Relational Databases (Oracle, SQL Server) as per the standard format and load into Central DW (Netezza, Salesforce)
• Configured Address Doctor in MDM which can cleanse whole world address Data and enhanced by making some modifications during installation.
• Extensively worked on Informatica performance tuning maps, sessions and workflows to find potential bottlenecks in the Source, Informatica and Target systems.
• Implemented the massive data loads by using range partitioning to achieve parallel data loads.
• Used Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger.
• Developed UNIX shell scripts for scheduling the jobs, archiving the logs, validating the input data files and automating the manual process.
• Proactively identify the loads which consume more time due to performance or data volume issues and then preparing the Root cause analysis to fine tune those jobs.
• Installed Hotfixes, utilities and patches released from Informatica Corporation, responsible for coding standards and migration activities to the respective environments.
• Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows and data accuracy.
• Coordinated and engaged the team to reach the milestones by crossing major barriers while implementing Complex requirements.
• Implemented the Proof of Concept on the new solutions proposed for business requirements.

Environment:Informatica 9.5.1 hotfix6, Informatica Data Quality(IDQ), Informatica Master Data Management(MDM), Informatica Administration, Informatica Cloud, Web services, ODI, Netezza, Oracle 11g, Flat Files, XMLs, Sales force CRM (SFDC), SQL Server, Aginity Workbench, Unix Scripting, Cloudera Hadoop, HIVE, PIG, IMPALA, NOSQL, JAMS, Putty servers, Eclipse, SQL, PL/SQL, HP Quality Center, Salesforce CRM.

Sr. ETL Developer

Responsibilities:

• Closely worked with Business Analyst and Architects to clarify the Requirements and then translate them into technical specifications.
• Implemented the mappings using Normalizer and other transformations to process the data from the COBOL VSAM files by preparing the respective Informatica Copybook for each and every file and then propagating the data into Teradata warehouse.
• Developed CDC (Change Data Capture) mechanism using Informatica Power Exchange for Real time analytics by capturing the live updates in the OLTP / Source systems.
• Experienced in using various transformations like Aggregator, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Lookups, Union and XMLs to develop robust mappings.
• Implemented Push down optimization (PDO) technique and used to Teradata utility adapters (BTEQ, MLOAD, FLOAD, FEXTRACT and TPT) at the sessions to fasten the loading process.
• Designed and implemented the Audit trail process for the ETL job statistics.
• Created reusable Events, Tasks, Sessions, Worklets and Workflows in Workflow manager.
• Used Workflow Manager and Workflow Monitor for scheduling ETL jobs, repository creation/Backup/Restore using PMREP, Creating repository user/role/group.
• Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with explain plan, creating new indexes, partitions and Materialized views.
• Troubleshooting memory related issues like DTM, Line Sequential buffer size, Stack over flow in Informatica and Database related spaces issues.
• Used Teradata SQL Assistant to query the data in the target Teradata data warehouse.
• Worked with Informatica support team to resolve the Environment and Product bugs.

Environment:Informatica9.5.1, Informatica Power Exchange(CDC), Informatica Data Quality(IDQ), Informatica Master Data Management(MDM), Teradata 14.00, Erwin, Control-M, SQL Server, DB2,Qlikview, ERWIN, TOAD, Teradata SQL Assistant, Oracle 11g, Flat Files, XMLs, COBOL Files, Mainframe JCLs, Hadoop, HIVE, PIG, Map Reduce, HBASE, AUTOSYS, Unix Scripting, Erwin, LINUX, PL/SQL, SSIS, SSRS, HP Quality Center.

ETL& BI Developer

Responsibilities:

• Requirement gathering and preparing low level and high level design documents after doing proper impact analysis for new and enhancement changes.
• Build efficient ETL Process for processing the data warehouse facts &dimension tables through complex transformations and SCD type 1 and SCD type 2 implementations.
• Customized the OOB Out Of the Box mappings and also developed the new mappings, sessions, workflows based on the business requirements.
• Hands on experience on various transformations like Qualifier, Filter, Expression, SQ Generator, Update Strategy, Joiner, Lookups, Unions and Aggregator to develop robust mappings.
• Built the new DAC execution plans for scheduling by customizing Out of Box Subject areas or creating new Subject areas with the required tables for triggering different ETL Loads.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables, Dynamic Cache and usage of Transformations.
• Customized and administered the Physical layer, Business Model Mapping layer (BMM) and Presentation layer of the OBIEE repository.
• Implemented security settings in Oracle Administration tool to set up groups, roles, access privileges and also managing security for groups in BI Answers.
• Experienced in running the daily production loads, experienced in reconciling the issues on the spot by analyzing the bad / reject records and log files.
• Conducted presentations to the end users on the new functionality before go live.

Environment:Informatica Power center 8.1.1, Informatica Power Exchange, Informatica Quality Center (IDQ), Erwin, Informatica Metadata Manager(MDM), ODI, TOAD, PL/SQL, SAP BO, Data Stage, Flat Files, BI Publisher, OBIA 7.9.6.X, OBIEE 11g, Oracle EBS(Forms, Reports),PeopleSoft CRM, Unix Scripting, Shell Scripting, DAC, Oracle 11g, HP Quality center, PVCs (Poly version control system).

ETL& BI Developer

Responsibilities:

• Actively participated during the design discussions with the customer and prepared both the High level, Low level design HLD&LLD documents.
• Implemented few complex mappings with all kinds of transformations and customized the Out of Box mappings to match the requirements.
• Extensively used Informatica Transformations like Union, Look Up, Aggregator, Filter, Router, Joiner, Sequence Generator, Expression, Update Strategy, Stored procedure and Rank.
• Developed Error handling strategy for trapping errors in a mapping and sending to an error table
• Built the new DAC execution plans using the Out of Box Subject areas and also fixed the issues occurred, while triggering different initial ETL Loads.
• Customized and administered the Physical layer, Business Model Mapping layer and Presentation layer with OBI Apps repository.
• Extensively worked on creating the Segments, Segment Trees, Lists and Load Formats used for the Siebel Campaign Management.
• Enhanced the performance of the Reports, Segments and Segment trees by cache management.
• Created Security settings in Oracle Administration tool to set up groups, access privileges and also managing security for groups in BI Answers.
• Responsible in Managing, scheduling/triggering different DAC loads in the production box.
• Experienced in Automation of the loads using the Shell script programming (PMCMD).
• Performed the Peer to Peer code reviews for the code quality and standardization.

Environment:Informatica Power Center 8.6.1, Informatica MDM, Informatica Power Exchange, OBIA 7.9.6.X, OBIEE 10.1.3.X, Siebel 7.8 CRM, Siebel Tools, TOAD, Flat Files, Oracle, UNIX Shell Scripting, File Transfer Protocol (FTP), WebLogic, SQL, PL/SQL, SQL, DAC, Sun Solaris, HP Quality Center.

ETL& BI Developer

Responsibilities:

• Prepared the Low level Design documents for all my requirements.
• Created new Mappings, Mapplets, Transformations, Sessions, Workflows and Worklets.
• Defined Target Load Order Plan and Constraint based loading for loading data into Target.
• Scheduled and monitored the loads by using the DAC (Data Administration Console)
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Implemented Level based and Data based measures in the OBIEE repository.
• Implemented both Object and Data level security as per business requirement.
• Developed reports with different kinds of pivot, chart, compound and column selector views.
• Worked on Analytics iBots to send messages conditionally to Groups / Selective Recipients.
• Analyzed and resolved the defects logged during ST, SIT and UAT cycles.
• Conducted the KT sessions post production on new changes to support team.
• Monitoring the production jobs on a weekly basis and reconciling the issue on the spot.

Environment:Informatica 7.1.5,OBIEE 10.1.3.3, Administration Tool, Catalog Manager, Oracle 10g, Siebel Sales CRM, Siebel Tools, HP Quality Center, Windows, UNIX Shell scripting, TOAD, SQL, PL/SQL, SQL, Data Warehouse Administration Console (DAC), Flat Files, MS Visio.

ETL& Analytics Developer 

Responsibilities:

• Developed the Mappings and session as per the technical Design specifications.
• Used various Transformations like Expression, filter, Joiner, Router and Lookups for better data Propagation, migrate clean and consistent data without any redundancy.
• Created and executed the Unit test case, DB Scripts for new maps and executed the loads.
• Used the existing connection pools to import new physical tables, defined joins and designed the Physical, BMM layers of the repository.
• Developed different kinds of Reports (pivots, charts, compound layout) using global, Local Filters and assigned them to the application specific dashboards.
• Worked on setting up the Users, groups, roles, privileges and cache management.
• Handled and fixed various support issues in both Siebel Analytics and Siebel CRM.
• Promptly acknowledged to all the Service requests which are owned by me with in the SLA.

Environment:Informatica7.1, Siebel Analytics 7.8.x, Oracle 9i, Siebel Call Center 7.8.x, Siebel tools, AIX 5.1, SQL, PL/SQL, BMC Remedy tool, HP Quality Center.