Experience

The Canada Life Insurance Company of Canada

• Canada
• Insurance
• 1 - 100 Employee

• Sr. SAP Business Intelligence Developer

  • Aug 2019 - Present

  •Created Projects, SAP HANA DB Modules/Database artifacts, and SAP HANA service connections while SAP HANA XS Advanced and SAP Web IDE for SAP HANA. •Created Roles, Grants from cross HDI/Service access, created Synonyms, Synonymsconfig, SQL Views, Table types, Functions, Procedures, dimensions, and Calculation Views using SAP Web IDE. •Worked closely with project managers for Yield Curve Service, Unit of Account, and IFRS17 projects planning and requirement gathering. •Planned, designed, developed, and published reports, Dashboard and Datasets using MS Power BI. •Created data models using MS Power BI. •Designed, developed and published dashboard for YCS and IFRS17 Dashboard using SAP HANA, BOBJ 4.2 and SAP Lumira Designer 2.1. •Gathered requirements, planned, designed and developed YCS and IFRS17 reports using SAP HANA, HANA Views, Web IDE, HANA Studio and WEBI. •Created dashboards using SAP Cloud Analytics •Gathered requirements, designed solutions, helped project manager to create Kanban Board to manage and follow agile iterations using Jira. •Configured/Implemented BI Security. Created users, groups and ACL in BOBJ as well as roles and authorizations in SAP BW •Designed/Created ETL Jobs, Data Models, and universes using BODS, IDT, UDT. •Created BICS, HANA http, HANA 2.0 connections for dashboards •Created, updated packages, HANA Calculation views and Analytical views using HANA Studio •Promoted users, groups, security, reports and Dashboard using Promotion Management tool; created workbench/customizing requests and transported BW objects to production •Created logos and icons for dashboards, reports using Adobe Photoshop Show less



Toronto District School Board

• Canada
• Primary and Secondary Education
• 700 & Above Employee

• Sr. SAP Business Intelligence Developer

  • Jul 2019 - Aug 2019

  •Analyzed, created BW data model for spend reporting. Created DSO’s, InfoSet, MultiProvider and Bex queries. •Created Dashboard for spend reporting using SAP Lumira Designer. •Developed Data Sources, InfoObjects, DSO to load master and transactional data for trust and scholarship statement and CRM PSS Project, •Created requirement and solution architect documents for all projects •Created prototype while using Crystal Reports & Crystal Report for enterprise to display attachments from DB •Meet with steak holders to gather requirements and share the prototypes. •Provided training for “SAP Analysis for Office” to team members •Created WEBI reports for trust and scholarship statement. •Developed web service while using Query as Web Service for distribution list •Created publications for reports dynamically distribution to school principals •Created and managed BOBJ and BW transports and provided recommendations for security implementations Show less



The Great West Life

• Sr. SAP Business Intelligence Developer

  • Aug 2017 - Jul 2019

  •Planed, designed, developed, published and transported LICAT (Life Insurance Capital Adequacy Test) Dashboard while using SAP BW, BOBJ 4.2 and SAP Design Studio •Designed, developed and published dashboard for LICAT data Accuracy using SAP Design Studio •Gathered requirements, planed, designed and developed AML (Anti Money Laundering), MC (Market Conduct)-Wealth Transaction trending, AML data explore and MC data explorer dashboard using Lumira Designer 2.1 and HANA views •Gathered requirements, designed solutions, helped project manager to create Kanban Board to manage and follow agile iterations while using Jira. •Configured/Implemented BI Security. Created users, groups and ACL in BOBJ as well as roles and authorizations in SAP BW •Created prototypes for dashboard and reports using Pencil Project. •Created BICS, HANA http, HANA 2.0 connections for dashboards •Created, updated packages, HANA Calculation views and Analytical views using HANA Studio •Created DataSources, Info packages, InfoArea, InfoObjects, DSO’s, Transformations, and DTP’s, Cubes, InfoSets, MultiProvider and BEx queries •Created Direct access DataSource, DTP and created virtual provider (Cube) to read data directly •Created DataSource in 7 different environments to gather users, roles and authorization data and brought into SAP BW for reporting •Created data model in BW for Users and Roles data storages and reporting •Developed Analysis Workbooks using SAP Analysis for office 2.7 SP5 •Created user security, Currency exchange reports using Web Intelligence Rich Client and BI launch pad and published to BI Platform •Created fiori tiles for FioriLaunchpad in SAP BIS (Business Integrity Screening) to access dashboard directly •Provided training and training documents to end users •Promoted users, groups, security, reports and Dashboard using Promotion Management tool; Created workbench/customizing requests and transported BW objects to production Show less



SaskPower

• Canada
• Utilities
• 700 & Above Employee

• Sr. BI/BOBJ Specialist (Technical team lead)

  • Nov 2012 - Jun 2017

  • Planed, designed, developed, published and transported Asset Management Dashboard while using SAP BW, BOBJ 4.2 and SAP Design Studio • Gathered requirements, designed solutions, distributed tasks and managed/hired team of 5-8 • Configured/Implemented BI Mobile Server and integrate with SMP (SAP Mobile Platform) • Created, updated WEBI reports while using Web Intelligence/Rich client in BI 4.0/4.1/4.2 environment • Created, Updated dashboards while using Xcelsius/Dashboard 4.0/4.1/4.2 and design studio • Created WEBI reports, Dashboards for Mobiles; published reports and dashboards on BI Mobile Server • Created visualizations and storyboards using SAP Lumira. • Provided training to end users for SAP Lumira, SAP Design Studio and WEBI • Used universe design tool and information design tool to create/update Universes documents ,Crystal Reports, Analysis Workspaces, and BI Workspaces • Created Jobs, Workflows, Data flows, Datastores with configurations, Transformations (data quality, platform), file format , scripts and custom functions • Created, Transported, Managed and scheduled BODS batch jobs. Used Data Service designer and Management Console to manage jobs • Managed securities for SAP Data Services using CMC and Management Console for repositories • Leads the HANA initialization/implementation project • Worked with BI and technical team to identify the reports and BW data models to integrate with native HANA and BW on HANA • Prepared technical/design and solution architect documents ensuring proper IT standards are followed • Created business objects development guidelines standard document and provided end users training • Developed WEBI reports and dashboards templates • Created test plans and test labs in HPQC for unit, regression and user acceptance testing • Created BEx Queries, InfoProvider, Cubes, DSO, MultiProviders and InfoObjects and custom extractors in SAP BW/BI Show less



RIM

• Poland
• Administrative and Support Services
• 1 - 100 Employee

• Business intelligence Analyst

  • Nov 2010 - Aug 2012

  •Designed, developed and distributed BOBJ Universes on XI R2 and R3.1 environment•Managed, Developed, designed and distributed Universes, Web Intelligence (WEBI) documents and Crystal Reports•Produced and distributed SAP BW/BI queries, workbooks and Web application while using BEx Query designer, BEx Analyzer, and Web Application Designer.•Integrated Xcelsius dashboards with Crystal Reports•Worked extensively on Designer, Web Intelligence (WEBI), Crystal reports, Central Management Console (CMC) and InfoView.•Extracted/Integrated data from various sources and created advanced/complex dashboards using Qlikview script editor and visualizations•Implemented Star schema & snow flake schema. Developed Linked Tables, Concatenation, different types of sheet objects like List boxes, Buttons, Multibox and solved the loops issues using QlikView•Created different types of reports like Master/Detail, Sub reports, Cross Tab and Chart•Created, managed and scheduled dashboards while using Xcelsius, QlikView and Crystal Reports•Scheduled/automated documents and reports to make them available online using InfoView/LiveLink•Wrote SQL scripts to create Reports, Tables, External Tables, Views, Materialized Views, Procedures and directories. Loaded data from files into Oracle (ETL) and created jobs to automate the process.•Created data model while using Toad Data Modeller•Analyzed data and performed business analysis, managed document versioning using perforce•Gathered business requirements from stakeholders and analyzed data to prepare Universes, WEBI/Crystal reports, and Xcelsius/QlikView dashboards•Designed and developed Wiki Confluence portal to consolidate the information for Executives•Developed Ms Access database/application to manage reporting data, created forms, queries and reports•Complied with project standards and methodology set by the company. Prepared design/technical documents ensuring proper IT standards are followed Show less

• Marketing Intelligence Analyst

  • Jan 2010 - Nov 2010

  •Designed and developed marketing intelligence reports while using WEBI and Crystal Reports •Scheduled and automated WEBI/Crystal Reports to share the information with teams while using SAP InfoView Business Objects Enterprise XI R2•Designed, created, organized and distributed Universes, Web Intelligence documents and Crystal Reports•Analyzed end user interaction requirements, created, managed, scheduled reports while using SAP Business Objects Enterprise Central Management Console•Used SAP Business Objects Enterprise Central Management Console to manage, create the security and user access right•Exported and Imported documents to and from Central Management Server•Analyzed data and performed business analysis•Used Oracle 11g and SQL Developer to develop Marketing Intelligence reports •Worked with business to gather business requirements and analyzed data to prepare the reports•Used LiveLink Enterprise Content Management System to manage, automate the documents and reports, to make them available online•Provided system support to end users to make sure the business standards•Documented system information, user guide and server upload processes Show less



RBC

• France
• Design Services
• 1 - 100 Employee

• Enterprise BI Analyst (Technical System Analyst)

  • Apr 2009 - Dec 2009

  •Designed, developed and maintained integrated enterprise BI applications and data models while using Erwin data modeller •Worked with project management team to gather requirements and specifications and translate to detailed system requirements. •Documented and tracked work flow and changes of applications while using MS Visio •Communicate status and progress to the development team and project manager •Worked with project manager for the development of project activities, cost and schedule while using MS project •Complied with project standards and methodology set by the company. Prepared design documents ensuring proper IT standards are followed •Reviewed and evaluated capabilities and benefits of existing systems and reuse components to develop new application while using Access, SQL Server and VB.Net (wrote Macros, Function and Triggers) •Loaded and configured Open Database Connectivity (ODBC) drivers to access MS SQL Server and MS Access databases •Wrote technical document for requirement analysis such as business requirement and software requirement documents •Used wiki confluence to develop confluence site for wiki entries •Test dashboards and reports in Oracle Business Intelligent environment. Show less



Mite Inc

• United States
• Information Technology & Services

• Software and Database Developer (Contract)

  • Dec 2008 - Apr 2009

  •Analyzed, designed, created and Implemented database table structures to add, drop, or modify columns, indexes, triggers, or constraints •Designed Database while using Erwin •Implemented databases on SQL Server 2008 and Windows Server 2008 environment •Developed E-learning, Learning Management System while using Dreamweaver and Visual Studio •Created presentations and quizzes for online learning contents while using Articulate and Created online surveys while using Zoomerang Online survey tool •Tested Cross-browser and interface •Troubleshoot & debug Internet technologies •Prepared technical documentation, user guides and create online help while using Robohelp •Developed, managed and deployed websites (ASP.net and C#.net) in a Windows environment, including using Internet Information Server. •Provided end user training and support •Installed software packages and hardware, troubleshot and configured networks, Configured Web Server Show less



Raul Mercier Fine Arts

• VBA Programmer and Database Developer

  • Aug 2008 - Apr 2009

  •Analyzed database, designed, developed, tested and supported database application •Designed, developed, tested, and implemented new forms, tables, and reports •Wrote functions, triggers, messages for data entry validation and information •Served as developer/analyst rewrites code for application •Provided development/enhancement support •Analyzed end-user’s requirements, wrote technical specifications for software enhancement, prepared user guides and provided training •Prepared various documentation including process documentation for effective understanding, maintenance and support as per End User Computing procedures •Utilized tables, queries, forms, reports, macros, modules, and VBA Show less



USystems Ltd.

• United Kingdom
• Appliances, Electrical, and Electronics Manufacturing
• 1 - 100 Employee

• Information Technology Technical Support

  • Mar 2006 - Aug 2006

  •Developed and maintained relationship with various vendors for up-gradation of software, hardware and services •Designed and developed Access database, and including queries, functions, macros, forms, and reports •Analyzed existing programs and prepared logic for new systems, convert database from Ms Access 2000 to Ms Access 2003 perform coding, and test/debug •Implemented, managed software’s, websites according to latest technologies and developed new reports •Installed, configured, and troubleshoot network infrastructure and helpdesk services •Installed software’s, supported, network security admin and managed networks of multi environments set-up •Delivered technical and end user support; trained 40 employees •Maintained data, backups, user setting, record checks, generated queries and reports •Established windows, hardware, device drivers, networking software and networking security •Supervised production, provided technical support to paint plant production, managed and controlled stock, quality assurance, maintained plant paint and spray equipment's, that exceeded production by 25% Show less



Arshad Group of Textiles Ltd.

• Software Engineer (Oracle Developer/DBA)

  • Feb 2005 - Aug 2005

  •Developed, administrated, supported Oracle 9i, Microsoft Access and SQL Server based databases •Analyzed, designed, developed and implemented in house Client/Server Oracle based applications •Designed, created reports using Crystal Reports •Scheduled for backups, performance, tuning, and repairing for the databases •Supported and maintained software and hardware; trained 90 members of staff in its use •Installed and configured Oracle Developer as well as database on Windows and Linux operating systems •Evaluated, tested, trained users, provided support, delivered production support and training of the deployment teams to ensure a high level of quality •Managed the company wide Windows and Linux based LAN networks, included installation, troubleshooting, support, and cabling Show less



Sitara Fabrics Ltd.

• Software Engineer (Oracle/VB Developer/DBA)

  • May 2002 - Feb 2005

  •Analyzed, Designed, developed, deployed, and maintained Client/Server Applications using Oracle forms and reports •Designed, created, implemented, maintained Databases Oracle, SQL Server and MS-Access •Evaluated, designed, installed, supported, maintained of all network, desktop hardware and software in a multiple site set-up •Created, maintained and distributed crystal reports •Facilitated network, end-user system set-ups and configurations, e-mail, anti-virus •Provided technical support, training and instruction to team of 60 •Planned for backups, performance, tuning, and maintenance of database •Planed for successful completion of projects within time and budget Show less