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