SUMMARY:

• 17+ years of experience in Information Technology with emphasis on Business Intelligence and Data warehousing
• 15 + years in (Cognos BI Analytics (all major versions) and 1+ yr on other tools including Power BI,Tableau, Cognos TM1,BO, SSRS and SSIS),AWS and Azure
• Worked on Agile Methodology Process for more than 9 years with Cross Functional Business teams
• 2+ years of Healthcare Experience including Facets TriZetto, RxClaim, Valencia, Medforce, CMS and AAH
• Provide process improvements and solutions to Development & Administration
• Worked as Cognos Admin/Sr Developerfor Clients. Strong Experience on all Cognos BI Products including Workspace, Workspace Advanced, Report Studio, Query Studio, Framework Manager, Metrics Studio, Transformer. Business Insight and Business Insight Advanced
• Installed and configured all Cognos BI products in Production and all other environments
• Experience on installing and Configuring TM1, have integrated Cognos BI security with TM1
• Experience in data warehousing concepts, data modeling and OLAP.Strong knowledge on Ralph Kimball and Bill Inmon Datawarehouse Strategey.
• Strong Data Modeling Experience to meet the complex reporting requirements.
• 3 plus of years of ETL development experience using Sql Server Integration Services
• Basic Knowledge of ETL Mappings and Workflows - OWB, informatica, Microsoft DTS and Humming Bird-Genio and Oracle DBA
• Production support (Level1, Level 2 and Level 3) and to end users
• Strong SQL experience in MS SQL Server, Oracle, SSIS, Teradata and follow Database Naming Standards
• Experience in Requirement Analysis, Design, Development, Testing and Implementation of Software
• Quick Learner of Business Processes and Technologies
• Excellent interpersonal communication skills, team player with commitment to excellence
• Experience in working with clients to gather requirements

TECHNICAL SKILLS:

Databases: Oracle10.x/8.1/8i, MS SQL Server 2000, DB2, MS Access,Teradata

ETL: Humming Bird. Oracle Warehouse Builder (OWB), Informatica Microsoft DTS, Microsoft SSIS Packages

BI Reporting: Cognos Analytics 11,10.2, Cognos Insight, Workspace, Workspace Advanced, Cognos8.3(Report Studio, Query Studio, Framework Manager, Transformer Analysis Advanced, Cognos8.3(Report Studio, Query Studio, Framework Manager, Transformer Analysis Studio, Event Studio, Metrics Manager),Cognos ReportNet 1.1 MR2,Cognos Transformer 7.3,Cognos Power Play 7.3, Cognos Metrics Manager 2.1, Cognos Visualizer 7.3,Business Objects 6.1b, Web Intelligence, Crystal Reports Tools, Tableau,PowerBI

Languages: SQL, PL / SQL, Java, PHP,UNIX Basics

GUI: Visual Basic, FACETS,Salesforce

Other Tools: Toad, Chameleon, Azure Cloud,Alteryx

Functional: Finance, Healthcare, Hospitality, Telecom, Retail and Banking

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Created Reports and Models using Cognos 11 and Framework Manager
• Worked on creating professional report studio reports
• Worked on AWS and Azure services
• Worked on Power Bi, power BI pro service and power BI desktop
• Worked on their internal systems,databases and Datawarehouse including Oracleand SQL Server database on Azure
• Worked on creating complex reporting solutions using Cognos,Jira and Oracle
• Created Reports and Models using Cognos 11 and Framework Manager
• Worked on T-SQL,SQL
• Worked on their internal systems,databases and Datawarehouse including Oracleand SQL Server database on Azure
• Implemented Cognos 10.1 to 11 migration
• Salesforce support and Cognos Production support
• Fix FM packages,reports including Dashboards
• Supported implementation/configuration of Cognos APIS/JDK
• T-SQL

Confidential, Durham, NC

Cognos/Database Admin/Developer

Tools: Cognos 10, 11+, SQL Server,SSIS,PowerBI,BSP,Cognos TM1,Accounting Hub,AWS

Responsibilities:

• Worked for Workforce, Revenue and Projects Data
• Worked on to understand the reports requirements and other systems including Acct Hub Revenue
• Installed and administered Cognos 11.x version on AWS servers
• Created Stored procedures,views,packages,Dashboards,reports
• Worked on Mapping documents, Analysis and UAT
• Worked on analyzing the SSIS packages for data issues and understanding
• Work on TSQL procedures
• Have experience in Database naming conventions
• Have done TM1 security implementation on IBM Cognos Servers
• Installed and Configured IBM Cognos Analytics
• Provide full support on Cognos Maintenance with other teams

Confidential

Sr.Cognos Developer/Database Developer

Tools: Cognos 10 & 11 Oracle and SQL Server

Responsibilities:

• Worked for Insurance Reporting and other internal systems including Guidewire and other applications
• Worked on data including Auto, Property and Liability
• Worked on to understand the reports requirements and other systems
• Created Reports, Dashboards,using Cognos Report Studio
• Followed Scrum Methodology
• Worked on Mapping documents, Analysis and UAT

Confidential, Bridgewater, NJ

Sr.Cognos Developer

Tools: Cognos 10.2.2 & 11, Tableau,Corporater, Oracle and SQL Server

Responsibilities:

• Worked for SCM/ Financial Reporting Project
• Worked on to understand the reports requirements and other systems
• Created Reports using Tableau and Cognos
• Followed Scrum Methodology
• Worked on Mapping documents, Analysis and UAT

Confidential, Chicago, IL

Senior Cognos Modeler/ Developer

Tools: Cognos 10.2.1 & 11, Oracle, Teradata, Aptitude Accounting HUB database, BIG DATA

Responsibilities:

• Worked for Financial Services Division Reporting Project
• Worked on to understand the reports requirements and other systems
• POC on development/security/reports solutions using Tableau/Cognos suite of products
• Followed Scrum Methodology
• Worked on Mapping documents, security templates and Framework documentation

Confidential, Troy, MI

Sr Cognos Developer/Database Developer

Tools: Cognos 10, Cognos TM1,SSIS,SSRS, Oracle 11g

Responsibilities:

• Cognos BI 10.2 & Cognos TM1 Administration and Production support.
• Have installed configured Cognos BI, Cognos TM1, Cognos Planning
• Provide Level1, Level2 and Level3 Support, provide solutions to Administration and Development
• Design, Develop, Build and Test Cognos Reports
• Developed Report Studio reports queries, filters, conditional formatting, aggregations,

Confidential

Senior BI/Developer/Database Developer

Tools: Cognos 10, SSIS. FACETS, SSRS, Oracle 11g, MS-SQL Server, Medforce, RxClaim, Valencia, Teradata

Responsibilities:

• Interact with Business users to gather requirements
• Write BRD, Approach, Design and Unit Test Case documents for Medicare Part D Projects
• Developed AENO, Out of Area, Routed Calls, Discrepancy, Undeliverable Mail & healthcare reports
• Process Improvements within the team
• Design, Develop, Build and Test Reports. Provide Solutions to Development
• Develop reports using SQL technology including Oracle and SQL server and other BI tools
• Production Operations Support using HPSM tickets and regular reports
• Work on Healthcare systems including Facets-Trizet to and other internal systems and perform reporting based on it
• Worked on Facets which includes Medicare Part D Data, Member Enrollment data, Eligibility Data, RxClaims, Configuration Data, Plans and Groups, Part D Events.
• Understanding of Facets Data model (Subscriber Eligibility, Customer Service, Groups, Plan)
• Cognos Reports, Report Studio, Query Studio, Workspace, Workspace Advanced, Analysis Studio and Transformer Cubes
• HPSM Incident and Problem Management
• Create, Build and Test Microsoft Sql Server Integration Packages for reporting.
• Work on Automation of Queries using Microsoft SSIS packages.
• Develop, Design Packages using SSIS for various projects.
• Perform analysis on various source systems including Medforce, AS400, Datawarehouse, MS-Access and other systems and develop reports.
• Worked on Medforce Databases and other Rxclaims systems, created reports for Paper Claims Processing.

Confidential, Detroit, MI

Senior Report Writer/Cognos Architect/BA/Database Developer

Tools: Cognos 10.2, Oracle 11g

Responsibilities:

• Gather reporting requirements with SME’s
• Design, Develop, Build and Test Cognos Reports
• Developed Reports for Development and Alumni Affairs Department
• Created Reports on Family Gifts, Donors
• Performed Analysis using reports and Oracle Queries
• Work on Databases-Oracle

Confidential, Detroit, MI

Lead Cognos /BIDW/Senior Developer/Administrator/Architect

Responsibilities:

• Cognos BI 10.2 & Cognos TM1 Administration and Production support.
• Have installed configured Cognos BI, Cognos TM1, Cognos Planning
• Provide Level1, Level2 and Level3 Support, provide solutions to Administration and Development
• Design, Develop, Build and Test Cognos Reports
• Developed Report Studio reports queries, filters, conditional formatting, aggregations,
• Calculations, block variables, Drill down, drill through, Page Set, etc
• Created Reports for Loan Applications, Credit Cards,Refferals and for Sales
• Have worked on Framework Modeling Changes
• Managing 21 applications which are developed using Cognos suites of Products
• Have developed dimensions,cubes using Cognos TM1 using input files as source
• Have added users to Cognos TM1,Cognos BI & Planning
• Incident, Problem and Requests Management through Service Desk
• Co-ordinate with Offshore team and Business users
• Educate users on using Cognos Workspace Advanced and other Cognos Products
• Analysis of Incidents and fixing/providing solutions
• Work on Databases including Oracle, DB2 and SQL Server
• Worked on Lifecycle Manager and BSP MetaManage

Confidential -Chicago, IL

Lead Report Developer/Database Developer

Responsibilities:

• Analysis of Reports sources from Business Objects and other Oracle reports
• Interact with Client to get requirements
• Perform Gap Analysis
• Mapping between Source and Target systems for Reporting needs
• Creation of Reports using Cognos tools including Report Studio, Query Studio and FM
• Developed Complex reports using Report Studio
• Unit Testing
• Assign work to team members
• Provide technical support to Cognos Developers
• Co-ordinate with Offshore team
• Analysis of Reports sources from Hyperion, SQL and access reports
• Creation of Reports using Cognos Report Studio and Query Studio
• Framework Model changes using Facts and Dimensions
• Unit testing of Cognos Reports

Confidential, Phoenix, AZ

Cognos Developer & Administrator/Architect

Responsibilities:

• Cognos 8.4.1 Administration and Production support
• Building, Scheduling and Monitoring Cubes using Batch scripts
• Deployment of Reports, Cubes and portal pages between Dev and Production environments
• Implementing Security and Enabled Single Sign On
• Analysis of Reports issues in Production Worked on Transformer Power Cubes Changes
• Upgraded the Cognos Environment from Cognos 8.3 to 8.4 and 8.4 to 8.4.1
• Installed Cognos 8.4 on a multi-server environment and configured with IBM WebSphere
• Installed and Configured Cognos Go Dashboard
• Installed and Configured Metrics Server, Designer and created metric store
• Install of Fix packs and hotfixes for Cognos BI products.
• Moved the metric files from SQL server database metric store to Oracle metric store through Cognos
• Use of Maximo for managing Change in Production
• Supporting startup and shutdown of Cognos Services during Security patching.
• Cognos 8.1 Planning Administration-Adding users and running Admin links, GTP
• Developed few reports on Audit and few reports for ETL Job Status using Informatica Tables

Confidential, Madison, WI

DW/BI Test Lead

Responsibilities:

• Interacted with clients on getting the testing requirements.
• Analyzing their source systems, ETL approach and Business Objects Reports
• Defined the scope of testing
• Designed the flow of testing which includes the testing approach on ETL and Business Objects Reports.
• Involved in system testing on the ETL source systems which involves testing from different stages, i.e. testing from source to staging and from staging to EDW and from EDW to Data marts.
• Involved in analysis on some of their ETL mappings.
• Tested the Business Objects reports by writing SQL queries on the backend.
• Involved in Defect Triage Meeting with the Development teams to work on the defects found during testing.
• Worked on HP Quality Center 9.2 for test case execution, creating and logging the defects.
• Interacted with SME’s on getting the requirements.
• Analyzing of clients Crystal Reports, source tables
• Creating Oracle Stored Procedures using PL/SQL Programming language.
• Creating Cognos Framework Models and Reports using Framework manager and Report Studio.
• Creation of Filters, prompts, calculations in Report studio
• Development of Cognos Reports, Test and Deliver.
• Installed and Configured Cognos 8.3 suite of products including Cognos Go Office
• Portal Administration and Worked on Security - Users, Groups and Roles
• Configured Audit Reporting.
• Scheduled Reports using inbuilt Trigger functionality and using Events
• Exported and Deployed Packages, Report Specifications from Development to Test and Production Environments.
• Written technical and end user documentation on Cognos.
• Trained the Clients on Framework Manager.
• Installed the patch update for Cognos 8.3
• Code reviews and UAT

Confidential, St Paul, MN

Architect/Developer/Lead

Responsibilities:

• Analysis of Requirements.
• Developed Framework models based on their Data Models.
• Developed Cognos Reports according to customer’s requirements. Extensive amount of portal customization and integration with their web application was done as part of the requirements
• Designed and develop web pages using JSP, JavaScript and PHP to render data
• Worked on web services using Apache Axis and Java. Involved in creating wsdl files and generating server and client stubs and writing client interface using JSP.
• Worked on Oracle and My SQL 5.0 databases
• Worked on Open source mapping Tools such as Chameleon and Map Server.
• Involved in Creating Maps for Map Server using Shape files.
• Worked on Google Earth using Kml files.
• Designed the user interfaces using JSP(Java Server Pages) and HTML
• Created User interface using Asp.net and Vb.net.
• Embedded video player on web.

Confidential

Data Warehouse/ Senior Cognos Developer /Database Developer

Responsibilities:

• Performed system analysis, design, development, coding, generation of reports, testing and documentation.
• Collected requirements from clients, prepared requirements document, followed up and developed new report templates as per the client request
• Involved in Logical and Physical Data model and created Business models using Framework Manager
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Building models and publishing packages in Framework Manager to the Report Net server.
• Created cubes from multiple iqds using Cognos Transformer
• Created drill thru reports from Cognos Power Play to Cognos Report net
• Created Scorecards, (KPI’s) and Dashboards using Cognos Metrics Manager and Cognos Visualizer
• Implemented security for Cognos Transformer, Report net, Metrics Manager
• Trained the Clients in Cognos
• Supported UAT
• Analysis of the specifications provided by the clients
• Installation of Cognos suite of Products.
• Cognos Administration- security, scheduling and distributing reports.
• Creation of Framework models using Framework Manager
• Building models and publishing packages in Framework Manager to the ReportNet server.
• Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio.
• Created cubes using Cognos Transformer
• Perform Oracle DBA activities, importing, exporting and backup
• Created both summary and detail reports using Cognos Powerplay and Reportnet
• Implemented security for Cognos Transformer, Reportnet, Metrics Manager
• Created drill thru reports from Cognos Power Play to Cognos Reportnet
• Involved in Logical and Physical Design of the database
• Replicated the Logical Data models using Cognos Framework Manager.
• Replicated the Reports using Cognos suite of Products.
• Experience in designing and building Universes, Classes and objects using Business Objects
• Created Cardinalities, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Perform Oracle DBA activities, importing, exporting and backup
• Exported the universes to the Repository for making resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.
• Used Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
• Experience in BO Reporter, Designer and Supervisor modules, Query Panel and Data Provider.
• Created universes including universe parameters, objects and classes in BO Designer.
• Used Designer Module to Create prompts and queries, applied Aliases to remove cyclic loops
• Backups and Recovery in Test Environment using Oracle (DBA activities).
• Unit and module testing
• Maintaining VSS (Visual Source Safe)