Kartik Kapur

631-***-**** ac19m2@r.postjobfree.com

PROFESSIONAL SUMMARY

•Over 11 years of Business Intelligence experience including 10 years of hands on experience with SAP Business Objects 6.x/ XI R2/R3.1/4.0/4.1 (Supervisor, Designer, Reporter, Desktop Intelligence, Web Intelligence, Info View, Publisher, Version Management and Central Management Console), Crystal Reports 2008, 2011.

•5 Years of Data Visualization along with 3 years on Tableau Desktop 8.1, 9.2, 10.1 and Tableau Server

•5 years of ETL and Data integration experience with tools such as Talend Integration Suite (4.x/5.x), Talend Admin Console (TAC) and Microsoft Business Intelligence Suite (SSIS).

•Proven track record of successful implementation of Full Lifecycle (Requirement gathering through implementation and enhancement) of Business intelligence projects.

•Extensive experience in building and managing reporting environments that can support Self-Service and Ad-hoc Universes, creating Complex Reports and/ or Dashboards and Data Visualizations using Business Objects Web Intelligence/Desk Intelligence/Crystal Reports/Xcelsius/Tableau/Microstrategy.

•Expertise in using various data providers like Universes, Personal Data Files, Stored Procedures and Freehand SQL to generate reports and dashboards.

•Proficiency in Scheduling, Publishing and Distribution of Business Objects reports, Tableau Dashboards and Talend Mappings using Scheduling services and Publishing server.

•Experience in creating Repositories, Folders, Groups, Users, assigning privileges to users and maintaining the Repository.

•Expertise in Administering Business Objects, Tableau and Talend Administration consoles to perform all administrative duties.

•Experience working with Data Warehousing Concepts like Kimball/ Inmon methodologies, OLAP, OLTP, Star Schema, Snow Flake Schema, Logical/Physical/ Dimensional Data Modeling.

•Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend and designed data conversions from wide variety of source systems including Oracle, DB2, SQL server, non-relational sources like flat files, XML and salesforce cloud.

•Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts using SCDs (Type 1/Type 2/ Type 3) loads.

•Extensive experience with Customer Insights, Consumer behavior and subscription based models.

•Able to work on own initiative or as part of a team, backed by excellent organizational and communication skills along with the capability to solve problems as they arise.

•Superior Team building and Leadership skills.

•Quick in learning new toolsets.

•Diversified domain experience in Telecommunications, Construction, Health Care, Finance, Banking, and Manufacturing.

SKILLS PROFILE

BI Tools Business Objects 6.x/ XI/ XIR2/XIR3.1/ XIR 4.0/ XIR 4.1 (Universe Design Tool (Designer), Desktop Intelligence, Web Intelligence, Central Management Console, Info View, Publisher, Import Wizard, Launch Pad, Life Cycle Management), SAP Crystal Reports, SAP Dashboard (Xcelsius), Microsoft Business Intelligence Studio 2008, Tableau 10.1, Microstrategy 9.3

Data Modeling ERWin 4.0/ 3.x

ETL Tools Informatica 7.1, Talend 5.4, Alteryx 10.6

Databases Oracle 8i/ 9i/ 10g, 11g, SQL Server 2000, 2005, 2008, Sybase, MySQL, SAP HANA and MS Access 2002

Languages PL/SQL, T-SQL, SQL

CM Tools Clear Case/Clear Quest/JIRA/Team Track/Service Now

Platforms Windows NT/ 2000/ Server 2003/ Server 2008/ XP/ 7 and UNIX

PROFESSIONAL EXPERIENCE

Altice USA (Formerly Cablevision Systems), Jericho, NY Apr’14 – Present

Senior Programmer Analyst

DESCRIPTION:

Altice USA is national Telecommunications, Entertainment and Media Company, subsidiary of Altice Group a global telecommunications company. Altice USA provides residential and business services to customers across 20 states and offers digital cable television, high-speed Internet, voice, WiFi and data products. Where I am part business Insights and strategy group responsible for companywide business intelligence and reporting solutions. My main focus area is the commercial side known as Lightpath in the NY tri state area.

RESPONSIBILITIES:

Delivered 250+ reports to various business groups that consisted Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL, Designed Universes, Stored Procedures and excel as data providers.

Work with all business units to define and develop KPI’s and Analytics. Extensively worked with Customer insight group to design marts that could provide KPI’s such as Customer Relation gain and loss, Customer Transformation, Promotion uptake, Customer churn, Customer usage, Customer retention and Customer loss to competition.

Collect demographic data from Experian and Dun and Brad Street for residential and commercial customers to analyze behaviors.

Perform technical analysis, ETL design, development, testing, and deployment of business intelligence solutions as needed by business.

Participate in designing the overall logical & physical Data warehouse/Data-mart data model.

Produce visually exhilarating dashboards for upper management and executives. Monthly Recurring Revenue, Customer Lifetime value, Customer Acquisition Cost and Customer Churn.

Build and support Alteryx mappings to clean and compile customer geo location data and demographics data.

Responsible for tuning Talend ETL mappings, jobs and underlying queries to optimize data load and job performance.

Lead Business Intelligence Center of Excellence, where we established data governance framework, reporting and data warehousing SLA for business units, issue management and quality improvements.

Maintain system availability through administering the business objects server on day to day basis.

Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Provide monthly web sessions and develop user documentation guide for the end users, which enabled them to develop their own complex and ad-hoc reports.

Automated processes and delivery for Customer Stewardship reporting that saved the department 2 FTE dedicated for the process for 2 weeks every month.

Recognized by the department as outstanding performer for 3 years in a row.

Manage cross functional teams and interface with business users to gather requirements and translate them in to technical solutions.

Shifted the culture from instinct to data and fact driven decision making by increasing availability and accessibility of analytics through data warehousing and reporting.

ENVIRONMENT: SAP Business Objects XI 4.1 SP6 (Universe Designer, Information Design, Rich client, Web Intelligence, Live Office, CMC, Launch Pad & Life cycle management), SAP Dashboard (Xcelsius), Talend 5.4 data Integration suite, Alteryx 10, Microstrategy 10, Tableau 10.1, Subversion, Free hand SQL, PL/SQL, Oracle 11g, Windows Server 2008.

Parsons Brinckerhoff, Lancaster, PA Apr’13 – Apr’14

Lead Application Developer

DESCRIPTION:

Parsons Brinckerhoff is a global consulting firm assisting public and private clients to plan, develop, design, construct, operate and maintain hundreds of critical infrastructure projects around the world. Currently the business objects environment in conjunction with the data warehousing serves as the decision support system for Parsons Brinckerhoff, where I am responsible for the complete business Objects reporting architecture.

RESPONSIBILITIES:

Led a team of onsite offshore resources.

Responsible for creating user access, user groups, user authentication and maintained row level and object level security using Business Objects Central Management Console and Designer.

Built new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.

Used Derived tables in some instances to create the universe for best performance, and use context and alias tables to solve the loops in Universe.

Built universes on the designed schemas, tested and exported them to repository using Business Objects Designer Module.

Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.

Created various complex reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.

Converted Desktop Intelligence reports to web intelligence.

Implemented changes and perform bug fixes as part of maintenance on existing universes

Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.

Provided monthly web sessions and develop user documentation guide for the end users, which enabled them to develop their own complex and ad-hoc reports.

Resolved issues reported by business users and follow SDLC process using Team track.

Wrote unit test cases, SQL queries and comparison to front end to assure quality of reports.

Effectively prepared and customized the training documents, Best Practices, Template documents.

Efficiently trained both the developers and business users with limited or zero experience using Business Objects and 4.0.

ENVIRONMENT: SAP Business Objects XI 4.0 FP3 (Designer, Rich client, Web Intelligence, CMC, Launch Pad & Life cycle management), SAP Crystal Reports 2011, SAP Dashboard (Xcelsius), Subversion, Free hand SQL, PL/SQL, Oracle 11g, MS SQL Server 2008, SSIS, Windows Server 2008, and exposure to Oracle EBS R12.

Universal American (Formerly APS Healthcare), White Plains, NY Full Time Aug’11 – Apr’13

Part Time Apr’13 – May’15

Sr. Business Objects Developer

DESCRIPTION:

APS Healthcare is a managed behavioral health organization that provides managed behavioral health, employee assistance programs (EAP), and specialty care management services to more than 9 million people in the United States and Puerto Rico. Their customers include corporate employers, HMOs (commercial, Medicaid, Medicare and point-of-service), unions, PPOs, indemnity plans and public sector programs. In March of 2012, APS Healthcare was acquired by Universal American. APS operates as a branded, standalone business. APS has health management and care coordination products like Care Coordination Connection (C3) and Personal Health Record (PHR). I am part of the corporate operations and business intelligence department which handles Reports for external and internal clients. Maintenance, support and upgrades to existing client reports.

RESPONSIBILITIES:

Designed Universes by defining joins, cardinality between tables, linked the existing Universes in Business Objects XI R3.1 and 4.0.

Developed complex universes by using features like aggregate aware, Conditions, hierarchies and Perform linking of universes by Kernel method to optimize the universe development and performance improvement.

Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.

Published existing reports to corporate intranet through Web Intelligence.

Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs. Perform unit testing, system testing and user acceptances test (UAT) for universe and reports.

Wrote unit test cases, SQL queries and comparison to front end to assure quality of reports.

Took initiatives such as Converted and automated DTS packages in to Web intelligence reports, which reduced man hours spent running and producing these reports. Converted and Automated Stored procedure based reports in to web intelligence reports, which eliminated reliance on production support team and SQL server schedule jobs.

Created reports with dummy data and after user acceptance used live data to stay aligned with HIPAA policies.

Work extensively with the major functionality of Business Objects like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations, Ranking, user response, Variables, @function, @BOUSER and formulae.

Linked universe security to crystal reports by using LOV from universe to answer prompts in crystal.

Developed interactive crystal reports that had features such as universe security, hyperlinks to detail reports, ability to view data in different charts on demand, well defined tool tips for better user experience, Ability to run the report on specified time periods or ad-hoc based on user preference.

Serve as subject matter expert and share technical knowledge of system under the business objects center of excellence.

Developed Patient Health Registry (PHR) and Patient Health Brief (PHB) reports that helped health coaches in determining patients that might be falling behind in their care coordination or management. These reports required data from multiple sources and complex logic to develop. These were developed to track various conditions such as Coronary artery disease (CAD), Asthma, Depression, Diabetes and each differing in report generation logic.

Utilized Merge Dimension capability to develop complex claims reports which required use of multiple data sources.

Built static Dashboards using SAP Dashboard with the data in Excel files.

Updated the static models with live data connecting via the Web Service connectors like QAAWS, Live Office.

Efficiently and effectively handled the Change, Add, Delete Request in a Universe, WebI, and/or Crystal Reports assigned via the JIRA ticket application.

Effectively prepared and customized the training documents, Best Practices, Template documents.

Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

ENVIRONMENT: SAP Business Objects XI R3.1/4.0 (Designer, Rich client, Web Intelligence, CMC, Info View, Launch Pad & Life cycle management), SAP Crystal Reports, SAP Dashboard (Xcelsius), Free hand SQL, PL/SQL, MS SQL Server 2008, SSIS, SSAS, QWAAS, JIRA, Windows XP, and exposure to Facets.

Capgemini, Rosemont, IL Feb’11 - Aug’11

Lead Consultant

Client - Fannie Mae, Herndon, VA Feb’11 - Aug’11

Sr. Business Objects Developer / Lead Consultant

DESCRIPTION:

Federal National Mortgage Association (Fannie Mae) is a government-sponsored enterprise (GSE) chartered by the United States Congress to support liquidity and stability in the secondary mortgage market, where mortgage-related assets are purchased and sold. Its activities include providing market liquidity by securitizing mortgage loans originated by lenders in the primary mortgage market into Fannie Mae mortgage-backed securities (Fannie Mae MBS), and purchasing mortgage loans and mortgage-related securities in the secondary market for its mortgage portfolio.

RESPONSIBILITIES:

Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes.

Created several Universes using Designer based on requirements.

Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.

Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where).

Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables. Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.

Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved. Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing,

Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.

Exported the universe to the Repository to make resources available to the users.

Scheduled the reports on daily wise, monthly wise and weekly by using scheduler in B.O.XI R3.1.

Updated and maintained existing Universes based on changing user requirements and based on changes in data source.

Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables and joins

Documented all the changes made to the Universes and Reports for future references.

Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.

Trained end users to use various functionalities of Business Objects and provided technical support. Created different types of reports such as Master/detail, Cross Tab and Charts.

Created graphical representation of reports such as Bar charts, 3D charts and Pie charts etc.

Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).

Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.

Used Alerter to draw attention to a particular block of data by highlighting it.

Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.

Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.

Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.

Generated complex reports like Status Summary Report, Business Case Summary Report, Project Status Report, Yearly Funding Approval and Budget Transfers Report, MS Project Server Report, Change Request Summary Report

Exported reports into XL, PDF, CSV and XML formats as per the client requirement.

Migrated Business Objects content (users/user groups, Universes, reports) in to different environments such as Test, User acceptance and production using the Import Wizard.

Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes. Developed PL/SQL queries for data manipulation and report generation.

Implemented user based security on reports using the @Variable (‘BOUSER’) function.

ENVIRONMENT: SAP Business Objects XI R3.1 (Designer, Rich client, Web Intelligence, CMC & Info View), SQL, PL/SQL, Oracle 11g, Windows XP, and Exposure to HP PPM tool.

Beltway Consulting, Fairfax VA Nov’06–Feb’11

Senior Business Intelligence Consultant

Client - Verizon Wireless, Ashburn, VA Mar’08–Feb’11

Client - American Electric Power, Columbus, OH May’07–Dec’07

Client - Wyeth pharmaceuticals, Plainsboro, NJ Nov’06 – May’ 07

EDUCATION

Bachelors of Science in Business Administration and Economics, Stony Brook University, NY-US

Current Work Status: US Citizen

Location: Deer Park, NY

Contact this candidate