SUMMARY

• Accomplished and versatile system professional with considerable experience in enterprise information architecture, software architecture and data management.
• More than two decades of delivering extremely robust and efficient Information Management Solutions, on - time and on-budget.
• A proven ability to deliver highly comprehensive Master Data Management designs to consolidate data across a wide range of business entities.
• A long-running record of providing exponential increases in throughput, accuracy and profitability.
• An outstanding ability to define business functions as generalized metadata, enabling systems to provide long­term stability and reliability.
• Been an Inspiring leader with an innate understanding of team dynamics and intrapersonal relationships, I build winning teams and that take pride in their accomplishments.

TECHNICAL SKILLS

Familiar with: AWS, Azure, Pig, Hadoop, JAVA/.NET framework, C#/ VB.NET, map reduce, Salesforce, SOAP/WSDL, J2EE, Servlets, JSP, COM/DCOM, JSP/SERVLETS, PL/SQL, TSQL, Cubes/ROLAP/MOLAP/HOLAP, MDX, XML/XSD/XSLT/CSS, MTS/MSMQ, ADO.NET/ ADO/RDO/DAO/ODBC, HTML/DHTML/ASP/JSP, C, C++, Visual Basic, javascript/Vbscript/perl, crystal reports, CICS/VS, COBOL

DBMS/SERVERS: Neo4j, ORACLE (Ug,11i,10G/9i/8i/7.3/6),SQLServer multiple versions 2012/2008/2005/2000/7.0/6.5/6.0 , Sybase11/9, DB2, IMS/DB-DC, SMS, Web sphere, Weblogic 5.0, SITESERVER, EXCHANGE SERVER, UNIFY, FOCUS, TELON, PACBASE

Portals/CRM: Salesforce, Cognos, Hyperion, Business objects, Oracle app server, Sharepoint, SAP, peoplesoft.

Modellers and Designers: Erwin, Visio, PowerDesignor, Rational Rose, designer2000, visual modeller, Goundworks and IEW

BI tools: Cognos, Brio, SSAS, Tableau

Middleware: Biztalk, IBM MQ

ETL tools: Informatica, Integration server, DTS.

Enterprise Frameworks: TOFAG framework, ITIL framework

EA tools: Enterprise Architect, archimate

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NY

Enterprise Architect

Responsibilities:

• Provided roadmap to future state of the enterprise data integration and enterprise application integration platform, leveraging industry standards like HIPAA EDI standards and HL7 standards.
• Provided reference architecture and the consolidation framework to create the informatica MDM implementation to host customer, HCO/HCP data. Defined merge rules and stewardship workflows. Patterns of integration to the various upstream and downstream systems that were defined.
• Instrumental in establishing the synchronous and asynchronous end points in mulesoft API gateway and batch raw zone on both cloud and on premises locations.
• Architected automation of claim processing and adjudication, using pega robotics.
• Designing the landing/raw/refined and published zones for the enterprise data warehouse. Added Hedis metrics to the EDW on AWS and neteeza platforms for hybrid strategies to enhance refined and published zone capabilities.
• Tools: enterprise architect. Powerpoint, word, visio and excel, AWS, redshift, Azure, Pega robotics, collibra.

Confidential, Manhattan, NY

Executive director and Chief enterprise architect

Responsibilities:

• Roadmap from current to future state of the enterprise was formulated and delivered addressing business strategy and technology vision.
• Constituted Architecture review board, documented enterprise standards, architectural landscape and enhanced security framework. Introducing Entity framework and unity framework into the enterprise to replace home­grown enterprise framework.
• Introduced Hybrid Agile methodology of development in the agency
• Introduced dynamics workflow methodology to existing "data intake to administration" of NYC mandated city programs.
• Architected Esubmit program in agency using box.com as a cloud solution, leading to a dramatic cost reduction of intake of unstructured data. (Information week technology award recipient).

Tools: archimate. Powerpoint, word, excel

Confidential, NYC NY

Director and Enterprise Data Architect

Responsibilities:

• Responsible and accountable for the enterprise data management team.
• Managed the data management team of ETL architects, database architects, middleware architects and cognos architects by providing architectural solutions for back end databases, canonical models and orchestration objects for Interfaces, cognos packages through framework manager and web parts and web charts for the presentation layer for multiple data management efforts.
• Architected framework for MDM and datawarehouse solutions to provide datamart solutions on Policy, claim and risk analysis. Defined merge rules, data steward workflows, upstream and downstream integration patterns.
• Architected sentiment based loss analysis and log analysis of real-time systems, using big data approach.
• Architected loss/policy/coverage and customer information presentation to customers and underwriters through salesforce.com.
• Architected and maintained Erwin logical and physical data models for MYTMM, salesforce.com and Datawarehouse projects.

Tools: Salesforce, Erwin 7.3, Sun UNIX/Oracle 9i/10g/11g, DB2, Sqlserver 2008,2012., Neo4j, Teradata, Informatica 9.1/8.6, Cognos 10.1/8.3 portal, SAP portal, IBM MQ/broker, microstrategy, SSIS,SSRS,SSAS, Sharepoint portal, Azure, AWS, cloudera pig, hadoop, spark, scala, python

Confidential, Somerset, NJ

Principal Data Architect

Responsibilities:

• Lead Architect in Designing Comprehensive Data warehouse Solution, from data to presentation layer, to build and expose Activity/Productivity of Sales Forces involved in pharmaceutical drug distribution for more than 40 pharmaceutical Clients.
• Architected dimensionally secured SSAS cubes to house CAST data along targets, Professionals, Specialties, Jobs and Calendar for all call, target, and Trx and NRx metrics from IMS data. Provided Drill through functionality, to accommodate "what if" scenarios.
• Designed SSIS Packages to Load Data from CAST database to Data mart databases.
• Designed the Score carding, Reporting and Dash boarding solution in Performance Point Server, and deployed in MOSS.
• Designed custom dashboards for clients in Cognos8. Experienced in developing complex reports and Expertise in developing reports with multiple parameters, filters, complex cross tab reports, graphics and charts, dashboards, drill through to other reports or cubes
• Architected and maintained Erwin logical and physical data models of the data warehouse and datamarts.

Tools: Sqlserver 2005/2008, oracle10G, Visio, SSIS, SSAS, SSRS, Performance Point, .Net framework, Cognos 8, MOSS.

Confidential, Lyndhurst, NJ

Lead data architect

Responsibilities:

• Managed and guided a group of architects who
• Designed the integration of business entity data to implement MDM hub architecture of GIS system with workflow and dataflow from various sources like GMF, DNB.
• Designed Erwin data model of the Datawarehouse and implemented multiple phases of Datawarehouse with data extracted from various OLTP systems like GMS, GFIS.
• Designed data flow and auditing processes to support reporting services and data analysis.

Tools: Erwin 4.1, Visio, Oracle 10G/9i, SqlServer 2005, SSRS, SSAS, and SSIS.

Confidential, Marlton, NJ

Principal Architect

Responsibilities:

• Managed and guided a group of architects who
• Designed and Implemented EAI solutions for interchange of data between various applications like data flow of SWIFT standards data between subsidiary banks, Mismo standards data from brokers to Mortgage approval system.
• Designed and implemented multiple phases of Datawarehouse with data extracted from various OLTP systems like mortgage application on a C tree structures, loan servicing data on DB2 and consumer loans from SQLserver, for a centralized pool of data to report from. Designed cubes and rollups for all reporting efforts.
• Designed and implemented commission automation. Designed the database structures to implement the plans and rules of commission calculation. Designed soap web services for data extraction and update. Modelled processes for commission calculations. Created framework of classes and interfaces to implement the design.
• Implemented Brio portal based solution for financial reporting of profitability and Business object based solution for risk management.
• Designed and implemented Informatica ETL solutions.
• Designed Erwin logical and physical data model of the datawarehouse.

Tools: C#, Java, Biztalk2004, SqlServer 2005/2000, Oracle 9i, DB2, Analysis Server, Erwin 4.1, Brio, SAP ERP financials, Business Objects, Rational RUP modelling, Informatica, Visio

Confidential, Clark, NJ

Architect

Responsibilities:

• Designed and implemented ETL load solutions using Informatica.
• Designed Star Schema data Warehouse with data from OLTP databases for DSS purposes. Created MDX queries for use with cubes created using Analysis services.
• Implemented distributed decision support systems and active backup for the PYRAMID claims and AGO policy databases, by replication to off-site server at the Connecticut location.
• Designed and developed COM/DCOM objects for error distribution and message routing
• Build Asp's for provider and hospital location searches and, claim information searches for employers, generated from both Oracle and Sqlserver databases.
• Generated crystal reports for web presentation of reports.
• Added WEB-forms and WEB-services using C#.NET to extract data from Oracle and SqlServer.
• Designed security using Authentix for protecting web site.
• Was responsible as DBA for the enterprise network of oracle and SQLservers.

Tools: SqlServer 2000/7.0, Analysis Server, oracle 8i/9i, Rational RUP modelling, Informatica, C#, JAVA/VB scripts Ms- project, Visio, Crystal reports 8.0.

Confidential, Princeton, NJ

SOLUTION/DATA architect

Responsibilities:

• Was responsible for the resolution of problems relating to the FACTIVA intranet toolkit database. Involved in monitoring, performance tuning, building indexes and views, creating stored procedures and triggers.
• Was responsible for the coding of SQL-DMO objects in V.B6.0 to maintain the database from the UI through COM objects.
• Built and maintained site server/catalogue server to crawl specific sites to provide for global searching from the intranet.
• Created MDX queries for use with cubes created using Analysis services.
• Fine-tuned the tool kit after stress testing the product using E.R.W software.
• Developed custom replication strategies.
• Creation of DTS packages for data transformation.
• Generated Usage Reports in crystal for web Presentation.

Tools: SqlServer 2000/7.0, Analysis Server, site server 3.0, visual basic 6.0, Interdev 6.0, java and vbscripts, Erwin.

Confidential, Piscataway, NJ

Data Architect

Responsibilities:

• Architected and maintained the conceptual data models and physical data models of the CMS system using PowerDesignor 7.0.
• Was responsible as DBA in the maintenance of the enterprise network of Sqlserver and Sybase servers with responsibilities including backup and restore of data, creating DTS packages, index, stored procedures and trigger creation, job scheduling and alert management,
• Replication of data, performance-tuning Sqlserver for better overall performance
• Was responsible for conversion of data from Legacy systems to Sqlserver for the Customer Management system using VB6, Sqlserver 7.0 and ADO2.0.

Tools: SqlServer 7.0, Sybase 11, visual basic 6.0, sourcesafe6.0, Powerdesignor 7.0., embarcadero schema/change manager and Dbartisan, BackTrack, Visio

Confidential, NJ

AS a DBA /architect

Responsibilities:

• Designed Star schema data mart to convert OLTP to OLAP model using Erwin. Lead a team in the development and of the conceptual data models and physical data models of the Medicaid system.
• Designed and developed "Claim settlement" project using Java, servlets, EJB, JSP, JavaScript, XML to retrieve information on claims and related expenses based on the CPT4 and ICD9 codes and to co-relate to provider and group information from SQLSERVER and ORACLE systems.
• Designed and developed "Contact" system using VB6, Sqlserver 6.5/7.0,oracle8i and ADO2.0.

Tools: Oracle 7/8i, SQLserver7.0, sybase10/11, SMS, visual basic 6.0, HP UNIX, JAVA, Weblogic, peoplesoft, designer 2000, vbscript/perl, SqlBacktrack. MS-Project, Visio

Confidential, Frankfort, KY

Architect

Responsibilities:

• I was involved as an architect in the design, development and user interaction for the Kentucky Registry of Election and Finance and Kentucky housing department.
• Developed and implemented Election Financial tracking system for the commonwealth of Kentucky. Designed entity level relationship diagrams (ERDs) and developed Logical Model and Physical Database Design using Erwin.
• Created a number of Classes, User controls Triggers, Stored Procedures and Functions.
• Coded legal subsystem along with initiating documents, waivers and statement of intent. Created objects for general usage in the project. Implemented Objects for OLE connectivity for the system. the design and development of software for a varied number of projects like Manufactured Housing, Heating Ventilation and Air conditioning system, Hazardous material handling, Fire Protection,

Tools: visual basic 3.0/4.0(16 bit/32bit), 5.0, DB2, SQLserver 6.0/4.5, Oracle 6.0/7.3, SQLPlus 3.3, SourceSafe 4.0/5.0, crystal 5, and reports2.5, Erwin.

Confidential, Frankfort, KY

Consultant

Responsibilities:

• I was a consultant DBA, involved in database and system design, coding, testing and implementation of issuance and calculator/rating modules, and in the enhancement of the eligibility determination modules of the welfare system of the state of KENTUCKY. This system was designed to determine eligibility of applicants for welfare programs such as, food stamps, Medicaid.
• I was involved in system analysis, design, software development and implementation of the issuance modules for the welfare systems for the states of FLORIDA and OHIO. This system was used to determine the eligibility of applicants for welfare programs in the states of FLORIDA and OHIO.

Tools: TELON, IMS/DB, and COBOL VS II on IBM ES9000/900 running MVS/ESA.

.