OBJECTIVE:

• To work with an organization where I can get an opportunity for continuous growth and utilise my skills to the best of my abilities.

PROFESSIONAL SUMMARY:

• 7 Years of Experience in Automation, Analytics & Reporting and Work force Management. Expertise in Payroll and Incentive Management, Process MIS & Reporting, ID Management, Data Management & Automation (Web Applications & VBA) and database Management, ITIL V3 Foundation Certified.

TECHNICAL SKILLS:

Languages: VB 6.0, ASP, C#, VB.Net, ASP.Net

DBMS: MS - Access, SQL Server, Oracle

BI Tools: Crystal Report

Designing Languages: HTML, DHTML, Dream weaver

Scripting Languages: JavaScript, VBScript

Application Software: MS Office Automation using VBA, MS Excel & MS Access

PROFESSIONAL EXPERIENCE:

Senior Engineer

Confidential

Responsibilities:

• Quality check and Process Improvement for reporting
• Performing Internal checks on reporting
• Improvising reporting and analysis by automation
• Automation, Reporting & Analysis, Data Management and Crystal Reports:
• Global Health Score Card Report (Management Dashboard)
• Non Productive Asset Report Dashboard (Global) & Trend Analysis
• NA Cycle Count Report (NA Region)
• SPOC for Reconciliation Database Creation
• AMI-SAP/GSAP Reconciliation activity
• Remedy-GSAP Reconciliation activity
• UK Expenditure Reports(SAP Procurement/Finance)
• Tool/Project/Database Development:
• Warranty Search Tool Front End - MS Excel & VBA
• Report Timelines Tracker Front End - MS Excel & VBA
• Back End - MS Access
• Tasks Performed
• Gather customer Requirements, Specification and conduct the feasibility test
• Application/Database Design
• Build, Implement and code the logic
• Testing & Maintenance of the application
• Creating Technical documentation of the project
• Creating User manual & Documentation
• Conducting s (MS Excel, MS Access)
• Adhoc Request(GAMO Request System):
• Quality Dashboard Creation & Automation
• Design & Development of MS Access based Database and Tools
• Developing custom macros as per user’s request
• Designing Crystal reports & Scheduling
• ODBC Setup

Business Analyst

Confidential

Responsibilities:

• GE Aero Trend Tool Project: Front End - MS Excel & VBA, Backend - MS Access
• To gather customer Requirements, Specification and conduct the feasibility test
• Database Design and Maintenance
• Data Structure Design & Modification
• Query Design & Enhancements
• To Build, Implement and code the logic into Trend Tool
• Testing & Maintenance of the application
• To Add new utilities into the Application
• Creating Technical documentation of the project
• Creating User manual & Help manual to operate the Application
• Attending Client calls to share the updates and gather requirements for building the application
• GE Aero Analysis Project: Front End - MS Excel & VBA, Backend - MS Access
• To gather customer Requirements, Specification and conduct the feasibility test
• Database Design and Maintenance
• Data Structure Design & Modification
• Query Design & Enhancements
• Building the logic & prototype and presenting it to the client
• Creating Technical documentation for the project
• Making amendments in the model as per the client’s specification
• Attending client calls and meetings
• GE Aero Price Module Project: Front End - MS Excel & VBA, Backend - MS Excel
• Building the application as per the client specification
• Process flow Design and development
• Coding and Testing of the application
• Creating Technical documentation for the application
• Creation of User Manuals
• Adhoc Projects & Support on other Projects
• Database Design & Creation
• Logic creation and implementation ed for the Excellence & Outstanding effort for the project.
• Trained on Six Sigma Green Belt & Lean methodology
• Implemented 2 Lean project on automating GE Aero projects
• Trend Tool - Business Impact of $30420/Annum
• Price Module - Business Impact saving $5000/Annum
• Creation of Technical Project Documentation and User Manuals for all the projects

Team Lead MIS/WFM

Confidential

Responsibilities:

• MIS, Reporting & Data Management:
• To prepare various Daily, Weekly & Monthly reports (Both Internal & Client Reports)
• Daily Performance Trackers (Process performance snapshot)
• Invoicing for the process
• Real Time analysis of pending work load
• Productivity Reports
• Payroll, Incentives & Shift Allowance
• Shrinkage & Absenteeism report
• ID Management report (Directly interacted with client)
• Automation of reports using Macros
• To prepare Billing/Invoice report for the entire process
• Includes more than 150 sub processes
• Taking care of all the “ID Management” which involves taking care of all the Application ID’s & Secure Tokens used by the employees for accessing different applications & VPN/MPLS
• Interaction with Client for ID Management
• To make Payroll and Incentive for the entire process and forward it to HR
• To Process the Shift allowance and forward it to the HR
• To update, compile the attendance & preparation of Shrinkage & Attrition reports with analysis
• Creating Dashboards and scorecards for middle level & senior management
• To create various Excel based templates for Operations, HR, Quality Team & Department
• To prepare the roster based on the process requirement and share it to Operations and Transport team
• Data analysis for ad-hoc queries by top management and client
• Co-coordinating with other departments like Admin, Transport, HR & Operations
• To create & Edit Macros as per process requirement
• To make presentations for reviews using PowerPoint
• Application Development: Front End - HTML, ASP Backend - SQL Server2000/MS Access
• Understand the functional and technical requirements of the customers/operations
• Design and develop the solution/Application
• Developing the Test cases and creation of technical documentation
• Application Maintenance
• Team handling
• Team size 4 resources
• Trained Operations & MIS resources with Intermediate & Advance Excel
• Trained team members with Basic SQL Queries ed four times for Excellence, Leadership & outstanding effort for the process
• Developed an Intranet site for the Process which provided all the General reports (Roster, Productivity Report, Leave Balance, Photo Gallery & other Application links) to be accessed by multiple users at a single point of time
• Developed web based Quality portal to share daily, weekly quality updates from client and its maintenance
• Developed & Maintenance of Web based Quality Tool for Quality team to perform the Online Audits and provide feedbacks Front End - ASP, Backend - MS Access
• Developed the Web Based OLTP system for the process to keep a track of the Transactions and automate the reporting through Real time & other Reports. Also, took care of the Application Maintenance Front End - ASP, Backend - SQL Server 2000
• Successful Creation & Implementation of Shared Drive to store Data/Reports for Operations
• Successfully implemented the policies within the process:
• Leave Management System
• Break Management & Tracking System
• Incentives Plan for Associates & Team Leads