- Over 13+ years of Information Technology experience in all phases of software development life cycle (SDLC) process.
- Expert in designing extract transform and load (ETL) processes in enterprise data warehouse and data marts. ETL tools - SQL Server SSIS and Informatica.
- Create dimensional model, Star and Snowflakes schema, data visualization in various reporting tools - SAP BW\BI, SAP Business Objects, Microsoft SSAS, SSRS, Power Pivot, Excel, Lumira, Qlikview and QlikSense. Exposure to Tableau and Power BI.
- Methodologies - ASAP, Agile Scrum, Waterfall, Six Sigma, JAD Sessions
- End to end report development - requirements gathering from stakeholders, dashboard creation, product deployment and user training.
- SAP Integration and Upgrade implementation experience - SAP HANA, BW 7.4 Upgrade, Business Objects 4.1.
- Manage SAP BW release level development, delivery time lines, GO live activities; BW 7.4 Upgrade, hyper care and batch job support calendar.
- Serve as IT liaison between business and development team.
- Worked on all phases of ASAP methodology including requirement gathering, Blueprint, Gap Analysis, Go-Live and Post-Live\hyper care support.
- Good Troubleshooting and Crisis Management skills.
- A self-motivated team player with excellent communication and verbal skills.
ERP Packages: SAP BI 4.1/4.2, SAP BW HANA, 7.4/7.x, SAP ECC, SAP R/3, ABAP
Business Intelligence: QlikSense, QlikView, Business Objects XI 3.x/4.0\4.1\4.2, Tableau, Informatica, Web Intelligence XI, SAP BI, SAP Business Explorer (BEx), InfoView, CMS, Solution Manager, MS SSIS, SSAS, SSRS, Power Pivot, Power BI
Database: DB2, Oracle 10g/11, SQL Server 2000/2005/2008 , IMS
Mainframe: DB2, COBOL, IMS DB, CICS, JCL, PANVALET, XPEDITER
Operating Systems: WINDOWS XP, Z/OS, MVS/ESA, OS/390, UNIX
Other Software: MS OFFICE SUITE, EXCEL, VISIO, ACCESS, SOURCESAFE
Sr Business Intelligence Analyst
- Capture business requirements, create data model and implement key performance indicators KPI with charts, maps and graphs. Help end users with product guidance.
- Lead reporting strategy, create Qlikview\Power BI report development standards and implement connectors across SAP landscape. Use calendar measures and set analysis expressions to slice data. Help analyze data in excel pivot table and power pivot.
- Create Qliksense\Qlikview - Retail Vehicle registrations dashboard and Competitor Industry sales data dashboard to help sales team visualize and compare year over year (YOY) and current month vs previous month sales actual and target units.
- Extract (ETL) source data using Microsoft SSIS packages, format, apply lookups and rules to transform and cleanse data sets. Use MDX and DAX queries for analysis.
- Extract FI-GL PCA data for ad-hoc analysis across product category, hierarchy, division and region. Create SSRS reports and dashboards. Build SSAS cube for analysis.
- Design and implement daily sales dashboards for parts, oil, garment and accessories POGA business segment.
- Automate work flow, data loads with extract transform and load (ETL) scripts; Process data from external agency for Motor Vehicle industry standard data formats.
- Implement business requirements, create work break down matrix and delivery time-lines.
Platform: SAP, Salesforce, SAP BW 7.4/7.0, QlikSense 3.2, QlikView, Power BI, MS Access, SSIS, SSAS, SSRS, MDX, BI 4.1, BI Launchpad, Infoview, ABAP, SAP (BEx), Solution Manager, Business Objects XI r3.x/4.1, Business Objects Universe Designer, Web Intelligence XI
Sr Business Intelligence Consultant
- Drive estimation process with business analysts; capacity planning, align QA testing, user acceptance testing resources.
- Extract(ETL) QM system data using SSIS packages; apply business rules and load in SSAS database schema. Create reports for adhoc data analysis.
- Perform root cause analysis for batch job failures and suggest source data correction.
- SAP Hana Pre-migration check list activities. BW 7.4 Migration and BI 4.1 upgrade experience. Upgrade and perform batch load testing for process chains.
- Enhancement of Procure to pay (P2P) process for Ariba PO Extraction and load into BW.
- Develop Webi reports for Contracts and planning business process, EHS, Purchasing and Corrective Action prevention and Learning (CAPAL) business areas.
- Performance optimization of process chains for Sales Distribution, CRM, CAPAL.
Platform: SAP HANA, SAP BW 7.4/7.0, BI 4.1, BI Launchpad, Infoview, ABAP, SAP Business Explorer (BEx), Crystal Report, Solution Manager, Business Objects XI r3.x/4.0, Business Objects Universe Designer, Web Intelligence XI, Microsoft Power BI, SSIS, SSAS, SSRS
- Design high level system landscape data flow/modeling diagrams in SAP Solution manager. Make changes to As-Is process / To-Be process maps.
- Enhancement of reports for HR, MM and SD modules. Developed WEBI / InfoView reports with Business Objects Universe as source. BEx query analysis and tuning.
- Perform extract transform and load (ETL) of HR data with Informatica into warehouse.
- BW data modeling with PSA, InfoPackage, DSO, InfoCube and multiprovider. Used BEx Query Designer to add calculated and restricted key figure.
- Collaborate with functional teams (Client) and manage offshore team members to prioritize, design, plan, manage and deliver reporting and analytics solutions.
- Manage rights (security) for folders \ user groups via Central Management Console.
- Analysis and performance tuning of existing DSO and Info cubes with BW statistics, partitioning and indexing. Used Sql Trace and DB Monitor for analyzing the performance of BI objects.
- Load Characteristic and key figures data for HR Time-sheet and travel subsystem.
- Created Transport requests from dev to system test environment.
Platform: SAP BW 7.0, Informatica, SAP Business Explorer (BEx), Solution Manager, Business Objects XI r3.x/4.0, Business Objects Universe Designer, WebI, SQL Server, SSIS
- Subject Matter Expert (SME) for Item Master application; analyzing\harvesting data flow to downstream interfacing systems, generate business process diagrams.
- Harvest standalone packaging system to consolidate business processes and improve data quality.
- Develop Sql Server Packages with multiple transformations and activex scripts.
- Architect automated batch programs to process good service data.
- Analyze and design data feeds to Global Warehouse\ datamarts.
- Generate Migration plan to harvest data from Access database into DB2 database.
- Monitor and enhance the Sql load batch process running daily updates.
- Crisis Management\Problem solving - Solve data upload issues to Global Data Warehouse, debug data loads to downstream systems
Platform SQL SSIS, SSRS, Informatica, Business Objects XI r3.x, DB2, Cobol, Visio, Rational Reqpro, ClearQuest, SQL Server, Mainframe, Jcl, CA-7, ChangeMan
- Extract Senior care and Child Care data into Data Marts using DTS jobs. Analyze and design data flow diagrams and components to extract data from source database (Legacy systems) to destination database.
- Design and develop Sql Server Packages (SSIS) for extract transform load process.
- Generate Migration plan to harvest data from Access, SQL database into DB2 database.
- Design test-data load scripts to move data from Excel/Access to DB2 database using IBM loader mainframe JCL jobs.
- Performed Unit testing, integration testing and user acceptance testing.
Platform: SQL SERVER, DTS, DB2, INFORMATICA, MS VISIO, IMS-DC, COBOL II, TELON, JCL, FILEAID, VSAM, TSO, CHANGEMAN, MICRO FOCUS COBOL (MFE)