SUMMARY:

• Enterprise IT Strategy Advisor with over 16 years of progressive experience in working with various teams through mission - critical projects from planning to delivery by fostering cross-functional collaboration and gauging customer needs for high-quality delivery/support, functionality and automation within time-sensitive and high-volume environments.
• Strong technical expertise in architecting and leading large-scale N-tier, Data Warehouse, ETL process technology, Data integration, Business Intelligence and Big Data systems and teams across Retail, Financial Services & Health Care verticals.
• Expand capabilities and align organizations with technical advances, devising robust solutions and correcting the root cause of failures; expert in developing IT strategies that can be adapted to meet the changing needs of customer and market demands and able to customize and introduce tools, programs and systems to enhance IT environments.
• Adapt to diverse programming environments operating at different roles, developing solutions to complex problems, managing business expectations and formulating complex implementation of IT road maps to members of the executive management team.
• Advise management teams on uncovering risks and offer alternatives; excel in team settings, driving full-cycle projects from requirements gathering to post-installation support as well as eliminating root cause of inefficiencies and interfacing with key stakeholders.

TECHNICAL SKILLS:

Subject Domain Expertise: Data Lake Strategy Framework, Active Data Warehousing, Data Architecture (OLAP/OLTP/DSS/DM), Master Data Management, Agile Development, Data Services, Data Governance, Data Quality, Metadata Management, Requirements Gathering, Change Data Capture Solutions, Application Rationalization, Product Selection / RFPs

Business Domain Expertise: Retail, Financial Services and Health Care

Skills Inventory: Enterprise Architecture, Data Architecture, Solution Architecture, Project Management, Application Delivery, Technical Leadership, Dashboards, Integration Architecture, Strategic Planning, Data Modeling, Business Analysis

RDBMS: Oracle 8i-11g, Teradata v2R4-v14, Netezza, SQL Server 2000, Greenplum, Informix, DB2, Postgres, MY SQL

ETL Tools: Ab Initio Co>Op 2.12-3.0.2, DataStage 7.5-8.0.1, Informatica PowerCenter & MDM Hub (Siperian) 9.1/XU/XT

Operating Systems: UNIX, Linux, Sun Solaris, MVS, HP R-11i/9000/3000, IBM AIX 4.x, Windows98/ XP/2000/NT.

Utilities: Erwin 3.5.2, ER/Studio 9.0, BTEQ, Fastload, Multi-Load, TPump, SQL-Assistant, Oracle SQL- Loader and TOAD

Languages: Shell Scripting, C, C++, Java, SQL, XML, HTML, Perl, PL/SQL, SQL*Plus.

OLAP Tools: IBM Cognos, Business Objects, Oracle Hyperion, SAS

Tools: Unica (Campaign Management), Reflexis (Task Management), RightFax Captaris, EMC Captiva Image Capture, CVS, RCS, Subversion, Ab Initio BRE, Matlab, Mathematica, PSPICE, Simulink, MS Project, MS Visio, MS Office Suite

Big Data: Cloudera, HortonWorks, Apache Hadoop (Map Reduce, HDFS), Pig, Hive, HBase

PROFESSIONAL EXPERIENCE:

Confidential, Washington,DC

IT Strategy Advisor

• Successfully provided enterprise data architecture solutions and support to Loan Accounting (LAI) and Common Securitization Platform (CSP) strategic initiatives.
• Successfully defined enterprise data architecture standards for data governance lead enterprise data management policy and procedures across the enterprise.
• Delivered high-level executive presentations and strategic recommendations, comprehensive information and data architecture designs, detailed functional specifications, fully elaborated standard design patterns across the enterprise.
• Extensively involved in providing architectural recommendations for Multi-Family enterprise data alignment with Single Family including Master Data Management (MDM), Integrated Data Store and Enterprise Data Warehousing.
• Successfully delivered Integrated Data Store logical architecture design patterns for acquisition, staging, integration, access, vending and non-functional work products including security, common exception handling, audit, balance & control etc.,
• Extensively involved in mentoring and assisting the development team with providing guidance on the integration of master data with transactional data leveraging enterprise agile methodology.

Confidential

Tennessee Enterprise Architect

• Delivered high-level executive presentations and strategic recommendations, comprehensive information and data architecture designs, detailed functional specifications, fully elaborated conceptual, logical and physical data models, and sophisticated managed metadata environments.
• Successfully provided enterprise architecture solutions and support to supply chain, electronic tender, inventory management, enterprise pricing and one customer view initiatives.
• As a member of Architecture Governance Council and Enterprise Architecture Review Boards, responsible for providing recommendations to Enterprise Data Model (Product and Customer Master), ETL framework using Audit, Balance & Control (ABC) and defining standards and best practices.
• Accountable for successful delivery of the Electronic Tender (Integration with PayPal) initiative using go-forward Enterprise Application and Data Architecture standards.
• Extensively involved in the legacy Data Model analysis of various Databases like Informix, Mainframe DB2, Greenplum, UDB DB2, SQL Server, Oracle, Postgres, MYSQL etc.,

Confidential,New Jersey

Enterprise Data Architect

• Accountable for successful delivery of the Data Access Layer (DAL) using Enterprise Canonical Data Model on Integrated Transactional Data Store (IDS) with single Party based multi-domain Master Data Management (MDM) hub in tandem with Service Oriented Architecture using Enterprise Service Bus (Data Power) and Batch Services through ETL Informatica.
• Successfully provided data architecture solutions and support to multiple Blue list projects involving various business domains of health care (Provider, Networks, Specialties, Credentialing, Member, Groups, Enrollment, Plan, Benefits, Billing, Accounting and Claims).
• Extensively involved in the architecture of Dental migration from Latron to two Third Party Administrators (DeCare/Scion) for managing majority of dental capabilities/operations and processing claims.
• Responsible for providing data architecture solutions and support to Pharmacy Benefits Manager (PBM) conversion involving two leading PBMs (CVS Caremark to Prime Therapeutics) for processing pharmacy prescription claims.
• Provide architecture recommendations in the design of Semantic Layer on Horizon’s Data Analytics Platform (HDAP) using Teradata for Pended Claims.
• Review and recommend data integration solutions involving MDM/IDS and various internal and external applications (Horizon Health Initiatives, McKesson, Facets, NASCO, NMS, Members Edge, Landa Corp, Magellan, Value Options, HNJH etc.,) for Mandates Portfolio projects such as Healthcare Exchange, Healthcare Reform and many other mandated requirements by the government and BCBS Association.

Confidential,Illinois

IT Strategy Consultant

• Successfully delivered Compass (Task Management) initiative which will track and manage the workload in the stores with cost savings of $34M in 10 yrs. All field communication from Corporate will flow through this tracking tool, through which stores will have a view of their pending and completed tasks.
• Accountable for overall delivery of Medical Document Tracking System (MDTS) Medicare Part B Phase 2 and ESignature initiatives to successfully automate document processing workflow by integrating and leveraging Confidential Enterprise Technologies & Infrastructure with NPV of $83M in 5 yrs.
• Extensively involved in design, implementation and maintenance phases of major Pharmacy Accounts Receivable System for Confidential Retails and Homecare businesses to reduce the number of claim write-offs by increasing the effectiveness of the claim billing system, which delivered cost savings of $12M annually.
• Delivered Confidential Profit & Loss system that collects data from multiple lines of business (Retail, Healthcare, TakeCare etc.,) and generates monthly profit and loss statements at various levels of location hierarchy.
• Managed overall implementation of DataStage to Ab Initio conversion process for Profit & Loss system.
• Successfully designed and implemented Campaign Management application for planning, managing, tracking and analyzing marking programs to enhance customer experience and get higher marketing return of investment by integrating Unica with EDW Teradata, Oracle, Ab Initio and other enterprise technologies.
• Well-tuned ETL Ab Initio routines for Ecommerce Dashboard application for better performance.
• Responsible for managing the budget (Plan, Actual), SOW, project level status, timeline, risks, issues, change requests for various project deliverables.

Confidential,Palatine,IL

IT Strategy Consultant

• Evaluated technologies for Big Data initiatives, including commercial versions of Hadoop, use of industry models and data warehouse appliances such as Netezza and Teradata.
• Extensively involved in the creation of Data Governance processes to ensure data quality and correct representation of business concepts.
• Extensively worked with Oracle and Teradata environments and involved in re-designing /fine tuning these databases for proper usage with Ab Initio/DataStage.
• Implemented Ab Initio configuration and set up well-tuned environments for Production and Development.
• Implemented and tuned various complex Ab Initio graphs and shell scripts, which will transform data from various systems of records tables to the data mart layer while assigning proper matching on customer relationship.
• Involved in production support of a complex production environment, which typically has 50 sources, more than 500 Ab Initio graphs, and numerous wrapper Shell scripts.
• Migrating data from Oracle to Teradata Monthly, weekly, daily basis and implemented the Various Load Data by using Fast Load, Multi-Load.

Confidential

Teaching Assistant

• Reliable and robust HTTP Web Computer Networking servers (Pre and Post versions of fork and threaded applications) have been developed using socket programming with the extensive use of C on Solaris and Linux
• A Cyclic Redundancy Check (CRC) encoder and decoder communication system for a binary symmetric channel, which introduces single and multiple bit errors, is coded in Visual C++
• “ Blind Source Separation for Speech and Image Processing using C and Mat lab” The recovery of the ‘n’ statistically independent sources (Speech and Image) from their mixtures when some of them are very weak signals
• Worked as a teaching assistant in Electronic circuits and Communications for B.S. Level courses using different Software Techniques