PROFESSIONAL SUMMARY:

• Having 10 plus years of experience in IT industry in the Analysis, Design, Development, Testing and implementation of Enterprise Wide Business Intelligence Applications.
• Having exposure of working at client locations in US, Germany and Prague.
• Specialized in Business Intelligence solutions Informatica, Talend, PL/SQL, Oracle Data warehouse console (DAC) and Oracle Business Intelligence Enterprise Edition (OBIEE 11g)
• Hands on Experience in Oracle Applications E - Business Suite R12
• Oracle Certified Professional (Developer)
• Specialized in design and development of OBIEE repository, dashboards, reports, guided navigations.
• Expertise in creating Hierarchies with drill-down capabilities using global local Filters, creating static, dynamic and session variables, configuration of Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, reports).
• Excellent Data Analysis, Data modeling Skills and ability to translate Business logic into mappings using complex Transformation logics for ETL processes.
• Worked on Informatica tools Source Analyzer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Creating the custom Execution Plans at Data Warehouse Administration Console for the custom mappings.
• Experience in using Data Warehouse Administration Console (DAC) for scheduling and executing Full and Incremental ETL loads.
• Provided production support and enhancement requests for users.
• Efficient in performance tuning of sources, mappings and optimization of ETL
• Major responsibility is to correctly analyze and debug the issues reported within the stipulated time frame and provide a good reporting solution, by setting up an effective data warehouse.
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the Session logs.
• Monitoring the daily DAC loads and fixed the failed jobs in Data warehouse Administration Console.

TECHNICAL PROFICIENCY:

ETL: Informatica Power Center 9.5.1, Talend, SQL *Loader

Reporting Tool: OBIEE 11g

Visualization Tool: Endeca

Operating Systems: Windows Family, UNIX, Linux

Languages: SQL, PL/SQL

Databases: ORACLE 10g/11g

Scheduling Tools: DAC

DBMS Tools: Toad

PROFESSIONAL EXPERIENCE:

Confidential, North Canton, Ohio

Informatica, PL/SQL Developer

Responsibilities:

• Understand the Project requirements by attending business meetings.
• Create Informatica mappings by applying different transformations and creating PL/SQL stored procedures and functions where required.
• Resolve the issues raised in UAT.
• Production migration and support.

Environment: Oracle Exadata, Informatica 9.5.1, PL/SQL, Oracle 11g, DAC 11g, Tidal scheduler

Confidential, North Canton, Ohio

Informatica, PL/SQL Developer

Responsibilities:

• Requirement gathering and design of the report to be built.
• Getting complete functional knowledge on SM and PPM tools
• Developing new custom mappings in order to in corporate SM & PPM tools data in BI
• Developing new PL/SQL procedures functions
• Designing complete RPD structure in Physical layer, BMM layer and presentation layer
• Designing complex reports to fulfill the business requirements
• Developed a new Execution plan in DAC to scheduled jobs for daily refreshment of data.
• Enabled security in such a way that dashboards will be available for higher level management only.

Environment: Oracle Exadata, Informatica 9.5.1, PL/SQL, Oracle 11g, DAC 11g, OBIEE 11g, Tidal scheduler.

Confidential, North Canton Ohio

Informatica Developer

Responsibilities:

• Requirement gathering and design of the report to be built.
• Worked on Account Receivables(AR) module as Informatica developer
• Developed different tables using Informatica to capture Closed AR invoices, Open AR invoices and Open AR aging snapshot models
• Performance tuning of the tables as tableau can’t handle large sets of data
• Modified the existing tableau reports to fit for Confidential data
• Worked on publishing tableau workbook (twbx) to tableau server.
• Effectively implemented User level security in tableau server
• Created DAC execution plan to run tasks related to AP, AR & Inventory modules.
• Enabled subscriptions for different users in tableau server to receive dashboard on weekly basis
• Scheduled Twbx refresh in tableau server to fetch incremental data

Environment: Oracle Exadata, Informatica 9.5.1, Oracle 11g, DAC 11g, Tidal scheduler.

Confidential, North Canton, Ohio

Informatica Developer, PL/SQL Developer

Responsibilities:

• Requirement gathering and design of the report to be built.
• Worked in different modules like Service, Finance and Projects as OBIEE, Informatica and PL/SQL developer.
• Creating new reports or modifying the existing ones in OBIEE based on the requirement
• Implemented enhancement requests to OOTB mappings without effecting the existing logic and granularity.
• Created new dimension and fact table for based on report requirement.
• Involved in designing Data Modeling i.e. Facts/Dimension in Star Schemas, Snow Flake schemas
• Preparing technical design documents.
• Designed and developed transformation rules (business rules) to generate consolidated (fact and summary) data using Informatica.
• Used transformations such as the Source qualifier, Aggregators, Expression, lookup, Filter & Sequence generator.
• Developed PL/SQL stored procedures and functions.
• Provided support and quality validation through test cases for all stages Unit and Integration testing.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well
• Experienced in working with load Plans and scenarios.
• Participated in all phases of project development, testing, deployment and support.
• Execute test cases with multiple data sets to attain exact test results and capture faulty construction.

Environment: Oracle Exadata, Informatica 9.5.1, PL/SQL, Oracle 11g, DAC 11g, OBIEE 11g, Tidal scheduler.

Confidential

Informatica Developer, PL/SQL Developer

Responsibilities:

• Support the call management and contract management systems in BI Data warehouse.
• Solving the incidents raised by business users without breaching SLA’s.
• Enhancing the existing models or add new models as per business requirements
• Performance tuning of Informatica mappings

Environment: Oracle Exadata, Informatica 9.1, PL/SQL, DB2, Oracle 11g, DAC 10g, OBIEE 10g, Tidal scheduler.

Confidential

Informatica, PL/SQL Developer

Responsibilities:

• Responsible for interacting and collecting the requirements from Client
• Responsible for understanding the requirements and posing queries in case of any discrepancy
• Responsible for adding several new coverages to the workers compensation
• Adding a new coverage includes writing queries, development of Informatica mappings,PL/SQL procedures, to calculate the premium amount of a policy when a respective coverage is selected in that policy and mapping the data into the Coverage and IPD tables
• Configuring the UI changes
• Involved in interactions with client and Unit Testing
• Involved in code reviews and Documentation

Environment: Oracle, Informatica 8.6, PL/SQL

Confidential

Informatica, PL/SQL Developer

Responsibilities:

• Responsible for interacting and collecting the requirements from Client
• Responsible for understanding the requirements and posing queries in case of any discrepancy
• Development of PL/SQl packages,procedures and functions to load the IPD data
• Involved in interactions with client and Unit Testing
• Involved in code reviews and Documentation

Environment: Oracle, Informatica 8.6, PL/SQL

Confidentia

Technical Consultant

Responsibilities:

• Responsible for design of the archiving system
• Responsible for cleaning and identification of invalid data
• Development of PL/SQL comp onents to Archive the data of costing system into suitable data structures.
• Extending technical support and troubleshooting problems related to custom forms, concurrent programs and reports
• Involved in interactions with client and Unit Testing
• Involved in code reviews and Documentation

Environment: Oracle 9i, PL/SQL

Confidential

Technical Consultant

Responsibilities:

• Involved in the discussions with the clients, to know the basic requirements of the system
• Responsible for development of PL/SQL package to calculate the incentive payout factor
• Development of form interfaces using oracle forms 6i to enter the productivity, quality and safety inputs
• Development of reports to display the Incentive payout factor, productivity score, quality score and safety score of all the departments
• Involved in interactions with client and Unit Testing
• Involved in code reviews and Documentation
• Deployment and migration of the development
• Providing end user support

Environment: Oracle 9i,SQL, PL/SQL, FORMS 6i, REPORTS 6i

Confidential

Technical Consultant

Responsibilities:

• Development of PL/SQL packages to validate and load the data into staging tables
• Development of programs to load the data from staging into oracle applications interface tables
• Reports to display error logs along with the reason for errors
• Development of forms to enable correction of invalid data
• Unit testing and debugging the code
• Deployment and migration of the development

Environment: Oracle 9i,SQL, PL/SQL, FORMS 6i, REPORTS 6i

Confidential

Technical Consultant

Responsibilities:

• Extending technical support and troubleshooting problems related to 11.5.10 custom forms, concurrent Programs, PL/SQL stored procedures and packages
• Development of Interfaces and Stored Procedures
• Data extraction
• Tuning for performance
• Handling issues related to data integrity
• Testing and debugging the code

Environment: Oracle 9i,SQL, PL/SQL, FORMS 6i, REPORTS 6i

Confidential

Technical Support

Responsibilities:

• Assisting both end user clients and dealerships nationally providing pre and post sales customer service through telephone support, email, internet and training (on client site)
• Contribution to pre-sales meetings with prospective clients, assist with product testing and development and other administrative tasks as required
• 100% of committed training volumes trained in Confidential product curriculum
• Achieving the monthly and quarterly goals, certification and yield rates, new product training of revenue and conversion.