SUMMARY OF QUALIFICATIONS

Over ** year experience as Systems Analyst / Application Developer / Database Developer / Data Modeler / Data Analyst / Data Governance / ETL, Quality Assurance, Testing and BI Consultant in client-server and mainframe applications with an excellent delivery record of projects & system support

Application Development experience with full understanding of SDLC including Data Architect - logical / physical data modeling, development of strategy, gather functional and business requirements, analysis, coding and developing, maintenance and enhancements

Experience in Oracle application and database design, development, configuration, implementation and testing, creating and optimizing all database objects included materialized views, stored packages / procedure and functions, database triggers, synonyms, sequence, object type, user profile and roles

Over 7+ years of work experience in Business Analysis and Data Analysis in Financial industry. Specialized in Implementation of Financial Tools, Data Governance, Data Lineage, Data Quality, Project Financials, Budgets, Forecasts, Costs, Benefits, Requirements management, user acceptance testing, Change Management, Reporting and SQL

7+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.

5+ years working with Oracle BI, SQL including intermediate to advanced knowledge on DML / DDL

Experience in creating Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules

Experience with data management technologies and tools such as MDM and Informatica

Experience in Oracle ERP R12 Implementation (AP, AR, GL, CM) and Seibel Case Management, Oracle SCM (Procurement, Inventory, Order Management, Business Intelligence)

Experience in SAP HCM Implementation (OM,PY,PA,EN,TM)

Experience in Oracle XML Publisher, Oracle OBIEE 11g/12c, OBIEE RPD modeling, OBIEE front end, security and leverage advanced DB functions, Oracle Application Framework, Oracle Data integrator (ODI)

Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN

Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio, IDEF1X methodology

Extensive knowledge and experience of Extraction, Transformation and Loading (ETL) environments database development methodologies, programming languages, developed highly complex SQL scripts, supported analysis and transformation of data, database extraction and data cleansing

Wrote programs, debugged and executed unit testing, system testing, integration and regression testing

Knowledge and understanding of web services (SOAP, XML, WSDL, SQL) and experience designing interfaces between application systems, Oracle API’s and Concurrent programs

Experience and Expertise includes Business Requirement Gathering, Requirement Mapping, GAP analysis, Functional architecture, Solution Design, Unit Testing, UAT and User Training

Technical expertise in Oracle DB, DB2, COBOL, QMF, VSAM and debugging tools

Experience with ASG tech tool, data intelligence ASG Rochade, Becubic, Scanning, Data Lineage

Strong analytical, problem-solving, time management and communication skills, Organized, self-motivated, detail-oriented and a good team player and Continuously learning and updating my skills to keep up with changing IT technology

Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision

TECHNICAL SKILLS

Systems Windows NT/2000/XP/VISTA/7, VAX4200, VAX/VMS, UNIX, Linux, Apache, HSF,

Languages T-SQL, PL/SQL, VB6, ASP.Net, VB.Net, C#, COBOL, WBF, WCF, XML, XSL, HTML

Networking Novell, NFS, Ethernet, Cisco CCNA, VPN, LAN, SOAP

Applications Oracle EBS R12, Oracle/PLSQL, Oracle/DBA, MS Windows, MS Office, Crystal Reports, MS Visio, MS Visual Studio, SSIS, SSRS, MS Project, UML, HP QC, Oracle BI Publisher, Seibel Case Management, Oracle XML Publisher, Seibel Tools, IBM Clearcase, Java Scripts, SSH, FTP, CASE Tools, SAP BI, SAP ECC 6.0, OBIEE g11/12C, ODI 12c, MsSQL, NoSQL, XML, ERwin, Toad, Jira, DB2, OAF, Informatica Power Center, COBOL, DB2, VSAM, QMF, ASG Rochade, ASG Becubic Data Lineage Tools, AG Data Intelligence Tools (DI)

PROFESSIONAL EXPERIENCE

Senior Data Engineer Jan 2022 – Present

Knights of Columbus, New Haven, Connecticut, USA

Complete full life cycle of ETL/ELT development to address business needs or resolve issues including design, mappings, data transformations, scheduling and testing

Translate data movement requirements into technical ETL design

Develop ETL/ELT workflows and mappings to extract, transform, and load data into target environments

Develop data extraction and transmissions to external vendors

Develop test plans and perform unit testing

Create supporting documentation for new ETL processes

Work closely with data analysts to gain understanding of business processes and corporate data

Determine impacts to data warehouse structures and information flows due to changes in business or technical requirements

Contribute to architectural decisions to support business processes

Provide production support for data solutions

Complete root cause analysis and contribute to remediation planning and implementation

Perform data quality analysis, report data quality issues and propose solutions for data quality management, Learn and expand upon internal controls and participate in customer support

Perform design and code reviews in support of organizational standards

Mentor less experienced team members

Prepare effort estimation including researching and estimating costs of software development, unit testing, provide estimates for upgrades of vendor packages upgrades and integration with existing systems

Data Management Consultant Dec 2020 – Dec 2021

BNY MELLON – Bank of New York, New York, USA

Responsible for determining systems requirements for new or modified database application programs, creates the system specifications and is responsible for the development, testing and implementation of efficient, cost effective application solutions

Work in conjunction with the data architect/modeller on the data warehouse reporting solution

Writing and tuning SQL queries, view, stored procedures, and function

Interpreting data models and developing database structures; using standard diagramming techniques to design and develop computer data models; and implementing and troubleshooting programming changes and modifications

Work within a team and lead database efforts and to document customer requirements, translate into technical designs, and explain technical issues clearly and accurately to both technical and nontechnical audiences

Convey technical information on scanners (software) to data custodians

Prepares deliverables such as source to target mappings and transformation rules documentation

Design/Analyse of Enterprise Data Analytics dashboards, visualization for various line of businesses

Defines and captures metadata and rules associated with ETL processes in Informatica and ThoughtSpot

Design and develop the technical/functional specification for ETL development and implement using Informatica. Analyze dependencies for workflow for various ETL processes, handle exception, and maintain logs

Manage artifacts - versions, including software code, documents, design models, and even the directory structure itself

Created and maintain Data Model in repository for Dev environment, create migration and data mapping databases

Work on ASG Data Intelligence Tool (DI) to provide data lineage functionality

Sr. Data Consultant /Business Intelligence (BI) Developer Mar 2020 – July 2020

Express Scripts Canada (ESI) – Mississauga, Canada

Participated in the design of analytics solutions supporting at an Enterprise level

Assisted in planning reporting projects to include but not limited to requirements analysis, project scoping, data analysis, and business logic transformation

Collaborated with BI System Analyst to create required reports using reporting tools like OBIEE, BI Publisher; profile data necessary to meet reporting requirements

Designed, develop, and support visualization tools including but not limited to dashboards, scorecards, operational and scheduled reports, ad-hoc queries, and decision support

Performed detailed data analysis, developing online analyst processing (OLAP) cubes for predictive analysis and forecasting

Designed and administration of Oracle Business Intelligence (OBI) repository

Oracle database development using SQL, Oracle PL/SQL and/or SQL Server T-SQL

Work closely with Data Architect for database schema changes

Ensured high levels BI Systems availability through systems administration/support and change management.

Communicated task status, roadblocks, and critical matters to management promptly

Creating / Writing and maintaining the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure, constraints, and roles

Using DDL and DML for writing triggers, stored procedures, and data manipulation

Worked closely with end users to designing reports and dashboards, suggesting better ways of reporting in OBIEE so that the required information is visualized by end users and drive the design and build of visualizations and analytics

Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services

Prepared and executed comprehensive test plans for system and quality testing of reports which included writing PL/SQL queries to check and compare the quality of data provided by report

Wrote several Packages /stored procedures/Functions/triggers in Oracle (PL/SQL) for the enterprise portal application and data merge

Worked with database administrators to optimize report performance through database tuning

Developed ELT and ETL Mapping in Oracle Data Integrator, Implemented SCD type1 and SCD type2, and Changed Data Capture (CDC)

Liaise with business subject matter experts in analyzing business requirements and translating them into detailed conceptual data models, process models, logical models, physical models and schema development in the database

Sr. Data Modeller / BI /DW September 2019 – Jan 2020

CN – Railway – Montreal

Interacted with users to gather business requirements for BI projects and enhancements

Designed data architecture for BI projects and enhancements

Created EDW business data models and business rules for all EDW environments

Created data definitions, models and access views and BO Universe Structures

Definition of data synchronization and acquisition rules, data quality and validation rules

Defined Extract/Transform/Load (ETL) processes

Ensured data access optimization

Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment

Developed working documents to support findings and assign specific tasks and Data Profiling

Supplied high level and detail estimates for enhancements/projects

Provided data modeling services to BI Development & Support Team

Worked on Business Objects Universe Design & Report Construction, Data dimensional and relational modeling techniques and tools (Erwin)

Collaborated with enterprise data warehouse, data governance, and business teams on data quality issues, as well as architecture or structure of data repositories

Analyzed the Data Lineage from source systems including DB2, Oracle, SAP systems and legacy applications to Data Warehouse

Working with the enterprise data governance team to incorporate business unit inventories as part of the enterprise data catalog and Business Information Model

Support teams and processes with large data analysis using advance Excel features (Pivot tables, Macros etc.)

Ensured reported issues were resolved more quickly by documenting and tracking application issues, using Agile Methodology, as well as by participating in scrum meetings, which assisted with prioritization of issues

Senior Business Systems Analyst / ETL / BI / DW March 2018 – July 2019

McKesson Canada – Toronto

Worked with customers and Stakeholders in gathering business requirements for data migration needs in Specialty Technology Solutions Project

Worked across multiple functional projects to understand data usage and implications for data migration

Developed PL/SQL triggers and master tables for automatic creation of primary keys, created stored procedures, functions and pancakes for moving the data from staging area to data mart

Involved in the continuous enhancement and fixing of production problems. Generated server PL/SQL scripts for data manipulation and validations and materialized views for remote instances

Assisted in designing, planning and managing the data migration process, manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy

Wrote and deployed stand-alone C# web application with SQL Server backend for attachments patient services applications using data from legacy data source extraction, translation and insertion from flat to the new patient solution

Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements

Understand the data structures and tables inherent in the new PSP system and be able to map legacy data to the new structure using mapping tools, Excel and intermediate databases

Ensuring that ETL processes run as scheduled and performance tuning ETL jobs as required

Developed and Optimized Stored Procedures and Functions to perform Work with technical & business staff to develop field level data mappings to aid in data migration and to build interfaces

Creating & maintaining data dictionaries for different areas of data

Demonstrated a strong grasp of database architecture including SQL server and database access tools

Created and maintain Data Model in repository for Dev environment, create migration and data mapping databases

Synchronized model with data base and correct discrepancies if any in DDL and generate SQLs according to new model

Adhering to standards in all work products and participate in the refinement of those standards to improve quality and productivity

Documenting procedures to facilitate cross team support of ongoing operational interfaces and regular data patches

Understand and communicate technical issues and solutions to the business

Worked with business users to clarify data requirements and analyze and document scope of work for data conversion and cleansing projects

Developed and run validation processes to ensure conversion accuracy and quality

Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* Plus

Worked on support tickets of SPM using JIRA, resolve and follow up with functional and technical teams

Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data and warehouse systems

Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job

Participated in the Sprint Planning sessions, daily stand-ups, sprint demos and sprint retrospective sessions

Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks

Used Agile methodology to created and maintained project plans, project tracking, log of changes, issues, action items, and decisions

Facilitated daily scrum sessions and status updates to client management

Managed dependencies between business analysts, laboratory development, and operational development teams

Senior Systems Analyst / Information Systems Officer Oct 2013 – Dec 2017

United Nations Secretariat - Field Personnel Division - Information Management Unit - New York, USA

Umoja Project (SAP HCM, SAP BI, Inspira, IMIS, Necleus, OBIEE, ODI, ETL)

Provided support of Umoja SAP HR modules Maintain and stabilize HR modules in SAP system : Payroll, Time, OM, PA, Benefit, Training & Event, Appraisal, ESS/MSS Create/Maintain Payroll Schema

Supported and worked with the Umoja SAP HCM project team in Data Conversion, QA, Master Data Maintenance, Deployment, BI and ETL, Testing of HCM module

Testing & Creation of data the Enterprise Structure (Personnel areas, and Personnel sub areas), the Personnel Structure (Employee groups, Employee sub groups, Payroll Accounting Areas), and the Organizational Structure (Organization Units, Positions, Jobs)

Worked on HR data marts and transactional systems, this involved analyzing requirements (user stories), identifying transactional database / data marts, validating data mart design and ETL mappings logic, creating mappings from data mart for the report, creating repository (RPD), reports and dashboard, testing those reports, unit testing, regression testing and documentation

Maintained Employee Master Data using transaction codes PA30, PA40 to retest new defects upon vendor requirement/changes

Involved in the Oracle OBIEE BI project, creating queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience using Oracle OBIEE g11

Designed customized interactive dashboards in OBIEE and SAP BI tools as BI power user applying analysis, drill down, guided navigation, prompts, filters, and variables

Designed, build and deploy data models optimized for business intelligence and analytics

Developed a Conceptual model using Erwin/Toad based on requirements analysis

Developed normalized Logical and Physical database models to design OLTP system for insurance applications

Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1

Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model

Coordinated data collection activities to support data migration / conversion of legacy data into Umoja. Acts as a liaison between the internal Umoja teams and the Deployment Cluster Sites

Developed data sets using SQL for quantitative and qualitative reports for both internal and external clients; standardizes Queries for reuse within the unit

Participated in the IMU peer review process to ensure accuracy, quality and consistency in IMU provided reports

Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP

Developed global data strategy for Enterprise Data Management, including data architecture, Master Data Management, EDW, data modeling standards, meta data management and Data Governance

Modeled and designed the database using Agile development method. Created and documented logical, physical and dimensional data models (data warehouse, data model)

As part of Data Quality analysis: Traced Data Lineage of data elements to be used in the new system, worked with the data steward and data owners in creating metadata, Lineage, Data Quality rules and guidelines

Extensively used ODI (Oracle Data Integrator) ELT tool to create Data ware Housing OLAP, ODI Designer, Topology, Operator and ODI Tools, Performance Tuning in Oracle Data Integrator

Worked and have solid understanding with Oracle, MSSQL and NoSQL databases including data structure design, Data Modeling

UNOPS /GPSO - Development Group – Umoja Project

Worked with business users to clarify data requirements and analyze and document scope of work for data conversion and data cleansing projects

Designed and developed custom made business intelligence solution according to the plan using BI applications

Built interactive dashboards with drill down effect through Oracle BI Answer using OBIEE 11g

Developed and design complex data structures, ad hoc queries, reports and analytics, stored procedures, functions, triggers

Interfaced with Umoja, Missions, OAH’s and HQ in order to facilitate data gathering and cleansing of data from legacy systems (IMIS, SUN, Progen etc) and provided guidance to missions and OAHs regarding data conversion

Converted data from multiple data sources including text files, MS Excel, MS SQL, MS Access, Lotus Notes and others as and when required

Designed ETL to load data from data warehouse, Oracle, MySQL, SQL Server to meet business needs

Involved in writing test scripts and functions in Test Script Language using QTP for automated testing

Developed and ran validation processes to ensure conversion accuracy and quality

Analyzed data coming from different sources for data conflicts resolution in order to maintain and enhance records within master data

Interacted with stakeholders in order to address issues and processes that will improve master data integrity

Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions

Created and maintained the Data Model repository as per company standards, data integration and migration processes as required by Umoja technical teams

Ran period reports for business stakeholders and Umoja management to show progress of efforts

Interfaced with Subject Matter Experts in pertinent business users and Umoja to review data conversion and cleansing requirements

Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center

Tested ETL jobs as per business rules using ETL design document

Developed data sets using SQL for quantitative and qualitative reports for both internal and external clients; standardizes queries for reuse within the unit, designs reporting templates using MS Excel and Crystal Reports

Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets and create scripts using T-SQL and automate SSIS package execution

Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems

Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPALIN PLAN, SQL&TRACE, TKPROF and AUTOTRACE

Designed and developed mappings with required transformations and load the data into the warehouse server for analysis using Informatica Power Center 9, IDE (Informatica Data Explorer), IDQ (Informatica Data Quality)

Migrated SQl server database into MySQL using Data Transformation Services, creation of triggers for audit log of database, scheduled both hot and cold backups using MySQL dump and tuning databases by partitioning tables

Senior Systems Analyst / Oracle EBS R12 Functional Consultant Oct 2010 – July 2013

OPS - Ministry of Community and Social Services / Ministry of Revenue / Government Services – Toronto, Canada

FRO – Family Responsibility Case Management Systems (FCMS) Project

Worked as Oracle EBS ERP version R12 technical consultant in developing, implementing and maintaining of FRO ERP Financial System and Case Management System components

Conducted programming, coded, fixed and enhanced complex programming modules based on the functional specification documents (ISD’s) using the development tools and languages (SQL, PL/SQL, Oracle Forms, Oracle Reports, Oracle XML Publisher, Concurrent Programs, API’s, Alerts, Oracle Application Object Library, Workflow, Oracle Framework Architecture, Seibel Tools), version control tools (IBM Clearcase), and testing tools (HP QC)

Extracted data, designed, developed and execute SQL scripts on various databases, like IMS, SQL and Oracle to produce data sets for analysis

Analyzed, identified tested and implemented data management techniques on required data elements and assist in data migration

Implemented process for Extraction, Transformation and loading (ETL) using Oracle PL/SQL, SQL Loader, SQL Server, MS Access, MS Excel, Oracle XML Publisher, XML, XSD and Unix shell scripting

Worked with functional team to Implemented complete data migration mapping between Legacy data and Oracle AP / AR and GL application

Updated and tested oracle packages and procedures, and implementing successful interface between Siebel and EBS

Implemented data migration mapping between Legacy data, customize Oracle objects for data load using Oracle API’s, PL/SQL, SQL*Loader, Oracle Developer Suite 10g, SQL*Plus, Workflow Builder

Provided Data Governance solution to an integrated, comprehensive metadata repository, providing definitions, business rules, defaulting rules, data lineage, data governance workflow, etc

Analyzed, Designed, Built and Test Reports, Dashboards and other BI objects of financial and case management data using Oracle OBIEE 11g, Oracle XML publisher and Oracle EBS R12 concurrent manager

OntTax Project, Supply Chain Management (Oracle SCM), Oracle EBS R12

Designed, Developed, Tested and Implemented a variety of business application solutions used by the Ministry of Revenue/ Government Services client

Worked across three projects using OntTax platform: Sales Tax Reform, MOST Wind Down, and working with QA team resolving problem tickets

Created various reports to meet client requirements (pivotal, chart, tabular, drill down, etc.) through global and local filters

Created, enhanced, upgraded, supported, and maintained custom mission critical business applications by providing subject matter expertise regarding capabilities of Oracle Applications, Supply Chain Planning, Order to Cash, Procurement, Order Management, Inventory and Business Intelligence

Designed, developed and architected custom applications/interfaces/web services using Oracle Development technologies including OAF, ADF, PL SQL etc

Provided strong technical and functional leadership during all phases of life cycle system development

Prepared and executed the test scripts, unit testing and User Acceptance Testing (UATs)

Logged, managed and resolved SR’s with Oracle Support

Developed Test Scripts using Functional Requirement Documents. Test scenarios are created for Positive, Negative, Boundary cases, etc. Performed all types of testing on workflows and server software

Developed global strategy for Enterprise Data Management, including data architecture, Master Data Management, EDW, data modeling standards, Meta data management, and Data Governance, facilitating data discovery sessions with key subject matter experts

Created reports and report templates, design, code, extract, manipulate, and load into a data model/data warehouse

United Nations Relief and Works Agency – Jerusalem May 2003 – June 2010

Management Information Systems Coordinator / Systems Analyst / Application Developer lead

Credit Management Information System Project

Responsible for designing the solution and leading a team to Analyse, Design, Develop, Support, Implement and Manage live Credit Management Information System for Microfinance and Microenterprise business and financial applications, using structured methodologies for the design, development and implementation of applications

Provided a full automated financial and management information system using the latest software and hardware techniques includes the full life cycle of a software development, analyzing business processes, preparing user requirements documentation in addition to conducting a training workshops and sessions

Created and designed technical documentation on user and business requirements, systems hardware and software requirements, functional design, data base model, data dictionary, detailed program specifications

Created and executed automated software test plans, cases and scripts to uncover, identify and document software problems and their causes

Involved in UAT testing in UAT environment, Prepared UAT test cases and testing estimates

Specified the system architecture and design utilizing the UML Analysis and Design Models and using CASE tools

Created and maintained data integration and migration processes and performed data conversion from multiple data sources such as text files, CSV, MS Excel, and MS Access or XML format

Prepared cost estimates and project budget, reporting on budget and programme performance and recruitment of staff

Grant Management Information System Project

Developed Grant Management Information System project end-to-end based on international monetary fund, statistical reports, monitoring and control reports

Conduct testing and quality assurance of software, information systems, products and services delivered from local or from offshore development

Provided assistance in identifying training needs, development of training plans and programs and deal with some logistical issues relating to training, seminars, round tables etc

Leaded the development team in system design, writing code, testing and system support

Provided technical support, maintenance of database structures and associated applications, which includes Installation, configuration, upgrades, development of databases,

Contact this candidate