Поругайте пожалуйста резюме - структуру и ваще
Добавлено: 08 апр 2007, 10:45
Адрес
Имя
Цель (пока не придумал, но что-то типа хочу принести много пользы своим опытом консалтиноговой компании - партнеру Cognos.)
Summary:
Over 9 years of experience in the development and support of software for various business applications. Over 5 years of hands-on experience with OLAP/Datawarehouse design using MS Analysis Services and MS SQL Server 2000; Cognos PowerPlay, Cognos ReportNet, Cognos 8 BI. Strong knowledge of the DW architecture, cubes design, MDX, DTS, SQL.
Development tools:
Cognos BI, Cognos EP, MS Analysis Services, MS SQL Server 2000, MS DTS.
Cognos certificates:
Cognos 8 BI Authoring
PowerPlay Series 7 Product Professional
Cognos Planning Analyst Series 7 Product Professional
Cognos Planning Contributor Series 7 Product Professional
Experience:
Consultant, Senior Consultant
XXX Systems Integrator
Moscow, Russia
March 2005 – present
Commercial projects
• As a BI expert lead a team of two consultants in a complex IT project.
Created structure of DWH for needed reports.
Developed a concept of data exchange between several information systems.
• Participated a Cognos EP project for a big retail company selling sportswear and equipment.
Created several libraries (budget of operating expenses, transfer prices, etc).
Created a links between the libraries.
Managed technical issues of working upon Oracle database.
• Participated PowerPlay project for a big media holding company.
Analyzed business requirements
Designed SQL queries to OLTP database (Oracle);
Designed Powercubes in Cognos PowerPlay Transformer;
Presales and POC projects
• Together with trainee created pilot BI solution upon Cognos EP data and transaction database for plan-fact analyses for a big retail company.
Created data mart.
Created SQL scripts for transforming data from Cognos Contributor published data and from OLTP database and for loading it into data mart (Oracle).
Created a FM model with multigrain information. (Fact data more detailed than plan data).
Created Powercubes with both plan and fact data (level of detail of fact data is the same as for plan data).
Created several reports including dashboards and detail reports.
Created drill-throughs between reports and package drill-throughs allowing drilling from Powercube analysis into detailed fact reports.
• Created a Powercube using customer’s data and authoring network of dashboards and detailed reports upon it.
• Participated presale activity for the Central bank of Russia (one of the top 5 Cognos sales in a East Europe).
• Realized number of minor presales.
• Created a Cognos 8 BI demonstration scenario for using by the other consultants.
Trainings and investment projects
• Created the PowerPlay course for users.
• Trained several groups of client’s staff (PowerPlay, PowerPlay Transformer, Cognos 8 BI).
• Trained several new employees groups (BI concept, DW and ETL basis, full line of Cognos BI products)
• Created business case for new employees testing.
• By my own initiative created BI-spam (basis of BI), that most of colleagues found very useful.
Software Engineer
XXX join stock
January 2001 – February 2005
Krasnodar, Russia; Moscow, Russia
• Made a DW aimed to collect sales information from both Moscow and Kiev sales divisions of the company (data is sent to DW in XML format, SQLXML 3.0 allows loading it into the DW).
Analyzed business requirements;
Designed data storage (MS Access);
Designed DTS packages for transforming data from two data stages to data storage;
Designed OLAP cubes;
Trained users to work with ProClarity Desktop client application (later – ProClatity professional);
Tools developed for the project:
A tool to extract various data from OLTP databases and to save it in XML format (1C built-in language, VB 6.0);
A tool to monitor data changes and to save changes as updategrames for SQLXML 3.0 (1C built-in language, VB 6.0);
A tool to load changes to DW
Project information:
In Moscow division data for sales cube loaded from one operative database and four historical databases.
Project based on previous versions of systems for trade and finances analysis (perfect example of spiral development circle).
• Established and adapted trade OLTP system based on 1C (application with built-in programming language like VBA) in Moscow division, provided support for the system
• Established and adapted production OLTP system in Krasnodar division (Factory of cosmetics), provided support for the system.
Senior Software Engineer
XXX, Ltd
January 1998 - January 2001
Krasnodar, Russia
Adapted various 1C applications for business needs in several companies in Krasnodar and region.
Designed and deployed a system for calculation of rent of uninhabited buildings. System is still operated by municipal services of Krasnodar.
Responsibilities:
• Analyzed business requirements of clients;
• Adapted 1C applications for business needs;
• Trained client’s staff
• As a one of the lead specialists participated seminars and product demonstrations.
Education:
BS in Computer Science
Kuban State University, Krasnodar, Russia (1992-1997)
Additional education:
Cognos 8 BI – Authoring and Modeling FastTrack
Completed Microsoft courses:
M2779 Programming a Microsoft SQL server 2005 Database
M2071 Querying Microsoft SQL server 2000 with Transact-SQL
M2073 Programming a Microsoft SQL server 2000 Database
Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000; Implementing Business logic with MDX in Microsoft SQL Server 2000; Populating Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services (intensive complex course, approved by Microsoft).
References: Available upon request.
====
И еще - с первой работы (последней в списке) не получится получить референс - надо ли ее указывать?
Имя
Цель (пока не придумал, но что-то типа хочу принести много пользы своим опытом консалтиноговой компании - партнеру Cognos.)
Summary:
Over 9 years of experience in the development and support of software for various business applications. Over 5 years of hands-on experience with OLAP/Datawarehouse design using MS Analysis Services and MS SQL Server 2000; Cognos PowerPlay, Cognos ReportNet, Cognos 8 BI. Strong knowledge of the DW architecture, cubes design, MDX, DTS, SQL.
Development tools:
Cognos BI, Cognos EP, MS Analysis Services, MS SQL Server 2000, MS DTS.
Cognos certificates:
Cognos 8 BI Authoring
PowerPlay Series 7 Product Professional
Cognos Planning Analyst Series 7 Product Professional
Cognos Planning Contributor Series 7 Product Professional
Experience:
Consultant, Senior Consultant
XXX Systems Integrator
Moscow, Russia
March 2005 – present
Commercial projects
• As a BI expert lead a team of two consultants in a complex IT project.
Created structure of DWH for needed reports.
Developed a concept of data exchange between several information systems.
• Participated a Cognos EP project for a big retail company selling sportswear and equipment.
Created several libraries (budget of operating expenses, transfer prices, etc).
Created a links between the libraries.
Managed technical issues of working upon Oracle database.
• Participated PowerPlay project for a big media holding company.
Analyzed business requirements
Designed SQL queries to OLTP database (Oracle);
Designed Powercubes in Cognos PowerPlay Transformer;
Presales and POC projects
• Together with trainee created pilot BI solution upon Cognos EP data and transaction database for plan-fact analyses for a big retail company.
Created data mart.
Created SQL scripts for transforming data from Cognos Contributor published data and from OLTP database and for loading it into data mart (Oracle).
Created a FM model with multigrain information. (Fact data more detailed than plan data).
Created Powercubes with both plan and fact data (level of detail of fact data is the same as for plan data).
Created several reports including dashboards and detail reports.
Created drill-throughs between reports and package drill-throughs allowing drilling from Powercube analysis into detailed fact reports.
• Created a Powercube using customer’s data and authoring network of dashboards and detailed reports upon it.
• Participated presale activity for the Central bank of Russia (one of the top 5 Cognos sales in a East Europe).
• Realized number of minor presales.
• Created a Cognos 8 BI demonstration scenario for using by the other consultants.
Trainings and investment projects
• Created the PowerPlay course for users.
• Trained several groups of client’s staff (PowerPlay, PowerPlay Transformer, Cognos 8 BI).
• Trained several new employees groups (BI concept, DW and ETL basis, full line of Cognos BI products)
• Created business case for new employees testing.
• By my own initiative created BI-spam (basis of BI), that most of colleagues found very useful.
Software Engineer
XXX join stock
January 2001 – February 2005
Krasnodar, Russia; Moscow, Russia
• Made a DW aimed to collect sales information from both Moscow and Kiev sales divisions of the company (data is sent to DW in XML format, SQLXML 3.0 allows loading it into the DW).
Analyzed business requirements;
Designed data storage (MS Access);
Designed DTS packages for transforming data from two data stages to data storage;
Designed OLAP cubes;
Trained users to work with ProClarity Desktop client application (later – ProClatity professional);
Tools developed for the project:
A tool to extract various data from OLTP databases and to save it in XML format (1C built-in language, VB 6.0);
A tool to monitor data changes and to save changes as updategrames for SQLXML 3.0 (1C built-in language, VB 6.0);
A tool to load changes to DW
Project information:
In Moscow division data for sales cube loaded from one operative database and four historical databases.
Project based on previous versions of systems for trade and finances analysis (perfect example of spiral development circle).
• Established and adapted trade OLTP system based on 1C (application with built-in programming language like VBA) in Moscow division, provided support for the system
• Established and adapted production OLTP system in Krasnodar division (Factory of cosmetics), provided support for the system.
Senior Software Engineer
XXX, Ltd
January 1998 - January 2001
Krasnodar, Russia
Adapted various 1C applications for business needs in several companies in Krasnodar and region.
Designed and deployed a system for calculation of rent of uninhabited buildings. System is still operated by municipal services of Krasnodar.
Responsibilities:
• Analyzed business requirements of clients;
• Adapted 1C applications for business needs;
• Trained client’s staff
• As a one of the lead specialists participated seminars and product demonstrations.
Education:
BS in Computer Science
Kuban State University, Krasnodar, Russia (1992-1997)
Additional education:
Cognos 8 BI – Authoring and Modeling FastTrack
Completed Microsoft courses:
M2779 Programming a Microsoft SQL server 2005 Database
M2071 Querying Microsoft SQL server 2000 with Transact-SQL
M2073 Programming a Microsoft SQL server 2000 Database
Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000; Implementing Business logic with MDX in Microsoft SQL Server 2000; Populating Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services (intensive complex course, approved by Microsoft).
References: Available upon request.
====
И еще - с первой работы (последней в списке) не получится получить референс - надо ли ее указывать?