EXPERIENCE SUMMARY
Over ** years of total experience
Over 12 years of IT experience
Undergone training for Leadership Program within TechM
Exposure to Customer Interaction, Requirement Analysis, Design, Architectural Aspects, Tool Evaluations, Development, Testing, Implementation, Project Management
Functional experience includes Telecom, Life Insurance Industry, Banking -Audit, Manufacturing Industry and Mutual Fund Industry
Excellent interpersonal skills and leadership qualities
Excellent understanding and logical aptitude
Excellent problem-solving
ACADEMICS
Bachelor of Engineering in Mechanical Engineering, Pune University, India, 1995
TECHNICAL SUMMARY
SKILLS
TOOLS
New emerging technologies
Hadoop/HDFS and related tools
Business Intelligence
BusinessObjects
Oracle Business Intelligence
Solution Design
Reporting
Crystal Reports
Data Warehousing
Solution Design
Databases
Oracle 8 and above
SQL Server
DB2
Sybase IQ
HP Vertica (Architectural and conceptual understanding. No hands on)
PL/SQL
GUI(S)
Visual Basic
LANGUAGE
JavaScript
WORK HISTORY
Duration
Organization
Role
September 2006 till date
Tech Mahindra Ltd.
Sr. Tech Lead
August 2003 – September 2006
iDecisions Consulting Pvt. Ltd.
Technical Lead/Project Lead
April 2003 – July 2003
GainIT Solutions
Programmer Analyst
February 1998 – March 2003
Anamika Engineers
Versatile role being the proprietor
May 1996 – January 1998
MAMCAD Engineers and Consultants
Designer Engineer
July 1995 – April 1996
Bajaj Tempo Ltd.
Trainee Engineer
January 1995 – June 1995
Thermax Babcock and Wilcox Ltd.
Trainee Engineer
July 1993 – December 1993
Thermax Babcock and Wilcox Ltd.
Trainee Engineer
ACHIEVEMENTS
Handled a team of around 100 team members spread across design, development, environment and testing streams
Customer appreciation, including programme director’s acknowledgement
Dollar savings
Worked as SME for proposals regarding reporting solutions
Worked on value added reports for ATT with self-driven initiatives
Worked on performance improvement
Worked on POC: Analytical reporting for ATT
Developed good relationships with domestic and international customers and received complimentary emails from them
Demonstrated value in the methodology which we followed to win a project deal
WORK EXPERIENCE
Tech Mahindra Ltd.
February 2013 – Present (17 months)
Large Telecom in United States of America
Data Analysis/Architecture: Environments: Cassandra, Oracle
Currently working as a Data Analyst
Participate in requirement gathering
Sizing estimations
Defining solution architecture path
Participate in solution and data architectural calls and decisions
Requirement analysis, data analysis and data mapping
Interfacing among development, test teams, sources and destinations as a data analyst and approver
Environment: Cassandra
June 2012 – February 2013 (6 months)
EIP Usage Repository Project; Client: Large Telecom in United Kingdom
Data acquisistion through CDRs, processing the CDRs into data model, usage reports
Summary of work: Interactions with data consumers, understanding the needs, interactions with data streams, understanding of data, observe correctness of data and one version of truth
Responsible for
BI Solutions
oOracle BI Solution and implementation
oOracle Exadata: Performance Tuning
oOracle Data Integrator: ETL
oCustomer Interaction
oModeling
September 2008 – July 2012 (46 months)
EIP GSEDW Project; Client: Large Telecom in United Kingdom
Enterprise Data Warehouse for acquisition of source data from 20 different source systems, integration of data, data procesing into Data Mart, reports and dashboards based on the data
Worked on OBI rollout, GCSO, 21CCE projects, Global Hub deliveries, which expects GSEDW to produce reports, which can be consumed directly by the end users.
Summary of work: Interactions with data consumers, interactions with data streams, reconcilation of data, observe correctness of data and one version of truth, alerting for pattern irregularities, consoldation of requirements
Achievement: Multiple streams of data users were using same data with different point of view. After interaction with the end users, the same was understood and an effort was taken up to streamline these activities. Users were brought on to the same platform, explained different scenarios to the end users, understood their requirements and then it was left to the end users to interact with each other and decide the way forward. It helped greatly in understanding the data and using similar/unique approaches to look at the data
Responsible for
BI Solutions
oOracle BI Solution and implementation
oOBI problem-solving
oOracle Performance Tuning
oOracle: PL-SQL
oBusiness Objects: Solution and Support
oCustomer interaction
OBI and BO support
oAdministration of OBI
Development using CIT methodology
oAutomated testing
Extending technical support to other projects
July 2008 – August 2008 (2 months)
Development of Crystal reports for VSC Billing Project; Client: A Large Telecom, UK
Requirement gathering and analysis
Devising BI solutions for implementation through Crystal Reports on Oracle 9i Database
Oracle: Creation stored procedures
Creation of Crystal Reports
Integration of reports with solution
Expedited report creation and delivered in extra quick time
October 2006 – June 2008 (21 months)
Development of BusinessObjects reports for OSAM-ERMS Project; Client: ATT, USA
Modification of existing Universes to suit additional requirements
Modification of existing reports to suit additional requirements
Creation of Universe and reports
Introduction to scheduling of reports for periodic refresh of the reports: Modifications in the existing Universe and reports to support scheduling
Achievement:
Performance enhancements at the report level which saved reports storage space by 40% and report refresh time by 60%
iDecisions Consulting Pvt. Ltd.
April 2006 – September 2006 (8 months)
Deployment of BusinessObjects across A Large Life Insurance Company – Mumbai and
The 4 universes and 150 reports based on these universes were created to cater to the requirements of 11 departments
Responsible for
Requirement gathering
BO Solution Design and Implementation on DB2 Database
Building stored procedures to calculate daily opening balance
Customer Interaction
Environment: BusinessObjects 6.5
December 2005 – March 2006 (4 months)
Assessment of tools for reporting at a Large Mutual Fund Company – Mumbai
Responsible for
Requirement analysis
Implementation of BusinessObjects and Crystal Reports on Oracle Database
Environment: BusinessObjects XI and Crystal Reports XI
December 2005 –February 2006 (3 months)
Development of Universe and summary reports for a Large Gas Distribution Company – Ahmedabad
Responsible for
Requirement analysis
Customer Interaction
Implementation of Business Objects reporting solution on Oracle Database
Environment: BusinessObjects XI
January 2006 – February 2006 (2 months)
Development of Universe for Control Self Assessment (CSA) for A Large European Bank – Mumbai
Responsible for
Requirement gathering and analysis
Customer Interaction
Implementation of Business Objects Reporting Solution on SQL Server
Creating stored procedures for processing the data for reports
Environment: BusinessObjects 6.5
August 2005 – September 2005 (2 months)
Creation of inventory reports in Crystal Reports for A Pharmaceutical Company – Mumbai
Responsible for
Requirement gathering and analysis
Customer Interaction
Implementation of Business Objects Reporting Solution on Oracle Database
Environment: Crystal Reports 9
March 2005 – August 2005 (6 months)
Development of Universe for Audit Tracking System for Large European Bank – Mumbai
Responsible for
Requirement gathering and analysis
Customer Interaction
Implementation of Business Objects Reporting Solution on Oracle Database
PL-SQL procedures required for data loading for reports on Oracle database
Environment: BusinessObjects 6.5
June 2004 – October 2004 (5 months)
Performance tuning and support for the existing BusinessObejcts environment at an IT Outsourcing Company, Pune
Responsible for
Performance tuning at report level
Performance tuning at database level on SQL Server
Environment: BusinessObjects 6.5
September 2003 – May 2004 (9 months)
Development of Production Planning Universe and reports based on that for a Manufacturing Company India – Kolkata
Responsible for
Requirement analysis
Design and development of Universe on Oracle Database
Reports creation, administration and distribution
Environment: BusinessObjects 6.5
GainIT Solutions
April 2003 – July 2003 (4 months)
Development of Inventory Management software and implementation of Business Objects Reporting Solution for Traders in Engines and their spare parts
As a Consultant was responsible for
Customer Interaction
Requirement gathering and analysis
Study of flow of the physical processes
Database design
GUI Design
Implementation of solution using visual basic development
Performance tuning on SQL Server
Reports development using Crystal Reports
Environment: Visual Basic, M.S. Server 2000, Business Objects 6.5.1, Crystal Reports
Anamika Engineers
February 1998 – March 2003
1.To devise and implement a Production Planning system
As a Team Lead (with a team size of 4) was responsible for
Understanding the customer requirements, studying purpose of introducing the system
Customer Interaction
Requirement analysis and further interaction with customer
Study of flow of the physical processes Deriving software flow accordingly
Design of database
Design of forms (user interface/GUI)
Imposing and checking validations to suit customer
Implementation of solution including reports in Crystal Reports
Location of the factory: Akola, Maharashtra
Environment: SQL Server, Visual Basic
2.Production Management for a Malaysia-based company Tralvest Sdn. Bhd., Johor Bahru, Malaysia
As a Team Lead (with a team size of 4) was responsible for
Understanding the customer requirements, studying purpose of introducing the system
Customer Interaction
Studying manufacturing process flow
Requirement analysis and further interaction with customer
Study of flow of the physical processes Deriving software flow accordingly
Design of database
Design of forms (user interface/GUI)
Imposing and checking validations to suit customer
Implementation of solution including reports in Crystal Reports
WORKSHOPS AND TRAINING PROGRAMS ATTENDED
Training for ISO Procedures: Project Management., Facilities Management, HR and Training, Business Development and most importantly, Internal Training, Duration: 4 days: May 2005, Leadership Program – Tech Mahindra