PROFESSIONAL SUMMARY:

• 8+ years of experience in overall SDLC, 6+ years of experience in Business Analysis and OBIEE (Oracle Business Intelligence Enterprise Edition)/ Oracle BI Apps - Pre Built Analytic Packages.
• Expertise in Dimensional modeling and business process denormalization to build star schemas.
• Expertise in complete SDLC which involves Requirement Gathering, Proof of concept, Gap analysis, converting functional to technical Spec, Design, Development, Testing and Implementation.
• 2+ Years of IT experience in Requirement Analysis, Design, Development, Deployment and Maintenance of large enterprise Web-Based environment, Distributed N-Tier architecture and Client/Server architecture.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Experience serving industrial segments like, e-commerce and Insurance, Sales and Marketing domains in business related to implementation of ERP/CRM and BI Solutions
• Extensive experience in OBIEE RPD Development, Answers, Intelligent Dashboards and Delivers/iBots
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Expertise in Debugging and Performance Tuning of reports using various technical approaches like database tuning, aggregate implementation.
• Involved in performance tuning at the DB level, OBIEE-RPD, Dashboard Server Level
• Worked with Oracle Utilities like Toad, Putty and expertise in SQL * Loader, SQL, PL/SQL, MS Word, Visio for documentations and diagrams, and Excel spreadsheets.
• Worked on Excel Macros and Aggregations for data analysis.
• Working on Powerpoint and MS Visio to give presentations to the client .
• Experience in preparing Requirement Analysis Documentation, Training scripts, Functional
• Documentation, User Training Documents and Customization Documents.
• Expertise in creating Dashboards and Reports in areas like “Supply chain Management, Order Management and Fulfillment, Inventory and Sales”

TECHNICAL SKILLS:

Cloud Services: Amazon AWS, -VPC,EC2,S3,Redshift, Cloud best practices, DynamoDB(Nosql),Amazon RDS,Networking and Security, Cost optimization, Elastic Load Balancer and Elastic Beanstalk,Cloudwatch (Metrics). Microsoft Azure

Business Intelligence: OBIEE 10.1.3.4/3/2, Obiee11gData Modeling: Star-Schema Modeling, Snowflake Modeling, FACT & Dimensions

ETL-Tools: Informatica PowerCenter 9i

Languages: C++, VB 6.0, PL/SQL.

Web Technologies: HTML,JavaScript

Designing Tools: MS Visio, UML.

Operating Systems: Windows 98/NT/2000/XP/2003 Server.

Reporting Tools: HFM, OBIEE Answers & Dashboards

Scheduling Tools: DAC and Maestro

Databases: SQL Server 2000/2005, Oracle 9i/10g, DB2.

Web Servers: Internet Information Services (IIS), Weblogic.

Data Visualization tools: Tableau,Power BI

PROFESSIONAL EXPERIENCE:

Confidential, VA

Business Analyst

Roles and Responsibilities:

• Gathering business requirements and preparing the necessary documentation.
• Coordinating with offshore teams.
• Elicitation of data retention requirements.
• Worked on Business functions, use cases and Business rules.
• Conducted high level and low- level requirement analysis, impact analysis and estimation.
• Designed HTML and Excel Mockups.
• Assisted in coordinating testing efforts for business and IT testers.
• Participated in modified Agile, Scrum and Waterfall methodology.
• Working on different test phases of the project including UAT.
• Working on different projects related to construction.
• Hands on working on reports related to Order management, Supply Chain and Finance.

Environment: SQL,Excel,OBIEE, HTML,Power BI

Confidential, CT

Business Analyst and OBIEE Developer

Roles & Responsibilities:

• Understanding the business requirements working with business group and preparing the documentation.
• Coordinating with Onsite and offshore teams.
• Worked as a liaison between the business users and other departments.
• Worked on user acceptance testing in the final project.
• Working on overall project management, preparing the agenda and participating in SCRUM meetings.
• Performing the gap analysis and working on the data analysis.
• Worked on creating joins and adding attributes/measures in the RPD.
• Worked on creating different kinds of reports solving particular requirements of the client which included:
• Flash Reports-Mostly used by the management and the finance team to have a quick look into the budget and forecast of the Sales and Finance.
• Also included details of number of Orders shipped, Orders in Transit, Channel etc.
• Fill Kill Reports-Based on the retail business of the organization with clients like Walmart etc to look into the Orders filled or killed.
• OM and DP Reports-Defined the Supply Chain and Order Management.
• Sequel being a member of Swiss watch Federation designed branded watches like Guess and GC.
• Worked on Sequel Reports including Supply Chain, Pricing, Discounts and operations between London, Paris, Hong Kong and Norwalk.
• Provided user training to technical and non - technical users as well, on running the reports and dashboards.
• Migration of Discoverer reports to OBIEE.
• Migrated RPD metadata to test and production environment.
• Worked on Sales, Supply Chain management and Financial Modules and reports.
• Experience working on reports related to GL, Accounts receivables, Accounts Payables, Inventory, Budget and forecast, Sales.

Environment: OBIEE 11g, Informatica, OBIA, Oracle, SQL.

Confidential, FL

BI Developer and Analyst

Roles & Responsibilities:

• Worked closely with the client Business Analyst in understanding the Analytics requirements and created the Kimball Matrix for generating reports as per the user requirements.
• Presented the overall RPD metadata development methodology.
• Provided Weekly status reports to the Project Manager.
• Configured OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer. Established the logical joins/keys required to support drill-down aggregation.
• Writing data extracts to Excel files so that Business-users can analyze the data extracts in spreadsheets. These data extracts are also used for high-level Business users reporting purposes.
• Developed Role-Based Dashboards for Region Managers, Business Heads to review the Forecasts vs. Revenues and Contact Relationship Management (CRM) to analyze the financial service center statistics for different campaigns.
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
• Performing Testing of the IT Defects and CR raised by the Testing team.
• Implemented security by creating roles & web groups, checks with LDAP Authentication.
• Migrate the RPD metadata & web catalog contents to Test & Production environment.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, rebuilding of indexes, overwriting the SQL execution path by making use of hints etc.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository.

Environment: OBIEE 10.1.3.4, Informatica, Oracle 10g, Sql

Confidential

Operations Analyst

Roles and Responsibilities:

• Writing PL/SQL, T-SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Writing data extracts to Excel files so that Business-users can analyze the data extracts in spreadsheets. These data extracts are also used for high-level Business users reporting purposes.
• Involved in the design of the Database and Developed Triggers, Stored Procedures using SQL Server 2005 for all the interaction with the database performance tuning of SQL.
• Worked on complex reports using SQL Server Reporting Services.
• Created data entry screens with validation rules and developed Test case documents for all modules.
• Involved in data schema designing and actively involved in test case designing discussions and project scope document preparations.
• Working knowledge on Paging Concepts and Involved in implementing both User side and Admin Side modules.
• Involved in doing unit testing, System testing and created test case documents and program specification documents.

Environment: VB 6.0, VBScript, Oracle 8.x, 9.x, Dev 2000, SQL Server 6.5x, HTML/DHTML, Windows 2000 and Windows servers.