SUMMARY:

• Development / Technical Delivery Manager / Director with 18 years of Global Software / IT experience managing requirements gathering, software architecture, design, application development, solution delivery and production support (Incident & Problem management) across multiple projects / deliveries managing multiple geographically dispersed teams across time zones with a very strong business, customer and end - user focus. Oracle - Database / Datawarehouse track senior developer and architect with extensive technology exposure.
• Managed client portfolios and applications that support gross business value in $2 - 5 billion range. Managing multiple teams and projects concurrently, managed teams of 5 - 50 developers, architects, analysts, infrastructure & support professionals, interns and outsourced vendors. Managed remote employees and geographically dispersed offshore teams working on different time zones. Well versed in project / program & account management, extensively involved in proposal generation, blueprints, planning, budgeting, sales, marketing, resourcing, staff augmentation and presenting to senior and C-level executives.
• Currently managing data integration & production support for Confidential ’s CRM Implementations having an annual gross of USD 3.5 Billion and used by 5000 plus user base.
• Managed development & production support for Confidential ’s internal draft deposit accounts and liquidity risk applications have cashflow of USD 5-6 Billion.
• Managed application maintenance & production support for Confidential USA’s retail business for office products applications & datawarehouse have a cashflow of ~ USD 1 Billion.
• Managed application maintenance & production Support Manager for Confidential Services IT Europe while working at Dell Confidential .
• Managed P&O Nedlloyd’s (Now acquired by Maersk) global non-core systems application & production support onsite in USA & UK and established Offshore Centre in Pune, India while working for Confidential .
• Well versed in working across language barriers interacted with users in Latin America (Spanish & Portuguese) via translators, extensively worked with Japanese customers at Confidential & Confidential (Fujitsu Services).
• Deep understanding of all levels of Production Support & Service Delivery.
• Closely worked with L1 (Helpdesk) defining procedures, protocols, application onboarding & routing.
• Extensively worked and managed L2 support teams, have worked in shifts and staggered hours as an associate, lead, manager & client representative. Well versed in application / job monitoring & recoveries.
• Senior Developer & Architect (Oracle - Database / Datawarehouse Track) extensive involvement in L3 Support in Defect fixing & Application Maintenance. Well versed in causal analysis & root cause resolution processes leading to reduced support ticket volume.
• Understanding of L4 support; managed external vendor staff (product owner) & worked with leading product companies like Oracle on product compatibility & production issues.
• Database (Oracle) track hands on senior / lead developer and technical architect having extensively worked on Database Design (Oracle Designer, Erwin), SQL, PLSQL, PRO*C, performance tuning (tkprof, explain plan), reporting, master data management and configuration, data extraction load and migration, ETL, Datawarehousing, Business Intelligence, Ascential Datastage, Neo4j (Graph Database), GoldenGate, Performance Tuning (Explain Plan / Tkprof) & DBA fundamentals, Developer Forms & Reports, Crystal Reports, TOAD, PLSQL Developer, SQL Loader & Autosys. Familiar with DB2, MySQL, SQL Server, Progress.
• Strong exposure to UNIX (Solaris, AIX and HP) & Shell scripting. Familiar with Java, spring, eclipse, SOA, web services (REST / SOAP, JSON, XML), Tomcat / WebLogic and used custom frameworks like WebSphere & Ezdeveloper, MQ (Rabbit), Splunk and Drools rule engine. High level understanding of front-end development and frameworks including HTML, JavaScript, CSS, jQuery, react, AngularJS, bootstrap and backbone. Familiar with Python, C/C++, ASP. Familiar with cloud implementations using AWS (RDS, Aurora, EC2 & Vault).
• Worked across SDLC (Waterfall) in requirements gathering, analysis & design software architecture, design, development, (high level design, low level / detailed design, software requirements specifications & database design), systems development, testing & production support. Well versed with project planning and estimation methodologies. Implemented Agile Principles like Continuous Integration (Jenkins, Maven), Relative Estimation & QA Automation.
• Extensively used incident / problem management tools like JIRA, ITG, Remedy ARS, and Mercury Quality Center. Used SVN, PVCS, VSS, and TFS for version control.

PROFESSIONAL EXPERIENCE:

Senior Application Lead

Confidential, Stamford, CT

Responsibilities:

• Senior Application Lead (Technical Delivery Manager) Confidential IT, managing all aspects of Inbound and Outbound Data Integration to the corporate CRM application (Siebel) supporting & servicing 4000 plus sales, service delivery, marketing and research engagement services associates supporting USD 2.5 Billion annual gross business.
• Managing integration of CRM Implementation (Salesforce) of Confidential ( Corporate Executive Board) a recent acquisition by Confidential supporting 1000 Sales & Service delivery associates supporting USD 1 Billion annual gross business.
• Design and Development owner for Oracle / PLSQL development (Agile / Scrum) for Sales and Service delivery group. Managing a development team of developers, consultants, interns and vendor staff.
• Architect and delivery owner for data interfaces / DataMart required for the Confidential Sales Process (Agile / Scrum) providing the salesforce with a two page mobile friendly experience on opportunity (renewal / growth), recommended actions, key contacts and performance.
• Architect and delivery owner for research engagement services service request assignments leveraging Drools (Java) rule engine.
• Managing data integration based on web services and SOA for the CRM application.
• Integrating the CRM application with other corporate applications for bookings / orders, marketing, Datawarehouse & Confidential .com.
• Project planning, work estimation and scope definition including detailed architecture, design, and impact analysis.
• Architect and Manager for a Graph Database (neo4j) based analytics and reporting application.
• Managing enterprise data quality, deduplication & data cleansing, master data management (MDM), data security, compliance and access control across systems.
• Managing ETL, Datawarehousing & marketing analytics and dashboard related projects & initiatives.
• Production support for all applications a) Recovery for any failed jobs / processes b) Analysing and addressing user problems and issues c) Autosys jobs setup and scheduling.
• Managing & architecting conversion of Confidential ’s current Siebel based CRM implementation to SugarCRM that includes a web app based mobile experience. Data is sourced via custom Plsql - trigger based change capture and then transported via Java based producers in JSON format to Rabbit MQ, Java based consumers retrieve these messages and using SugarCRM API’s upsert data to the new SugarCRM application which is currently being piloted.

Senior Consultant

Confidential, Jersey City, NJ

Responsibilities:

• Dimensional modeling and schema design for Confidential Datawarehouse.
• Development of ETL transformations & enterprise reporting for Liquidity based Reporting and Analytics ( Confidential ) which is a data warehouse application that supports the Liquidity Risk Management processes at Confidential for debt, deposits, loans, open positions, assets and other balances.
• Senior developer (Agile) for Oracle / PLSQL, PRO*C on Treasury Bank Information Systems ( Confidential ) which is a repository of Confidential Merrill Lynch internal and external accounts world over.
• Development of PLSQL modules for new internal draft deposit account’s project, Confidential system interfaces for liquidity risk, central data warehouse, due from risk system (BASEL-III) compliance, signer tracking, and ongoing enhancements and maintenance.
• Detailed architecture, design, impact analysis, and feasibility study and work estimation for separation of Linux application server from Oracle Database and Database upgrade from Oracle 10g to 11g. UTL file transactions were handled by a custom shell script
• Production Support including job failure recoveries & resolution of user reported problems, issues and discrepancies.

Senior Consultant

Confidential, Manhasset, NY

Responsibilities:

• Senior developer for Oracle / PLSQL, PRO*C and Developer Forms for Confidential USA for Confidential (Retail Operations & Support System).
• Design & development for conversion of Confidential to a Java based application S21. Non-core components were re-engineered to map to the revised data model.
• Development for ETL, load, transformation and reporting for retail Datawarehouse application.
• Production Support including job failure recoveries & resolution of user reported problems, issues and discrepancies.

Senior Consultant

Confidential, Austin, TX

Responsibilities:

• Senior developer for Oracle / PLSQL and Developer Forms to support Confidential ( Confidential ’s Health Insurance Project) implementation & MAXE-Perinatal (Insurance for Pregnant Mothers) for Confidential, Confidential .
• Design and development of letters management module to support changes for enrolment fee extension project.
• Production support, defect management, data analysis & reporting.

Technical Manager and Project Lead

Confidential

Responsibilities:

• Senior / Lead developer & architect for Oracle / PLSQL and Developer Forms on projects for Confidential Service’s Finance & Leasing Product ‘Phoenix’.
• IBM WebSphere & Portal Server development to support new business process optimization initiatives for Confidential Service’s.
• Data migration by entity mapping for Confidential Group UK migrating configuration and transactional data from a legacy desktop application PAMS to web based application Confidential .
• ETL development using Ascential Datastage.
• Configuration and quality controller for Confidential account.
• Successfully had Confidential NOIDA India certified for the clients security audit and compliance.
• RFP & Detailed proposal for Confidential, South Africa for a travel & hotel bookings portal.

Senior Consultant (Technical Manager)

Confidential

Responsibilities:

• Design & Development for BDR (Business Data Repository System) using Oracle, PRO*C (Unix Solaris), Developer Forms and Reports to support non-core country/region specific shipping business for P&O Nedlloyd.
• Architect for database design (logical and physical model) using Oracle Designer for Focus Plus Project for Non-Core Systems unification / merge for America, Europe & Asian applications. Worked at P&O Nedlloyd’s corporate headquarters in London.
• Technical Manager for Development & Application Support leading a team of 10 - 15 offshore developers / analysts for P&O Nedlloyd.
• Visited the USA office in East Rutherford, NJ and coordinated the support transition to P&O Nedlloyd offshore center in Pune.
• Development of PRO*C batches for Confidential Project for Confidential to manage demand / supply & inventory at their global manufacturing hubs.