Principal Consultant Positions in Cloud, DB/DWH, and Legacy Technologies

January 2011 – Present Zimmer Biomet, NJ & IN

Jan 2008 – Nov 2010 UBS, NY

Oct 2007 – Dec 2008 1199SEIU National Benefits Fund, NY

May 2006 – Aug 2007 K Hovnanian, NJ

Feb 2006 – May 2006 Johnson & Johnson, NJ & PA

Mar 2004 – Jan 2006 Novartis, NJ & EMEA

Nov 2002 – Mar 2004 Department of Defense, DC & NJ

Apr 1997 – Oct 2002 NJDHSS, Department of Home Land Security, NJ

CORE COMPETENCIES

Senior Architect of CaPEx and Opex Technology Projects, multi-phase budgets from $2m to 35m.

My long-term assignments align our clients’ business goals with strategic technical solutions.

Solutions expert in B2B, Cloud Services, Enterprise Architecture, Process Management, IT Governance.

Knowledgeable on Private Cloud solutions IAAS, PAAS and SAAS bearing Industry best practices.

Architect in implementation of ERP systems, AZURE, Cloud, EA, AI, DW/BI, Oracle, IBM, SAS.

Applied SDLC, leveraging from waterfall methodology to agile, iterative development by groups.

Domain experience in Pharma, Medical Devices, Insurance, Banking, Federal, State, University.

Feasibility study to acquire new technologies; provided POC, RFP’s to evaluate ROI for buy vs. build.

Planning of large strategic Projects in defining Budgets, Scope, Resources, and Vendors Contracts.

Management of Business Continuity, Disaster Recovery, Data Management, Security and Data Centers.

Global team’s management; on Shore and Off Shore and Vendors as per SLA’S for multiple business Units

Planning end-to-end Orchestration of Operations full-cycle process, Data analysis, Design to migration.

Possess communication, facilitation, negotiation, influencing and Problem-solving skills.

Meetings management and presentations to C-Level executives on Technology Architecture/Programs.

Technical leadership architecture in security tech IDS/IPS, firewalls, malware and network analysis.

A Leader in providing technical guidance to team, mentor resources and lead their training needs.

EDUCATION

Master in Information Technology New Jersey Institute of Technology, New Jersey, USA

Master in Engineering. New Jersey Institute of Technology, New Jersey, USA

Bachelors in Engineering. Regional Engineering College, India

Teaching Experience Adjunct Faculty, New Jersey Institute of Technology, New Jersey

WORK EXPERIENCE

January 2011 to Current, Principal Consulting Architect, Zimmer Biomet, Indiana and New Jersey.

Cloud Responsibilities

Accountable for AZURE Cloud implementations and data solutions from existing DW and BI platforms.

Architected to meet end Users needs assessed tools for optimizing operations to implement AZURE.

Worked with implementing Partner MS BI data stack within an Azure cloud framework and Tabular Model.

Performed Data extraction using Data Factory, Data Brick into Data Lake repository.

Ensured to utilize Cloud Solutions automated configuration by doing (CICD) Continuous Integration and Continuous Deployment to a source code repository cluster.

Prototyping to implement (HDInsight) Hadoop and Spark Platform for Marketing team, working with Azure Partner from an existing traditional Data Warehousing and BI Platform.

Working on ML Prototyping end-to-end machine learning lifecycle platform and interfaces for Processing.

BI/DWH/DB Responsibilities

IT Architect to Marketing & Sales Division, Financial and Insurance Groups for Real-time Reporting needs.

Worked with Sales business units’ Stakeholders/Managers to build Artifacts into BI Analytic tools.

Lead technical integration of B2B systems, Sales Datamart, DW Cubes, to forecast Revenue Collections.

Modified packages for Metadata changes, daily loads from AS400 DB2 to Sql Server for Reporting.

Incorporated network infrastructure, data security with Access control for tables, clusters and jobs.

Worked with 25+ teams on data reporting portal, using Power BI, and integrated to smart devices.

Architected the roadmaps to support data needs working with Infrastructure, DB, Data Modeling

Developed robust system that generates 400 reports to Sales team on a Daily basis using MS SSRS.

Lead technical teams on Architectural design; OLTP and OLAP Data Modeling to build reports for Users.

Technical Program/Project Management Responsibilities

Responsible for multimillion, high visibility complex technical Programs for CaPEx and Opex Budgets.

Co-ordinated with Infrastructure teams, application teams and performed deployments by milestones.

Managed Project Development and cross-functional SOA application teams for integration using REST.

Managed IT teams in Operations of Legacy Systems AS400 integrated to SQL Server On Shore/Off Shore.

At various phases of SDLC performed architectural reviews to ensure adherence to EA standards.

Zimmer Acquisitions of Biomet Product lines: integrating data-driven into Zimmer SAP systems, oversaw system testing-maintained quality by meeting User needs and business goals.

Presented Proposals with ROI to senior executives to enhance existing technology, for Insurance group.

Organized information and Presented KPI, Reports and Score Cards on projected to actual sales.

Included SME’s, to align processes across Zimmer Biomet for marketing, sales and managed care.

Supported Insurance group needs coordinating with Claims team on EDI transactions and validations.

For CaPEx provided ad-hoc support on proposals, POC at the Enterprise & Cyber Solutions Operation.

Managed Claims data processing in transmission to Clearing houses with inhouse and Vendor team.

Performed Discovery, Orchestrated stage wise Planning, Design, execution to post implementation.

Environment: AZURE, HDFS, Python, Scala, Hive, Hbase, Oracle, DB2, SAP, Mapics, MS Office, Windows, SQL Server 2008/2012/2016, SSIS, SSAS, SSRS, MS Project, Power Point.

January 2008 to November 2010, Principal Solution Consultant, UBS, New York City, New York

My assignments were to build innovative IT solutions, for execution and access to the world’s capital markets.

Architected technology to integrate from Oracle views into SSAS cube using SSIS for a team of 8-12.

Worked with integrated teams, improved performance on Data loads, by alternatively loading into two cubes.

Ensured end-to-end solution is tested and supported thru UAT prior to PROD in securities businesses.

Performance of MDX queries were optimized for query performance using Sql Profile tracing.

Parameterized the solution for hands free operation of parallel processors for the processing of cubes.

As an Architect managed Database management, Data Modeling, Data Warehousing and BI projects.

Developed package to load multiple cubes as part of performance enhancement.

Address technical concerns, managed service-oriented architecture (SOA) and resolved technical issues.

Prototyped using PowerShell scripting and RoboCopy to copy data from processing to querying server using Detach and Attach process, checking the status of cube and running cache queries.

Responsible for managing the team and deployments to QA, UAT and Production environments.

Environment: Windows 2003/2008, SQL Server 2008, Oracle 11g, SSIS, SSAS, PowerShell, C#, MOSS 2007

October 2007 to October 2008, Director of Applications, 1199SEIU, New York City, New York,

Implemented BI solutions and Enterprise Applications National Benefit Fund, for its 500,000 beneficiaries.

Managed resources, meetings, reports to executives, developed budgets by programs 2m to 5m.

Handled multiple projects leading team’s size of 18 - 28 resources for internal Projects.

Accountable for Vendor RFP’s for Microsoft BI tools that meet the business process and SLA considering price, performance, functionality, User adaptability to the modeling and Reporting tools.

Implemented BI projects on timely delivery by fulfilling executive management team’s vision.

Lead .NET based STAR project Training and Education Fund to strategize successful completion.

Held business review meetings to re-prioritize the requirements and completed Regression, Integration, Performance, UAT testing with successful deployment to PROD.

Monitored the progress of Oracle ERP Financials Interface to the STAR application payment processes.

Environment: Windows 2000, 2003, MS Office, Linux, SQL Server 2005, Oracle 10g, SSIS, SSAS, SSRS, Performance Point Server, Pro Clarity, WSS 3.0, VB.Net, Visual Studio.

May 2006 to August 2007 Director of Operations, K Hovnanian, Red bank, New Jersey,

Developed high visibility BI Project for the homebuilders working with the VP of Strategic Systems.

Budgets ranged from 3m to 8m took part in RFP’s and Vendor selections and Contracts management.

Responsible for the leadership, Resource Procurements, Vendor management, technical direction and growth of multiple lines of businesses plans, compliance, team building and budgets.

Managed Operational team size of 15, provided direction and leadership to build reporting systems.

Established Data Warehousing performed vendor selection through RFPs.

Set up infrastructure for development and deployment of prototype for Purchasing VPO cubes.

Extracted data from Homebuilder and GL modules of Oracle's JD Edwards Enterprise One.

Managed creation of project plan, Scope, Resources, estimates, milestones and schedules.

Environment: Windows, MS Office, SQL Server 2005, BIDS, JDE Enterprise One, SSIS, SSAS, SSRS, ClearCase.

February 2006 to May 2006 Data Warehouse Architect, Johnson & Johnson, Piscataway, New Jersey

http://www.jnj.com/exit_warning.jsp?url=http://www.jnjgateway.comDesign of Data Modeling, extraction, cleansing, mapping, transformation, Integration and aggregation.

Lead a team of 5 developers, provided architecture and design for converting existing application to fit the Pyramid project scope and risks.

Performed Data consolidation from various source CRM applications to integrate into Siperian software.

Analyzed to generate consolidated set of physicians’ demographic records with state licensing information. The ETL packages were developed in Informatica.

Environment: Solaris, Korn Shell, Oracle 9i, Informatica, Siperian, UNIX, CRM, Windows, MS Office.

March 2004 to January 2006 Data Warehouse Architect, Novartis, East Hanover, New Jersey

Multimillions budgets for the DIOVAN Project, managed Resources, and Vendors.

Evaluated technology and non-technology trends and best practices to delivers business outcomes

Architected and streamlined SMM, IND Projects deployment to post implementation with global teams

Applied Waterfall methodology to implement Data marts for DEDW as per Novartis SOW’s.

The development involved Data Modeling, Data extraction, Data cleansing, Data mapping and transformation, Integration and aggregation of clinical trial data streams into data warehouse.

Trial Data from Source to Target via Data Staging, Validation, Consolidation and Mart distribution.

Environment: Oracle, SAS, Korn Shell, Informatica, Cognos, Toad, Control-M, Clear Case, UNIX, MS Office

November 2002 to March 2004 Director of Applications, Multi Lifecycle Engg, NJIT, DoD, NJ, DC

Principal Architect for DOD Programs in liaison with Multi Lifecycle Engineering Research Center (NJIT) and Virtual Corp to develop Supply Chain Risk Analysis Management System (SCRAMS) and Sustainable Planner for Disaster Recovery and Business Continuity Planning.

Constructed technology-enabled operating models, that provides viable options and visibility to execution

Lead teams in advanced disaster recovery (DR), Business Continuity Plan for Operations sustainability.

Guided multiple teams, by directing and leading the ER models for the Oracle Schema.

Produced ETL interface programs for loading data into Oracle from SAP FICO and MM modules.

Conducted Predictive Modeling and simulation routines for SCRAMS application implementing Supply Chain Algorithms.

Environment: Oracle, SAP, C Sharp, .NET, Informatica, Cognos, Toad, UNIX, MS Office, Windows

April 1997 to Oct. 2002 Technical Manager, NJIT, Dept. of Health and Senior Services, New Jersey,

Multi-year Program and technology Projects for Health Alert Network database to access information of various emergency services Groups across New Jersey.

Proposed implementation was to build New Jersey Immunization Information System using the IIS web services, security network with a firewall secure (Verisign).

Held and lead the training programs to various Agencies, health officers and Official on Reports.

Supervised development teams, testing and Deployment teams. Managed team to convert from VB to Java using EJB, IIS server, WebLogic server and Oracle server.

Environment: Windows, MS Office, Exchange Server 2000, Oracle DB, Business Objects

Contact this candidate