SUMMARY:

• 12+ years of experience in the field of software design, development and deployment of Business Intelligence and Analytics solution using leading BI and Data Visualization tools
• Experience in requirements gathering, data analysis, writing design/technical specifications, business requirements, test scripts and project charters
• Domain expertise in Pharmaceutical, Banking/Finance, Manufacturing and Retail Industries
• Experience in Data warehousing and data modelling using relational and dimensional data models - Implemented Star & Snowflake Schemas
• Proficient in DB2, SQL server and Oracle databases using PL/SQL stored procedures
• Experience in designing visualizations using Xcelsius and Tableau, publishing and presenting dashboards on web and desktop platforms
• Experience in building reports using SAP Business Objects, Web Intelligence, Crystal reports, Universe Designer - UDT & IDT
• Knowledge in extraction, transformation and loading processes using SAP Data Integrator and Informatica
• Experience in VBA scripting, conversion of DESKI reports to Web Intelligence
• Performed conversion from legacy system data to Business Objects and Business Objects Platform migrations
• Strong analytical, logical and problem solving skills and team player with the ability to quickly adapt to new technologies by self-learning
• Strong organizational and time management skills to deliver projects on time and budget

TECHNICAL SKILLS:

Operating System: Windows NT/ 2000/2003//2008/2012, Unix,Linux

Database: Oracle 8.x/9.x/10g, SQL Server 7.0/2000/2005/2008, MS Access, DB2

Languages: Visual Basic 6.0, C,C++, Java, ABAP, SQL, and PL/SQL

Web Technologies: ASP, HTML/DHTML, Java and VBScript, Java, XML, XSLT

Web/Application Servers: WebLogic, Tomcat 4.1

BI Reporting and Analytics: Tableau 9.3, Xcelsius 4.5/2008, Business Objects 5.x/6.x/XI R2/3.1/4.2 DeskI, Web Intelligence, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Solutions Engineer

• Requirements gathering and analysis of new and ongoing modifications of reporting systems, and implementing report development standards, processes, and procedures
• Prepared business requirements documents, participated in defining Functional Specifications, Technical design specifications, UAT, SIT Testing and GAP Analysis
• Responsible for management and successful delivery of BI Reporting projects for Marketing and Merchandizing departments
• Acted as a liaison and coordinator between the business and the technical team to gather and translate business needs into technical requirements as well as effort analysis and estimation.
• Developed complex reports such as CD 100 reports, Customer segmentation, Retail dashboards, Portfolio clients month on month sales, Tourist vs Domestic sales, Customers by client type by market, Yearly and Quarterly store sales analysis
• Built universes using designer UDT(Universe designer) and IDT(Information design tool - including multi source universe) from DB2 and Oracle data sources
• Built audit reports based on Activity Universe and Metaminer Universe
• Maintained universes based on dimensional and relational data models, resolved traps and loops, built aggregate awareness and derived tables
• Built DB2 stored procedures, performed SQL query tuning and data validation to improving query performance
• Worked on Tableau Dashboards and stories to answer business needs
• Created story board to determine market level sales trend drillable to store level within each selectable product category
• Used bar charts, Pie charts, Heat Maps, Motion charts to show historical sales trends progressed over a periods of time for a selectable customer segment.
• Led and managed a team of 2 developers to deliver assignments on time
• Built complex reports in WEBI using functions such as Forcemerge and Ranking, Performed Conditional Formatting, Report Automation using BI Scheduler, Report Drilling and Linking, Data Tracking etc

Environment: Business Objects XI 3.1/4.2, Tableau 9.3, CMC, CCM and DB2, Sql Server

Confidential

Sr. BI Architect

• Installed and fine-tuned SAP BI 4.2 environment, upgraded from BO XI R 3.1.
• Migrated content from 3.1 to 4.1(using Upgrade Management tool), Migrated content from BI Dev to Test/QA to Prod using promotion management tool, worked on version management, Performed server configuration on CCM/CMC, Scheduling, Publications
• Universe development using Designer - UDT(Universe designer) and IDT(Information design tool - including multi source universe)
• Worked on Tableau Dashboards, worksheets and stories as part of dashboard development.
• Created complex reports using web intelligence and crystal reports for signing player (minor and major league) contracts, Player score cards, Status and availability etc.
• Built reports from JSON as a data source using CDATA plugins (3rd party) to build complex crystal reports saving cost of maintaining intermediate layers.
• Built universes using DB2 and oracle data sources based on dimensional and relational data models.

Environment: Business Objects XI 3.1/4.2, Tableau, Crystal reports 2008/XI/Enterprise,DB2 and Oracle.

Confidential

BO Architect/Sr Developer/Admin

• First hand requirements gathering from business and documenting
• Business Objects complex Report development using WEBI and Crystal Reports, lead a team of 3
• Hands-on experience with Import Wizard, Upgrade Manager, Promotion management, version management to support content management across BI landscape(dev-test-prod), administering users & security via CCM, CMC, Migrated content from BO 3.1 to BI 4.1
• Universe Development using IDT/UDT, Built audit data reporting, data validations on Toad
• Scheduling, Monitoring and Publishing BI content across cross company and clients - Published standing orders purchase receipts to clients and vendors by leveraging BO Publishing feature
• BO Server/web server administration - bouncing, configuring settings as needed to maintain stability
• Implemented Event based Scheduling, ETL Job Monitoring and error rectification
• Data validation against Oracle, Mysql, Postgre and SQL Server databases
• Built real time dashboard using Xcelsius, Live office and QAAWS to answer transportation department data needs for tracking food truck delivery status and truck loading schedules
• Providing business objects end users support thru Service desk ticketing system
• Used Erwin for modeling data of (requirement analysis and database design) custom developed transactional system worked with data models such as relational and dimensional(built star and snowflake schemas)

Environment: Business Objects XI 3.1/4.1, Crystal reports XI, Web Intelligence, SAP Dashboards/Xcelsius, Live Office, Oracle, Mysql, SQL Server.

Confidential, New York, NY

BO Architect/Lead

• Collection of reporting requirements from Business users, writing design specs, technical specs.
• Extensive Universe development work that Includes working on Linked Universes, custom hierarchies, condition objects, custom LOV’s, aggregate awareness, Implementation of aliases, contexts, resolved loops and traps(chasm/Fan), worked on Information design tool - IDT(BO 4.0).
• Lead a team of six folks.
• Implemented ‘ALL’ functionality with in LOV to have the user selected all the list of values presented at one click selection
• Implemented derived tables for those reports that fall out of the universe schema or those reports that need a quick fix.
• Worked on writing a database functions that rolls up to prior rows in a table to fetch data based on the inputted user value from a WEBI report.
• Implemented row level security at table level (on fact tables ) using a self join that also access a table containing security information
• Worked on reports that brings data from multiple data provides using merge dimensions, resolved query synchronizations and joined queries
• Worked with union queries, cross tab reports, calculation contexts (to mimic excel report functionality in BO - A block of data that has multiple dimensions has to be sorted on a single measure without affecting the prior sorted column)
• Worked on charts, filters, drill reports, linked reports(Open doc and Hyper linking through interactive reporting), sorting, sectioning, alerting, ranking, complex report formatting using various WEBI formulas, scheduling reports, profiling and publications thru CMC
• Extensive data validation and testing reports on Oracle database by writing SQL on Toad
• Dashboard development Using Xcelsisus 2008.
• Worked on both live office and QAAWS for brings data in to Xcelsius area (as data connectors).
• Worked on BEx designer and building universe based on BEx queries.
• Converted DESKI reports that has VBA Macros in to WEBI reports.
• Managed a team of 6 developers, work delegation, meeting timelines, adhering to the assigned time and budget.
• Worked on Oracle custom functions, stored procedures, cursors and triggers.
• Installation, sizing, patching, Server Administration, Security implementation - row level, folder level, managing user groups security and authentications etc.
• Working as a subject matter expert in proving reporting solutions to the business and developers.
• Exposure on query transformations using BODI - SAP data Integrator
• Configured, setup and worked through various data flows using SAP data integrator.

Environment: Business Objects XI 3.1/4.0, SAP BI 7.0, Crystal reports, Web Intelligence, Rich Client, CMC, Informatica, Xcelsius 2008, QAAWS, BODI - Data Integrator, Live Office, SQL Server, Oracle 10G/11G, TOAD, Windows 2003, Unix, Shell scripting

Confidential, Warren, NJ

BO Architect/Sr BO Developer

• Leading end to end business objects development and maintenance activities.
• Managing offshore/onsite model, delegating work to resources, assigning tickets to respective teams, managing development changes through change control model tools such as JIRA and RFC.
• Developed various report/dashboards using Excel - Live office, Xcelsius, QAAWS, WEBI, DESKI and rich client,
• Lead a team of three folks.
• Developed and maintained universes, xcelsius dashboards, BO reports, folders and security within.
• Worked on dashboards that required add-ins from cinnegon solutions - Reverse selector
• Scheduling reports, Managing scheduled reports and extracting report info using Activity Universe and Connect Stats Universe to track older report instances in order to save server space and usage.
• Managing complete life cycle - Implementing ETL changes in to BO universes and updating depending reports.
• Involved in discussions on ETL changes, DB changes, new BO development and Implementations.
• Preparing development and Impact analysis on new and existing universes/reports vs ongoing changes that happens on ETL side n monthly/weekly basis.
• Meeting project deadlines, supporting end users (PMA group) for reporting related concerns- single point of contact
• Worked on universe changes and WEBI report changes to improve performance by implementing derived tables, adjusting report variables and formulas.
• Developed universes and reports from the scratch as well as modified existing ones to accommodate new ongoing changes.
• Responsible for handling migration requests - consolidation and raising RFC’s
• Integrated BO with Java application called IRIS, implemented open doc functionality facilitating access to BO reports from java bases application using build in security(java token)
• Worked on security administration and server administration.
• Worked on Universes created on stored procedures.
• Setting up meetings as part of BO clean up’s- deleting older report instances, managing unwanted folders and reports, creation of new BO user accounts as needed and assigning access/roles etc
• Worked on data services jobs - Query transformation.

Environment: Business Objects XI 3.1SP2, Crystal reports, Desktop Intelligence, Web Intelligence Rich Client, Xcelsius 2008, QAAWS, CMC, LCM, Oracle 10g, SQL, PL/SQL, Talend, UNIX Shell scripting

Confidential, Pawtucket, RI

Sr. BO Developer

• Analyzing requirements from functional leads/Business users and creating BRP (business requirement portfolio) for WEBI reports.
• Implemented various components, Histogram, Bar/column charts, excel functions and techniques in Xcelsius 2008 (SP2, FP3)
• Extracted data using QAAWS from universes to Xcelsius charts using various excel formulas.
• Resolving point in time data issues and updating the universe accordingly.
• Participating in meetings for ETL changes and BO development updates with management.
• Preparing development analysis and Impact analysis on new and existing universes for ongoing changes that happens on ETL side.
• Worked on Dynamic Sort, Filtered Summary integrating them to Maps, stacked bar chart, Line chart Combinational charts and column charts, Dynamic visibility, extracted data using QAAWS.
• Worked on Universe changes and WEBI report changes to improve performance by implementing derived tables, adjusting report variables and formulas.
• Worked on aliases and creating contexts to reflect on going changes to avoiding loops and traps.
• Worked on creation of date related filters in universe such as “Prior fiscal to last month of the fiscal year”, “Current fiscal to last month of the fiscal year”, “Prior fiscal to current fiscal month + 2 (of prior fiscal year)”, “Current fiscal to current Fiscal month + 2 “ Etc
• Implemented hierarchies, Prompts, derived tables, data base views where every necessary.
• Extensive worked on linked universes spanning multiple business domains such as logistics, finance, sales, inventory control and sales.
• Creating new universe objects, update measures from MDR (Meta Data repositories), updating SQL for obsolete objects in universe (used @select and @user commands)
• Worked on SCD1, SCD2 (replacing tables projecting SCD type 1 in universe with the views projecting SDC type 2(Historic data)), developing a new history classes, established new joins and contexts
• Worked on Creating Mandatory filters on classes in the universes, Implemented cascading prompts.
• Managing the universes between dev, test and prod environments reflecting ongoing changes.
• Worked on WEBI reports with complex filters, multiple queries, complex variables, polished formatting
• Validation of WEBI reports against SQL Server 2005 and 2008 Databases and resolving data issues.
• Developed linked reports (Open Doc Functionality in previous versions)
• Worked on various WEBI reports using calculation contexts, applying almost every available formatting feature, ranking, sorting, breaks, prompts, sub-queries, data tracking, Alerter(s), creating complex formulas/variables, projecting charts, cross tab reports, drill down reports, fold option (available after XI 3.1 SP2), Merging dimensions, various WEBI functions such as "User response", "NO filter", "Drill filter", "Force merge", "Prompt summary", "Running count" etc

Environment: Business Objects XI 3.1SP2, Crystal reports, Desktop Intelligence, Web Intelligence Rich Client, Xcelsius 2008, QAAWS, CMC, Sql Server 2005/2008, SQL, PL/SQL, Informatica, Windows 2003.

Confidential

Support Analyst

• Created, modified/maintained Universe, Created report templates to maintain same standards across all the reports
• Worked on Data mart and Data models.
• Handling tickets rose through Web-Clarify.
• Assigning calls to respective queue, responsible for clearing queues.
• Clarifying process related issues to analysts.
• Handling escalations for expediting issues on priority basis.
• Prepared requirement specification, designed the visual model
• Involved in creating Tables and relationships.
• Created reports using BO functionalities such as Drill Down reporting, Slice/Dice, Master-Detail reporting, sorting, etc.
• Involved in the design/development of Universes, Classes, Objects and Conditioned Objects for Business Analysis and Report Generation.
• Exported Reports to the Broadcast Agent (BCA) and used BCA server to schedule, monitor, and publish the reports.
• Involved in BO Administration - authenticate users, provide privileges, and make resources available to users through repository.
• Involved in creation of Stored Procedures and VBA procedures to retrieve the data faster and generate the reports quickly.
• Involved in training users in Business Objects.
• Installed and configured Business Objects XI Suite
• Created, modified/maintained Universe
• Created and maintained Business Objects & web Intelligence and Crystal Reports.
• Developed sub reports, writing complex formulas, conditional formatting and working on Command Objects.
• Preparing Work Schedules & Traceability Matrix.
• Involved in Network operations such as configuring TCP/IP, DHCP, DNS on servers.
• Configuring network drives and access privileges for NT servers.
• Administered user accounts for windows users as well as BO users.
• Involved in code review, created Active X components using Visual Basic
• Preparation of Manual Test Plan
• Programming user interface screens using C, C and Java Technologies.
• Implemented Search Algorithms for various Sort techniques used.
• Test Script Reviews and Documenting Test Results and Automation Test Scripts

Environment: Windows 2000 Server, Business Objects 5.x OLTP.,ASP, SQL Server and Win Runner Windows 2000, IIS 5.0, ASP, C, C++, Java, Commerce server2000, SQL Server, VB 6.0, COM, HTML, DHTML, MS Visual SourceSafe, VBA, Excel