Shailesh Chauhan
Summary
Solutions-oriented Business Analyst possessing unique combination of business analysis, business intelligence and applications development experience in top-tier organizations. Solid SQL query writing skills paired with familiarity of visualization tools and techniques. Successful provider of IT services 12+ years of comprehensive experience. Logical Data Analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with of vast experience collecting, cleaning, and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Senior Business Intelligence Analyst
Atos Syntel Inc. USA
03.2021 - 07.2023
- Collaborated with stakeholders across the organization to understand their needs from a data perspective.
- Gathered requirements from stakeholders to design data models and reports.
- Co-ordinate and manage service support work items with SAAS based vendors for Humana
- User Access Management of a third-party Reporting Application i.e., ‘Health Edge Answers Ad Hoc’.
- Built visualizations that enabled users to quickly interpret results from complex analyses.
- Worked with internal teams to understand business needs and changing strategies.
- Developed dashboards with Power BI to monitor key performance indicators.
- Performed quality assurance testing on newly developed reporting solutions.
- Leveraged SQL queries to extract and analyze data.
Senior Business Data Analyst
National Consulting Group LLC, USA
07.2015 - 02.2021
- Source to target data mapping.
- Lead requirements gathering and data mapping activities.
- Conduct data gap analysis to identify data integrity issues.
- Data mapping for new programs and update data model to accommodate new tables and columns.
- Design & maintain operational database model (Relational) and datamart (Dimensional). Validate monthly business reports.
- Maintain and enhance customer facing website.
- Collaborated with stakeholders across departments to define requirements for new projects.
- Analyzed existing systems and processes to identify areas of improvement.
- Facilitated brainstorming sessions with cross-functional teams for problem solving activities.
- Drafted functional specifications documents outlining project scope, objectives and deliverables.
- Created detailed process flows and user stories to document system requirements and design solutions.
- Interacted with non-technical stakeholders to deliver analyses and answer questions on deliverables.
Business Analyst
Syntel Ltd. USA & India
05.2012 - 07.2015
- Read and understand mainframe tables for different states, business line and company codes.
- Do peer review of requirement packages, provide observation comments to BA team, and ensure requirements are passed to client with no/minimal defects
- Attending weekly client status calls, delegate tasks to offshore BA team, maintain projects tracker, coordinate with project PJ's, attend QC Triage calls
- Creating functional and non-functional requirement documents for underwriting rules, master tables and reporting
- Design and create screen mockups using Visio and Lucidchart
- Data Mapping from Source – DC Shredding Database to target – SQL Server
- Create requirement packages by mapping Business rules, Data, and display forms
- Defined style, format, data description and fields to be accommodated in the forms
- Creating SRS (System Requirement Specification) as the base document for developers and testers.
Business Analyst
Zensar Technologies, India
01.2011 - 05.2012
- Client - Sanlam Life Insurance Ltd., South Africa Do as is analysis, to be analysis and gap analysis for existing & desired reports and dashboards
- Prepare source to target data mapping sheet.
Sales Manager
Development Bank of Singapore, Tata-AIG Life, HDFC
11.2003 - 12.2009
- Managed daily operations of sales department, including supervision of staff members.
- Tracked monthly sales to generate reports for business development planning.
- Developed sales plans, goals, strategies and objectives to achieve team goals and revenue objectives.
- Established relationships with key clients, while maintaining existing customer base.
- Trained, coached, and mentored junior sales personnel to ensure success in their roles.
- Prospected for new business using databases and other strategies to generate sales.
Education
MBA - Business Administration
Bhilai Institute of Technology
Durg, India08-2003
Bachelor in Commerce And Economics -
St. Thomas College
Bhilai, India08-1999
Skills
- Business Analysis
- Data Analysis
- Business Intelligence
- Stakeholder Management
- Software Development Lifecycle
- Agile Methodology
- Requirements Gathering
- Data Warehousing
- Data Modelling
- Data Mapping
- SQL
- Power BI
- Duck Creek
- User Acceptance Testing
Certification
- Certification in Business Intelligence and Data Warehousing
- LOMA 280
- LOMA 290
Timeline
Senior Business Intelligence Analyst
Atos Syntel Inc. USA
03.2021 - 07.2023
Senior Business Data Analyst
National Consulting Group LLC, USA
07.2015 - 02.2021
Business Analyst
Syntel Ltd. USA & India
05.2012 - 07.2015
Business Analyst
Zensar Technologies, India
01.2011 - 05.2012
Sales Manager
Development Bank of Singapore, Tata-AIG Life, HDFC
11.2003 - 12.2009
MBA - Business Administration
Bhilai Institute of Technology
Bachelor in Commerce And Economics -
St. Thomas College
Similar Profiles
Rahul DavaneRahul Davane
Associate Consultant at SYNTEL, Atos SyntelAssociate Consultant at SYNTEL, Atos Syntel
Bikash Kumar TiwariBikash Kumar Tiwari
Associate Consultant at Syntel Private Ltd, ATOS SyntelAssociate Consultant at Syntel Private Ltd, ATOS Syntel
Manjit SarmahManjit Sarmah
SAP S4 Hana Service Delivery Manager at ATOS-SYNTEL (Renamed as Eviden- An ATOS Business)SAP S4 Hana Service Delivery Manager at ATOS-SYNTEL (Renamed as Eviden- An ATOS Business)
Snehanshu SenguptaSnehanshu Sengupta
Senior Business Intelligence Analyst at Cloud Software GroupSenior Business Intelligence Analyst at Cloud Software Group
JESSE REAVISJESSE REAVIS
Senior Business Intelligence Analyst at Victra - VerizonSenior Business Intelligence Analyst at Victra - Verizon