SUMMARY:

• Around 10+ 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 life-cycle (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.

TECHNICAL SKILLS:

Diagnostic ToolOracle SQL DeveloperDatabases: 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:

Confidential

Skills: Cognos BI 10.2.1, Cognos Framework Manager, Oracle, Motio PI.

Senior Cognos 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.

Confidential

Skills: Tableau Desktop, Cognos, Teradata.

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.

Confidential, New York.

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

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.
• Providing solutions for the new requirements and change request
• 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 and Cognos Cafe.
• Created Portal Usage report which consists of information regarding usage of Cognos reports in LRI reporting portal

Confidential

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

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.

Confidential

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

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.

Confidential, Florida.

Skills: Cognos BI 8, Oracle, DB2.

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.