SUMMARY:

• Over 8+ years of experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence, ERP Applications and teh related Database Platforms.
• Extensive experience inTableau Desktop, Tableau Server, Tableau Reader and Public. (Tableau 8.x.)
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Extensive experience on building dashboards using Tableau.
• Involved inRequirements gathering/analysis,Design, Development, TestingandProduction rollover of Reporting and Analysis projects
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Expertise in understanding and supporting teh client with project planning, project definition, requirements definition, analysis, design, testing, system documentation and user training.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports.
• Extensive TableauExperience in Enterprise Environment and TableauAdministrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Snow-Flake Modeling and Star Schema Modeling.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
• Demonstrated ability to self-motivate and be flexible within a fast-paced environment
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using OBIEE
• Experience in creating Dashboards, using answers, setting up iBots, administering presentation access, configuring Aggregates, fragmentation and cache management, Customizing, clustering using OBIEE
• Experience in developing Rapid file Database (RPD). Identify and configure measure using Time Series functions and Level Based Measures.
• Experience in converting user requirements into Data Modeling and to Intuitive Dashboards, Configuring Analytics Metadata objects (Subject Area) and customized teh look and feel of teh dashboard by modifying style sheets and other image files.
• Experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Contextual Navigation, Guided Analytics, Alerts, Security Setup (groups, access privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Configured iBots and scheduled it to warm server cache as well as to deliver reports to business users.
• Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle ApplicationsR12/11i.
• Strong understanding of business flows, underlying technical architecture and table structure of OracleE-Business suite applications.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Technically proficient inRICE components (Reports, Interfaces, Conversions, Extensions) and in OraclePL/SQLDevelopment i.e.Stored Procedures, Packages, Functions & Triggers.
• Extensive knowledge and work experience indesign and developmentof database/web applications in Client/Server environment usingOracle Developer toolsForms (6i & 9i), Reports (6i & 9i),JDeveloper 9i, Discoverer, XML/BI Publisher PL/SQL Developer, Workflow Builder and TOAD.
• Proficient in functional knowledge of Order to Cash, Procure to Pay, Drop Ship, Back to Back and Assemble to Order (ATO) processes.
• Participated in peer code review process.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Provided on-call and day-to-day support and worked as a part of team in24x7 production environment.
• Interaction with theoffshore development teamfor development of reports and changes needed in teh requirements.
• Conversant with bothoffshore and onsitedevelopment models.

TECHNICAL SKILLS:

BI Tools: Tableau, OBIEE

Oracle Applications: General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP),Cash Management (CE), Fixed Assets (FA), Project Accounting (PA), iExpenses, iPayments, Trade Management, Order Management (OM), Inventory (INV), Purchasing(PO), Bill of Materials (BOM), ASCP, Demantra, Core HR (HR)

Application Versions: Oracle 12.x, 11i, 11.0.3, 10.7

Database Versions: Oracle 11G, 10G, 9i, 8i, 8, SQL Server, My SQL, Access

Technical Skills: Oracle Developer Suite (Forms 4.5 - 10g, Reports 4.5 - 10g), Oracle Workflow, Oracle Applications Framework, SQL, PL/SQL, UNIX Script, SQL Tuning, SQL* Loader, Oracle Discoverer, Oracle BI Publisher, JDeveloper, TOAD, SQL Navigator, FNDLOAD:

Document Management: Visual Source Safe 6.0

Defect Management Tool: HP Quality Center

Data Modeling: ERwin, ER Studio, MS Visio

Industries: Telecommunications, Technology, Media and Entertainment, Manufacturing, Banking, Payroll Services and Health care

PROFESSIONAL EXPERIENCE:

Confidential, Menlo Park CA

Senior Consultant

Responsibilities:

• Worked on Performance tuning of Queries that took longer time to execute in application.
• Involved in creating dashboards by extracting data from different sources like Organizational data ware house system and Oracle.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Oracle, SQL Server
• Performed Tableau type conversion functions when connected to relational data sources.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating Complex Stored Procedures, triggers, cursors, tables and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Confidential, New York

Senior Analyst

Responsibilities:

• Involved in creating dashboards by extracting data from different sources like Excel, SQL Server.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Implemented Security feature.
• Re designed user management functionality which was taken cumbersome process to manage.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Confidential, Palo Alto, CA

Senior Analyst

Responsibilities:

• Worked on Performance tuning of Queries that took longer time to execute in application.
• Involved in creating dashboards by extracting data from different sources like Organizational data ware house system and Health Buddies.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Oracle, SQL Server
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all teh environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Involved in implementing in-memory capabilities to increase query performance.
• Re designed user management functionality which was taken cumbersome process to manage.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating Complex Stored Procedures, triggers, cursors, tables and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used ETL process to Extract, Transform and Load teh data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling and server related issues.

Confidential

Tableau Developer

Responsibilities:

• Responsible for gathering requirements, interactions with business stake holders and managing teh delivery.
• Analyzed user and business requirements attended periodic meetings for changes in teh application requirements and documents.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes..
• Used Sheet filters to produce Multiple chart types in a single view.
• Extensively used Calculated fields extensively for different logics for Trend, Extended price calculations for teh different cost types.
• Foundefficientways to make tables and graphs which were visually easy to understand and at teh same time maintaining teh accuracy of teh core information content.
• Created dashboards using Tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Created visualizations for logistics calculations and departmental spend analysis.
• Participated in teh User Acceptance Warranty Testing. Involved in doing security and negative testing of teh application.
• Performed Parallel Testing or Production Testing, which ensures that teh new system will perform correctly in a production environment and interface correctly with other production systems.

Confidential

Tableau Developer

Responsibilities:

• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Develop, Organize, manage and maintain graphs, tables and document templates for teh efficient creation of reports.
• Expert in infographics and Dashboarding for data visualization.
• Interact professionally with diverse group of professionals in teh organization including managers and executives.
• Extensively used data blending, embed functionalities in Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA’s with Tableau support.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in providing Tableau server and tableau desktop training.

Confidential

OBIEE Developer and ERP Technical Lead

Responsibilities:

• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures.
• Developed reports using different Analytics Views (Pivot Table, Chart, and View Selector).
• Managing teh dashboards by using dashboard and page level security.
• Developed Time series functions to perform trend analysis.
• Developed Mappings, transformations.
• Monitored production jobs.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Created and customized reports using drill-across and drilling-down capabilities.
• Developed Dynamic / Interactive Dashboards and pages by creating Dashboard Prompts and constrained filtering..
• Used iBots using OBIEE Delivers to send reports to users. Set up power users to use iBots.
• Unit tested and debugged dashboard reports verifying that data matches as expected.
• Involved in various stages of teh testing life cycle, QA and UAT support
• Navigating from OBIEE to custom operational reporting web pages
• Developed BI Publisher reports according to business requirements.
• Implemented Order to Cash modules: OM, Inventory, Warehouse, Purchasing, Receiving and module integrations withOM GL, AP, AR, CM,INVwith inEBSSystem.
• Involved in development of inbound interface custom package to validate and import Order details data into Oracle ApplicationsOMOrder interface tables from external system.
• Created new concurrent request set and scheduled theOrder Import interfaceprogram to run periodically.
• DevelopedSQL Loaderscripts to populate staging tables.
• Involved in theconversionofInventory (INV)Items and Item Category data from legacy to Oracle ERP.
• Worked onOpen Item Interfaceto convert Purchased Item Information from Custom Purchasing System to Oracle INV module.
• Part of teh Implementation team forOrder to Cash life cycle.
• Involved inPerformance tuningof various queries and stored procedures.
• Designed and DevelopedStored procedures,FunctionsandTriggersinPL/SQLto implement complex business rules.
• Register generatedreports, forms,Flex fields. DefinedDescriptive Flex fields,value setsand also registeredPL/SQLstored procedures,SQL*Plusscripts etc.
• Designed teh frame work which would evaluate teh details collected for customer instances and tan generate various reports.
• Worked onTuning of queriesof teh CustomReportsto improve teh performance utilizing diagnostic tools (Explain Plan, TK Prof).

Confidential, Philadelphia, PA

Responsibilities:

• Served as Technical Lead.
• Designed and developed interfaces and Forms.
• Responsible for Technical design for RICE components and MD070 and MD120 documentation;
• Design and Development of custom components (Extensions) where Oracle functionality not available.
• Oracle APS collections
• Designed APS interfaces to collect data from Oracle Inventory, Order Management & Purchasing.
• Net Change, Targeted Collections and Continuous collections.
• Oracle APS Releases to ERP
• Release of Purchase orders / Requisitions from APS to PO
• Developed New form for teh planners to check and review teh Min/Max level quantities and once review is done push teh values to Inventory to update Min/Max levels.
• Forms personalization in ASCP workbench with approved supplier information.
• Custom implementation of Horizontal plan view to display weekly bucket and monthly bucket values in PAB$.
• Involved in running Demantra EZ loads
• Developed different interfaces in DEMANTRA by getting Order history, CTO collections and planned orders to generate forecast.
• Prepare, Execute and review test plans and test cycles;
• Delivered unit and integration testing and documentation.
• Involved in Defect fixing and code deployment into test environments.

Confidential

Responsibilities:

• Served as Technical Lead
• Designed and developed forms and reports related to custom solution;
• Participating in Developing interfaces and PL/SQL development.
• Provide solutions for teh new requirements and user stories
• Participate in Agile work.
• Prepared and reviewed test plans;
• Delivered unit and integration testing and documentation;
• Provided MD070, MD120 Documentation.

Confidential

Responsibilities:

• Served as Sr Technical Consultant
• Worked for Procure to Pay Process and Order to Cash Processes and module integrations with AR, GL, AP, OM, WMS and INV with in EBS System
• Designed and developed forms and reports related to custom solution;
• Participating in Developing interfaces and PL/SQL development.
• Provide solutions for teh new requirements and user stories
• Prepared and reviewed test plans;
• Delivered unit and integration testing and documentation;
• Provided MD070, MD120 Documentation.

Confidential

Responsibilities:

• Served as Technical Consultant;
• Worked on Order to Cash life cycle implementation and integrating modules.
• Implementation and up gradation of Oracle financials Suit.(AP, GL, AR)
• Provided impact analysis to ensure that teh existing functionality and teh processes are not effected by changes.
• Developed Unix Shell scripts to Load data and email notifications;
• Written a Segment extraction program to extract teh Chart of Accounts segment values and related information. This program Written inPL/SQLand made it as concurrent program.
• Designed and developed two custom data entry forms to maintain data in custom tables. Modified existing reports.
• MigratedGLandAPcustom interfaces and reports, during oracle financials upgrade project.
• Developed Outbound GL Interfaces from Oracle R10.7 General Ledger;
• Imported Invoices usingAuto-invoiceprogram and applied receipts usingAuto-Lock Box
• Developed test cases and templates to test teh custom report migration process.
• Customizing AccountingFlex Fields, Cross Validation Rules and Security Rules Setting of profile options at various levels.
• Evaluation of organization structure, reporting needs, business needs to plan teh chart of accounts as well as defining them
• Frequently worked with defining accounting anddescriptive flex fields, writingvalidationsto custom forms.
• Developing Adhoc reports usingDiscovererto analyze data and compare with General Ledger.
• Helping financial service people to understand and reconcile data between custom module and Oracle financials. Also designing and developing custom procedures andReports(Pl/SQL, Reports 6.0).
• Writing scripts to automate reports to run in batch for given time period.

Confidential

Responsibilities:

• Served as Technical Consultant
• Gathered Business Requirements, identified pain points provided impact analysis for 11i upgrade for existing R11.0.3 application;
• Provided upgrade of teh existing Finance custom objects from teh version 11.0.3 to R11i;
• Teh migration activity includes teh forms, reports, SQL scripts and host scripts movement;
• Developed Outbound GL Interfaces from Oracle R11i General Ledger;
• Developed Unix Shell scripts to Load teh Financial Statement Generator (FSG) table data for FSG Reporting from one instance to another;
• Re-designed teh ftp process to meet Sarbanes Oxley (SOX) Compliance;
• Customized teh Costs of Goods Sold (COGS) work flow for Intercompany AP Invoice accounting;
• Tailored ERP to redefine policies and procedures through workarounds;
• Reconfigured and customized Oracle Financials to suit teh requirements;
• Reported on teh status of issues and action plans to Project Managers;
• Ensured quality deliverables on time;
• Played key role in Design, Development and Testing of Inbound and Outbound Interfaces;
• Provided impact analysis to ensure teh change of existing functionality and processes are not effected by changes;
• Prepared and reviewed test plans;
• Delivered unit and integration testing and prepared MD060, MD070 and PM020;

Confidential

Responsibilities:

• Served as Technical Developer
• Learned and used AQL and Ariba related processes for teh enterprise spend management capability for Dell’s global non-production spend.
• Generating teh PL/SQL Procedures and functions needed and Related Database work.
• Learned BRIO reports in short span of time and uploaded BRIO reports into new environment server.