SUMMARY:

• Nineteen years of IT experience including Application Architecture, Data Architecture, Information Management, Systems Integration, System Analysis, Database Programming, Software and Database Development, IT Strategic Planning and implementation skills with a coding background in several programming languages (ASP.NET, C#, JavaScript, PHP, Python, R, T - SQL, PL/SQL) in Financial Services, Healthcare, Insurance and Higher Education industries.
• Extensive hands-on experience with relational, OLTP, SQL, dimensional and OLAP databases and technologies, business intelligence, data warehousing methodologies and concepts, and reporting tools.
• Extensive hands-on experience in architecting and developing client-server, N-tier object-oriented applications, Application Program Interface (API), Representational State Transfer (ReST) and web services.
• Over ten plus years of hands-on experience in Data Management, Data Analytics, Data Lineage, Data Quality, Data Profiling, Data Modeling, Performance tuning and Query optimization.
• Extensive knowledge of information extraction from enterprise data sources using commercial tools like Informatica (PowerCenter and Data Integration Hub), IBM Infosphere, Pentaho, Oracle Goldengate, SQL Server Integration Service (SSIS) packages, MS Master Data Services, Corepoint Integration Engine.
• Experienced with the design and implementation of data transaction replication solution; moving data transactions utilizing various methodologies/technologies.
• Experienced with collecting and extracting semi-structured/structured/unstructured data from the Internet as well as enterprise data sources.
• Knowledge of various Machine Learning technologies and algorithms (K-means, Random Forest, Naïve bayes etc.).
• Experienced in Data Analytics with Data Mining, Predictive Modelling, Big Data, Data Visualization with SQL, R and Python.
• Ten plus years of hands-on experience with detailed knowledge of integrating and aggregating large data sets into high-volume data warehouse applications using highly varied and high velocity data collection systems.
• Experienced with version control tools i.e. Team Foundation Server (TFS), Apache Subversion (SVN), GitHub and Redgate Source Control.
• Technical and functional knowledge of the business intelligence technologies such as Sisense, Cognos, MicroStrategy, Power BI, QlikView, Qlik Sense, Tableau and Business Objects.
• Experienced with designing data security, lineage, governance through the data pipeline from in premiae sources to AWS S3 and cloud based data warehouses.
• Subject matter expert in designing, developing and testing of ETL (Extract, Transformation and Load) strategy to populate the data from OLTP databases, Staging Area to data warehouse and data marts.
• Experienced in source to target data mapping using Data lineage technique and calculating the impact on the data flow using Impact Analysis.
• Experienced working with multiple geographic cross functional business and distributed IT teams (onsite and offshore).
• Experienced with writing complex database queries, stored procedures, functions, triggers, views, indexed views/materialized view, packages using MS SQL Server and Oracle.
• Experienced in all aspects involved in system development life cycle methodologies (Agile/Scrum/Waterfall model).

TECHNICAL SKILLS:

Database Server: Microsoft SQL Server 2005/2008/2012/2014/2016, MySQL 5.0/5.5, Oracle 9i/10g/11g/12c, Teradata, MongoDB, Hadoop (Hive/HBase/HDFS)

Search Server: Sphinx 2.2, Solr 6.3

Other Applications: CA Erwin, Crystal Reports, ER/Studio Data Architect, MS Office, MS Project, MS Visio, Oracle SQL Developer Data Modeler, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Toad Data Modeler, Toad for Oracle

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Senior Data Architect Consultant

Responsibilities:

• Provided guidance and direction on Data Integration Hub (DIH) project, intended to provide HBCBSNJ a platform for publishing data in near-real time and ensure digital APIs retrieve the most up-to-date relevant data in digital caches for enterprise topics for enterprise data assets (Provider, Product, Group, and Claim).
• Create conceptual and logical models, data flow diagrams in support of the enterprise target architecture and solution design.
• Define, develop and expand upon horizon’s Audit Balance and Control (ABC) framework.
• Collaborate with Data Strategy team to create a new HBCBSNJ Data Quality framework.
• Developed standards, process flows, testing strategies, mapping documents, documenting interfaces and data movement across the enterprise.
• Partnership with various teams (onsite and offshore) to define and create an enterprise data lake for HBCBS.

Technologies deployed: AWS (S3, Lambda, RabbitMQ), Managed File Transfer (MFT), Hadoop, MongoDB, Informatica Data Integration Hub and Data Quality, TeraData

Confidential - New York, NY

Team Lead/Senior BI Data Architect/Lead Developer

Responsibilities:

• Work directly with the Chief Technology Officer to recognize and identify potential areas for future business expansion. Owned roadmap and product-managed 3 releases of new product over 1 year - working with 2 scrum teams of 20 engineers spread across 2 locations international and local.
• Provide strategic guidance to ensure that projects are developed while leveraging the Information Architecture standard, including data strategy (management, integration and optimization) and Governance tools; ensure alignment with the defined future Information Architecture.
• Used Agile methodology to developed a POC (proof of concept) product using Big Data Analytics, Hadoop and Spark framework and Microsoft SQL Server 2016, SQL scripts, and Python for data manipulation and Machine Learning algorithms.
• Design strategic, efficient approach for data loading and ETL/ELT guidelines for semi-structured and unstructured data for medical science repository.
• Created a generic .Net Core Search Restful API wrapping Solr enabling engineers to leverage the search-based product with no prior search background (e.g. Search, Highlighting, Faceting, Stemming, and Filter Query etc.)
• Effectively articulate reasoning for data model design decisions and strategically in corporate team member feedback to produce the highest quality data models.
• Work with project and application teams to ensure understanding of and compliance with data quality standards, architectural guidelines and designs.
• Recommend suitable technical architectures and define high-level solutions; developed standards and architecture for systems data integration frameworks and delivery.
• Manage end-to-end implementation activities related to reference data, data modeling, data cleansing, data quality, data governance and data consolidation using standard information management methodologies and processes.
• Manage offshore and onshore data management, machine learning (data scientists) and analytic teams of 20 plus supporting/developing BI platform using Python, .Net Core, Hadoop, Apache Spark and Tableau.
• Provide strategic guidance to machine learning team to disambiguate and normalize data organized around medical science researcher freestanding datasets to provide answers and insights (connecting the dots).
• Define long term strategies for data management architecture and delivery to meet operational, programmatic and business intelligence needs.
• Managed 4TB data migration from Oracle 11g to SQL Server 2016. Coordinated pre-upgrade test procedures in development as well as debugging post upgrade performance issues. Managed 4 production servers containing ~15TB
• Map entities to use cases and business requirements and assist in the development of data services.
• Created and manage an array of artifacts (data design deliverable including data architecture, data models, data diagrams, data flows, data governance and corresponding data dictionary documentation).
• Created detailed programming specifications for ETL, data migration, and data scrubbing processes.
• Implemented reference data database transactional replication, Full-text search, memory-optimized tables and types on SQL Server 2016 Enterprise.
• Created application and data architectures, research database technology and application framework, determined business requirements, propose changes, and develop migration and implementation plans.
• Designed and implemented custom technology-enabled SQLCLR solutions utilizing .Net, T-SQL, Solr and Sphinx.
• Analyze effectiveness of existing technologies and processes in relation to data and software architecture: recommended new solutions (tools/technology) as required (Django for web application framework and Python for machine learning), Ansible/Docker for devOps and reengineered implementation/migration plans.
• Communicated, educated and ensured adherence to sound data management principles (reuse of data as well creation and management of metadata and business rules for use of data).
• Designed and implemented C# multi-threading XML parser application to load terabyte of semi-structured and unstructured data into the data warehouse for processes and products consumption.

Confidential - New York, NY

Senior BI Data Architect/Lead Developer Consultant

Responsibilities:

• Provided guidance on projects to ensure that development leveraged the Information Architecture and Governance tools and ensured alignment with the defined future Information Architecture.
• Initiated the re-architecture of a Shared Data Layer (SDL) Project and data migration of fixed income, ratings, equity, reference and linking data for S&P Capital IQ products.
• Interacted with business analysts regularly to consolidate and analyze data requirements and information gaps; outlined the diverse steps needed to build an integrated data system.
• Provided architectural solutions covering data structures, sourcing, integration, security, and retention for data-mart project.
• Provided data analysis, data profiling, data integration, and data quality for a data-mart project.
• Developed standards, process flows and tools that promote and facilitate the mapping of data sources, reference data, documenting interfaces and data movement across the enterprise.
• Designed and developed data quality rules for data-mart solutions to ensure data integrity levels are met.
• Designed ETL and ELT guidelines to ensure efficient and accurate data transfer within the entire SDL Project using SSIS and Goldengate.
• Worked with project and application teams (onsite and offshore) to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.
• Improved database performance by using indexes, partitions and tuning T-SQL by examining execution plans.
• Rewrote complex functions, stored procedures and views by incorporating SQL Server new features such as merge statement, analytic functions, pagination and error handling.
• Created data architecture, research database technologies, determine business requirements, propose changes, and develop migration and implementation plans for SDL project.
• Created conceptual, logical, physical and dimensional models using Erwin; data flow architecture using MS Visio, data management specifications and data mappings.
• Created data dictionary, data lineage documentation and ETL, and also calculating the impact analysis.

Confidential - New York, NY

Architect/Lead Developer Consultant

Responsibilities:

• Designed and developed database-driven web interfaces that enable effective control and governance to mitigate compliance risk for bank-wide real-time file sharing security system.
• Designed and implemented new features and custom changes for new releases and patches using VS 2010, C#, SQL 2008R2, SQL 2012, SSIS, SSRS, web-services, JQuery, JScript and multi-threading.
• Developed external web portals allowing users to input and retrieve accurate information.
• Designed and developed an application that maintains and enhances management of bank wide security systems by reading/writing to Windows Active Directory Service and Master File Table (MFT).
• Collaborated with geographically distributed teams performing Quality Assurance on an Agile-based project.
• Improved backend database using indexed views, indexes and optimizing store procedures/functions.
• Built business applications from concept to execution including designing, developing and implementing.
• Created conceptual, logical and physical data models using Erwin and MS Visio for OLTP environment.

Confidential - Brooklyn, NY

Senior BI Data Architect/Lead Developer

Responsibilities:

• Managed all phases of IT from team building, to formalizing IT policies, strategies, standards and technology decisions and ensuring compliance with HIPAA, JCAHO and LCME requirements.
• Designed data loading strategies and data model for Special Treatment and Research (STAR) Program to reduce data entry redundancy by 15% on a weekly basis.
• Implemented Multi Layer ETL Data Extracts, Data Load Logic, Mapping, Work Flows, and stored procedure.
• Developed and implemented data security policy for the department and ensured that appropriate backup systems were in place for business continuity.
• Created schemas/synonyms to control data access and improve security and trained programmers in the use of store procedures for applications and reports.
• Managed end-to-end implementation activities related to reference data, data modeling, data cleansing, data quality, data governance and data consolidation using standard information management methodologies and processes.
• Created logical, physical and dimensional models using Erwin and Oracle Data Modeler.
• Created and maintained data dictionaries and other metadata.
• Managed the maintenance of a LAN and a comprehensive patient management/EMR system for the STAR Health Center.
• Performed data mapping between disparate databases/data sources and gap analysis.
• Established and maintained sound backup and recovery policies and procedures for SQL Server databases.
• Designed and implemented custom technology-enabled clinical solutions utilizing .Net, T-SQL and SSIS; served as an integrator between clinical needs and technology solutions.
• Profiled master data for completeness, accuracy and integrity, and evaluated connections between data and applications.
• Developed web applications using C#/VB.NET and SQL Server 2008R2 and 2012.
• Implemented, configured, and administered replication for MS SQL 2008R2 Servers.
• Created and supported required reports in response to business and clinical user needs using C#, SSRS, SSAS and Crystal Reports.
• Established data architecture and BI best practices, standards and data models; recommended data warehouse and reporting performance-tuning techniques.

Confidential - New York, NY

Data Architect/Lead Developer

Responsibilities:

• Directly responsible for driving Logical and Physical Data Model deliverables while managing deployment of production, development and validation environments for WTC Master Data Management system.
• Led a five-person software development team and implemented a center-wide HIPAA compliant web application solution utilizing ASP.NET, T-SQL, SSAS, SSRS and Crystal Reports to support over twelve centers/affiliates.
• Installed, configured, deployed and administered 3 SQL 2005 Server, 2 Web Servers (IIS 6.0) and 4 Windows 2003 Server.
• Created logical and physical data models for both data-marts, OLAP and operational (OLTP) database environments using Erwin.
• Planned, directed and managed all facets of windows/web product development for the department, including the development and documentation of user experiences, product strategies and roadmaps.
• Served as the key liaison with upper management and technology teams throughout windows/web development project lifecycles, identifying issues, needs and solutions for project longevity.
• Defined and developed strategic Master Data processes, conceptual and physical models for use as a system of record/reference.
• Worked with key personnel to de-identify patient information and ensure system integrity and HIPAA compliance across the multiple locations.
• Designed and developed data quality rules for data mart solutions to ensure data integrity levels are met.
• Created detailed programming specifications for ETL, data migration, and data scrubbing processes.
• Managed the maintenance of an EMR system for the World Trade Center Project.
• Consulted with infrastructure development project teams to fit infrastructure to architecture.
• Managed the collection and integration of data from disparate data sources using SSIS, internal and external to World Trade Center (WTC) Data and Coordination Center, to ensure clinician and epidemiologist received adequate patient health information to help identify areas of concern and inform decision-making.