VIJAY SHANKER PANDEY
[Former Sr. Project Manager/ IT Consultant at CyberThink Inc. USA,
UBA Lagos Nigeria, CIB Cairo Egipt, AlRajhi Bank Saudi Arabia,
Bank Danamon Indonesia]
Academic/Professional Qualification
Master in Computer Application [M.C.A.] E-mail : v_s_pan@hotmail.com
Master of Business Administration [M.B.A.] Cell No : +919415264983
Master of Social Work [M.S.W.]
Certification/Training/Workshop
Executive Development Programme “Project Management” under CEP from I.I.T. Delhi.
Workshop on Microsoft Project 2007.
SUMMARY OF QUALIFICATIONS:
IT Professional with over 18 years of extensive experience in IT that includes Project Management ,Resource
Management, Data Analysis, Modeling, Mapping, Design and Development of Databases for business
applications in client/server applications, OLTP/OLAP and Data warehousing/Business Intelligence, Data
Marts environment.
Provided project leadership to 10-15 members for development, migration to production, status reporting,
project delivery, client/project team coordination etc.,
9+ years of experience in Business Intelligence with tools Cognos 10/8.4/8.3/8.2/8, Cognos EP, TM1,
Cognos7 Series, ReportNet 1.1, Business Objects, Crystal Report, Informatica,DataStage and MS SQL
Server 2008/2005/2000 BI , Oracle BI 10.1.3.4.
Proficient in OLTP/OLAP/Data warehousing /Data Marts architecture.
Expertise in OLTP/OLAP System Study, Analysis and E-R Modeling / Dimensional Modeling, for
developing database schemas, Star Schema / Snowflake Schema used in relational, dimensional,
multidimensional modeling and Metadata creating Data Definitions and Metadata repository.
Experience in dealing with different data sources ranging from Flat files, XML, Oracle8i/9i/10g, SQL
server2000/2005/2008, MS Access, dBase, FoxPro and Excel.
Extensive experience in Cognos 7 & 8 &10 Series which includes Impromptu, Powerplay, Powerplay
Transformer, Architect, Query Studio, Report Studio, Analysis studio, Event Studio, Metric Studio.
Experience in designing, developing and maintaining Cognos Impromptu and Cognos PowerPlay reports,
creating Catalogs and implementing the Security using User Classes in Impromptu Administrator. User
creation in Cognos Access Manager. Created multidimensional models and Power Cubes for distribution
using Power Play Transformer.
Expertise in creating complex reports in Cognos Report Studio, Impromptu Administrator, Power Play
Reports (List reports, Cross-tab reports, Drill through reports, Sub reports and Cascading prompts).
Experience in designing, developing Projects, Models and publishing Packages using Framework Manager
and Cognos Metric Designer.
Experience in data mapping from source to target database schemas. Designed, Extracted and Loaded the
Database using ETL tool Informatica 6.1/7.1 and IBM DataStage made several transformations and run
sessions.
Experience in SQL Server 2000/2005/2008, Data Transformation Services (DTS), Analysis Services
(SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
Experience in different databases like Oracle 8i/9i/10G, MS Access and SQL Server 2000/2005/2008.
Experience in creating complex Packages, Stored Procedures, Functions, Triggers, Cursors, Tables, Views,
Joins, SQL, and T-SQL.