SUMMARY

• 9 years of experience in implementation of Business Intelligence solutions, Database, Data Warehouse, Data modeling and Team managing skills.
• Around 7 years of experience in architecture, Installation design, development and implementation of business intelligence applications using IBM Cognos tools.
• Worked on various Cognos BI tools like Administration, Installation & configuration, Framework manager, Report Studio, Transformer and Analysis Studio, workspace Advanced, workspace, Active Reports, Mobile, Metric Studio and Event Studio.
• As a Technical Lead worked wif various Cognos IT teams in resolving issues. Majorly focused on issues related to framework modeling, report performance optimization, Installation and configurations, security setup, job monitoring, deployment and OLAP cubes.
• Hands on experience wif Tableau Desktop, Tableau Server and Cognos 10.2 advanced visualizations - RAVE.
• Document non issues related to existing Cognos environments. Get to no teh new IBM fix packs and install and test fix packs in test and UAT servers.
• Worked on multiple Cognos migration projects and provided end to end deployment of multiple Cognos projects.
• Sound technical skills in ETL tools like Informatica, Oracle Data Integrator (ODI) and Microsoft Integration services (SSIS).
• Proficient in writing SQL and PL/SQL procedures, functions scripts and SQL performance optimization.
• Proficient in designing relational, dimensional and DMR models using Cognos Framework Manager, multi dimensional OLAP models using transformer. Experience in Installation, Configuration, Monitoring, assigning security and Management of Informatica and Cognos 8/10 BI.
• Knowledge in UNIX shell script and service methodologies such as Agile scrum and SOA.
• Excellent Communication, Leadership and Interpersonal skills and Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Ability to accomplish tasks under minimal supervision, Self-starter, Team player, Self-motivated, self-sufficient and comfortable working in a dynamic environment that demands multi-tasking.

TECHNICAL SKILLS

BI Server & Tools: Cognos 10.2.1, 10.1.1, 8.4.1, 8.3, 1.1 and impromptu

Operating Systems: Windows 2003/2008, Linux and UNIX

Databases: Oracle 11/ 10/ 9, SQL Server 2005/ 2008 and Teradata.

ETL Servers & Tools: Informatica 9.x/8.6, Microsoft Integration Services (SSIS) 2005/ 2008, Oracle Data Integrator 11G and Oracle Warehouse Builder 10G R2

PROFESSIONAL EXPERIENCE

Confidential, Basking Ridge NJ

Technologies used: Cognos BI 10.1.1/ 10.2.2/ 8.4 , Oracle 11G and SQL Server

Senior Cognos BI Developer and Admin

Responsibilities:

• Work directly wif stake holders to gather ETL/BI requirements, identify KPIs, gap analysis and come up wif technical design and effort estimates.
• As a senior Cognos BI member work wif various Cognos teams in troubleshooting various day to day Cognos issues faced by other teams and create proof of concepts.
• Day to day administration and support of Cognos environments. Deploy reports and framework models from development to UAT and production environments. Monitor scheduled reports and jobs, reboot when necessary.
• Follow best practices to create new and modify existing three layer relational Cognos framework models.
• Create multi-dimensional OLAP cubes using transformer. Modify and optimize performance of existing cubes. Assign security, schedule and deploy in Linux environment.
• Using Cognos 10.2 RAVE engine created multiple advanced Cognos visualizations.
• Create multiple dashboards, complex scorecards, active reports, drill through, bursting and etc.
• Using Tableau Desktop created multiple advanced visualizations and dashboards. Primarily involved in data blending, publishing onto Tableau server, custom calculations and created multiple advanced visualizations.
• Work wif report developers and offshore for technical noledge transition, design/ code review and sign off.
• As part of Cognos upgrade project, install and configure BI sandbox in distributed environment, upgrade models, install client tools (framework manager and transformer), participate in server load balancing and capacity planning.
• Document Cognos server related issues and get to no new IBM Cognos fix packs. Install and test new Cognos fix packs and coordinate wif IBM teams for solutions and Verizon users.
• Written complex PL/SQL code like procedures, functions, packages, added error logging, parallel processing using hints and extensively worked in performance optimization. End result was 24/7 availability of Cognos packages to end users.
• Create/update data models using ERWIN. Using Oracle Data Integrator (ODI) ELT tool to create interfaces, packages, deploy code and also support nightly production data load jobs.

Technologies used: Cognos BI 10.1.1, SQL Server 2008

Confidential

Senior Cognos BI Consultant

Responsibilities:

• As a project lead, coordinate wif IT and business teams for requirements gathering, task priorities, weekly status meetings, UAT, integration testing and production implementation phases.
• Track project status on daily basis and submit teh details to stake holders.
• Work wif 3-6 members offshore team on day to day basis and work as single point of contact to IT/stake holders.
• Setup best practices for team report writing, testing, ensure quality and onetime deliverables.
• Create development and Unit testing plan and share it wif developers and stake holders.
• Majorly involved in analysis, design and development of new three layers relational cognos framework model, provide framework model walkthrough sessions for IT and end users.
• Create report templates and Cognos reporting standards and guidelines documentation.
• Create master detail, drill through and complex reports in cognos 8.4 using report studio.
• Rewrite SQL server stored procedures for better performance in Cognos. Rewrite stored procedure reports using cognos framework model when possible.
• Create event studio report to notify failed cognos jobs and scheduled reports automatically.
• Deploy changes into production environment and apply security.

Technologies used: Cognos BI 8.4, SQL Server 2005

Confidential

Senior Cognos BI Consultant

Responsibilities:

• Create Migration documentation and test plan for all subject areas. Use Microsoft SharePoint tool for team tracking and version control.
• Fix report issues related to Java script, functionality and cosmetic changes.
• Backup & Migrate transformer models, reports and framework models.
• Use Life cycle manager tool to validate data between Cognso 8.4 and Cognos 10 environments.
• Unit and integration testing of reports as per teh test plan, fix broken reports if any.
• Test output data and new functionalities between Cognos 8 and Cognos 10 reports.
• Document changes and present teh new functionalities to management. Create active reports, dashboard reports and business insight advanced reports.
• Present Cognos 10 mobile reports demo to IT and business teams

Technologies used: Cognos BI 8.4, SQL Server 2005

Confidential

Microsoft Integration Services Developer

Responsibilities:

• Gather requirements from IT teams analyze source system data and create design documents.
• Use various SSIS tasks and create packages.
• Use web service task, script task, execute SQL task and etc., to load data into SQL Server 2005 database.
• Create stored procedures in SQL Server 2005 and modify teh existing procedures.
• Create archive and purging process for large data volume.
• Deploy SSIS packages and create jobs. Coordinate wif users for UAT
• Move changes into live environment and provide post production support.
• Create user documentation for various forecasting processes.

Technologies used: Cognos BI 8.4, Oracle 10G, Access Manager

Confidential

Cognos BI Consultant

Responsibilities:

• Gather requirements from various business teams and prepare report design documentation.
• Provided end user training to educate business users on teh technical aspects of various business units. Provided end to end cognos solutions for business.
• Design and develop transformer models, cubes, publish power cubes into cognos connection.
• Assign security to power cubes in transformer model and cognos connection data sources.
• Create power cubes, cube drill through reports, dashboards using cubes, scorecards and dynamic dashboards in cognos 8.4.
• Worked on cognos 8.4 relational model. Create framework model and report studio reports.
• Provide access to users for new power cubes and reports.
• Work closely wif business for UAT and project sign offs and post production support.
• Worked on cognos 8.4 to 8.4.1 migration project.

Confidential

Cognos and Informatica Developer

Responsibilities:

• Design, Development and Unit testing of Informatica mappings.
• Reviewing teh mappings against teh cognizant’s best practices.
• Pointing cubes to Oracle data warehouse, testing and building cubes.
• Cube data validation against teh existing system.
• Create new cognos framework models and create dashboard reports for Mattel management teams.

Confidential

Cognos Developer

Responsibilities:

• Analyzed list of objects to be migrated and come up wif subject area wise report priority and complexity involved. Create list of in scope and out of scope objects as per teh business requirements.
• Document teh server settings and configuration of existing cognos environment.
• Request DBA for content store back up and coordinate wif network team for new cognos 8.3 windows server access rights and softwares.
• Set up new cognos environment, configure new cognos 8.3 development server and document teh list of teh changes done on development environment for QA and production implementation.
• Migrate framework models, Cognos reports and other cognos objects into new server and validate teh same.
• Unit and Integration testing of migrated cognos objects and fix teh broken reports if any.

Confidential

Developer for Data Warehouse Enhancements

Responsibilities:

• Analyzing teh existing system for impact analysis and create design documents.
• Modifying teh existing data load procedures and reports as per teh change request.
• Analyzed, design and develop various mappings using Oracle Warehouse Builder.
• Modify existing and create new relational and dimensional framework models, assign security. Create drill through, dashboards and scorecard reports using report studio.
• Arriving at coding standards for cognos tools, development checklists and unit test cases.
• Add new database objects and security groups in Cognos framework models, reports, transformer models and power cubes in Cognos 8.3 and cognos reportnet.
• Following quality procedures & processes, arriving at standards & templates

Confidential

Informatica Developer

Responsibilities:

• Analyze and develop mappings using Informatica and scheduled those new jobs into RMS system.
• Made many minor / major enhancements in existing mappings / Workflows and tested teh same.
• Create design documents, Unit and Integration testing of mappings and create test logs.
• Migrating all mappings / workflows from development to integration folder during each release.
• Use version control to check in and checkout code and project documentation.