RESUME
NAME:Prashant Mohan Shilwant
DOB:31st January, 1984
ADDRESS:A-301, Kaveri CHS, Plot No – 4, Sector No - 5
Kharghar, Navi Mumbai-410 210
E- Mail I.D--CONTACT NO. :-;-
WORK EXPERIENCE:
5. Tata Consultancy Services – (5th Jan 2016 to Till Date)
Profile: Assistant Manager (BI Reporting, Automation and Visualization)
Leadership Experience:
Manage multiple technical Teams of 12 Developers (SSIS, BI Report Transformation)
Technical Experience:
Creating and Automating Reports using VBA, MS Excel and MS Access
Creating SQL queries, Stored Procedures and SSIS packages to import data
Report transformation from MS Excel to Power BI, Tableau and QlikView
Create multiple dashboard in Power BI using multiple data sources.
Data transformation and Cleansing in Power BI
Good understanding of DAX, M creating data model in Power BI.
Report transformation from SQL to Cognos
Creating and testing reports in UAT, Dev and Production environment
Working with Client and Client Tech team in case of any package or data related issues
Supporting multiple clients for requirement gathering and Automation
Providing support to internal Team with Automation
Learning SAS, R and Python as part of Data Science
4. Maersk Global Service Center (13th May 2014 to 26th December 2015)
Profile: CMD Database Specialist – Level 3
Managing Consolidate Market Database (CMD – Global Data), collecting data from various sources & transform into SQL and Access tables
Creating SSIS Packages, SQL Automation and Process automation
Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of systems, using SSIS and ETL
Developing & deploying tools in VBA
Scrutinizing the core of the issues & resolving them with a solution
Creating dashboards to help the higher management to take appropriate decision
Transformation of the process from Access to SQL to reduce the execution time
Process Automation (SQL, Access & Excel and VBA)
3. Tech Mahindra Business Services (4th December 2012 to 12th May 2014)
Profile: Team Leader - Operations Planning
Prepare and submit MIS reports to the management in India and Australia.
Maintain the reporting templates, and update the template to reflect the ever changing requirements.
Publish the weekly SMOPS Report and the weekly/monthly Executive Report on time.
Generate and maintain the monthly Board Report/MSA; submit it on time to the Management for review.
Troubleshooting of SQL queries, calculations, new report development.
Automation of MIS report using VBA and SQL
Create SQL up-loaders to upload data on SQL server
Design reports and SQL queries based on Ops team reporting requirement
2. eClerx Services Limited (2nd January 2008 to 30nd November, 2012)
A - Profile: Access Management - Senior Analyst (September, 2009 to 30nd November, 2012)
SMS Automation:
Working on Process Automation using VBA project where excel in front end and SQL server database as backend
Managing/creating check list and issue tracker
Project Estimation and co-ordination
Access Management:
Troubleshooting Network and applications issues
Managing escalations and team issues
Given training for team mates and new managers on Access Mgmt. process and activities
Co-ordinate with Client IT team for client side network and applications issues
Handling On-boarding and Off-boarding process
Client and internal Application Management (Entitlement review)
Process documentation
Managing team automation projects
Team quality and process management
MIS reporting:
Automating MIS report using Excel VBA
Business intelligence reporting
Preparing Weekly and Monthly team reports which goes to senior Management
Auditing team reports
Ad-hoc reporting
Process/report automation (MS Excel)
Managing Service Desk:
Troubleshooting Network and applications issue
Co-ordination and follow up with internal and external IT teams
Managing service desk calls
Team escalations and issues
B - Profile: Information Security (IS) - Information Security Officer (2nd January, 2008 - September, 2009)
Handling Helpdesk calls
Handling Access Management
Handling Service Desk calls
Desktop Audit
Manage team MIS reporting
Ad-hoc Reporting
Corporate Project Details:
MIS Reports Automation (Excel)
Automated AD account creation (VBA & Excel)
Account management tool using Excel
Batch file programming for pulling the data from servers
Ops Notification Automation
Costing tool using VB.NET & SQL
Academic Project:
Society Management System VB.NET & SQL
Achievements:
Awarded as Best Analyst of the Month 2 times
Sound knowledge of Networking and applications issues
Managing and auditing team MIS reports (MS Excel)
Constantly getting high banding and performance rating
1. Shell Transource Private Limited (22nd May 2006 to 31st December, 2007)
Profile: Office Assistant
Checking applications and forward them to concern departments
Scanning and Data Entry
Co-ordination and follow-up with customers for pending documents
EDUCATIONAL QUALIFICATION:
CLASS
UNIVERSITY
SCHOOL/COLLEGE
YEAR
Class
Percentage
MCA
TMV, Pune
AIMT Vikhroli, Mumbai-
First
63.8
BA
Mumbai
Wilson College, Mumbai -
Second
49.8
HSC
Mumbai
Wilson College, Mumbai -
Second
54.8
SSC
Mumbai
Wilson High School,
Mumbai -
Pass
44.8
ADDITIONAL QUALIFICATION:
Computer Hardware & Networking
MS Excel and MS Access
Active Directory
C and C++
Visual Basic 6.0 and VBA
SQL server 2000, 2005 and 2008 R2 and SSIS
I hereby declare that the information given above is all correct to the best of my knowledge. Certificates may be produced for any as if required.
Prashant Shilwant
