Mar 2022 – Feb 2023 · 11 mos · India · Hybrid

• Leading the end-to-end analytics of Loan Frame’s Supply chain financing business by closely working with all business functions across Loan Frame to fulfill their Data, BI, descriptive, and predictive analytics needs.
• Working closely with management to understand reporting requirements and getting them translated into Dashboards and reports.
• Presenting the derived insights to all the stakeholders.
• Responsible for complete reporting & analytics for the organization by partnering with business heads from different functions (Sales, Finance, Operations, Marketing, Product, HR, etc.)
• Using BI Tools for visualizations to create best-in-class analytical solutions and making them available for Management to drive business.
• Guiding the business heads in best data practices by periodically detailing out new process requirements to improve data quality of business and system processes.
• Maintaining consisting data collection from various sources into a structured format.
• Cleaning the raw data using ETL processes to make it ready for SQL runs of reporting.
• Liaising with multiple internal and external stakeholders to get business reports executed smoothly and on time.
• Personally prepared reports in line with functional requirements of Loan Frame’s external Stakeholders.
• Currently managing a team of 4 resources.
• Have extensive experience in BI tools like Power BI,

Apr 2021 – Mar 2022 · 11 mos

• Promoted to BI Tech Lead and handling a team of 16 members, consisting of Reporting Analysts & Core BI Developers.
• Managing multiple projects from various domains.
• Mentoring & Training resources to develop inhouse technical expertise.

Jul 2019 – Apr 2021 · 1 yr 9 mos

• Building Analysis Services reporting models.
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Able to implement row level security on data and understand application security layer models in Power BI.
• Proficient in making DAX queries in Power BI desktop.
• Able to develop tabular and multidimensional models that are compatible with warehouse standards.
• Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
• Knowledge and experience in prototyping, designing, and requirement analysis.
• Knowledge and skills of secondary tools such as Microsoft Excel, Share-point etc.
• Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation.
• Understands SQL and NoSQL queries to process data for reporting.
• SSRS Integration to Power BI.
• Experience in Data Gateway for data refreshing, content Pack Library.
• Publishing reports to app.powerbi.com and setting up the necessary connection details and scheduling. Along with knowledge of connecting Microsoft Power BI Desktop to various data sources.

Nov 2017 – Jul 2019 · 1 yr 8 mos · Greater Atlanta Area

• Served as the functional and technical SME during development, implementation and testing of highly complex PRICING MATRIX for PCNA’s Remarketing business.
• Identified new marketing areas and distribution channels for Porsche's Remarketing business.
• Designed & Implemented Porsche's participation in Cox's Manheim Auction.
• Identified key issues affecting business and selected appropriate strategic choices and alternatives for success. (Ex: Pricing Matrix & Audit)
• Built and maintain BI dashboard and data visualizations to enable performance analysis, and communication. Ensured global standards are applied across all sales processes.
• Developed a streamlined process to incorporate highly complicated industry standards of KELLY’s BLUEBOOK and adjusted BLACKBOOK data in PCNA’s pricing matrix.
• Contribute to the development of remarketing business strategy by customer meeting, workshops, etc.
• Monitored the Market trends, their analysis, and reporting.
• Priced around 700 Cars per month which amounted to 45 Million USD with the Sales elevation of about 10%.
• Collaborated with National Remarketing manager to develop, expand, and maintain DMS (Dealer Management System) based dashboards and visualizations for better dealer decisions.
• Responsible for setting the strategy for E2E Reporting process of the entire Remarketing Business of PCNA.
• Provide weekly and monthly detailed sales and remarketing portfolio status reports to the National Remarketing Manager. Proficient in creating reports that outlines Repossession and Remarketing’s overall performance using SQL and MS Excel.
• Performed data analysis by extracting data from database through SQL and performing Analysis in MS Excel (Macros/ Pivot Tables/ Conditional formatting/ VBA) and Visualizations in PowerPoint/ BI.

Aug 2017 – Dec 2017 · 4 mos · Greater Atlanta Area

• Worked as a graduate assistant in college.
• Responsible for assisting the professor in teaching Students.
• Preparation and evaluation of test papers.
• Maintenance of student data including grades and performance.
• Conducting qualtrics survey's for various classes.
• Providing help to undergrad students on basic MS office techniques.
• Grading assignments
• Proctoring lab sessions
• Providing assistance on lab assignments/ challenges

Feb 2016 – Jul 2017 · 1 yr 5 mos

• Client - [GE Appliances-Haier]
• Lead formal requirement reviews to obtain document signoffs and review plans, risks, issues, defects, and dependencies identified during requirements gathering.
• Converted high level business requirements into executable, detailed user stories to enable move from Worksoft Certify to Selenium.
• Very high proficiency in MS Office applications such as MS Word, Excel, PowerPoint, MS Project, etc.
• Conducted daily and monthly revenue, expense and volume monitoring. Produced and distributed standard daily and monthly reports to leaders.
• Created 500 automated scripts using Worksoft Certify for the rigorous testing of the application modifications done by functional consultants and reporting of bugs.
• Ability to create detailed, well-written documentation for a variety of audiences to support the project, delivering the work on time and under budget.
• Creating new test set automation using Worksoft certify manually as well as using LiveTouch.
• Creating a Layout and record set for the child process and master process.
• Responsible for batch execution in Regression Testing using Quality center.
• Raising defects in QC
• Executing the test set in different environment like QRD, TRD, ERD and ARD system for health check.
• Worksoft Certify DB set-up and client installation.
• Mentoring and providing technical assistance to the team members to ensure smooth deliverable.
• Involved in developing Automated Test Scripts and E2E processes within the delivery timelines & running the same for multiple iterations to check their correctness.
• Helping the business teams to build the logic for their business process scripts development-using Certify even when Certify Learn cannot identify the objects of application under test.
• Preparation of Weekly status report for test automation execution status.

Nov 2014 – Feb 2016 · 1 yr 3 mos

• Client - [GE Power and Water]
• Responsible for the most complex functional assignments, including functional and solution design, specification creation, requirements gathering, testing strategy development, and working with partners to define standard integration.
• Participated in all phases of the project lifecycle, produced formal project documentation and other relevant artifacts, prioritized project resources, balanced competing priorities, worked directly with clients to meet their needs and handle concerns, and contributed to hands-on development where needed.
• Solid track record with designing/architecting enterprise solutions while following formal delivery methodologies and best practices.
• There were workflow issues affecting the efficiency of service for users in the existing version of IBM Maximo 7.1 Application.
• Led the implementation effort for GE-Oil and Gas in upgrading Maximo to v7.5, an IBM-developed Enterprise Asset Management tool, in order to achieve greater efficiency and improve data integrity
• Upgraded the Maximo Application from 7.1 to 7.6 for 7 sites and 3000 users using technologies SQL, BIRT, WebSphere, JavaScript and HTML and provided continuing support of the application.
• Each site received a unique user-friendly solution. Site demand for upgraded version increased as a result due to efficiencies gained from the implementation.
• Incidentally, 14 more sites were upgraded under my supervision.
• Extensive training in core JAVA programming for a period of 3 months. Also, trained in other languages such as SQL, XML.

Jul 2014 – Oct 2014 · 3 mos · Kanpur Area, India

• Excellent client services skills including written and verbal communication and organizational skills
• Manage monthly sales reporting and forecasting and developed presentations for senior management
• Detailed sales trends by product line for quarterly business reviews and performance comparison to budget and prior year
• Prepared forecast and budget presentations showing consolidated company results
• Worked within a team of people responsible for the completion of private fund subscription documents and new account opening paperwork on behalf of clients
• Completed fund subscription documents on behalf of clients.
• Implemented the timely and accurate processing of investment operations (i.e. transaction processing, investment funding, cash transfers, wire set-up, standing letters of authorization, etc.) in accordance with guidelines and regulatory requirements

Apr 2013 – Jun 2013 · 2 mos · Bhilai Area, India

• There was a need to provide solution for better management of raw materials and inventory for the authority.
• Created a simple workflow process
• Trained over 300 employees with different soft skills for better reporting and logging.
• The easier reporting process and trained employees helped in better management of materials which resulted in 25% depreciation of quarterly scrap records.

May 2012 – Jul 2012 · 2 mos · Kanpur Area, India