SKILLS SUMMARY
Programming Languages: Java, C#,C++, SQL, XML, JavaScript, HTML, Lotus @Formula Language, Lotus Script
Web Technologies: J2EE, .NET, ADO .NET, ASP .NET
Application Servers: IBM WebSphere, IBM MQ Series
Databases: DB2, Oracle, MS SQL
Operating Systems: Windows NT/2000/XP/Seven
Other Skills: Cognos 8/10 BI (Query Studio, Report Studio, Framework Manager, Cognos Connection, Cognos Configuration)
Crystal Reports
Lotus Domino Designer, Lotus Notes, Teamstudio,
Microsoft Visual Studio 2003/2005/2008 .NET,
IBM Rational Software Architect,
DBVisualizer,
IBM InfoSphere Data Architect.
Foreign Languages: English Advanced Good operational command of a language in a wide range of real world situations
PROFESSIONAL EXPERIENCE
Data Architect, IBM Cognos BI Architect
Jun 2013 – Present
Integrated Project Planning and Forecasting (IPPF) Blue Harmony [IBM].
The IPPF solution provides a key resource for project managers and partners to help in managing and controlling project financial and non financial information through Project Financial Control (planning, reconciliation and forecasting), Non-financial project assessments and Integration with back end systems. The solution receives data from various IBM systems and presents this to the project manager to enable them to better understand the performance of their project. The objective is to provide project managers and business operations with the set of Cognos reports.
Responsibilities: Data Modeling(star schema design), developing of logical and physical data models. Data analysis.
Designing and implementing new data structures and attributes when appropriate.
Responsible for maintaining Framework Manager Models.
Create and maintain system documentation including report, end user documents.
Responsible for tuning and optimization of the reporting solution and creating of FM models.
Environment: Cognos 8/10 Framework Manager, Cognos 8/10 BI Report Studio, Cognos 8/10 BI Query Studio, DBVisualizer,
IBM InfoSphere Data Architect,IBM DB2, SQL, JavaScript, HTML, CSS.
Project results: Project still up and running.
Cognos 8 BI Data Modeler/Report Developer
Jan 2012 – May 2013
Program Management Portal (PgMP) project [IBM]. PgMP reporting project addresses both functional and performance needs of PgMP reporting by Developing a new data structure, Addition of data from trusted data sources to provide integrated view, Create Cognos reports based on business needs that are currently created manually.
Responsibilities: Developing Cognos 8 BI FM model and Cognos 8/10 reports (crosstabs, lists and complex dashboards).
Responsible for tuning and optimization of the reporting solution and creating of FM models.
Writing technical documentation and user instructions.
Testing.
Environment: Cognos 8/10 Framework Manager, Cognos 8/10 BI Report Studio, Cognos 8/10 BI Query Studio, Cognos 8/10 BI Analysis Studio.
Project results:
The project is on Production.
Cognos 8 BI Data Modeler/Report Developer
Feb 2011 – Dec 2011
Deal Workflow Data Mart (DWDM) project [IBM]. In summary, the DWDM is a centralized reporting and analyzing tool that:
Integrates key O2O databases by using a common data model
Deliver the information in a user-friendly environment
Provides a single point of information (dashboard) for executives and business analysts
Adapts with changing business requirements as the Report Writers (also known as “Brio Power Users”) incorporate new data sources and generate reports as needed by the business.
DWDM is a part of Business Intelligence Central for Services which is hosted within the WW Business Metrics Organization.
Responsibilities: Developing Cognos 8 BI reports (crosstabs, lists and complex dashboards).
Responsible for tuning and optimization of the reporting solution and creating of FM models.
Writing technical documentation and user instructions.
Testing.
Environment: Cognos 8 BI Report Studio, Cognos 8 BI Query Studio, Cognos 8 BI Analysis Studio.
Project results:
The project is on Production.
Cognos 8 BI Data Modeler/Report Developer
Jul 2010 – Jan 2011
GTS Work Force Productivity Automation (WFPA) project [IBM]. A Global Technology Services (GTS) project intended to move work force productivity reporting onto a standard platform and, to the extent possible, establish a common vocabulary for GTS and its sub-brands with respect to WFP metrics and associated dimensions.
Responsibilities: Developing Cognos 8 BI FM model and Cognos 8/10 reports (crosstabs, lists and complex dashboards).
Responsible for tuning and optimization of the reporting solution and creating of FM models.
Writing technical documentation and user instructions.
Testing.
Environment:
Project results:
Cognos 8/10 Framework Manager, Cognos 8/10 BI Report Studio, Cognos 8/10 BI Query Studio, Cognos 8/10 BI Analysis Studio.
The project is on Production.
Cognos 8 BI Data Modeler/Report Developer
Nov 2009 – June 2010
CLD/TSD [IBM]. The main task of the CLD/TSD project are creating of the Technical Services Dashboard that consists of nine distinct screens, each providing a different view of Technical Services data. The filters allow you to customize and view the data in the way most appropriate to you. These filters are available on every page and control all reports and screens simultaneously. Each screen consists of several charts and lists of data.
Responsibilities: Business logic data analyzing, creating Data Models in Cognos 8 BI, reports development, Writing technical documentation and user instructions, Testing reports.
Environment: Cognos 8 BI Framework Manager, Cognos 8 BI Report Studio, Cognos 8 BI Query Studio, IBM Rational Data Architect v7
Project results: The project is on Production.
Cognos 8 BI Data Modeler/Report Developer
Feb 2009 – Oct 2009
RM Application Maintenance. The main task of the RM Application Maintenance project is to integrate Cognos functionality into IBM “Metro” application. Main directions are Resource Tracking Application (static (HC) and dynamic parts), SLMT report (hiring requests life cycle), RPA progress reports (business metrics views). Reports are based on Metro operational database and DT&C database.
Responsibilities: Business logic data analyzing, creating Data Models in Cognos 8 BI, reports development, Writing technical documentation and user instructions, Testing reports.
Environment: Cognos 8 BI Framework Manager, Cognos 8 BI Report Studio, Cognos 8 BI Query Studio, IBM Rational Data Architect v7
Project results: –
EDUCATION and TRAINING
• Gomel State University (GSU), Gomel, Belarus.
