Back to Search Results

AMOL A.

Software Engineer

Commitment
0/ 5
Competency
0/ 5
Reliability
0/ 5
  • Overall Experience: 8 Years  
  • Agile Software Development:
  • Amazon Relational Database Service:
  • Application Lifecycle Management:
  • Business Activity Monitoring:
  • Big Data:
+ More

AMOL A. 

Software Engineer

Commitment
0/5
Competency
0/5
Reliability
0/5

Time zones ready to work

  • Eastern Daylight [UTC -4]
  • Eastern European [UTC +2]
  • Australian EDT [UTC +11]
  • Dubai [UTC +4]
  • New Delhi [UTC +5]
  • China (West) [UTC +6]
  • Singapore [UTC +7]
  • Hong Kong (East China) [UTC +8]

Willing to travel to client location: Yes  

About Me 

A progressive, decisive and innovative professional, highly valued for expertise in interpreting corporate vision and strategy; passionate about solving problems, always
A progressive, decisive and innovative professional, highly valued for expertise in interpreting corporate vision and strategy; passionate about solving problems, always looking for breakthrough ideas and collaborate with business stakeholders and cross functional and multi-disciplinary teams to deliver business intelligence and analytics solutions. Result-oriented and focused Business Intelligence Professional with strong work ethic and commitment to offer quality work; over 7 years of experience in end-to-end BI Solution Architectures and Project Management As a Tableau Manager, managed large complex BI projects to meet deadlines by understanding the importance of timeline, priorities, communication and commitments Expertise in BI Application Life Cycle Management including scoping, requirement analysis, technical specifications, effort estimates, risk management, planning, monitoring, reporting and communication management In-depth understanding of Data Modelling, Data Warehousing, Data Lifecycle/Retention and end-to-end BI Solution Architectures Strong expertise in Databases, SQL Query Tuning/Optimization, Automatic E-Mail Notifications, Table Indexes, Views, Stored Procedures, and Functions
Show More

Interview Videos

Signup to see videos

Risk-Free Trial, Pay Only If Satisfied.

Portfolios

JPMorgan Chase, Capital One, Netapp, State of colorado, Metlife, Aetna

Website Link:

Role:

Key Result Areas:

· Configured & deployed customer solutions by facilitating out of the box dashboards and designing approx. 60 customized dashboards for different clients based on VMware IT Business Management (ETL/BI) Solution

· Identified var

Key Result Areas:

· Configured & deployed customer solutions by facilitating out of the box dashboards and designing approx. 60 customized dashboards for different clients based on VMware IT Business Management (ETL/BI) Solution

· Identified variances between expenses & costs to monitor budget variances and facilitated more effective planning and budgeting/forecasting of spend on IT

· Conducted business requirements workshops and organized end-user training sessions to educate clients on product configuration & implementation with understanding of overlapping functions and other interdepartmental dependencies

Highlights:

· Proficiently automated the flow of the cost models, resulted in redirecting 95% of IT finance resources from data collection and aggregation to data analysis and achieved 100% chargeback of IT services for IT Cost Optimization

Played a key role in compiling IT financial data for 30 data sources/systems into data visualization platform & data analysis of IT service costs at enterprise & individual department level in a short span of time of 1-2 months.

Show More

Skills:

Tools: Tableau

UnitedHealth Group

Website Link:

Role:

Key Result Areas:

· Variance Analysis: Provided meaningful, concise and clear variance analysis to senior management on financial issues and performance and reasons thereof

Highlights:

· Ensured smooth o

Key Result Areas:

· Variance Analysis: Provided meaningful, concise and clear variance analysis to senior management on financial issues and performance and reasons thereof

Highlights:

· Ensured smooth offshore transition, operational excellence, process enhancement and closure of monthly financial cycle amounted to $2 Billion yearly

· Remarkably automated & improved the business process for closing the monthly finance cycle within record time of 10 days as against to 25 days and got “Bravo Award” for the same; recommended the data quality methodology to VP Finance

Show More

Skills:

Tools: SQL DeveloperTableau

UBS Bank

Website Link:

Role:

Key Result Areas:

· Generated Tableau/SQL/Excel reports function cross-functional teams to support Migration Factory a global initiative with more than 450 resources

· Created more than 100 SQL Ad-Hoc reports supporting business

Key Result Areas:

· Generated Tableau/SQL/Excel reports function cross-functional teams to support Migration Factory a global initiative with more than 450 resources

· Created more than 100 SQL Ad-Hoc reports supporting business decisions by providing insights to improve accuracy and reduce the timeline of decision making

· Built and published 10 customized interactive reports and dashboards in Tableau for different business lines

· Gathered MIS/BI requirements for migration project by working with multiple cross-functional projects to understand data usage to meet the business SLAs related to the delivery of data/reports

· Engaged in creating database objects like tables, views, procedures, triggers, and functions using MS SQL in Data Warehouse using linked servers to provide definition, structure and to maintain data flow efficiency

Show More

Skills: SQLTableau

Tools: SQL DeveloperTableau

Employment

Software Engineer

2018/12 - 2019/08

Skills:

Your Role and Responsibilities:

Key Result Areas:

·         Responsible for creating, improving, and developing BI project plan

·         Spearheaded business requirements gathering, project scheduling & execution, resource administration for timely deliverable and status track

Key Result Areas:

·         Responsible for creating, improving, and developing BI project plan

·         Spearheaded business requirements gathering, project scheduling & execution, resource administration for timely deliverable and status tracking; performed activities IT Infrastructure analytics and MIS Reporting

·         Developed Tableau visualizations and dashboards using Tableau Desktop, Cross Tabs, Heat Maps, Box, Whisker Charts, Scatter Plots, Geographic Maps, Pie Charts, Bar Charts, Density Charts, Donut Charts; facilitated robust features in charts such as creating bar charts in tooltip

Trainings Attended:

·         Power BI

·         Alteryx

·         Python

Show More

Manager

2018/04 - 2018/12

Skills: Data WarehousingData Warehousing

Your Role and Responsibilities:

Key Result Areas:

·         Generated Tableau/SQL/Excel reports function cross-functional teams to support Migration Factory a global initiative with more than 450 resources

·         Created more than 100 SQL Ad-Hoc repo

Key Result Areas:

·         Generated Tableau/SQL/Excel reports function cross-functional teams to support Migration Factory a global initiative with more than 450 resources

·         Created more than 100 SQL Ad-Hoc reports supporting business decisions by providing insights to improve accuracy and reduce the timeline of decision making

·         Built and published 10 customized interactive reports and dashboards in Tableau for different business lines

·         Gathered MIS/BI requirements for migration project by working with multiple cross-functional projects to understand data usage to meet the business SLAs related to the delivery of data/reports

·         Engaged in creating database objects like tables, views, procedures, triggers, and functions using MS SQL in Data Warehouse using linked servers to provide definition, structure and to maintain data flow efficiency

Show More

Deputy Manager – Analytics

2016/04 - 2017/08

Skills: MS OfficeSQLTableauVBA

Your Role and Responsibilities:

Key Result Areas:

·         Variance Analysis: Provided meaningful, concise and clear variance analysis to senior management on financial issues and performance and reasons thereof

Highlights:

·

Key Result Areas:

·         Variance Analysis: Provided meaningful, concise and clear variance analysis to senior management on financial issues and performance and reasons thereof

Highlights:

·         Ensured smooth offshore transition, operational excellence, process enhancement and closure of monthly financial cycle amounted to $2 Billion yearly

Remarkably automated & improved the business process for closing the monthly finance cycle within record time of 10 days as against to 25 days and got “Bravo Award” for the same; recommended the data quality methodology to VP Finance

Show More

Business Consultant

2013/12 - 2016/01

Skills: MS Office

Your Role and Responsibilities:

Configured & deployed customer solutions by facilitating out of the box dashboards and designing approx. 60 customized dashboards for different clients based on VMware IT Business Management (ETL/BI) Solution Identified variances between expenses & costs to monitor budget variances and facilitated m
Configured & deployed customer solutions by facilitating out of the box dashboards and designing approx. 60 customized dashboards for different clients based on VMware IT Business Management (ETL/BI) Solution Identified variances between expenses & costs to monitor budget variances and facilitated more effective planning and budgeting/forecasting of spend on IT Conducted business requirements workshops and organized end-user training sessions to educate clients on product configuration & implementation with understanding of overlapping functions and other interdepartmental dependencies Highlights: Proficiently automated the flow of the cost models, resulted in redirecting 95% of IT finance resources from data collection and aggregation to data analysis and achieved 100% chargeback of IT services for IT Cost Optimization Played a key role in compiling IT financial data for 30 data sources/systems into data visualization platform & data analysis of IT service costs at enterprise & individual department level in a short span of time of 1-2 months.
Show More

Management Consultant-Associate

2011/03 - 2013/12

Skills: MS Office.NetMicrosoft Access Database - MDBMssql

Your Role and Responsibilities:

Business Intelligence (Apptio): Configure, test, & document more than 30 data sources from IT systems into meaningful dashboards, reports and underlying data models to meet functional design and specifications to drive IT decisions using ETL (Extraction, Transformation & Loading) of data for analysi
Business Intelligence (Apptio): Configure, test, & document more than 30 data sources from IT systems into meaningful dashboards, reports and underlying data models to meet functional design and specifications to drive IT decisions using ETL (Extraction, Transformation & Loading) of data for analysis and design and optimization of data models and load-scripts for data visualisation. (Winner of High Performance Award) Highlights: Essayed a key role in reducing the time span of engagement by 50% by implementing a data entry web based application (in VB.Net and MS Access) Commendably headed data analysis & reporting of over 100 ad hoc reports to facilitate statistical analysis & data integrity checks for identifying key risk indicators, remediate the business process and delegate work to calculate interest rate using MS Access Remarkably developed a Segregation of Duties (SOD/SOX) analysis application and a reporting desktop software for JDE World, Avantis and Prism in MS Access that reduced the review time by 70%
Show More

Education

2009 - 2010

2003 - 2008

2017

2010

2008

US work authorization

Are you legally authorized to work in the United States? Yes

Do you or will you require sponsorship for a US employment visa (e.g. H-1B)? Yes

Skills

Agile Software Development Amazon Relational Database Service Application Lifecycle Management Business Activity Monitoring Big Data
+ More

Hobbies

Painting - http://amolambilwade.blogspot.com/

Preferred Languages

English -