SUMMARY

• Thorough professional with 18 years of experience in delivering IT projects in Application Development, COTS Implementations, Business Intelligence, EDI, Data & Systems Integrations in AS/400, Mainframe, Oracle EBS, PeopleSoft and SAP landscapes encompassing Medial, Universities, Insurance, Manufacturing, Retail, and Technology sectors.
• Involved in many complete project life cycles (SDLC) playing different roles as Business Analyst, Project Manager, Solution Architect and being a Hands - on Developer has given comprehensive understanding of how projects are executed and also developed a holistic approach to Software Development
• Master’s Degree in Business Administration(MBA) and Bachelor’s Degree in Electrical Engineering and an experience of managing & working in cross-cultural & geographically scattered teams, On site-Offshore models and also has the experience of working in USA, Europe and India
• Key Skills and Knowledge: Business Analysis, Data Analysis, Business Intelligence, OBIA, BI Publisher and PeopleSoft EPM
• Define solution scope and objectives for requests based on user needs and how they impact business processes
• Devise or modify reporting tools to solve business problems
• Build alerts and notifications based on performance data
• Translate business and user needs into system requirement specifications
• Coordinate with business leaders to prioritize and schedule development projects
• Work with other system business analysts to oversee project dependencies
• Write and execute thorough test plans
• Communicate the availability of new reports and features within the reporting system
• Participate actively in end-user training
• Participate in production code pushes after regular business hours
• Shadow business users to fully understand business processes and challenges
• Share best practices to help other team members develop
• Seek feedback, new challenges and growth opportunities
• Implement BIDW projects both as Business Analyst and Project Manager

TECHNICAL SKILLS

BIDW Tools: OBIEE, OBIA, PeopleSoft EPM, DAC, Business Objects, Informatica SAP Net Weaver, MDM, SAP XI

Databases: Oracle, MS SQL Server, DB2/400, MS Access.

Languages & Tools: J2EE, SQL, XSL, XSLT, XML, PL/SQL, RPG/400, CL/400, and HTML

Modeling & Productivity Tools: MS Office, Toad, Erwin, HP Quality Center, MS Share Point and JIRA

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior BI Analyst/Offshore Coordinator

Technology Landscape: Oracle EBS R12, OBIA 7.9.6.4, Oracle BI Publisher 11g, Oracle 12G, Toad, SQL Developer Share Point, HP Quality Center

Responsibilities:

• Implemented Oracle Business Analytics using OBIA 7.9.6, Employee Expenses, Spend Analytics, Green Grade projects to meet the requirements of the client
• Coordinated with IBM’s Macy’s team for the development efforts and be responsible for their delivery on various projects
• Manage and track the status of requirements throughout the project life cycle; enforce and redefine as necessary.
• Establish and enforce proper change request management procedures for all projects to ensure proper scope control.
• Communicate changes, enhancements, and modifications verbally or through written documentation to project managers, sponsors, and other stakeholders so that issues and solutions are understood.
• Provided and created user training and to use OBIEE reports and dashboards

Confidential, Houston, TX

BI Analyst/Lead

Technology Landscape: PeopleSoft EPM, Oracle 11g, OBIEE 11g, Oracle BI Publisher 11g, Oracle 11G, Toad, SQL Developer Share Point, HP Quality Center

Responsibilities:

• Implemented Business Analytics using PeopleSoft EPM, in the Grants, Research Finance, General Ledger Analysis, Income Statement, Asset Management, Supply chain Analysis and FTE subject areas to meet the requirements of the client
• Lead the functionality fit/gap analysis, conducted iterative requirements sessions with the project team to define functional system requirements via workshops, scenarios and other methods.
• Provided and created user training and to use OBIEE reports and dashboards

Confidential, Columbia, MD

Senior BI Consultant

Technology Landscape: Oracle 11g, OBIEE 11g, Oracle BI Publisher 11g, Oracle 11G, Toad, SQL Developer SharePoint, HP Quality Center

Responsibilities:

• Helped BA team for writing functional specifications and in prototyping the reports for external requirements team
• Conducted iterative requirements sessions with the project team to define functional system requirements via workshops, use cases, scenarios and other methods.
• Lead JAD sessions with key stakeholders for stated functional requirements
• When necessary, worked with the DBA team to build materialized views and also dynamic views for on demand reporting.
• Worked with the Release Manager in LOE’s, project scheduling and on status updates on release defects and deployed to V&V under tight schedules
• Manage and track the status of requirements throughout the project life cycle; enforce and redefine as necessary
• Function as a lead analyst responsible for coordinating and motivating the analyst team to ensure successful completion of the project.

Confidential, Atlanta, GA

Technology Landscape: Oracle 10g, OBIA,DAC, Oracle EBS 12, OBIEE 11g, BI Publisher, Informatica 8x, Toad, Microsoft .Net, XML

Responsibilities:

• Designed and built the dimensional data model OBIEE meta data repository as per the business requirements to include and all the required metrics and KPI’s and mapped with the data models in FMS and HCM warehouse data models
• Reviewed the OBIA data models with business users, App Developers and Information architects to ensure all the requirements are fully covered.
• Created dashboards that connect to external databases (oracle, Microsoft Access, etc.), MS Excel worksheets and any other data sources both at RPD level and at report development
• Detailed testing was planned at various stages, executed and results were validated before releasing the system to users.

Confidential, Santa Ana, CA

Technology Landscape: Oracle 10g, OBIEE 10g/11g, OBIA 7.9.6.3, Informatica 8, Toad, J2EE, XML, Share Point, PeopleSoft EPM

Responsibilities:

• Involved in custom development of Case Dispositions based Analytical and Operational Reports in OBIEE and also involved in implementation of OBIA Financial module called US Federal Financial Performance Analytics
• Performed requirements gathering by interacting with Administration Office of Courts executives at various levels for Case dispositions and. Prepared detailed flow-chart diagrams using Microsoft-Visio for Process flow and documented the reporting needs of AOC
• Designed and Developed custom OLAP data models for case dispositions data from Court Case Management Systems and customized OBIAW data model for US Federal Financial Performance to draw data from Oracle EBS for the data warehouse based on the analytic requirements
• Implemented Operational Analytics and reporting solutions relative to key performance indicators
• Provided training, support and guide for best practices for Adhoc Query Users and Report Authors.