Anilkumar cheyreddy

ac9lqj@r.postjobfree.com

Mob no: 704-***-****

Summary:

Around 11 years of experience in Development of Business Intelligence Reports, extensively into data warehousing applications using IBM Cognos BI &Tableau

Exceptional understanding of Business Intelligence and Data Warehouse concepts

Having good knowledge of Data Modeling Concepts (Normalization, Star Schema, and Snowflake Schema).

Solid understanding of transactional, relations and multi-dimensional databases

Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.

Provided technical team leadership support for the full systems development lifecycle (SDLC) Data Warehouse.

Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages), Security, Packages and Complex Report building with Report Studio.

Expertise in Cognos BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio, Business Insight, Active Reports and SQL.

Ability to work collaboratively and understanding of business requirements and system architecture

Strong analytical, problem-solving and organizational skills. Ability to handle multiple tasks and assignments concurrently in cross-functional teams and a flexible team player able to communicate with all levels of personnel.

Worked on functional domains like Finance, Banking, P&C Insurance and Telecommunications &Sales.

Education

M.C.A (Master of Computer Application) From Nagarjuna University, AP, passed out in the year 2007.

Certifications

IBM Certified Developer - Cognos 10 BI Metadata Models.

Tableau Certified Developer – Tableau Desktop Specialist & Qualified Associate.

Alteryx Certified Developer – Alteryx Designer Core

Experience:

Worked as a Senior BI Consultant for Premier Corporate Services from Sep’16 to April’19 date

Worked as Module Lead for Mphasis, Bangalore from Dec’14 to Apr’16.

Worked as Technical Lead for Wipro, Bangalore from Jan’14 to Nov’14 date.

Worked as Consultant for CSC, Hyderabad from Jan’13 to Jan’ 14.

Worked as Senior Software Engineer for NIIT Technologies, Noida from Nov’ 11 to Dec 2012.

Worked as Software engineer for Innvectra, Hyderabad from June 07 to Oct 2010.

Technical Skills:

Diagnostic Tool

Oracle SQL Developer,

Databases

Oracle, DB2, SQL Server, Teradata

BI/ETL Tools

Cognos 8.4, 10.1, 10.2 & IBM Cognos Analytics V11, tableau 9.2, SSIS, Alteryx Designer

Methods

Scrum and Agile, Waterfall

Web Technologies

HTML, Java Script

Data Retrieval

SQL

Professional Experience:

1. Amdocs-Program Spring BCC Oct 16 to April 19

Client: Amdocs, Missouri

Skills: Cognos BI 10.2.1, Cognos Framework Manager, Tableau, Oracle, Moto PI.

Role: Senior Cognos/Tableau BI Developer.

Responsibilities:

Worked closely with Business Analyst to understand the business requirements and discuss about the KPIs.

Operational Report (OPS) Analyst/ODS developer with technical skill set as Cognos.

Create user guide, conduct user training and demo of solutions / tools

Provide user support, guidance and troubleshooting on reports and dashboards

Created Groups& Users and implemented data level security & Package level security as per the business requirement.

Create data visualization (reports and dashboards) using techniques for guided analytics, interactive dashboard design and visual best practices.

Experience in security administration, design and setup of authorization and user management

Analyze, estimates, design, development, testing, and production roll-out of data visualization and reporting projects.

Collaborate with stakeholders, providing guidance and analysis, helping identify and escalate issues/risks/dependencies and facilitating communication across teams.

Working with multiple systems and merging data from multiple data sets, including filed input and management assumptions to create clear reporting, that can be communicated to stake holders.

2. Liquidity Risk Infrastructure (LRI). Dec 14 to April 16

Client: JP Morgan Chase, New York.

Skills: Cognos BI 10.1.1, Cognos Framework Manager, Sql Server.

Role: Module Lead.

Responsibilities

Involved in requirements gathering and FRS preparation and getting it sign-off from Client.

Generating various reports List Reports, Cross-tab Reports, Chart Reports.

Created Drill- through reports, Master detail reports.

Created reports like 5G reports, stress reports, cross reporting and LCR Reports

Worked on both support and development of new reports, and report enhancements.

Created Adhoc Reports using Cognos Workspace Advanced.

Created Portal Usage report which consists of information regarding usage of Cognos reports in LRI reporting portal.

Worked with the UAT and SIT teams for a detail level of testing.

3. CVM Consultancy Jan 14 to Nov 14

Client: Ooredoo, Kuwait.

Skills: Tableau Desktop, Cognos, Teradata.

Role: Senior Cognos/Tableau Developer.

Responsibilities

Involved in all phases of application software lifecycle (SDLC) including design development, testing and deployment

Worked in tableau environments to create dashboards-weekly, monthly and daily reports in tableau desktop and publish them to server

Developed story telling dashboards/visualizations in tableau desktop and published them to tableau server which allowed end users to understand data on fly with quick filters to filter the needed information.

Created custom hierarchies to meet the business requirements.

Experience in connecting and extracting data from different data sources.

Data blending to create views combining data from multiple data sources

Expertise with creating solution driven views and dashboards by developing different chart types including Line Charts, Bar Charts, Pie Charts, Scatter Plots, Histograms, Tree Maps, Heat Maps, Area Charts, Gantt Charts, and Bullet Graphs in Tableau Desktop.

Implemented Tableau features such as parameters, table calculations, sets, groups, user filters.

4. TQ and Archer Reporting. Jan 13 to Jan 14

Client: Genpact. India

Skills: Cognos BI 10.1, Cognos Framework Manager, Sql Server, Oracle.

Role: Technical Lead.

Responsibilities

Involved in requirements gathering and FRS preparation and getting it sign-off from Client.

Created Design, Deployment Documents and deployed the Code to Production environment.

Involved in designing model, created packages and published them to report users

Created standard reports using Report Studio like list, crosstab and Chart reports

Created reports using Cascading Prompts and Applied Conditional Styles to highlight Data on the Report.

Worked on creating reports using Conditional blocks and render variables.

Worked on creating reports using repeater tables and page breaks.

Created Summary reports, which consists of drill through to Detail report.

Coordinating the deployment and validation. Post deployment support.

Worked with the UAT and SIT teams for a detail level of testing.

5. ESM Reporting and Performance Management Nov 11 to Jan 12

Client: BHP Billiton, Manulife Rio Tinto, GE Japan.

Skills: Cognos BI 8.4, Cognos Framework Manager, Sql Server.

Role: Senior Cognos Developer.

Responsibilities

Created standard reports using Report Studio like list, crosstab and Chart reports

Accountable for all Cognos deliverables (Development & Support) from offshore.

Created drill through report, which consists of drill through from summary to detail.

Created reports using Cascading Prompts and Applying Conditional Styles to highlight Data on the Report.

Worked on creating reports using Conditional blocks and render variables.

Worked on creating reports using repeater tables, master detail reports and also involved in report bursting

Involved in designing model, created packages and published them to report users

Created service level reports, customer reports and operational reports for multiple Clients.

Created Events and scheduled reports based on event condition.

Involved in Job creation, monitoring and scheduling of existing reports.

6. Operational reporting & Performance management June 07 to Oct 10

Client: Bankers Financial Corporation, Florida.

Skills: Cognos BI 8, Oracle, DB2.

Role: Cognos Developer.

Responsibilities

Created standard reports using Report Studio like list reports, cross tab reports

Created Rate Analysis Tool, which includes 21 measures like PIF RE, PIF NB, DWP, DEP, EXP, paid losses, Case reserves and open, closed Counts.

Involved in Creating Claim Management Tool Which Consists of Claim Count, YTD Conversion and Claim Details for Monthly, Year basis with drill through from Summary to Detailed.

Created Claim Work tool report, which consists of drill through from summary to detail.

Created NB Inspection Report and Inspection Renewal Report these reports will run every day based upon the event Condition and the outputs mailed to external agencies by default.

Worked on conditional formatting by creating variables.

Developed reports using dynamic sorting and using conditional blocks.

Contact this candidate