SUMMARY:

• Over 10 years of professional work experience in Business Intelligence with prime focus on analysis, design and development of BI solutions using Reporting / ETL tools such as Cognos Reports and Dashboards and Informatica and Microsoft BI Suite Power BI Database management and developing complex reports for the customer and business clients.
• Strong expertise in using other ETL and Reporting tools Informatica and Cognos.
• Expertise in Microsoft toolsets such Cognos,Power BI.
• Analyzing data and evaluating business processes Screening and modeling ideas for process improvements.
• Analyzing business work flow and system needs for conversions and migrations; assisting in data mapping.
• Conducting gap analysis and using analytical skills to identify root cause of system failures.
• Reviewing test plans to identify defects while supporting system testing and User Acceptance Testing.
• Collaborating with Subject matter experts, Project Managers, Developers, deployment and offshore teams, production support, operations, IT Security and testing teams throughout the SDLC.
• Highly proficient in developing reports based on Cognos Report Studio, Active Reports, Cognos Workspace, Cognos Workspace Advanced, Analysis Studio and Event Studio, Impromptu,Powerplay Transformer.
• Expertise in Cognos Powerplay Transformer and developing time based partitioning and fully refreshed cubes.
• Involved in Installation and configuration of Cognos
• Expertise in Framework Manager for importing tables from different data sources and setting the cardinality for the tables as per requirements.
• Developed and Published Packages using Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries, functions and security in Framework Manager.
• Proficient in designing multidimensional Model in Framework Manager in Cognos BI version 8 and as well as Strong knowledge and understanding of Snow Flake and Star Experience in Deployment (Export, Import) into environments ( DEV, UAT, PROD)
• Created Active Reports with Tab Controls using tab Deck and Tabs.
• Complex Report building experience in Report studio by using filters customized prompts, conditional formatting, drillup & drill down and drill-through, Cross tab,Master details Reports and HTML Scripting.
• Created ad-hoc queries from multidimensional views for analysis.
• Developed Cubes, Reports, and Dashboards using Cognos BI.
• Worked on replicating the cubes between servers, sharing data between cubes and linking asymmetrical cubes.
• Prototyped system interfaces in Excel and facilitated reviews and capture project related documentation and maintain project repository.
• Facilitated discovery and documentation of multi-organizational planning and forecasting processes.
• Experience working with large datasets and query optimization. Been responsible for migrating Cognos objects from one version to another. Worked on versions like Cognos 8, Cognos 10.1, and Cognos 10.2.
• Worked on the performance improvement of Cognos reports and dashboards thereby improving the efficiency.
• Worked on creating both folder level security and report level security using Cognos userclasses. Also worked on implementing userclass security in Framework Manager for both object level and row level security; and also in Powerplay Transformer models.
• Experience with all phases of business operations report specifications development including creating business requirements documentations (BRDs), report mock ups, and acceptance testing for business intelligence tools to design report, data analysis, or Dashboards for operational reporting business solutions
• Excellent communication and interpersonal skills, and a team player with Strong organizational and problem solving skills.

TECHNICAL SKILLS:

BI Tools: Cognos 11.6,Cognos 10.4 & Cognos 8.4 BI(Report Studio, Query Studio, Analysis Studio, Transformer, Framework Manager), Power BI, Cognos Series 7 Version Impromptu, COGNOS PowerPlay Transformer, Access Manager LDAP Server, Cognos connection, Frame work Manager, Query studio, Report studio, Workspace Advanced

ETL: Informatica 9.6.1

Operating Systems: Windows XP/2000.

Languages: SQL*Plus,HTML.

Databases: ORACLE 9i, 10g, 11g, DB2, MS SQL Server 2000, and Netezza.

Software Packages: MS-Office 2003, Microsoft Word, Excel and Power Point.

Database Tools: Toad.

Other Tools: Motio Ci

PROFESSIONAL EXPERIENCE:

Consultant-Power BI,Cognos

Confidential, Little Rock, Arkansas

• Developed and Implemented Reports and Interactive dashboards to help drive business decisions.
• Responsible for understanding business requirements and translating them into high quality report deliverables.
• Expertise in designing Framework Manager Packages and Reports.
• Complex Report building experience in Report studio by using Drill up and Drill down, Master/details queries, and filters customized prompts, conditional formatting, drill-through, Crosstab, Variables.
• Creating Models using Curam as a source.
• Created Reports for Adhoc Request using Sql overwrites.
• Designed the models and packages using Microsoft Power BI and Microsoft Analysis Services in an agile, iterative method and had those reviewed and enhanced in the bi-weekly workshops
• Created Power Bi Dashboards using Excel, and DB2 Database as a source.
• Transformed well formatted data and Loaded into Power BI desktop using query editor.
• Splitted column into Category code and Type
• Developed Calculated columns and expression using DAX Commends
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Ensuring clear query paths by resolving ambiguous relationships (Role-playing dimensions, loops).
• Determinants has been assigned for the respective Query subjects.
• Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, conditional formatting reports using Report Studio and Query Studio. Working experience with different date functions in Report studio.
• Involved in writing Queries in SQL server. Trained end users effectively to use reporting tool, to build and customize their Ad-hoc reports.
• Migration of Cognos objects from one version to other. Versions worked on: Cognos 10, Cognos 11.
• Deployed Reports, Packages and Folders from DEV to UAT and from UAT to Prod environment.
• Involved in writing Queries in SQL server. Trained end users effectively to use reporting tool, to build and customize their Ad-hoc reports.
• Extracted the data from Relational Database, Flat Files and Loaded into the target Data warehouse.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager
• Created Medium ETL Mappings, Workflow for Datawarehouse tables using Informatica.

Technology Lead-Cognos Infosys

Confidential - Frisco, TX

• Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
• Conducted client and user demos during the growth and development of the project; Conducted sessions that presents the project’s capability and trained users on the tool for self-serviced reporting.
• Developed and implemented interactive dashboards to help drive business decisions. Responsible for understanding business requirements and translating them into high quality report deliverables.
• Expertise in designing Framework Manager Packages and Reports.
• Complex Report building experience in Report studio by using Drill up and Drill down, Master/details queries, and filters customized prompts, conditional formatting, drill-through, Crosstab, Variables.
• Development activities include creation of dashboards sourced from Active reports which were interactive and scheduled, and implementing them to be sent to the users on daily basis. The Active Reports are downloaded and the MHTML files would be sent to SharePoint and sharing the SharePoint link to users avoided user access to Cognos. Also created reports compatible to iPad and iPhone.
• Creating Models using store procedure.
• Provided on call support on Release incidents.
• Security being the primary focus, worked on creating user classes in Cognos LDAP for securing individual projects, and by assigning these user classes to folders, packages and reports and Cube groups secured by corresponding user group. Also, implemented security in data access, Object level access and package access.
• Delivering Adhoc reports using Workspace Advanced and Cognos Insight, also for creating customized and comprehensible reports. Used Java scripts to achieving high end functionalities in Report Studio Dashboards;
• Creation and Implementation of DMR models.
• Migration of Cognos objects from one version to other. Versions worked on: Cognos 8, Cognos 10.1, and Cognos 10.2 (current).
• Develop reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.

Confidential

Technology Lead

• Facilitated meetings with Client Managers and Stakeholders and finalized program objectives, scope, schedule and cost, and negotiated with customer to secure additional funding and scheduling extensions.
• Effectively collected project metrics and communicated status reports to Metlife and Infosys Leadership Team.
• Participated in proactive proposals provided by Infosys to customers which added value to the business.
• Gathering and Analyzing user requirements and creation of Models based on different data sources.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Used Framework Manager to build models, packages and publish packages to Cognos Connection.
• Built models containing query subjects, query items, and namespaces from imported metadata.
• Created complex reports using Cognos 8 BI Report Studio and Ad-hoc reports using Query Studio.
• Developed complex reports from lists, Cross-tabs through Complex dashboards, Conditional formatting, Drill through, &master/detail reports for End users.
• Created Complex dashboards and published to Cognos Connection portal.
• Developed multidimensional models (DMR) and published packages using framework manager and then generated reports from these packages.
• Created prompts, Calculations, Filters, Developing Prompt pages and Conditional Variables using Report Studio.
• Worked on Informatica B2B to support TPXU Project
• Tested and validated the Report output against database to measure performance of reports.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection. Involved in Performance Tuning the reports in Report Studio.
• Deployed Reports, Packages and Folders from DEV to UAT and from UAT to Prod environment.
• Involved in writing Queries in SQL server. Trained end users effectively to use reporting tool, to build and customize their Ad-hoc reports.
• Disaster Recovery Validation
• Extracted the data from Relational Database, Flat Files and Loaded into the target Data warehouse.