SUMMARY:

• Manage a dual role of client service and client development; responsible for consulting and providing analytics support to one of the world's largest computer technology company - Dell. Worked wif the Dell direct marketing team by providing them wif data driven marketing strategies and solutions.
• Provided forecasting solutions wif time series methodology for the demand and sales of Dell direct sales.
• Provided guidance to the offshore colleagues to provide analytics-driven profitability analysis wif Tableau and actionable growth opportunities to leadership.
• Analyzed various marketing promotions and measured the TEMPeffectiveness of each promotion and Managed on time delivery of various monthly and weekly reports
• Informatica developer wif over 2 years of Industrial experience in developing and maintaining the Informatica workflows for a major Norway based Telecom client.

TECHNICAL SKILLS:

Core skills: SAS, R, Python 2.7, SQL, PL/SQL, Unix Shell, Perl, C, C++, Hadoop, Java.

Database: Oracle9i/10g/11g, Sybase

ETL tools: Informatica 9.1/9.5

Tools: SAS Enterprise Miner, Weka, SAP Business Objects, SQuirreL (SQL client), Toad, Adobe Marketing Cloud (Omniture).

Environment: s: Windows, UNIX, Fedora. PL/SQL (Oracle PL/SQL Developer Certified Associate)

PROFESSIONAL EXPERIENCE:

Confidential

Analytics Consultant

Responsibilities:

• Worked wif the Consumer and Small business marketing analytics segments of Dell Direct sales by providing strategic analytical solution based on the changes trends in the business.
• Built forecasting models on quarterly basis using ARIMA(X) for the major demand and sales KPIs for Dell to provide them wif a possible targets for the quarter and tracked the forecasted resulted on weekly basis to provide any risk associated wif the quarterly targets.
• Forecasting models were built to assess the Demand and Sales from both online and offline - Online units, Offline Units, Visits and calls based on historic data, planned pricing and marketing spends taking in account for seasonality of the periods.
• Helped in reducing the MAPE% from 6.1% to 4.3% by introducing value driven variables in to the models.
• Weekly accuracy review meeting were driven to understand the changes in business and provide data based opinions on how marketing team could be efficient in achieving the targets.
• Developed tableau visualizations and dashboards to implement a BI solution for Sales, Product and Channel KPIs.
• Developed a 360 business dashboard wif multiple panels and parameters for the Gaming segments (Alienware) which went on to become the most consumed business tool for the Dell Direct segment.
• Helped the CSB Marketing and Merchandising teams in planning, executing and analysing the digital and offline campaigns by providing an assessment on campaign performance thereby halping them to make major marketing driven decisions.
• Performed Ad-hoc analytic tasks for the Consumer and Small Business segments of Dell. Solutions provided were marketing driven aiming at getting better ROIs.
• Worked wif various marketing vehicle leads both online and offline to provide them wif an ROI analysis of the marketing dollars and provide them wif insights on getting the most of each dollar spent in marketing.
• Built and migrated many of the Dell’s standard reports from excel sheets to user friendly tableau dashboards.
• Expertize in Adobe Marketing Could (Omniture) which was the online visits tagging tool for Dell.
• Worked as an onshore consultant for a team of nine putting in efforts to provide the business context to the offshore team and also standing responsible for the client deliverables ensuring quality and timely delivery.
• Drove weekly business reviews and quarterly business reviews to understand the business challenges and work towards bridging the gaps.
• Expertise in Dell’s transactional database (Teradata).
• Worked wif multiple marketing channels ranging from Affiliates, Banners, Search terms, Social Media to offline channels like ROPs/FSIs, Spadea etc. - Provided an ROAS/MOAS for each of the campaigns.

Confidential

Jr. Systems Engineer

Responsibilities:

• Used SAS to make prediction on missing gene codes using chi-square testing and neural networks.
• Implemented statistical models using SAS to understand the disease patterns between parents and children.
• Using HDFS system for data extraction and analysing.
• Developed python scripts for data collection and extraction.
• Worked in the backend in installing Hadoop cluster of 56 nodes.
• Created virtual environments for various teams.

Confidential

Systems Engineer

Responsibilities:

• Developed Informatica mappings for automation of site synch and patch activities used by radio-planners.
• Worked as a Single point of contact (SPOC) for the customer applications Mobile Inventory and ASTRIX.
• Designed reusable mapplets which were flexible enough to be used in many other workflows making it easy for the client. Used Business Objects for reporting and creating dashboards on client’s request.
• Created procedures according to the service level agreement dat were used in the workflows.
• ed “Star of the month” twice for smart work and on time deliveries along wif many client appreciations.
• Received a for winning the Java Quiz Contest.