Resume

Sign in

Business Intelligence, SQL, OLAP modeling, Python, Reporting

Location:
Sunnyvale, CA
Posted:
March 10, 2020

Contact this candidate

Resume:

Dedicated business intelligence analyst with **+ years of experience in the retail and manufacturing sector facilitating clients Insights and Data Science team. Proven track record of improving the efficiency and effectiveness of business decision making through development of OLAP modeling solutions containing dimensions (with added hierarchies), measures and calculated measures.

TECHNICAL SKILLS

Databases - SQL Server, Oracle 9i/10g, Postgres, Teradata, MonetDB

BI Tools – SSIS, DTS, SSRS, Business Objects XI, PowerBI, Datastage, Inhouse IRI’s OLAP applications like ASCS Workbench, Advantage Pro, Unify.

Scripting language - Python

Platforms and OS - Windows, UNIX,

Data Warehouse Modeling - ETL/data marts, OLAP modeling, reporting

EXPERIENCE

Technology Manager Information Resources Inc. April 2012- Present

Lead the design and development of focused analytical solutions for retailers and CPG manufacturers based on the National Consumer Panel (NCP) data

Design and develop OLAP multidimensional models for their appropriate interaction with Oracle Exadata and now MonetDB

Create the timeline and scope of project solutions and implementation plans

Lead the timely delivery of OLAP product solutions and incremental changes that have revenue associated with it

Build scalable OLAP model frameworks to be leveraged across multiple client implementations reducing the time and effort of developing a new OLAP solution by 30%

Ensure thorough testing of solutions prior to delivery

Collaborate with the Data investigation team on any data issues in the production environment

Coordinate with various teams within the organization for the project implementation

Assist in streamlining the process for getting model related inputs in a centralized application

Manage the offshore team for the deliverables of several clients

Project: Consumer and Shopper Insight Models

Create data models using NCP data for major retailers and manufacturers such as Walmart, Target, CVS, Walgreens and many more

Closely work with the Product managers to implement new measures and defining KPIs in the OLAP solutions

Partner with Client Insights team and Delivery managers to cater specific requirements of a specific client

Successfully delivered and maintained from 70 to now 180+ OLAP solutions used by IRI clients.

Project: Consumption Data Models

Develop new OLAP solution based on coffee and connected brewer data to help understand brand's consumption performance and SKU level brew settings and how those settings differ by segment

Create independent dimensions based on Brewer data such as – Brew size, brew temperature, brew strength, brew variety and other demographic and geography-based data from NCP

Create the consumption model using Postgres relational database

Project: Market Advantage Models – Based on POS Data

Create data models using actual POS data shared by the retailers for analysis.

Closely work with the Product managers to implement new measures and calculations in the OLAP solutions

Partner with Client Insights team and Delivery managers to cater specific requirements of a specific client

Business Intelligence Analyst IDC Technologies June 2011 - March 2012

Create custom data model for the pricing tool of the memory chips using the pricing data mart

Migrate about 10% of DataStage jobs to SQL server integration services

Prioritize and resolve cases based on criticality

Provide an estimated timeline after analyzing the case

Collaborate with DBA’s and system support teams to enhance and automate code to production

Develop complex mappings to load data from Oracle, SQL SERVER, SAP and flat files to DataMart in Oracle database

Generate reports for the business users using SSRS

Lead Engineer HCL Technologies (DSGi) June 2007- Dec 2010

Install SSIS, establish connections with remote systems such as Teradata, Mainframes & Oracle

Discuss, validate and document best practices for SSIS development

Develop 20+ SSIS packages with detailed logging and configuration files for large volume data warehouse

Automate the execution of SSIS packages by scheduling it to run through a job scheduler

Maintain and support of more than 50 SSIS packages

Review code and technical designs of other ETL developers

Created dashboards and reports using Business Objects

Project: Supplier Delivery Conformance Application

Participate in the entire development lifecycle from gathering business requirements, implementation to acceptance phase

Create High Level Design for ETL based on business requirements

Create weekly reports for the on-site team

Develop SQL Server Integration services 2008 packages in the application for reporting

Document all package enhancements to assist team members in efficiently supporting the applications

Utilize version control tools such as VSS and PVCS to maintain the source code

Design and develop mapping to extract, clean, transform, integrate and load data into different target

Develop mappings using fuzzy logic, lookup and other complex transformations

Perform SSIS tuning & best practices, reusability, variables and workflow design

Project: Supplier Value Improvement Application

Analyze SQL code to write SQL queries and procedures to resolve issues

Monitor daily data feeds using Control-M

Split up the data feed to ensure the availability of the application during the business hours

Act as the Project Quality Analyst and Configuration Controller to ensure the quality standards are maintained

Conduct root cause analysis for issues during production support

Improve efficiency in warehouse and supplier value application by ensuring smooth functioning of systems

Map business requirements and transalte them into functional specifications and detailed test plans

Create service installation plans, procedures and scripts, service release deployment and validation plans

EDUCATION

B. Tech in Computer Science Engineering with Distinction May 2007

Punjab Technical University, India



Contact this candidate