SUMMARY:

• Strategic, analytical, and highly adaptable professional with 20+ years' success leading teams to build high - quality enterprise Data Warehouse, Big Data, Business Intelligence, Data Management/Architecture and Analytical solutions (On-Premise /Cloud) across a variety of large, mid, and small sized organizations.
• Proven & extensive experience in leading & engineering Data Warehouse, Business Intelligence (BI) and Big Data initiatives, including data architecture, data visualization, project management, requirements analysis, solution design, data modeling (conceptual/logical/physical/dimensional), data pipeline development, testing, integration, and implementation.
• Seamlessly partner with developers, analysts, project teams, and internal / client stakeholders across the end-to-end solution development life cycle for concurrent project portfolios.
• Adept in providing top-notch production system support, optimization, enhancement, and issue resolution; proven record of delivering high-caliber security and user management solutions.
• Key achievements include creating a Reference Data Management & MDM product, implementing & engineering Enterprise Data Warehouses, more than 50 Data Marts, Master Data Management (MDM) Solutions, Operational Data Stores (ODS), BI/DW Solutions on Big Data/MPP Platforms, OLTP Applications and Metadata Repositories with Service Oriented Architecture (SOA).
• Established high-quality Data Architecture standards /services /policies, Data Governance process, Metadata management techniques, Data Visualization Solutions, Model for Data Lineage, and Championing importance of " Confidential ."
• Good working knowledge of Hadoop Technologies including Spark, AWS, Cloud Data Warehouse(Snowflake, Redshift), NoSQL DB, Streaming service such as Kafka.
• Enjoy learning new technologies, able to grasp and can adopt new ideas quickly.
• Worked in various capacities as Project Lead/Manager, Lead Data Architect, Solutions Architect, Technical Lead, ETL Architect, Systems Analyst, Data Modeler, DBA, and Developer.

HIGHLIGHTS OF EXPERTISE:

• Solutions Architecture
• Data Architecture /Strategies
• Data Modeling
• Project/Team Management
• Big Data Cloud Technologies
• Business Intelligence
• Data Warehousing (DW)
• Master Data Management
• Mentoring & Coaching
• Data Analytics/Science
• Data Quality & Data Governance
• Exposure to Machine Learning & AI
• Data Visualization
• Systems Integration
• Agile Methodologies

TECHNICAL PROFICIENCIES:

Programming: JAVA, C, C++, Pro*C, Basic, PL/SQL, HTML, XML, XSD, WSDL, UNIX Shell, SCALA, Python SPARK, Hadoop MapReduce, HDFS, YARN,PIG, HIVE,, HBase

Software / Tools: Kalido, Business Objects XIR2, Webi,BO Data Integrator, Informatica, DataStage, Cognos, MicroStrategy, Discoverer, Sagent Data Mart Suite, SSIS, SSAS SSRS, Cubes, MDX queries, Tableau, Qlik View, DataInsight, InfoSphere Information Analyzer, Data Flux etc. Data Quality, Kalido MDM, IBM MDM, Purisma MDM PL/SQL, SQL*Plus, SQL*Loader, Complex Oracle queries, Oracle Analytics, Solarwinds, PowerBuilder with PFC, PFC, VB 4.0/5.0/VC++. VB, Microsoft Office Suite, PeopleSoft, Oracle Apps, SOAP, SAP

RDBMS: Oracle, DB2 UDB, Sybase, MS SQL Server, Azure, MySQL

Modeling Tools: ErWin, ER/Studio, Sparx Enterprise Architect, Visual Studio, PowerDesigner, Rational Rose

Cloud DW: Redshift, Azure, NoSQL,Snowflake

MPP Database: Teradata, MS PDW

Hadoop Technologies: Integration Infosphere, Informatica, DataStage, Talend, Microsoft, Azure, Data Integrator, Anypoint Platform

Modeling: Logical, Physical, Normalized, Dimensional, OLTP Applications, Modeling using ERWIN, Embarcadero, Power Designer, Designer, Visio, UML Rational Rose

Methodologies: SOA, Agile Scrum, ESB, OLAP, OOAD, ORM, EAI, TOGAF, WBD

Additional Knowledge: Machine Learning, tools such as SAS, Microsoft Azure Studio, RapidMiner. Streaming Platform such as Kafka. Spark, Apache Hive DW Architecture, Snowflake Cloud DW

PROFESSIONAL EXPERIENCE:

Confidential, Naperville, IL

Senior Solutions Architect/ Data Lead

Responsibilities:

• Spearheaded the creation of projects plans, high-level designs and technical documents to tackle complex problems and create simple data management solutions between various systems.
• Designed System Integration techniques between multiple systems, (6) using various methods such as Web Service calls, File transfer, timely direct data loads.
• Collaborated with the ETL team in providing mapping specifications from source to target and provided SQL queries for complex business logic/calculations.
• Reviewed changes to technical and business metadata and did impacts analysis on the GAMI application system to successfully bring the effort through to final delivery. Key Contributions:
• Created a BI data mart Schema capable of answering 75+ KPI metrics to analyze gas module deployment metrics, resulting in increased efficiency of operations and satisfied stakeholders. Wrote complex queries to derive complex metrics and business calculations
• Simplified complex logic for handling measurement meters by designing and implementing a logical & physical AMI Integration Repository for storing Master Data, Vendor Outgoing & Incoming Data, Gas Module Deployment RNI Register & Interval Read Data and 3 Systems Check Data.
• Designed & Developed Meter Read Data Repository to consume 50-70 million interval reads on daily basis. Optimized the load performance to load the data in 8 minutes.
• Designed Logical & Physical Model and used ERWIN and Modelmart for the Modeling and Data Model version Control.
• Collaborated with the ETL team in providing mapping specifications from source to target and provided SQL queries for complex business logic/calculations.
• Reviewed changes to technical and business metadata and did impacts analysis on the GAMI application system and lead the effort to delivery.
• Lead in System Testing, UAT, and Production Deployment.
• Tracked all development progress and reported weekly to the Steering committee.
• Coached and Mentored team of 6 professionals as well as engaged in knowledge sharing about AMI across cross functional teams.
• Created POC of Azure Data Lake for Meter Interval Read Data by storing CMEP Files on Azure Blob Storage and then loaded the Interval data from big CMEP file into Snowflake Cloud Data Warehouse. Connected PowerBI & Tableau to get summarized reports/dashboards for key metrics.
• Used ERWIN and Modelmart for the Modeling and Data Model version Control.

Environment: System Integration, ERWIN, SQL Server 2016, Azure, Snowflake, SSIS, Tableau, PowerBI, RNI system, File Management (Incoming Outgoing), Web Services, .Net, RNI Sensus System, CCB.

Confidential, New Orleans, LA

Senior Solutions Architect /Data Architect

Responsibilities:

• Participated in Requirement sessions with Business Users/ Stake Holders, analyzing the requirements, streamlined those requirements, created SOW and a project plan.
• Created and reviewed High-Level design documents. Presentations with business executives/ Stake Holders.
• Designed Logical & Physical Model for Utility Data Warehouse and used ERWIN and Modelmart for the Modeling and Data Model version Control. Also designed Data Mart Schemas (Dimensional Model)
• Created Conceptual and Logical/physical data model for Revenue stream and Smart Meter Data(5 Minute -15 Minute Interval Data )
• Designed data load strategy for 10 years of data as well as ongoing data from the legacy systems.
• Ensured user satisfaction with the ability to retrieve data from a data model by working with technical partners and ensuring stability and growth potential of data model and database.

Environment: ERWIN, Oracle, SQL Server 2010, PDW(APS), Azure, Informatica Power Center/Developer, SSIS, Cognos

Confidential, Tucson, AZ

Senior Interval Data DW BI Architect

Responsibilities:

• Engineered a solution for storing and managing interval data to enable on the fly calculations and aggregations before displaying in mobile and in web resulting in a much faster response time. Analyzed complex legacy system data and designed load strategy and plan to load the data in the Meter Data Repository.
• Built a Conceptual and Logical/physical data model for Revenue stream and Smart Meter Data (5 Minute -15 Minute Interval Data).
• Worked closely with the ETL team in the definition of the data collection, transformation, and loading, and acted as a liaison between executive leadership, end users, and engineers.
• Participated & owned Requirement sessions with Business Users/ Stake Holders, analyzing the requirements, streamlined those requirements, assisted in creating SOW, and a project plan.
• Designed Logical and Physical dimensional Model for better analytical reporting needs and used ERWIN and Modelmart for the Modeling and Data Model version Control.
• Created TOU (Time of Usage) Metrics using PL/SQL using complex business rule and huge volume of interval data.
• Developed high-level Data Flow /ETL designs, created ETL Mapping documents for ETL Developers.

Environment: ERWIN, Oracle, ITRON MDM, PL/SQL, Informatica, Cognos

Confidential, Los Angeles, CA

Senior Data Architect

Responsibilities:

• Responsible for all activities related to the architecture of data and metadata.
• Utilized SQL for data profiling, data analysis, and developed high-level Data Flow /ETL designs and maps.
• Designed a Dimensional model for better analytical reporting needs.
• Established an analytic environment for an NFL Sunday Ticket program based on the clickstream data which was in Hadoop.
• Designed Logical Model and Physical Model which implemented in Teradata Enterprise DW.
• Developed high-level Data Flow /ETL designs, created ETL Mapping documents for ETL

Environment: ERWIN, Teradata, Hadoop, Cloudera, Informatica, Cognos, SAS, Big Data, Map Reduce

Confidential, Austin, TX

Data Warehouse Architect

Responsibilities:

• Engaged with client enterprise architecture team and built a high-level end state data warehouse architecture to meet client needs.
• Presented numerous software and hardware solutions to high level executives, including CIO.
• Developed high-level Data Flow and ETL designs. Key Contributions:
• Created detailed data profiling of the CCB billing data and built out a data visualization reporting capability on the data profiling analysis results using Tableau.
• Designed a logical and physical model solution for the customer and used ERWIN and Modelmart for the Modeling and Data Model version Control.

Environment: ERWIN, Oracle 11g, IBM DataStage, MicroStrategy, Tableau, Toad

Confidential, Austin, TX

Senior Solutions Architect/Data Warehouse Architect

Responsibilities:

• Responsible for creation of data architecture standards, governance policies, data quality, maintaining enterprise data model, and peer reviews.
• Used SQL for data profiling, data analysis and designed a dimensional, logical & physical model for better analytical reporting needs. Key Contribution:
• Created a business objects universe (semantic layer) and integrated with EBI global universe.
• Developed high-level Data Flow /ETL designs, created ETL Mapping documents for ETL
• Collaborated with ETL team in the definition of the data collection, transformation, and loading.
• Acted liaison between Business Executive, Business Users, and Technical Team.

Environment: ERWIN, SQL Server 2008, Teradata, Informatica, Business Object, SAS

Confidential, Austin, TX

Senior Data Warehouse Architect

Responsibilities:

• Worked as Sr. Data Architect/Solutions Architect on one of the biggest Project in Confidential involving Finance & Inventory.
• Responsible for design and architecture for changing Hierarchies for Cost Centers, Profit Centers. GL Accounts, Customer, Product, Region. Designed Enterprise Logical& Physical Model (3 NF Relational).
• Designed a simple Dimensional model for better analytical reporting needs.
• Used SQL for data profiling, data analysis, reconciliation to source system SAP.
• As part of the Data Architecture Team involved in creating data architecture standards, governance policies, data quality, maintaining enterprise data model, peer reviews
• Fostered Data Management and Architecture culture; promoted data integrity and reuse at all levels.
• Developed high-level Data Flow /ETL designs, created ETL Mapping documents for ETL Developers.
• Collaborated with ETL team in the definition of the data collection, transformation, distribution, and loading of the data model. ETL Development using Informatica.
• Acted liaison between Business Executive, Business Users, and Technical Team.

Environment: ERStudio, SQL Server 2008, MS Cube, SAP, MDM, BPC (Forecasting tool), Informatica, Tableau, HP Quality control

Confidential, Temple, TX

Team Lead, Business Intelligence Group

Responsibilities:

• Managed and mentored a team of 6 personnel.
• Implemented data architecture, data governance & data quality processes and created official processes and frameworks to ensure compliance.
• Proposed and materialized a master data management initiative and roadmap.
• Created a basic framework to support the MDM initiative, and introduced and implemented Agile SCRUM methodology.
• Performed a role as a scrum master. Acted as a liaison between Business Executive, Business Users, and Technical Team.
• Fostered a data management and architecture culture; promoted data integrity and reuse at all levels.
• Designed Enterprise Logical (3 NF Relational) and physical model (Dimensional).

Environment: Agile Scrum Methodology, Oracle, MS SQL Server 2008, ER Studio, Business Objects XI Edge

Confidential, Bowie, MD

Senior Metadata Architect

Responsibilities:

• Introduced Agile SCRUM methodology for project management/development and performed a role as a scrum master.
• Created sample cubes (SSAS) to create ad-hoc reports and demonstrated various data visualization tools such as QlikView, Tableau. Key Contributions:
• Create MORE2 Data Warehouse to load all the member and encounter data
• Developed an aggregated benchmark data mart to calculate various utilization, chronic conditions, co morbidity, demographic statistics, and a process to calculate national benchmarks.
• Designed Logical and physical model (3NF and Dimensional) and created SSIS packages to load data from source to target.
• Created sample cubes (SSAS) to create ad-hoc reports.
• Demonstrated various data visualization tools such as QlikView, Tableau.
• Developed complicated analytical reports using SSRS, T-SQL in 2 weeks.

Environment: Agile Scrum Methodology, MS SQL Server 2008, MySQL, SSIS, SSAS SSRS, Cubes, MDX queries, Erwin, Dezign Data modeling tool, Tableau.

Confidential, New York, NY

Senior Business Intelligence Architect

Responsibilities:

• Re-Engineered current process, integrating data from various source systems into Kalido Data Warehouse and removing spreadsheet-based data movement within the organization.
• Worked with client manager for project/resource planning. Worked with management for establishing goals, expectations Data Governance, and fostering data management culture; promoted data integrity and reuse at all levels.
• Designed a model for Metadata Repository and Data Lineage.
• Designed ETL mapping in Business Objects (BO) Composer in collaboration with ETL team. Guided for rapid ETL development with the first iteration getting released in 3 months.
• Wrote Complex Oracle PL/SQL programs, utilities, and reports using Oracle analytical functions.
• Created Business Objects Universe and Webi reports using materialized views and merge Statements.
• Developed CBE’s, Transaction Data Sets, File definition, Reference Data Load, Query Definitions, and Model Master using Kalido DW.

Environment: (ERWIN 4.0, Kalido, Agile Scrum Methodology, Business Objects XIR2, Data Integrator, Composer, Oracle 10g PL/SQL, Oracle Analytics, SOA, MySQL, MS SQL Server 2005, PeopleSoft, BO Data Integrator, Microsoft Office suite, Visio, Windows 2000)

Confidential, Livingston, New York

Senior Data Architect / Consultant

Responsibilities:

• Promoted data integrity and reuse at all levels of the organization; adhered to and refined data standards ensuring SOX compliance.
• Performed source system data analysis and data profiling.
• Created and maintained conceptual, logical, and physical models throughout the project.
• Responsible for all activities related to the logical architecture of data, metadata and its Lifecycle from data entry into the organization, usage, persistence, and exit from the organization.
• Wrote Oracle PL/SQL programs/utilities, reports using Oracle analytic functions
• Collaborated with ETL team on ETL Architecture; created ETL mapping documents and
• Wrote ETL Code in Oracle PL/SQL to load data from DW to DM.
• Implemented a physical model for DW and DM in collaboration with DBA.
• Collaborated with the vendor to ensure compatibility of a data model with Business Objects Universe.
• Created DW Website to facilitate all teams in HTML and ASP.
• Created Repository to manage Executive Dashboards with crucial metrics.

Environment: (ERWIN 4.0, Oracle 10g PL/SQL, Oracle Analytics, MS SQL Server, PeopleSoft, Data Stage, Business Objects, SOX, Performance Manager, Dashboard Manager, MS Office suite, Visio, Enterprise Architect, Windows 2000)

Confidential, New York

Senior Data Architect / Consultant

Responsibilities:

• Created an end state operational model for Claim Processing System based on Confidential
• Standards which handles 500,000+ claims per day; designed, created, and maintained logical and physical data models.
• Collaborated with users and IT Business Analysts on requirements definition an applications design.
• Realized physical data structures working with database administrators and object-oriented modelers.
• Employed modeling techniques that ensure adherence to modeling standards.
• Created or provided input to the creation of accurate and appropriate project plans.
• Completed work assignments by deadlines agreed upon by incumbent and management.
• Ensured policies regarding technical guidelines and change management processes were followed.

Environment: (ERWIN 4.0, Power designer 6.5, Tibco, XML, Java, DB2, PeopleSoft, Oracle 9i, PL/SQL Informatica, Teradata, Cognos, MS Office suite, Mainframe, Windows NT, Novell NetWare)