SUMMARY:

• 11 years and 4 months of experience in design, development and maintenance of Business Intelligence projects using Cognos (10.2, 8.x, 7.x), ReportNet 1.1, Impromptu, Oracle, Teradata
• Currently working with Xerox Services as Cognos Technical Lead for the New York State Medicaid Management Information System (MMIS)
• Worked as Analyst / Consultant in the USA for major Clients including Citibank and Dell Services
• Good understanding of BI architecture, ETL, data modeling, reporting, OLAP, DMR, data & object level security; Also involved in installation, configuration and troubleshooting.
• Played key role as Cognos Architect, Cognos Technical Lead, Individual Contributor, Module Lead, Onsite Coordinator and Developer in multiple BI Projects
• Implemented new and existing Reporting solutions for multiple major application areas simultaneously, managing offshore resources as well as interacting with technical & business users
• Supported major application areas during technical upgrades like Cognos 10 Migration, Cognos 8.4 Migration, Database upgrades, as well as Auditing activities like Annual Continuity of Business (CoB) Testing, by planning the entire course of action through pre - defined Test Scripts
• Experienced in Agile methodology, as well as all stages of the SDLC
• Practical knowledge of all stages of Data warehousing project
• Extensive knowledge of the Banking & Financial, Healthcare and Manufacturing domains
• Solid management skills, demonstrated proficiency in leading and grooming individuals to maximize levels of productivity, while forming cohesive team environments
• Excellent Presentation skills; Delivered well-structured technical s on Cognos tools to Developers as well as Users
• Clear understanding of Client and Organization processes
• Good understanding of Quality Assurance in compliance with CMMI Level 5
• Analytical thinker; consistently suggests good Cognos solutions to appropriate Reporting and ETL areas, often called upon to consult on problems that have eluded resolution by others
• Experience in ETL Tool - Cognos Data Manager
• Knowledge of ETL Tools - Informatica, Ab Initio
• Experience in Cognos Active Reports

TECHNICAL SKILLS:

Business Intelligence Tools: Cognos (10.2, 8.4, 8.2, 7.x) - Framework Manager, PowerPlay Transformer, Data Manager, Report Studio, Query Studio, Analysis Studio, PowerPlay Studio, Event Studio, Workspace, Workspace Advanced, Active Reports, Cognos Mobile, Cognos for Microsoft Office, ReportNet 1.1, Impromptu 7.3

Databases: Oracle, Teradata, SQL Server, MySQL

Database Tools: Toad for Oracle, Oracle SQL Developer, Oracle Enterprise Manager Console, Teradata SQL Assistant, phpMyAdmin

Languages: SQL, C, C++, Java, UNIX Shell Scripting

Project/Lifecycle Management Tools: VersionOne, ProjX, Accept IT, Daptiv PPM, Planview

Software Development Methodologies: Agile, Waterfall, RAD

Web and GUI Development: HTML, JavaScript, PHP, ASP, ASP.NET, PHP, Java, J2EE

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Cognos Technical Lead

Responsibilities:

• Cognos Technical Lead for all Reporting requirements.
• Attend the concept sessions to collect the detailed requirements, co-ordinate with Confidential Product Owners, SMEs and Business Analysts to clarify the requirements, work with onsite and offshore developers to design and develop an optimum BI Solution.
• Design the FM Model and Reports for the Release-1 requirements for Provider and Contact Management Modules.
• Co-ordinate with the Security team on Information classification and User Class design.
• Work with the related Admins to schedule the Cognos reports via Control-M, and integrate the scheduled Cognos reports into the Xerox Transactional Content Manager (XTCM) via MOVEit file transfer tasks.
• Create the deployment packages, upload in Git Source Control Management (SCM) system, and work with Cognos Admins on the deployment activities of the objects across various Testing environments.
• Active involvement in supporting User Acceptance Testing.
• Provide walk-through of the reporting solution and capabilities to the Confidential and Xerox teams as and when needed.
• Portfolio/Story/Task and Defect tracking using the VersionOne lifecycle management tool, documentation support using IBM Blueworks Live tool.

Confidential

Senior Analyst Developer

Tools: Cognos 10.2, 8.1, 7.3 Framework Manager, Report Studio, Active Reports, PowerPlay Transformer, Workspace, Workspace Advanced, Analysis Studio, Event Studio, Oracle SQL Developer

Responsibilities:

• Lead Developer for the Dashboard requirements
• Co-ordinate with the Business Analyst as well as key Business Users to understand the requirements
• Co-ordinate with the SAP, ETL an PL/SQL Developers to understand the data, create the tables in the Enterprise Datawarehouse, and validate the data writing SQL statements
• Design and develop Cognos Framework Manager model
• Design/Architect the Dashboard in Report Studio Active Reports
• Lead the TCS team on the Cognos Dashboard development
• Lead Developer in consolidating the details on infrastructure review, Cognos objects and security
• Individual Contributor for FM Model and Report upgrade
• Moved one of the major daily reports, which had used batch file, external .net application and excel macros, into Cognos Event Studio
• Co-ordinate with the ETL and Database teams as well as Cognos Admin, to set up the testing environments
• Lead and Review the Cube upgrade
• Support User Acceptance Testing and Post Implementation validation
• Support Power Users on the User created Workspace Advanced (old PowerPlay Studio) Reports
• Work with Solution Consultants and IBM team on the open technical items
• Deliver s to the User Community on using Cognos 10, as well as creating Cube-based reports using Workspace Advanced
• FM Models, Packages and Reports upgraded to Cognos 10
• Documentation and to Power Users and normal Business Users

Confidential

Individual Contributor

Responsibilities:

• Individual Contributor for various new Reporting requirements in the PDRS area
• Maintain the BI Reporting solution for various application areas within PDRS
• Co-ordinate with the Product Owner and key Business Users to understand the requirements
• Design, develop and unit-test Cognos Data Manager jobstreams to load data from the diverse source systems into the target database
• Design, develop and unit-test FM Model, Packages, Reports and Cubes for Local and Global PDRS requirements
• Automate and schedule the Cognos Data Manager jobs, Reports and Cubes
• Deploy the Cognos objects into the QA and Production environments
• Create stories, estimations and technical documentation with the help of Accept IT Project Management tool
• Support User Acceptance Testing and Post Implementation validation
• High Level and detailed Design of Cognos deliverables
• Data Manager jobstreams, FM Model, Packages, Reports and Cubes for Global and Local PDRS requirements
• Detailed deployment instructions for migrating the code to Production environment
• Demo to Business Users at the end of each Sprint
• Detailed project plan for major projects like Cognos 10 migration

Confidential, Plano, TX

Cognos Technical Lead - Onsite

Tools: Cognos 8.4 - Framework Manager, Report Studio, Analysis Studio, PowerPlay TransformerOracle SQL Developer, Toad for Oracle, Daptiv PPM

Responsibilities:

• Lead Designer and Developer for all Reporting requirements and maintaining the BI Reporting solution for Tenet and Conifer application areas.
• Co-ordinate with Business Users to understand the requirements and work with Data Modelers, ETL and offshore developers to provide an optimum BI Solution.
• Design and develop FM Model, Packages, Reports, and Cubes for various Tenet/Conifer BI requirements.
• Co-ordinate with Business Users and Project Managers on Information classification and User Class design.
• Provide detailed Estimations during various phases of the Project, as applicable.
• Project Planning, Status Reporting and Resource Allocation for Design, Development, Testing and Implementation tasks.
• Defect tracking and documentation support using the Daptiv PPM Project Management tool
• Work with Cognos Admin on migration activities of the objects to the UAT and Production environments.
• Active involvement in supporting User Acceptance Testing and Post Implementation Validation.
• High Level and detailed Design of Cognos deliverables
• FM Model, Packages, Reports and Cubes for Tenet and Conifer
• Detailed development and design tasks with allocation of resources and timelines
• Standards and compliance in process and coding
• Demo and to Business Process Owners

Confidential

Cognos Tech Lead - Onsite

Tools: Cognos 8.x - Framework Manager, Report Studio, Query Studio; Cognos 7.4 PowerPlay

Responsibilities:

• The Agent Fraud Incident Reports were designed to illustrate Agent Access in comparison to Fraud Closures.
• The Account Address Reports enhance Internal Fraud detection by monitoring Account Address changes as well as the changed Account-Address’ comparison across Employee-Address.
• Internal Fraud Footprint Reports provide reporting/monitoring capabilities on Associate activities, by projecting Account level activity data.