Worked as Data Architect on Digital Marketing for India’s leading Pvt. Bank. We are involved in Customer analytic and process digital marketing campaign.

Worked as Data ware House / Data Integration Architect for Cetera Inc a top 5 financial advisor in US.

Working as Technical Project Manager with team size of 8 at offshore and 1 at on-site coordinator

• Project Management
• Offshore Technical lead and coordination
• Resolving technical issues on the project design

Worked as Project Leader managing a portfolio of 7 Client manager with multiple projects with offshore team size of 40+ and Onsite team of 14+. Managed teams with Agile Scrum Methodologies and Iterative methodologies

• Project Management
• Offshore Technical lead and coordinaton
• Involved in pre-sales activities, making proposals, schedule and cost estimates
• Identifying and training fresh resources and assimilating them in projects
• Appraisals and Team management.
• Creating Database objects like Tables, Views, Index etc
• Writing PL/SQL scripts, Tuning SQL’s

Fox Entertainment is a Media and entertainment giant. They are having legacy system and home Accounting system for Domestic, International accounting along with Royalty and contractual financial information. All these systems are integrated so that user can have single view of customer, product and market.

Syntel has initiated Strategic Initiative to help Humana accelerate implementation on new and niche technology. Working as EDW SME where we have to migrate Informatica and SQL scripts to Hadoop/Hive environment.

Humana Inc. is a American managed health care company that markets and administers health insurance in the United States, and has business interests in Western Europe and Asia. Humana has over 13 million customers in the USA. Business Intelligence and Informatics Competency Center (BIICC) manages various projects under DWH, Business Intelligence and build skills on upcoming technology for Humana. Worked as Project Leader managing a portfolio of 7 Client manager with multiple projects with offshore team size of 40+ and Onsite team of 14+. Managed teams with Agile Scrum Methodologies and Iterative methodologies Project Management Offshore Technical lead and coordinator Involved in pre-sales activities, making proposals, schedule and cost estimates Identifying and training fresh resources and assimilating them in projects Appraisals and Team management. Creating Database objects like Tables, Views, Index etc Writing PL/SQL scripts, Tuning SQLs Writing Dollar Universe job for scheduling jobs. Create Database objects like Tables, Views, Procedure, Packages Supporting in Product Backlog, Sprint planning and Release planning meetings. Updating Burndown chart

Worked as Project Leader, for BASEL-II, Data warehouse project with State Street Inc. (SSIT). SSIT is a investment banker and as per Federal regulation has to comply with Basel-II banking guidelines. To address the compliance issue SSIT has purchased few products namely Bancware, LMS and others which is the source system for DWH system. Out of the three Regulatory requirement of Basel-II guideline we have completed sourcing data for Regulatory Capital requirement and reports are being generated using Cognos and TM1 for validation and verification. Apart from project lead related activities, responsibilities include Data Analysis, Data Profiling, Dimension Modeling Validation of Source and Target Database Creating mapping specifications for ETL development team. Create Database objects like Tables, Views, Procedure, Packages

HP asset Center is an Asset Management Software product to manage assets of companies particularly IT Asset. The product has many features which includes Software Installation, Contracts, Hardware assets like Desktop, LAN network etc. The product being OTLP system does not captures historical data, Reporting of OLTP system is very slow, and analytical querying is not possible. To overcome these limitations, we have built Data warehouse which is capable to provide canned reports, Adhoc reporting on Business Objects.

Brazil Credit Card Data warehouse is unique for the reason of 9 million customer base data to be loaded within 8 hours each day. All ETL jobs, canned reports had to be up within short span of 8 hours. It also had its own Adhoc reporting system. We build the system from Scratch with many technical difficulties, which we overcame successfully to deliver the product to the Business user.

IBM BDW is standard Data warehouse along with other products from Teradata etc. Client required us to compare their Credit Card Data warehouse against Industry standard Data warehouse particularly IBM BDW. We provided them consultancy on the gap they need to bridge, data that is required to capture and how they can improve performance of their existing data warehouse.

A software development company which provides high end value added services to ISVs around the world which includes Usability engineering, Testing Services, Product life extension and Mobile solutions. Have been working as Associate Software Specialist (Team Lead) on Maintenance Project for Raindrop Information Systems Ltd. Activities involved are support for their enhancement activities, in their product Manhattan. Manhattan is a property management application which is used by Multinationals, Corporate, Property owners and Agents to maintain property details, which may be owned or sublet to third party or acquired for its own use. This software is being continuously upgrade to include new functionality & features.

Development IT a division of Novartis Ltd. Switzerland which provides support for drug development from molecular research to end product development, following FDA regulations and international safety standards. We successfully outsourced development/enhancement and maintenance activities from Switzerland and France to India. Project included IMOS an inventory management and Ordering System,. CLINICOPIA a clinical trail and randomization system, Baptrack system to maintain Quality accepts of Development process. These projects are on Platform D2K, Oracle PL/SQL and Uniface. We have also successfully migrated and implemented Uniface application Stock Movement system of IMOS on .Net Technology on a mobile device to be used in warehouse. Roles included Project Lead and job involved requirements gathering, interaction with business and global associates, coding, testing, writing program specification. Creating HLD and DLD, Screen Layouts, responsible for Team output and overall project activities.

This project is developed for Bharat Heavy Electrical Limited. BHEL takes manufacturing contract which are executed in time span of 3 to 6 years. All these contracts are in Foreign Currencys. Every contract has many inflows and outflows of foreign currency till completion of the contract. To safeguard their interest and have complete overview of all financial transaction in foreign exchanges, from all units this project was developed for H.O. Finance Department.

Due to decision made by ICICI bank to phase out ASP from all its major projects and reconvert the same to J2EE. Intranet module which was on ASP, which is on ICICI Bank Intranet. This Intranet Module services more than 250 branches all over India is now converted to J2EE framework. All business logic from middle tier has been taken to the database. Apart from changing technology, adding of new functionality and optimizing the whole module and reducing work flow has been incorporated.

This project is live since 1998 and was installed to handle all Demat Account of ICICI Bank Customer. This project is closely works ICICI – Direct which is a web enabled direct online trading system. Also this project is connected with EAI, Client Information System, and Data warehouse of ICIC Bank. The project involved accurate and on time delivery without fail.

This is an ERP project developed and customized for National Dairy Development Board (NDDB) a Govt. of India Undertaking for development of Co-operative Dairy Industry in India. My involvement was development of Library management system, health check-up system, Official Quarter Assignment and Maintenance module and customization of payroll module.

General Motors Assurance Company, a subsidiary of General Motors Corp, this company covers for perils of damages caused due to untoward incidences. Module worked on Policy Manual, Claims, Cash Management and Endorsement Management.

In-house Project Management tool developed for the company, to track, maintain, and analyze various projects of the company.

This module is part of the ERP package customized for Borax Morarji Ltd. made various reports and forms for this module.

This project was developed for Electrical Department, Central Railway for maintaining all records of inventory, management of shop floor maintenance, schedule of loco maintenance.

This project has been developed for Aecho Communication Co. Ltd. China. The whole system has been developed on Templates. The project takes care of Investor details, Noncommercial Transactions, Reports like investor details, NAV Related parameterized reports, Reconciliation reports, Brokerage calculations, and Generation of NAV after the day end process has been provided.