Profile: Highly motivated with ability to adapt to a wide variety of situations. Very responsible, dependable and punctual. Quick learner with strong work ethic & natural attention to detail combined with superior planning abilities and excellent organizational skills. An outstanding ability to think logically.

Summary:

• 7+ years of IT experience in systems analysis, design, development and support of complex applications in the Data warehousing/ Business Intelligence domain
• Strong knowledge & understanding of industry standard methodologies including Software Development Life Cycle (SDLC) and Project Life Cycle.
• Business/Functional/Reporting Analyst experience.
• Experience in business process engineering and software development life cycle, including analysis, design, development, testing and implementation of software applications
• Data Analysis - Analysis of source data systems, to identify and document complex data mapping / data dictionary.
• Preparation and execution of test cases
• System Study, Analysis, Design and Development of Decision Support Systems- Data modeling & Data analysis
• Expertise in analyzing the data and generating various complex reports using SAP Business Objects XIR3/R2/R1/6.X (Designer, Reporter, Supervisor, Broadcast Agent (BCA), Web Intelligence) Key Performance Indicators and Crystal Enterprise/Reports 9/10/XI, Live Office, Business Objects Data Integrator XI 11.5.0.
• System Study, Analysis, Design and Development of Decision Support Systems- Data modeling & Data analysis
• Worked extensively with all Informatica Designer tools including Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Strong Knowledge of Data warehousing concepts and Dimensional modeling (Star schema, Snowflake schema)
• Proficient with various databases such as Teradata, Oracle, SQL Server and MS Access, MS Excel.
• Strong Knowledge in functional testing tools and management tools.
• Excellent communication, analytical, interpersonal, and presentation skills; expert at managing multiple projects simultaneously.

Technical Skills

Data Warehousing: Business Objects suite XIR3/XIR2/XI/6.x/5.x (Supervisor, Designer, and Web Intelligence, Business Objects, Info View), Crystal Enterprise/Reports XI/10/9i,08. Oracle Business Intelligence Enterprise Edition 10.1.3.4.1 (OBIEE ETL Tools: Informatica Power Center 7.1/6.x/5.x, Data Integrator, Business Objects Data Integrator XI11.5.0 Dimensional Data Modeling: Dimensional Data Modeling, Erwin Modeling (ERwin 4.1/4.0/3.5.5/3.5.2, Oracle Designer), FACT & Dimensions tables, Physical & logical data modeling, Star & Snowflake schema Relational, dimensional and multidimensional modeling and De-normalization techniques, Kimball & Lnmon Methodologies Functional Areas: BI Project Life cycle development, Design and deploy complex BI solutions, Excellent skills in Universe & Report Design, Excellent client relationship management skills. Databases: Oracle 10g/9i/8i, MS SQL Server 2000, MS Access 7.0/2000, Teradata. Programming: SQL & PL/SQL Operating Systems: MS Windows 98/NT/2000/XP Others: SQL Navigator, ODBC

Academic Qualification: Master in Computer Science Bachelor of Science (B.Sc.)

Certifications: IBM Certified Designer - Cognos 8 BI Reports IBM Certified Designer - Cognos 10 BI Reports Informatica PowerCenter 8 Mapping Design Certification NETEZZA - NPS Bronze Certification

Professional Experience:

Company Name: Confidential Fremont, CA Clients worked: Confidential, Milpitas, CA Dec 2011 - Till date BO BI Analyst

Goal of this LSS (Large Scale System which manages both Ad-hoc and Standard Reports) project is to do the reverse engineering on multiple domains which includes Finance, Manufacturing, Marketing, Planning, Supply Chain universes and their corresponding reports due to the migration happening at the database level. These reports include the Billing, Backlogs, Balance Sheets, Forecasts & the Dashboards. Need to make sure that any underlying tables/views/columns are not getting impacted and if in case are impacted then have to identify and fix the what all universes and reports are making use of those attributes to make the reports run and refresh the data as expected.

Responsibilities:

• Interacting with different members in the organization namely project managers, designers, testing team, subject matter experts, and customers to understand and document the details related to the reporting requirements by having regular scheduled interviews, document analysis, requirements workshops, business process descriptions, use cases, scenarios, business analysis, task and Informatica workflow analysis.
• Gathering the details from the ETL & DBA's on the changes happening at the database level.
• Identifying the modified tables from the ETL mapping document
• Doing the gap analysis to identify the New/Additional/Existing attributes which needs to be fixed.
• Preparing the high level Universe and Reports Specifications & documenting the reporting standards.
• Providing the timelines for the first cut of the Analysis phase with the details to the client with the checklist.
• Preparing the scope and execution plan which requires during the development phase.
• Created regular Use Cases, Requirements, related documents, UI layouts, UseCase diagrams with users todefine the right concepts.
• Perform user acceptance testing andquality analysis
• Worked closely with the developers andSME's to establish the technical vision and analyzethe detailed needs.
• Engaging team with various tasks to do the impact analysis on the universes and reports.
• Coach, mentor and lead personnel within a technical team environment.
• Always tied the team between the businessunits, technology teams and support teams to get to the 100% requirements done as per the user request.
• Strong hands of experience in the complete SDLC life cycle of the project.
• Strong presentation skills
• Knowledgeof Windows XP and Microsoft Office Suite

Environment: Business Objects XIR3 Enterprise Suite (Designer, Web Intelligence), Teradata, Windows 2003, Oracle10g, TOAD & Data Virtualization tool.

Confidential, Denver, CO Aug 2011 - Dec 2011 BO BI Analyst

Confidential is primarily a gold producer which is one of the world's largest gold producers and is the only gold company included in the S&P 500 Index and Fortune 500. The main goal of this project is to design a new Repository/Universe and to develop around 100 reports which have been divided into 4 subject areas i.e Plant Management, Human Resource, Supply Chain Management & Supplier Relationship Management which is coming out of SAP BW & Teradata.

Responsibilities:

• Responsible for the business operations as Business Analyst and give an efficient and effective solution, doing excellent documentation on business requirements that would help the organization to achieve the best solution in business.
• Responsible for finding out the business problems and also propose solutions for the same.
• Interacting with different members in the organization namely project managers, designers, testing team, subject matter experts, and customers.
• Work closely with the end users to understand and document the details related to the reporting requirements.
• Preparing the Test cases used during the testing phase of Unit Testing, System Integration Testing, Functional Testing & User Acceptance Testing.
• Communicate status, issues and risks to project stakeholders, project team and management.
• Work at all levels of business and technology organizations to communicate requirements.
• Independently managed to deliver the MPP plans (Management Project Plans) includes both high level and the detailed level information.
• Allocated resources accordingly to the user allocation and assigned with the tasks to reach the go-live date of the client.
• Work collaboratively with other Business Intelligence and ETL resources to design and develop effective solutions.

Environment: SAP Business Objects XIR3 Enterprise Suite (Designer, Web Intelligence), Teradata, Windows 2003, Oracle10g, TOAD, Data Services.

Confidential, San Jose, CA Jan 2011 - Aug 2011 BO BI Analyst

Manufacturing domain reports which are developed to maintain the records of the Supplier Chain Risk Management (SCRM) which includes 8 different tracks/subject areas i.e.: GENERAL, ADHOC, TEST, GCRM, BCP, FRA, PRS & CRISIS. The universe model has been designed to capture the entire details of the SCRM tracks which makes the users/Business to create their own temporary reports along with the 43 standard reports which includes the Billing, Balance Sheets, Forecasts & the Dashboards.

Responsibilities:

• Responsible and accountable for the coordination with offshore development team related to project objectives.
• Building credibility, established rapport and maintained communication with the stakeholders at multiple levels, including those external to the organization.
• Preparing high level project plans depending on the resources to deliver the given assignment on time.
• Maintaining continuous alignment of project scope with strategic business objectives, and making recommendations to modify the project plan to enhance the effectiveness towards the business results.
• Coach, mentor and lead personnel within a technical team environment.
• Requirement gathering, developing detailed analysis, design, construction, Integration & Testing, preparing unit test cases, system integration test cases and leading the team in delivering the test results which includes Unit, SIT, FT& UAT test cases and results (as a part of the development) .
• Documenting the reporting standards, time estimates and checklists.
• Managing transition of client from Solutions Implementation to Client Support & Manages the development and maintenance of implementation portions of the project.
• Involved in multiple BI projects in various capacities & managed the development of DW/BI solutions and provided efforts estimate for BI reporting.
• Validated the data and the joins in the Universe by running BO reports and exporting the output to the Excel Spreadsheets.
• Participated in groundwork of Project plans, user acceptance testing's.
• Responsible for organizing Functional Test Plans which was used by the testing team during a testing process.
• Participated in meetings with Senior Business Analysts and manager's and understood different business process, process plans and functionality in a detail.
• Organizing training sections for new process developments and completion.
• Involved in arranging the Integration Test Plans which was utilized by the functional team and the development team for performing detailed testing on business application.

Environment: Business Objects XIR3 Enterprise Suite (Designer, Web Intelligence), Teradata, Windows 2003, Oracle10g, TOAD & Data Virtualization tool.

Confidential, Cupertino, CA Mar 2010 - Dec 2010 BO BI Analyst

This iTunes Global Reporting Information Database Application establishes data quality (completeness, accuracy, consistency and reliability) and data ownership and management processes with functionality to generate the summary and detail finance reports. The report's are used to provide increased availability of business information with better analysis, improved decision making and self-service iTunes reporting and establish proper balance of standardized reporting and end-user ad hoc flexibility.

Responsibilities:

• Responsible for requirement gathering of functional/technical specifications to establish proper balance of standardized reporting and end-user ad hoc flexibility.
• Worked with various finance groups to gather Business Objects Reporting, Dashboard requirements
• Responsible to work in Finance analysis reporting.
• Worked as Business Analyst position to gather, validate, and deliver regular as well as ad- hoc Finance, Customer Service and Operational measurements of business performance requiring coordination with multiple groups and systems in order to produce accurate, meaningful and actionable reports
• Created a best practice library over 100+ prebuilt metrics, 30+ intelligent dashboards, 60+ reports and several alerts for CFO, Finance Controller, Finance Analyst, AR/AP Managers and executives.
• Customized the iTunes in GRID BBB (Billing, Booking & Backlog) Universe.
• Build, maintain and support Executive Dashboards and adhoc reports.
• Created interactive and connected models in xcelsius.
• Perform system integration testing (SIT) / validation to ensure a smooth launch of the report. Create validation scripts, establish the validation process to ensure if the data on the report correct, if the report formatted according to requirements.
• Streamlined and documented the business rules.
• Documented and trained the Business users with the user adaption techniques in using the universe and the reports.
• Played the key bridge between the developers and the end user (client)

Environment: Business Objects XIR3 Enterprise Suite (Designer, Web Intelligence), Teradata, Windows 2003, Ms-Exce07, Oracle10g.

Company Name: Confidential. Chicago, IL Confidential, Mountain view, CA Oct 2009 - Mar 2010 Lead Business Objects / Crystal Report Developer

Environment: Business Objects XIR3 Enterprise Suite (Designer, Desktop Intelligence, Web Intelligence), Crystal Reports 2008, Performance Management, CMS, Windows 2003, Ms-Exce07l, SAP BW, Oracle10g,Oracle SQL Developer, Live Office.

Confidential, Chicago, IL April 2008 - Sep 2009 Sr. Business Objects / Crystal Report Developer

Environment: Business Objects XIR2 Enterprise Suite (Designer, Desktop Intelligence,Web Intelligence), Crystal Reports XI, Performance Management, CMS, Windows 2003, Ms-Excel, Oracle Server, DB2, Oracle10g, SQL, PL/SQL, Oracle SQL Developer, Erwin.

Confidential, Atlanta, GA Jan 2008 - April'08 Sr. Business Objects Report Developer / Report Writer

Confidential, Hopewell, NJ September 2007 - December 2007 Sr. Business Objects Developer

Confidential Duration : July 2006 - June 2007. Software Developer

Confidential Dec 2003 - March 2006. Software Developer