Aug 2015 – Aug 2023 · 8 yrs · India

• Working as a part of Techno Finance Transformation program (Reporting and data analyst), my responsibility to created tools and automate reports also to find out best possible solution for AMEA and global level.
• Key Responsibilities
• ● Develop, maintain and publish existing reports, and modify as per requirement.
• ● Create Dashboards and Answer reports from multiple subject areas in OBIEE.
• ● Create reporting tool using VBA, SQL, Excel, PPT etc...
• ● Creating database and maintain the same.
• ● Administration of OBI dashboard access, development and changes.
• ● Implementation of new technologies to enhance the process.
• ● Connect with Vendors (Like. TCS, Tech Mahindra, and Seteria) for any change or technical consultation.
• ● Additional ad hock reports and activity.

Jan 2015 – Aug 2015 · 7 mos · Gurgaon, Haryana, India

• In retail stores, online and through their mobile devices. Each week, more than 245 million customers and members visits nearly 11,000 stores under 65 banners in 28 countries and e-commerce websites in 11 countries. With fiscal year 2015 net sales of $482.2 billion, Walmart employs 2.2 million associates worldwide.
• Role: Senior Analyst GTS
• Key Responsibilities
• ● Create productivity and performance reports.
• ● Working on development and automation of new reports.
• ● Setup database and update on daily and weekly basis.
• ● Logic implementation and creating new layouts.
• ● Automation of report using VBA, Access and SQL.
• ● Additional ad hock reports and activity.

Feb 2011 – Jun 2015 · 4 yrs 4 mos · Gurgaon, India

• Agilent Technologies, a spin-off of Hewlett-Packard Company, broke records on Nov. 18, 1999 as the largest initial public offering (IPO) in Silicon Valley history. When measurement matters, engineers, scientists, manufacturers, businesses, researchers, and government agencies rely on Agilent tools and solutions.
• ● Logics implementation and report formatting.
• ● Prepare report and Automate thru VBA and Formulas.
• ● Finding requirements and create tools using VBA forms and macros.
• ● Database Maintenance and data analyses Extract data thru SQL, Access, Oracle and other data sources.
• ● Additional ad hock reports and activity.

Aug 2010 – Feb 2011 · 6 mos

• Cvent is the largest event management software company in the world with 650+ employees and 80,000 users in 34 countries. Cvent offers software to help meeting planners increase event attendance and decrease event costs. In addition, it has tools that help meeting planners find event venues, and marketers conduct web surveys and emarketing campaigns.
• Working in PSG department as an MIS analyst.
• Key Responsibilities
• Prepare templates for new reports and automate thru VBA and Formulas.
• Finding requirements and create tools using VBA forms and macros.
• Database Maintenance and analyses.
• Additional ad hock reports and activity.
• Extract data thru SQL and Access.

Aug 2008 – Jul 2010 · 1 yr 11 mos

• It is a life insurance company, joint venture between Max India Limited, which is a one of India's leading multi-business corporate, and New York Life International.
• Was working in Agency Contracts department as an MIS-Analyst.
• Certificates/Appreciations
• Star of the Month
• You are a Winner Certificate – Twice
• Appreciation mail and flag from HR head
• Sent projects for Green/Yellow belt.
• Key Responsibilities
• ● Creating MIS, Dash board, Quality reports, Head Count reports
• ● Prepare performance reports of agents, QA.
• ● Database Maintenance and tools designing in VBA using Forms and macros.
• ● Conducting data analysis - including analysis of performance, activities and process related trends
• ● Synthesize the results and findings out of the above analysis and prepare summary reports for distribution to senior management team on a regular pre-defined basis and
• ● Prepare regular and ad-hoc reports based on business partner requirements
• ● Interact with potential and existing vendors on a regular basis to assist in contract negotiations..
• ● Initiatives/ Process improvements/Additional responsibilities
• ● Redesigning Performance MIS, Dashboard, Head count report.
• ● Automate the reports to save time and maintain accuracy.
• ● Establish Agency Contracts MIS, Bulletin
• ● IRDA Amount utilization report