Contact information
Neeraj Doshi
C234, East Padmavati Colony, Mumbai
(789)-121314
Career objective
Dedicated IT Professional with more than 8 years of multifaceted experience, including data warehouse, database, and business intelligence, as well as working directly with customers in a consulting capacity throughout the full software life cycle.
Career Achievements
- Designed and developed Informatics mappings to replace the existing PL/SQL code, decreasing processing time by 40% and reduced the burden on the database server up to 60% to meet the SLAs.
- Successfully collaborated with national and international teams to plan and execute development projects. Effectively managed 3 offshore and 2 onsite development resources.
- Convert Functional Requirements into Technical specifications and adhere to SLAs.
Experience
Data Warehouse Consultant
Kalpna Groups, Mumbai, 2006-Present
- Extracted data from Mainframe databases (ADABAS) using Power Exchange and loaded into SQL Server Database tables.
- Modified existing Java code to meet the current data requirements.
- Train and manage developers, advising other groups in organization on data warehouse development, and Informatics development best practices.
- Executed test cases, diagnosed and resolved problems and generated problem reports.
- Provide on-call support to production system to resolve any issues.
- Documented frequent problems with solutions to help support teams reducing average response time.
- Provide on-call support to production system to resolve any issues.
- Documented frequent problems with solutions to help support teams reducing average response time.
Data Warehouse Consultant
General Life Insurance, Mumbai, 2003-2006
- Designed and developed data mart using Oracle Warehouse Builder to populate the integrated information repository with contracts, transactions, assets, commissions, enrolments and producers.
- Managed a team of 8 developers.
- Developed Type-2 mappings using Oracle Warehouse Builder, Triggers, and bulk load scripts and tested them using TOAD.
- Worked with the IT team to bring in the data required into Business Objects Universe so as to make available for super users to create adhoc reports.
- Worked with business users to provide the data in form of complex reports and excel sheets for analysis.
- Created & tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down.
Data Warehouse Consultant
BPL Internationals, Mumbai, 2000-2003
- Extracted data at regular intervals from 30 different source systems across the globe and populated an Enterprise Data Warehouse to support management information reporting needs.
- Analyzed the existing data model and further optimized the design to speed up daily data loads.
- Implemented the Business Intelligence and Global Standards model using Kalido.
- Used Star schema to populate Data into Cube, using dimensions and fact Tables.
- Created classes, dimension and measure objects according to business requirements.
- Generated effective reports using formulae, sections, breaks and filters and supported users in various adhoc issues.
Education and Certification
- M C A
IIT Chennai, 2000
- B Sc.
Pune National Collage, Pune, 1997
Honors
- Member of IT Solution team to Maharashtra Govt. IT Advisory Group.
- Honored by Mumbai Science Collage Doctorate.
References
Aditya Chopra
Chief Manager
Kalpna Groups
adichopra_B123@yahoo.com
Recent Comments