SUMMARY

• Seven Years of IT experience in Business Intelligence area in providing comprehensive business reports with detailed analysis for executive review.
• Proven track record in planning, building analytics, and managing successful large - scale Data Warehouse and decision support systems.
• Comfortable in both technical and functional applications of RDBMS, Data Warehouse - Data Mapping, Data management, Data transportation, Data Staging.
• Proficient in all phases of the Software development lifecycle, including requirements Definition, Analysis, Design, System Implementation, Testing and Support.
• Job roles include gathering business requirements, establishing functional specifications, translating them to analytic specifications.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using Informatica Power Center Designer.
• Strong understanding of data warehousing - Star/Snowflake schema.
• Experience in dealing with a software development process from requirements through implementation.
• Experience in analyzing data sourcing from Oracle, Salesforce.com (SFDC), SQL Server, and Flat files from Multi-Dimensional Data Modeling -Star, Snow Flake schema.
• Possess wide range of IT industry experience with strong analytical, problem-solving, organizational, communication, learning and team skills.
• Experienced with coordinating cross-functional teams.
• Experience in creating Dashboards with BI Answers reports with different Analytics views using OBIEE.
• Experience in building Tableau Reports and Dashboards using Tableau Desktop and Analytics with wide expertise in Visualization techniques.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica Power Center, Metadata, Data Mart, FACT & Dimensions tables, Physical & Logical data modeling, Dimensional Modeling.

Databases: Oracle, MS SQL Server, Teradata.

Programming: SQL, PL/SQL, SQL*Plus SQL*Loader, Unix, Shell Scripting, SQL Tuning/Optimization.

Tools: Tableau Desktop, OBIEE, TOAD, Control-M, HP-QC, Excel, Word, MS-Project.

Environment: Windows, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

BI Business Analyst

Responsibilities:

• Translated business requirements into functional design solutions, support development, testing and release activities.
• Adhered to the IT SDLC and ensured the Bookings business follows required processes and standards.
• Worked with Partner Operations stakeholders as IT SME/ETL Lead for building Confidential Partner Data Automation Project.
• Interacted with several Confidential distributors across the world in gathering the business requirements for ecommerce tools feed.
• Supported and maintained Confidential Compliance reports for month end and quarter end audits.
• Developed OBIEE reports & dashboards for the Field Finance organization.
• Developed and supported existing Bookings OBIEE Dashboard into Tableau Environment using Tableau Desktop and Analytics with wide expertise in Visualization techniques.
• Analyzed metrics for better understanding and formulated, presented relevant actionable recommendations to business.
• Provided support for the current reporting dashboard solutions, including data warehouse management, query modifications, improving the quality and timeliness of critical reports.
• Assisted business team in developing test cases and provide necessary subject matter support during integration testing cycle.
• Worked with various operations teams to understand processes and source systems underlying the data. Provided insights and recommendations for addressing data issues.
• Driven the application changes to support the evolving needs of a rapidly growing business.
• Provided data analysis support for data warehouse, ETL, and OBIEE reporting layers.
• Created several Functional Specification Documents to articulate the business requirements for IT development.
• Handled the various aspects of end to end lifecycle related to complex data warehousing and business intelligence projects.
• Well versed with the onsite-offshore development model.
• Extensively involved in developing reports with inputs from the assigned Business Analysts.
• Worked in a cross functional environment engaging with Business, Development, QA and Operations team
• Assisted business users in month end and quarter end audits

Environment: OBIEE 11.1.1.6.2 , Tableau Desktop 8.1, Informatica 9.1.0, Oracle EBS, Oracle10g, MS SQL Server, Toad, SFDC and Windows.

Confidential, Sunnyvale, CA

BI Data Analyst/BI Developer

Responsibilities:

• Co-designed the dimensional data model to provide the managers at Confidential Inc. the visibility to manage their budget in an efficient manner
• Spearheaded the data solution to provide Confidential Inc. managers the ability to track their requisitions, account payables, purchase orders, travel and other expenses using a dashboard.
• Analyzed the expense reporting requirements in the areas of GL, AP, PO, PR, Vendor Invoices and supported the team building the reports using OBIEE
• Actively participated in Data modeling (LDM/PDM) in the capacity of an IT SME / Data analyst.
• Created several Functional Specification Documents to articulate the business requirements for IT development
• Handled the various aspects of the end to end lifecycle related to complex data warehousing and business intelligence projects.
• Well versed with the onsite-offshore development model.
• Created Interactive Dashboards with BI Answers reports in different Analytics views (Pivot Table, Chart, Narrative, Column Selector and View Selector) and Pixel perfect BI Publisher reports using Oracle Projects and BI Answers as source.
• Upgraded, configured and tested OBIEE 11.1.1.6.2 Repository and created interactive Dashboards and Analysis.
• Coordinated with an offshore development team in India for ETL delivery
• Extensively involved in developing reports with inputs from the assigned Business Analysts.
• Developed reports based upon business requirements and processes, in line with defined workflows and use cases.
• Processed transaction from system entry to exit. Tested functionality of reports across applications and workflows.
• Worked in a cross functional environment engaging with Business, Development, QA and Operations team
• Reconciled reports and assessed readiness and deviation of product/project performance based upon results and design specifications.
• Assisted business users in month end and quarter end audits
• Involved in the complete SDLC cycle of enabling key reporting around expense management
• Displayed strong problem solving skills working in a fast paced environment
• Involved in both AGILE and Waterfall development models
• Participated in performance tuning TIGER team to make sure all reports meet their PLA’s
• Reviewed PL/SQL and ETL code
• Reviewed unit test cases and implementation plan
• Determine the end user requirements and plan data warehousing policies in its accord.
• Identified the feasible alternative approaches, systems and equipment’s to reduce cost and improve efficiency while meeting the business expectations

Environment: OBIEE 11.1.1.6.2 , OBIEE 10.1.3.X, DataStage, Oracle10g, SQL Plus, Toad, Flat Files, SFDC, HP-QC and Windows.

Confidential, Bensenville, IL

BI Data Analyst

Responsibilities:

• Analyzed financial data to compile reports and prepare recommendations.
• Perform analysis, design, and document - report requirements.
• Developed OBIEE reports and dashboard.
• Worked with users and coordinating with application developers to understand and capture data/reporting requirements.
• Interacted with Business Users for gathering Business Requirements to develop the reports.
• Document requirements, assist in clarifying discrepancies in requirements, and assist in obtaining appropriate approvals.
• Knowledge in business process and system functionality such as research, analysis, testing and documentation.
• Coordination of project teams, including reviewing deliverables and providing technical guidance during projects.
• Performed complex ad-hoc SQL queries when immediate access to data was required.
• Prepared weekly project status reports to keep management informed of project status and related issues.
• Meet with decision makers, systems owners, and end users to define business requirements and systems goals, Identifying, and resolving business systems issues.
• Reviewed and analyzed final audit reports for deficiencies in order to complete a response and make recommendations for corrective actions which resulted in a 20% increase in bank regulatory compliance.
• Assisted the internal auditors with to ensure 100% compliance.
• Ensured that all departmental policies and procedures manuals were kept current and that any changes were made in a timely manner in order to comply with the various government regulations.
• Created a planning system with the unit managers to streamline the external auditing process which resulted in a 50% reduction in the time needed to produce the final audit statement.

Environment: OBIEE 10.1.3.x, SQL Plus, Toad, Oracle10g, Informatica, Windows.

Confidential, Madison, WI

BI Data Analyst

Responsibilities:

• Implemented OBIEE application and managed all process and activities at client end, analyzed user's requirements and documented the development and results of the reports.
• Depth understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
• Implemented a Business Intelligence (BI) program to improve scorecard, dashboard and analysis capabilities.
• Interacted with customer as needed to better define and understand reporting requirements.
• Interacted with the business leaders and end users to identify areas to leverage Business Intelligence.
• Worked directly with the business to plan and implement reporting solutions.
• Expertise in building business intelligence and corporate performance management solutions including dashboards, score cards, query, and analysis reports with drill up, drill down.
• Acted as liaison between business units and technology groups to identify business processes and system requirements, including the implementation of an executive portal to deliver knowledge content and Analytical Reporting.
• Assisted in the troubleshooting of several financial systems problems and successfully corrected them.
• As a Business Intelligence Analyst I was involved in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service involved in documenting the business process by identifying the requirements.
• Supported the application, created and delivered training programs and solve problems including troubleshooting of operational/data issues.
• Analyzed, incorporated new business rules to ETL process to support changes as required by the business.

Environment: OBIEE 10.1.3.4.0 , SQL Plus, Toad, Oracle9i/10g, Informatica, Windows.

Confidential, Hudson, OH

ETL Informatica Consultant

Responsibilities:

• Interacted closely with Business Users in the Requirements gathering phase.
• Worked with Data Architect in the logical and physical design of the data model.
• Documented the design by creating High-level design document and a Low-level design document
• Used transformations like Source qualifier, Joiner, Lookups (connected and unconnected), Update strategy, Sequence generators, Routers, Aggregators, Union in the development.
• Worked on creating Mapplets and Reusable Transformations for recurring business logic in multiple mappings.
• Designed ETL logic and implemented mappings for slowing changing dimensions type 2 target tables and change data capture methodologies.
• Implemented Load schedule table to control the date the data needs to be run
• Developed Sessions and Workflows in the workflow Manager associated with each mapping.
• Created Worklets when a group of sessions need to run multiple times.
• Implemented Error Rejection process to load bad/invalid records into a separate reject table
• Used versioning within Informatica to control the changes to mappings, sessions and workflows.
• Worked with the administrator in creating the deployment groups for the deployment of the jobs to QA and Production.

Environment: Informatica 8.1.1 (Designer, Workflow Manager, Workflow Monitor and Repository Manager), Oracle 9i, SQL, TOAD, Erwin and UNIX.