SUMMARY

• Experienced Management Professional with over 12 years of experience in various fields like people management, software development, customer satisfaction, customer relations, client management and execution and implementation of software projects. Specialized in project management, implementation and experienced in complete project cycle from analysis, architecture and design, through development and deployment.
• Over 6 years asOracle BI/ERP Developer/ConsultantinOracle E - Business Suite Applicationswith expertise inGeneral ledgerGL,Account PayablesAP,Account ReceivablesAR,Fixed AssetsFA,Order ManagementOM,Iprocurement and Purchasing PO, Inventory INV and Payroll.
• OverSix yearsof experience asBI/ETL Technical Consultant.
• Extensively worked on Installation and configuration of Financials Analytics, Supply chain and Order Management Analytics, HR Analytics, and Procurement and Spend Analytics.
• Experience in using Data Warehouse Administration Console (DAC) to schedule the Informatica jobs and metadata management and well versed with OBIA 7.9.6.1.
• Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL * Plus, Data Loader and TOAD.
• Experienced in Complete Software Development Life Cycle (SDLC) which includes Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
• Knowledge about Hyperion Essbase, Smartview, XML/BI Publisher.
• Strong Conceptual, Business, Analytical skills & highly motivated team player and ability to provide work estimates and meet deadlines.

TECHNICAL SKILLS

Oracle Applications: Oracle Financials E-Business suite R12/11i (Order Management, Inventory, Purchasing, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, AOL, System Administrator).

Developer Tools: OBIEE 11.1.17/6/5/1 , 10.1.3.x, SAP Business Object, Tableau, SSIS, Oracle Reports 10g/6i/4i, Oracle BI Apps 7.9.x Oracle APEX, Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i, XML Publisher 5.6.3/5.6.2 , TOAD 9.7.3/8.x, SQL*PLUS, Data Loader, SQL*Loader, SQL Developer.

ETL Tool: Informatica Power Center 9.0.1,8.6.1,8.1.1, SAP Data Services, Wherescape /ODI,DAC 10.1.3.4.1

Operating Systems: Windows NT/XP/2000/98, UNIX, Linux

Languages: SQL, PL/SQL, T-SQL, C, C++, C#, HTML, XML

RDBMS: OLAP, OLTP, Oracle 10g/9i/8i, MS Access, SQL Server 2005/2008R2, SSIS, SSRS, SSAS

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Senior BI Developer

Responsibilities:

• Design, Develop and Implement Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management (RPD), Extraction Transformation and Load (ETL).
• Work and manage offshore team and pass on the business requirements and technical specifications to develop and design the operational reports.
• Work on converting reports from other Business reporting tools and legacy systems to migrate in OBIEE Analytics.
• Work on SAP Business Object and Integrations Services, and migrate reports to OBIEE.
• Import Noetix query metadata structure in OBIEE RPD, and convert existing reports and dashboards from business objects in OBIEE Analytics.
• Conduct user training on using OBIEE and Tableau reporting tools and its best practices.
• Responsible for Business Analysis and Requirements Collection and involved in Designing and creating Technical Specifications
• Analyze existing SAP Business Objects reports, document technical specifications, document user acceptance criteria, and assist user with acceptance testing.
• Gather requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Design, developed, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modeling, and Repository Management.
• Configuring Interactive reports with drill-drown capabilities using global and local filters, OBIEE Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Create financial reports and dashboards like Balance Sheet, Trial Balance, SLA Transactions, P&L Analysis, AP and AR invoice aging and so on.
• Create Order Management, Billing, Service contracts and Shipping modules data marts and reports.
• Create custom reports and dashboard for executive managers.
• Write T-SQl queries using CTE and store procedures to connect and publish reports using Power BI queries.
• Created Power BI Queries using SQL Server to connect and Configure the changes and source to prompt the values for big data extract reports.
• Working with business users to have them test and validate reports during development phase, UAT, Mock C, Cutover and Production migration.
• Manage the client relationship, address client requirements, meet the projects specifications and deadlines, and ensure client satisfaction
• Direct the project team through the full system development lifecycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation, and support& assigning work.
• Conduct reviews of team projects on a routine basis, sought information about completion obstacles, and aligned teams as necessary or managed customer expectations as necessary
• Promote reports from Dev to Stage and from Stage to UAT environments and involve in support plan for release and go live dates.
• Possess strong technical/functional skills, including SQL and PL/SQL.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Work on creating tableau reports along with OBIEE and Power BI queries for certain set of users using TDS files.
• Identify problematic areas and conduct research to determine the best course of action to correct the data and ongoing issues.
• Work and implementing the financial/accounting principle modules to support day to day retail activity for the project.
• Write Complex T-SQL Queries to give data dump to users, used CTE statements or created views to reuse complex calculation in SQL queries.
• Designing/Developing Reports, Dashboard, Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Working on Oracle Business Intelligence Enterprise Edition (OBIEE) 11g application tools and Oracle ERP development concepts.

Confidential, Seattle, WA

Lead OBIEE Developer (Oracle Business Intelligence)

Responsibilities:

• Working with Business Groups to identify, analyze, and document Business Requirements.
• Gather requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Designing, Developing and Implementing Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management (RPD), Extraction Transformation and Load (ETL).
• Involved in upgrading Oracle 11i to R12.
• Managing critical business changes whenever necessary in short notices.
• Working closely with business to identify potential improvement plan for the company.
• Conduct user training on using OBIEE and Tableau reporting tools and its best practices.
• Working with business users to have them test and validate reports during development phase, UAT, Mock C, Cutover and Production migration.
• Designed and Developed Data model for core Financial Analytics module.
• Configured Financials, Order Management and Procurement & Spend Analytics.
• Customized Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger.
• Customized Dashboard pages like AR Balance, Payments Due, Invoice Details and AR Transactions in Receivables.
• Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Convert the FSG reports in OBIEE and all the management deck reports using custom groupings.
• Create Balances and Sub-ledger details dashboard reports to help during close and reconciling.
• Design and develop AP Invoice listing, AR aging & bucketing along with FA depreciation and mass additions reports and dashboards.
• Recreate FSG and Oracle Seeded reports in OBIEE 11g and test the data against Oracle 11i and R12 reports for comparison during upgrade process.
• Created many Reports / Dashboards using various Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector) with global and local Filters using OBIEE.
• Created Star Schema and Custom Subject Area in OBIEE RPD for Financial Analytics module.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Developed the semantic layer, metadata, reports, and report definitions.
• Analyzed and write new T-SQL queries to improve performance and designed complex drill down matrix and tabular reports
• Did reverse engineering for the data sources and targets.
• Used existing data fromHyperion Essbasefor analysis for budgeting and forecasting.
• Worked on existing hyperion reports to mirror in OBIEE
• Worked on remediation and regression testing of Informatica code, HR OBIEE and Hyperion IR reports.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Manage the client relationship, address client requirements, meet the projects specifications and deadlines, and ensure client satisfaction
• Direct the project team through the full system development lifecycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation, and support& assigning work.
• Worked in SCRUM and agile environments to meet project specific deadlines.
• Configured Interactive Dashboards with drill-drown capabilities using global and local filters, OBIEE Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)

Confidential, Seattle, WA

Senior OBIEE Developer (Oracle Business Intelligence)

Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Designed and Developed BI specifications for core Retail Sales/Inventory Management module and working with business users/groups to identify, analyze, and document business requirements.
• Working on Oracle Analytical Workspace Manager (AWM) OLAP Cubes/Microsoft SSAS cubes to import in OBIEE and Design the rpd based on business user’s requirements.
• Worked on Exalytics suite and OBIEE in general. Developed tools including gdb scripts and code instrumentation to aid in diagnosing stress related issues in the OBIEE server suite to debug numerous crashes, memory leaks and memory corruption bugs.
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Developed the semantic layer, metadata, reports, and report definitions.
• Configured MS SQL Server 2008 R2 Reporting Services including: Report Server, Report Manager and integrated with SharePoint.
• Analyzed and write new T-SQL queries to improve performance and designed complex drill down matrix and tabular reports.
• Formulated SQL queries, functions and processes as per customization requirement for APEX
• Contributed with database designs and assisted in increasing response time for APEX reports.
• Designed application framework and developed Oracle APEX Application.
• Provided APEX guidance and support to technical staff on application maintenance and SDLC process.
• Created Star Schema and Custom Subject Area in OBIEE RPD for Analytic Center - Global Retail Sales Summary and Transaction Detail project for (Asia, Europe and North America regions)
• Configured Interactive reports with drill-drown capabilities using global and local filters, OBIEE Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Working on complex reports, Union reports and creating & executing report requirement from multiple subject areas.
• Working on creating dashboards and enhancing existing one as well.
• Possess strong technical skills, including SQL and PL/SQL.
• Worked with Admin team in connecting ETL to Exadata and Exalytics.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Working and implementing the financial/accounting principle modules to support day to day retail activity for the project.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Designing/Developing Reports, Dashboard, Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Implemented Financial, Procurement, Supply Chain Management, Demand, CRM, Retail and Spend Analytics.
• Worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots)
• Working with Confidential Business users to help and understand and resolve ETL failures issues.
• Conduct remedial End-user/Administrator training as required by Confidential BI support staff

Confidential, Philadelphia, PA

OBIEE Developer

Responsibilities:

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Designed and Developed Custom Mappings, Workflows Online Billing and Invoice for and Registered in DAC.
• Worked with TW Business users to resolve EBS data/configuration issues that may be contributing to HR/Finance ETL failures
• Created Star Schema and Custom Subject Area in OBIEE RPD for Online Billing and Invoice.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Formulated SQL queries, functions and processes as per customization requirement for APEX
• Contributed with database designs and assisted in increasing response time for APEX reports.
• Designed application framework and developed Oracle APEX Application.
• Provided APEX guidance and support to technical staff on application maintenance and SDLC process.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE.
• Created Dimension hierarchies to achieve the drill down functionality.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Worked on (DAC) to schedule the Informatica jobs and metadata management and well versed with OBIA 7.9.6.1.
• Designed and Developed Data model for core Online Billing and Invoice module.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.

Confidential, Warrenville, IL

OBIEE Developer

Responsibilities:

• Worked with NEC Business users to resolve EBS data/configuration issues that may be contributing to HR/Finance ETL failures
• Worked with HR Key Business User to identify and resolve any issues unrelated to ETL process failures - data integrity or missing data
• Identifying root cause for Inventory Product Dimension and Product Catalog/Category ETL failures and work with NEC on correction actions
• Worked with HR Business Key User to determine if OBIEE enhancements are required
• Document as necessary for presentation to NEC IT management.
• Support Vizaya integration to OBIEE, on an as-needed basis. Work closely with Vizaya team for implementation and scheduling of execution plans (HR/Financials, Vizaya, COMPASS)
• Identified poor performing ETL extract/load sessions and tune accordingly (focus on longer-running extract/load tasks)
• Re-examine BI technical landscape (especially as relates to data volumes) and create a recommendation document for NEC IT management consideration
• Conduct remedial End-user/Administrator training as required by NEC BI support staff
• Educate NEC BI support staff on BI upgrade steps and considerations, with a focus on preservation on custom objects.
• Start/stop DAC services with access and the directory structure on the DAC server to monitor Unix level process and access logs
• Scheduling and monitoring of Execution Plans (HR/Financials, Vizaya, COMPASS)
• Timely identification of failures and creation of help desk ticket(s) and notification to end-users of issue(s)
• Used Oracle APEX 4.0 for designing application structure.
• Formulated oracle process, data retrieval methods and SQL code blocks
• Worked on (DAC) to schedule the Informatica jobs and metadata management and well versed with OBIA 7.9.5 and upgrade to 7.9.6.1.
• Trace DAC plan/task failures into Informatica session logs
• Access/maintain all source/target databases for issue such as tablespace updates, index creation, data reconciliation processes.
• Making Sure all the data migrated to OBIEE is correct and validated for (HR/Finance)

Confidential

Senior Analyst/Assistant Lead

Responsibilities:

• Worked in Health & Welfare Insurance Process (NAS) part of global delivery team.
• Dealing with clients and carriers to verify and fix information about employers and their employees. Day-to-Day basis handle issues related to those groups, as it’s large in number. Every month audit a percentage of each and every client and resolve issues, if any with Business Units.
• Handling to few Projects which deals with updating Web Database, Performing Audits and Special Audits of each and every client and also to check the percentage of audits need to be performed in a month for every client and insurance plans that need to be audited. Responsible for updating client’s information and generating roster that need to be audited every month for each client.
• Generating and Preparing client status report and would send them on daily basis to client, carriers and higher management, Handling Escalations on day to day basis for every project.
• Take huddles, giving presentations for team, updating process queries, resolving any issues for the team, coordinating with Business Units, driving project in a timely & efficient way, helping & coaching the new joiners and handling team in the Team Lead’s absence
• Worked closely with the Assistant Managers to stream line audits that are to be performed and also to generate the clients that are to be audited.
• Has been rewarded with Quality of Honor for my exceptional performance, team handling abilities, streamlining process on its Audits, Database Issues and Quality. And also couple of recognitions from Business Units and Management.