SUMMARY

• 10 years 2 months 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 with 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 with Tableau Desktop, Tableau Server and Cognos 10.2 advanced visualizations - RAVE.
• Document non issues related to existing Cognos environments. Get to no the 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, Tableau

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

Sr BI Developer and Admin

Responsibilities:

• Work directly with stake holders to gather ETL/BI requirements, identify KPIs, gap analysis and come up with technical design and effort estimates.
• As a senior Cognos BI member work with 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 with 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 with 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.
• Attended trainings - Tableau Developer training, Cognos SPSS classroom training by IBM, Big data - Hadoop and Oracle Data Integrator 11G by Oracle Corporation.

Confidential, Woodbridge, NJ

Technologies used: Cognos BI 8.4, SQL Server 2005

Senior Cognos BI Consultant

Responsibilities:

• As a project lead, coordinate with 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 the details to stake holders.
• Work with 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 with 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.

Confidential, Woodbridge, NJ

Technologies used: Cognos BI 8.4, SQL Server 2005

Microsoft Integration Services Developer

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 the test plan, fix broken reports if any.
• Test output data and new functionalities between Cognos 8 and Cognos 10 reports.
• Document changes and present the 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

Confidential, Minneapolis, MN

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

Cognos BI Consultant

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 the existing procedures.
• Create archive and purging process for large data volume.
• Deploy SSIS packages and create jobs. Coordinate with users for UAT
• Move changes into live environment and provide post production support.
• Create user documentation for various forecasting processes.
• Check in and check-out code using version control tool.

Confidential

Technologies used: Informatica 8x and Cognos Impromptu

Cognos and Informatica Developer

Responsibilities:

• Gather requirements from various business teams and prepare report design documentation.
• Provided end user training to educate business users on the 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 with business for UAT and project sign offs and post production support.
• Worked on cognos 8.4 to 8.4.1 migration project.

Confidential

Technologies used: Cognos Reportnet and Oracle 9i, Access Manager and Cognos 8.3

Cognos Developer

Responsibilities:

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

Confidential, Chennai - India

Technologies used: Cognos reportnet, cognos 8.3, Oracle 9i PL/SQL, Oracle Warehouse builder and Microsoft Integration Services (SSIS) 2005

Developer

Responsibilities:

• Analyzed list of objects to be migrated and come up with subject area wise report priority and complexity involved. Create list of in scope and out of scope objects as per the business requirements.
• Document the server settings and configuration of existing cognos environment.
• Request DBA for content store back up and coordinate with 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 the list of the changes done on development environment for QA and production implementation.
• Migrate framework models, Cognos reports and other cognos objects into new server and validate the same.
• Unit and Integration testing of migrated cognos objects and fix the broken reports if any.

Confidential

Technologies used: Informatica 7x and Oracle 9i

Informatica Developer

Responsibilities:

• Analyzing the existing system for impact analysis and create design documents.
• Modifying the existing data load procedures and reports as per the 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, Woodbridge, NJ

Technologies used: Cognos BI 10.1.1, SQL Server 2008

Senior Cognos BI Consultant

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 the 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.