PROFESSIONAL SUMMARY

• Over 7+ years of experience as a Data and Business Intelligence Analyst.
• Experienced in implementation of Business Objects project in many domains like Construction Chemicals Manufacturing, Marketing Consulting, Online Mall and Retail services.
• Defined logical views and worked with the database administrator to create physicaldatastructures
• Lead, developed and maintained a formal description of thedata anddatastructures - includingdatadefinitions,datamodels, dataflow diagrams, etc.
• Worked with interfacing with the business objects universeanalystto complete a business objects universe.
• Partnered with business partners and other BIS departments on design.
• Partnered with implementations of all components related to design (i.e.,database, tables, business objects universe, etc.)
• Excellent knowledge of Microsoft Excel spreadsheets to validatedata
• Ability to interact and communicate effectively in a fast-paced environment with both external customers and internal colleagues
• Meticulous attention to detail anddataaccuracy. Excellent communication skills.
• Demonstrated experience using advanced Excel Analysis
• Demonstrated experience in analysis and presentation ofdata
• Experience working with a variety of information systems anddatafiles, including large and complex files: analyzing file structure, using and creating file layouts, transforming rawdatainto finished products.
• Strong communication skills, both written and spoken.
• Comfortable working independently, with experience working in a team environment.
• Skills in establishing and maintaining effective working relationships with members and staff.

TECHNICAL SKILLS

Reporting Tools: Business Objects XI R3/R2/6.5/5.x/4.x, Xcelsius 4.5/2008, Crystal Reports 2008/XI/10/9/8, Web-Intelligence 6.5/2.x, SQL Server Reporting Services, CMC Performance Management.
ETL: Informatica Power Center 6.2, 7.1, 8.1.
Operating Systems: WINDOWS NT, 95/98, 2000, UNIX.
RDBMS: ORACLE 10g/9i/8i,MS SQL Server 2005/2000 and MS- ACCESS 2000, DB2.
Data Modeling: MS Visio, DB Designer, Dimensional Data Modeling (Star Schema,
Snow-Flake, FACT Dimensions),
Web Technologies: ASP.NET, Java script, XML, XSL, HTML, DHTML, JavaScript
Application servers: Web Logic, Web Sphere, Tomcat.
Languages: C, C++, ASP.NET, Java.

Education

Bachelor in Engineering, Higher second class honors

PROFESSIONAL EXPERIENCE

Confidential, Tampa, Florida April 2010- current
Sr Business Intelligence Developer

Description: Confidential, is one of the biggest Auto insurance provider and has about 4 million members. AAA has travel, online mall and auto repairs under its umbrella. I was mainly responsible for the online dollars program which was a new addition to their product portfolio. Worked as a Business Intelligence Developer, managed Reports, Universes, Security and Dashboards.

Responsibilities:

• Involved in all steps of Software Development Life Cycle (SDLC). Gathered report requirements from the users, preparing draft specifications, generating new reports.
• Performed projectDataAnalysis, DataPreparation, Project Upgrades and Quality Control of the ProjectData
• Used business and analytical skills to draw information from a variety of individuals and various business environments, compiling information into a comprehensive database that tracks repurchase.
• Knowledge of PC based programs such as Business Objects, Access, Outlook, Word, Excel and PowerPoint.
• Experience working on special projects or within a project team; documenting process, procedures and requirements. Accountable for the interaction and matrix relationship with other business teams.
• Assisted Project Leads, Business Managers with follow-up on outstanding issues
• Generated and distributed ad-hoc, weekly/monthly and year end reports.
• Worked on Business Object migration project and played a key role in migration of business objects from XIR2 to XIR3.
• Designed and modified the Universes as per the requirements adding new classes and objects as required.
• Developed and maintained complex universes supporting multiple levels of hierarchies for drill down, drill through and drill across functionalities.
• Used derived tables to create the universe for best performance, and used context and alias tables to solve the loops and traps in the Universe.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail and Formulae\'s etc.
• Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Developed new Business Objects Reports along with modifying existing reports to support new and additional business requirements. Used prompts, filters, alerts, drill down analysis, row level securities and aggregative awareness as per the end user requirements.
• Extensively used calculation contexts, variables, drill down, slice and dice, alerts in the creation of reports.
• Involved in testing reports in XIR3 to compare row count, response time and report output.
• Created many free hand SQL queries for accessing information residing in Oracle database and defined full client reports.
• Worked on complex Crystal Reports that require running totals, sub-totals, sub-reports, prompts, cross-tab, multiple groups, hierarchical grouping and conditional display of groups, fields, and messages.
• Used version control for maintaining and modifying the stored procedures and codes for every new project release and also involved in tuning of Crystal Reports for better performance.
• Created dashboards, graphs using Crystal Xcelsius. Personalized the dashboards to reflect user-specific alerts and metrics to track critical Key Performance Indicators (KPI).
• Created reports on web using Info View Portal and published the reports on the World Wide Web to different users.
• Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.

Environment: SAP Business Objects XI R3/XI R2 (Desktop Intelligence, CMC, CMS, Application Foundation, Web Intelligence, Crystal Reports XI, Designer, Xcelsius 2008 Universe Builder, Import Wizard), SAP BW, Sybase, Informatica, UNIX, Rapid SQL, MS Office.

Confidential, Tampa, Florida Dec 2008 - March 2010
Role: Business Objects Developer

Description: Confidential, is a national research, strategy and marketing firm headquartered in Tampa, Florida. They have clients from various industries including financial, health care, credit unions etc. The responsibilities undertaken in the project were mainly to conduct data analysis for HCP's clients. As part of the Reporting project, there was a need to extract data from the database, transform and load into the reporting database which is the data source for Business Objects reports.

Responsibilities

• Interacted with business users to understand their requirements and thereby was actively involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications to generate thereports.
• Designed both written and graphic metrics based reports for management.
• Utilized various systems, such as Clarity, SAP, and vendor systems, to extract data
• Extensively used Excel and Access for report generation.
• Applied statistical methods appropriate to the type ofdataand variance involved.
• Provided written analysis and recommendations to address trends.
• Determineddatacollection methods and frequencies most appropriate to manage performance levels.
• Ensure communication and report delivery mechanisms meaningful are effective.
• Acted as a subject matter expert indataanalysis and metrics development across key process areas in MIS.
• Trained specific MIS personnel on report usage, value, and compliance implications. Works with MIS departments to gatherdatarequirements for metrics reports.
• Prepared ad hoc supporting documentation for senior financial management.
• Built static Dashboards using Crystal Xcelsius with the data in Excel files.
• Created dashboards, graphs using Xcelsius 2008. Personalized the dashboards to reflect User-specific alerts and metrics to track critical Key Performance Indicators (KPI).
• Used QAAWS (Query as Web Service") to pull data from the universe and use that data to build personalized Xcelsius dashboards.
• Implemented Open Doc to drill down to detail WebI report from Xcelsius Dashboard.
• Involved in creating test plans and test scripts for reports testing and test run in QualityCenter.
• Managed and configured servers (File Repository Server, Report Application Server,
• Web Intelligence Server, Destination Job Server, Program Job Server, and Event Server)
• Worked on performance tuning of universe and reports.
• Worked extensively on distribution, maintenance, and optimization of universes for
• Business Objects and Web Intelligence deployments.

Environment: Business Object XI/6.5.1, Crystal Reports, Designer, Xcelsius 4.5/2008, Desktop Intelligence, Web Intelligence, Info View, Informatica 7.1, JSP, J2EE, CMC, CMS, Oracle 10g,SQL,PL/SQL,SQL Server 2000, Erwin 4.5, TOAD, Windows XP.

Confidential, Mumbai, India Jan 2007 - Nov 2008
Role: Business Objects and Crystal Reports Developer

Description: Confidential, is a manufacturer of Industrial Mortars used in the application as tile adhesives and tile grouts. Saint Gobain was in the process of increasing their product lines to Industrial flooring used for warehouses. The fundamental goal of his project was provide detailed reports to the respective department heads and conduct a statistical analysis of the data.

Responsibilities:

• Worked extensively with mappings using expression, aggregator, filter, lookup and procedures to develop and populate Data Warehouse.
• Created sessions and batches to run the mappings and set the session parameters to improve the load performance.
• Developed universe using designer module in Business Objects.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Resolved problems like fan trap and chasm trap.
• Created hierarchy and conditions at the designer level.
• Created complex reports by linking data from multiple sources, using functionalities like Slice and Dice, Drill Down, Master Detail, etc.
• Used different data providers in a single report and implemented synchronization.
• Created hierarchies from providing drill down options for the end-user.
• Created daily, weekly, monthly and quarterly reports for the management team and field operation managers using Business Objects reports.
• Creation of different types of reports such as master/detail, cross tab and chart for trend analysis. Used filters, conditions, calculations in the reports created.
• Prepare the reports using BO for the end-users and export them to the library for the end-user's view and reports scheduling.
• Extensively used Designer to design various universes for different business groups.
• Created Contexts and Aliases for resolving Loops, and synchronization problems in the SQL and created cascading prompts in the universe. Created complex reports using cascading prompts, decode objects etc.
• Created dashboards, graphs using Crystal Xcelsius. Personalized the dashboards to reflect user-specific alerts and metrics to track critical Key Performance Indicators (KPI).

Environment: Windows 2003 Server, Informatica, SAP Business Objects 6.5 (Desktop Intelligence, CMC, CMS, Application Foundation, Data Integrator, Web Intelligence, Designer, Universe Builder, Import Wizard), Toad, Oracle 9i.

Confidential, Mumbai, India Sept 2004 - Dec2006
Role: Junior Business Intelligence Developer

Description: BASF Construction Chemicals is one of the largest chemical manufacturers in the US. I was involved with the construction chemical division in India. BASF had clients all over India including architects, structural consultants and builders. I was mainly responsible for data analysis and running reports.

Responsibilities:

• Developed business in western region of India by locating upcoming projects and conducting technical seminars.
• Conducted sales promotional activities and assisted in building BASF's brand.
• Provided technical support to sales and channel partners, as well as customer and supplier relationship management.
• Updating the clients about the new products and services in the market through email channels.
• Managed Users (using CMC created user and assign the different level of access, delete user). Also created folders and provided access to different users.
• Created folder and subfolders for different categories such as Sales & Marketing, Finance, Product Development and R & D.
• Debugged the universes, contexts, various BO reports for conversion to equivalent BI Web reports.
• Created filters (condition objects) to improve the report generation.
• Created hierarchies from providing drill down options for the end-user
• Created context, alias to resolve the loops in the universe
• Modifying the existing universes, adding new objects editing joins, mapping the existing objects with renamed tables
• Created database objects such as views, functions and stored procedures from the Universewith respect to user requirements.
• Created underwriting reports using store procedures which are used to pull data from many tables.
• Worked on performance tuning of universe and reports.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.