Manager Project

*

C A R E E R O B J E C T I V E :

To secure a position as a Cognos Reporting/Business Analyst with a well-established organization and utilize my skill set in analyzing business requirements to help the management in organizing and scheduling solutions by developing and implementing a system.

P R O F E S S I O N A L S U M M A R Y :

Over 8+ years of experience data warehousing and in all phases of System Development Life Cycle (SDLC) from the investigation of initial requirements through analysis, Design, Development, Testing, Documentation in various Industries like Retail, Financial Services, Airline, Pharmaceutical, Health Care Services and Power Sector.

Proficient in Enterprise level modeling and complex report development and analysis using Business Intelligence applications like Cognos

Good Knowledge skills and also worked with different databases

Good at closely coordinating with a team of developers, both onsite and offshore based, in multiple concurrent models.

Productive team player, Capable of meeting deadlines, multi-tasking, flexible in work schedules

Quick learning ability, keen analytical skills and excellent communication skills. T E C H N I C A L S K I L L S :

Project Management Tools &

Requirement Gathering

Techniques

Microsoft Project, Brainstorming, Interviews, Workshops, Focus groups Modeling & Requirement

Management Tools

IBM Rational Tools: Rational Rose, Requisite Pro, MS Office Suite: Word, Excel, PowerPoint, MS Visio

Methodologies/Data Modeling SDLC, RUP, Agile, Waterfall, Relational/Dimensional Data Modeling and Star/Snow- Flake Schema Modeling

Languages & Testing Tools C, C++, Linux, Quality Center, Load Runner, Life Cycle Manager 10.2, Metamanager, HP Tools: ALM, JavaScript

Web Applications & Operating

Systems:

Windows 95/98/NT/2000/XP/2003, MSDOS, UNIX, HTML, XML, Salesforce, Innotas, Clear Quest

Mail Servers Lotus Notes, Microsoft Outlook

BI Reporting tools: IBM Cognos Analytics V11, Cognos TM1, Cognos 10.1.1 Mobile, Cognos 10.x Suite (Cognos Workspace, Cognos Workspace Advanced, Cognos Connection, Business Insight, Business Insight Advanced, Life Cycle Manager 10.2, IBM Cognos Administration), Cognos 8.x BI suite (Report studio, Query Studio, Analysis studio, Framework Manager), SAS, Power Play Transformer, Cognos Data Visualizations, Qlikview Databases & ETL Tools: Netezza, Oracle 10g/9i/8i (PL/SQL, TOAD, SQL Navigator), SQL Server 2005/2000 (Stored Procedures, Functions, Database Triggers and Packages) and Informatica Power Center 8.x

P R O J E C T S I N V O L V E D :

Performance Food Group, Richmond, VA February 2016 – Present Day Sr. Cognos Developer / IBM Business Trainer /CRM BSA Performed in-depth analysis of business practices and provided recommendations on ways to improve the process

Planned and conducted requirements elicitation meetings with the business to collect functional and non-functional requirements relating to clients business intelligence tool like IBM Cognos. Aishwarya

Business Analyst/Cognos Reporting professional

Mobile: 484-***-****

Email: *******.*********@*****.***

2

Conducted brainstorming sessions with the development team to actively involve them during the requirements stage analysis.

Serve as liaison between customers and team developers to overcome application issues and maintain established business relationships.

Apply data mining techniques to identify and analyze new and existing data using BI tools like Cognos

Developed Several Reports using Business Insight Advanced/ Report Studio and Query Studio

Prepare training material and provide in-person training, and also training via web conferencing on applications like Cognos

Monitor Salesforce remedy tickets and Innotas tasks to assist with project implementation and control monitoring process related to quality assurance and user-assisted testing.

Attended workshops for Cognos version11 (Cognos Analytics) CHUBB Insurance, Warren, NJ January 2015 – January 2016 Role: Technical Architect

Performed architecture and code review of the existing business model, established development and delivery processes, designed project execution plan

Closely Involved in Requirement gathering and Analysis with customers and designed functional requirement spec’s for the report development.

Reports on Claims - Claims Finalized Summary and Detail, Claims Daily Production, Pended Claims Details, Claims Turnaround, Claims Summary Tracking, Weekly Paid Claims.

Deployed applications from development to QA and then Production servers using Export/Import functionality in Content administration.

Worked on support/issue tickets with IBM

Manually modified the SQL in Report Studio to tune and/or to write complicated reports

Passing the Prompt Parameters in Report Studio reports using JavaScript

Conducted POC’s with the customer to implement the new IBM Cognos Mobile feature.

Researched, resolved and communicated insurance issues to customers and management.

Tested the Active reports on Cognos Mobile 10.1.1 and also on Ipad Associated Banc-Corp October 2014 – December 2014

Role: Cognos developer / Admin / Project Coordinator Coordinated the supportive services between departments through organized daily/weekly meetings

Conducted daily stand-up meetings with the team and documented the discussions.

Conducted JAD sessions with extensive involvement from Business, Development, Testing teams, Architects, SME’s and Managers of various Business Units.

Acted as a liaison between Business and Project Stakeholders to translate User Stories, Wish List items into respective Sprints

Design and developed the Framework Manager Models (Relational/DMR Models) and published the packages to IBM Cognos Connection.

Worked on Cognos Administration in assigning Users, Groups, User Roles with access permissions.

Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.

Created Jobs to Schedule reports in Cognos Connection based on the reports to run daily, weekly basis using Event Studio.

Created Ad hoc reports using Query studio.

Built Portal pages using IBM Cognos Connection

Developed the List Reports, Charts, Drill Through Reports, Master Detail Reports Using Report Studio and Query Studio

Very good understating of using Union, Intersect, Except and Stich queries

Writing the Java Script in Report Studio Reports to display default values in value prompt

Deployed applications from development to QA and then Production servers using Export/Import functionality in Content administration.

Trained users on navigation and creating simple reports in Query studio.

Proficiently helped development teams to break down large user stories for execution. 3

Participated in functional walkthroughs, User Acceptance Testing (UAT), and supervision in the development of user manuals for the client

The Boeing Company April 2012 – September 2014

Role: Cognos Developer / Lead /Admin

Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements

Worked closely with Boeing Focal’s to analyze and understand the business requirements and participated in requirements gathering meetings/ JAD Sessions.

Worked with project teams to design, implement, and test and deploy BI Data Warehouse solutions using the agile methodology.

As a team lead, I manage a group of developers and personally managed security and Framework Manager related development activities.

Extensively worked on Framework Manager, created models and implemented ‘best practices’ while modifying relationships, resolving the loops, and dimensionally modeled relational data (DMR)

Involved in migrating and upgrading from Cognos 8.4.1 to Cognos 10.1.1

Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema

Documented Framework Database view, Business Requirements and other Technical specs for the project.

Experience working on Cognos Administration with expertise in installation, configuration, Troubleshooting and setting up security for Cognos 10.1.1 & Cognos 8.4.1 environments

Customized data by adding the Prompts, Filters, Calculations, Summaries, and Functions & Conditional formatting in Report Studio

Built Portal pages to replace their existing portals in Java

Worked on Cognos Administration in assigning Users, Groups, and User roles with access permissions in Framework model and at Package level.

Created Jobs to Schedule the reports in Cognos Connection based on the reports to run daily, weekly and monthly basis using Event Studio.

Created List reports, Crosstab reports and Charts as per user needs.

Maintained the off shore team and provided support for IBM Cognos 8.4.1 reports.

Created Test Script documents for Unit Testing, Integration Testing (IFT) and User acceptance Testing (UAT) for the reports in Freeze, Preprod and Production environments.

Trained the Program Focal’s to effectively use the reporting tool to build and customize their Ad Hoc Reports. Systems in Motion, MI October 2011 – February 2012 Client: Magellan Health Services, Inc.,

Role: Cognos developer /Admin

Extracted customer information from databases and created reports that meet business requirements.

Involved in full project life cycle implementation (Requirements gathering to production phase).

Interacted with clients, understanding Business Applications, Business Data Flow, Data Relations and ability to quickly master new concepts and Technologies, Strong communication and interpersonal skills.

Built Relational Models using Framework Manager created & published packages to the Cognos Server.

Actively involved in the administration part of Cognos Connection for organizing, security, scheduling and distributing reports.

Understood the existing mainframe reports to replicate them in Cognos Reports.

Coordinated and resolved Data Quality issues for a smooth migration to production/maintenance of Reports to different environments.

Trained power users in Business Insight Advanced and Cognos Insight to use it for ad-hoc/self-service reporting.

Documented Business requirements, Data Mapping and Technical specs for the project. DaVita Inc., Vernon Hills, IL July 2011 – September 2011 Role: Cognos developer

Developed requirements through interaction with business 4

Acted as primary liaison between the client departments and the IT department to perform analysis, review, and estimation for client needs/requirements by conducting Brainstorming/JAD sessions.

Created targeted Questionnaires to gather requirements and prepared Business Requirement Documents (BRD) using Rational RequisitePro.

Assisted technical team to analyze and created Functional Requirement Documents (FRD) and data mapping documents by delivering within project timelines.

Understood a given software project “end-to-end” beginning from business requirements gathering, data architecture and user interface

Used JavaScript on prompts to achieve the functionality as per business needs

Worked with the Business Process Reengineering team, analyzed the existing system and created a detailed To-Do plan.

Developed the List Reports, Charts, Crosstab Reports, Drill Through Reports, Master Detail Reports using Report Studio.

Scheduled reports to run and distribute to the users in a timely fashion depending on their frequency

(daily/weekly/monthly)

Worked on Cognos Administration in assigning Users, Groups, and User roles with access permissions.

Created pages in the Cognos Connection and embedded different portlets, reports in the same page.

Deployed the reports and package from freeze to Pre-prod and Pre-prod to Prod environments using Cognos tool/third party tools.

Communicated change request to Project managers and Change control board for approvals

Perform Quality Assurance of new reports/dashboards based on functional understanding of system, prior to hand-off to UAT team and also, Create test scenarios and test cases in consultation with business team Client: Bharat Heavy Electricals Limited, Hyderabad, India November 2007 – July 2010 Role: Jr. Cognos developer

Built, Tested and deployed scalable, highly available and modular software products

• Added value and quality to projects by consistently meeting deadlines, contributing input at progress meetings, and communicating with vendors, clients and engineering colleagues.

• Facilitated communication and understanding between product owner and technical team in bringing out tremendous amount of system knowledge to discussion

• Designed and created test cases to verify existing software.

• Tested analog and digital circuits for satellite test applications E D U C A T I O N :

Bachelor of Technology in Electrical & Electronics Engineering April 2007 Jawaharlal Nehru Tech. University Hyderabad, India References are available on request.

Contact this candidate