SUMMARY:

• Over 10+ years of professional work experience in System analysis, Design, Development, Implementation of Relational Database based Data Warehouse and Client/Server Applications.
• Expertise in Tableau 7, 8, 9 and Business Objects 4.0, 4. 1, 4.2 and SAP Business Intelligence 7.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Hands on experience on Tableau Desktop versions 7/8.2/9, Tableau Reader,Tableau Server and Administration.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Extensive experience working on Business Objects 4.2/4.1/4.0, Releases XI R2/3.1/4.0 SP2, SP4 and SP5 (CMC, CCM, CMS, LCM, Promotion Management, Information Designer tool, Business Intelligence Consumer Services (BICS), Universe Design (Unv and Unx), Web Intelligence 4.0, Business Intelligence Web Services (BIWS), Report Conversion Tool, Crystal Reports 2001, Dashboard Design using Xcelsius, Live Office, Query As a Web Service (QaaWS), SAP Business Objects Explorer, Good understanding of BEX.
• Strong work experience in Dimensional Modeling, and designing Star and Snowflake Schemas, Fact and Dimension tables.
• Experience in using Information design tool (IDT), to create universes using multiple Data Sources.
• Experience in Designing/Developing Universes/Data - Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports.
• Strong experience as Business Objects Administrator including installation, configuration of BO tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.
• Efficient in Optimizing, Debugging and testing SQL queries with Databases like DB2 9.7/9.1 SQL Server 2012, Oracle 11g/10g, Sybase, flat files and Teradata
• Excellent Experience in Oracle PL/SQL and T-SQL Programming (Stored Procedures, Functions, Packages, Cursors and Triggers).
• Expert in UNIX Shell Scripting.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with Latest technologies.
• Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 8.1.1/7.1.2/6.1/5.1.2/1.7/1.5, PowerMart 5.x/4.x (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations), ETL, Metadata, Data Junction, Data Mining, Datamart, OLAP, OLTP, SQL*Plus, SQL*Loader, IBM Information Server DataStage and QualityStage 8.1.1,Ascential DataStage EE 7.X/6.5 (Designer, Director, Manager Administrator)Databases: DB2 UDB 9.0/8.1/7.2, Oracle 11/10g/9i/8i/7.x, Teradata, MS SQL Server 2012/6.5/7.0, MS Access 7.0/ 97/2000,Sybase.

Reporting Tools: Business Objects 4.2/4.1/4.0/XI R3.1/R2/6.5/5.1, Tableau 9/8.x/7, Power Analyzer 4.1/3.5, Jasper Reports, Cognos Impromptu, Transformer and Power Play, Data Reports, Crystal Reports 6.x/5.x/4.x/3.x, MS Access Reports.

Programming: C, C++, Java, JSP/ASP, JavaScript, SQL, PL/SQL, ISQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, Pascal, HTML, DHTML, Unix Shell Scripting, Perl.

Designing Tools: UML (Rational Rose), MS Visio, Erwin, MS FrontPage

Environment: Sun Solaris 2.6/2.7, HP-UX, IBM AIX 4.2/4.3, MS-DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT 4.0, SCO Unix, HP9000.

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

Senior Business Intelligence Developer/Analyst

• Interacted with Business Users and Managers in gathering business requirements.
• Proposed Best Practices for Universe optimization, Report review and created the ETL/universe mapping document.
• Designed and Implemented universes for Encounter, CSAT, Mass Outreach Suggestions, Surveys, Scorecards.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Migrated & upgraded Business Objects from 4.1 to 4.2 and establishing BO environment for dev, UAT and production servers.
• Performed testing of the reports after the upgrade from 4.1 to 4.2
• Worked on the conversion of universe from UNV file to UNX file using IDT.
• Worked on the conversion of the reports to point to the new Universe (UNX).
• Tested the reports with the new universe after conversion in development environment.
• Worked with end users to create reporting templates and mock ups.
• Participated in the complete development lifecycle: analysis, design, build and test reports
• Created several complex Web Intelligence Master Detail, Cross Tab, linked, unlinked reports using filters, Sorting, Groupings based on different fields.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Created User Prompts, Conditions and Filters to improve the quality of report generation.
• Scheduled Reports using scheduler Infoview as well as CMC.
• Performed migration of reports and objects using Life Cycle Manger and Promotion Management Tool.
• Worked on JIRA for issues log, resolving and release plan to UAT, Production environments.
• Responsible to synchronize the QA, DEV environments with Production during release and upgrade.
• Involved in Unit testing, System Integration testing and User Acceptance Test, throughout conversion process.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

Environment: Business XIR4.1/XIR4.2 (CMC,CCM,CMS, UDT, Web I, BI Launch Pad, Information Design Tool), Tableau Desktop, Tableau Server, JIRA, Microsoft SQL Server 2012, MY SQL Workbench, PLSQL Developer, Windows 2000 Server, Erwin 4.0, MS Visio, HP Quality Center (QC) & Service Manager.

Confidential, Washington, DC

Senior BI/Tableau Developer

• Participated in project planning sessions with Project Managers, Business Analysts, DBA and team members.
• Gathered, analyzed and documented Business requirements, clarified Business rules and data design requirements, functional requirements and data specifications for reports.
• Responsible with 24/7 on call support for Incident Management, Change Management and Production Management tickets.
• Created BIAR File Backups and Performed Weekly Migrations to UAT, SIT, Pre-Prod and Production.
• Extensively worked on Content Level Security and Application Level Security to manage end user rights.
• Designed and validated universe from multiple data sources with SAP BI4 Information design tool.
• Created IDT views for better maintence of Joins.
• Created Derived tables and used @prompts for reusability at reports.
• Extensively worked on performance turning of the Reports, Universe and servers.
• Involved in documentation for the mapping, technical specifications, data validations and Test cases.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Involved in training session for Business and IT knowledge transfer sessions.
• Involved in migration and deployment of the universes and reports across multiple domains.
• Tuning the Adaptive processing servers as per the BI requirements.
• Upgrade the Development, Stage, Test and Production Business Objects and Explorer servers from BI 4.1 SP5 to BI 4.1 SP6 Patch4.
• Responsible to synchronize the QA, DEV environments with Production during release and upgrade.
• Involved in Unit testing, System Integration testing and User Acceptance Test, Government Acceptance Testing (Universes and Reports) throughout conversion process.
• Designed and Implemented Securities, Portfolios, Transactions, Subledgers and Pricing reporting and Universe.
• Worked on AutoSys Schedling for Webi reports scheduling.
• Proposed and documented Best Practices for Universe and Report Design.
• Involved in creating documentation for Business Requirement and Functional Specifications, Data Validation Scripts, Database Attribute Crosswalk, Performance Tuning, Test Cases, Universe Attribute Mapping, Issue Log, Release Plan Presentation, Data Dictionary, Object and Tables Mapping, Best Practices for Universe, Reports and Xcelsius Dashboards.
• Responsible for Universe & Report Testing, Query Optimization, and Performance Tuning during upgrade.
• Created 5+ complex universes using IDT and 60+ Operational and Business reports.
• Created Solution Specification, Report Requirement and Attribute Mapping Documentation.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis Published Workbooks by creating user filters so that only appropriate teams can view it.
• Embedded Tableau views in to SharePoint.
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports. Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards with combination charts for clear understanding.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics.
• Developed Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Extensively used data blending, embed functionalities in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Environment: Business Objects R3.1/XIR4.0/XIR4.1 (CMC,CCM,CMS, UDT, Web I, BI Launch Pad, Information Design Tool), Tableau 9, Enterprise Performance Manager (EPM), PL/SQL, Oracle 9i/10g/11g, Crystal Reports 2008/2011, Teradata V2R6.1, Microsoft SQL Server 2000/2005/2008, TOAD, PLSQL Developer and Windows 2000 Server.

Confidential, Boston, MA

Senior Tableau Developer/Analyst

• Analyzed existing database schemas and designed star schema models to support the users reporting needs and requirements.
• Met with end users for gathering user requirements and documented the rules and specification document for development of the reports.
• Assessed requirements for completeness & accuracy and provided technical leadership in the Design and the Development and Testing Phases of the SDLC lifecycle for the implementation of reporting solution.
• Designed and Developed Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases etc, and also Developed Hierarchies to support users with the option to drill down on reports.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created User Groups, assigned Folder level Security, and maintained the environment using CMC.
• Defined security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
• Design and Develop Complex Webi reports using Variables, Drill Downs, Sections, breaks, and Merged Dimensions etc.
• Worked on cross-tab and master detail report and created line charts, bar charts etc.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design,development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Documented and presented the production support documents for the components developed to the production support team
• Developed training modules and conduct training sessions.

Environment: Business Objects 4.0, Tableau Desktop 8.0, Tableau Server 8.0,Informatica PowerCenter 9.x, Control M 6.4, Unix AIX, PERL Windows XP, Oracle 10g/9i (DBArtisian 8.7 / SQL Developer), Erwin 4.0, SQL Server 2008, MS Visio, HP Quality Center (QC) & Service Manager.

Confidential, West Greenwich, Rhode Island

Senior BI/Tableau consultant

• Involved on the implementation strategy and designs for individual projects based on functional requirements and project objectives.
• Involved in complete SDLC lifecycle for the implementation of reporting solution for Lottery Users.
• Involved in requirements gathering, system requirements and creating technical design specifications based on Client functional specs, the documents for the ETL process include extraction of source data, transforming data, validation of data integrity, loading to the data warehouse, data reconciliation and archiving of data according to the project specification.
• Involved in Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
• Created and maintained Data Dictionary and pursued to reach consensus.
• Created report specifications containing mapping to the data sources.
• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Created a Prototype data warehouse and provided the OLAP front end to show the Drill Down, Roll ups, Slice and Dice features.
• Responsible for evaluating and incorporating emerging standards, best practices, and new technologies.
• Build the new universes as per the user requirements by identifying the required tables from Data Warehouse and by defining the universe connections.
• Created Classes, Objects, Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the universes.
• Streamlined SQL generation from Universes by implementing Aggregate Aware functions and @ Variables.
• Created Filters, @prompts and setup Hierarchies for Multidimensional Analysis.
• Assigned @ BO Variable to implement User Level Security, Assigned Hierarchies to facilitate Drill Down and Scope of Analysis Accordingly.
• Provided various management level reports for retailers and chains.
• Created Xcelsius Dashboards for Sales and Product level data based on Calendar Month & Usage using various components of Xcelsius.
• Created WSDLs using QaaWS (Query as Web Services) and implemented into Xcelsius dashboards.
• Created report having multiple hyperlinks to various reports using Open Document functionality from parent to child Webi Report.
• Performed Data Analysis and Data validation by writing complex SQL queries.
• Worked with DBA to create aggregate tables and views to meet the report specification requirements and improve the performance of the query.
• Tuning of SQL queries for better performance of reports.
• Resolve difficult design and build issues, troubleshoot bugs and optimize report performance.
• Scheduled, Published and Distributed the WEBI reports.
• Administered the BO activities and provided the security access management by creating users/groups and folders.
• Migrated existing user accounts, groups, categories, Webi documents, universes and connections to other environments (QA, CAT and production).
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Prepared high level Test Plan, and detailed Test cases based on the System /Business requirements
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Regularly synchronized the QA, DEV environments with Production reports.
• Responsibe to talk to business users and finalize on any enhancements/new requirements needed by the Client.
• Provided support to Lottery users to resolve user questions, issues concerning report.
• Developed data dictionary and universe user documentation guide for the end users reference.
• Provided training for end users for generating their own report including complicated report.
• Installation the Business Objects suite, test, validate and apply service packs, hot / critical fixes on UNIX and Windows OS to stabilize Server environments.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Environment: Business Objects XIR2/R3, Tableau 8.1/7, Xcelsius 2008, Designer, Desktop Intelligence, Web Intelligence, CMS, Informatica PowerCenter 8.6.1, DB2 9.0, SQL, PL/SQL, Linux, Windows 7/XP

Confidential, Parsippany, New Jersey

Senior ETL Developer/Analyst

• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Involved in Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases, Trouble shooting guide, created functional and technical requirements documentation and Data Migration Document
• Analyzed requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using Visio.
• Developing the documentation and plan for transformation and loading of data into Warehouse.
• Involved in requirement gathering, system requirements, and data modeling, and designing the documents for the ETL process according to the business requirements.
• Worked on Informatica PowerCenter 8.1.1/7.1.2/6.1.2 Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and update strategy.
• Use of Trillium External procedures (AEP) to standardize the address coming from the source and loading the data into tables.
• Involved in development of Informatica mappings and also performed tuning for better performance.
• Wrote UNIX Shell Scripts to ftp files from remote system, merge the files into single file and defining parameters, moving, renaming and deleting files and performing other rules.
• Involved in different Team review meetings.
• Tested all the applications and transported the data to the target Warehouse DB2/Oracle tables.
• Schedule and run extraction and load process and monitor Workflows and Worklets by using Informatica Workflow Manager.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Extensively involved in Fine-tuning the Informatica Code (mapping and sessions), SQL to obtain optimal performance and throughput.
• Wrote Stored Procedures for cleansing, formatting data and creating unique identifier for batch processing to retain the value through out the process.
• Provided Level 2 & 3 Support for Production team & concerns raised by Business/End users.
• Worked on Business Objects to create users and defined security, Created universes and added the classes, objects and schemas required for creating Sectional, Tabular and Cross Tabular Reports.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @aggregate awareness, Custom sorts, Cross Tab, and Formulae's etc.

Environment: Informatica PowerCenter 8.1.1/7.1.2/6.1.2, Business Objects XIR2/6.5.1, Web Intelligence, UNIX AIX, WindowsNT, DB2 8.0 (Quest Central 3.1), Oracle 10g/9i (Toad 7.4), Informix, MS SQL Server, Trillium, Erwin 4.0, MS Visio & Office.

Confidential, West Greenwich, RI

Data Warehouse/BO Consultant

Responsibilities:

• Analysis of Source, Requirement, existing OLTP system and Identification of required dimensions and Facts from the Database.
• Involved in analysis of end user requirements and business rules based on given documentation and worked closely with tech leads and Business analysts in understanding the current system.
• Interacted with end users in documenting business requirements, Report specifications and Non Functional Requirements.
• Analyzed the business requirements and wrote Test Plans and Test Cases.
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to DB2 tables.
• Involved in designing and development of BI System using Business Objects Designer, Reporter and Supervisor.
• Created & Modified Universes for various functional areas of high level reports group using Designer.
• Customized LOVs in Universes for quicker performance of reports. Created Joins, Contexts, and Aliases for resolving Loops & Universe Tuning and checked the Integrity of the Universes
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, and Formulae's etc.
• Created reports according to different requirements Such as Summary Charts etc Using Wizards and Web intelligence2.x.
• Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the reports.
• Used Supervisor, Info View to manage Users etc .
• Enhanced and maintained the existing reports.
• Created various analytical reports like Sales, Trending, Rank reports from multiple data providers.
• Involved in different Team review meetings.
• Developed data dictionary and universe user documentation guide for the end users reference.
• Performed Data Analysis and Data validation by writing complex SQL queries.
• Did Unit Testing and tuned the reports queries and design for better performance.
• User/System Documentation, User training and testing developed reports for final deployment.
• Provided end user support and problem resolution for various issues related to BO.
• Created complex reports by using Jasper Reporting tool.
• Implemented the Filterable Data Source concept for designing the reports that are based on a large data set, subsets of which are needed for individual sub-reports. Performance of reports was improved.
• Maintaining backup of the developed objects (reports & universes) in PVCS Version Control tool for deploying the code in QA & PROD.

Environment: Informatica Power Center 6.2/5.x, Business Objects (6.5/5.1), PL/SQL, IBM Web Sphere AE 4.0.5, AIX, DB2 UDB 7.2/8.1, BEA Web Logic Server 6.1, MS Windows, Jasper, MS Visio, PVCS (Version Control).