Manager Data
Resume:
Sandeep. G [pic]
Email:
*****.************@*****.***
Professional Summary
> TOTAL 10 YEARS OF EXPERIENCE IN IMPLEMENTING BUSINESS INTELLIGENCE
SOLUTIONS USING COGNOS BI AND INFORMATICA SUITE IN DIFFERENT
ENVIRONMENTS.
> Knowledge of complete BI Life Cycle Development process.
> Having strong knowledge on Data warehousing Concepts.
> Extensive experience in gathering and documenting user requirements.
> Good understanding of Multi Dimensional Modeling using Star and
Snowflex Schema.
> Developed reports in Cognos 8/10 BI Suite using Report Studio, Query
Studio, Analysis Studio, Cognos ReportNet (Report studio, Query Studio)
and in Cognos Enterprise Series 7 using Impromptu and Power Play for
windows.
> Extensive experience in installation and configuration of Cognos 8/10
Environments
> Expertise in Bursting and Scheduling of Reports.
> Proficient in designing complex reports using Conditional Prompts,
Filters, Cross Tab, Graphs, Chart, Dynamic Reports, Dash boards, Multi
Query reports and Drill-Through Reports.
> Worked on Security access to clients using Access Manager and worked
with Data Security, Object Security, and Package Security.
> Extensively worked on Informatica tools such as Informatica Repository
Manager, Designer (Source Analyzer, Warehouse designer, Mapping
designer, Transformations & Mapplets).
> Expertise in Deployment using Cognos Connection Portal in Cognos 8/10.
> Extensive experience in Migrating to Cognos 10.2/10.1 from 8.2/8.3/8.4
versions.
> Extensive experience in Cognos BI Life Cycle Manager.
> Extensively working on Oracle 10g, 11g and DB2.
> Extensively working on Design, Installation, Configuration,
Administration, Maintenance and Upgrade of Cognos8 BI servers on DEV,
UAT and PROD Environments.
> Working on Operational support coverage to solve technical problems
7/24(365 days), Code deployments, User Administration, Non-Prod
environment support, Development support, Automation Support, Net-
backup support, all scheduled jobs to build reporting objects in the
environment maintaining system and server performance, server
administration including disk usage, memory usage, server monitoring.
> Performing monthly Disaster Recovery, upgrades and applying Cognos code
fixes, Application server fix pack as applicable.
> Experience with the design and delivery of Extraction Transformation
and Loading ETL tool and applications including decision support
application development approaches, methodologies and technologies
(OLAP, MOLAP, ROLAP, OLTP, Informatica Power Mart 7.1/8.1 Power Center
7.1/8.1 Designer, STAR Schema, SNOW-FLAKE Schema design, ETL and UNIX).
> Extensively working on daily vaulting, weekly vaulting NetBackups on
Veritas NetBackup 6.0 Enterprise Server.
> Extensive experience install configure and Maintain SQL Server
Databases.
> Built Multidimensional cubes using PowerPlay Transformer.
> Good Knowledge on Informatica & Data Stage tools as ETL Developer.
> Proficient and hands on experience with Informatica & Cognos Data
manager/ Decision Stream.
> Develop the Informatica mappings/workflows/worklets/session.
> Experience in testing the data consistency between Source System - DW
and DW-Report.
> Excellent analytical and communication skills, ability to work
independently and also a good team player.
> Good experience in training end users.
> Ability to rapidly learn new concepts together with excellent
interpersonal skills.
> Exceptional communication, analytical, presentation and problem solving
skills.
> Excellent skills in understanding business needs and converting them
into technical solution.
> Experience in handling tickets for production support.
> Good experience in analysis, design, testing, development and
implementation of client/server applications.
> Deploy the Cognos code (Transformer models, Framework Models/Packages,
reports and cube views) from Dev to UAT and from UAT to Production
environment.
> Installation of patches in Cognos or Microsoft or windows.
> Make sure to balance the load on the servers.
> Closely monitor the servers during month end.
> Managing the current activities.
> Reboot the servers on weekly basis on sequential order.
> Managing the Dispatchers and services.
> Guide the Cognos developers to follow the project standards at the time
of designing.
> Set up the security to projects.
> Creating the Data source connection for an application
> Create Users, user groups in Cognos access manager and associate them
into Cognos connection.
> Installation and configuration of cognos software in new developer
system.
> Creating a profile and grant the access to new developers.
> Make sure to take the backup of code.
> Maintaining the source code in configuration management.
> Make sure to deliver the scheduled reports on daily/weekly/monthly.
> Certified in COGNOS BI.
Technical skills
OLAP Tools : Cognos 10.1/8/7 BI (Framework Manager, Query Studio,
Report Studio, Analysis Studio, Metric Studio and
Event Studio, Cognos Connection, Power play
Transformer, Workspace, Workspace Advanced, Business
Insight, Cognos cube Designer, Access Manger, Cognos
administration.),Cognos EP 7 (Impromptu,Web Reports
(IWR)), Upfront, BOXI3,Crystal reports 9.0. IBM Web
Sphere Application Server,OBIEE, SSRS,SSIS,SSAS,
Micro strategy, Access Manager, Hyperion Essbase,
Hyperion DRM,, Hyperion Essbase, Hyperion DRM,SAP
BPC .
ETL Tools : Informatica8/7, Data stage,
Data Manager8.4, Abinitio, SSIS.
Databases : Oracle 11g/8i//9i/, MS SQL Server, DB2,
SQL Server2008, Teradata.
Database Tools : Toad, WINSQL.
Languages : C, C++, Java, .NET, COBOL, Pascal,
FORTRAN, HTML, XML, Visual Basic 6.0,
PL/SQL
Operating Systems : Windows NT/98/2000//XP,
Unix/Linux, AIX Sun-Solaris.
Web services : Java/ Web Server, IIS 4.0/5.0, Netscape
Directory Server, Apache Web
Tomcat 4.01. IIS, Sun Salaries, Red Hot, Linux,
UNIX.
Other Tools : Adobe Photo Shop, MS Office2003, MSAccess,
MSExcel.
Education:
. Masters from Osmania University, Hyderabad.
Certifications in Cognos:
> IBM Cognos 10 BI Metadata Models Certified Professional
> IBM Cognos 10 BI Reports Certified Professional
> IBM Cognos 10 BI Administrator Certified Professional
Professional Experience
Client: BMW
Dec'
10 - Till Date
Role: BI Consultant
Project Name: - BI Support
Location: Woodcliff Lake, NJ
Key Responsibilities:
. ANALYZED THE BUSINESS PROCESSES, DATA ANALYSIS REQUIREMENTS AND
DEVELOPED SPECIFICATION DOCUMENTS FOR REPORTS AS PER CLIENT
REQUIREMENTS.
. Deploy the Cognos code (Transformer models, Framework Models/Packages,
reports and cube views) from Dev to UAT and from UAT to Production
environment.
. Installation of patches in Cognos or Microsoft or windows.
. Make sure to balance the load on the servers.
. Closely monitor the servers during month end.
. Managing the current activities.
. Reboot the servers on weekly basis on sequential order.
. Managing the Dispatchers and services.
. Guide the Cognos developers to follow the project standards at the time
of designing.
. Set up the security to projects.
. Creating the Data source connection for an application
. Create Users, User Groups in Cognos access manager and associate them
into Cognos connection.
. Installation and configuration of cognos software in new developer
system.
. Creating a profile and grant the access to new developers.
. Maintaining the source code in configuration management.
. Make sure to deliver the scheduled reports on
daily/weekly/monthlyEnsure the timely and quality deliverables of
Cognos and Informatica tasks assigned to me.
. Managing the Dispatchers and services.
. Set up the security to projects.
. Make sure to deliver the scheduled reports on daily/weekly/monthly.
. Extensive experience in Migrating to Cognos 10.2/10.1 from 8.2/8.3/8.4
versions.
. Extensive experience in planning and implementation of: Cognos server
scaling, Cognos architecture, Cognos capacity planning, Cognos load
testing,Cognos query/performance tuning, Cognos failover, Cognos load
balance, Cognos advance routing, Cognos back-up and recovery
. Extensive experience for the health of the Cognos 10 BI environment
DEV, QA and PROD.
. Extensively managed the security of the Cognos 10 BI environment.
. Extensive experience in monitoring all scheduled jobs including reports
for business users, ETL jobs
. Extensive experience in setting up standard and architecture of the
meta data layer
. Extensive experience in Staging Layer, Core Layer, Semantic Layer
design and data modeling to meet the business requirements semantic and
presentation layers.
. Extensive experience in providing performance monitoring and tune
services on BI server platforms
. Extensive experience in ensuring stability given large, uneven requests
of BI environment for reporting and adhoc analysis
. Extensive experience in setting up and manage multiple environments for
application and report development, testing, training and production
environment
. Strong experience in Setting up and manage domain groups/access rights
(Name spaces) for BI platform users
. Strong experience in follow change management process and procedures to
perform production migrations from test and other environments
. Extensive experience in documenting installation steps, environments
custom configurations, production system changes and technical
architecture platforms
. Extensive experience in assisting developers with test planning, test
conditions and obtaining test data
. Extensive experience in supporting Cognos reports, cubes migrate to
different environments
. Performing in-depth and comprehensive system, application and user-
object troubleshooting - coordinating with users, other department
personnel, vendors and service technicians
. Extensive experience in consult with business community to gather
requirements for specific BI scorecard, dashboard and reporting needs.
. Extensive experience in Cognos 10 Administration to work in a fast
paced environment.
. Extensive experience in multiple server environments in distributed
architecture, with plans to upgrade to 10.1.1/10.2.1.
. Extensive experience in work on problems of diverse scope with moderate
to high complexity
. Extensive experience in root-cause-analysis, problem identification and
resolution, optimization and performance tuning, security, backup and
data recovery.
. Extensive experience work closely with the client to design,
implements, and architects an enterprise environment that spans
multiple divisions and groups, and integrates data and processes
throughout the organization.
. Strong expertise in the following functional area such as Security
Management, Patching and applying bug fixes, Performance Tuning, Backup
and Recovery.
. Monitored System Performance (identifying the no of items in the queue)
using Metrics available in Cognos Administration.
. Strong experience in installation of products and Cognos Modules,
experiences working with Cognos support and ticket escalation
. Extensive experience in Participate in the design and development of
enterprise-wide data repositories.
. Extensive experience in Design and validate Cognos Framework Models as
assigned, working with BI analysts and DBAs to ensure appropriate
database views and/or tables are available to support the Framework
information needs and that accurate information is presented through
the framework.
. Provided guidance on and adhere to best practices in Cognos Framework
design and development as well as change management.
. Extensive experience in performance tuning/optimization of the
Framework in coordination with database layer tuning performed by the
DBA and application team.
. Make recommendation to improve the efficiency and functionality of the
database and Cognos BI environment
. Designed and developed scorecards, dashboards and multi-dimension data
cubes using Cognos
. Developed and executed a verification and security strategy to ensure
the accuracy of the data distributed in the reports
. Design the different documents like Requirement Specification and Low
Level Design Documents for Reports.
. Prepare the Test cases for Cognos reports and Informatica Mappings.
. Creation of reports based on simple, medium and complex using Cognos8
and 10.
. Do the Unit testing for accuracy of the reports.
. Fixing the issues of defects during the monitoring.
. Analysis of the ETL Mappings/Sessions/Workflows/Worklets in
Informatica.
. Monitor the ETL mappings/jobs during the Production Support.
. Extensively worked on Informatica tools such as Informatica Repository
Manager, Designer (Source Analyzer, Warehouse designer, Mapping
designer, Transformations & Mapplets),
. Responsible for Extracting, Transforming and Loading data from Oracle,
Flat file and lacing it into Data warehouse.
. Design and Development of Mappings, Mapplets using Informatica Power
Center.
. Failure analysis for Informatica loads using Error logs.
. Configuring Repository Manager, created folders and managed objects in
repository manager of Informatica.
. Creating Informatica mappings to build business rules to load data.
Most of the transformations were used like the Source qualifier,
Aggregator, update strategy, Router, Expression, lookups, Filters &
Sequence Generator.
. Managing the current activities.
. Follow up with Users for any clarifications.
. Fixing all issues which are raised in Remedy Ticket tool by Users.
. Creating the Data source connection for an application
. Design the cognos reports as per the deadline.
. Validate the reports with Users.
. Preparation of the KT plan.
. Arrange KT sessions for new support applications with planned time
table.
. Give estimations for new developing reports/TPA.
. Executed the Cognos migration project from Impromptu to Cognos8 for UK
Apps.
. Maintain good relationship with Customer/Superiors/Team members.
. Configuration of Cognos content store.
. Identify risks and communicated to Supervisor.
. Guide the Cognos developers to follow the project standards at the time
of designing.
. Developed the Best Practices method for Creating Report Template,
Report & Prompt Page, Governor Settings and Report Naming Convention in
Cognos 8.4 &10.
. Designed very informative and efficient relational models using
functionalities like Shortcut Alias only available in Cognos 8.4
Framework Manager.
. Created Executive Dashboards to represent the financial data
. Deploy the Cognos code (Transformer models, Framework Models/Packages,
reports and cube views) from Dev to UAT and from UAT to Production
environment.
. Installation of patches in Cognos or Microsoft or windows.
. Monitored System Performance (identifying the no of items in the queue)
using Metrics available in Cognos Administration.
. Scheduled and Distributed 8/10 BI reports using Schedule Management in
Cognos Connection.
. Created new Groups and Roles in Cognos 8 and associating with the new
packages.
. Setting up New Users in Access Manager and giving them the required
permissions.
. Business User Training to get them familiarized to Cognos Connection
environment and also helped them in the transition from Series 7
Upfront to Cognos Connection.
. Demonstrated the Cognos 8/10 environment, tools with their
functionality.
. Reboot the servers on weekly basis on sequential order.
Environment: Cognos10.1(Cognos Connection, Framework Manager, Report
Studio, Query Studio, Analysis Studio, Metric Studio and Event Studio,
Configuration Manager, Power play Transformer, Cognos cube Designer, Access
Manger, Workspace, Workspace Advanced, Business Insight, Cognos
Administration),Informatica,Teradata,Oracle11g,MSSQL Server.
Client: GE
Nov'08 - Dec'10
Role: Cognos Administrator/Modeler/Developer
Project Name: - Forecast Datawareshouse
Location: Albany, NY
Key Responsibilities:
. Requirement Analysis & Estimation Interaction with business
users/analysts to clarify doubts and provide technical inputs to
them." Analyze the complexity of the requirement and communicate the
effort estimate to client.
. Functional understanding of existing and new reports
. Functional understanding, documentation of tactical and strategic client
mart.
. Business requirement analysis. Conversion of business requirements into
technical understanding.
. Involved in gathering Onsite-Offshore connectivity requirements and
setting up the connectivity at offshore.
. Proficient in implementing user level and data level securities within
Cognos 8
. Strong experience in Cognos server build, Sizing, troubleshooting,
tuning,POC & disaster recovery exercises.
. Extensive experience of data warehouse modeling, architectures, OLAP,
OLTP data sets.
. Proactively monitoring threshold/s setup in Cognos 8 environment.
. Strong expertise with tuning Cognos BI OLAP components for faster access
and performance (i.. Transformer, PowerPlay Cube, PowerPlay Client and
PowerPlay Studio)
. Extensive experience install configure and Maintain SQL Server Databases
. Successfully completed Cognos v8.4 upgrade for the various reporting
suites to the defined scope, project plan and implementation plan to
specified timeline.
. Extensively working on the configuration of the Cognos environments such
single server and multiserver components, failover, load balance
mechanism including the underlying WebShere Application Server and
database components such as Audit and Cognos Content Store.
. Daily, Weekdays, Weekend, off-hour Support to developers with the
Cognos framework engineers, as needed, to assist in problem
determination of complex issues including assistance in analyzing
application performance problems.
. New Development, Enhancement, Maintenance and Migration of applications
in the Development tower.
. Experience with migration of hot files, catalogs, reports, power play
Transformer cubes from Cognos Series 7.1/7.4 to Cognos 8.2 using
Migration Utilities.
. Customize the Cognos connection portal using existing portlets and
customized tabs.
. Developed List, cross tab, drill through, master-detail, chart and
complex reports which involved Multiple Prompts, multi-query reports,
Burst Reports and Dashboard reports against database.
. Creating cross-tab reports and chart reports using multiple queries and
drill down capabilities in a single report to meet the business needs.
. Created Cubes (MOLAP/ROLAP) using IQD's which were built in Framework
manager and DMR Metadata Modeling.
. Supported Cognos Transformer models and cubes. Involved in implemented
security at transformer level by creating custom views. Created
Calculated Measures in Transformer.
. Working with Informatica Power Center client tools like Source Analyzer,
Warehouse Designer, Mapping Designer and Transformation Developer.
. Developed the Mappings/Worklets/Workflows/Sessions in Informatica.
. Fixing the issues of defects during the SIT.
. Using Developed SQL scripts for business data loads.
. Imported data from various Sources transformed and loaded into Data
Warehouse Targets using Informatica client Tools.
. Involved in Unit testing, System integration and UAT.
Environment: Cognos 8.2 (Framework Manager, Report Studio, Query Studio,
Analysis Studio, Cognos Connection,
Metric Studio and Event Studio, Configuration Manager Cognos
Administration), CognosEP7 (PowerPlay7.1/7.4,
Impromptu7.1/7.4,PowerplayTransformer),Informatica,Oracle,DB2,Windows
2000sever, Cognos Migration tools.
Client: Electrolux, NA, US
Oct'07 - Oct'08
Role: Cognos Developer
Project Name: BI - Support
Responsibilities:
. Created metadata models, made appropriate Joins, organized Folders
according to the Business view and published the packages using Framework
Manager onto Cognos Connection.
. Designed various types of reports according to end user requirements.
. Applied advanced formatting features to the reports using Query Studio
and Report Studio.
. Developed Rank reports and Section reports using Query Studio.
. Designed reports with conditional formatting.
. Designed reports using cross tab.
. Developed single select and multiple select cascading prompts.
. Scheduled reports using cognos connection Web portal.
. Created master detail relationship report.
. Extraction of data from source systems present at different physical
locations both for historical load and ongoing processes.
. Worked with Blocks in simple list reports.
. Loading the transformed data into the data warehouse.
. Testing the Cubes data for accuracy and monitoring the BI Portals.
. Running the job streams manually when required.
. Monitoring the nightly jobs using Tivoli Scheduler and fixing the issues
on daily basis.
. Created Views for Generating reports.
. Extraction of data from source systems present at different physical
locations both for historical load and ongoing processes.
. Handling the enhancement work.
. Provided administrative support for production issues.
. Involved in Creating Content store, installation and configuration of the
Cognos8
. Involved in design and development of joins, filters, calculations and
conditional variables in DMR Packages within Framework Manager.
. Created complex reports using Report Studio and Ad-hoc web based reports
using Query Studio.
. Published Impromptu Web Reports (IWR) and PowerPlay cubes & reports onto
the Upfront using Cognos IWR administration as well as PowerPlay
Enterprise Server
. Performed Pivoting, Drill-down, Slice & Dice and Filtering operations
done for all OLAP applications.
. Extensive experience in Exceptional highlighting, sorting and ranking.
. Performance tuning power-Dynamic cubes (IQD) to reduce Query time and
Partitioned Cubes.
. Involved in Scheduling reports using Cognos Scheduler.
. Trained end users on Query Studio for Ad-hoc reporting as well as
involved in the Documentation.
Environment: Cognos 8 BI(Report Studio, Query Studio, Cognos Connection,
Framework Manager, Cognos Administration), Cognos EP,Impromptu Web Reports
7.3, Power play Transformer 7.3, Cognos Data Manger, Decision Stream
designer,DB2,MS SQL Server, Windows 2K.
Client: AT & T, US
Oct'05 -
Sep'07
Role: Cognos/Informatica Developer
Project Name: - Database of Records (DBoR)
Responsibilities:
. Analysis of the specifications provided by the clients
. Responsible for gathering/refining requirements from the customer for
developing reports.
. Loaded operational data from Oracle, Flat Files into transient Tables and
cleaned the data using appropriate business rules.
. Worked on Informatica power center, Source Analyzer, Warehouse Designer,
Mapping Designer and Workflow Manager.
. Implemented Expression, Aggregator, Sorter, Lookup, Update Strategy,
Filter Transformations.
. Developed reports in report studio.
. Implemented filters, prompts, Formatting, Look and Feel and drill
through capabilities
. Designed various types of reports according to end user requirements.
. Developed simple as well as complex reports using Report Studio.
. Developed standard templates which could be used as foundation of all
reports.
. Designed reports with conditional formatting and drill through.
. Created multi page reports using conditional layouts.
. Involved in creation reports with value prompt, select and search prompt.
. Created the reports on daily, weekly and monthly basis.
. Prepared the unit test cases.
Environment: Informatica Power Center, Cognos, Windows XP and Oracle.
Contact this candidate