Pankaj Bhambhani Email & Phone Number

Pune, Maharashtra, India

Pune Area, India

Pune Area, India

 Responsible for offshore services as well as product development for four major Pharmaceutical accounts. The team consists of 80+ members including two Project Managers.  Contributed to solutioning, strategic planning, resource forecasting and deployment, billing and invoicing, cost vs benefits, analyzing risks and impacts on departmental processes and goals. Ensuring continuous process improvements, strong quality governance and deepen customer relationships Accountable for… Show more  Responsible for offshore services as well as product development for four major Pharmaceutical accounts. The team consists of 80+ members including two Project Managers.  Contributed to solutioning, strategic planning, resource forecasting and deployment, billing and invoicing, cost vs benefits, analyzing risks and impacts on departmental processes and goals. Ensuring continuous process improvements, strong quality governance and deepen customer relationships Accountable for new proposals, contributing in Sales/Pre-Sales cycle, preparing and presenting responses for RFP/RFIs. Lead adaptation of Agile methodology for anchor programs resulting in rapid implementation. Customer and stakeholder management Helping the Sales and Pre-Sales team with RFP/RFI and proposals.  Ensuring compliance to quality standards for the deliverables Show less

Pune Area, India

 Techno-functional managerial role for multiple projects Communicate with the project team, management and supporting business stakeholders to ensure that project tasks are being completed & handoffs to other groups are successful  Involved in end-to-end Data Warehousing as Delivery Manager and contribute in planning, estimation, vendor management, risk identification, mitigation.  Propose approaches by studying market trends, Big Data related tools/techniques (Hadoop, Pig… Show more  Techno-functional managerial role for multiple projects Communicate with the project team, management and supporting business stakeholders to ensure that project tasks are being completed & handoffs to other groups are successful  Involved in end-to-end Data Warehousing as Delivery Manager and contribute in planning, estimation, vendor management, risk identification, mitigation.  Propose approaches by studying market trends, Big Data related tools/techniques (Hadoop, Pig, Sqoop, Tika), available Data Appliances(Netezza), for driving changes in data integration space. Remotely manage data integration projects developed by vendors and ensure qualitative outputs are delivered Working closely with domain architects to define data strategies and principal for data accumulation.  Arranging cross skills trainings and attaining operational efficiencies Show less

Pune Area, India

 Resource Management for delivery unit(80+ resources) Project Manager handling team of 10+ team(onsite and offshore model). Preparation of Weekly reports, risk measure, conducting Function point analysis.  Architecting near real time and batch feeds, at multiple server locations. Articulating transition for the engagement.

 ETL processing using Informatica Power Center, for integrating vertical systems data and creation of OLAP cubes.  Analyze and integrate various system data and scale it in reportable format.  Development and maintenance of Java applications used for loading risk data in Risk system Articulate complicate processing and information.  Defining and Designing rule engines for model control Unauthorized exposure investigations

Team Size 20+; About Project Risk Management team is responsible for providing a platform capable of real time analytical data as soon as it becomes available. The system operates 24/5 and stores over 300m risk records a day. As part of new initiative and FED requirements, a new model control system is formed to ensure that all system adhere to trading models. Data is derived from various trading systems like Bank loans, Securities and share trading, repos, commodities, derivatives, etc… Show more Team Size 20+; About Project Risk Management team is responsible for providing a platform capable of real time analytical data as soon as it becomes available. The system operates 24/5 and stores over 300m risk records a day. As part of new initiative and FED requirements, a new model control system is formed to ensure that all system adhere to trading models. Data is derived from various trading systems like Bank loans, Securities and share trading, repos, commodities, derivatives, etc. Various risk curves and associated values are being collected and analyzed. Daily reports are also being generated to track violations, unauthorized trades, expired trade, outstanding exception, etc. Responsibilities ETL processing using Informatica Power Center, for integrating vertical systems data and creation of OLAP cubes. Analyze and integrate various system data and scale it in reportable format. Development and maintenance of Java applications used for loading risk data in Risk systemArticulate complicate processing and information. Defining and Designing rule engines for model controlUnauthorized exposure investigations Technologies Used Informatica Power Center, Core java, shell scripts, perl, linux, IBM Db2, SQL procedures. Show less

 Delivery lead for all development efforts. Process analytics and solutions for proposed data warehouse(without impacting the phased rollout).

Team Size 10+; About Project Areva's e-TerraSettlment is one of the most popular energy settlement product. It is capable of assisting complex settlement of energy trades, for ISO as well as participants. The system is completely configurable. It reads configuration and formulas, and using competent Core engine, apply them to heterogeneous sources using Mathematica. As part of product, a dashboard user interface with supporting functionalities for data transfer and reporting are also… Show more Team Size 10+; About Project Areva's e-TerraSettlment is one of the most popular energy settlement product. It is capable of assisting complex settlement of energy trades, for ISO as well as participants. The system is completely configurable. It reads configuration and formulas, and using competent Core engine, apply them to heterogeneous sources using Mathematica. As part of product, a dashboard user interface with supporting functionalities for data transfer and reporting are also included. Responsibilities Design, develop and maintain settlement dashboard user interface and java(MVC) applicationDevelopment of settlement core engine in Java multi threaded environment running on Service Oriented Architecture. Development of Transfer engine for Billing and invoicingUpgrading ERWin data models and associated database changes, Developed API for uploading formulation from excel sheet to Database.Discuss and analyze client's new request and formulating feasible solutions. Performance Improvement by recursive monitoring of database (using Toad).Creation of Billing/Settlement reports in XML/PDF format. Product Support and defect resolution in releases. Part of R & D team involved in conversion of product in Microsoft related technologies(.Net framework)Analyzing risk in operational environments and creating backup plans. Technologies Used Core Java, In-house developed ETL tools, Oracle 11g, 10g, 9.x, Java Scripts, JSP, XML, XSL, HTML, .Net(C#), Springs, Tomcat, WebLogic, JBoss, Mathematica, VSS/TFS, Netbeans and Eclipse IDE, Quest Toad, ERWin. Show less

 Technical lead /Code owner for Data Warehouse team, responsible to meet SLAs and functional system without any down time.  24/7 Onsite-Offshore coordination for assignment and deliveries  Act as business expert and lead developer in migration of Data Warehouse from Mainframes to Informatica.  Object Oriented Designing and extraction from various online systems using Java and C on unix.  Legacy system extraction using Cobol/Db2 on Mainframes Supporting… Show more  Technical lead /Code owner for Data Warehouse team, responsible to meet SLAs and functional system without any down time.  24/7 Onsite-Offshore coordination for assignment and deliveries  Act as business expert and lead developer in migration of Data Warehouse from Mainframes to Informatica.  Object Oriented Designing and extraction from various online systems using Java and C on unix.  Legacy system extraction using Cobol/Db2 on Mainframes Supporting nightly/daily/monthly ETL extraction. Pager support for monitoring and issue resolution in timely fashion. Monthly Metrics preparation and Reporting in XML/PDF/QMF Queries using Java/DB2. Effective Scheduling using CA7 and autosys.  Automating process to reduce manual intervention and mistakes. Mitigation planning and participation in enterprise level recovery exercises.  Change management queries, approvals and enhancements. Applied Processes and Service Oriented architecture for quiet production system Code reviews and approvals before production move. Show less

Team Size 20+; About Project National City's Data Warehouse utilizes manifold technologies and environment for Business Analysis and Intelligence. The Extraction is via Java/C and related technologies/Mainframe programs/Informatica from Unix UDB, Windows as well Mainframe legacy data. It is then transformed and scrubbed, via Informatica/Geneva ERS and finally loaded in DB2 environment. The support team works 24/7 in onsite/offshore model assuring no blockage to the Business clients… Show more Team Size 20+; About Project National City's Data Warehouse utilizes manifold technologies and environment for Business Analysis and Intelligence. The Extraction is via Java/C and related technologies/Mainframe programs/Informatica from Unix UDB, Windows as well Mainframe legacy data. It is then transformed and scrubbed, via Informatica/Geneva ERS and finally loaded in DB2 environment. The support team works 24/7 in onsite/offshore model assuring no blockage to the Business clients. Responsibilities Technical lead /Code owner for Data Warehouse team, responsible to meet SLAs and functional system without any down time. 24/7 Onsite-Offshore coordination for assignment and deliveries Act as business expert and lead developer in migration of Data Warehouse from Mainframes to Informatica. Object Oriented Designing and extraction from various online systems using Java and C on unix. Legacy system extraction using Cobol/Db2 on MainframesSupporting nightly/daily/monthly ETL extraction.Pager support for monitoring and issue resolution in timely fashion.Monthly Metrics preparation and Reporting in XML/PDF/QMF Queries using Java/DB2.Effective Scheduling using CA7 and autosys. Automating process to reduce manual intervention and mistakes.Mitigation planning and participation in enterprise level recovery exercises. Change management queries, approvals and enhancements.Applied Processes and Service Oriented architecture for quiet production systemCode reviews and approvals before production move. Technologies Used Informatica, S/390, JDBC, Core Java, Unix, JCL, COBOL, Geneva, C, CA-7, Autosys, Shell Scripts, NDM, Syncsort, File-Aid, DYL280. Show less

Team Size 20+; About Project With ongoing business needs, National City's data warehouse also need to grow and provide analysis and intelligence services. I got opportunity to work at various ranks and responsibilities in Data Warehouse team. The job profile required lots of understanding of core and non-core application and multiple environments. I adeptly learned and excel in numerous platforms (Mainframe S/390, Windows, Unix), ETL tools(Informatica and Geneva) along with core technical… Show more Team Size 20+; About Project With ongoing business needs, National City's data warehouse also need to grow and provide analysis and intelligence services. I got opportunity to work at various ranks and responsibilities in Data Warehouse team. The job profile required lots of understanding of core and non-core application and multiple environments. I adeptly learned and excel in numerous platforms (Mainframe S/390, Windows, Unix), ETL tools(Informatica and Geneva) along with core technical languages(Java, COBOL, C); Lead ETL Developer for various projects including 2 key data marts, Activity Log(ALG) and Operation Data Store(ODS). Object Oriented Development for non-core applications(online banking, loans, mortgages) using Java/C on unix. They were used for scheduled extractions and response from web services. Wrote Cobol/Db2 Programs to extract UFAM/VSAM/FLAT file data from different core systems(DDA/SVN) and align them for Data Warehousing process.Exploited ETL tools for referencing, conversion, calculation, parallel processing, summarizing, trapping, meta data creation and transformationSyncsort utilization for sorting, merging, reports, summarizing, conversion.Deployment of new/changed components n Production using ISPF/Changeman/Changeman DS/Geneva Checkout/check in tools.4/7 Onsite-Offshore coordination for assignment and deliveriesLead Developer for electronically documenting consumer loans using third party tools (Captiva Image Scan, IBM Content Manager, Smead, Rekon and webmethods).Wrote SQL Server stored procedures and DTS(Data Transmission Services) to track documents in various stagesKey Performance Indicators(KPI) analysis and synchronization. Technologies Used Informatica, Core Java, S/390, JCL, COBOL, Geneva, C, CA-7, Autosys, Shell Scripts, NDM, Syncsort, File-Aid, DYL280, Xpeditor, JDBC, Sql Server, Oracle, Db2, UDB, DTS, ChangeMan, autosys, Microsoft Reporting Show less

Master Of Science, Information Technology

Bachelor Of Science, Electronics

Advanced Diploma, Computer Arts