Business Operations Analyst Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Aparna Goswami

Sr. Business Operations Analyst

Oracle Certified Professional(OCP)                                                                                                                                                          aparna_526@ymail.com

Tel: 350-812-3025

Summary:

·         Overall 9 years of experience as Business Analyst including 6 years of Operations and Business Intelligence experience.

·         Specialties in operations, business intelligence, reporting, data warehouse, financial close-out, financial planning and analysis, metrics, professional services operations.

·         Expertise in Xcelsius Dashboard(4.5/2008), Business Objects (XI, 5x and backwards) with experience in Supervisor, Designer, Reporter, BCA Server (Publisher and Scheduler), Web Intelligence 2.5/2.6.1/6.0, Info view, Auditor and Schema Design.

·         Developed and published thin client reports using Web Intelligence.

·         Strong background in Data Warehousing, Data Modeling, Database Design, Data Migration, Capacity Planning, Space Management.

·         Expertise in Oracle development using Oracle, MS-SQL Server, SQL, PL/SQL, Functions, Procedures, Packages, Oracle Developer 2000, Oracle forms, Oracle reports, Oracle E-Business suite.

·         Good knowledge of Modules like OM, CRM, ERP and Sales Management.

·         Familiarity with Unix (Linux & Sun Solaris) concepts.

·         Excellent project management, analytical, problem solving, communication and interpersonal skill to interact with individuals at all levels.

Technical Expertise: 

RDBMS Skills	Oracle-8i/9i/11i, MS-SQL Server, PL/SQL, MS-Access, Database Normalization, Data Modeling, Entity Modeling, Reverse Engineering, MS-Excel, Data Guard and SQR.
Applications	Xcelsius 4.5/2008, Business Objects 5i, Business Objects XI, Crystal Report 9.0 and 11.0, Crystal Report Enterprise, PL/SQL, Visual Basic 6.0, VB Script, C, C++, ASP, Pascal,  L, Oracle 4.5/6i forms, Oracle 6i Reports, Oracle Application 11i, Front Page, CGI, Perl and Scripting, Java.
Network Protocols	Basic knowledge of SNMP, TCP/IP, TFTP, RCP, FTP, HTTP, Ethernet, Token Ring.
Operating systems	Windows 98, Windows NT, Windows 2000, Windows XP, Unix/Linux.

Education & Certifications:

·         Oracle9i Database Administrator Certified Professional (OCP) – July 2003

·         Bachelor of Engineering (Electronics) with Distinction

                Marathwada University, Aurangabad, INDIA in 1999.

·         Diploma in Electronics & Communication Engineering with Distinction

MC Polytechnic, Jalandhar, INDIA in 1995.

Certification Courses:

·         Oracle DBA, Santa Clara Adult Education, CA.

·         UNIX (Sun Solaris & Linux) from Santa Clara Technical Education, CA.

·         Software QA & manual testing from Santa Clara Technical Education, CA.

·         Oracle 8.0 and Developer 2000 from Tata Unisys Education Center, Jalandhar, INDIA.

·         Visual Basic 6.0 from Tata Unisys Education Center, Jalandhar, INDIA.

Experience:

Symantec Corp. Mountain View, CA

Sr. Business Operations Analyst

      Sept 2007 to June 2010

Responsibilities Included

·         Interfaced with cross-functional teams spanning Consulting Services/Product Management/Finance/Sales/Revenue Accounting/Education Services/Business Critical Services group senior management and users (Globally) to understand their business needs and helped them by developing, automating and managing reports/dashboards for them.

·         Gathered requirements from Business Users and Owners and their Business views in developing and modifying Universes and Reports accordingly.

·         Managed and helped the team to move from reporting to Business Intelligence team.

·         Developed innovative and self-serve executive dashboards with sensitivity analysis for better customer usability, better data insight and low cost maintenance.

·         Designed and developed complex dashboards that provide users precise data visibility and slicing-dicing of data for Professional Services Organization to maximize ROI, Profitability and track cost/utilization rate/Backlog/Timecard compliance

·         Analyzed, planned and managed projects such as automating the dashboards, saving data from dashboard to excel, application/universe enhancement, creating and maintaining new share point site for Operations group.

·         Managed relationship with vendors such as Quick arrow/OpenAir, salesforce.com ”SFDC” and Saba for new enhancements and quarterly maintenance release cycle.

·         Lead and managed quarterly maintenance cycle by working with business users for gathering any new requirements, new enhancements or updates on application, universe and reports. Worked with IT to accomplish them.

·         Updated and modified the BO universes depending on the business and report requirements. Also, directly worked with IT for any new BO reports or universe modifications and updates.

·         Managed UAT for reports with business users. Planned and managed end to end process for any new requirement/enhancement and communicate that end users.

·         Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.

·         Created full client and webi reports using Business Objects functionality's like Queries, Slice and dice, Drill Down, Cross Tab, Master Detail and Formula's etc.

·         Responsible for updating Executive Dashboard and Operational - Financial Metrics reporting.

·         Subject matter expert in pipeline, bookings, delivered revenue, recognized revenue, resource utilization.

·         Mentored BO users and managed business objects and dashboard developers.

Environment: Xcelius 4.5/2008, Business Objects 6.5.1/XI, Webi 6.5, Designer, Supervisor, Broadcast Agent, Info view, SQL, PL/SQL, Xcelsius Dashboard, Quick arrow, Sales Force, SABA, HTML, XML, Oracle 9i and Windows NT, Excel and Access.

Carrier IQ, Mountain View, CA

Business Analyst

      Jan 2007 to Sept 2007

Responsibilities Include

·         Interacted with the end users and higher management to gather requirements for reports and data analysis.

·         Deployed Crystal Report Server in Linux environment.

·         Created views and stored procedures for reports using complex SQL and PL/SQL.

·         Created Carrier IQ templates to be used throughout the company.

·         Published the reports in crystal enterprise and scheduled the reports depending on the users request to receive in different formats (Email, Public folder etc).

·         Handled administrative tasks via Crystal Enterprise for reports publication, scheduling, user security.

·         Responsible for creating the complex Crystal reports (On demand, AdHoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, Graphical and Charts).   

·         Worked with sales and professional services to analyze the reports on daily basis.

Environment: Crystal Reports XI, Crystal Enterprise XI/10.0, Business Objects XI, Business Objects 6i, Oracle 9i, SQL * Plus, MS-Excel, MS-Access, SQL Developer, Linux, Toad, SQL Loader, Perforce.

Hitachi Data Systems, Santa Clara

Saba LMS Implementation Project

        Business Analyst/Business Objects Dev., Feb 2006 to Dec 2006

Responsibilities Included

·         Actively involved in discussion meetings and requirement gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.

·         Installed, configured and maintained Business Objects XI and Crystal Report XI on different environments.

·         Worked with Business users for project status and data migration reports using Business Objects 5.1 and Crystal Reports 11.0.

·         Created reports using queries, drill down, functions, cross tab, functions, hierarchies, rank, charts, dashboard, sorting and group by sorting, master detail, formulas and sub reports.

·         Created Business Objects Repository and published SABA out of box and custom reports using BO Publisher Wizard. Created report configuration in SABA UI for custom report.

·         Scheduled Business Objects Reports for IT and Business users with different roles and privileges.

·         Created standard templates for all the HDS custom reports and tested all SABA custom and out of box reports by Info view and Saba Application.

·         Designed and managed groups and users using Supervisor module and assigned them universes and documents specific to their domains.

·         Loaded data using oracle SQL*Loader utility. Extracted data from different data sources by Crystal Report to flat and pipe delimited files, wrote the control file and loaded data into the tables.

·         Actively involved in data migration from different data sources and in UAT for reports.

·         Worked on Oracle E-Business suite to test the PL/SQL scripts which loads data from Oracle HR into SABA tables.

Environment: SABA 5.2/5.3, Crystal Reports XI, Crystal Enterprise XI/10.0, Business Objects 5x, Business Objects XI, Oracle 9i, SQL * Plus, Excel, SQL Server 2003, Access, SQL, PL/SQL Developer, Toad, InterBase etc.

Intellisync / Nokia, San Jose

      DBA/Data Analyst, Sept 2005 to Feb 2006

Responsibilities Include

·         Created parameterized drill-down dashboard reports, cross-tab, conditional, Top N, Summary, Form, OLAP reports and sub reports.

·         Created reports with formatting options such as Charting, Mapping, Grouping, Sorting, Alerting, Field highlighting, Drill-down, Parameter prompts, Templates.

·         Created views and Procedures and integrate Crystal Reports with SQL and Oracle databases using Views and Stored Procedures and Functions.

·         Worked with the higher management in Marketing, Sales and Finance departments to gather requirements for their reporting needs.

·         Handled administrative tasks via Crystal Enterprise for reports publication, scheduling, user security.

Environment: Crystal Reports XI, Business Objects XI, Crystal Enterprise XI/10.0, SQL Server 2003, MS-Access, SQL, T-SQL, Sales force, Quick arrow etc.

Catholic Charities, San Jose

Crystal Report Developer, Sept 2000 to Sept 2005

Responsibilities Include

·         Involved in project planning, setting up the security, menu design, screen layout, screen design, development, documentation and creating reports.

·         Handling installation and maintenance of Crystal Reports 9.0 and 11.0.

·         Designed Crystal Reports using version 11.0 with Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the report requests. The reports were from Tables, Stored Procedures, Views and Command Objects.

·         Developed web reports using crystal reports and migrated the existing reporting system to higher version and published them using crystal enterprise.

·         Database performance monitoring and identifying bottlenecks hindering the performance of the database. Created Data Dictionary for data conversion in MS Access database with XML.

Environment: Windows NT 4.0, Crystal reports 9.0, 11.0, Business Objects XI, MS Excel, SQL Designer, MS SQL Server 6.0-6.5, SQL.

Work Status:

·         No work authorization needed.

Extra Curricular Activities:

·         National Player in Tennis.

·         Active member of Computer Society of India.

References:

·         Available on request.

Download Resume Format