Nitin Lomash Email & Phone Number

San Francisco Bay Area

San Francisco Bay Area

United States

San Francisco, California

San Francisco Bay Area

Responsibilities:Created Dashboard based solution to address attrition in the ISMC (Independent Small and Medium Chains) segment that both identifies stores that are Profitable, High Performers, and Highly Engaged with McKesson (and vice versa) and also presents key program performance and store pathway engagement metrics. The solution involved combining elements from over 15 data sources across 3 different data platforms into an integrated data view. This helped marketing to understand program penetration and design a more effective and focused marketing campaign across different regions.Lead and created a comparative study of pharmacy coverage by designing cubes and hierarchies for areas across urban, suburban and rural America. Comparing a combination of Healthmart and Walmart pharmacy coverage against other competitive pharmacies. As an impact of the study Mckesson made a decision to partner its AccessHealth with Walmart and increased its footprint across all the regions where it had no or very small presence and thus able to increase its market share and compete with other chains.Developed Tableau dashboards to study the value and effectiveness of the MedSync (Prescribe Wellness) program by comparing enrolled pharmacies and their script patterns against the pharmacies not enrolled. The study shows how the program has helped in bringing more scripts for the enrolled pharmacies. Developed multi-dimensional views to create dashboards to study the sales pattern of Flu and Core vaccines, and how Flu vaccinating stores enrolled in the Vaccine Starter Kit (VSK) program have been able to see a growth in the vaccine sales and revenue Year over Year. The analysis involved creating data pipelines and data mart which was then used as a source for Tableau dashboards. The analysis helped in evaluating the overall effectiveness of the VSK program.

Stamford, Connecticut

As a Sr. Analyst, I am responsible for interpreting business needs/requirements and build solutions to help them overcome existing issues, and challenges faced while implementing large initiatives, thus reducing costs and increasing success rate.Responsibilities:Delivered a 360 degree view on sales operations i.e a reporting solution which gave insights into every aspect of sales’ lifecycle from the time of first call till the time of installation of services in a customer premise. This information helped business to understand gaps in the current process and in fixing these issues which converted potential subscribers into actual subscribers and increase revenue.Provided a comparative study on various video equipment, with regards to their trouble calls, repair calls and removal rate there by providing a view of issues and expenses related to these devices. It enabled procurement team to pin point the problem devices and replace them with the ones less prone to issues.A dashboard solution providing a dynamic monthly view of unreturned video equipment from the customer who got disconnected or transferred, helping collections team to understand the loss in revenue.A detailed analysis for customers who swapped one type of video equipment with another. This analysis was clubbed together with the change in the revenue and helped in overall revenue projection after the swap.Provided detailed analysis for customers who get reconnected after soft or hard disconnect on their delinquent amount compliance. The analysis also looks into the collection analysis i.e the amount collected before restarting customer services.Actively engaged in defining key operating metrics, documenting customer requirement and working with technical team on building Next generation data warehouse which is designed to cater 10 million subscribers as oppose to the current 4 million.

Stamford, Ct

Responsibilities:Worked directly with Traders for gathering their reporting requirements & analyzed data source systems to create data model implemented to develop Flow Credit Trading dashboard, which shows data summary and details about trades and positions since 2011 for various Instruments such as Bonds, Derivatives, Equities & Loans.Created several QlikView Data files (QVD) to extract & store data from various databases and load it in QVW files to display it in dashboards.Worked on dashboards to display analytical information about current Trade Volumes trends for High Yield bonds.Created dashboards for stale curves and stale marked bonds used for compliance as part of Dodd Frank guidelines and for internal audit.Worked with QA analysts to document test procedures and participated in testing various dashboards & verifying data using Bloomberg market access.

Shelton, Ct

Responsibilities:Created several QlikView Data files(QVD) to extract & store data from database and load it in QVW files to display it in dashboards.Worked on dashboards to display analytical information about the current fleet of S-92s (commercial helicopters) with regards to fleet’s total flying hours, flight hours based on operators, availability of each aircraft and projecting fleet’s total flight hours along with total number of aircraft availability for next 60 months.Created dashboards for parts removals; to help business analyzing trend of most frequently removed parts per aircraft.Using Google map web services, created dashboard to display aircraft with its location around the world on maps.

Ny, New York

As an AVP, I am currently managing a global team with its presence in 3 different regions, thereby leading and delivering outstanding results by motivating team members while dealing with the cross cultural issues. Actively involved in designing and documenting the Chargeback model, costing, and budgeting for the group.Responsibilities:• Setup shared BI platform to be used across the bank by various application teams thereby providing a more cost efficient solution.• Managing global teams & providing BO Administration and consultancy to users for developing reports in BOXI 3.1• Coordinating installation and configuration of BOXI 3.1 with Weblogic• Directing infrastructure team on server design and implementation plans• Designing and Implementing the Security framework for the BOXI3.1 infrastructure• Planning, Testing, and Implementation of Service packs/Fix packs and other patches• Identifying key processes and services to implement monitoring• Configuring real time monitoring system for BO production environments & take corrective measures to avert any major outages• Designing Test cases, performing drills & tracking the results to ensure working of all the alerts.• Setting up BOXI clustered environment, implementing failover, load balancing, and integrating SSO with LDAP• Tracking & Analyzing System performance • Planning and implementing failover and disaster recovery setup for BO Server• Evaluating organizational needs, estimating number of users, calculating system resources, analyzing thresholds and evaluating the servers and system performance and tuning them as needed• Providing end users training on reporting features and leading user forums biweekly on issues/concerns• Developing Reports and Dashboards using WebI, QaaWS & Xcelsius• Working with vendor to resolve issues• Meeting with prospective users and giving demo on the BO tool set• Designed & Implemented ITIL best practices along with SDLC processes

Groton, Ct

Responsibilities:• Identified potential areas of cost savings in off-shoring IT processes, developed proposals and reports, and made recommendations • Prepared action plans with timelines for transition of technical processes from Pfizer to Infosys (onsite/offshore)• Prepared project plans, reviewed and monitored milestones and deliverables on a weekly/monthly basis with the steering committee• Proactively raised project risks to the steering committee and provided solutions• Created status reports for the senior management highlighting status, growth and achievements• Involved in designing & defining the Security and Setup of the Business Objects XI R2 environment deployed on over 28 servers for over 150 projects• Executed the build of BOXI R2 environment as a primary environment deployed on 40 servers which was able to serve more than 10,000 users• Worked as Sr. Team Lead and had been responsible for preparing & analyzing the weekly & monthly reports to identify the areas of improvement• Involved in migration from Business Objects 6.5 to BO XI R2. Defined process and migration of the content (Universes, Report Objects, Measures, Goals, Dashboards) into the Production environment• Managed and Maintained Business Objects environment by understanding the issues faced by various teams and troubleshoot the issue to fix/tune the performance of the environment as per the business needs• Applied fix packs and/or service packs provided by the vendor as a fix to the issue/bug in the environment after testing the fixes in the sandbox environment• Successfully upgraded Informatica 6.2.2/7.1.3 environment to 8.1.1 involving creation of domains, repositories, integration services and migrated content from version 6.2.2 to version 8.1.1• Efficiently managed Informatica environment by understanding the issues faced by various teams and tuning the environment as per their needs

Project# 1MATRIA HEALTHCARE, Atlanta Data Junction DeveloperEnvironment: SQL Server 2000, Data Junction, VBScript, MS VSS, Test Director 8.0Responsibilities:• Efficaciously gathered requirement for Design of field level mappings• Extracted the sources from different files and developed mappings by using Data Junction Designer• Involved in extracting Data from Raw form to the Standard form using VBScript• Involved in debugging of mappings and unit testing• Handled mapping, flow design and time based Scheduling• Successfully extracted complex data from the raw Database by developing Logic using VBScript Project# 2Worked as a Software Engineer and a part of the development team developing the Operation Management Application using J2EE Technologies.Environment: Oracle, J2EEResponsibilities:• Collected and compiled user requirements into functional documentation • Designed databases for the system using ER Models • Involved in creating Database Tables with integrity Constraints & Writing stored Procedures• Created Test Cases and led the Functional Testing, System Testing, and Regression Testing.• Investigated software bugs and interfaced with the developers to resolve Testing Issues

High Impact Leadership Program, Business Administration And Management, General

Ms, Computer Software Engineering

With minor in Data Science

Bachelor Of Engineering (Be), Electrical, Electronics And Communications Engineering