PROFESSIONAL SUMMARY:

• Highly Skilled Professional with Seven + Years of experience as a Data Analyst and BI Consultant with Tableau, Cognos BI Tools such as Cognos Report Studio, Framework Manager and Analysis Tools such as Cognos Transformer &PowerPlay.
• Expertise in Upgrading ReportNet to Cognos 8 BI and Cognos8.4 to 10.1.2 and Cognos 10.1.2 to 10.2.2 .
• Involved in Cognos Administration and Data Migration process between different versions of Cognos.
• Experienced in building Analytical Queries and reports to support the business requirements.
• Experienced in designing Data Flow, process flow, technical specs, and business specs.
• Strong background in building Metadata models using Framework Manager and Dimensional Modeling.
• Extensively worked on developing various kinds of reports in Cognos 8 Report Studio, Analysis Studio and Query Studio.
• Extensively worked on Power Play Transformer for building up of Multidimensional Cubes.
• Experienced in developing Dashboards Reports in Cognos 8 based on OLAP Cubes designed on Cognos Transformer and MSAS Report Studio using MDX Functions.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level, and data level security.
• Setting up domain groups and assigning access rights to users and groups using the Cognos Server tools linked to standard LDAP.
• Involved in modeling the Data. Expertise in tuning up the database queries.
• Experience in writing and debugging stored procedures and triggers.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

• Cognos 8,10 BI
• Analysis Studio
• Event Studio
• ReportNet 1.02/1.1
• Report Studio
• Query Studio
• Framework Manager
• Metrics Studio
• Cognos Transformer &PowerPlay
• Tableau
• Informatica Power Center 5.0/5.1/6.1
• Informatica Power Mart 4.5
• Ablnitio
• Data Stage
• Decision Stream
• MS SQL Server
• Oracle 8i/9i/10G
• DB2 UDB
• MS - Access
• Informix
• TeraData
• C
• VB
• Java
• SQL
• PL/SQL
• HTML
• XML

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Senior Data Analyst/ BI Consultant

• Evaluate Data Management, Data Quality and Data Access processes for Health Care Programs and provide recommendations to improve and Created Prototypes in Development Systems and then transfer the corresponding scripts into automated Production Systems.
• Implement solutions and processes for Management and Governance across data quality metrics, metadata, lineage, data access rights and business definitions
• Documented Functional and Technical requirements for developing Data Marts, Cognos packages and Reports.
• Work across Compliance/ Program Integration teams and engage stakeholders for their needs and problems.
• Developed scripts to perform Data validation at Account level by using SQL.
• Designed aggregated tables on the most frequently queried data.
• Gathered and analyzed requirements from potential data sources.
• Compiled Weekly, Monthly, Daily Financial analysis reports as per Business Groups requests.
• Documented the steps in report creation and validation process, for user training purposes.
• Worked with Complex/ Visualization Business Reports in Tableau and Cognos Report Studio using master-detail relationship, drill through, burst options, cascading options and Prompts depending on user requirements.
• Worked on various Dashboard projects in Tableau.
• Created reports using cascaded prompts, value prompts, sections, dynamic filtering, and conditional layouts in Cognos Report Studio.
• Deploy and support Cognos reports, Ad-hoc packages, and OLAP cubes.
• Interact with other teams for Design and Architecture of cognos solutions.
• Troubleshoot evaluate and implement solutions for production support issues.

Environment: Cognos (10.1, 10.2.2), Tableau, Framework Manager, Teradata 14, Informatica, Windows 2008 Server

Confidential, Philadelphia, PA

Senior BI Consultant/ Data Analyst

• Implement solutions and processes for Management and Governance across Data Quality Metrics, Metadata, Lineage, Data Access rights and Business Definitions.
• leverage Analytic and Technical skills to innovate, build, and maintain well-managed data solutions and tackled business problems.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Created multiple Dashboard reports for multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Migrated Reports from Cognos10.1 to 10.2.2
• Initiated training for the users to do ad-hoc reporting using Query Studio.
• Extensive experience on Structuring Metadata and Cognos Models using Framework Manager.
• Provided support for slowly changing dimensions in data marts
• Implemented data profiling and quality check in Data Manager.
• Designed and Prepared a Training Material for the Users.
• Closely Involved in Requirement gathering and Analysis with the customers.
• Created List Reports, Cross tab Reports and Control Charts.
• Implemented Security for Data access, Object level access and Package access.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports.
• Extensive experience in Security Administration based along with LDAP.
• Formalized the reporting process by creating the technical specification and requirement specification.
• Create Cubes using Power Play Transformer.

Environment: Cognos (10.1, 10.2.2), Framework Manager, SQL Server 2008, Cognos Datastage, Windows 2008 Server

Confidential, Buffalo, NY

Senior BI Consultant/ Data Analyst

• Work with project managers, business analysts and end users to understand business requirements and translating them in to Technical Specifications.
• Involved in analyzing, documenting functional and technical requirements for developing Data Marts, packages and reports.
• Developed standard reports and analytics to meet the needs of business analysts.
• Demonstrated the Spec Documents and obtained Sign-off from the Users.
• Upgrade cognos 10.2.1 to 10.2.2.
• Involved in designing and creating various data marts and Ad-hoc projects in Framework Manager.
• Moving applications from one server to another using Deployment Manager.
• Involved in setting up sign-on for Groups/Roles to secure the Models and packages.
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
• Participated in JAD Sessions provided the session Deliverables to the client for the approval.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query, Burst Reports against database.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Moved projects from development to QA and then to Production servers.

Environment: Cognos (10.1, 10.2.2), Framework Manager, Oracle 11g, ETL, PL/SQL, Windows 2008 Server

Confidential, Indianapolis, IN

Senior BI Developer/ Data Analyst

• Involved in the Initial development and implementation of the Confidential Data Warehouse, Including JAD sessions to gather the Business Requirements, Development of Conceptual thru Physical Model, Initial loading of 6 years historical Medicaid Claims transaction 20 plus sources of Data.
• Development of 20 Plus extract files like Member Enrollment based on Medicaid, HIP (Healthy Indiana Program and K2), Provider Enrolment based on Prime Specialty (Individual or in a Group), CMS extract for Federal Reporting, PRTF (Psychiatric Residential Treatment Facility) based on their COS( category of service) and LOC (Level of care).
• Installation, Configuration, Deployment and Administration of Cognos BI 10.1.2.
• Designed & developed most efficient reporting models with improved performance and defined the best practices in Framework Manager 10.1 and 10.2.
• Involved in creating complex reports with Provider, Recipient& Claim subject area like ( IBNR-Incurred But not Reported, HIV Recipient’s expenditures by category of service and member demographics of HIV Population based on define Diagnosis code, Provider Claims by Physician, Mental Health and Dental and their Demographic Information.
• Migrated BO (Business Object) reports into Cognos BI environment.
• Created drill-through reports for detail reports.
• Generated Various Reports using Cognos 10.2(List, Crosstab, Chart, Repeater)
• Involved with the end user to understand the Business Requirement.
• Created report Specifications for the GSD (General System Design), DSD (Detail System Design).
• Leading the team for design, development, testing & deliver using Cognos products to meet the client's needs based on specified requirements.
• Customize the Cognos Portal according to the User Specification.
• Created Dashboards for a better understanding of the business performance metrics.
• Perform QA for SIT and UAT Phases using Dev Track and Dev Test.
• Involved in Data profiling and Data Mining to assist the ETL team to fix those data anomalies to improve the Data Quality.
• Provided day-to-day support for all COGNOS Report studio and Query Studio Users using Numara Foot Print 11.5.
• Performing Lead role for the Reporting team and collaborate resource allocation/ utilization, process improvement principles, monitor ongoing development activities, documentation standards and project implementation.
• Follow Water Fall Methodology to communicate the report development progress and issues to management and team members.
• Involved in various trainings (Cognos Report Studio, Cognos Query Studio, Teradata SQL Assistant), to assist user to the new Data Warehouse Environment.

Environment: Cognos10.2 (Cognos Administration, Framework Manager, Report Studio, Query Studio) Teradata 14.0and Windows Server 2008.

Confidential, Alpharetta, GA

BI Consultant

• Involved in Designing and Created various Projects in Framework Manager
• Imported the Metadata from Third Party tools like ERWin.
• Created filters within the Model for improving performance of the Model.
• Created CPF (Project files) and published projects from the FM Models.
• Build complex packages using various tool options.
• Updated various database changes into the Framework manger model
• Generated Various Reports (List, Crosstab, Chart, Repeater)
• Used Conditional explorer for the usage of variables and hide and show the different reports on the same selection criteria
• Created drill-through reports for detail reports.
• Build complex reports using various tool options
• Interacted with the business users and assisted them to use query Studio to develop ad - hoc reports.
• Created Dashboards for a better understanding of the business performance metrics
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Provided day-to-day support for all COGNOS Report studio users.
• Communicated report development progress and issues to management and team members.
• Ensured compliance with standard software development practices, processes and enterprise standards

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, SDK) Oracle 10G and Windows server