Cognos developer

John Ye

*** ****** **. ********, *******, Canada N2V 2V9

226-***-**** *******@*****.***

CAREER OBJECTIVE

Seeking a position as a IBM Cognos TM1 Developer utilizing my creativity and innovative thinking with super strong BI experiences to accomplish the projects and benefit of the company and myself

HIGHLGHTS OF QUALIFICATIONS

4 yrs. super strong Cognos BI skills and experiences in TM1 model design, developing and coding of financial projects, Cognos TM1 Servers administration, performance tuning and TM1 users technical support

7 yrs. expert skills and knowledge in software developing and systems and network technical support

Expertise programming and coding skills in Cognos BI Rule, TI, ETL, Excel Reports, Cognos Reports, SSRS, HTML, Javascript, .Net, C#, ASP.net, VB.net, VBA, XML, SQL query and SQL Store Procedures

Excellent interpersonal and written and verbal communication skills

Strong customer services, problem-solving, multiple tasks, self-motivated and attention to detail skills

Successful working under pressure, fast-paced, eager and quick to learn new technology

PROFESSIONAL EXPERIENCE

Business Intelligence Developer April 2014 - Present

Manulife Financial, Waterloo, Ontario, Canada www.manulife.com

Developed and Implemented Cognos TM1 9.5/10.2 model projects for Finance, Bank, Retail and Advisory departments including MS SQL server 2018/2012 databases, batch, VB script, ETL, MDX, dimensions, Cubes, Rules, TI, chores, SQL query, drill down/up, active form and excel reports

Designed and developed TM1 business models in expense, budget, plan, mutual fund and Seg fund

Administrated and managed Cognos TM1 9.5/10.2 servers on server security, configuration, migration, troubleshooting, monitoring, technical support, data loading, documentation, performance and tuning

Performed Cognos Web portal management on application, updated reports and added link button

Supported and served over 300 TM1 users including presentation, troubleshooting and technical training

Created Cognos TM1 ER Model diagram, work/data flow, code logical chart, process documentations

Implemented new database design, ETL(text/Excel/CSV/XML/DB to DB), SQL query, store procedures, VB code/micro, pivot on data formatting, quality, mapping, insert, convert and transfer from text files, excel files into Cognos TM1 server, output files or MS SQL 2008/2012 databases

Implemented software design patterns and code algorithm into Cognos TM1 models and ETL loading.

Worked as BA on user requirements collection, analysis, design, implement, testing and document

Developed and created SSIS ETL loading, SSAS Multidimensions model, SSRS chart/Tablix reports

Provided new BI technology research alternatives to a problem and recommend for the best solution

John Ye Page 2

Software Developer April 2013 – April 2014

Compusense Inc., Guelph, Ontario, Canada www.compusense.com

Developed and created web and client-server architecture software using MS Visual Studio 2010/2012, C#, ASP.net, HTML, CSS, JavaScript, SQL query, SQL Store Procedures and ADO.net languages

Performed software life cycle, design patterns, 3 tier architecture and MVC models in agile project

Worked on source code control on SVN turtle, MS Team Foundation server and HP ALM defect software

Implemented software testing including Unit, Smoke, Functional, performance, overload, regressive tests

Worked on requirements collection, technical support, new features and functional documentations

Implemented and created code algorithms, refactoring improving software performance and efficiency

Product Development Technician Nov. 2009 – Feb.2013

BlackBerry Ltd., Waterloo, Ontario, Canada www.blackberry.com

Designed and developed application using MS VS 2008, C#, ASP.net, VB.net, ADO.Net, SQL query

Worked on software developing life cycle, 3 Layers, MVC model and design patterns in waterfall projects

Developed code quality controls and code performance monitor for smart phone qualities and defects

Created database, tables, views, SQL query, stored procedures to update, insert and delete data in DB

Implemented user requirements, use case, UML diagram and sequence diagram documentations

Provided technical support, troubleshooting, new technique research and electronic supplier services

Systems Network Specialist March 2006 – July 2008

Schiller networks, Kitchener, Ontario, Canada

Administrated Windows 2000/2003 Servers, MS SQL 2005/2008 Database Servers, Networks, IIS, Exchange 2003 server including, configuration, migration, monitoring, backup, performance and tuning

Created and configured DNS, DHCP, Active Directory, Shared files, Group Policy Object, VPN tunnel and AAA authentication and Crypto in LAN business scale network environments

Provided users support and troubleshooting including PC, printers, fax, windows systems, network, hardware, disk, shared folders, firewall and routers

EDUCATION

Master of Applied Computer Science 2004

Dalhousie University, Halifax, Nova Scotia, Canada

Bachelor of Engineering - Computer Science 1995

Harbin Engineering University, Harbin City, China

References Available Upon Request

Contact this candidate