RAHEEL SAJID

acuimb@r.postjobfree.com

Objective: Looking for a Sr. BI Developer role.

Carrier Highlights:

** ***** ** **/**********

Solution Architect (10 yrs); Data Analyst/Data Architect (15 yrs); BI (10 yrs); Java Developer (10 yrs); Development Lead (10 yrs); Process Improvement (8 yrs); BPR (8 yrs); CRM (4 yrs); SAP Development (7 yrs);

15 years’ expertise financial/insurance industry (P&C 7 yrs; Health 7 yrs; Life 2yr)

4 years in Training/Education/Train the trainer @ Durham College

2 years in direct software on-shore/off-shore development.

1 year Public Service/Government/MGS/Ontario

Technical Skills:

RDBMS: ORACLE-11g, 12c, MYSQL, SQL Server, MS Access, ERWin, HADOOP

Client Tools: SAP BI, BOXI 3 - Universe Design Tool, BOXI 4.1 Information Design Tool, Xcellcious, LiveOffice

Operating Systems: Windows/Solaris/Linux

Visual Tools Visual Basic/.Net, Eclipse, SQL Developer, TOAD

Languages: JAVA, PERL, HTML, JavaScript, PL/SQL, Visual Basic, ColdFusion

Web Technologies: Adobe, JDK, Servlets, JDBC, HTML, XML, Bootstrap

Application Servers: Tomcat Application Server, Web Logic Server

Content Management: Kentico, Calligo DMS, Open Text, JOOMLA

Methodologies: Object Oriented Design (OOD), UML.

Configuration Mgmt: Harvest, Rational Clearcase, Rational Clearquest, and QVCS

Reporting Tools Crystal reports, Oracle Reports, Business Objects, COGNOS, LUMIRA, Tableau

Professional Experience:

(07) Healthcare Insurance Reciprocals of Canada (HIROC), Dec’08 to Mar’16

Sr. Development Consultant (Development Team Lead)

I was responsible for end to end solution development & architecture. Lead design sessions in prototyping new systems to improve processes, operations, and information flow.

Implemented guidelines, processes and tools to generate and maintain deliverables to train new and existing employees.

Created data architecture to sustain enterprise information using Oracle and Oracle tools such as OWB, ODI and Grid Control.

Developed:

oComplex Crystal reports from scratch using Tableau, Crystal Reports, and Business Objects

oCross-Tab reports with multiple grouping summaries

oAnnual financial summary reports with more than 100 fields in the report.

oReports using Command mode

oReports with multiple parameters passing to the main report, and sub reports.

oReports with formulas, and running totals to display summaries in different levels of the report.

oReports using Basic, and Crystal syntax to calculate values, and to manipulate different data types.

oReports using build in functions to manipulate data. (Ex: EvaluateAfter, WhileReadingRecords, Mid, LooksLike etc)

oFormatting reports to fix different printable paper sizes.

oReports output to have different formats. (Ex. CSV, Excel, PDF, XML etc.)

oReviewed all the existing reports and eliminated duplicates, and created reports master list with metrics. (Users, Frequency etc.)

Achievements:

1.Implemented Business Intelligence Road-Map - Reports Development Life Cycle (RDLC)

2.CRM/Client Management – JAVA, Oracle, ColdFusion

3.Surplus Management – JAVA, Oracle, Hibernate, Eclipse, JAVA Excel API (jexcelapi)

4.eApp – Oracle Stored procedures, ColdFusion, Bootstrap, ERWin, Java, Web Services (RESTful), SAP Business Objects, Crystal Reports

5.Reporting and Dashboards – Oracle, SAP BO (Info View), BO Xcelsius (BI Dashboards), APOS bursting manager for BO

6.Security (external) – RFP, AD/LDAP, Oracle, LSC, SSL & TLS, Kerberos

7.Intranet – Multiple applications, ColdFusion, Oracle, PHP, JavaScript

8.Web – Kentico CMS, HTML, JavaScript, PHP, Oracle & MySQL

9.Policy & claim Administration System – Java/J2ee, Test cases, SAP, Vendor supported system, multiple upgrades

10.Online reports portal – SAP Business objects, LaunchWorks, Java Web services (RESTful), AD/LDAP, Oracle

11.Data warehouse – Oracle OWB/ODI, Stored procedures, Strategy, analysis & implementation

12.Training, User Guides & Documentation

(06) St. Joseph’s Health Centre, Aug’08 to Sep’08

Development Consultant

Implements innovative functions on the SJHC Intranet site to facilitate the knowledge management functions of the department (i.e., describing, communicating and facilitating the uptake of best-practices in research, academic support, quality improvement, etc.)

Responsible for implementation new functionality for the SJHC website while maintaining un-interrupted services in the legacy components of the website.

Responsible for developing an implementation strategy that will build on gains and maintain enthusiasm for a rapidly developing intranet site.

Research, develop and maintain the content of web application (intranet and Intranet).

Achievements:

1.Roadmap for static website management using content management servers (CMS).

2.Implemented procedures to distribute C. Difficile facts as required by Government of Ontario.

3.Continued maintenance of Intranet and internet and application

4.Implemented CVS as the repository of code.

5.Inquiry and Innovation database web application (PHP, mySQL)

(05) Ministry of Finance, Oshawa, Ontario, Jun ‘07 to May ‘08

Sr. Business Systems Analyst

Writes Technical Requirements for the failed prototype test conditions for Symposium and IVR applications.

Created end user reports using Crystal reports

Consults with internal stakeholders to define needs or problem areas, and determines scope of investigation required to recommend possible solutions

Contributes to the design & approach phase of the conversion methodology project by constructing moderately process flows

Through iterative development and testing phases, contributes to the resolution of common conversion problems found within data mapping, data regeneration, and data reconciliation

Responsible for quality assurance of output for Interactive Voice Responses (IVR) in order to ensure all aspects of requirements are met

Achievements:

1.Systems design document for Workforce Management Application (JCL, DB2, Web Application).

2.Test plans and scripts for connectivity testing across Ministry hubs (Oshawa, North York, Ottawa and Sudbury) for all four phases of IVR implementation.

3.Test scripts for multiple Nortel’s symposium and Bell’s IVR systems.

4.Conduct system tests to ensure specification conformance for 1-800-ONTAXES (CTI, IVR, ICM, ACD).

5.Created test plan and scripts for web based applications (DB2, Oracle).

(04) EDS Canada Inc., Toronto, Ontario, Sep ‘06 to Jun ‘07

Sr. Business Systems Analyst

Performs data mapping between systems, and builds moderately simple test conditions for prototype testing

Utilizes knowledge of life insurance, product functionality, and data conversions to contribute to and validate the development of a data-generation based conversion methodology

Analyzes data, rules, and events to assist in determining the necessary sequence of events to drive generation of data using BI and ETL techniques.

Executes and qualifies prototype test conditions for more complex programming changes which will have widespread effects

Assess reporting environment then created Best Practices report tailored for client’s environment.

Provide reporting services and best practices in developing reports for Oracle Reports, BI Publisher, Oracle Discoverer and Oracle Discoverer Administrator against Oracle Financials and client’s homegrown systems.

Provide interface development to move and massage data between desperate systems using PL/SQL.

Provide training to clients in the use of Oracle Reporting products.

Achievements:

1.Insurance verticals for Life Insurance management and property and casualty products.

2.Application conversion plan from INGENIUM to new platform independent Radiance policy administration system (WebSphere, Java, XML).

3.24/7 supports to Prudential of Korea.

4.Development of estimates for SCRUM (agile) project plan for Q4 2006

5.BI Reporting tools for custom reports on misc. policy details.

(03) Great West Life, Winnipeg, Manitoba, Aug ‘05 to Feb ‘06 (03)

Sr. Business Systems Analyst

Manage quality assurance manual and automated testing and technical writing to validate JAVA Products.

Matured test beds creating a separate QA domain to better emulate client environments, administered the domain.

Mentored automation resource in QuickTest Professional scripting, constructing scripts intelligently using looping and object wait properties.

Ran projects using MS Project, documenting test cases in TestDirector, mapping tests to functional specification documents.

Work as liaison between business and the development team to rewrite business processes and tools involved in Group Sales Reporting System (Health, Life, P & C).

As a senior analyst on the team I was responsible for understanding, mentoring and implementing the latest IS methodology implemented at GWL.

Implemented a support strategy to implement and smooth out the transition from old system to the new system.

Achievements:

1.Group Sales Reporting Application (agent/agency credit reporting on life and P&C products)

2.Design Documents using Object Oriented Methodology, Use Cases, Sequence diagram, Class diagrams based on J2EE patterns.

3.Application test strategy documents including system test, UAT, test cases based on use cases

4.Team of Analysts to take over support of the application.

5.Reports using Business Intelligence reports and publisher.

(02) allTier Systems, Feb ‘05 to May ‘05 (02)

Sr. Business Systems Analyst

Provided leadership and direction to project teams by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times

Spearheaded the analysis of upgrades to URMS (Utilization Review Management System) to achieve first quarter goals; presented findings and recommendations to upper management for project approval; and followed through with a work plan to meet the project goals

Played an instrumental role in re-architecting URMS application to improve upon performance deficiencies.

Created views for ad hoc reports using SQL and performance tuned when necessary. Predominantly used Oracle PL/SQL for extracts to and from disparate systems. Created and modified Oracle triggers. Worked on a custom subsystem using Oracle Reports and Oracle Forms. Provided extracts for Cognos.

Used the many facilities of Toad to work with Oracle objects

Achievements:

1.Upgrades to URMS application

2.Documentation of XML, XSLT system components

3.Oracle Reports and Oracle Forms and extracts for Cognos

(01)Blue Cross Blue Shield of Minnesota, June ‘98 to Jan ’05

Development Lead

Performed a gap analysis of LoadRunner and WebAvalanche working toward the attainment of load and stress testing tools. Installed and configured TestDirector 8.0 with SQL Server 2000.

Implemented defect tracking and resolution processes for QA and Development, fully utilizing TestDirector in the organization for the first time.

Developed test plans, test cases, SQL and WinRunner test scripts. Performed automated and manual testing of Groups and Benefits department back-end procedures, and front-end applications based upon the Java Web Start run-time environment, while documenting the process.

Performed TestDirector server configuration enhancements, and general maintenance, and documented the maintenance process.

Upgraded twenty legacy TestDirector projects to version 7.2. Developed WinRunner and LoadRunner test scripts for Formulary and Authentication Web based applications and analyzed test results.

Designed and programmed Benefit Sets application (Visual Basic, JSP, DB2, COGNOS, Solaris, MQ Series, BI reports, ETL) to process and replicate 1000 + groups to back end legacy system

General Oracle work that includes Oracle Reports 6i, Oracle Forms 6i, Oracle Forms, Korn shell scripts, Oracle Discoverer, interfaces, conversion, triggers, Oracle Alerts, Oracle applications 11i setting flex fields, PL/SQL, TOAD, programming, performance tuning and reporting. Performed modifications and reporting for a transportation software system.

Achievements:

1.Care Support Co-op application (Billing, Extracts)

2.State Health Plan changes to entire Benefits Management System as mandated by the state of Minnesota, USA

3.Benefits integration to Claims systems (JAVA, VB, DB2, ORACLE, SourceSafe, CVS)

4.Application inventory and documentation (PC Docs)

5.Brought group setup time from 2+ weeks to less than 30 minutes

6.Built test automation for the Client Operational Linking Tool (COLT) and the Client Management Tool (CMT) (Websphere, WebLogic)

Education:

2002 - Masters of Software Systems (MS), University of St. Thomas, St. Paul, Minnesota, USA

1998 - Master of Business Administration (MBA), Saint Cloud State University, St. Cloud Minnesota, USA

1996 - Bachelor in Economic and Finance (BS), Central Missouri State University, Warrensburg, Missouri, USA.

Other Experience:

(08) Adjunct Faculty - Distance Education at Durham College, Aug’11 to Present

Deliver instruction on technology integration on key topics.

Develop educational technology curriculum for delivery of on-line coursework.

Research new and innovative applications and theories on technology.

Inspire students to integrate technology into daily classroom activities.

Restructure student attitudes regarding purpose and use of technology.

Currently teaching the following two courses:

Introduction to SQL

Advanced SQL

Database development using Oracle

Training/Certification:

PMP

HADOOP – Registered & ECD Summer 2016

Reference:

Available upon request

Contact this candidate