Manager Project

Dexter Jagula

*** – ** Kingsbridge Garden Circle w Mississauga, ON w L5R 4B1 w Canada

+1-647-***-**** w ************@*****.*** w www.dexterjagula.com

PROFILESoftware Engineer with over 5 years of IT experience.4 years of business intelligence experience, mostly with IBM Cognos BI spanning all facets of business intelligence: model and cube development, dashboarding, report writing and scheduling, and administration. IBM Cognos 8 architect experience including requirements development and estimates, implementation planning and result validation.2 years of application development experience in object-oriented programming using Java (J2EE) and C#.Experience in SAP Business Objects report development.Extensive experience in client-facing activities through all phases of software development, which some managerial expertise as well.Excellent leadership and team-lead experience, especially within the BI sector.

Very familiar with Agile methodologies and processes.

EDUCATION

M.Sc. Space Studies

September 2007

International Space University

Strasbourg, France

Specialization: Planetary robotic missions and modular-based robotic platforms

B.A.Sc. Software Engineering

May 2006

University of Ottawa

Ottawa, Canada

Specialization: Telecommunications and networking

CertificationsMicrosoft Certification: Microsoft SharePoint 2010 Configuring (2011)

EMPLOYMENT

Technical Consultant

September 2010 – August 2012

Thoughtcorp / EPAM

Toronto, Canada

Since joining Thoughtcorp / EPAM in September 2010, the following is a brief list of indirect work initiatives that have been undertaken:Agile Coach: Part of a volunteer team with the purpose of introducing and instructing company employees on the Agile development methodology through interactive activities and learning sessions.Sports and Social Committee: Part of a volunteer team tasked with organizing social activities for employees in order to improve overall company morale and to encourage inter-company interactions.

January 2012 – June 2012

Client: Tarion (Toronto, Canada)

Project Role: SAP Business Objects Web Intelligence Report DeveloperPerformed the role of Business Objects Report Developer for this projectResponsible of re writing 25+ reports originally written within Desktop Intelligence, which included a few changes to formatting or business logicInterfaced with business users and product owners Worked closely and interfaced extensively with Project Manager, Data Architect, ETL team, Business Analysts and other Report Developers.

Performed the role using SAP Business Objects Web Intelligence 4.0 and SQL.

October 2011 – December 2011

Client: Bell TV (Toronto, Canada)

Project Role: Sr. IBM Cognos BI ConsultantPerformed the role of lead Cognos BI developer for the Programmer Payment System applicationResponsible of creating new reports based on business requirementsCreated appropriate design and business documentation to illustrate the approach for model and reports designData modeling within Cognos Framework Manager based on business reporting requirementsCreated reports within Cognos Report Studio geared toward the business rules and requirements

Performed the role using Cognos BI 8.4 (Framework Manager, Report Studio, Cognos Connection, Cognos Configuration), Oracle 9i/10g, SQL, Microsoft Office Suite, Bugzilla.

August 2011 – September 2011

Role: Automated Build Specialist

This period of non-billable project time consisted of a self-directed and self-initiated task of configuring the first automated build for any application within Bell TV.Implemented automated builds through the Hudson and Jenkins toolsetConfigured Hudson and Jenkins to work alongside source code repository tools like CVS and Microsoft Visual SourceSafe, including triggering the build process upon polling of the source repositoriesDeveloped ANT and batch scripts when necessary to be used within Hudson and Jenkins to aide with proper automated build configurationConfigured Hudson and Jenkins to allow build tagging within the source repository upon the successful build of an application.

February 2011 – July 2011

Client: Bell TV (Toronto, Canada)

Project Role: J2EE Application DeveloperPerformed the role of lead developer on the projectDevelopment responsibilities required the implementation of changes to an existing application within all three architectural tiers (UI, business/web services, database)User-interface (UI) changes in CSS/HTML involved modifying colour schemes, logos, other visual elements, and page layouts, etc.Changes to JavaScript code to reflect business and UI-related changesBusiness logic changes involved modifying Java modules to handle new definitions of XML beans that exist between applicationsDatabase changes to existing stored procedures to reflect changes to the businessCreating database scripts to make changes to existing database tablesInterfacing with third-party business IT systems to ensure validityConfigured build automation for the application using Hudson, running ANT and batch scripts, including integration with a source code repositoryWorked closely and interfaced extensively with Business IT, Business Analyst, QA Lead, and Project Manager.

Performed the role of J2EE Application Developer using Java, HTML, JavaScript, Oracle SQL, XML, Microsoft Office Suite, JIRA.

September 2010 – January 2011

Client: Bell TV (Toronto, Canada)

Project Role: Sr. IBM Cognos BI ConsultantPerformed the role of lead Cognos BI developer for the Programmer Payment System applicationResponsible of re writing 20+ reports originally written within a previous version of Cognos, which included a few changes to formatting or business logicData modeling within Cognos Framework Manager for optimal reporting efficiencyReport development in Cognos Report Studio through SQL interpretation, adhering to specific business requirementsProviding Cognos administrative insight to aide in implementing best practicesResponsibilities included the migration of Cognos Impromptu reports, re-modeling old catalogs, and the development of new reports with Cognos administrative responsibilitiesWorked closely and interfaced extensively with Business IT, Business Analyst, QA Lead, System Architect/Technical Lead, and Project Manager.

Performed the role using Cognos Impromptu 7.x, Cognos BI 8.4 (Framework Manager, Report Studio, Cognos Connection, Cognos Configuration), Oracle 9i/10g, SQL, Microsoft Office Suite, Bugzilla.

Software Project Coordinator

May 2010 – September 2010

GrantStream

Oakville, Canada

Employing requirements engineering processes to liaise with clients in order to gather new project requirements and suggest effective solutionsFacilitating communication among task groups including client, development team and post-production maintenance/supportManaging client expectations, while coordinating the efforts and managing the development teamDeveloping requirements documents for software developers and business cases for prospective projectsCollaborating with the client, the development team, the client services team, and the quality assurance team toward the goal of a successful projectMonitoring the status of development projects and identifying scheduling issues and/or delays when they arise, as well as other issues and assisting in handling them accordingly internally and with the clientClosely analyzing the work performed by the development team, suggesting techniques and approaches, and coordinating the quality assurance efforts.

Performed the role using Microsoft Project, Microsoft Office Suite, Microsoft Visio, AutoTask.

Software Development Consultant

May 2008 – February 2010

KCM Solutions

Toronto, Canada

KCM Solutions is an IT company that provides specialized business intelligence expertise to a variety of clients in different industries all over North America.

January 2010 – February 2010

Client: HSBC (Mettawa, Illinois, USA)

Project Role: Sr. IBM Cognos ConsultantUnderstanding the requirements of the business, both from a functional and aesthetic perspective, and translating that to development within Metric Designer and Metric StudioDetermining how the data will be used in order to calculate and capture the identified key risk indicators (KRIs)Creating appropriate metric types based on each KRI along with the correct roll-up logic within Metric DesignerModifying a Framework Manager model to reflect appropriate data joins as well as to create intermediate values for the calculation of any applicable KRICreating separate reports within Report Studio that act as drill-throughs that are made available to a user through each scorecardCreating proper maintenance protocols for proper metric extraction and data updates through tasks and jobs in Cognos Connection.

Performed the role using IBM Cognos BI 8.4 (Framework Manager, Report Studio, Metric Designer, Metric Studio, Cognos Connection, Cognos Configuration), Microsoft Office Suite.

October 2009 – December 2009

Client: The Mosaic Company (Tampa, Florida, USA)

Project Role: Sr. IBM Cognos ConsultantInstallation and configuration of Cognos 8.4 using 64 bit and 32 bit componentsDrafted a Cognos server installation and configuration document specific to the client’s needs and environmentIdentified and executed test cases/scripts to test and validate the proper installation and configuration of the Cognos serverConfigured the user class capabilities within the Cognos roles to be used for security by the clientCompiled the technical specifications for the dashboard end productConfigured the auditing component to be used within the client’s Cognos environmentsCreated business and presentation layers of SAP query sources within a Framework Manager model as required by the clientUtilized Transformer to bridge SAP queries and Excel sources via the SQL database to model dimensions within a PowerCube in order to create the most suitable package for reporting as requiredModeling the key performance indicators (KPIs) into a dashboard using Report Studio as per the design specifications.

Performed the role using IBM Cognos 8.4 (Framework Manager, Report Studio, Metric Studio, Cognos Connection, Cognos Configuration), Windows Active Directory, IBM Tivoli, SQL Server 2005, Microsoft Internet Information Services, Microsoft Office Suite.

April 2009 – September 2009

Client: The Timken Company (Canton, Ohio, USA)

Project Role: Sr. IBM Cognos Migration Lead/Report DeveloperGathered requirements and identified reporting issues from the end-usersAnalyzed business requirements from the client and developed a plan that led to the project’s technical success and ensured the reporting needs of the end-users were metSuccessfully migrated 200+ Impromptu Web Reports (IWRs) Modifying Framework Manager models to adhere to reporting requirements, while also identifying model enhancements so that proper reporting could take placeCreating complex scheduling, allowing reports to be run based on external events within the business systemDesigned and help set up the security and administration for the Cognos Connection portal, while maintaining current LDAP settings.

Performed the role using IBM Cognos BI 8.3/8.4 (Report Studio, Query Studio, Analysis Studio, Transformer, Cognos Connection), Cognos Impromptu 7.3, Windows Active Directory, PL/SQL, Microsoft Office Suite.

May 2008 – March 2009

Client: Medco Health Solutions (Alpharetta, Georgia, USA)

Project Role: IBM Cognos ArchitectUsed MapInfo to create zone, region and district maps for the different sales forces within Medco. These maps were then used in Report Studio for operational dash boarding purposesCreated a scorecard to allow upper-management to get a bird’s eye view of the system, without going into managerial level detailPrepared reports (standard, customized and ad hoc) that were logically presented and organized appropriately to client groups served. Created daily, weekly, monthly and annual reports as per functional requirementsLinked various related reports to dashboards through drill through links to provide more insight for the businessSecured Cognos 8 contents by applying appropriate authentication & authorization on users groups, roles & capabilities by Cognos Administration Conducted meetings with key business users to collect & analyze requirements and business process information.

Performed the role using IBM Cognos BI 8.3/8.4 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Transformer, Metric Designer, Metric Studio, Cognos Connection), MapInfo, MapBasic, GeoSet Manager, Oracle 10g, Windows Active Directory, Microsoft Office Suite.

Software Application Developer

June 2007 – September 2007

German Aerospace Center (DLR)

Wessling, Germany

Employed at the Robotics and Mechatronics division of DLR, within the planetary robotics groupDeveloped a systems engineering tool for creating a preliminary design for planetary rovers based on inputted mission parameters (i.e. planetary body and required instrumentation)Researched various rover sub-systems, in order to understand how rover system trade-offs are madeDeveloped an unique internal iterative loop to be used within the application to simulate the system trade-off process yielding in the most optimal rover design based on dimensions and power and data requirementsCreated and designed the software application user interface using MATLAB GuideUtilized UI design best practices for the design of the final application user interface Application was coded in MATLAB, utilizing a database interface for MS ExcelConducted unit testing to verify and validate all data.

Performed the role using C# .NET, UML, MATLAB, Microsoft Office Suite.

Quality Assurance/Business Analyst

June 2006 – September 2006

eCom ServCorp

Toronto, Canada

Software testing for online casino client and server applicationsTesting activities included: functional, regression, and automated testingWrote business requirements for new release casino gamesCreated test cases based on previously approved business requirementsCreated test scripts using in-house testing toolsReported and maintained bugs encountered through Bugzilla.

Performed the role using Microsoft Office Suite, WinRunner, LoadRunner, Microsoft Visual SourceSafe, Bugzilla.

TECHNICAL SKILLSLanguages: Java, J2EE, C#, C++, C, HTML, XML, CSS, SQLDesign Languages: UML, SDLTesting Frameworks: JUnit, CUnitDatabases: SQL Server, Oracle 9i/10gDevelopment Environments: Weblogic 8.x, IBM Eclipse, Microsoft Visual Studio .NET, Dev C++, IBM Cognos BI 7.x/8.x, SAP Business ObjectsSoftware: Microsoft Office Suite, MATLAB, IBM DOORS, Microsoft Project, Google SketchUp, Adobe PhotoshopTools: JIRA, Bugzilla, Microsoft Visio, IBM Rational Rose, WinRunner, LoadRunner, CVS, Microsoft Visual SourceSafe, TOAD, SQL Developer, Hudson, JenkinsSystems: Microsoft Windows 9X/NT/2000/XP/Vista/7, Linux, UnixNetworking: LAN, TCP/IP, HTTP, FTPWeb Servers: Microsoft IISLDAP: Windows Active Directory, IBM TivoliConcepts: OOP/A/D, Design patterns, Requirements engineering, Software quality assurance, Software project managementProcesses: Agile, Scrum, Waterfall Model, RUP

OTHER SKILLSKnowledge of requirements engineering and project management concepts, techniques, and approachesVery familiar with modern software engineering processes and practices Knowledgeable in software development practices using an Agile methodologyStrong communication and presentation skillsExcellent people skills – able to interact with colleagues and clients of various levels with ease High level of attention to detailQuick learner with excellent problem-solving skills and a creative mindHard worker with excellent leadership and teamwork skillsExcellent interpersonal and intercultural skillsFluent in English and functionally proficient in French.

Contact this candidate