Sr. Business Intelligence Data Warehousing Consultant with expert skills in Design, Analysis, Architecture, Administration, Development of Business Intelligence applications in Business Objects, Tableau, MicroStrategy, on Windows and Linux platforms
Over 13 years of IT experience in application development and providing Reporting Solutions in transactional and data warehousing environments and around 2 years of experience with OTC workflow process including creating Revenue Management reports and OTC workflow metrics and dashboards
Seasoned SAP Business Objects Consultant with 9 plus years of experience in Designing, Developing and Implementing Reporting Systems, around 2 Years into MicroStrategy and 2 years of Tableau.
Well versed and experienced on various ETL activities including target to source mappings, data cleansing, transformation & Integration, and data modelling with help of tools like ERwin
1-year experience into Big Data Analytics including Hadoop (Cloudera, Hortonworks), Hive query language, Spark, Bit Bucket, & Python etc.
Proven expertise in different modules of SAP BO Products Suite that includes Business Objects / Desktop Intelligence reports, Designer, CMC, InfoView, WebIntelligence, SAP BI/BW, Bex /MDX queries, Xcelsius 4.5, Xcelsius 2008, QAAWS, Live Office
Right blend of business and technology expertise with leadership, interpersonal communication, analysis, design, implementation, and integration skills in providing enterprise-wide Business Intelligence solution
Expertise in migration, version control, developing and testing Business Objects products including server and desktop products
Excellent working knowledge and experience of Databases, Data Warehousing concepts and proficient in reporting
Expert in trouble shooting issues and Installation & Configuration of Business Objects Enterprise product Suite
Business Intelligence & Data warehousing tools
SAP Business Objects Enterprise, Tableau, MicroStrategy, MySql Workbench, Erwin 7.x
SAP BI Suite
Web Intelligence, Xcelsius 2008, 4.5, QAAWS, XML, LiveOffice, BI Services, Crystal Reports XIR2, Business Objects XI R2 integration with SAP BW/BEX Queries, Business Objects Designer, Xcelsius 4.5 / Xcelsius 2008, SAP BW, SAP ECC tables, UDT, IDT
SAP, Zuora, RevPro
C, Python, HTML, DHTML, SQL, PL/SQL, HIVE Query Language (HQL), COBOL
Teradata, Oracle 10g/11g/12i/19.x, SQL Server 2000/2008/2012, DB2, MS-Access, MYSQL
AWS, Tableau, MicroStrategy, Cloudera, Spark, Cloudera, Hortonworks
Web Application servers
IIS, Apache Tomcat Server
Windows2003/2000/98/95/NT 4.0/XP/10, UNIX, LINUX REDHAT Release 6.2
Domains worked in
Entertainment, Consumer goods, Real Estate, Energy, Railroad &Public transportation, Manufacturing, Federal (USDA), Software & Hardware
WISHLIST FOR YEAR 2020
· Tableau Desktop Specialist – Associates Certified
AWS Solution architect - Associates, Professional
· AWS Cloud Practitioner – Certified
AWS Data Analytics
· Zuora Administrator Certified
Bachelor’s in computer science (1998 – 2001)
Master’s in Business Administration (2001 – 2003): Marketing management, Finance
Zuora – Boston, MA 05/18 – till date
Senior BI Lead
Zuora is an enterprise software company that designs SaaS applications and sells access to these applications, using a subscription business model, to client companies. Zuora’s applications are designed to automate billing, commerce, and finance operations. I am part of the Zuora Revenue team as a techno- functional analyst and a Datawarehouse developer responsible to architect, design, configure data solutions
Help implement OTC (Order To Cash) KPI metrics dashboards using Tableau 2018.x
Collect requirements for the revenue recognition of the company, document use cases and meet with the clients to confirm the finalized technical layouts and designs.
Involved in various business meetings to analyze and document the business requirements and impacts from Order Management, Credit Management, and Supply Chain Management
Created orders and subscriptions test data in Zuora central for testing the integration along with preparing custom templates
Documenting workflows, design documents, functional specifications as part of design process in an Agile environment
Actively participating in sprints and consistently be part of all stand up meetings and a thorough documentation procedure
Implementing 5 steps of Revenue recognition principle at the client place and wherever applicable, recommending best practices to the client, conducting workshops for Key decisions so that the business has all the required information to take the most effective decision to better their policies in regard to their systems, accounts, revenue recognition approaches etc
Worked with different groups to coordinate on various changes and analyzing dependencies and impact analysis
Designed, developed various reconciliation reports to balance the sales figures with the revenue and various other reports like Billing report, Booking report, Events and Revenue Summary reports, Accounting reports, revenue Waterfall reports etc.
Designed tableau dashboards for clients using features such as global filters, calculated fields, maps, area charts etc.
Publishing the dashboards on Tableau Server and Scheduled extract refresh for weekly and monthly reports.
Environment: Business Objects SAP BI, Tableau 2018.x, Oracle 12i, Zuora Central, Informatica, SQL Server 2012, Teradata, JIRA etc.
AT&T (Previously DIRECTV) El Segundo, CA 04/15 – 05/18
Senior BI Lead / Architect
DirecTV is an American direct broadcast satellite service provider and broadcaster based in El Segundo, California. As of July 2015, it is a subsidiary of AT&T. Worked with various BI tools such as Microstrategy, Business Objects and Tableau etc. including Hadoop, HIVE query language, Spark, Python etc. Developed various Order to Cash KPI metrics dashboards and detailed Revenue Management reports like Forecast Analysis, Revenue percentage and DSO (Days Sales Outstanding) reports
Lead a team under the Broadcast System Engineering department with a focus on delivering reporting solutions to users across the company using Business Objects, Microstrategy and Hive HQL.
Worked on various projects related to Video-On-Demand reporting, DIRECTVNOW, DFW project, Content management systems, Ticketing systems (Jira/Remedy), Spare level Management and delivered integrated reporting solutions
Also worked closely on the BDAR (Big Data Analytics and Reporting) team to capture the business needs and work on building BDAR aggregated tables on Hortonworks Hadoop clusters. Provided sources for Microstrategy cubes through the HQL scripts and worked on the end reports as well using documents, dashboards, reports in MicroStrategy
Used Erwin tool for building various engineering logical, conceptual, and physical dimensional models
Built hive / external tables on top of hdfs files that are Ingested from various sources such as Amazon S3 bucket, NiFi etc. for consumption in the front-end BI tools
Created crontab entries and documented the runbooks, used bitbucket to backup and version control the code
Involved in interacting with business users, requirement gathering sessions and providing LOEs and project plans
Worked on various Release Summary reports giving scheduled reports every week for the senior management of Broadcast Software Engineering department giving an overall health of the project statuses
Maintained & administered the Development, Staging & Production environments of Business Objects Cluster 4.1 SP4, Microstrategy 10.4
Defined the process of extracting, transforming, and loading the data into system, by defining the functional specifications and testing the programs.
Developed and maintained dashboards / reports and drive performance measurement
Created revenue management reports like Average Revenue per User (ARPU), Average Revenue per employee using SAP Business Objects on top of SAP BW BEx
Created Dashboards for OTC KPIs like Revenue Percentage, Individual Productivity, Calculation of DSO (Days Sales Outstanding)
Maintained the App servers and web servers on LINUX REDHAT O/S
Worked with SAP, Microstrategy to report and resolve product errors or find an alternative design approach in times of technical limitations and to troubleshoot in times of any issues with environment
Environment: SAP Business Objects 4.1 SP4, MicroStrategy, Tableau desktop 2018.xx, Information Design tool, Universe design Tool, Web Intelligence, Dashboard Design tool (Xcelsius tool from Business Objects 3.1), Teradata, Oracle 12i, Query As A Web Service (QAAWS), BICS connection, SQL Server 2012, MYSQL, DB2, JDBC, REMEDY, JIRA, MicroStrategy 10.4, Hive HQL, Cloudera, Hortonworks, Hadoop 2.0, Spark, Python, AWS S3 buckets
The Irvine Company - Irvine, CA 08/13 – 03/15
Senior SAP BW/BI Integration Consultant
The Irvine Company® is a diversified, privately held real-estate investment company and master-planner. Worked in various projects as part of the BI/DW team in handling source data and transforming it into meaningful reports and dashboards. Involved with various projects related to Retail, Office and Apartments divisions of the company including various OTC metrics dashboards and revenue management reports
Involved in the architecture and development of Executive dashboard, Office Key Results, Retail key results, Office Rental rates Analysis Dashboards built on top of BEx queries using BICS Connection
Worked closely with the top management to build most critical KPIs like Health Ratio, Cost Of Occupancy, Guideline rates, etc.
Created various Revenue Management reports like Monthly revenue, Revenue Analysis and Forecast reports
Support and execute data cleansing, migration, and conversion to ensure accuracy of enterprise master reports, transactional data reports
Worked closely with Business to come up with the architecture of "Lead to Lease" reporting solution that traces end to end how the potential customer is converted into an Opportunity and into an Executed Lease. As part of this, several stored procedures, views have been created that are used at the Universe level to build a dimensional model.
Designed Tableau designer to build Leasing dashboards for Apartments division
Designed SAP BW based Webi reports for the Apartments, Office, and retail divisions
Used Dashboard Design tool to design Dashboards in Business Objects 4.0 for the Office division
Worked with SAP to report and resolve product errors or find an alternative design approach in times of technical limitations
Worked closely with BASIS team to translate security requirements and create roles to enable judicious use of SSO Vs Fixed user access
Helped in testing User Security roles in Quality Environment before rolling out the BI solutions at backend level using RSECADMIN and at BOBJ level using Test IDs created with collaboration with the Business Objects administrator
Environment: SAP ERP, SAP BW, SAP ECC, SAP Business Objects 4.0 SP8, Information Design tool 4.0, Universe design Tool 4.0, Web Intelligence 4.0, Teradata, Dashboard Design tool 4.0 (Xcelsius tool from Business Objects 3.1), SAP BW Analyzer, Query As A Web Service (QAAWS), BICS connection, SQL Server 2008, SAP BW 7.0
Sempra Energy - Los Angeles, CA 08/12 – 07/13
Senior SAP BIDW Architect
Sempra Energy is a Fortune 500 energy services company, based in San Diego, Calif., that combines deep industry expertise with rigorous risk management to deliver superior shareholder returns. Involved with Productivity reporting Systems, Advanced Meter Projects which involve developing WebI reports along with Xcelsius Dashboards for the overall Advanced Meter KPIs and they are used to track the Meter Installations and retrofit changes per every warehouse all over the country.
Designed various Xcelsius dashboards for the Advanced Meter project, IT Dashboard etc.
Designed Universes using Information Design and Universe Design Tools (IDT / UDT) for PRS, System Health, Call center
Administration of Business Objects XIR2, SAP Business Objects 3.1, SAP Business Objects 4.0 environments and servers
Used Dashboard Design tool to design Dashboards in Business Objects 4.0 for the Advanced Meter KPI project.
Installed Special packs and Patches, tested the functionalities to make sure all existing functionalities are preserved
Supporting Developers by helping with software installations, Security management, Suggestions on best practices to design universes and reports overall and train users on Web intelligence
Used XML, BI Services, QAAWS data connectivity tools to design Dashboards
Used Information Design tool to create multi source universes in Business Objects 4.0 for Productivity Reporting Systems
Created wrappers to host the Dashboards for Advanced Meter KPI project
Created WebI Reports on top of BEX queries for Device Inspection projects
Converted overall 73 Business Objects XIR2, 3.1 universes, reports, personal documents to SAP Business Objects 4.0
Created audit reports for XIR2 and BOBJ 4.0 environments
Environment: SAP Business Objects 4.0 SP4, SAP Business Objects 3.1, Business Objects XIR2, Information Design tool 4.0, Web Intelligence 4.0, Dashboard Design tool 4.0 (Xcelsius tool from Business Objects 3.1), Query As A Web Service (QAAWS), Live Office, Teradata, CMC, SQL Server 2005, SAP BW 7.0, SAP ERP
USDA, DC 03/12 – 08/12
Senior Business Objects/ Xcelsius Developer
The United States Department of Agriculture (informally the Agriculture Department or USDA) is the United States federal executive department responsible for developing and executing U.S. federal government policy on farming, agriculture, and food. Involved with the Operational Reporting project of the Foreign Agricultural Services (FAS) FAS works to improve foreign market access for U.S. products
Designed various Xcelsius dashboards for the Foreign Agricultural Services (FAS) and OCFO (Office of Chief Financial Officer)
Involved heavily with requirement gathering and a complex analysis for building the Xcelsius dashboards and Web intelligence reports for the Operational Reporting
Involved in multiple working sessions with various users, managers to build prototypes for various dashboards for Financial Management, Budget Vs Actual Comparison, Human Capital Management etc.
Documented Design documents, Technical Specifications documents, Functional Specifications Documents etc.
Involved in the Financial Management Modernization Initiative (FMMI) and passed various tests for the access grants
Worked with customized components and embedded them into Xcelsius 2008 successfully by creatively bypassing technical limitations of Xcelsius limited out of the box components
Environment: SAP Business Objects 3.1, Designer, WebIntelligence, Xcelsius 2008 SP3, Query As A Web Service (QAAWS), Live Office, CMC, SQL Server 2005, SAP BW 7.0
Scotts Miracle – Gro, OH 10/11 – 03/12
The Scotts Miracle-Gro Company (NYSE: SMG) is the world's largest marketer of branded consumer lawn and garden products. The role assigned was a general Business Objects administration and as a team member in several projects that included SAP BW & Business Objects integrated reports along with designing and developing Xcelsius dashboards for the management.
Created Scotts Canada Garden WebIntelligence Reports using BW as a source
Designed, developed Dashboards using Business Objects Dashboard Design 4.0 and connectivity tools such as BICS
Handled overall Content Management and Security
Integrated the Web Intelligence reports onto the Dashboards using Opendoc functions
Defined Security roles and assigned users to custom groups defined for a better user rights administration and maintenance
Created Dashboard specific universes and created derived tables to cater to the dashboard requirements
Resolved various issues as an administrator which include, issues with Crystal reports and MS Access, SAP BW as a Database
Resolved scheduling issues with various reports, streamlined the scheduling to lower the processing burden on the servers
Worked closely with the SAP BW developers and administrators to streamline the rights conflict with the user rights in the Business Objects Environment and import the SAP defined roles into the Business Objects Environment
Raised tickets with SAP Support coordinated with them to get a closure on various technical issues and bugs and to understand some of the best practices pertaining to the issues
Environment: SAP Business Objects 4.0/3.1, Business Objects Administrator, BI Services, XML, WebIntelligence, Dashboard Design 4.0, BICS, SAP ERP, SAP BW
Amtrak, DC 02/09 – 10/11
Datawarehouse Analyst / Developer
Involved in the Customer Service Performance Metrics Information (“CSPMI”) project, built 2 universes, created reports and worked along with the Database developers to identify and resolve the performance issues since the CSPMI dashboards involved complex data pertaining to Customer complaints, Ridership and On-Time-Performance data sliced in various dimensions. Also was involved in multiple projects like creating, maintaining the Universes/Dashboards for Mechanical department, and proposing prototypes for the Chief Operating Officer dashboards.
Created CSPMI Universe from the Remedy tables along with the respective Web Intelligence reports
Created Monthly and Daily dashboards with each dashboard reporting up to 2 years of data monthly and daily level. The source data combines Customer Complaints, Ridership, and the On-Time Performance of the trains overall at route level, category wise and train level for different time dimension
Integrated the Web Intelligence reports onto the Dashboards using Opendoc functions
Merged various Web services into one big Web Service thus reducing the number of times the clicks invoke the web services.
Developed Acela Continuous Maintenance Dashboard and integrated various Crystal reports onto the dashboard
Developed various detail dashboards for Mechanical work floor project which would enable the dashboards to be displayed on the Mechanical workshop screen display as well as deliver a working model for interactive report churning for the management
Proposed various prototypes for the Chief Operating Officer
Analyzed the nature of the data and delivered 6 dashboards for the Safety department for Injury/Illness reports
Upgraded the Business Objects reports, dashboards, universes to the Business Objects 3.1 instance
Environment: SAP Business Objects XIR2, SAP Business Objects 3.1, Designer, WebIntelligence, Crystal Xcelsius 4.5, Xcelsius 2008 SP1/SP2/SP3, Query As A Web Service (QAAWS), Live Office, CMC, SQL Server 2005, SSIS
Apple Inc., CA 09/06 – 12/08
SAP BIDW analyst / Developer
The project was an amalgam of requirements from Japan, Singapore, and UK (taken as a part of the Regional Enhancements space). A common reporting solution, ‘Sell-Thru reporting’ had to be delivered and yet the regional requirements had to be met in full. The direct sales are anyways captured by SAP and then are channeled to the Global Sales Data from where it goes to the Business warehousing. The Indirect Sales are fed into the GDV from where it is channeled into the staging data mart and then into BW. Apple needs to integrate both the Direct and Indirect sales along with the information at various levels of the distribution channel.
Coordinated with the Business Owners to outline Business Requirements.
Liaised with the regional heads of Singapore, London, and Taiwan to seamlessly connect all the requirements and help complete the Business Requirement Document.
Acted as the lead developer for Sell-Thru reporting segment. Reports were reconstructed in Web Intelligence and Crystal Reports from SAP BW reports using BeX queries.
Created ad developed various data models for Regional enhancements division using Erwin tool
Scheduled documents to different users using CMC (Central management console)
Created Hierarchies to facilitate drill-down in the Desktop Intelligence reports
Concierge Project involved the study and analysis of the required data and pooling up different data from three different data warehouses for the sake of building up a common universe
Created pre-defined conditions and universe level prompts making it easy for business users to utilize these objects
Environment: Erwin, Business Objects XiR2, WebI Reports, Crystal Reports, InfoView, CMC, SAP NetWeaver BI/BW BEX Queries and Cubes, SQL Server, Apple Mac OS X, Windows XP/2003 Server, Oracle 10g.