Cognos Designer
Resume:
Shruti Kumari,
IBM Certified Cognos Designer
IBM Certified Cognos Administrator
Current Location : Toronto, ON -- Canada
Email : ****************@*****.***
Mobile : +1-647-***-****
Professional Profile
Shruti Kumari is an IBM Certified Designer and Administrator in Cognos practice. Cognos is IBM's (BI) and software suite. The software is designed to enable business users without technical knowledge to extract corporate data, analyze it and assemble reports. Shruti has over six years of experience in the IT industry with the last two focused on solution architecture assignments. Shruti also has experience with several leading technologies including Pl/SQL, Oracle D2K and UNIX. She has lead teams of practitioners to help IBM and its customers with Data ware house application development, testing & architecture for several years. Her industry experience includes banking, financial services, energy & utility, and telecommunications.
Summary of Professional Experience
6+ years of IT industry experience encompassing a wide range of roles / responsibilities in Banking & Finance / Energy & Utility, Telecommunication, Health and Manufacturing sector.6+ years of relevant experience in Cognos, Oracle, SQL & PL/SQL.Worked on UNIX shell scripting. 6+ years of experience in Data warehouse, BI Reporting, Business Analysis, Client Management, Training & Documentation, Troubleshooting, Quality Assurance and Management of Project Deliverables.Experience in Analysis, Design, Development, Customization and Implementation of Data Warehouse and BI Reporting using Cognos and SQL.Working Knowledge of Data Warehouse concepts and Metadata Modeling.Strong Experience in User Acceptance Test, Product Support, Version Control, Change Management and On-site/Off-Shore Coordination.Experience in implementation as per SDLC (Waterfall & Agile Methodologies)..28+ months of onsite experience through IBM in Singapore & Canada. Presently working with BMO as a Senior Cognos developer since Aug 2011.Secondary Skills include D2K (Developer 2000, designing of forms and reports)Worked closely with Fortune 500 clients like Telus, BMO, DBS Singapore, Islamic Banking Singapore, and Nisource, USA. Other prestigious domestic clients include Chamundeshwari sugars Bangalore, Himalaya Drugs Bangalore & Pidilitte Mumbai.Handled multiple roles in projects like Information Gathering, Application Developer, Solution architect and Designing, Production Support. Matured in IBM Organization from an application developer to Application Consultant.
Employer History
Jul 2010 – Present
IBM Canada Ltd.
Senior Developer & Solution Architect (Cognos)
Aug 2007 – Jun 2010
IBM India Pvt. Ltd
Application Consultant
Oct 2005 – May 2007
3i Infotech Ltd. (Formerly Icici Infotech Ltd.)
Software Engineer
Project Duration:
IBM:
#1 BMO, Canada (Aug 2011 – Till Date)
#2 Telus, Canada (June 2010 – July 2011)
#3 NiSource, USA ( June 2008 – March 2010)
#4 Development Bank of Singapore (DBS), Singapore (Aug 2007 – June 2008)
3I Infotech:
Himalaya Drugs and Pidilite - Oct 2005 – May 2007
Assignment History
IBM -- Project Details:
#1 BMO, Canada (Aug 2011 – Till Date)
I am presently working as Senior Cognos Developer for Capital Market area in BMO. This project involves requirement analysis, Datamodel understanding, planning report design and development of reports and changes in existing reports.
I have worked on Project RAW (Reporting, Analytics and Workflow). The RAW project aims to enhance the timeliness, accuracy and comprehensiveness of Market Risk Analytics and oversight processes. The objective of this initiative is to implement a more robust reporting platform and replace the current reporting application.
Cognos 10 migration was done 6 months back and since then team is mostly working on development of reports in Cognos 10. Previous to that Cognos8.4 was being used in the project.
Client
BMO, Toronto
Role
Senior Cognos Developer
Duration
August 1 2011 till date
Organization
IBM Canada Ltd.
Team Size
12
Tools & Environment Used
IBM Cognos BI Suite 10x/8x- Framework Manager, Report Studio, Query Studio, Oracle10g, Sybase, Unix, Clearcase, Clearquest, Autosys, Data Warehouse Methodology and Metadata Modeling, MS Office Suite - MS Visio, SQL Server 2008, Windows NT/XP.
Tasks Undertaken:
Cognos10 and Cognos 8.4 Report Authoring: It included Creating reports, Enhancing reports, Create reports using the query model, making reports using SQL query and fine tuning SQL query for reports.Gathering Functional Specification Document from the client and Developed complex Reports according to the client requirementInstalled & configured the Cognos BI Environment, Administering the Servers, Troubleshooting, and Performance Tuning.Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.Design and Developed the Framework Manager models using stored procedures, Relational tables and published in to server.Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models.Customizing Cognos Connection Portal based on user specifications.Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down,Drill Up).Worked with Stored Procedure Query Subjects in FM and Reports.Created Drill- through reports & Customized Reports with Prompts (List, Cross tab)Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.Resolving problem related to Cognos application. Datamodel and Datamart analysis.Verification of data at database level.Converting user requirement in form of reports.Creating Mock up reports and coordinate with customer for verification.
Deployment and post deployment testing with the help of user.Changes in existing reports as per requirement.
#2 Telus, Canada (June 2010 – July 2011)
I have worked as a Cognos Solution Architect and Developer. This project involves requirement analysis, Datamodel understanding, planning report design and development of reports and Framework Datamodel.
I have worked on Project ‘Web Channel’ which was an analysis of the Web activities done by user on Telus Website for example Identifying the user login, failure to login, reason to call IVR, Call Centre, number of users created etc. These data captured in our report, is further used by Telus Management to analyze their website and improve it better.
Also I worked on Live Chat Project which again involved analysis of Live Chat option available on Telus Website and how to further improve this facility.
Other projects include Holborn, high level analysis of GOC (Government of Canada) project and I was also involved in QA of Reports and DataModel.
Client
Telus, Toronto
Role
Solution Architect
Duration
June 2010 – July 2011
Organization
IBM Canada Ltd.
Team Size
Tools & Environment Used
IBM Cognos BI Suite 10x/8x- Framework Manager, Report Studio, Query Studio, Oracle10g, Sybase, Unix, Clearcase, Clearquest, Data Warehouse Methodology and Metadata Modeling, MS Office Suite - MS Visio, SQL Server 2008, Windows NT/XP.
Tasks Undertaken:
Cognos Report Authoring: It included Framework Manager Data Modeling, Creating reports, Enhancing reports, Create reports using the query model, making reports using SQL query and fine tuning SQL query for reports, Setup reports for bursting, manage events using agentsAnalyze source system, define data element mapping and design logical data model for DW/BI Reporting.Design, develop & publish metadata model in Cognos Framework Manager.Develop, enhance, customize, and manage professional reports using Cognos FM & Report Studio.Creating a variety of different report types, such as list, crosstab, chart, map, and drill through. Worked on Dashboard and created new Dashboard.Enhance reports by adding calculations, advanced formatting, filtering, and exception data highlighting.Understand business requirements of the customers and translating them to specific technical design document.Define security matrix and Implemented package level object level and data level security in the reports.Prepare deployment packages and plan deployment of Cognos code in SIT/UAT and Production.Prepare Technical Design documents, Unit Test documents & Deployment documents as part of im-lementation.Create Cognos Groups, roles & align members and implement object level security based on security matrix definition.Provide Technical expertise to deliver Effective BI Reporting with bare minimal issues.Interact with Clients and Super users for business and functional requirements, Conduct workshops, meetings and formal training sessions for end users. Create BI user manuals and documentation for various BI applications.Co-ordinate for Design sign off, Roll out and Defect Management.Work as primary resource for production support, defect resolution and tracking for cognos BI applications.Review existing processes to determine opportunities for improvement/efficiency.Cognos Administration: Manage Report Content, Manage the Server Environment, Manage the Security Environment, Scheduling Jobs, Setting up output versions of report.Datamodel and Datamart analysis.Verification of models and data at database level.Converting user requirement in form of reports.Creating Mock up reports and coordinate with customer for verification.Deployment and post deployment testing with the help of user.Changes in existing reports as per requirement.Also involved in package and report review process.
#3 NiSource, USA ( June 2008 – March 2010)
This is a Data Warehouse initiative within the Meter to Cash Transformation project.
The main purpose of the Data Warehouse initiative is to provide the reporting and ad-hoc query capability using Cognos Business Intelligence software and provide a uniform data view on transactional data from DIS, CIS NIPSCO, CIS BayState and GIW.
Client
Nisource,USA
Role
Application Consultant
Duration
June 2008 – March 2010
Organization
IBM India Pvt. Ltd
Team Size
Tools & Environment Used
Meter to Cash, Unix, IBM Cognos BI Suite 8x- Framework Manager, Report Studio, Query Studio, Oracle10g, SQL Server 2008, Unix, Clearcase, Clearquest, Data Warehouse Methodology and Metadata Modeling, MS Office Suite - MS Visio, Windows NT/XP.
Tasks Undertaken:
Resolving problem related to Cognos application.
Cognos Report Authoring
Cognos AdministrationDesign, develop & publish metadata model in Cognos Framework Manager.Develop, enhance, customize, and manage professional reports using Cognos FM & Report Studio.Creating a variety of different report types, such as list, crosstab, chart, map, and drill through. Enhance reports by adding calculations, advanced formatting, filtering, and exception data highlighting.Gather report requirements and build sophisticated reports/dashboards/scorecards, analysis and queries.Understand business requirements of the customers and translating them to specific technical design document.Prepare deployment packages and plan deployment of Cognos code in SIT/UAT and Production..Work with QA group and adhere to quality standards defined for BI reporting.Work as primary resource for production support, defect resolution and tracking for cognos BI applications. Review existing processes to determine opportunities for improvement/efficiency.Monitoring jobs and file load in stage and production.Checking database for correct insertion of data in tables. If data has not been properly loaded them manually loading data in database through UNIX shell script.Removing duplicate records from database which stops data upload in database.Handling enhancements in application at database level.Modifying procedures if they do not catch a particular error.Granting access to users on Cognos.Changing file permission and reloading the file when files are being sent with wrong file permissions.Monitoring jobs and file load in stage and production.Trouble shooting Cognos Jobs in case if fails.Manual reload of file if any job fails.Identifying duplicate records from database when file load fail due to that and getting them correctedPurging the unnecessary Cognos jobs to clear the stream when all the present cognos jobs go into pending status and rerunning them. Maintaining space on MTC application server.Writing UNIX shell script to ftp files from one server to another. Used UNIX commands to check for files and load them manually. Writing UNIX shell script for encrypting and decrypting of file in PGP format for security reason. Modifying UNIX script for file reload to simplify file load process.Monitoring jobs and file load in stage and production.Restarting Cognos services through GUI mode when any patch is being applied.
#4 Development Bank of Singapore (DBS), Singapore (Aug 2007 – June 2008)
Worked on Flexcube Gain and MFA System.
Flexcube is used by overseas branches of DBS bank to perform business functions like processing of trade, payment, fixed deposit, credit administration and finance. Flexcube is an Oracle based banking package. FLEXCUBE application is deployed in CITRIX mode. CITRIX MetaFrame technology is used over Wide Area Network for establishing the client connectivity from overseas branches to the CITRIX application server in Singapore.
Moody’s Financial Analyst (MFA) is the standard financial analysis and credit risk rating tool to aid and accelerate credit evaluation. It can also facilitate risk management. MFA is the 32-bit version of Winfast. Winfast is a vendor package from Moody’s. It is developed using VB with option for data storage. Bank implemented with Oracle Database.
Client
Development Bank of Singapore
Role
Application Consultant
Duration
August 2007 to June 2008
Organization
IBM India Pvt. Ltd.
Team Size
Tools Used
Flexcube, MFA, Oracle, UNIX, Windows 2000, Cognos
Tasks Undertaken:
Worked as Application Consultant, supporting Flexcube System and MFA (Moody’s Financial Analyst).Problem Ticket Analysis and Root Cause Analysis Problem simulation & establishment and Vendor coordination for package code fixResolving problem related to Cognos application.
Cognos Report Authoring
Cognos AdministrationUser coordination, support and query resolutionRequirements analysis, design, development, testing and implementation of custom-built components Problem determination and Root cause analysisCo ordinate with vendor to get fix for error.Generating Debug file and sending to Vendor when needed.Apply fix sent by vendor in test environment and perform testingCo coordinating with user if fix applied and test is Ok.Direct interaction with client on issues and its fixes.Doing data download of production data if needed for testing.Raising CR and all process related activities to apply fix in production.Checking-in sources in clear case and preparing baseline form for the same.Applying fix in production with the help of DBA and doing live Verification with customer.Monitoring batch jobs running for flexcube and handling night calls if any batch job fails.Make system ready for user as per different timing of 5 different overseas branches.Handling problem tickets raised by customer in MFA. Handling problem which arise in BDW and RMG files and correcting them through UNIX commands. Handled RFS in MFA and timely completion of activity as per user requirement. Raising CR for different activities in MFA Raised about 40 CRs for different activities of MFA and Flexcube for eg. Data Download, Opening of Firewall, applying data patch or permanent fix, Key exchange between servers, SCP of files from one sever to another, Implementation of URs.
3i Infotech Pvt. Ltd. Project Details:
ORION (ERP Team)
Orion was an ERP tool mainly used by manufacturing team. It was used by manufacturing company for different business processes like sales, manufacturing, production, Excise, Inventory etc. It used Oracle at back end and D2K in frontend.
Client
Chamundeshwari sugars, Himalaya Drugs and Pidilitte
Role
Software Engineer
Duration
Oct 2005 to May 2007
Organization
3i - InfoTech
Team Size
10
Tools Used
(Forms and Reports), D2k, Windows 2000, Birt Tool, Cognos
Environment
Oracle 9i, Unix
Location
Mumbai, Bangalore/India
Training
Oracle, D2K, Birt Tool
#1 Himalaya Drugs, Bangalore
Client
Himalaya Drugs
Role
Software Developer
Duration
May 2006 to May 2007
Organization
3i Infotech
Team Size
10
Tools Used
D2k, Birt tool, Oracle 9i
Responsibilities:
Preparation of reports and interface form for Himalaya Drugs Company.Handling sales module in client place and implementing ERP.Looking after issues in Client site (Himalaya Drugs Company)Preparation of Forms and Report for Inventory of Himalaya Drugs.Preparation of Forms and Report for Sales department of Himalaya DrugsPreparation of Forms and Report for Production department of Himalaya Drugs Writing script (pl/sql) to upload data from older version of product to new version.Rectifying errors which arise while uploading of data.Writing Procedures, triggers, functions, packages, cursors etc at backend to design logic of forms and reports.
#2 Chamundeswari sugars, Bangalore
Client
Chamundershwari Sugars
Role
Software Developer
Duration
May 2006 to May 2007
Organization
3i Infotech
Team Size
10
Tools Used
D2k, Birt tool, Oracle 9i
Responsibilities:
Worked on Oracle D2K – front-end design and back-end code developmentDatabase skills, Object Oriented Programming and development knowledge.
Good analytical skills and communication skills, ready to learn new skills and believe in team work.Preparation of Forms and Report for Inventory of Chamundeswari sugars.Preparation of Forms and Report for Sales department of Chamundeswari sugarsPreparation of Forms and Report for Production department of Chamundeswari sugarsWorked with ERP team (Functional Domain) and handling sales, finance, TDS, Fixed Assets module of product along with technical work of Report and Form building. Rectified errors in Existing forms and reports as and when they arise. Generating Excel sheet for the reports wherever required.Making changes in existing documents prints as per user requirement.Received training on birt tool to convert reports in excel sheetWriting script (pl/sql) to upload data from older version of product to new version.Rectifying errors which arise while uploading of data.Writing Procedures, triggers, functions, packages, cursors etc at backend to design logic of forms and reports.
#3 Pidillite, Mumbai
Client
Pidillite
Role
Software Developer (Trainee)
Duration
Oct 2005 to May 2006
Organization
3i Infotech
Team Size
Tools Used
D2k, Birt Tool, Oracle 9i
Responsibilities:
Contact this candidate