SUMMARY

• Extensive experience in design, development, analysis, implementation, upgradation, migration and support as a Business Intelligence applications consultant for multiple industry verticals and products
• Implemented BI solutions using SSMS, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
• Expertise in delivering high - visibility projects in domains like supply chain management (SCM), customer relationship management (CRM), supplier relationship management (SRM) and manufacturing
• Expertise in Qlik Sense Desktop, Qlik Sense Enterprise, Qlik Sense Cloud, Qlik/QlikView Desktop, QlikView Server, QlikView Publisher, QlikView Management Console, Qlik Analytics platform, Business Intelligence (BI), Business Objects (BO), Big Data, Dashboards and SQL as a Techno-Functional consultant
• Experience using Tableau Desktop to generate visualizations including geographic/heat/bar/pi/ dashboards, charts, maps, plots and Tableau server for administration including security/authorizations/scheduling/tuning
• Full life cycle implementation in Qlik Sense, QlikView, Tableau, BI/BO for FI/CO, SD, and MM modules in all phases including Gap analysis, Blue-printing, design specification, development, performance tuning, testing, agile analytics, documentation, maintenance, training, Security authorizations, licensing and trouble-shooting
• Expertise in functional Applications (SD, MM, FI GL/AP/AR, HR, PP, QM, LE, APO DP/SNP, SEM, CRM, COPA applications), extraction ( LIS/LO Cockpit, CO-PA, FI-SL & Generic extractors) & enhancement
• Worked extensively with Project and product manager/architects and involved in Business Blueprinting and followed through with RICEF / FRICE (Forms, Reports, Interfaces, Conversion and Enhancements) and BPML
• Expertise of QVDs, QVFs, QVWs, Qlik Sense/QlikView scripts, distribution services, QlikView publisher, data loading techniques including incremental data loads, Mapping functions, set analysis, charts and functions
• Experience in Entity Relationship model (ERM), Multi-Dimensional model (MDM) and Star Schema models
• Hands on experience in Master Data Management, d esigning Infocubes, Multiproviders, DSO/ODS, Advanced Modeling, datasources, Transformations, DTPs, BEx Queries, BEx reports, BO Universe, IDT/UDT, BVM, QAAWS, Live Office, Analysis for OLAP, BICS, Design Studio, BO Reports (Webi, Crystal) and Dashboards
• Customized Standard Business Content Extractors and Enhanced Data Sources using SQL, ABAP in various applications and in customer user exits and proficient in interpreting and writing ABAP routines
• Configured OLE DB/ODBC datasources, worked with BI/BW components, User Exits, OLTP data extraction, loading (Full/Delta Load), Scheduling, Monitoring, Process Chains, OLAP Cubes and Data Marts
• Proficiency in developing Front-End BI Business Warehouse Solutions, Query Development, Reporting agent, Calculated and Restricted key figures (CKFs and RKFs), Structures, Variables, KPIs using BEx Analyzer
• Extensively involved with Tableau and QlikView Desktop/Server/Publisher, QMC (QlikView Management Console), Business Objects Webi / crystal reports, Dashboard Design / Xcelsius, Explorer and analysis for OLAP
• Excellent Production Support skills including Process Chain Data loads, Reporting related Issues, data Archiving, Performance Issues, and Data Compression Activities and Source Control /Version Control expertise
• Hands on experience on both Load performance tuning and Report performance tuning by creating DB Statistics, Aggregation, OLAP Cache, Compression, Indexes and Partitioning.
• Prepared documentation, wrote project plans, functional & technical specifications, testing scripts and experience in arranging and conducting workshops, presentations and trainings.

TECHNICAL SKILLS

Programing Languages: SQL, T-SQL, PL/SQL, MS SQL, SAP ABAP/4, VB, Java, C, Hastus, XML, Python, R, JSON

BI/Reporting Tools: Tableau, Qlik Sense, QlikView/Qlik, SAS, IBM Cognos BI suite, QVW, QVD, QVF, QMC, Business Objects Enterprise, Infoview, BO Design Studio, WebI, DeskI, BEx Analyzer, WAD, QAAWS, Live Office, Analysis, HANA Studio, MS Excel, Dashboard Design / Xcelsius, Voyager, Crystal Reports 2011/XIR2

Databases /Tools: Oracle, Qlik Sense Cloud, SQL Server, My SQL, SSMS, SSIS/SSAS/SSRS, Visual Studio, HTML5, SQL Server Agent, Business Objects, Harmony, HANA, Teradata, TortoiseSVN, HPQC, Kronos, HADOOP, Informatica, Data Stage, Hyperion, MS Access, BICS, Hastus

BI/BW/BO: Power BI, SAP BW/BI 7.x/3.x, BOE XI/4.x/3.1, R/3 ECC, HANA, Solution Manager

Functional Modules: SD, FI/CO, GL, AP, AR, MM, IM, PP, QM, LE, APO DP, SNP, CRM, SRM

Application Servers: Vorne System, Web Sphere, WebLogic Server, RED5, Apache with Eclipse

Operating Systems: Windows, LINUX, UNIX, Ubuntu

PROFESSIONAL EXPERIENCE

Confidential

BI Developer

Responsibilities:

• Involved with business users for requirement gathering, architecture, creating data flow diagrams, functional and technical specifications, product designing and developing, Business Intelligence reports and dashboards
• Responsible for Data Discovery, structured/visual analytics, pattern recognition, creating Tables/Views/Stored Procedures, temporary tables/variables that helps in identifying/creating relationships between objects
• Developing reports including comparison analysis / trending reports on On-Time-Performance, Scheduled Vs Actual Employee Shifts, Asset Management using SSRS/SSIS/SSAS, QlikView, Qlik Sense and Crystal Reports
• Extracting, Transforming and Loading (ETL) data from SQL Server, SAP, Trapeze, Kronos and other datasources, creating and maintaining Qlik Sense/ QlikView dashboards, modeling star schema (facts and dimension tables)
• Building Qlik Sense smart/interactive visualizations for actionable insights, utilize Qlik Sense smart search for identifying relationships, build and share QVF files, deploy and share with responsive UI for mobile/touch
• Managing data quality, scalability, self- service analytics, govern libraries, embed objects with APIs,
• Involved in designing multiple charts, cross-tab, master-detail repots, prompts, data access security, object level access, package access, conditional formatting while developing reports and storyboard dashboards
• Documenting and version management through Visual Source Safe (MS VSS) creating Source Control/ Version Control of Qlik/SSRS/Crystal reports accessed by multiple developers and managing change request forms
• Installation of QlikView, Qlik Sense, creating efficient Qlik folder structure, designing system landscape, data mapping documents, web analytics, design QlikView / Qlik Sense loading strategies, managing job scheduling
• Developing dashboards/templates/charts/scorecards using Tableau, data extraction, data blending, forecasting, administration using Tableau server, restoring backups of Tableau repository and maintenance
• Monitoring SSIS packages, incremental load with Merge into tables, ensure client/server apps run successfully
• Creating stored procedures, functions, cursors, datamarts, SSIS/SSRS/SSAS packages in BIDS, security control, access, distribute SSRS reports and scheduling tasks for Qlik Sense / QlikView dashboards in QMC
• Developing data warehouse design for the migrated data, test/debug and seamlessly append the data from multiple datasources with the existing data and promoting objects to testing/production in agile environment
• Developing QVWs, QVDs for performance analysis, schedule analysis and usage analysis reports/dashboards
• Extraction of data to Cubes, conversion and loading data from OLE DB/ODBC datasources in near-real time
• Applying data transformations like Slowly Changing Dimension, Aggregates, Sorting, filtering, Multicasting, Cache Transform, Conditional Split and Derived column thru SSIS, created sub-reports on dashboard, linked reports, charts, snapshot reports, drill through/ drill down reports in SSRS/Qlik/Tableau/Mobile applications
• Developing Mechanical/HR/Inventory/Financial reports and dashboards using Qlik Sense/QlikView/ SSRS/ BO
• Using QlikView for reporting on Type 1/2/3 slowly changing dimensions (SCD) and Point-in-time reporting
• Developing required objects in Hastus by Giro, modified object types and involved in creating and migration of reports based on Harmony Crew Management system to Hastus Transport Crew scheduling software
• Involved in data reconciliation, UAT and improve performance based on Key Performance Indicators (KPIs)
• Scheduling of jobs using SQL Server Agent, SSIS package, job scheduling for data from multiple sources
• Developing Dashboards, linked/ad-hoc reports, Sub/complex Reports and drill through reports using Qlik Sense, QlikView, SAP Business Objects, Crystal Reports and SSRS as per business needs of the organization
• Creating documentation, provide user training on Qlik Sense, QlikView Reports/Dashboards, Crystal and SSRS
• Working with End Users, create test cases and involved in testing including integration testing, UAT and improve performance based on the governance Key Performance Indicators (KPIs) of Dashboards and reports

ENVIRONMENT: Qlik Sense 3.x, QlikView 12.x/11.x, Tableau 8.x/7.x, MS SQL, SSIS, SSAS, SSRS, SSMS, BIDS, HTML5, Cloud, SAP Business Objects, Hastus, Harmony, AWS, Crystal Reports, MS Visual Studio, Trapeze, QVW, QVD, QVF, NPrinting, QlikView Desktop / Server, kronos, CRM, My SQL, T-SQL, PL/SQL, Oracle, JavaScript, MS Access, BO CMC

Confidential

BI Developer

Responsibilities:

• Involved with users for requirement gathering, product development, created data flow diagrams, translated them to functional and technical specifications for Business Intelligence reports and QlikView dashboards
• Created Tables, Views, Stored Procedures, Temp tables, variables in Oracle / SQL Server Management Studio
• Developed reports including comparison analysis / trending reports on new Customer Enrollment, customer drops and customer switch of services and plans allowing business users to effectively modify product plans using SSRS/SSIS/SSAS, QlikView, publishing and broadcasting for access from thin client/mobile applications
• Extracted, Transformed and Loaded (ETL) data from Oracle, SQL Server, My SQL, ECC servers, created and maintained QlikView reports and dashboards, modeling star schema (facts and dimension tables)
• Installed open source software (TortoiseSVN), creating Source Control/ Version Control of QlikView documents definition in - prj folder accessed by multiple developers, create documentation and change logs
• Involved in migration of data from Oracle and My SQL databases to SQL Server database and creating DataMart and deployment of updated SSRS/SSIS/SSAS package with new control flows for seamless reporting
• Created indexes, queries, stored procedures, functions, cursors, datamarts, SSIS/SSRS/SSAS packages in BIDS, security control, access, distribute SSRS reports and scheduling tasks for QlikView dashboards in QMC
• Designed/developed data warehouse design for the migrated data, test/debug and seamlessly append the data from multiple datasources with existing data, creating and updating tables, views and stored procedures
• Monitored SSIS packages, incremental load with Merge into tables, ensure client/server apps run successfully
• Imported data to SQL server from Oracle DB .OUT files, developed staging/ready/load stored procedures
• Developed QVWs, QVDs for Sales analysis, price analysis and enrollment analysis reports using QlikView
• Involved in ETL data to Cubes, data conversion, conditional split, derived column, aggregation, connectors, data mining and loading huge volume of data from OLE DB/ODBC datasources in near-real time dashboards
• Applied data transformations like Slowly Changing Dimension, Aggregates, Sorting, Multicasting, Cache Transform, Conditional Split and Derived column thru SSIS, created sub-reports on dashboard, linked reports, charts, snapshot reports, drill through and report models drill down reports in SSRS and QlikView applications
• Developed Customer Order Processing, Sales, financial reports and dashboards using QlikView/ SSRS/ BO

ENVIRONMENT: QlikView 11.x, SQL Server, SSIS, SSAS, SSRS, SSMS, BIDS, MS Visual Studio, Business Objects, TortoiseSVN 1.8x, BI, Oracle, ECC, CRM, My SQL, T-SQL, PL/SQL, Oracle SQL, Python, Java, OLTP systems, QVW, QVD, EDI, ISTA, AUREA, BeQuick, Crystal Reports, Dashboard, MS Access

Confidential

BI Consultant

Responsibilities:

• Requirement gathering from business users, documentation, creating data flow diagrams and translate them to functional and technical specifications for BI/BW BEx reports, BO and QlikView dashboards and reports
• Created and maintained QlikView reports and dashboards, involved in data extraction from SQL Server, ECC/CRM/APO and Kronos database, created data models including star schema (facts and dimension tables)
• Published near real-time data on Thin Clients at plant, allowing comparison of hourly goals (APO) vs actual goals using SSRS/SSIS/QlikView allowing rescheduling of operators to work centers and increase productivity
• Created Productivity, Safety, Quality and Resource Feasibility dashboards, Cycle count analysis, inventory variations, requisitions, open orders dashboards and reports using QlikView and BO Dashboards
• Developed QlikView QVDs, BO dashboards and display on mobile applications/TCs that dynamically refresh
• Applied data transformations like Slowly Changing Dimension, Aggregates, Sorting, Multicasting, Cache Transform, Conditional Split and Derived column thru SSIS, created sub-reports on dashboard, linked reports, charts, snapshot reports, drill through and report models drill down reports in SSRS and QlikView application
• Developed reports for Sales, Financial Billing and Order processing and created dashboards using QlikView
• Used QlikView for Point-in-time reporting/SCDs, creating functions like Set Analysis and deploying
• Scheduled jobs using Espresso CA automation tool to handle job scheduling from multiple source systems
• Developed Sales/PO/Deliveries/Price/unit reports, price analysis / pricing condition reports using QlikView
• Worked with End Users, create test cases and involved in testing including integration testing, UAT and improve performance based on the governing Key Performance Indicators (KPIs) of Dashboards and reports
• Developed Dashboards, linked/ad hoc reports, Sub/complex Reports and drill through reports using QlikView
• Created documentation for end users and provide training for QlikView Dashboards and reports to users

ENVIRONMENT: SQL, SSIS/SSAS/SSRS, QlikView 11, SAP BI 7.3/7.0, SAP R/3 ECC 6.0, CRM, APO, HANA, ABAP/4, BO XI 4.0/3.1, Design Studio 1.x, UDT/IDT, Webi, Crystal Reports 2011, Dashboard / Xcelsius, Live Office, HANA, BVM, Espresso, Vorne, Kronos, Oracle, BEx, MS Excel, Espresso, Vorne, kronos, UltraVNC

Confidential

BI BO Consultant

Responsibilities:

• Worked with users, understand business processes, requirement gathering, document, create data flow diagrams and translate them to functional/technical specifications for SSRS/QlikView reports and dashboards
• Involved in system analysis, creating blueprint, designing and developing SSIS/SSRS/SSAS/QlikView data models, identify data in source (SQL Server/legacy systems), mapping the data to the QlikView environment
• Configured ODBC, OLE DB datasources, extracted data from SQL server, Flat files to in-memory QlikView
• Extract, Transform and Load (ETL) data to QVWs, create QVDs Infocube/DSO/WOD/Multiprovider from SQL Server, Transformations, scripting and resolve issues like redundancy / data inconsistency / errors
• Developed reports for Sales (SD), Financial Billing system and Order processing (FI GL/AP/AR, COPA), create objects and prepared financial reports, standard reports, ad hoc reports and dashboards by using QlikView, tools such as BEx, Design Studio, WebI, Xcelsius / BO Dashboards, Crystal Reports, Live Office
• Created Calendar, Metrics, analytics, Dashboard reports, Speedometers, gauge/pivot tables/Charts, Alerters, traffic lights etc.,), use Performance Manager, Dashboard design/ Xcelsius, QAAWS and Live Office
• Worked with security/admin team & authenticate systems in QlikView Management Console(QMC), implement Security Features for reporting (row level/object level/report level and make report data secure
• Created Set Analysis, use QlikView for Point-in-time reporting and SCD (Slowly changing Dimensions)
• Developed Dashboards, linked/ad hoc reports, Sub/complex Reports and drill through reports using QlikView

ENVIRONMENT: SSIS/SSAS/SSRS, SQL Server, IBM Cognos, QlikView 11, SAP BI 7.3/7.0, SAP R/3 ECC 6.0, CRM, HANA, ABAP/4, SAP BO XI 4.0/3.1, Design Studio 1.x, UDT/IDT, Infoview /BI Launch Pad, WebI, Crystal Reports 2011, Dashboard / Xcelsius, QAAWS, Live Office, HANA, BVM, HPQC, Oracle, Net weaver, BEx

Confidential

BI Analyst

Responsibilities:

• Worked with on-site / off-shore teams on multiple projects, created /modified existing BI queries and created new BI /BO Webi reports, Crystal Reports and delivered BI BO dashboards and reports
• Involved in design, analysis and end to end development on identifying KPI's and gathering requirements for GL, Revenue, AR, AP, PP and Aging reports enhancing multiple standard and generic extractors
• Created user-exit variable for Planning periods based on user entry, developed expert routines and end routines for PP, QM, GL (new GL datasources), AP and AR Aging report
• Reviewed existing BI Models and data flows for various Dashboards and reports and recommend, design and develop new BI BO Models and enhancement of existing BI Models and improved Performance
• Worked on multiple enhancements in SD, PP and FI with in BI and ECC source system and developed APD's for planning stock and Inventory movements, source as BEx query
• Developed BO WEBI reports and used features as formatting, ranking, sorting, breaks, prompts, sub-queries, data tracking, Alerter, complex formulas variables, projecting charts, cross tab reports, drill down reports
• Developed new/enhanced custom Transactional/Master data Extractors, InfoObjects, DSOs, Infocubes, Multi Providers, Transformations, Info Packages, DTPs and scheduled the load via process chains
• Enhanced SD extractors for line item texts with multi language options, enhanced SD extractors and relevant objects adding a new partner function and modified existing reports to accommodate new fields and functions

ENVIRONMENT: SAP BI 7.0, SAP R/3 ECC 6.0, ABAP/4, Business Objects XI 3.1, Universe Designer, Infoview, WebI, DeskI, Crystal Reports, Xcelsius, QAAWS, Live Office, Oracle 10g, SAP Net weaver, SAP Enterprise Portal, BEx Analyzer, Query Designer, SQL Server, MS Excel, WAD