Senior BI Consultant

KRISHNA C BEERAKAYALA

Email: *************@*****.*** Ph: 832-***-****

SUMMARY

Result oriented Technical design developer with 10+ years of experience with Business Intelligence Reporting, Waterfall/Agile Methodologies, Development, Analysis, Testing, and Data Warehousing in IT industry.

Hands on experience of 3.5 years with Cognos 10.2.1, Over 5 years of experience and excellent knowledge in working with Cognos 8 BI Server, 3 years in working with Cognos ReportNet 1.1/1.02, 2 years of experience in Cognos EP Series 7 Tools such as Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, and Analysis Tools such as Cognos Transformer & PowerPlay 7.x/6.x, Oracle 8i/9i, Teradata and SQL Server databases.

Experience in playing a pro-active Business analyst role in interacting with business users, analyzing and documenting requirements, designing, developing, testing and implementing the Cognos Package in an enterprise environment, knowledge in configuration of servers, establishing database connections and Security Administration.

Experience in providing technical and functional consulting to corporate and divisional users for Cognos.

TECHNICAL SKILLS

Reporting Tools

Cognos 10.x, Cognos 8 BI, ReportNet 1.1 MR2/MR3: Report Studio, Query Studio, Framework Manager, Cognos Impromptu 5.2/6.0,7.x, Cognos Transformer & PowerPlay 8.3/8.4, Impromptu Web Reports (IWR), Cognos Upfront,Cognos Query, Cognos Visualizer, Cognos Scheduler, Cognos Architect, Cognos Maps, Cognos PowerPlay Enterprise Server, SSRS, Business Objects

Data Modeling

Star-Schema Modeling, Snowflakes Modeling, FACT and dimension Tables

ETL Tool

Informatica, SQL, DTS

RDBMS

MS SQL Server 6.5/7.0/2000/2008,2012,Oracle 8i/9i/10g, MySQL, MS Access 97/2000, Teradata, Netezza

Languages

PL/SQL, SQL*PLUS, PL/SQL, T-SQL

Web Technologies

HTML, JSP, ASP, XML, PERL, CGI, Shell script

Operating Systems

Windows 9X/NT/2000/XP/7/8, Unix, Linux

EDUCATION

Bachelor of Engineering from Nagpur University, INDIA.

Masters in Computer Engineering, University of Houston, Clearlake, TX.

CERTIFICATIONS

IBM Cognos 8 BI Author – Cog112

Cognos Certified in Reportnet 1.1 Product User.

Cognos Certified in Reportnet 1.1 Advanced Authoring.

Cognos Certified in Reportnet 1.1 Metadata Modeling.

Cognos Certified in Reportnet 1.1 Administration.

PROFESSIONAL EXPERIENCE

Client: Experian Consumer Services, CostaMesa, CA Jul 13 – Current

Position: Senior Cognos BI Consultant

Experian Consumer Services (ECS) delivers online credit reports, credit scores, identity protection and credit monitoring products to consumers all across the United States. ECS products promote greater financial health and opportunity among consumers by enabling them to understand, manage and protect their personal information.

Responsibilities:

Worked as a liaison between Business and Database Engineering teams and helped translate business requests into technical reporting requirements.

Worked in an Agile Environment, actively participated in grooming sessions for requirements, and helped drive the BI team to re-strategize for better time optimization with retrospective sessions.

Designed new Framework models implementing best practices, used Report Studio to develop advanced reports to satisfy business needs.

As a daily role, helped the Bus Ops and Finance teams make insightful business decisions by delivering ad hoc data extracts with extensive SQL coding including loading data into temporary tables, implemented business rules via Informatica in co-ordination with the ETL team, assisted in verifying accuracy of data, supported QA.

Environment: Cognos 10.2.1, Cognos 8.3 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio), Windows 7/8, Sql Server 2008/2012

Client: DIRECTV, El Segundo, CA Mar 11 – Jun 13

Position: Cognos BI Consultant

DIRECTV is the leading direct broadcast service provider and broadcaster in the United States. Its satellite service transmits digital satellite television and audio to households. The BI Enterprise performance management team provides key reporting solutions and data analysis to various internal departments like Finance, Sales, Offers and Marketing which help them in their decision making process and enable them to explore and implement new ideas to promote growth.

Responsibilities:

Helped to create a default reporting template on Cognos report studio to standardize all Directv BI enterprise performance management governed and developed reports.

Developed high visibility dashboards for various projects containing key performance indicators and graphical representation of data to track sales and revenue trends. Designed financial reports which track actual vs. plan data across various segments.

Worked with the Business System Analyst team to design and implement business friendly framework models to promote self-service among business power users and provided them with cross functional training to effectively leverage the models for ad hoc reporting needs.

Involved in coding/debugging complex SQL queries in Teradata for data analysis, ad hoc requests for data extracts and report development.

Environment: Cognos 10.1.1, Cognos 8.3 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Powerplay Transformer), Windows 7/XP, Teradata 14.01

Client: Experian Consumer Direct, Irvine, CA Aug 09 – Jan 11

Position: Cognos Reporting Engineer

Experian Consumer Direct (ECD) delivers online credit reports, credit scores and credit monitoring products to consumers all across the United States. ECD products promote greater financial health and opportunity among consumers by enabling them to understand, manage and protect their personal information.

Responsibilities:

Defined user interfaces and functional specifications, worked with business to understand and document the requirements (BRD) prior to development. Trained end users to promote self service with ad-hoc reporting.

Created new User accounts on Access Manager, worked on creating and defining various groups and roles on the Cognos Portal to streamline user access.

Designed new Framework models implementing best practices, created multi dimensional models using 8.2 Transformer, used Report Studio to develop advanced reports to satisfy business needs.

Implemented business rules via SQL stored procedures in co-ordination with the ETL team, verified the accuracy of data with extensive unit testing.

Environment: Cognos 8.2 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Powerplay Transformer), Windows 2000, SQL Server 2005/2008.

Client: Merial Inc, Duluth, GA April 08 – Jul 09

Position: Cognos Consultant

Merial Inc. manufactures pharmaceutical products and vaccines for livestock, pets and wildlife. The Business Process Transformation project (BPT) involved implementing a new ERP system consolidating various business operations, and create a standardized reporting environment over the data warehouse.

Responsibilities:

Actively involved in interacting with business users, worked on technical design documents to make sure all the business requirements are addressed from a functional perspective.

Developed Multi dimensional models using 8.4 Transformer, designed and published packages to re-place existing IQD based data sources on transformer models with Framework manager query subjects.

Implemented security on Cognos Connection for cubes and reports, created user groups and assigned roles, worked with multiple data source connections, managed and ran jobs and events on Cognos connection.

Helped modify and tune back-end SQL for ETL process.

Environment: Cognos 8.2/8.3/8.4 BI (Framework Manager, Report Studio, Powerplay Transformer), Windows NT, Oracle 9i/10g.

Client: UPS Supply Chain Solutions, Alpharetta, GA Apr 07 – Mar 08

Position: Cognos Consultant/ Developer

UPS is a global leader in supply chain services. Its business unit, UPS Supply Chain Solutions, offers transportation and freight services, and international trade services. The Cognos reporting solution involved either developing a complex PL/SQL /SQL code for the reports, or leverage a catalog / model-package.

Responsibilities:

Developed technical design documents from the business requirements for every report.

Worked on data models using Framework Manager and deployed packages onto Cognos Connection.

Developed reports based on user requirements from Business Support users, both in Reportnet and Impromptu 7.0. Worked with Power prompts in IWR reports, HTML and Java scripting on Report studio. Involved in migration of Reports, Catalogs and model packages into the new Cognos 8 BI environment,

Created standard templates for training internal and end users on Cognos Connection, worked with the QA team to ensure compliance with all regulatory requirements.

Environment: Cognos ReportNet 1.1 MR3(Framework Manager, Report Studio),Cognos Impromptu 7.0, Windows NT, Cognos BI Server 8.1MR1, Oracle 9i.

Client: Amgen Inc, Thousand Oaks, CA Sep 06 – Jan 07

Position: Cognos Consultant/ ReportNet Developer

Amgen is a leading human therapeutics company in the biotechnology industry. The Project involved developing complex reports for the Amgen Libraries department. Used Cognos as front end and SQL Server as back end to develop and publish web reports.

Responsibilities:

Developed data models using Framework Manager and deployed packages onto Cognos Connection.

Developed reports based on user requirements from Business Support users both for standard reporting and ad hoc requests using Query Studio, worked on reports using Filters, Charts, Lists, Cross tabs & Nested Cross tabs in Report Studio.

Setup and Maintained security for the BI Models and Reports, bursted reports to multiple recipients in different formats like PDF, html and excel according to the user requirements in Cognos Connection.

Involved in Training end users in Cognos Connection and Query Studio.

Environment: Cognos ReportNet 1.1 MR3 (Framework Manager, Query Studio, Report Studio), Windows NT, MS SQL Server 2000.

Client: Caterpillar Inc, Peoria, IL Jan 06 – Aug 06

Position: Cognos Consultant/ ReportNet Developer

Caterpillar is the world’s leading manufacturer of construction and mining equipment. The Global IT solutions department formulated the project to convert People soft SQR reports to Cognos Reportnet. The project also involved an upgrade to the Cognos 8 environment.

Responsibilities:

Published packages from Framework Manager to Cognos connection for report creation, worked on multilingual packages, involved in migrating existing cognos series 7 cubes and reports to Cognos 8.

Created Users, User Classes and Database Sign-ons in Access Manager, worked on scheduling and distributing Reports through Schedule Management in Cognos Connection.

Involved in creating multidimensional cubes using PowerPlay Transformer, tuned power cubes for reducing the time consumption by Auto partitioning and by using multiple IQD’S, created Drill-Through reports from PowerPlay to ReportNet.

Worked on creating and analyzing the complex reports including calculations, Prompt pages and Conditional Variables.

Environment: Cognos ReportNet 1.1 MR3/MR1 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Transformer 7.x, PowerPlay 7.x, Impromptu, PowerPlay

Enterprise Server 7.1, Access Manager, DB2 and Windows NT/2000.

Contact this candidate