SUMMARY:

• An experienced and highly motivated IT professional, with 12+ years of experience in analysis, architecture, design, development, testing and support of Business Intelligence products and services (Tableau/ Business Objects/ Informatica).
• Hands on experience in administration, managing, designing, modelling, development and testing of enterprise wide reporting systems.
• Strong data architecture, business requirement analysis using Agile methodologies. Enjoys leading, motivating and being part of a specialized team, bringing strong leadership qualities, equally comfortable working on own initiative.
• Possesses exemplary technical problem solving and negotiation skills and accustomed to delivering results under considerable pressure, remaining calm and effective and prioritizing wisely.

AREAS OF EXPERTISE:

• Data Visualisations Design & Implementation
• Visual Analytics
• Report Design & Development
• Universe Design & Development
• Performance Management
• Installation
• Configuration & Maintenance of Reporting Environments
• Data Warehouse/Data Mart Design & Implementation
• Data Modelling
• Business Analysis
• Project Planning & Management.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g, SQL Server 2000/2005/2008, Teradata v2r6, DB2

BI Tools: Tableau, SAP BO BI 4.0/4.1, Business Objects (6.X/XI R1/R2, XI 3.0/3.1), SAP BO Analysis, Crystal Reports XI/2008/2013, Xcelsius 4.5/2008, Informatica 9.1/9.6, Live Office, QaaWS, Promotion Management, Import Wizard, Report Conversion Tool, SAP BI 7.0, SAP HANA, SAP BW 7.4

Query Tools: TOAD, Teradata SQL Assistant, Rapid SQL, PL/SQL Developer, Oracle SQL Developer

Modeling Tools: VISIO, Erwin

Web Development: MySQL, PHP, HTML, CSS, Flash, Macromedia Dreamweaver, Adobe Photoshop

PROFESSIONAL EXPERIENCE:

BI Consultant - Tableau Specialist

Confidential, NY

Responsibilities:

• Worked with the C-Suite and helped them with analyzing Sales Operations Metrics.
• Created dashboards for senior Executives to track multiple KPIs in Accounting and Finance.
• Conducted source data analysis, performed data profiling and synthesized data for developing visuals.
• Spearheaded the discussions and strategized data sources from SAP BW to flow into Tableau workbooks/ dashboards.
• Created overall project plan and timelines for key deliverables; owning all deliverables against timelines.
• Lead the development of data delivery processes to enable self-service analytics where possible.
• Implemented incremental Data Extracts and scheduled to update in certain frequency.
• Incorporated different actions on worksheets/dashboards to increase interactivity.
• Designed and built dashboards with data security to restrict data different audience.
• Authored documents for business requirements and transformed them to technical specs and trained users using Tableau at different levels.

Environment: Tableau 10, Cognos, Oracle 11g, SAP BW, Windows 2012 Server

BI Lead

Confidential, New York, NY

Responsibilities:

• Led multiple teams for new initiatives, enhancements and support of BI in Corporate Office of Technology.
• Engineered automation process for various report batch runs and helped the organization to make better decisions.
• Interacted with business users to understand their requirements, analyzing the available data to build Tableau Dashboards.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, Agents performance, strength & weakness for the client at a glance, also interact with data as necessary
• Created Tableau Data Extracts for improving Performance and giving flexibility for different users in using worksheets.
• Converted multiple reports/worksheets from Excel into Tableau visuals/ Dashboards and automated the same.
• Built Universes for canned and ad-hoc reporting requirements.
• Created Auditing reports for various purposes like User activity, Query performance.
• Debugged several data issues using Informatica Mappings & Sessions.

Environment: Tableau 9, SAP BO BI 4.1, Business Objects XI 3.1, Informatica 9.6, Oracle 11g, IBM DB2 9.7, SQL Server 2008, Windows 2012 Server

Sr. Consultant - Business Intelligence

Confidential, New York, NY

Responsibilities:

• Designed and Developed Reporting platform for Market Risk space.
• Led a global team from India & Poland for Development and ensured timely deliverables.
• Reconciled the reporting to a more strategic and transparent platform and met Regulators requirements.
• Synthesized the data and developed reports/ visuals for C-Level Executives using Tableau.
• Trained users in creating Tableau worksheets and visualizations.
• Interacted with Users and suggested best solutions for having a robust reporting platform.
• Provided support for Users creating report schedules, data connections, projects and groups in Tableau server.
• Maintained Tableau repository by creating backups using Tabadmin and Tabcmd commands.
• Automated scheduling of reports using control-m and improvised ad-hoc capability for Users.

Environment: SAP BO BI 4.1, Business Objects XI 3.1, Tableau 8, Oracle 11g, PL/SQL Developer, OBIEE 11g, Oracle SQL Developer

Sr. Business Intelligence Consultant

Confidential, New York, NY

Responsibilities:

• Active participant of ‘Navigator Suite’ Product development team which has content-rich dashboards & scorecards.
• Instrumental in developing visuals for consumer and small business deposits and payment customer level performance at a Financial Institute using Xcelsius 2008.
• Created visualizations across various products like Consumer Credit and Debit Cards with different borrower demographics, creditor FICO and Commercial Credit Ratings.
• Created Dashboard Analytics (Single Metric Gauges, Speedometer, Barometer, Traffic Lights, and Interactive metric trends) using Dashboard Builder and extensively used QaaWS and Live Office to retrieve the data from the universe objects.
• Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.
• Incorporated new Xcelsius components like Print Button, Connection Refresh Button, Reset Button, and Trend Icon.
• Validated data by writing scripts (stored procedures) for the visuals used in the product.

Environment: Business Objects XI 3.1, SQL Server 2008, QAAWS, Xcelsius 2008, Windows 7, Windows 2008 Server.

Business Intelligence Tech Lead

Confidential, New York, NY

Responsibilities:

• Led a team of 4 for carrying out the reporting assignments.
• Interacted with users for analysis of reports, documented user requirements and developed technical design specification document.
• Involved in the design of Data Warehouse and Data Mart.
• Developed Informatica Mappings, reusable mapplets, sessions and workflows to load data from Oracle data warehouse into the Data Marts.
• Designed, developed & documented new Universes and created reports using Web Intelligence Rich client.
• Conducted POCs to ensure technical feasibility of visual representation of data.
• Designed, documented & developed Dashboards using Xcelsius using QaaWS
• Guided application developers in creating a web interface for viewing Dashboards.
• Trained/ Tutored users on usage and functionality of dashboards.
• Interacted with offshore team conducting peer document testing adhering to guidelines.

Environment: Business Objects XI 3.1, Oracle 10g, Rapid SQL, Informatica 8.6, TOAD 8.5, Crystal Reports 2008, QAAWS, Crystal Xcelsius 2008, Window XP, Windows 2003 Server.

Sr. Business Intelligence Consultant

Confidential, Orlando, FL

Responsibilities:

• Design and Implementation of $8 MM Business Intelligence and Data Warehousing solution for the Merchandise line of business as part of a $40+ MM Oracle Retek implementation.
• End to end design of the solution and the delivery of 150+ operational, tactical and strategic reports, visuals/ dashboards, and the foundation for advanced analytics.
• Built complex reports using multiple data providers and extensively used OpenDoc to call child reports from parent reports.
• Interacted with testing team to derive test scripts.

Environment: Business Objects XI R3.1,BO SAP Integration Kit, IIS, Oracle 10g, Teradata, SAP BW, TOAD 8.5, Crystal Reports XI, Crystal Xcelsius 2008,Quality Center 9.2, Window XP, Windows 2003 Server.

Business Objects Administrator/ Migration Specialist

Confidential, New York, NY

Responsibilities:

• Conducted meetings for implementing a Confidential architecture for deploying Business Objects across the organization.
• Migrated various applications from 5.1 & 6.5 to XI R2 and provided support to new Environment.
• Configured servers in XI R2 for Development, Test and Production environments and created group structure
• Recreated complete security model in XI R2 at enterprise level.
• Involved in day-to-day Business Objects Server maintenance.
• Conducted end user training sessions and prepared training material.
• Trained users in basic & advanced reporting functionalities, creating Ad-hoc reports for analysis.

Environment: Business Objects 5.1, 6.5 & XI R2, Web Intelligence, Desktop Intelligence, TOAD, Oracle 10g, MS SQL Server 2005, SQL, PL/SQL, Windows Server 2003, AIX

Business Objects Administrator

Confidential, Dallas, TX

Responsibilities:

• Installed and configured Business Objects XIR2 and applied subsequent patches.
• Created CMS, PM and Audit Databases on SQL Server 2005.
• Configured Central Management Server (CMS) Cluster on Windows 2003 server.
• Extensively used Central Configuration Manager (CCM) for Administration and Central Management Console (CMC) for Folder Level security set-up, Report Scheduling, Users, User Groups, Servers and Server Group administration.
• Created users and revised Group Structure in Development and Production environments.
• Automated bulk report scheduling using APOS InfoScheduler.

Environment: Business Objects XI R2, Crystal Enterprise XI/X, SQL SERVER 2005, Oracle, Web Intelligence XI R2, Windows Server 2003

Reports Analyst & Web Developer

Confidential, Jackson, MS

Responsibilities:

• Maintained Orders, Inventory reporting for Department of Biology.
• Created reports for expenses of Research Fellows
• Created balance sheets of Federal grants for various research initiatives.
• Developed website of Student Organizations and Student publications
• Managed and designed content for various articles
• Published Newsletters and Magazine contents for various events.

Environment: MySQL, PHP, HTML, CSS, Flash, Macromedia Dream viewer, Adobe Photoshop, Windows, Mac OS