Handling a fantastic Data analysis team for Philips GBS, we perform deep dive analysis and deliver on commitments. As a committed person, I thrive in unstructured environments. We are not just a team of individuals who work by the clock. We are a team who think before we ink.

Key projects at LITC that have made a difference in the organization are given below. AP Duplicate finder  Data flows from SAP to SQL Server and reported in Excel User marks the data in Excel as True / False duplicates. Data from SAP loaded in SQL reports in Excel. Predictive models were built depending upon the vendors who submitted duplicate bills, frequency/time period of the duplicates to identify the trend and seasonality of the purchase timelines. This project was… Show more Key projects at LITC that have made a difference in the organization are given below. AP Duplicate finder  Data flows from SAP to SQL Server and reported in Excel User marks the data in Excel as True / False duplicates. Data from SAP loaded in SQL reports in Excel. Predictive models were built depending upon the vendors who submitted duplicate bills, frequency/time period of the duplicates to identify the trend and seasonality of the purchase timelines. This project was run in collaboration with the SAP team, BI team, SQL DBA and the Finance team The business impact for the historical records rolls up to USD 2M for data from July 2015 After go live(July 2017) we have identified and stopped duplicate payments amounting up to USD 700KConcur Duplicate Expense claim Analytics Issue: Employees making double claims as out of pocket expense when purchased with company card and/or submitting the same claim in two different reports Data was extracted from concur manually Created 3 rules for identification of duplicates Proactively identify duplicates before submitting the process for review Result: Duplicates were identified before approval and the tool results in not approving the true duplicate expensesRobotic Process Automation Created a bot for the Lennox warranty process which runs unattended for the warranty registrations Created a bot for identification of the phone subscriptions from AT&T website and retrieves the address, status and mobile model used Resulted in 6 days of 8hrs per day time savings – bot results were published in 9 hrs for 1500 registrations Certified and trained from Automation AnywhereTools Used SQL Server, Excel VBA, Tableau, Automation Anywhere Client Show less

Investment Management - Mutual Fund analysis and Metrics reporting for the funds managed by Dreyfus and Newton at BNY Mellon. Fund pricing analysis - A comparative study was made with the funds at BNY Mellon with fund pricing of other mutual funds using Morningstar. Asset flows reporting from various data sources were integrated into SQL server and reported out Month/Month to the directors of the Investment Management Team. Heat map analysis was done for the high performing funds by region… Show more Investment Management - Mutual Fund analysis and Metrics reporting for the funds managed by Dreyfus and Newton at BNY Mellon. Fund pricing analysis - A comparative study was made with the funds at BNY Mellon with fund pricing of other mutual funds using Morningstar. Asset flows reporting from various data sources were integrated into SQL server and reported out Month/Month to the directors of the Investment Management Team. Heat map analysis was done for the high performing funds by region. Every month the one pager slide of the Equity Market analysis, Bonds, Fed rates, FX Rates were presented to the executive team of Investment management.⇒ Led a team of 5 analysts managing data mining & manipulation while analyzing and producing extracted data for reporting.⇒ Designed one-slider dashboard for analyzing market summary data and presented to Investment Management group of directors.⇒ Prepared CFO deck to determine snapshot of previous month and performed market analysis of competitors' mutual funds.⇒ Created mutual fund dashboard in SQL Server facilitating with data checkpoints to collate data from Excel pivot table report.⇒ Reconstructed six excel reports with different data structures for obtaining single version into SQL Server and deriving a five year roll back in a single pivot table in MS Excel.⇒ Analyzed historical data of mutual funds impacting market trends and determined exact returns for the current and future months.⇒ Performed peer fund analysis and peer fund performance analysis of mutual funds by comparing categories from the Morningstar Direct data.Technologies used: • SQL Server, • VBA, • PowerPoint,• Access, • Morningstar Direct, • Quandl Show less

I had to take up my family business for automating the systems and upgrade them with the idea of selling this company. I completed the end to end process of automation in 1 year and we have successfully sold our business which is operational even today after 33 years of existence.

⇒ Elevated to Program Manager position from Consultant role in November 2012 and promoted to Consultant role from Business Analyst in September 2009.⇒ Achieved White Knight award for demonstrating best performance in the year 2008, and received Life Saver award for picking up a critical project and completing within deadlines without a lag in 2011.⇒ Handled worldwide end-to-end sales compensation operations single-handed for 3 half-yearly cycles, and created and analyzed sales metrics… Show more ⇒ Elevated to Program Manager position from Consultant role in November 2012 and promoted to Consultant role from Business Analyst in September 2009.⇒ Achieved White Knight award for demonstrating best performance in the year 2008, and received Life Saver award for picking up a critical project and completing within deadlines without a lag in 2011.⇒ Handled worldwide end-to-end sales compensation operations single-handed for 3 half-yearly cycles, and created and analyzed sales metrics like focused sales objective (FSO), linearity metrics and sales performance metrics that resulted in saving $1M.⇒ Reduced costs by utilizing existing third party database and avoiding duplicate campaigns and performed survey analysis reporting final results to executive management.⇒ Spearheaded migration project of LDSM from Vertica to SAS platform. ⇒ Project managed the team for migration of prospects, leads and contacts data from Siebel to SAS platform. ⇒ Facilitated data migration of marketing campaigns from Siebel to SAS platform.⇒ Acted as a single point of contact for telemarketing, direct mail marketing and email marketing campaigns, by providing prospects, leads and contacts from third party databases like Duns & Bradstreet, Harte Hanks, and Hoovers and performed as a custodian of complete datamart.⇒ Created a SQL Subject Matter Expert (SME) portfolio for HP Global Analytics and directed four member team to develop solutions for Labor Demand and Supply Management data.⇒ Successfully executed companywide migration of campaign marketing data from Siebel to SAS driving a team of 6 analysts.⇒ Automated internal audit data flow in SQL Server for immediate data collation and reporting while advising for ad-hoc projects with critical deadlines.⇒ Analyzed data for the sales pipeline to determine the conversion ratio by performing analysis of won and lost deals across different stages of the pipeline. Show less

CI- Go To Market Services Team: I have been working with the GTM team for the past 2 years as a Business continuity lead, leading out on campaign operations and resources to Analysts.

I was handling end to end World wide Sales compensation using SQL Server and Excel reporting as the front end. As I was also interested in the Marcom - Webanalytics, I was involved in the Web analytics for sometime and I moved on to become a consultant after this tenure as a Database lead

⇒ Administered the SQL Server database for company contacts.⇒ Performed Database integration for OLTP systems

⇒ Prepared MIS reports and developed database (still in place) for Invoice Requisition system (IR system) for loaned, owned and accrued resources. ⇒ Created dashboards for HR department to derive the company wide (team wise) employee attrition records.⇒ Assisted in data migration of various servers from production to OLAP systems and generated reports using excel dashboards.