Technical Summary:

• 11 years of IT experience on analysis, design, development, customization and maintenance of various business applications in an effective way to deliver business solution.
• Expertise in OBIEE 11G/10G, BI Publisher, Informatica 8.x/9.x, Autosys and DAC.
• Worked with big clients like Bank of America, Sun Trust Bank, British Telecom with respective domains like Banking, Telecom, Mortgage and Health care
• Good knowledge on Data Warehousing concepts like star and Snowflake Schema Methodologies along with the Strong Banking domain skills and experienced IT project lifecycle in a banking environment as the OBIEE Report Developer and ETL Developer.
• Responsibility includes involvement in gathering business requirements, analysis, design, data modeling, development, which include in designing ETL Process, building and configuring repository.
• Complete Life Cycle Gathering Business Requirements, GAPS Analysis, identifying analyzing the source/feeder systems, Design Data Modeling, Development, and Testing implementation experience of Enterprise Business Intelligence EBI using Oracle BI.
• Expertise in Building Metadata Repositories .rpd Building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool.
• Good Knowledge on OBIEE installation, configuration and good understanding of OBIEE Architecture and Development Process.
• Configured and Scheduled Agents iBots alerts
• Expertise with developing dynamic and interactive Dashboards with drill-down drill-across capabilities, and Web Catalog using Oracle Business Intelligence Tool.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series Caching.
• Experience in Configuring Multi User Environment on Shared environment to allow Development team to work as well as Merge 2-Way and 3-Way Merging.
• Experience in Setting up Dynamic, System and Non-System Variables.
• Worked with BI Publisher to report real time data to the users.
• Implemented Data Level and Object Level Security using External Table Authentication, as well as Presentation Services.
• Interacted with Business Analyst to understand the business requirements and also designed the ETL Mapping specifications for ETL Mappings of Data warehouse.
• Experience with Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager.
• Designed many Multi Source Single Target mappings and vice versa.
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Informatica Designer tool.
• Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, java and Expression Transformations.
• Effectively developed and tested the type1, type2 Slowly Changing Dimensions mappings.
• Experienced with designing ETL execution plan and scheduling task using DAC.
• Experienced with automation of ETL workflows with Autosys command line tools and GUI iXP tools and experienced FTP protocols in UNIX environment.
• Improved the advanced concepts of concurrent running of the workflow, session level partitioning techniques and pushdown optimization in ETL mappings.
• Performed the Performance tuning to the ETL code at the Database, Mapping, Session and workflow levels.
• Designed ETL strategy for various applications in the banking line of business.
• Performed coordination with the offshore team for all OBIEE and ETL Informatica deliverables with daily status calls and follow up on gap items on daily basis.
• Good at prioritizing along critical path, meeting project milestones and deliverable dates.
• Active participation in Presentation of Project concept, status, plans and progress
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.

Technical Skills:

Professional Experience:

TATA Consultancy Services

working as a Assistant Consultant this involves managing onsite/offshore teams , Also, performed roles to increase productivity, improve business revenue, onsite offshore co-ordination, problem management, deployments, etc.

Confidential

worked as a Senior System Engineer and performed different roles as Developer, Designer, Coding, and Testing.

Confidential

worked as a Software Consultant by performing roles in Developing Testing.

Confidential

worked as a Database Programmer by performing roles in Developing.

Confidential

Roles Responsibilities:

• Participated in the OBIEE Admin activities like giving access for the users in Productions, and solving the high priority production issues, and end to end implementations which consists of gathering requirements from multiple user groups, analyzing Business Requirements Documents BRD's , preparing high level and low level design documents, Development, Support.
• Monitor the existing prod system with various scheduling tools and solve the issues on daily, weekly and monthly scheduled ETL jobs if any.
• DAC changes implementation based on the business requirements.
• Participated in Business Requirement Documents review, HLD, LLD and Data Model reviews to understand the requirements and to prepare the necessary design documents accurate.
• Participated in GAP analysis, Impact Analysis.
• Expert in presenting the designs to business and in getting signoff's with some report mockups without actual developing the reports .
• Expert in designing and developing Rpd repository using OBIEE Admin tool. Developing all the three layers Physical, Business Model and Mapping, Presentation with oracle's best practices.
• Developing Reports/Dashboards using OBIEE front end OBIEE Presentation Services . Created Reports using different views like table, pivot, narrative, filter, compound etc.. based on the requirement.
• Developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations, Answer queries, and BI Publisher reports. Formatting Reports/Dashboards with attractive colors, wordings, font as per client's requirement.
• Developing highly formatted reports using BI Publisher, Developing multiple rtf templates, Used Answer Queries as source, Implemented stitching technology in the template to meet client's requirement.
• Supporting Infrastructure team in merging multiple projects from multiple development teams into one development rpd and deploying it into server. Preparing SIT, UAT, Production deployment checklists, testing the environments after each and every deployment.
• Tracking Production Issues, SIT Defects, UAT Defects in Quality Center and Fixing, deploying the changes in all the environments them with very less time.
• Participated in Release Management work which consists of raising TFS, Maximo tickets for code deployments in to different environments SIT, UAT, and Production .
• Documenting all the changes and maintaining them in SharePoint sites which help future enhancements.
• Performing Unit testing, providing test cases for the QA team TCOE .
• Reviewed ETL code done by the development team.
• Experienced with automation of ETL workflows with Autosys command line tools and GUI iXP tools and experienced FTP protocols in UNIX environment.
• Improved the advanced concepts of concurrent running of the workflow, session level partitioning techniques and pushdown optimization in ETL mappings.
• Performed the Performance tuning to the ETL code at the Database, Mapping, Session and workflow levels.
• Performed coordination with the onsite team for all OBIEE and ETL Informatica deliverables with daily status calls and follow up on gap items on daily basis.

Title : Global HR Analytics

Confidential

Roles Responsibilities:

• Participated in multiple end to end implementations which consists of gathering requirements from multiple user groups, analyzing Business Requirements Documents BRD's , preparing high level and low level design documents, Development, Support.
• Participated in Business Requirement Documents review, HLD, LLD and Data Model Reviews to understand the requirements and to prepare the necessary design documents accurate.
• Participated in GAP analysis, Impact Analysis.
• Expert in presenting the designs to business and in getting signoff's with some report mockups without actual developing the reports .
• Expert in designing and developing Rpd repository using OBIEE Admin tool. Developing all the three layers Physical, Business Model and Mapping, Presentation with oracle's best practices.
• Developing Reports/Dashboards using OBIEE front end OBIEE Presentation Services . Created Reports using different views like table, pivot, narrative, filter, compound etc based on the requirement.
• Developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations, Answer queries, and BI Publisher reports. Formatting Reports/Dashboards with attractive colors, wordings, font as per client's requirement.
• Developing highly formatted reports using BI Publisher, Developing multiple rtf templates, Used Answer Queries as source, Implemented stitching technology in the template to meet client's requirement.
• Supporting Infrastructure team in merging multiple projects from multiple development teams into one development rpd and deploying it into server. Preparing SIT, UAT, Production deployment checklists, testing the environments after each and every deployment.
• Implementing MUD Multi User Development environment across the whole organization which helps in smooth, easy, fast rpd development.
• Tracking Production Issues, SIT Defects, UAT Defects in Quality Center and Fixing, deploying the changes in all the environments them with very less time.
• Participated in Release Management work which consists of raising TFS, Maximo tickets for code deployments in to different environments SIT, UAT, and Production .
• Documenting all the changes and maintaining them in SharePoint sites which help future enhancements.
• Performing Unit testing, providing test cases for the QA team TCOE .
• Implemented the advanced concepts of concurrent running of the workflow, session level partitioning techniques and pushdown optimization.
• Performed the Performance tuning to the ETL code at the Database, Mapping, Session and workflow levels.
• Supported the ETL code when it deployed in QA and also at the initial days of the PROD deployment as well.
• Worked towards the knowledge transfer with prod support team for smooth transition.

Confidential

Roles Responsibilities:

• Work closely with the Onsite coordinator to understand the requirements and drive the development team for successful implementation maintaining the deadline
• Actively take part in the Development process by creating various complex reports in Answers and placing them in Dashboard
• Customize the look and feel of OBI Dashboard and Answers by creating customized Styles.
• Reviewed the business requirements and translated them to technical design specifications like HLD and LLD
• Developed meta data repository in physical layer, business model and mapping layer and presentation layer of OBI administration tool
• Creating the Reports using multiple Views and Formats
• Gathering requirements, Analysis, functional and technical specifications, interacting with Business Managers and End users.
• Configured and Creating the NQS Config.INI file sections
• Worked and Configured with a Pivot Table, Narrative View, Charts.
• Creating an Interactive Dashboards and Dashboard Prompts using Presentation Variables.
• Involved in Creating Delivers and configuring scheduler tables and scheduler.
• Worked in Administration Tab. Creating users, groups, assign privileges
• Creating the Business Models, Logical Columns, Logical Joins, and Creating Dimensional Hierarchies.
• Involved in Initialization Blocks and Variables Session, Dynamic Repository .
• Worked on Column Selectors and View Selectors.
• Involved in unit testing developing the design documents.

Title : F I A Fraud Image Analysis

Roles Responsibilities:

• Developing custom dashboards and reports using OBI Answers. Created Prompts, Filters and charts, pivot tables and views as per client requirement.
• Creating Dashboards, Charts, and Tables using OBI Answers.
• Filters/Column selectors
• Giving security permission / privileges as per the role of each user
• Developing business reports using OBI Answers and to display the reports in Dashboards
• Organizing the presentation layer in a format that is easy for end user to use as basis for reporting.
• Creation of reports in OBI
• Imported physical tables, Connection pool and defined joins and implemented in the physical layer of the repository.
• Worked on business model layer to include numerous calculated fields using expression builder.
• Created logical joins between fact and dimension tables in business model layer.
• Organizing the presentation layer in a format that is easy for end user to use as basis for reporting.
• Implemented Object level security
• Worked on OBI Admin Tool of Layers like Physical, BMM, and Presentation.
• Modifying the dimension hierarchies and measures for Drill downs.
• Worked on Analytics Web like Answers, Dashboards and Views.
• Development of all layers of OBI Physical, Business Model, Presentation layer.
• Creating value based Fragmentation on Dimension Tables.
• Creating and Configuring OBI Security and creating User's Groups and setting Privileges.
• Defining Dimension Hierarchies for the Dimension Logical Table
• Designed customized OBI answers views and charts, create and save filters, create charts and tables in OBIEE answers.
• Developing custom dashboards and reports using OBI Answers.
• Involved in unit testing developing the design documents

Confidential

Roles Responsibilities:

• Using the Siebel Analytics Administration tool to import data and enhance meta-data to Build Business model
• Build Repository at 3 layers Physical Layer connecting Data sources importing schema , Business Model data mapping created Logical tables data source mapping Presentation layer level created presentation catalogs , created presentation folders tested.
• Creating and managing Repository Groups, Initialization Blocks and User Administration using Siebel Analytics Administration Tool and Security Manager.
• Reconfigured the Analytics server metadata .rpd using the Admin tool to develop a reporting environment according to user requirements.
• Involved in the Creation of Dimensions in Business Model and Mapping Layer.
• Created Hierarchy level for dimensions to make drill-down on reports.
• Manual Testing/Database Testing.
• Developed custom dashboards and reports using Siebel Answers.

Confidential

Roles Responsibilities:

• Data Migration using SQL Loader and UTL FILE.
• UNIX Shell Scripting for analysis module and operation module to alert manager for pending Calls.
• Writing Stored Procedures and Triggers for operation Module.
• Implementing the projects as per the application requirements
• Team Coordination
• Performing the system coding, testing and debugging

Confidential

Roles Responsibilities:

• Involved in the writing stored procedures and triggers
• Involved in the Data Migration using SQL Loader, UTL FILE package for data loading.
• Performing the system coding, testing and debugging
• Team Coordination

Confidential

Roles Responsibilities:

• Writing Stored Procedures, Functions and Triggers.
• Data Migration using SQL Loader, UTL FILE package for loading data.
• Implementing the projects as per the application requirements.
• Team Coordination.
• Performing the system coding, testing and debugging.

Confidential

Roles Responsibilities:

• Writing Stored Procedures, Functions and Triggers.
• Data Migration using SQL Loader, UTL FILE package for loading data into Oracle.
• Implementing the projects as per the application requirements.
• Team Coordination.
• Performing the system coding, testing and debugging.

Title : HRMS

Confidential

Roles Responsibilities:

• Writing Stored Procedures, Functions and Triggers.
• Data Migration using SQL Loader, UTL FILE package for loading data into Oracle.