Sunil Kumar Dubey

Sunil Kumar Dubey
M-1306, Antriksh Golf View-2, Sector-78, Noida, UP.

Email: sunildubey29051984@yahoo.com (Mob) +91 9412309146 +91-9711320448
Seeking a challenging role in the field of Data Analytics, Business Intelligence and Reporting to contribute towards
organizational success and to reach Senior Management Level.
SYNOPSIS
Competent and result oriented professional with demonstrated capabilities in analysis, developing and generating
reports offering overall 9+ years of IT experience with 7+ year of experience in SAS Analytics, reporting in Banking,
Investment, 401(k) and Healthcare domains.
A result-oriented decisive leader to maintain high quality standards to meet challenges of this fast paced, high turn
analytics industry. Highly ethical and trustworthy.
 Possessing valuable insights, keen analysis and team approach to implement best practices to achieve business
excellence.
 Adept at working in high pressure environments with strict deadlines and multiple deliverables.
 Ability to interact with end-users, clients, managers and technical personnel.
 Strong leadership, problem-solving, planning, team-building and project management skills.
CORE COMPETENCIES/CAREER HIGHLIGHTS
 Successfully leading a team of 7 analysts in the Wipro Digital and Operations Platforms Business Unit (Wipro
Ltd.) for US Health and Wealth BI Team.
 Self-motivated individual with strong technical & analytical skills.
 Always keen and eager to face up to challenges by means of novel and innovative ideas.
 Experience in extracting, manipulating data, and creating Data Sets from various sources like Excel, flat files,
using PROC IMPORT techniques and SQL pass through facility.
 Experience in automating reports using SAS/MACROS, SAS/ODS, SAS/PROC SQL and Tableau
Desktop/Tableau Server.
 Effectively training the analysts on SAS/PROC SQL and Tableau.
 Received appreciations from seniors and clients for effective performance
 Skilled in using SAS Statistical procedures like PROC REPORT, PROC FREQ, PROC MEANS.
 Weekly interaction with client for Requirement handoffs, Requirement analysis and interpreting it as per data
stored in our system.
 Creating users, groups, projects, Data connections, settings as a tableau administrator.
 Writing SQL Queries to fetch required data from Database tables as per requirements.
 Creating Dashboards & Reports with decent graphics and publishing using Tableau Desktop, Tableau Server.
 Recipient of “Platinum Award 2013”
 Recipient of “Gold Award for delivery Business results.
EDUCATION
 B. Tech in Computer Science and Engineering from Uttar Pradesh Technical
University (U.P.T.U) in 2008 with 71.2% marks.
 Intermediate from St John’s School (ISC Board) Varanasi, UP in 2002 with 65%
marks.
 High School from St John’s School (ICSE Board) Varanasi, UP in 2000 with 77%
marks.
PROFESSIONAL EXPERIENCE
Wipro Limited (Alight Account), Noida (Sept’12 –

Present)
Lead Analyst (Reporting to Senior Manager)
Key Responsibilities:
Analyzing data to enable LOB (Line of Business) Partners/Clients to understand specific areas to focus in order to
improve Business Performance by conducting Statistical analysis of various performance indicators and providing
tools to keep effective control over the health of the Business.
 Strong experience in Base/SAS, SAS/Macros, SAS/SQL, SAS/ODS, SAS/Stat, SAS/Connect and competent in
carrying out statistical analysis on large-scale data.
 Good knowledge on Tableau development using sets, Parameters, Calculated fields, Joins, Data blending,
Filters, Actions, Groups, Formatting, sorting, Drill downs, Dashboards and Stories.
 Excellent experience with exporting SAS Results to different formats such as HTML, PDF, CSV, Excel using
SAS/ODS & Proc Export for reporting and presentation. Reviewing the quality of deliverables sent to the
Client
 Understanding the problem statement/Business objectives: It included interaction with the client, to
understand the client requirements and defining the Business objective
 Developing Analysis plan comprising of issue tree, data preparation plan, techniques to be used in the
analysis, defining timelines.
 Ability to connect to different data sources from Tableau, presenting the good Visualization of data, Different
way of using the filters and parameters.
 Perform various sanity checks on Data, extract the useful data and report the fetched data.
 Developing final output, after deriving insights and quality checking.
 Experience in creating interactive dashboards using Tableau Desktop software.
 Good knowledge in publishing the tableau dashboards to Tableau server to share with business partners.
 Delivering reports to clients using Share Point or Shared Drive or Tableau Server.
 Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw
data and writing SAS Program and creating reusable Macros.
 Have good understanding of Tableau architecture, design, development and end user experience.
 Always received positive feedback from my leaders, business partners and peers for taking the personal and
shared accountability of the team goals and going beyond the call of duty to support the business needs.
HTC Global Services, Gurgaon (July’11 –Sep’12)

Software Engineer (Reporting to Team Leader)
 Reviewing the quality of deliverables sent to the Business.

 Understanding the problem statement/Business objectives: It included interaction with the client, to
understand the client requirements and defining the Business objective
 Developing test scripts.
 Execute test scripts from Quality Center.
 Finding defects in the system and report in the Quality Center tool.
 Tracking and working with the team for the implementation of analysis done
Aon Hewitt, Noida (June’09 –
July’11)
Software Engineer (Reporting to Team Leader)
 Handoff requirements meetings to start the Analysis.

 Understand and Analyse Client’s requirements.
 Creating EXCEL Reports and conduct walkthroughs.
 Create the Detailed Test Script by referring requirement document, writing Test cases, and Test plans and
executed them.
 Creates issues as needed when actual results do not meet expected results.
TECHNICAL EXPERTISE
Tools/Technologies: SASV9.2/UNIX, SASV9.4, SAS/EG 6.1 (SAS Enterprise Guide) SAS/BASE, SAS/MACROS,
SAS/SQL, SAS/STAT, SAS/ODS, JCL, Tableau Desktop, Tableau Server, CICS, Mainframe Testing, Software Testing,
SDLC, Quality Center.
Operating System: Windows, UNIX, IBM Mainframes.
Language: SQL, HTML, XML.
Database: DB2, Teradata
Office Tools: MS-Office, Word, Excel.
Core Competencies: Statistical programming, Data Analysis, Reports Development, automation.
Date of Birth : 29th May, 1984

Father Name : Late Banshu Dubey
Marital Status : Married to Amrita Dubey
Hobbies : Spending time with my kids.
Reference : Available on request
Nationality : Indian
Sunil Kumar Dubey Noida

Sunil Kumar Dubey

Uploaded by

Copyright:

Available Formats

Sunil Kumar Dubey

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Sunil Kumar Dubey

Uploaded by

Copyright:

Available Formats

Sunil Kumar Dubey

M-1306, Antriksh Golf View-2, Sector-78, Noida, UP.

CORE COMPETENCIES/CAREER HIGHLIGHTS

Wipro Limited (Alight Account), Noida (Sept’12 –

HTC Global Services, Gurgaon (July’11 –Sep’12)

 Reviewing the quality of deliverables sent to the Business.

 Handoff requirements meetings to start the Analysis.

Date of Birth : 29th May, 1984

Sunil Kumar Dubey Noida

You might also like