SUMMARY:

• Business Intelligence professional who has immense expertise across many facets of front end reporting, data analysis, predictive modeling as well as data modeling and warehousing. Confidential has years of hands on experience working with the leading BI platforms specifically QlikSense, Qlikview, Tableau, SAP Business Objects, and Microstrategy.
• He is experienced with all aspects of full - cycle developments, inclusive of assessment and requirement gathering, data modeling and availability, development and testing, and user training and ongoing support. client facing and has worked with business partners at the analyst, quality assurance, management, and executive level.
• His in-depth knowledge of the analytics and reporting has helped clients select the right application for their reporting needs.
• Furthermore, his knowledge and forward thinking has allowed him to successfully implement a wide range of complex business requirements.

SKILLS AND SOFTWARE EXPERIENCE:

• QlikSense
• Qlikview
• SAP Business Objects
• Microstrategy
• Tableau
• SAS
• Oracle Business Intelligence Enterprise
• SQL Server Reporting and Analysis Services
• SAP HANA
• SAP BW
• Oracle
• Hadoop
• Teradata
• Greenplum
• Microsoft SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, New York, New York

Senior BI Developer

Responsibilities:

• Functioned as Lead Business Intelligence Contractor in COO’s Office
• Helped to drive and developed new Qlik reporting initiative across Operation’s key areas (Supply Chain, Facilities Management, Travel and Expense, Internal Technology)
• Coordinated with stakeholders and business leaders on defining key KPIs in order to measure business success
• Worked daily with BLP’s Engineering resources to procure data and develop new ETL and DB processes
• Coordinated the coding and availability of master data (ex: Organizational, Location) to better normalize reporting across different business areas
• Developed Travel dashboard to provide managers with better transparency on future travel and analysis of past spend
• Developed attribution model to tie travel booking data (BCD travel agency) to AMEX corporate card transactions
• Developed detailed and executive level dashboards for CFO to track employee expenses and compliance
• Utilized Qlik SSE, Python and existing proprietary code base in order pull real time data into dashboards
• Used Python and REST API to match street locations to GPS coordinates
• Developed over 10 Dashboards to track success of new Facility & Vendor Management partnership
• Built dashboards for Infrastructure group to track CAPEX spend and Capital Project management including timelines and budget allocations

Confidential, Suffern, New York

Head Software Engineer

Responsibilities:

• Core member of BI & Data Sciences start-up with a focus on delivering packaged BI solutions
• Lead development of end to end analytics solutions from data model to semantic layer to front-end dashboards
• Data discovery and mapping of EMR data files
• Built new HANA data systems to support streamlined integration
• Personally developed analytical views in SAP HANA to support reporting
• Built multi-functional reports for product demos and rollouts
• Developed business-friendly semantic layers to support self-service reporting
• Liased with industry experts for market analysis and understanding of analytics needs
• Resourced and managed off-shore developers for development of web application

Confidential, Roseland, New Jersey

AMR App Support

Responsibilities:

• Functioned as lead reporting resource on high priority requirement using Qlikview as front-end tool
• Lead report walkthroughs and functionality Q&A for steering committee demos
• Worked with business analysts and target audience to define correct business logic for data sets
• Took hands on approach with building complex multilayered data models in SAP HANA
• Built robust metadata to support self service BI with QlikSense
• Created advanced objects such as derived metrics compound metrics, and prompts to deliver complex requirement to business.
• Created dynamic enterprise dashboards in Qlikview utilizing objects such as graphs, gauges, and tabs
• Created customized report queries to support self-service reporting
• Trained end users in scheduling and delivery capabilities of Qlikview & Qliksense
• Worked on testing data quality of HANA models and BW sources across different environments (QA, STG, PRD)
• Was tightly integrated with UAT testers so that defects were fixed and retested with quick turn around
• Developed and presented testers and report consumers training material to support Qliksense learning curve

Confidential

Reporting & Analytics

Responsibilities:

• Developed over 50 robust reports and dashboards in Qlikview and Tableau
• Coordinated with business stakeholders on development of attribution model to track online marketing performance
• Built customized Marketing Sales Funnels for multiple lines of businesses
• Developed logic and procedures in order to report metrics at a Activity view level
• Developed over 20 deep dive sales funnel to track Digital interactions and sales (WEB assets, Off site search partners)
• Led multiple UAT phases
• Traveled extensively to lead training sessions for numerous lines of business and user groups
• Leveraged existing Microstrategy reports for scope narrowing and requirement gathering
• Heavily involved in the modeling and development of multiple Oracle data marts
• Led data reconciliation efforts between legacy sources/reports and new reports
• Coordinated with business partners to gather business rules, logic, and requirements
• Led tool demos for senior management and executive level stakeholders
• Reverse engineered legacy Teradata & SQL server code for debugging
• Liasoned with internal infrastructure team for troubleshooting, compatibility needs, and best practices
• Coordinated with multiple groups for security modeling and resource allocation
• Assisted with building reporting portal prototype to consolidate all business unit’s reports & data dictionaries
• Met regularly with analytics team for deep dive training
• Developed reporting roadmap and scope analysis for multiple workstreams
• Built proof of concept statistical analysis reports leveraging SAS and Tableau
• Offered continued production support for all new development

Confidential, New York, New York

Responsibilities:

• Functioned as lead resource for new BI platform rollout
• Guided steering committee and stakeholders as to project scope and required time and cost resources
• Developed roadmap and noted milestones and prerequisites for the Business Objects migration work-stream
• Performed in-depth analysis of current state including reports, data marts, data models, source systems, ETL jobs, and all dependencies
• Coordinated with project team regarding parallel workflow such as Oracle purge, partition, and stack upgrade
• Held working sessions with Treasury department management to analyze current usage and discuss migration concerns
• Provided gap-analysis, compatibility matrix, and informed client of all best practices
• Ensured connectivity to source and reporting database by installing Oracle middleware and troubleshooted network connectivity using packet tracing
• Designed, implemented, and tested improved security model for new version
• Liasoned with in-house resources regarding IT testing and validation of post-migration content
• Personally validated multiple BO metadata objects and reports.
• Led meetings with UAT contacts to help build test cases and test scripts for user acceptance and QA testing phase
• Performed demo of new software to key stakeholders and recommended roadmap for leveraging application for greater business value

Confidential, New Jersey

Responsibilities:

• Implemented custom configurations for BusinessObjects BI Platform 4.0 across 5 different environments
• Created clustered environment for fault tolerance and high availability in Development, UAT, and QA environments
• Coordinated with project team to review optimum infrastructure and sizing for physical and virtual servers
• Enabled Active Directory authentication for BO, and implemented AD Single Sign On to support over 2000 users
• Split and sized original Adaptive Processing Sever according to SAP best practices in all environments
• Configured Web Intelligence default printer settings by editing CSS
• Edited listening configuration in web.xml to remove hung user sessions
• Setup up FTP support on BO side and created and configured FTP on server side
• Liasoned with multiple support teams to create and update detailed project Runbook
• Expertly configured the Monitoring application in BI4 to provide valid, useful metrics
• Customized BI Launchpad by swapping out stock logos on login page, home page, and help screen
• Worked extensively with IBM Websphere 7.0.1 for configuration and troubleshooting
• Edited host and service files to ensure connectivity between BusinessObjects and SAP BW
• Was contact for QA users through testing phase and helped to resolve various queries errors
• For existing BEx Queries, rebuilt calculated and restricted key figures, variables, and structures to integrate with BI4
• Configured BEx Queries to read data while navigation in transaction RSRT to improve performance
• On BW side edited Business Explorer settings, display attributes, and hierarchies for existing InfoObjects
• Planned, created, and documented content management plan including custom access levels and folder structures for objects, universes, and connections
• Created aggregates in BW proposed from statistics and poorly performing queries
• Created new multi-sourced universes in Information Design Tool using relational and BICS connections
• Configured Web Intelligence Rich Internet Application to run on specified JRE
• Created and configured new server groups through the CMC for power users to schedule and process large reports
• Researched BusinessObjects service packs release notes and upcoming maintenance schedules to suggest optimum roadmap for client
• Used Promotion Manager to migrate reports and dependent objects while maintaining same folder structure and user security
• Created custom Auditing reports to monitor and troubleshoot failed instances
• Backed up necessary files prior and followed optimum procedures for running patches
• Created highly detailed documentation for all tasks completed

Confidential, Natick, Massachusetts

Business Objects Administrator

Responsibilities:

• Heavily involved in two full life-cycle implementations of BusinessObjects BI 4.0
• Coordinated with business contacts to gather reporting requirements and wrote functional design documents
• Used the CMC to group Business Objects servers and configured job and processing servers to serve reporting needs
• Developed a clustered environment for fault tolerance and installed patches on multiple server nodes
• Troubleshot error messages and slow processing times by analyzing server process flow
• Closed numerous support tickets in support of production environment
• Attended meetings with supervisors to create detailed security model outlining the roles and responsibilities for all groups within the organization
• Created and scheduled new workflows and worklets to execute prebuilt mappings in SAP Data Services
• Enabled Single-Sign-On from Business Objects to BW using SAP authentication
• Configured compounding in BW for consolidation reporting
• Enabled and configured auditing on multiple BO severs and wrote custom auditing reports
• Assisted in the design and creation of backup and disaster recovery strategies
• Managed profiles, configured fetch sizing, and developed delivery rules for report bursting
• Coordinated with pilot users during the rollout from the UAT environment to the production environment
• Worked extensively on creating balance sheet, gross margin, monthly sales, quarterly revenue, open orders, and payment history reports using Web Intelligence to its fullest potential
• Created BEx Queries with hierarchies and aggregations for direct consumption by Web Intelligence
• Assisted with implementing CAPA reporting environment in BO by using ETL process to retrieve data from Pilgrim ERP
• Utilized HTML debugging tools to analyze workflow and locate JAR files for modifications
• Configured BEx queries for report, dashboard, and universe development
• Involved in the production support of Netweaver BW including debugging with ABAP Debugger and ETL load monitoring of BW jobs
• Created reporting to support different language needs using translation manager and Unicode
• Resolved issues with current reports due to aggregate navigation errors
• Distributed publications to dynamic recipient sources from Active Directory
• Created and altered SQL views for the development of universes
• Troubleshooted existing universes by resolving loops, chasm traps, and fan traps using contexts and alias tables
• Restricted query sizes at the universe level by implementing row-level security and mandatory date range prompts
• Created multi-sourced data foundations and business layers using Information Design Tool
• Manually deployed WAR files for Tomcat and filtered static and dynamic content
• Increased session timeout parameter on BO side, web server side, and in Windows Registry
• At management request created numerous dashboards and scorecards using Xcelsius and BO Dashboards
• Performed initial install of Tableau Server creating fault-tolerant environment by configuring primary server, multiple workers, and backup gateway
• Configured multiple instances of wgserver and vizqlserver process to maximize processing times
• Added custom permissions to projects and data sources and enabled inheritance
• Enabled authentication pass-through for data source connections
• Performed data modeling on star and snowflake schemas
• Created data extracts using custom SQL, created calculations, assigned security, and published new data sources to repository
• Configured Tableau Server to consider client’s IP address when redeeming tickets for Trusted Authentication
• Adjusted trusted authentication logging level and troubleshoot generic errors
• Utilized Tableau Desktop to build workbooks for geographical distribution data
• Built highly customized and calculated dashboards for financial analysis using scatter plots, treemaps, and line charts containing weighted means and Bollinger bands
• Created training manual for power users to create Tableau ad-hoc dashboards