Name:
Surjit Kumar Singh
Designation
Senior Consultant
Birth Date
Residence
Bangalore
Nationality
Indian
Marital Status
Married
Gender
Male
Passport Details
L3192443
Visa Details
USA B1/B2
Total 9.2 years of experience on various Cognos suite. Managed and lead project, Resource planning, forecasting and budgeting for project.
Developed reports, Framework and Transformer models.
Migrated reports from Cognos 8.4 to Cognos 10.1 and10.2 using lifecycle manager. Followed SDLC lifecycle from development of reports and models to testing and deployment of reports.
Cognos 8.3/8.4/10.1/10.2 report studio, Framework Manager, Transformer,
Analysis Studio, Query Studio, Event Studio, Toad, Oracle 9/10/11,
Sql Server 2K5/2K8, Knowledge on DataStage8.5, tm1, Hadoop,
MongoDB, R programming, Tableau, Requirement gathering, project and
resource planning, report creation on forecasting and budgeting.
Worked for Retail Client for 3.2 years, Inventory for 2.6 Years and Banking industry for 1.2 Years.
Speak
Read
Write
Hindi
Native language
Native language
Native language
English
Fluent
Fluent
Fluent
01-05-2015 To
Current
(Centizen)
Project Name
Costco BI Report Development
Client
Costco
Role
Cognos BI Architect
Roles performed
Working as BI Architect and to gather BI report requirement and creating Detailed report design document for Dimensional reports.
Managing offshore team size of 20 resource.
Working as individual contributor to develop dimensional reports.
Contributing to onshore counterpart to develop model for reporting.
Technology used in project
Cognos 10.2.1 report studio, Framework manager, Google Tracker sheet, Citrix.
Environment
Windows 7 Client Machine OS, Oracle ExaData
30-06-2014 To
28-04-2015
(Capgemini)
Project Name
IKEA Migration
Client
IKEA
Role
Project Lead
Roles performed
Done requirement gathering for Migration.
Created Migration planning document, Test Plan document.
Actively involved in migrating Cognos 8.4 reports to Cognos 10.2
Upgraded FM Model to DQM.
Worked as coordinator between onshore offshore team.
Build Team for Cognos Migration and lead Team for migration delivery.
Provided new Governance and Security model for migrated Cognos Solution.
Scheduled migrated reports.
Deployed Solution to Production Environment.
Provided Knowledge Transfer to different Solution AM Team.
Technology used in project
Cognos 8.4, Cognos 10.2 report studio, Framework manager, HP-ALM, BMC Remedy, Project Place.
Environment
Windows 7 Client Machine OS, Oracle 11g Database server
Description
IKEA needed to migrated Cognos 8.4 reports to 10.2.1 environment.
30-11-2012
Project Name
Praxair BI
To 30-06-2014 (Capgemini)
Client
Praxair USA
Role
Senior Consultant
Roles performed
Developed and tested new reports
Enhanced existing reports and model
Fixed issues with existing reports
Provided solutions to optimize the performance of reports
Done Multilingual modeling and report implementation.
Provided Knowledge transfer to Support and Business user.
Scheduled Deployed reports on Production.
Technology used in project
Cognos 10.1 report studio, Framework manager
Environment
Windows 7 Client Machine OS, SQL Server 2008 R2 Database server
Description
Project needed to develop Logistics reports using semi Agile methodology and performance tuning into existing reports and model on Cognos 10.1 server. Deployment of reports to Production system and provide Knowledge transfer to Business user at Client location.
01-09-2011
Project Name
Economic Capital
To 02-11-2012 (IBM)
Client
Bank of Montreal
Role
Senior Application Developer
Roles performed
Developed and tested new reports
Enhanced existing reports and model
Fixed issues with existing reports.
Provided solutions to optimize the performance of reports.
Migrated reports from Cognos 8.4 to Cognos 10.1
Deployed Solution to Production Environment.
Provided Knowledge Transfer to different Solution AM Team
Technology used in project
Cognos 8.4 report studio, Framework manager, Analysis Studio, Query Studio, Event Studio and Life Cycle manager
Environment
Windows XP Client Machine OS, SQL Server 2005 Database server
Description
Project needed to develop some of the toughest reports using Agile methodology in very short span of time and plenty of defects fix, enhancements and performance tuning into existing reports and model on Cognos 8.4 server and then migrated to Cognos 10.1 server.
15-08-2011
Project Name
Capital Data Mart
To 31-05-2012
(IBM)
Client
Bank of Montreal
Role
Senior Application developer
Roles performed
Scheduling tool to collect data from various source to capital data mart
Defect fixing of the tool and administering the business users of Data Mart.
Technology used in project
VB 6, MS Access, Oracle10
Environment
window XP OS
Description
Scheduling tool to collect data from various source to capital data mart, defect fixing of the tool and administering the business users of Data Mart.
01-08-2010
Project Name
EUSFA – European Sales Force Automation
To 05-08-2011
Client
RICOH
(Infosys)
Role
Technology Analyst
Roles performed
Mentored Team
Developed reports and model using iterative SDLC cycle
Created functional specification document based on requirement received from Client
Developed new Sales Force reports.
Created HLD and LLD for reports and model.
Redeveloped existing reports of services for finance and SCM
Created UTP and SIT for reports
Technology used in project
Cognos 8.4 Report Studio, Framework Manager, Transformer, Analysis studio, Toad for Oracle 9.0
Environment
window XP OS
Description
RICOH wanted to develop their warehouse system for European Sales force and develop Cognos reports source from warehouse.
01-01-2010
Project Name
Technical Changes
To 31-07-2010
Client
RICOH
(Infosys)
Role
Technology Analyst
Roles performed
Redeveloped existing reports.
Technology used in project
Cognos 8.4 Report Studio, Analysis studio, Toad for Oracle 9.0
Environment
window XP OS
Description
Redeveloped existing reports of services, finance and SCM and created UTP and SIT for reports, tested reports.
15-02-2009
Project Name
Indian Railway
To 15-12-2009
Client
Indian Railway
(Infosys)
Role
Senior Software Engineer
Roles performed
Developed and tested Inventory reports.
Provided support and maintenance of developed reports.
Technology used in project
Cognos 8.3 report studio, Query Studio
Environment
window XP OS
Description
Developed and tested Inventory reports. Provided support and maintenance of developed reports.
27-07-2006
Project Name
Maintenance of Cognos Series 7 Suites
To 20-01-2009
Client
Cognos
(Infosys)
Role
Software Developer and Quality Engineer
Roles performed
Role as Developer:
Worked as development engineer for PPDS(Power play data server) on Windows, AIX, HPUX and Solaris platform. PPDS(Power play data server) is a part of PowerPlay Enterprise Server is the Cognos solution for enterprise OLAP (on-line analytical processing) reporting.
Maintenance and support for Architect product suite using MFC.
Development of customized messages box to resolve the issue of I18n in MFC.
Handling multiple components like PPDS, Architect, PPXO and CFC simultaneously.
Role as Quality Engineer:
Understanding of Cognos Visualizer Product.
Tested compatibility of Cognos Visualizer product with different database servers like DB2, ORACLE, SYBASE, and INFORMIX on different platforms like UNIX( Solaris, HPUX, AIX), Windows (2k3, 2k, xp, vista, 2k8) platform
3. Written Automation Test script for Visualizer using Win-Runner.
4. Tested UDA (Universal data Access) compatibility for different databases.
5. Done Manual and Automation testing for Cognos Noticecast.
6. Written Automation script for Noticecast using winrunner.
Technology used in project
MFC, C++,Visual Studio .NET 2003, WinRunner
Environment
Windows XP/2K/2K3/VISTA/2K8, Unix HP/AIX/Solaris
Description
COGNOS ULC was a leading BI/DW Product based company which was later acquired by IBM. COGNOS was customer of Infosys for its BI Products support, development and maintenance.
Certification
COG-612 IBM Certified report Author
COG-632 IBM Certified Meta Modeler
COG-180 IBM Certified Solution Expert
COG-635 IBM Certified Olap Developer
COG-622 IBM Certified Administrator
Training attended
B5181 – Framework manager modeling
KM200 Fundamentals of DataStage 8.5
MongoDB 101 Developers
MongoDB 102 DBA
Hadoop Cloudera (Capgemini internals)
TM1,
R programming (Coursera)
M.S in Software System from BITS Pilani in 2011 with CGPA 7.67
B.TECH in Computer Science & Engineering. from SASTRA University in 2006 with CGPA 8.4
12th in Math, Physics, Chemistry in 2001 from Bihar Board with 76%
10th in 1999 from Bihar Board with 72.14%
Excellence in Customer Delivery Award in Capgemini 2014
Project Star Award in Capgemini 2013
Service Excellence Award in IBM 2012
Spot Award in Infosys 2008
2nd prize in Mathematics in SASTRA university in 2002-03
Permanent Address
B-402, Lotus Petals, Kamanahalli Village, Near Meenakashi Temple, Bannerghatta Road, Bangalore -560083
Current Address
Mobile
Flat no: T6, EMAR Apartment, NGO-A Colony, Tirunelveli.
Email Address
acqwhg@r.postjobfree.com