Cognos developer
Resume:
JAYASREE CHUKKALA
SENIOR BI DEVELOPER
PROFILE SUMMARY:
IBM Cognos 10 certified with 8+ years of experience in Business Intelligence, Data warehouse Life Cycle. and has a proven track record in designing, developing, and delivering user friendly BI solutions that maximize IBM Cognos capabilities and utilize industry best practices.
Result oriented and a business savvy professional with specialization in IBM Cognos BI design and report / dashboard development, testing and analysis.
Unique expertise to design and develop well rounded plan solutions that consider future impacts/risks and help clients best achieve their goals.
HIGHLIGHTS:
Expertise on various on BI Technologies such as Cognos BI,Cognos TM1,SSIS(DTS packages), Tabelau,SQL
Expertise in creating Reports,Dashboards, Data visualizations using Tableau
Experience in developing various kinds of Gobal and International Operational Reports using BI tools
Expertise in Installing and configuring Cognos BI tools
Experience in creating ETL Mappings using tools SSIS
Expertise in performing QA activitieslike performance testing for Reports
Expertise in writing SQL Queries for Performance tuning and Testing of BI Reports,
Expertise in testing the reports against database by writing sql queries to reflect business logic of the reports and validate the reports against reporting requirements and KPI’s.
Involved in various estimation of proposals in pre-sales support activities
Highly capable to adapt new application environment and also to trace and remove bugs of existing applications
Excellent communicator with emphasis on building strong client relationships, capable of making professional presentation and negotiations skills.
EDUCATON:
Bachelor of Technology (Computer Science) 2004 – Jawaharlal Nehru Technological University, Hyderabad, Andhra Pradesh, India.
CERTIFICATIONS
IBM Certified Designer Cognos 10 BI Reports
IBM Cognos 10 BI Multidimensional Author
IBM Cognos 10 BI Metadata Model Developer
EXPERIENCESNAPSHOT:
INDUSTRY EXPERTISE
TOOLS
TECHNICAL SPECIALIZATIONS
Healthcare
Pharmaceuticals
Industrial
Tele Communications
Sales
IBM Cognos BI
IBM Cognos TM1
Tableau
SSIS
SQL
Oracle
WORK EXPERIENCE:
PROJECT DESCRIPTION:
EDUREKA JAN 2017 – Till Date
TABLEAU DEVELOPER/ANALYST (Training & Development)
Developed Tableau visualizations and dashboards using Tableau Desktop.
Developed Tableau workbooks from multiple data sources using Data Blending.
Access and transform datasets through filtering, grouping, aggregation, and statistical calculation.
Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
Utilized Tableau server to publish and share the reports with the business users.
Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
TECHNOLOGY EMPLOYED: Tableau Desktop 10.4, Tableau Public 10.4, Tableau Online 10.4, Tableau server10.4, SQL Server 2008.
PERFICIENT@ VITAMIN SHOPPE, NJ JAN 2016 – JUNE 2016
SENIOR BI REPORT DEVELOPER / DATA ANALYST
PROJECT DESCRIPTION:
The Vitamin Shoppe is New Jersey-based retailer of nutritional supplements. The Vitamin Shoppe's retail stores and online sites carry a line of nutritional supplements with supplementary lines. To maintain the sales information, current project source system is Sterling OMS. Data is floating from sterling OMS to Oracle database and Oracle to Adaptive Warehouse application, from adaptive warehouse application to cognos reports.
RESPONSIBILITIES
Understand business requirements and translated into IT solutions with the use of Adaptive Warehouse application and IBM cognos BI 10.2 suite.
Based on change requests, added new fields and calculations to the adaptive warehouse application.
Fixed all Filter issues and WTD, MTD, QTD and YTD issues in adaptive warehouse Application, as well as in reports.
Tested the reports against database by writing sql queries to reflect business logic of the reports
Tested and fine-tuned Cognos reports
Support and coordinate with project teams and business stakeholders for timely delivery of execution.
Moving/deploying reports from Development to testing and production servers using Content Administration
Wrote SQL Queries for data Validation and data Analysis to validate the reports against reporting requirements and KPI’s.
Documented all procedures and process during the project
TECHNOLOGY EMPLOYED: IBM Cognos BI 10.2, Sterling OMS, Oracle 10g, Adaptive Warehouse application
UNIVERSITY OF CHICAGO, CHICAGO IL JULY 2015 – DEC 2015
SENIOR BI REPORT DEVELOPER / DATA ANALYST
PROJECT DESCRIPTION:
University of Chicago encompass a wide range of fields of inquiry spanning the basic biological sciences and clinical disciplines. Our basic, translational, and clinical research enterprise is characterized by a fundamental commitment. She is responsible for developing the cognos BI Framework manager model and cognos reports for Center for Research Informatics (CRI) reporting as well as rational team concert reporting. Set up the basic user security groups in cognos administration.
RESPONSIBILITIES
Prepared Technical specs based on functional specs and verified with business stakeholders to make sure the current requirements are being met and to track the requirements in each phases of the project.
Developed all Framework manager models for biological sciences division.
Created all Cognos BI reports for biological sciences division data.
Created all the CRI reports as well as rational team concert reports.
Created all user groups and set up a user security in cognos environment.
Tested the reports against database by writing sql queries to reflect business logic of the reports
Performed Report Data Analysis and fixed all report data issues.
Worked with Business analysts and QA analysts closely to fix the report related issues.
Documented all work done during the project
TECHNOLOGY EMPLOYED: IBM Cognos BI 10.2.2, SQL Server 2008, Oracle 10g, IBM DB2
TAKEDA PHARMACEUTICALCOMPANY LIMITED, CHICAGO IL FEB 2015 – JUNE 2015
SENIOR BI REPORT DEVELOPER / DATA ANALYST
PROJECT DESCRIPTION:
Takeda Pharmaceutical Company Limited is a Japan-based company engaged in the pharmaceutical business. Takeda partially reorganized to combine its commercial operations into an organization called Chief Commercial Office (CCO). It also combined its global R&D operations into an organization known as Chief Medical & Science Office (CMSO).Takeda initiated Project Ascend to address the need for consistency in the financial planning process. Perficient was selected by Takeda to drive implementation of IBM Cognos TM1 and IBM Cognos Microsoft excel (CAFÉ 10.2.2) for the Takeda Project Ascend to standardize financial process and data structures, replacing the myriad of planning tools.
RESPONSIBILITIES
Gathered requirements from various TM1 architects to full fill the requirements of CAFF reports
Translated Requirements into Technical design documents
Created Dynamic Reports from Worksheets and Cube views using different functions
Created various IBM Cognos Microsoft Excel CAFÉ reports from TM1 consolidation cube
Performed all testing and validations on reports and tracked all the issues with “JIRA” tool
Coordinate with project teams and business stakeholders for timely delivery of execution
CAFÉ technical training was given to business users
All technical referral documents are created
TECHNOLOGY EMPLOYED: IBM CognosTM1 10.2.2, IBM Cognos Microsoft Excel (CAFÉ 10.2.2),TM1 Web, TM1 Perspectives.
PPG INDUSTRIES, CLEVELAND OH NOV 2014 – JAN 2015
SENIOR BI REPORT DEVELOPER / DATA ANALYST
PROJECT DESCRIPTION:
The project was based on building a common sales repository for a division of PPG's Architectural Coatings of North America. The repository built is trusted source for sales reporting and analysis across multiple channels such as Dealers, National Accounts, and Stores; Stores includes PMC. It has provided a central hub for other systems that require sales information.
RESPONSIBILITIES
Worked with end users, business analysts, and project managers to define reporting requirements
Based on change requests updated the framework manager and reports.
Created and enhanced various Reports in Cognos
Specific order and formats are adjusted on reports to get the result on different formats
Followed best practices for Framework Manger enhancements and reports
Developed new reports and validated all reports
Extensively worked on all reports related issues and fixed all report related issues
Worked on deploying Jobs, Packages and Reports to prod environment
Created Formatting standard document
TECHNOLOGY EMPLOYED: IBM COGNOS BI 10.2.1, Report Studio, Framework Manager, SQLServer 2008 R2.
ABBVIE, CHICAGO IL July 2013 – Oct 2014
SENIOR BI REPORT DEVELOPER / DATA ANALYST
PROJECT DESCRIPTION:
AbbVie is a proven pharmaceutical leader and the focus and passion of an entrepreneur and innovator. The result is something rare in health care today – a global pharmaceutical company that has the ability to discover and advance innovative therapies and meets the health needs of people and societies around the globe. She is a senior Cognos developer working for HUMIRA Commercial, LBE, HQPSand DSO and BS sales projects.
RESPONSIBILITIES
Prepared Technical specs based on functional specs and verified with business stakeholders to make sure the current requirements are being met and to track the requirements in each phases of the project.
Created dynamic reports from worksheets and cube views using different functions
Created and published models for cognos TM1 cubes using cognos framework manager
Created various complex reports using report studio
Automated prompted refreshes by implementing a logic in reports
Used conditional styles to highlight the data in different colours
Performed data analysis to validate the reports against reporting requirements and KPI’s.
Tested all reports and tracked all the issues with “JIRA” tool
Fixed all report related issues.
Coordinate with project teams and business stakeholders for timely delivery of execution
Moving/deploying reports from Development to testing and production servers using Content Administration
Documented all the procedures and process.
TECHNOLOGY EMPLOYED:IBM COGNOS BI 10.2.1, Report Studio, Framework Manager, CognosTM1 10.2.1, TM1 Web, TM1 Perspectives.
BCBS (BLUE CROSS BLUE SHIELD), BOSTON, MA DEC 2012 – JUNE 2013
SENIOR BI REPORT DEVELOPER / DATA ANALYST
PROJECT DESCRIPTION:
Blue Cross Blue Shield of Massachusetts is high-quality, affordable health care they expect and deserve. The current process for the production of the Practice Pattern Variation Analysis (PPVA) report utilizes individualized processing to develop multi-layer reporting for numerous ETG conditions and corresponding measures. The ETG PPVA project is an initiative of BCBSMA to systemically make the process of reporting dynamic while maximizing efficiency on Health Care Services (HCS) Performance Measurement and Improvement (PM&I) resources. She is a senior cognos developer for PPVA_ETG project. She is responsible for development of 4 ETG conditions in FM as well as in report development in IBM Cognos 10.1.1.
RESPONSIBILITIES
Worked with end users, business analysts, and project managers to define reporting requirements.
Created highly customized reports in Cognos Report Studio and ad- hoc reports in Query Studio.
Developed List Reports, Cross tab Reports, Charts and Drill through reports using Report Studio.
Created Dash Boards for multiple views of Reports in same Report page.
Created and Published Packages using Framework Manager.
Tested all reports and tracked all the issues with “JIRA” tool
Fixed all report related issues.
Performed data analysis to validate the reports against reporting requirements and KPI’s.
Tested the BI reports and done the user acceptances.
Moving/deploying reports from development to testing and production servers using Content Administration.
Documented all the procedures and test cases validation.
TECHNOLOGY EMPLOYED:IBM COGNOS BI 10.1.1, Report Studio, Framework Manager, SQLServer 2008 R2.
HALL STAR INC, CHICAGO IL OCT 2012 – NOV 2012
SENIOR BI DEVELOPER / DATA ANALYST
PROJECT DESCRIPTION:
The HallStar Company, we pride ourselves on delivering customized, cost-effective solutions for our customers. Our focus is on addressing our customers’ unique needs and in doing so HallStar will remain at the forefront of ester chemistry, an ever-changing industry. She is responsible for development work for all the reports in Cognos 8.4.
RESPONSIBILITIES
Gathered and analysed the business requirements from end users and project managers to define reporting requirements and translate into IT solutions with the use of IBM Cognos BI suite.
Recreated FM models in Framework Manager based on existing catalogues
Re-created various reports to meet client standards
Worked change requests for DMR reports
Wrote SQL Queries for data validation and data analysis to validate the reports against reporting requirements
Worked on Event Studio reports.
Updated reports with new Framework manager with new database SQL server 2008 R2.
With SQL Server 2008 R2 database, validation has done for all Hall Star GLOBAL data reports
Worked on report related issues and data issues.
Documented all the procedures and test cases validation.
TECHNOLOGY EMPLOYED:IBM COGNOS BI 10/8.4, Report Studio, Framework Manager SQLServer 2008 R2.
REYES HOLDINGS, CHICAGO IL JUNE 2012 – SEP 2012
SENIOR BI DEVELOPER / ANALYST
PROJECT DESCRIPTION:
Reyes Holdings, aligned with leading local and global brewers and foodservice providers, delivers the best-known brands and widest variety of food and beverage items to retailers around the world. The company is comprised of three divisions: The Martin-Brower Company, Reyes Beverage Group and Reinhart Foodservice. She analysed needs, for new version of SQL server 2008 R2 upgrade to test the Transformer cube reports.
RESPONSIBILITIES
Gathered and analysed the business requirements from end users and project managers to define reporting requirements and translate into IT solutions with the use of IBM Cognos BI suite.
Tested all cube builds data and the reports against database by writing sql queries to reflect business logic of the reports
Performed report data analysis and presented all cube data issues and report data issues to the development team for issues resolution.
SQL Server Upgrade to SQL Server 2008 R2 Validation done for all Martin-Brower dashboard reports and general Ledger reports.
Documented all procedures and process.
TECHNOLOGY EMPLOYED:IBM COGNOS BI 10/8.4, Report Studio, Query Studio, AnalysisStudio, Framework Manager, Cognos Transformer 7.3, Decision Stream and SQL Server 2008 R2.
AMERICAN EXPRESS, HYDERABAD, IN NOV 2006 – JUN 2009
SENIOR BI REPORT DEVELOPER / DATA ANALYST
PROJECT DESCRIPTION:
This project is to provide the wider Global Information Services (GIS) organization with an understanding of both the current position and future aims of TSD with regard to the planning and execution of Cognos reporting projects. Cognos is currently deployed for the American Express (AMEX) Remote Account Management (RAM), Cisco programs located in the United Kingdom (UK) Contact Centre and it is also deployed for Orange Flexible Partnerships (Orange) program located in the Atria Contact Centre, India. Orange report on telecoms data held on an external switch, which is provided by the client as quarter-hourly flat files as similar to Cisco client. These are imported to tables in our “Client” SQL Server database.
• Amex RAM report on data from our CIDS customer contact system. Data from the Oracle production database is passed into a SQL server reporting database, containing highly customized tables of data, based on the particular requirements of RAM, located on NEWDW08.
• Cisco report on telecoms data held on an external switch, which is provided by the client as quarter-hourly flat files. These are imported to tables in our “Client” SQL Server database.
RESPONSIBILITIES
Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location
Gathered the various reporting requirements from the business analysts.
Build sophisticated reports/charts/scorecards, analysis and queries using Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio.
Involved in writing multiple DTS packages in SQL Server (SSIS, SSAS) for Data Transformation from one database to another Database as per the key business requirements.
Design and develop metadata model in Cognos Framework Manager and published packages.
Created Physical layer, Dimensional layer and Business layer in Framework manager.
Worked in the creation of Dimensional Modelling in Framework Manager by creating Regular dimensions and Measure dimensions.
Worked on reports for performance Tuning, Scheduling, changing environment variable settings and other admin related activities.
Wrote SQL Queries for data validation and data analysis to validate the reports.
Performed testing to validate the reports generated and ensured the required KPI’s were met in the generated reports.
Upgraded the existing packages and reports from Cognos Report net to Cognos 8.2 and developed new reports and build new frame work models in Cognos 8.2.
Worked extensively on Performance tuning of the reports.
Provided production support, user training and documentation.
TECHNOLOGY EMPLOYED:IBM COGNOS BI 8.2 (Report Studio, Query Studio, Analysis Studio) Framework Manager, SQL, SQL Server, and Oracle.
CONVERGYSCONTACT INTERACTION MANAGER, HYDERABAD, IN MAY 2005 – OCT 2006
PROGRAMMER / ANALYST
PROJECT DESCRIPTION:
This is based on SCRUM model. We have been working to make the functionalities generic across all the clients. We have taken Interactive soft works which is based on three tier architecture. The first tier belongs to the interactive server where all the generic application logic reside and also responsible for managing the servers and services. The second tier service manager is responsible for the performance of the different services, load balancing and reliability. The last tier contains Metaphor interaction studio and Enterprise Manager. Metaphor interaction studio is where the entire GUI is build and all the business logic will be implemented here. The Enterprise Manager is responsible for creating logs, configure and maintain servers, conducting stress tests on different services.
Features of this Project:
It is a collection of independent services that offer flexibility in developing the applications.
As it is a collection of independent services, it is developed on the basis of SCRUM model which is very effective.
It is based on a three tier architecture which simplifies the distribution of Business logic and application logic, which in turn, the application logic can be separated as a separate service and then be used in other workflows.
The interactive server supports log views and stress tests which enable to know about the performance of the services, servers and load balancing.
RESPONSIBILITIES
Requirements gathering and system analysis.
Developing web services, testing them and deploying them on the interactive server
Performing stress tests and creating logs based on the statistics.
Creating work flows referencing the web services deployed on the interactive server
Performed Unit testing to test the developed code.
TECHNOLOGY EMPLOYED:VS 2005, C#.Net, Oracle, Windows NT, Interactive Soft works
Contact this candidate