Aaron D'Cunha
A/*, Sadhana Villa C.H.S Ltd., Off Eastern Express Highway,
Near Runwal Nagar, Thane west, Mumbai - 400601.
Mobile: +91-989******* / Email: ******@**********.***
PROFESSIONAL SYNOPSIS / ACHIEVEMENTS:
o SAP BI 7.0 certified consultant from ATOS - SAP Authorized Training
Center, Bangalore
o MCA professional with over 6 years of experience in eCommerce and Market
Research domains
o PRINCE2 practitioner with 4 years of Project Management experience;
Online Product Launch Manager for Dell between March 2007 - Nov 2011
o Worked on Dell Data Warehouse - Client request analysis, requirement
gathering, define and run SQL queries, regular dashboard(s)/report(s)
generation and analysis; broadcast the same via Dell portal/emails to
the stakeholders
o Resultant 6 heads added across quarters due to better capacity planning
and enhanced CE
o Upsell additional services by gauging Client requirements and harnessing
the existing expertise across eClerx via Knowledge Management
o Proven ability to manage multiple launches concurrently while
achieving the milestones set; thereby maintaining SLA and Quality.
Received Client appreciation for the same
o Provided value adds, improved overall quality and productivity by
undertaking various steps...
. VSM/FMEA initiatives: AHT reduction of two activities (by 43% and 15%
respectively) to create additional bandwidth. Received internal
recognition for the same
. Created NPL Product Launch tracker along with other automations
. Quality improvement: Process quality improved by 60% post defining and
implementing audit parameters. Appropriate measures put in place post
analyzing the error pattern
o Built an action-oriented 15 member PM team across four office
locations in Mumbai and Pune
o Conceptualized / designed an intranet site for our department
SAP CERTIFICATION:
Focus Areas:
o Worked on creating custom/reusing existing DataSources, InfoCubes,
InfoObjects, InfoSources, InfoPackages, ODS, Multiproviders, Virtual
Providers and Infosets
o Design and define...
. Various data design models (Entity Relationship, Multi
Dimensional / Star Schema and Extended Star Schema models) along
with the ETL process
. Data acquisition/extraction from within SAP/Non-SAP source
system; different interfaces used for the same
. Data Transformations and Data Transfer Processes (DTP) to load
and transform data from flat files/SAP systems
. Process chains, Start/Expert routines, Transfer/Extract
structures, Update Rules
o Developed data loading strategies for master data, transactional data and
delta uploads; uploaded Master and Transactional data from flat files
o Created Aggregates, Compressions, Indexes, Multi Cubes and parallel
setups for data loading to improve query performance and utilize data
effectively
o Knowledge on SAP Business Content usage, Metadata management, documents
integration in reports, APD (Analysis Process Designer) and Open Hubs
o Reporting:
. Created custom reports, web templates and workbooks via
Business Explorer (BEx)
. Query Designer - Building custom queries using filters,
restricted/calculated keyfigures, variables, structures,
conditions and exceptions
. In addition, worked on BEx Analyzer (web/excel), RRI (Jump
Queries), Web Application Designer and Report Designer; reports
broadcast undertaken via email/portal
o Authorizations & Security - Knowledge on developing Roles, User
Authorization Objects, Profiles and User groups
o Integrated Planning - Defined and setup planning model(s) and
manual/automated planning
o Modules Covered: Enterprise Data Warehousing (TBW10), Reporting & Query
Design (TBW20), Extraction with UDI, XI and APD (TBW41), Advanced
Enterprise Data Warehousing & Reporting (TBW42), Integrated Planning
(TBW45)
TECHNICAL SKILLS:
o Applications: SAP BI 7.0, MS Project, MS Visio, SurveyCraft (design
CATI/online surveys)
o Database : SQL, MS Access
o Programming / Web Technologies: VB, C/C++, C#, Java (Core Java,
Applets), JavaScript, HTML/XML
CERTIFICATIONS:
o SAP BI -7.0 Certified Consultant
o PRINCE2 Registered Practitioner from APMG Group
o ITIL V3 Foundation Examination Certificate from APMG-International
o Initiation course in French ("Initiation la langue fran aise") from
Alliance Fran aise de Bombay
o Java programming with JDK 1.2 (SEM A) from NIIT
ACADEMIC BACKGROUND:
o Masters in Computer Application (MCA part-time) from Indira Gandhi
National Open University [IGNOU] - First Class (2011)
o Bachelors in Information Technology (Bsc-IT) from Mumbai University -
First Class (2005)
o Higher Secondary (2002) and Secondary School Certification (2000) from
Maharashtra State Board of Secondary & Higher Secondary Education -
Second (2002) and First (2000) class respectively
PROFESSIONAL EXPERIENCE:
Position : Associate Process Manager
Company : eClerx Services Ltd
March 2007 - Nov 2011
An ISO/IEC 27001:2005 certified off-shore data management/analytics
services provider for Fortune 500 Clients.
o Successfully launched 40+ products online (globally-US/ EMEA/CA / LA / BR
/ APJ) while adhering to the stringent timeline and quality requirements
of our Client
o Achieved by-ins on key directives by organizing meetings with
internal/global audience
o Successfully managed the communication channel and client engagement with
the global audience (i.e. Clients, regional stakeholders, translation
team, regional developers) while adhering to the stringent timeline and
quality requirements
o Demonstrated ability to partner with Clients to achieve their goals while
advancing business opportunities; identify business expansion scope,
provide value adds, create quarterly executive dashboards to showcase the
same
o Sustained Client loyalty and improved business by showcasing measurable
ROI efficiencies through value adds
o Successfully on-boarded processes by scheduling kick-off meets, follow-
ups and trainings; in addition prepared - project charter, process
workflows, training collaterals, time/resource estimates, defined quality
parameters, SLA and prepared SOW
o Effective forecasting and capacity planning achieved by timely updates
and rigorous follow-ups
o Define/ run SQL queries on Dell database; analysis and report generation
based on extracted data
o Enhanced SEO capabilities and online content (i.e. write-
up/translation/imagery/banner) quality
o Initiated the weekly Audit Calibration sync up with the Client as an
observer to share ideas/solutions
o Gap analysis, risk assessment and mitigation and additional bandwidth
generation made possible by undertaking FMEA and VSM per activity across
processes; revisited regularly
o Enhanced CE by creation/review of support articles on Dell's technical
support pages based on customer feedback/grievances
o Other activities include managing Operations, Knowledge Management,,
Process metrics and conducting timely 1x1's/appraisals
Position : Junior Survey Programmer/Analyst
Company : Ugam Solutions Ltd Jan
2006 - March 2007
A leading provider of market research operations, advanced analytics and
online marketing services globally.
o Created Market Research online surveys for Harris Interactive (US Client)
o Created Market Research CATI surveys for our Australian Client
o Liaise with Clients for requirement gathering, feasibility study and
defining the data flow diagrams of the survey projects received
o Prepared project charter, process workflows, training collaterals,
time/resources estimation during the process(s) on-boarding phase
o Created weekly executive reports and monthly dashboards; published the
same to Clients
o Project allocation done across team based on effective capacity planning
and forecasting
o Liaise with the Client/in-house CONFIRMIT team for requirement analysis
and convert the raw data ( obtained via online surveys) into executive
reports; to be shared with the Clients
o Trained and mentored existing/new team members, undertake refresher
training to increase productivity and improve overall quality
Position : Technical Customer Service Representative
Company : Accenture Services Pvt. Ltd
June 2005 - Jan 2006
A global management consulting, technology services and outsourcing
company.
o Troubleshoot internet connectivity related issues on behalf of SBC
(Southwestern Bell Corporation)
o Received Customer appreciation for successfully troubleshooting the
internet connectivity issue in record time; was on top of the competition
within the Team
o Trained and mentored existing/new team members to increase productivity
and improve overall process AHT
o Actively participated and represented the team in org-wide events
PERSONAL INFORMATION:
Date of Birth : 7th August 1984
Marital Status : Single
Language : English, French, Hindi and Marathi
Aaron D'Cunha