SUMMARY

• Around 8 years of experience as BI Project Manager/Architect and more than 5 years as BI Tech Lead
• More than 5 Years experience as Project Manager this includes Client Management, Resource Management and Schedule Management handling BI Projects as well as Offshore - Onsite Management.
• Strong Experience in Finance, Insurance and Manufacturing Industries
• Strong knowledge in using Agile methodology for software development and good knowledge in different SDLC(Software Development life cycle) phases
• Handling and Prioritizing the BI releases allocate and re-direct resources and Resolve alternative strategies and areas of business focus.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Ensure that all related projects cooperate and coordinate with the BI program team.
• Act as senior liaisons between the program and all potential business areas that may use the business intelligence.
• Involved in defining the overall corporate data model on which the BI is based.
• Involved in creating proposals and POC in order to Market and sell the BI Program to the entire organization. Also involved in establishing the training programs for the business users.
• Facilitate the prioritization of Projects and Requests in consideration of competing business interests based on business needs and available resources.
• Experience in Data Virtualization using Cisco Composite 6.2
• Experience in building Workbooks and Dashboards using Tableau 9.2
• Knowledge of Data Analysis & Building Dashboards using Cognos 10. Well-versed in developing reporting applications employing Cognos 10 components like Framework Manager, Query Studio, Report Studio and Event Studio.
• Experience in Cognos Administration including setting up of environment, troubleshooting and all admin activities.
• Experience in query optimizing techniques and performance tuning.
• Knowledge in Dimensional data modeling, star and snowflake schemas, key generalization, and other OLAP considerations
• Hands on experience in working with SQL for Oracle, DB2 and HiveQL
• Strong experience in understanding business requirements. Excellent communication, interpersonal, presentation skills.
• Experience in gathering User requirements and preparing specification documents.
• Strong knowledge in building Test Plans and Test Cases and in building Use Cases.

TECHNICAL SKILLS

Reporting Tools: Cognos Series 10.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio & Event Studio), Cognos Administration

ETL Tools: Abinitio (GDE) 1.10.9.3, Informatica5.1 (Designer, Server Manager, Repository Manager)

Data Visualization: Tableau 9.2

Data Virtualization: Cisco Composite Studio 6.2

Big Data Technologies: Hadoop, HDFS, MapReduce, YARN, Hive, HiveQL

RDBMS: DB2, SQL Server 2008 and Oracle

OS: Windows 95/98, Windows NT/2000

Web Technologies: JAVA (Applets, AWT, Swing, JDBC, Servlet, JSP), HTML, DHTML, FrontPage

PROFESSIONAL EXPERIENCE

Sr Business Intelligence Architect / Manager

Confidential

Responsibilities:

• Resource Management and Project Management.
• Providing POC for new Business teams to use BI tools for their reporting needs.
• Understand business strategy and Identify business opportunities for information usage.
• Develop and maintain relationships with top business and technical executives.
• Evaluate team members.
• Assess risk and Identify measures of success.
• Develop and manage the BI dependency plan, job scheduling and cycle management.
• Develop disaster recovery strategy.
• Determine and ensure execution of backup and recovery strategy.
• Ensure the BI meets service level requirements.
• Monitor business use and performance of the BI and provide feedback to BI architects, developers, metadata manager, and database administrators.
• Develop, manage, schedule and document BI operations and tasks, including extraction, movement, loading, archival, security, backup and aggregate table creation.
• Manage maintenance processes and procedures.
• Monitoring SLAs, ensuring timely closure of priority tickets, handling escalations and implementing & migrating systems to upgraded versions so as to achieve maximum efficiency in various operations
• Performance monitoring and tuning
• Involve in meeting with end user in gathering requirements.
• Design and Develop Workbooks and Dashboards using Tableau 9.2
• Design and Develop Operational Reporting and Dashboards using Cognos 10.2
• Created Data Virtualization views using Cisco Composite 6.2
• Coordinate prototype reviews/testing of reports and deployment activities

Environment: Cognos 10.1, Cisco Composite Studio 6.2, Agile Methodology, DB2, Oracle andSQL Server2008, Tableau 9.2, Apache Hadoop, HDFS, Hive, Java, Sqoop, Cloudera CDH4

Confidential, Philadelphia

BI Technical Lead

Responsibilities:

• Providing POC for new Business teams to use BI tools for their reporting needs.
• Understand business strategy and Identify business opportunities for information usage.
• Develop and maintain relationships with top business and technical executives.
• Assess risk and Identify measures of success.
• Develop and manage the BI dependency plan, job scheduling and cycle management.
• Determine and ensure execution of backup and recovery strategy.
• Ensure the BI meets service level requirements.
• Monitor business use and performance of the BI and provide feedback to BI architects, developers, metadata manager, and database administrators.
• Develop, manage, schedule and document BI operations and tasks, including extraction, movement, loading, archival, security, backup and aggregate table creation.
• Manage maintenance processes and procedures.
• Performance monitoring and tuning
• Involve in meeting with end user in gathering requirements.
• Design and Implement an Enterprise Wide Reporting system using Cognos PowerPlay, Report Studio and Analysis Studio (Used Agile Methodology for this Project).
• Schedule Reports using Cognos Connection. Created Triggers using Unix Shell Scripts and setup Control-M jobs and use them to schedule Reports.
• Exported/Imported report specification from Development server to Production Server.
• Migrated reports from Cognos 7.3 to COGNOS 8.X.
• Migrated cubes/models from Cognos 7.3 to COGNOS 8.3.
• Design and Develop Operational Reporting and Dashboards using Cognos 10.2
• Testing Functional and Non-Functional requirements in Cubes and Reports.
• Tuning the Reports and Cubes to decrease the cube build time and access time.
• Define Jobs in Cognos Connection to execute multiple reports.
• Created Data Virtualization views using Cisco Composite 6.2
• Create XML Scripts to deploy Packages between Servers using SDK.
• Creating Control-M Jobs to execute Reports and Transformer models.
• Creating scripts to move the Cognos Reports to FileNet.

Environment: Cognos 10.1, Cisco Composite Studio 6.2, Agile Methodology, DB2, Oracle and SQL Server2008, Tableau 8.3

Confidential, Hartford

Tech Lead / BI Project Manager

Responsibilities:

• Resource Management and Project Management.
• Providing POC for new Business teams to use BI tools for their reporting needs.
• Understand business strategy and Identify business opportunities for information usage.
• Develop and maintain relationships with top business and technical executives.
• Evaluate team members.
• Assess risk and Identify measures of success.
• Monitor BI usage capture and maintenance of metrics.
• Develop and manage the BI dependency plan, job scheduling and cycle management.
• Develop disaster recovery strategy.
• Determine and ensure execution of backup and recovery strategy.
• Ensure the BI meets service level requirements.
• Monitor business use and performance of the BI and provide feedback to BI architects, developers, metadata manager, and database administrators.
• Develop, manage, schedule and document BI operations and tasks, including extraction, movement, loading, archival, security, backup and aggregate table creation.
• Manage maintenance processes and procedures.
• Performance monitoring and tuning
• Administer user access and security.
• Involve in meeting with end user in gathering requirements.
• Estimation, Scheduling and Release Management
• Gathering and analysis of Business Requirements
• Creation and review of Technical specification for Data model and reports
• Creation and Maintenance of DataModel using Framework Manager
• Creation and review of reports developed using Report Studio
• Onsite - Offshore coordination
• Creation of various metrics to measure the quality of the deliverables

Environment: Cognos 8 (Framework Manager, ReportStudio, QueryStudio), Datastage

Confidential

Team Lead

Responsibilities:

• Estimation, Scheduling and Release Management
• Configuration & Defect Prevention Management
• Analyzing Business Requirements
• Development and maintenance of Catalogs
• Creation of Reports using Impromptu
• Maintenance of DB2 Schema
• Documentation of design documents, Performance Metrics

Environment: Cognos 7.1 (Impromptu, Access Manager,Upfront)

Confidential

Responsibilities:

• Analyzing Business Requirements
• Design of Documents and Detail Design Documents creation
• Development and implementation of Catalogs, Cubes and Reports
• Involved in testing and fixing of bugs.
• Writing Test Cases.