PROFESSIONAL SUMMARY:

 18+ years of experience in IT with hands on experience working on Business Intelligence, MDM, and CRM, Data
warehouse, Data Analytics, and Big-data projects.
 Excellent experience for developing, designing and documenting the process and solution, to identify challenges,
risks, and dependencies that are often found in Business Intelligence, MDM, and CRM, Data warehouse (Data
Vault and 3NF form), Data mart (dimension model), Data Lake (delta lake and lake-house), Data Analytics (data
visualization, machine learning), and Big-data (Hadoop and spark) projects.
 Data migration and data conversion from legacy system to ERP system e.g., SAP, Microsoft Dynamics AX,
JdEdwards
 Facilitated several organizations through their digital transformation journey by helping them migrate from On -
Prem to Cloud solutions using MS Azure Stack.
 Worked across Microsoft Azure Data Lake, Databricks, Data Factory, Cognitive Search, ASQL Database.
 Experience in planning and directing product development projects that require managing time, budget, and
resources to meet objectives. If needed support program managers and project directors by providing technical
task breakdowns, duration and effort estimates, as well as identifying project risks and mitigation plans
 Expertise in translating enterprise requirements into systems specifications (BRD-business requirement and FRD-
functional requirement documents) and all aspects of technical systems design according to the TOGAF
architecture.
 Strong experience in performing Gap Analysis for new or existing functionality and requirements, as well as
prioritized them based on actual business needs so as to align them with the product release roadmap.
 Experience working on design and development of UI mock-ups, storyboards, flow diagrams, conceptual
diagrams, visual mock-ups, and interactive prototypes as they apply to the creative and effective visualization of
data across multiple business units.
 Hands on experience on quantitative data analysis and modelling including risk assessment to enable business and
algorithms to make a better decision
 Experience in designing Data and Application Architecture for data analytics, data warehouse, and business
intelligence solutions including data modelling and process modelling by using TOGAF and Zachman framework
including relational and dimensional data modelling.
 Extensive experience in developing ETL (extract, transform, load), ODS (operation data store), data lake,
dashboard, scorecard, data marts, cubes, reports, BI websites, data integration, process integration solutions.
 Good business knowledge of Exchange Traded Derivatives (Futures, Options, Stock, Equities, Commodities &
FX) and OTC (over the counter), Operation Risk and Compliance, Data Governance, Enterprise Asset
Management, CMMS/Reliability, accounting, financial reporting, and consumer & investment banking.
 Experience on Risk Modelling, positions, exposures or other factors that may expose the organization to unusual,
unexpected, inappropriate or otherwise not fully identified or quantified risks
 Expertise in designing, creating and executing high-quality reusable test cases and scripts while working in Agile
Teams.
 Strong experience in creating, maintaining, and executing test plans and test cases against different hardware and
software platforms.

TECHNICAL SKILLS:
Databases : MS SQL Server, Oracle, MS Access, DB2, Geospatial – GIS, Hadoop, Databricks
Languages : Python, Microsoft .Net C#, SAS, VBA, PL/SQL, T-SQL, MDX, DAX
ETL Tools : Azure ADF, Microsoft SSIS, Informatica, Oracle ODI/BW, OBIEE, FME (GIS), Talend
(Hadoop), Sqoop
BI Reporting : Power BI, SSRS, Performance Point, Business Objects, Tableau, SharePoint
ERP System : SAP, Microsoft Dynamics, JDEdward, Maximo, Gold, Tomax
Modelling : Erwin, Microsoft Visio
QA Tools : Jira, HP Quality Center, Microsoft TFS,
Business Solution : Asset Management, CMMS, ArcGIS, MDM, Reliability Management, Strategies and
Algorithm, Trades & Sequential Attribution, Mortgage, Energy Derivatives, Claim
Management

EDUCATION:
 Post-Graduation (Computer/Software Engineering)
CERTIFICATION:
 SAP Certified Consultant (Technical), Specialization in PM (Plant Maintenance)

PROFESSIONAL EXPERIENCE:
Apr 22 – till now Solution/Data Architect, Microsoft, Redmond,
WA
 Analyze customers’ data estate, including common workloads, use patterns and business priorities and needs and
arrive at solution architecture, design and implementation approach.
 Experience in Azure Synapse Analytics, Azure Data Factory, Azure Data Lake, Azure SQL Server, Azure SQL
DB, Azure Databricks, Azure Monitor, Azure DevOps, Azure Functions, Application Insights, Azure Logic Apps,
Azure Active Directory, Azure Event Hub, Cosmos DB, SSIS, SSAS, SSRS, Azure AI&ML and Power BI.
 Programming skills in SQL, PySpark, Python, .Net, JavaScript etc.
 Provide thought leadership for technical architecture, design, development, deployment and guide customer
towards accelerated adoption of Azure cloud data platform.
 Lead the adoption of Azure cloud platform technologies based on analysis/differentiation of Microsoft and
competitor products to influence the customer cloud adoption strategy.
 Lead a team of technical architects, technical leads and developers to build Proof of concepts (POCs) /
Minimum Viable Products (MVPs) etc. and guide customers through cloud adoption projects.
 Apply modern data platform architectures and data engineering best practices to build, implement, and optimize
analytical data solutions including data lake, data warehouse, data lake house etc. with streaming and batch data
processing and visualizations.
 Identify opportunities for improvements and enhancements based on stakeholder feedback and help incorporate
them into the overall technical strategy.
 Anticipate, identify, and remove technical blockers through regular technical reviews and check ins to accelerate
solution implementations.
 Ensure that solution exhibits high levels of performance, security, scalability, maintainability, and evolvability
upon deployment. Apply governance to identify, communicate, and minimize business and technical risks.
 Be an Azure cloud evangelist with customers, partners and external communities.
Environment: Azure, Python, ADF-Data Factory, Databricks, Synapse, Oracle, SQL Server, SSIS, SSRS, Power BI,
SSAS, SAP, Azure Function, Cosmos DB

Nov 18 – Apr 22 Senior Consultant (Datawarehouse, Data Analytics), TD Bank, Mississauga/New

Jersey
 Works with internal clients to gather business requirements and evaluates data requirements including data lineage
and data profiling to create STM (source to target data mappings) and extensively using team-collaboration tools
(Confluence, Jira, Microsoft Team) and make ensures consistent use of internal information architecture
standards.
 Data conversion, data migration and data integration from legacy system and data warehouse to new system
 Engage with all stakeholders, (i.e. project owners, external vendors, internal business and technology teams) and
lead meetings with internal and external clients to gather and document business requirements.
 Translates user requirements into technical architecture vision and implementation plans, going from design to
implementation to production support which includes development of enterprise-level information technology
solutions by analyzing, coding, configuring, testing, and implementing new and by modifying/enhancing existing
applications utilizing Microsoft SQL Server, IBM, Oracle and SAP technologies
 Conduct deficiency gap analysis using engineering principles; design, develop & implement financial apps for
end-to-end management of the Software Development Life Cycle (SDLC) by using Agile/Scrum project
management methodology
 Designs data models including customized business dimensions, facts and measures to support scorecard and self-
service reporting needs by using Microsoft and Informatica technologies including Microsoft SQL Server, Azure
Data Factory, Power Designer, SSAS, SSIS, Power BI
 Monitoring and performance tuning of Windows Cluster and SQL Server database clusters (Profiler, Tracing,
Execution Plan Analysis), data and application integration (ETL, OS scripting) and data migration; including
allocation and de-allocation of hardware resources according to the workload.
 Designs system and databases architecture using star, snowflake, normalization techniques required for data
modelling, including conceptual, logical, physical database design (OLTP, OLAP, Data Warehousing, UML) by
using ERwin, Visio, which includes capacity planning of databases and data marts by using TOGAF and Zachman
framework.
 Designed datalake(delta lake, lakehouse), data Warehouse schemas (Data Vault, 3NF model) as well as Data Mart
schemas (Dimensional model)
 Test webservices by using SOAPUI which includes SQL query, Web Services Description Language (WSDL),
SOAP
 Unify data from many sources (including SAP, Mainframe, Maximo, DB2, Oracle, Sales Force, SQL Server,
JSON, XML, Hadoop etc.) to create interactive, immersive dashboards and reports that provide actionable insights
and drive business results.
 Designs development and maintenance of complex SQL, PL/SQL, TSQL, MDX, DAX queries, views, triggers
and stored procedures including cubes (SSAS / Tabular) cube hierarchies, partitioning, Measures, KPI etc. for
efficient data visualization and data management
 Uses Microsoft SQL Server Analysis Services, Integration Services, Reporting Services and Power BI to develop
interactive dashboards, data visualizations, balance scorecards and other analytics for self-service BI solutions
 Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
 ELT/ETL from different data sources including building data pipelines and deploying ML models to production.
 Data engineering to design & monitor data pipelines that feed into ML model training and inferencing workflows,
MLOPs best practices to permit continuous integration/continuous deployment (CI/CD) of newer artefacts in the
ML production cycle, and management of ML models in production including continuous performance
monitoring, incident resolution, and model retraining.
 Designing and developing Data Pipelines for Data Ingestion or Transformation using Python and (PySpark)/Spark
SQL for Hadoop data lake
 Migrating the in-house data-warehouse to Microsoft Azure Data Stack (Databricks, Azure Data Factory, Azure
Synapse Analytics)
Environment: Azure, Python, ADF-Data Factory, Databricks, Synapse, Oracle, SQL Server, SSIS, SSRS, Power BI,
SSAS, DB2, Erwin, Jira, Azure Function, Cosmos DB

Jan 18 – Oct 18 Sr. Consultant (Data Governance, Data Analytics), Longos Brothers Fruit Market,
Canada
 Designed, developed and maintained Data Warehousing and Data Analytics/BI solution including ETL and data
integration solutions, database query optimization and RDBMS maintenance
 Data Conversion and data migration of Legacy ERP system to Symphony Gold AI ERP system which includes
FICO (Financial and Internal Control), MM (Material Management), Asset Management (Plant Maintenance and
Work Order), HR (Human Resource including Payroll).
 Gathered business requirements, documented reporting and analysis specifications, designed technical
architecture, installed and configured ETL solutions.
 Explored data in a variety of ways and across multiple visualizations.
 Utilized Power BI to create various analytical dashboards that depicts critical KPIs.
 Developed an efficient solution using jQuery, Plug-In, Workflows, Custom Business Processes and developing
C#, .NET applications to handle large dataset for AI (artificial intelligence) system.
 Participated in business requirements analysis, functional specifications, data profiling, data mapping for large
scale data warehouse implementation.
 Provided support in the development of data analytics/BI components and solutions
 Developed data extraction, transformation, and load programs (daily and initial load) functionality on a wide
range of data repositories (relational and multi-dimensional data stores), including familiarity with MS SSIS and
Data Factory
 Designed and developed data modelling like star schema and dimensional modelling
 Performed regression analysis, basket analysis, segmentation analysis, and correlation analysis
 Planned pricing, display, and coupon promotion strategies and designed an interactive presentation
 Used Informatica tools to create inbound and outbound web service messages from a traditional data source which
includes WSDL (SOAP),
 Developed and designed ETL Scripts, data mapping, XML Parsing, Web services, XML, SOAP, Web Services
Description Language (WSDL).
 Tested webservices by using SOAPUI which includes SQL query, Web Services Description Language (WSDL),
SOAP.
 Developed complex workflows that integrate notification emails & rollbacks.
 Developed complex Oracle PL/SQL scripts to retrieve and format data to meet business requirements which
includes DML/DDL script development.
Environment: Oracle 12C, SSIS, SSRS, SharePoint, Angular, .Net C#, MicroStrategy, Symphony GOLD Retail AI,
Erwin, Azure , PL/SQL, T-SQL

Sep 15 – Dec 17 Contractor (Business Intelligence & Data analytics) TD Bank, Mississauga,
Canada
 Worked on design and development of UI mock-ups, storyboards, flow diagrams, conceptual diagrams, visual
mock-ups, and interactive prototypes as they apply to the creative and effective visualization of data across
multiple business units.
 Created mapping documents to outline data flow from sources to targets.
 Designed datalake(delta lake, lakehouse), data Warehouse schemas (Data Vault, 3NF model) as well as Data Mart
schemas (Dimensional model)
 Involved in Dimensional modelling (Star Schema) of the Data warehouse and used Erwin to design the business
process, dimensions and measured facts.
 Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data
warehouse.
 Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow
Monitor.
 Parsed high-level design specification to simple ETL coding and mapping standards.
 Designed and customized data models for Data warehouse supporting data from multiple sources on real time
 Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
 Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
 Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored
Procedure, and Union to develop robust mappings in the Informatica Designer.
 Involved in analyzing, designing, developing, testing, implementing, and demonstrating BI and Data Analytics
tools - Microsoft cloud technologies and PowerBI.
 Developed data extraction, transformation, and load programs (daily and initial load) functionality on a wide-
range of data repositories (relational and multi-dimensional data stores), including familiarity with MS SSIS and
Data Factory
 Developed mapping parameters and variables to support SQL override.
 Created mapplets to use them in different mappings.
 Used Informatica tools to create inbound and outbound web service messages from a traditional data source which
includes WSDL (SOAP),
 Developed and Designed ETL Scripts, data mapping, XML Parsing, Web services, XML, SOAP, Web Services
Description Language (WSDL)
 Tested webservices by using SOAPUI which includes SQL query, Web Services Description Language (WSDL),
SOAP.
 Developed complex workflows that integrate notification emails & rollbacks
 Developed complex Oracle PL/SQL scripts to retrieve and format data to meet business requirements which
includes DML/DDL script development
 Developed mappings to load into staging tables and then to Dimensions and Facts.
 Used existing ETL standards to develop these mappings.
 Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command,
worklets, Assignment, Timer and scheduling of the workflow.
 Created sessions, configured workflows to extract data from various sources, transformed data, and loading into
data warehouse.
 Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
 Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
 Modified existing mappings for enhancements of new business requirements.
 Used Debugger to test the mappings and fixed the bugs.
 Involved in Performance tuning at source, target, mappings, sessions, and system levels.
 Prepared migration document to move the mappings from development to testing and then to production
repositories.
Environment: Azure, Python, ADF-Data Factory, Angular, Oracle, Hadoop, SQL Server, SAP, IBM Maximo, SSIS,
SSRS, Power BI, SSAS, DB2, Power Designer, Confluence, Jira

Jan 15 – Aug 15 Data Architect, Provincial Health Services Authority, Vancouver,

Canada
The Provincial Health Services Authority (PHSA) British Columbia, Canada plans, manages and evaluates selected
specialty and province-wide health care services across BC, working with the five geographic health authorities.
 Responsible for programming, testing, debugging, and documenting simple to moderately complex big data
applications under direct supervision.
 Maintained and modified existing ETL applications and corresponding documentation
 Maintained and developed Oracle PL/SQL procedures and Packages
 Managed and administrated database/Datawarehouse/BI servers including User Management, DDL/DML code
review, Code promotion/releases, Query/Indexes/Object tuning, DB Performance tuning, Data refreshes (prod to
non-prod), Database patching (security) etc.
 Participated in the entire lifecycle for Business Intelligence Solution Delivery
 Designed, built, documented and managed data warehouse objects
 Software Development including Database, ETL and BI solution by using Microsoft .Net Platform
 Designed and developed ETL processes using SQL Server Integration Services (SSIS)
 Developed BI Solution (DBMS, SSIS, SSAS) architecture and performance tuning. Developed, test and deliver
error free data
 Designed and develop reports using SQL Server Reporting Services
 Designed and develop OLAP Cubes and Tabular models using Analysis Services (SSAS)
 Worked on data wrangling to solve issues.
 Mentored junior programmers/statisticians on coding and data principles.
 Worked with statisticians in understanding the data.
 Worked with applications systems design specifications including data modelling & architecture (TOGAF and
Zachman framework). Utilizes company standards, procedures, and techniques.
 Used simple to moderately complex debugging techniques to test ETL applications.
 Built enterprise level BI, DW and reporting solutions that protect high-sensitive information.
 Worked with BPS governance methodologies (e.g. UPM, architecture gating).
Environment: SSIS, SSRS, SQL Server, DB2, .Net, Erwin, SAS, Pega, SharePoint, Oracle, PL/SQL, T-SQL

Jun 13 – Dec 14 Consultant/Team Lead, Amec Foster Wheeler Calgary, Canada/Houston,

TX
 Worked on design and development of UI mock-ups, storyboards, flow diagrams, conceptual diagrams, visual
mock-ups, and interactive prototypes as they apply to the creative and effective visualization of data across
multiple business units.
 Created platform independent and interactive BI solution – reports, dashboards and Scorecards that are highly
customizable and scalable, using technology that allows the end result to be easily embedded into web sites and
viewable across a wide variety of devices.
 Data Conversion, data migration and data integration of Legacy ERP system to SAP and Maximo ERP system
which includes FICO (Financial and Internal Control), MM (Material Management), Asset Management (Plant
Maintenance and Work Order), HR (Human Resource including Payroll).
 Responsible for developing, supporting and maintaining global CMMS/Reliability/PM solutions as determined by
the PM team.
 Worked on development and implementation of Master Data Management and Global Data Governance policies
and procedures.
 Quantitative data analysis & modelling including risk assessment to enable business and algorithms to make better
decisions.
 Verified and validated Engineering Drawing including P&IDs, Termination Drawing, datasheets etc. Maintain
FLOC, BOM, PRTs, Strategies, Work Aids, Procedures, Equipment/Material register, Task List, Operations,
Maintenance Plan
 Worked with internal clients to gather business requirements and evaluates data requirements including data
lineage and data profiling to create STM (source to target data mappings) and extensively using team-
collaboration tools and make ensures consistent use of internal information architecture standards.
 Engaged with all stakeholders, (i.e., project owners, external vendors, internal business, and technology teams)
and lead meetings with internal and external clients to gather and document business requirements.
 Translated user requirements into technical architecture vision and implementation plans, going from design to
implementation to production support which includes development of enterprise-level information technology
solutions by analyzing, coding, configuring, testing, and implementing new and by modifying/enhancing existing
applications utilizing Microsoft SQL Server, IBM, Oracle, and SAP technologies
 Migrated and data load into CMMS system e.g., SAP, Maximo
 Conducted deficiency gap analysis using engineering principles; design, develop & implement financial apps for
end-to-end management of the Software Development Life Cycle (SDLC) by using Agile/Scrum project
management methodology
 Designed data models including customized business dimensions, facts and measures to support scorecard and
self-service reporting needs by using Microsoft and Informatica PowerCenter technologies including Microsoft
SQL Server Reporting Services, SSAS, SSIS, Power BI
 Involved in monitoring and performance tuning of Windows Cluster and SQL Server database clusters (Profiler,
Tracing, Execution Plan Analysis), data and application integration (ETL, OS scripting) and data migration,
including allocation and de-allocation of hardware resources according to the workload.
 Worked with VS2012 .NET Framework 4.0, Asp.net, C# .Net and MVC Web Application by using SOAP and
REST web services for processing real-time data streams.
 Designed system and databases architecture using star, snowflake, normalization techniques required for data
modelling, including conceptual, logical, physical database design (OLTP, OLAP, Data Warehousing, UML) by
using Erwin, Visio, which includes capacity planning of databases and data marts by using TOGAF and Zachman
framework.
 Unified data from many sources (including SAP, Mainframe, Maximo, DB2, Oracle, Sales Force, SQL Server,
JSON, XML, Hadoop etc.) to create interactive, immersive dashboards and reports that provide actionable insights
and drive business results.
 Worked on design, development, and maintenance of complex SQL, MDX, DAX queries, views, triggers and
stored procedures including cube hierarchies, partitioning, Measures, KPI etc. for efficient data visualization and
data management
 Identified and driven resolution of data issues in CMMS system as needed e.g., BOM, Functional Location,
Equipment Register, Material Register, Task List, Strategies, RSPL, SPIR, Work Order etc.
 Maintained sprint management system queue and provide updates in line with agile methodologies. Coordinate
and manage offshore team and vendor. Work with vendor and internal teams to assure readiness of test &
production environments.
Environment: SAP, IBM Maximo, SSIS, SSRS, SQL Server,.Net, Erwin, Oracle, PL/SQL, T-SQL, Informatica
PowerCenter, SharePoint

Dec 2012 – May 2013 Senior Consultant – Data Analytics, Enbridge,

Calgary
Enbridge is a North American leader in delivering energy. As a transporter of energy, Enbridge operates, in Canada
and the United States, the world longest crude oil and liquids transportation system.
 Developed ETL, Business Intelligence, Operations reporting and Data Mart/DW (OLAP Cube) solutions
 Worked with database architects and business analysts to aid in building more robust BI and DW infrastructure to
increase process efficiency
 Data Conversion, data migration and data integration of Legacy ERP system to JDEdwards and Maximo system
which includes FICO (Financial and Internal Control), MM (Material Management), Asset Management (Plant
Maintenance and Work Order), HR (Human Resource including Payroll).
 Aggregate data from multiple sources in an efficient data warehouse and deliver reports, dashboards, and analytics
for Liquid Pipelines business advancement especially financial derivatives
 Responsible for ensuring the quality and reliability of all solutions, including specification reviews, test planning,
test case development, executing the tests, reporting bugs, functional and regression testing, driving hotfixes and
more.
 Comprehending business & functional requirements including data modelling & architecture
 Created new models for the data sources – flat files, web services, Oracle and MS SQL server.
 Quantitative data analysis & modelling including risk assessment to enable business and algorithms to make better
decisions.
 Performed an in-depth analysis of the system's organizational structure, services, and processes.
 Migrated existing data marts and .net applications to a modern and scalable infrastructure that will serve as the
foundation of BI and analytical capability for the new Centre of Excellence.
Environment: Oracle Warehouse Builder, OBIEE, JdEdward, SAP, PL/SQL, SharePoint, MS SQL Server,.Net C#,
Erwin, Excel/VBA

Oct 2011 – Nov 2012 Sr. Consultant (Data Analytics), Shell Inc., Calgary, Canada/Houston,
TX
Shell is a global group of energy and petrochemical companies. Responsible to develop pilot projects of three GIS
based DW/BI applications related to FWELL, Field and Reservoir Applications. After successfully completion of
those projects, a five year multi-million-dollar (approx. $500 million) projects have been awarded to Accenture. I was
a fulltime employee of Avanade (a company owned by Microsoft and Accenture).
 Managed and administrated database/Datawarehouse/BI servers including User Management, DDL/DML code
review, Code promotion/releases, Query/Indexes/Object tuning, DB Performance tuning, Data refreshes (prod to
non-prod), Database patching (security), Coordinate with Vendor Physical DBA for database upgrade, Schema
Creation etc.
 Worked on design and development of UI mock-ups, storyboards, flow diagrams, conceptual diagrams, visual
mock-ups, and interactive prototypes as they apply to the creative and effective visualization of data across
multiple business units.
 Data Conversion, data migration and data integration of SAP ERP system to Maximo ERP system which includes
FICO (Financial and Internal Control), MM (Material Management), Asset Management (Reliability, Plant
Maintenance and Work Order), HR (Human Resource including Payroll).
 Created platform independent and interactive BI solution – reports, dashboards and Scorecards that are highly
customizable and scalable, using technology that allows the end result to be easily embedded into web sites and
viewable across a wide variety of devices.
 Involved in monitoring and performance tuning of Windows Cluster and SQL Server database clusters (Profiler,
Tracing, Execution Plan Analysis), data and application integration (ETL, SSIS, OS scripting) and data migration,
including allocation and de-allocation of hardware resources according to the workload.
 Developed, supported and maintained global CMMS/Reliability/PM solutions as determined by the PM team.
 Participated in the development and implementation of Master Data Management and Global Data Governance
policies and procedures.
 Quantitative data analysis & modelling including risk assessment to enable business and algorithms to make better
decisions.
 Verified Engineering Drawing including P&IDs, Termination Drawing, datasheets etc. Maintain FLOC, BOM,
PRTs, Strategies, Work Aids, Procedures, Equipment/Material register, Task List, Operations, Maintenance Plan.
 Worked with internal clients to gather business requirements and evaluates data requirements including data
lineage and data profiling to create STM (source to target data mappings) and extensively using team-
collaboration tools (Confluence, Jira, Microsoft Team) and make ensures consistent use of internal information
architecture standards.
 Engaged with all stakeholders, (i.e., project owners, external vendors, internal business, and technology teams)
and lead meetings with internal and external clients to gather and document business requirements.
 Migrated data and load files into CMMS system e.g., SAP, IBM Maximo
 Translated user requirements into technical architecture vision and implementation plans, going from design to
implementation to production support which includes development of enterprise-level information technology
solutions by analyzing, coding, configuring, testing, and implementing new and by modifying/enhancing existing
applications utilizing Microsoft SQL Server, IBM, Oracle, and SAP technologies
 Conducted deficiency gap analysis using engineering principles; design, develop & implement financial apps for
end-to-end management of the Software Development Life Cycle (SDLC) by using Agile/Scrum project
management methodology
 Designed data models including customized business dimensions, facts and measures to support scorecard and
self-service reporting needs by using Microsoft technologies including Microsoft SQL Server Reporting Services,
SSAS, SSIS, Power BI
 Designed system and databases architecture using star, snowflake, normalization techniques required for data
modelling, including conceptual, logical, physical database design (OLTP, OLAP, Data Warehousing, UML) by
using Erwin, Visio, which includes capacity planning of databases and data marts by using TOGAF and Zachman
framework.
 Unified data from many sources (including SAP, Mainframe, DB2, Oracle, Sales Force, SQL Server, JSON,
XML, Hadoop etc.) to create interactive, immersive dashboards and reports that provide actionable insights and
drive business results.
 Worked on design, development, and maintenance of complex SQL, MDX, DAX queries, views, triggers and
stored procedures including cubes (SSAS / Tabular) cube hierarchies, partitioning, Measures, KPI etc. for efficient
data visualization and data management
 Identified and driven resolution of data issues in CMMS system as needed e.g. BOM, Functional Location,
Equipment Register, Material Register, Task List, Strategies, RSPL, SPIR, Work Order etc.
 Maintained sprint management system queue and provided updates in line with agile methodologies.
 Coordinated and managed offshore team and vendor. Worked with vendor and internal teams to assure readiness
of test & production environments.
 Developed GIS, Business Intelligence and Data-Warehouse solution including Metadata, CDC, database partition,
ETL packages development by using Python
 Designed, developed and tested low and high-latency systems capable of reliably handling large volumes of data
and orders. Quantitative data analysis & modelling including risk assessment to enable business and algorithms to
make better decisions.
 Modified and updated GIS, BI, ETL and DW framework. Migrate database from SAP environment (SQL Server
2005) and develop ODS (Operation Data Store) SQL Server (2008)
 Upgraded ODS system from SQL Server 2008 to SQL Server 2012 including .Net BI applications
 Maintained sprint management system queue and provide updates in line with agile methodologies
Environment: SAP, SSIS, SSRS, SQL Server, DB2, .Net, Erwin, Oracle, SharePoint, Python, ArcGIS

Dec 10 – Sep 11 Senior Engineer (BI & Data Analytics), Altalink, Calgary,
Canada
 Managed and administrated database/Datawarehouse/BI servers including User Management, DDL/DML code
review, Code promotion/ releases, Query/Indexes/Object tuning, DB Performance tuning, Data refreshes (prod to
non-prod), Database patching (security), Coordinate with Vendor Physical DBA for database upgrade, Schema
Creation, Ongoing Schema Maintenance (Reorg), Tablespace management (ASM), Database schema/ object
recoveries etc.
 Developed data analytics and data visualization solutions including KPI and dashboards
 Provided software application maintenance and enhancements, and ongoing expertise for in-house developed and
off-the-shelf application packages.
 Worked on Data Migration from SAP to SharePoint and DW (OLAP Cube) environment
 Provided technical database administration, maintenance, and development for Corporate System applications,
including monitoring and creating interfaces between applications, and performing data audits.
 Software Development including Database, ETL and BI solution by using Microsoft .Net Platform
 Developed and maintained reports for stakeholders.
 Ensured the company’s business requirements for capital project engineering, construction and document control
are being met.
 Worked on Database and System Administration.
 Involved in requirement engineering/business analysis including data modelling & architecture (TOGAF and
Zachman framework)
 Maintained source code version control and installation software inventory.
 Worked on client/server and web application installation, maintenance, configuration, and upgrades
 Technical writing, including documentation of procedures, technical requirements, and reporting.
 Provided technical support for all corporate-facing systems especially PM (Plant Maintenance) e.g., BOM,
Functional Location, Equipment Register, Material Register, Task List, Strategies, RSPL, SPIR, Work Order etc.
 Coordinated between the business and vendors for additional support
 Provided excellent customer service to our internal customers/users.
 Worked with vendor and internal teams to assure readiness of test & production environments
Environment: Oracle OBIEE, MS SQL Server, SharePoint, Business Objects/Crystal Report, SAP, Eclipse J2EE
(Spring), BIRT

Aug 09 – Nov 10 Senior Architect (Enterprise Architecture), Teck Resources Ltd., Calgary/Toronto, Canada
Worked on full implementation of Monitoring and Analytics features of MS Performance Point, SharePoint,
ProClarity, and SSRS specifically the KPI dashboard (Key Performance Indicators), data analysis by using SAS.
The tool is used to collect and consolidate data and provide analysis of data to enhance day-to-day decision making
and helping to operate more efficiently, effectively, and strategically.
 Centralized data, updated tracking and reporting capabilities, cut down on manual processes and automate daily
business tasks and workflows especially, BOM, Functional Location, Equipment Register, Material Register, Task
List, Strategies, RSPL, SPIR, Work Order etc.
 Software Development including Database, ETL and BI solution by using Microsoft .Net Platform
 Worked on design and development space of the project and its full implementation.
 Worked on Database and System Administration
 Involved in requirement engineering/business analysis including data modelling & architecture (TOGAF and
Zachman framework)
 Worked on data migration and data conversion from JD Edward (Oracle) and MS Dynamics AX (SQL Server) to
data-warehouse and GIS Data Integration
 Developed data-warehouse, data modelling, BI and data architecture and integrate with SharePoint, CDC,
database partition, SSIS packages development
 Developed and documented a technology roadmap through collaboration with the business teams.
 Led a group of developers and DBAs in architecting and building the EDW (Enterprise Datawarehouse)-OLAP
Cube for the reporting and analytics
 Worked with vendor and internal teams to assure readiness of test & production environments.
Environment: PL/SQL, T-SQL, Microsoft Dynamics AX, Erwin, Oracle, Performance Point, ProClarity, MS SQL
Server, SSRS, SSIS, SAS, MS Visio, MS Project, MS Excel, MS Access, MS .Net, BizTalk

Feb 2009 – Jul 2009 Senior Engineer (ERP & BI Systems), University of Rochester, Rochester,
NY
Project: Medical Advancement Management Systems
Environment: SAS, Oracle, PL/SQL, Oracle, Informatica, Unix, Oracle Reports, ER/Studio, Linux, MS Visio,
MS .Net, MS Project, MS Excel, MS Access)

Dec 2008 – Jan 2009 Senior Engineer (ERP & BI Systems), Wilton Re, Norwalk,
CT
Project: Insurance Management System
Environment: SAS, MS SQL Server 2008, .Net, Oracle, ER/Studio, Business Objects/Crystal Report, SharePoint,
Toad, Visual Studio Team Foundation (VSTF), MS .Net , Performance Point, ProClarity, Visio, MS Project, Excel

Apr 08 – Nov 08 Business Analyst (ERP Systems), Chevron Corporation, Burnaby, Canada & Richmond,
VA
 Implemented an Enterprise Asset Management & Reliability system for different refineries including gaining an
understanding of client business processes and improvement opportunities.
 Translated enterprise requirements into systems specifications and all aspects of technical systems design
according to the TOGAF architecture.
 Worked on Data Migration of Work Order, Vendor Master, Item Master, BOM, Functional Location, Equipment
Register, Material Register, Task List, Strategies, RSPL, SPIR, Work Order etc. etc.
 Ensured the company’s business requirements for capital project engineering, construction and document control
are being met.
 Supported system configuration, data conversion and cleansing, QA/Testing and User Training efforts.
 Led technical guidance to less experienced team members for specific engineering and programming activities
related to environment design and project implementation.
 Consulted with other technical areas regarding appropriate use of the Asset Management system and integration
with other line of business applications.
 Maintained sprint management system queue and provide updates in line with agile methodologies
 Coordinated and managed offshore team and vendor
 Worked with vendor and internal teams to assure readiness of test & production environments.
Environment: SAP, IBM Maximo, Oracle, OWB, Erwin, Visio, Crystal Report, ArcGIS, Toad, Informatica, Visual
Studio Team Foundation (VSTF), MS Project, MS Excel/Access, Unix, PL/SQL

Jul 07 – Mar 08 Subject Matter Expert/Program Manager (BI & DW), Microsoft Corporation, Issaquah,
WA
 Developed an Enterprise-wide Data Warehouse and BI reporting framework from strategy to implementation for
one of the top 20 divisions of Microsoft. As an Expert, designed the standards, plans, and frameworks for EDW,
ETL, BI Reporting, Dashboard, Meta-data Management, and Data Governance to ensure a successful
implementation of this far-reaching initiative.
 As a member of the BICoE (Business Intelligence - Centre of Excellence) team, worked on broad, complex, and
critical Data Warehouse engagements.
 Designed, architected, and managed full life cycle development of large data warehouse projects providing
guidance and direction to clients and project team members.
 Interacted with all levels of client technical and business management, along with various organizations in
Microsoft to marshal the resources required for successful implementation.
 Provided warehouse design, architecture, and implementation/integration effort, including data sourcing and
transformation.
 Helped define process to ensure that the clients' business goals and objectives are met by the proposed data
warehouse architecture and design.
 Gathered and written business requirements, design, and architect multi location databases with data flows and
synchronization mapping.
 Leveraged knowledge of current data warehouse and software development methodologies to contribute to the
overall planning of projects by recommending approaches, identifying resources, and developing timelines.
 Coordinated application releases into testing environments
 Provided technical leadership to project. Design data and reporting architecture framework
 Verified and updated conceptual data model. Designed logical and physical data model.
 Participated in and supported technical tasks as required. Relational and dimensional data modelling (OLAP
Cube)
 Medium to large data warehouse implementations. ETL architectures and design patterns
 Maintained sprint management system queue and provide updates in line with agile methodologies
 Coordinated and managed offshore team and vendor
 Worked with vendor and internal teams to assure readiness of test & production environments.
Environment: MS SQL Server (SSRS, SSIS, SSAS [MDX]), Visual Studio .Net, MS SharePoint, Performance Point,
ProClarity, Business Score Card, Excel Services, SAP, Report Builder, METaL (ETL Framework), Stratature
(EDM/MDM), Dynamic AX, Visual Studio Team Foundation (VSTF), MS Project, Visio, T-SQL