We provide IT Staff Augmentation Services!

Data Ingestion Framework Lead / Data Architect Resume

3.00/5 (Submit Your Rating)

NJ

PROFESSIONAL SUMMARY:

  • More than 17 years of extensive IT experience with a focus on Data Architecture along with Database Migration, Administration, Data Virtualization and development experience in SQL Server & Oracle including Implementation of Business Intelligence Projects.
  • About 1 Year of hands on experience working with Microsoft Azure full stack technology like Azure Data Factory, Data Lake Store, Azure Storage, Azure SQL DB, Azure SQL data warehouse, Docker Container and Azure Service fabric for Micro services.
  • Over 8 years as a Practice Lead in Business Intelligence Projects which combined experience in international and national organizations in Support, analysis, design, development, Data - Migration, Data-Integration, administration architecture, Data Modeling, implementation and post implementation.
  • Hands on experience to work on Azure - PaaS such as database management, Data movement using Data Factory, Integration using BI Tools, Azure Data Catalog and develop the solution for customer.
  • Build Data Ingestion framework & hands on experience on Azure SQL data factory to ingest data & transforming from any data source such as Flat file/RDBMS/ODBC to Azure Data Lake Store/Blob and further to SQL Azure database/Data warehouse.
  • Worked with azure lake to store the data as DataMart to be used for cloud date warehousing. Hands on experience on moving data between on premise and cloud.
  • Extensive technical knowledge of Installation, Configuration, setting up Log Shipping, DB Replication.
  • Experienced in Change management and ITIL methodologies
  • Planned coordinated, organized, lead and monitor the activities of cross-functional project teams (On-shore and off-shore).

TECHNICAL SKILLS:

Date Modeling & DWH Tools: Erwin, MS Visio Professional, DTM, DTS 2000, SSIS, SSAS, Pentaho

Microsoft Tools: MS Office, MS Project, MS Visio Professional, Microsoft Azure-PaaS

System Management Tools: Visual Source Safe, SVN, TFS, GitHub

Operating System: Windows 2003/2008/2012 , Linux, OpenSuse

Ticketing Tools: HP open view, LDAP Admin/Search

Databases: MS SQL Server/Azure SQL DB & DWH, Sybase ASE 11.9.2, Oracle 11g, My Sql

Reporting tool: SAP Business Object 6.5/XI R2, Crystal Reports, SSRS, Pentaho, Qlikview

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Data Ingestion Framework Lead / Data Architect

Technology: MS SQL Server 2016, Azure Data Factory, Azure .NET SDK, Visio, Azure SQL DB/DWH

Responsibilities:

  • Defining/understanding future business process
  • Requirements gathering based on interview sessions with business users
  • Design a robust future state Ingestion Framework solution leveraging Azure Data Factory, Azure SQL database & Data warehouse
  • Design Architecture for API development & deployment as Microservice including Python code in Docker container and Azure Service Fabric.
  • Hands on experience on Setting up and deployment of Azure service fabric and Automation.
  • Review end to end database architecture/design and data flows in the system.
  • Designs and architects overall DW architectures and standards, definition of data models
  • Ensures adherence to Confidential standards, policies and quality compliance, enterprise metadata definition
  • Team Handling, Project Planning, Task & resources Allocation and Delivery to customer
  • One point of liaison between client and Confidential teams, status reporting, etc.
  • Feasibility check, analysis and define scope of work
  • Raise Risks & Issues if any
  • Ensures in corporation of best practices and lessons learned from prior projects
  • Prepare contingency and mitigation Plan

Confidential, Texas

Data Architect

Technology: MS SQL Server 2014, SSIS, SSRS, Visio

Responsibilities:

  • Review end to end database architecture/design and data flows in the current system
  • Identify root cause/remediation of memory leaks and implement recommendation and best practices in SSIS packages in SSIS packages.
  • Optimize SQL query, Stored Procedure and monitor performance bottlenecks as needed
  • Fine Tuning Database Parameters for optimal performance
  • SQL Server Best Practice recommendation
  • Configuring alert/monitoring to troubleshoot any issues
  • Design a robust future state data design based on long term data strategy

Confidential, Atlanta

Data Architect

Technology: MS SQL Server 2012, SSIS, SSRS, Erwin 8.0

Responsibilities:

  • Database Design as dimensional model using Visio for Reporting and Dashboard
  • New Architecture for more database scalability of the project
  • Build Several SSRS reports
  • Writing Complex SQL scripts.
  • Build Dashboard using BI Tool SSAS
  • Built ETL Rules for Users to upload their own data into database.
  • Maintain Data movement and Data security across Dev, QA and Prod Environment
  • Used SSIS Package as an ETL Tool for data extraction from legacy system
  • User & security Management, Exploration on other BI Tools as Qlikview, Tableu and Power BI

Confidential, New Jersey

Data Architect

Technology: MS SQL Server 2008 R2, SSIS, SSRS, Pentaho 4.8, Erwin 8.0, BO XI R2, Denodo 5.5

Responsibilities:

  • Database Design as dimensional model using Erwin Studio 8.0 for Reporting and Dashboard
  • Build Several SSRS reports
  • Writing Complex SQL scripts.
  • Data Virtualization where connect multiple source build data model in the form of Universe and Publish to generate Reports as per User criteria using Business Objects XI R2
  • Build Dashboard using BI Tool Pentaho 4.8
  • Data Extraction using Pentaho Data Integrator(PDI)
  • Used SSIS Package as an ETL Tool for data extraction from legacy system
  • POC on Power BI and Denodo 5.5 for virtualization

Confidential, Milwaukee

Data Architect

Technology: MS SQL Server 2012, Windows 2012 Advance Server, Oracle, SSIS

Responsibilities:

  • Define the scope and design new database objects for requirement specification
  • Data Mapping and ETL Package
  • PL/SQL scripts
  • Data Migration from Oracle Schema to SQL Server

Confidential, New York

Database Architect

Technology: MS SQL Server 2012, Windows 2012 Advance Server, Oracle, SSIS

Responsibilities:

  • Database architecture, data modeling using Erwin based on Star Schema for relational model and design database, which can be widely used considering the near future development for framework application.
  • Feasible study on existing SQL Server 2012 Database, fixes non compatible tables, Stored procedure and make it compatible with SQL Azure on Cloud and Deployment support.
  • Migrate and Integrate data to cloud using Azure Data factory.
  • Move date between On-Premise and azure Cloud.
  • Database Migration for RMS project from SQL server 2012 to SQL Azure on cloud computing.
  • Technical Documentation and Set Best Practices and SOP

Confidential

Database Architect

Technology: MS SQL Server, Windows 2012, ERWIN, MS Project, Opensuse, Pentaho, SSIS, SSRS.

Responsibilities:

  • Database architecture to design database using Erwin based on Star Schema for dimensional data model, which can be widely used considering the near future development for framework application.
  • Complex Data Warehouse design for GMS DW where it involves data extraction from live website as XML and consolidation at Single SQL Server.
  • Worked on Immon and Kimball both techniques in agile methodologies.
  • Building Data Mart to be compatible with SQL Azure where it is require creating primary keys on the entire table to use of indexing and then host it on cloud for Data as a service.
  • Create SSIS packages to extract data from multiple sources and consolidate for centralization.
  • Used Pentaho Data Integrator (PDI) to extract data from legacy system.
  • Loading data from dynamic multiple spreadsheets of excel file using Integration services (SSIS).
  • Analyzing data quality issues and representing to the source for corrective actions.
  • Plan, design, and implement application database code objects, such as stored procedures and views.
  • Create multiple dashboard and reports with visual representation in multiple formats of graphs, bar charts etc.
  • Build and Deployment of SSIS package, SSRS Report on production.
  • Develop Dashboard using Pentaho Community Edition (CDE).
  • Collections of Data from multiple sources and host this data as a service from centralized location.

Confidential

Database Architect

Technology: MS SQL Server 2005/2008 R2, SSIS, SSRS, SAP Business Object XI R2, Cognos

Responsibilities:

  • Data virtualizationtomanage data where data retrieved from multiple sources such as excel, lotus notes & SQL Server and manipulatedata by transforming and consolidating virtually at single repository and can provide a single customer view at presentation layer. Build data model using Erwin based on Star Schema for dimensional model and design database, which can be widely used considering the near future development for framework application.
  • Complex Data Warehouse design for Confidential where it involves data extraction from multiple sources like Lotus Notes, SQL Server and Excel in distributed Format and consolidation at Single SQL Server.
  • Create SSIS packages to extract data from multiple sources and consolidate for centralization.
  • Loading data from dynamic multiple excel spreadsheets file using ETL package-SQL Server 2008 Integration services (SSIS).
  • Analyzing data quality issues and representing to the source for corrective actions.
  • Create Data Mart to support data warehousing which eventually turn into Business Objects dashboard.
  • Developed metadata-MDM Solution using SQL Server 2008 R2 Master Data services (MDS).
  • Plan, design, and implement application database code objects, such as SPs, views etc.
  • Create multiple dashboards with visual representation in multiple formats of graphs, bar charts etc.
  • Complex reports using SSRS, build and deployment of SSIS package, SSRS Report on production.
  • Develop Dashboard using Business Object.

Confidential

Database Architect

Technology: MS SQL Server 2005/2008, SSIS, SSRS, Business Object XI R2, ERWIN.

Responsibilities:

  • Data virtualizationtomanage data where data retrieved from multiple sources such as excel, lotus notes & SQL Server and manipulatedata by transforming and consolidating virtually at single repository. To accomplish it complete database architecture, data modeling using Erwin based on star schema using Kimball Techniques for designing relation model for OLTP & DWH system.
  • Migration of data from Lotus Notes database which is having staff data entities and attributes to map with new designed database and integrate with existing as well as future requirement using ETL Package - SQL Server 2005 Integration services(SSIS)
  • Online database replication setup to have repository for online reporting using Business Object XI so that business user can browse the data online using Business Intelligence interface.
  • Backup and recovery setup for more scalability and availability of database.
  • Standard operating procedure as well as guidelines for developers for Optimized coding to suit their requirement for development of framework application.
  • Analyzing data quality issues and representing to the source for corrective actions.
  • Setting up SQL service broker and message queuing for real time reporting of framework transactional data for other Data Mart based on requirement.
  • 3 tier production support based on ITIL methodology for deployment of modules and database setup.

Confidential

Database Architect

Technology: MS SQL Server 2005/2008, SSIS, SSRS, Business Object XI R2, Visio-2003.

Responsibilities:

  • Database architect to design the database for integrating of data from multiple sources.
  • Data virtualizationtomanage data where data retrieved from multiple sources such as excel, lotus notes & SQL Server and manipulatedata by transforming and consolidating virtually at single repository in the form of Universe, and can provide a single customer view at presentation layer.
  • Data modeling to build logical diagram as ERD to classify all possible Entities, Attributes, Dimensions, Measures and Facts for Reporting Module and Physical database design.
  • Migration of data from Dynamic excels spreadsheets using SSIS with multiple transformation tools such as ActiveX Script.
  • Build reporting system for Business user using Business Intelligence interface BO XI R2.
  • Analyzing data quality issues and representing to the source for corrective actions.
  • ETL package designing and development for data Integration.
  • BO XI installation, Building Universe and support in reporting.

Confidential

Database Architect

Technology: MS SQL Server 2008 R2 with MDS, Windows 2003, Business Object XI, MS Visio, Cognos

Responsibilities:

  • Data virtualizationtomanage data where data retrieved from multiple sources such as excel, lotus notes, MS Access & SQL Server and manipulatedata by transforming and consolidating virtually at single repository in the form of Universe, and can provide a single customer view at presentation.
  • Database Architect for Dimensional data modeling using Erwin for building Logical diagram as ERD which classify all possible Entities, Attributes, Dimensions, Measures and Facts for MDM in physical.
  • Worked on Inmon techniques in agile methodologies to design OLTP system.
  • Extraction data from all sources such as Lotus notes, SQL server, Excel from all mission and then integrate to build data as master data. The examples are Enterprise Identity Management System, eMOP, eTMS etc. which is been developed, integrated for both Application and reporting.
  • Data Profiling for MDM and database architecture for setting up all the defined dimension and facts.
  • Analyzing data quality issues and representing to the source for corrective actions.
  • ETL package (SSIS) designing and development for data Migration & Integration from Lotus Notes to SQL 2000 into one Data warehouse and Building Universe using Business Object XI.
  • Installation and Configuration Sql 2008 R2 with Master data services for MDM activities and prepare reporting schema.
  • Develop Cognos cubes to build reports and dashboards.

Confidential, New Jersey

Database Architecture, Administration & Production Support

Technology: MS SQL Server 2000, Cognos

Responsibilities:

  • Database Administration and Maintenance (Installation, Configuration setup etc.)
  • Setup of log shipping from 18 and more locations worldwide to have the centralized data using Sql server 2000.
  • Maintain and develop ETL package for new requirement to transfer the data transfer.
  • Setup of database replication for reporting purposes.
  • Analyze and resolve problem tickets related to data, setup & Code issues in minimum time frame.
  • Maintenance and development of existing and new cognos cubes and reports

We'd love your feedback!