PROFESSIONAL SUMMARY:

• 14+ 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
• 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 TFSBusiness Solution: Asset Management, CMMS, ArcGIS, MDM, Reliability Management, Strategies and Algorithm, Trades & Sequential Attribution, Mortgage, Energy Derivatives, Claim Management

PROFESSIONAL EXPERIENCE:

Data Architect (Datawarehouse, Data Analytics)

Confidential

Responsibilities:

• 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 work load.
• 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.
• Designeddatalake(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 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 re.
• 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

Data Architect (Data Governance, Data Analytics)

Confidential

Responsibilities:

• 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, Work Flows, Custom Business Processes and developing C#, .NET applications to handle large data-set 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 & roll-backs.
• 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

Contractor (Business Intelligence & Data analytics)

Confidential

Responsibilities:

• 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 & roll-backs
• 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

Data Architect

Confidential

Responsibilities:

• 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

Consultant/Team Lead

Confidential, Houston, TX

Responsibilities:

• 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 work load.
• 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

Senior Consultant - Data Analytics

Confidential

Responsibilities:

• 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 JDEdwardsand 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 modeling & architecture
• Created new models for the data sources - flat files, web services, Oracle and MS SQL server.
• Quantitative data analysis & modeling 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

Sr. Consultant (Data Analytics)

Confidential

Responsibilities:

• 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).
• Createdplatform 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 inmonitoring 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 work load.
• 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

Senior Engineer (BI & Data Analytics)

Confidential

Responsibilities:

• 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

Senior Architect (Enterprise Architecture)

Confidential

Responsibilities:

• 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: 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

Business Analyst (ERP Systems)

Confidential

Responsibilities:

• 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 efforts.
• Ledtechnical 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

Subject Matter Expert/Program Manager (BI & DW)

Confidential

Responsibilities:

• 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