SUMMARY

• An accomplished IT professional with an extensive knowledge and experience providing guidance regarding IT technologies to clients and organizations
• Extensive knowledge and experience in the design and development ETL/ELT framework and processes to support multiple sources/target databases supported by automated execution of ETL packages including reconciliation
• Practical knowledge and experience in analysis, design, development and implementation of Business Intelligence and reporting solutions using MS SQL Server suite products including SSIS, SSRS, SSAS and Power BI
• Experienced in Big Data, Business Intelligence and Data warehouse and associated technologies
• A solid understanding of data modeling concepts including star and snow - flake schema, and fact and dimension tables (dimensional data models)

TECHNICAL SKILLS

Application Systems: SAP, OpenText Enterprise Content Management, Microsoft Dynamics CRM 2016

Big Data (Apache Hadoop - Hortonworks): HDFS 2.7.1 Ambari, YARN, Ranger, MapReduce, HIVE, Scoop, Atlas

Operating Systems: Windows 2012/2008 R 2/2008/2003/2000 , Unix CentOS

Development Languages: T-SQL, PL/SQL, .Net and JavaScript

Databases: MS SQL 2016/SQL 2012/SQL 2008 R2/SQL 2008/2005 (SQL Server Clustering, SQL Server-Log Shipping, SQL Replication), Sybase 16/9, Oracle 11g/10g

ETL: SSIS (SQL Server Integration Services), Talend Studio, Informatica, SSIS Integration Toolkit for Microsoft Dynamics 365

Reporting Tools: Power BI, SSRS, (SQL Server Reporting Services, SSAS (SQL Server Analysis Services), Crystal Report, SAP-Business Objects, Dundas BI

Data Modeling Tools: ER-Win, ER-Studio, Power Designer

Other Tools: SQL Diagnostic Manager (IDERA), Red-Gate, Toad for Oracle, Orion-NPM(Network Performance Monitor), Orion-SAM(Server Application Monitor), MS Team Foundation Server, Visual Studio Team Services

PROFESSIONAL EXPERIENCE

Confidential

Data Integration Consultant

Responsibilities:

• A key member of confidential  liquidity technology team responsible to provide the technical solutions to business areas; Fund Transfer Pricing, Treasury Accounting, Liquidity and Capital Management
• One of the key element of the regulatory compliance reporting system is SOA (service oriented architecture) based valuation engine to support key valuation metrics for wide range of portfolios
• Designed and developed SSIS ETL packages and processes with focus on performance using table portioning and index optimization
• Designed and developed complex SSIS packages using established framework and processes to integrate data from various source systems to target system
• Prepared data mapping documents to support data transformation between various data sources and target environment
• Configured and developed custom components with technology partners (business analysts, developers, solution architect ) to meet business requirements and goals
• Designed and developed ETL processes and framework to support liquidity regulatory compliance reports (FRB LCR, OSFI LCR, NCCF, LRM and NSFR, 2052a and other finance compliance reports)
• Maintained and provided support for dimensional data models supporting large data warehouse
• Created and maintained complicated data conversion scripts, SSIS packages and ETL process to intake data from various sources allowing details logging and reporting supporting data governance

Environment: Windows 2012, SQL Server 2012 (RDBMS), SSIS, SSRS, SSAS, Visual Studio 2017, SharePoint 2012, Microsoft Team Foundation Services, Bitbucket, Source Tree, JIRA and Confluence

Confidential

Senior ETL Architect/Lead

Responsibilities:

• A lead member of confidential data migration and conversion team
• Actively involved in the development and implementation of data architecture to support multiple layers of data conversion and data migration
• Designed and developed data conversion / data migration framework
• Prepared source to target data mapping document including data transformation based on complex business requirement and logic
• Developed data conversion and data migration strategies sourcing data from multiple sources; Mainframe, MS-Access Database, Text Files. Oracle and SQL Server
• Designed and developed hundreds of SSIS packages to support multiple layer of data migration and data conversion layers to map target systems
• Established standards, naming convention and developed SSIS template packages to assist development team to design the SSIS packages with consistent naming of various control flow and data flow objects of SSIS packages
• Designed and assisted in the development of SSIS batch execution process to support execution of hundreds of SSIS packages using multiple threading including dependencies between the SSIS packages and parallel execution
• Actively involved in the Microsoft Azure (cloud based platform) proof of concept project to support new business reporting solution using Microsoft Azure SQL database, data factory and Power BI

Environment: Windows 2012, SQL Server 2016 (RDBMS), SSIS, SSRS, SSAS, Power-BI, Informatica, Visual Studio 2015, SharePoint 2012, Mainframe, Visual Studio Team Services (VSTS), Microsoft Dynamics CRM 2016, SSIS Integration Toolkit for Microsoft Dynamics 365, Git, Source Tree, Bugzilla, PowerShell

Confidential

Senior Consultant (Big Data - ETL/Metadata)

Responsibilities:

• A team member of high profile banking risk and regulatory compliance reporting project
• Designed and developed multiple Talend ETL/ELT processes to load data from multiple sources to target environment based on data mapping documents including business critical data transformation rules
• Created Talend jobs and processes to perform data conversion and data migration through various stages of data transformation layers
• Utilized Hadoop, HDFS, MapReduce, HIVE, Pig, sqoop
• Designed and created HIVE tables with partitioning and assisted in optimization of HIVE queries to improve performance
• Played a key role as Meta Data Engineer in preparing technical metadata documents to support ingestion of hundreds and thousands of data files (various formats including COBOL copybook)
• Provided ongoing support to ingest thousands of data files (structured data) sourced from multiple lines of business
• Managed relationship with business stake holders, data governance team and information architects

Environment: Apache Hadoop (Hortonworks), YARN, Ambari, Ranger, Atlas, HUE, MapReduce, HIVE, Pig, Sqoop, Confluence, JIRA, Talend Studio, Git, UNIX

Confidential

MS BI Consultant

Responsibilities:

• Played a key role in a large data warehouse/business intelligence project to provide performance metrics of health service providers (HSPs) ranging from community agencies to globally renown hospitals in Ontario’s only complete urban and most socially and economically diverse LHIN (Local Health Integrated Network), the Toronto Central LHIN
• Designed and developed the Hospital and Community Sector dashboards and reporting solutions using Microsoft SQL Server suite products including SSIS, SSRS, SSAS and SharePoint
• Developed and maintained dimensional data models
• Provided technical expertise in the design and development of reporting and dashboard architecture utilizing Microsoft Business Intelligence (dimensional model) technologies and Dundas BI tools
• Provided guidance and direction to the Business Intelligence team to create an enterprise data management vision and strategy to leverage new cloud based technologies
• Designed and created SSIS packages using various input formats including Excel and SQL Server

Environment: SQL 2012 (RDBMS), SSIS, SSRS, SSAS, MS SharePoint 2010, Team Foundation Server, Dundas BI, MS Power BI

Confidential

Data Architect

Responsibilities:

• Played a key role in one of the largest projects awarded to Locus by one of the largest state banks in USA to migrate 100+ TB of data from mainframe to OpenText Content Server and OpenText Vista Print
• Provided support for data architecture, administration and management of OpenText Content Server and Microsoft SharePoint installations for multiple clients

Environment: Oracle 11g (RDBMS), OpenText Content Server 10, OpenText VistaPrint, Microsoft SharePoint 2010

Confidential

Global Database Architect

Responsibilities:

• Played a key role in the development and implementation of long term technology roadmap
• Provided architectural expertise, direction, and assistance to confidential’s projects
• Recruited, trained and supervised a team of DBAs responsible for providing database architecture, administration and support of 150+ database servers hosting 2500+ databases across the globe
• Established an efficient and effective standards and processes to continuously improve quality
• Established database standards, policies, procedures and guidelines to support the installation and management of database management systems supporting projects across the globe
• Worked closely with the infrastructure team leads to ensure the database environment was stable, reliable, and optimized for performance
• Provided technical knowledge and expertise to various business and technical managers to evaluate and select appropriate database hardware/software to support projects across the business functions
• Designed and implemented SQL Server replication architecture for high profile project’s database(s) using multiple publishers, distributors and subscribers across the globe
• Managed and completed a database upgrade project involving more than 100 database servers from SQL 7.0/SQL 2000 to SQL 2008/2005 resulting in savings of hundreds and thousands of dollars in hardware and software cost
• Provided support with the installation of two-Node cluster for SAP SQL Server database running SQL 2012 to provide high availability and disaster recovery via VMware SRM (Site Recovery Manager)
• Provided support with the installation, setup and configuration of SQL 2012 high availability feature AlwaysOn (in lab) to demonstrate readable secondary copies for one or more user databases without the need of shared storage and zero configuration of applications and clients during failover

Environment: SQL 2012/2008/2005/2000 /7.0 (RDBMS), SSIS, SSRS, SSAS, MS SQL Server 2012/2008/2005/2000 , Windows 2012/2008 R2/2008, SAP Business Objects, ER-Win, SQL Diagnostic Manager (IDERA), Orion-Network Performance Monitor, Orion-Server/Application Monitor, Livelink (OpenText), SmartPlant/3D (Bentley and Intergraph), INFRA (Incident/Change Management System), Equitrac (Print Management and Cost Recovery System), Sassafras (Software Asset Management), Primavera P6, Oracle 11g/10g, MS Access, Toad for Oracle, VMWare, Hyper-V, HP-3PAR, HP-EVA

Confidential

Senior Database Administrator

Responsibilities:

• Planned, designed and implemented database technologies to provide business critical application and 24/7 database system availability using SaaS (cloud) model
• Designed and implemented four-node SQL Server cluster solution
• Provided database administration and support including database backup, recovery and performance tuning of more than 600 databases serving customers across North America and Asia
• Provided direction and support in the planning and architecture of data center operations, security and database performance metrics in SaaS (cloud) environment
• Developed Entity-Relationship data models (logical and physical) to capture business requirement and to support development team

Environment: MS SQL Server 2005 (RDBMS), SSIS, SSRS, SSAS, Windows 2003/2000, Windows/SQL Clustering, DTS, ER-Win, SQL Diagnostic Manager (IDERA), EMC CLARiiON

Confidential

Corporate Database Administrator

Responsibilities:

• Planned, designed and implemented database technologies including Microsoft clustering, SQL Server replication, data warehouse and data mining
• Provided administration and support for MS SQL Server and Oracle databases

Environment: MS SQL Server, Oracle, Windows 2000 (RDBMS), SQL-Replication, ER-Win

Confidential

Senior Database Consultant/Architect

Responsibilities:

• Provided technical knowledge and expertise to key customers such as confidential 
• Responsible for the database design, development and implementation of mission critical systems used by engineers, technical managers and astronauts
• Responsible for the database administration and support of Sybase SQL Server and Replication
• Played a key role in the migration and upgrade from Sybase SQL Server to MS SQL Server
• Designed and implemented MS SQL Server real-time replication between Brampton, Houston (NASA) and Montreal (Canadian Space Agency) using customized replication to meet data security requirements

Environment: MS SQL Server 7.0/6.5/6.0 (RDBMS), SQL Replication, MS Access 97, Windows NT 2000/4.0, ER-Win, PowerBuilder

Confidential

Senior Database Administrator

Responsibilities:

• A key member of the corporate architecture and technology group providing database knowledge and expertise in the evaluation and selection of business critical systems, database management systems and related technologies
• Designed database and provided database administration of all business systems
• Provided key support in the data migration of financial applications database(s) from IBM DB2 to Sybase SQL Server
• Provided administration and support of Sybase SQL Server

Environment: Sybase SQL Server, IBM DB2, IBM-Mainframe MVS-ESA, JCL, Assembler, RPG II, COBOL II, Software AG ADABAS