SUMMARY

• 13+ years of expert level experience in Cognos BI and Data Warehousing including Cognos suites V8.4.x, Cognos 10.1.x BI, Cognos 10.2.1 BI, Cognos 10.2.2 BI and Cognos 11, Tableau Desktop, Tableau Server.
• Experienced in Cognos BI Development and a wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation of the business technology solutions.
• Extensively worked in various domains like Banking, Finance, Life Sciences, Retail and education.
• Experience withRelational and Dimensional data modeling using ERWIN, understanding ofRalph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach
• Proficient with Cognos SDK, Framework Manager modeling, workspace, Analysis Studio and Report Studio
• Design and develop enterprise wide Data modelling, Framework Manager models, OLAP and Multidimensional modelling
• Designed and Developed BI reports, Dashboards, Active Reports and visualizations using Cognos, Tableau.
• Manages full system life cycle for BI projects including analysis and design, construction, testing and implementation
• Experienced in developing cubes with powerplay transformer, dynamic cubes, OLAP cubes and automation of cubes building.
• IBM Cognos BI administration skills such as installation and configuration, IIS installation & management, performance tuning, troubleshooting, and configuring client software on Windows and UNIX.
• Experience in dealing with Apache Hadoop components likeHDFS, MapReduce, HiveQL, HBase, Big Data and Big Data Analytics.
• Designed & Developed complex Report studio reports with conditional rendering, drill - through capability, prompts, dashboard-style reports combining list, cross-tabular, chart displays, burst reports and Active reports.
• Designed and implemented Enterprise Level Security, Application level Security, Role based Security, Folder level security, User Group access and Roles.
• Trained users on Cognos BI user tools like Cognos connection, Cognos query studio, analysis studio and provided technical guidance and best practices.
• Evaluate new tools and technologies and work on POCs as needed

TECHNICAL SKILLS:

BI Tools: Cognos Analytics, Cognos 10.2.2 BI (Framework Manager, Report Studio, Workspace, Analysis Studio), Cognos Administration, Cognos Power play and Transformer, Cognos Cube Designer, Cognos SDK, Cognos TM1, Tableau Desktop, Tableau Server, SSRS

Languages: JavaScript, SQL, PL/SQL, UNIX Shell Scripting, Java2.0, HTML

RDBMS: Oracle, MS SQL Server, DB2, Netezza, Teradata

ETL: Informatica, MS DTS

Environment: Windows, UNIX

Modelling Tools: Erwin, ER/Studio

Big Data: Hadoop, MapReduce, HDFS

PROFESSIONAL EXPERIENCE

Confidential, FL

Senior Cognos Consultant

Responsibilities:

• Worked on BI strategy and execution plan for conversion of hundreds of reports from legacy source system to guidewire datahub system.
• Involved in extensive analysis of source systems, existing database architecture, mapping reporting requirements.
• Accomplished the strategic execution of projects to ensure the processes align to the customer's plans and technology road maps architecting OLAP data model schemas for cube development allowing analytical reports to render at maximum
• Provide Technical recommendations for optimized data access and retention for the data warehouse and review of Solution architecture, High Level design documents. Build repository of reusable knowledge assets and implement best practices, concept documents for client education.
• Identify opportunities for value addition to for effective use of BI applications, Lead aspects of proposal development process, scope out effort and cost of solution, develop statement of work

Environment: IBM Cognos Analytics, IBM Cognos 10.2, DataStage, Oracle10g, SQL Server, JavaScript, Erwin

Confidential, Washington, DC

Sr.BI Consultant

Responsibilities:

• Conducted/attended requirements definition meetings with end users and document system/business requirements
• Worked on identifying and conducting detailed data analysis of different source systems.
• Develop an in-depth understanding of the business processes and data in the corporation and apply the knowledge towards developing and maintaining the Corporate Data Model and a Metadata Portal
• Designed and developed Data model, Cognos framework modelling and dashboard reports, Active Reports.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Worked on tableau servers to take backups, sending alerts and configuring SAML for authentication.
• Developed data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
• Given demos for end users and interacted with them to understand the requirements

Environment: IBM Cognos 11, Tableau Desktop, Informatica, Oracle10g, SQL Server, JavaScript, Erwin

Confidential, Cambridge, MA

Sr.BI Consultant

Responsibilities:

• Involved in Dimensional modeling (Star Schema) of the Data warehouse, used Erwin to design the business process, dimensions, and measured facts.
• Install and configure IBM Cognos 10.2.2 software on servers (multiple environments).
• Produced standard reports for various business needs using best approach and fine-tuned the performance based on the users need.
• Design, develop, and implemented dynamic cubes using IBM Cognos Cube Designer.
• Delivered multiple projects with challenging design and timelines.
• Given demos for end users and interacted with them to understand the requirements.
• Designed and developed Data model, Cognos framework modelling and dashboard reports, Active Reports.
• Implemented best practices in role playing dimensions and row level security at the model level.
• Implemented different functionalities for dashboard like having tabs and bursting.

Environment: IBM Cognos 11, IBM Cognos 10.2.2 BI, IBM Cognos Cube Designer, Tableau Desktop, Tableau Server, Oracle10g, Informatica, JavaScript, Erwin

Confidential, Chelmsford, MA

Sr. BI Consultant

Responsibilities:

• Performed installation, configuration and upgrade.
• Worked on writing stored procedures and complex sql queries.
• Given demos for end users and interacted with them to understand the requirements.
• Developed reports with a Computerized Maintenance management System.
• Designed and developed Data model, Cognos framework modelling and dashboard reports, Standard Reports.
• Used Cognos Transformer to Build multidimensional cubes and Automate the Cube Build Process.
• Migrated thousands of reports from Cognos 8.4 to Cognos 10.2.
• Provided technical guidance to junior developers

Environment: IBM Cognos 10.2 BI, Tableau Desktop, Tableau Server, Oracle10g, Cognos Powerplay and Transformer, Informatica, JavaScript, Erwin

Confidential, New York, NY

Senior Technical Specialist/Architect

Responsibilities:

• Designed and implemented DMR for multidimensional analysis of relational data which enables the user to slice and dice the data and also drill up and drill down behavior.
• Implemented model based entitlements based out of stored procedure and defined joins across different dimensions to enable the data level security.
• Worked on integrating Cognos with java application using sdk for running and archiving reports for different submissions.
• Implemented customized URL's to launch adhoc templates using business Insight advanced to enable the users to build their own adhoc reports.
• Implemented Dynamic filtering, Dynamic sorting, Javascript to concatenate multiple prompt values to input stored procedure.
• Implemented enhanced functionality collapsible hierarchy using Javascript that expands reports on different columns with better layouts.

Environment: Cognos 10.1.1(Report Studio, Business Insight Advanced, Business Insight, Analysis Studio, Cognos Connection, Framework Manager, Cognos Enterprise Planning,Cognos SDK, Oracle10g, Cognos TM1, Business Objects, Javascript

Confidential, Washington, DC

Cognos Consultant

Responsibilities:

• Cognos 10 installation and configured IIS, content store (Sql server database), security (namespaces), webserver setup. Followed best practices in configuring the server and setting up the environment.
• Created multidimensional model using transformer based on calculated measures and budget system taxonomy and published a cube package based on that.
• Worked on Javascript in implementing various functionality includes freezing panes across row and column wise.
• Cognos administrative activities like Deploying codes to different environments, setting up access levels, Customizing the portal (Skinning), Single sign on with dot net application.
• Tuned the reports which were running for more than ten minutes to 3 minutes.
• Trained users in query studio and provided sample report Studio reports to the users for getting them used to the report layout and functionality.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Environment: Cognos 8.4(Report Studio, Analysis Studio), Cognos Connection, Framework Manager, Cognos SDK, SQL Server

Confidential, Newark, NJ

Cognos Consultant

Responsibilities:

• Worked closely with the users, developed prototypes and participated in project meetings.
• Tuned the performance of the model using governor settings and removed loop joins by creating shortcuts.
• Developed Standard Reports using report studio and high level executive dashboards using business insight.
• Converted SSRS reports to cognos reports.
• Trained users on analysis studio and business insight advanced.

Environment: Cognos 10.1.1(Report Studio, Business Insight Advanced, Business Insight, Analysis Studio, Cognos Connection, Framework Manager, Cognos SDK, SQL Server, SSRS

Confidential

Report Developer/ Metadata modeler

Responsibilities:

• Worked closely with the users, Business Analyst in gathering requirements, developing prototypes, getting the BRD approval and participated in project meetings.
• Created Models using star schemas and snowflake schemas, Packages using Framework Manager. Published and managed packages.
• Scheduled, Monitored and Controlled access by creating groups, roles etc. using Cognos Connection.
• Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
• Involved in Migration of Cognos 8.2 version reports to Cognos 8.4.1 version.
• Scheduled and Bursted Reports on weekly, monthly basis.

Environment: Cognos 10, Cognos Suite 8.4(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager, Cognos VVM), Cognos SDK, Toad 8, Oracle10g, Netezza, IBM DB2, Cognos 8.4 Powerplay and Transformer, Javascript,Microstrategy

Confidential, Irving, TX

Business Intelligence/ Report Developer

Responsibilities:

• Used Framework Manager to build models, packages and publish packages to the ReportNet Server.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
• Created prompts, Calculations, Conditions, Filters, Multilingual Reports Using Report Studio.
• Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through Developed Combine Filter, User-Defined Filters, Custom ranking using Analysis Studio
• Created Models based on the dimensions, levels and measures required for the analysis-using Transformer.
• Tuned the performance of the Cognos Cubes and publishing Cubes on to the Powerplay Enterprise Server.
• Closely worked with data warehouse designers to refine data and metadata.

Environment: Cognos Suite 8.1(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager), Cognos SDK, Cognos PowerPlay7.3, Cognos Transformer7.3, Teradata, Windows 2000, Business Objects

Confidential

Cognos Developer

Responsibilities:

• Used Framework Manager to build models, packages and publish packages to the ReportNet Server.
• Created reports using Cognos Impromptu, Transformer, Power Play, Power Prompts and Visualizer.
• Designed, developed, and tested Power cubes and deployed them in to production.
• Worked on Cognos Security Administration to Create, Maintain groups.
• Involved in Data mapping between multiple data transaction systems. Database triggers, Sequences, Indexes and fact tables were widely used in providing data integration and security.

Environment: Report Net 1.1(Framework Manager, Report Studio, Query Studio, Cognos Connection), CognosImpromptu7.3/, CognosPowerplay7.3, Cognos Transformer 7.3, SQL Server 2000, Unix, Windows 2003.

Confidential

Developer

Responsibilities:

• Created the catalogs for the users and managing & testing of catalogs with Cognos Impromptu.
• Created the reports for sales of the different products for different regions and demands for future forecasting.
• Created Models based on the dimensions, levels and measures required for the analysis.
• Used MS Analysis to build multidimensional cubes and used it in Metrics analysis to build graphs and charts of sales data.
• Involved in performing Administrative tasks like user authentication, creating new users for the cube.
• Pivoting, Drill Down, slice and dice and filtering operations done for all OLAP applications.
• Involved in creating IWR to publish reports on a web.
• Performance tuning of power cubes to reduce calc time and partitioned cubes.
• Creation of standard filters, calculations, prompts and conditions in catalog.
• Exception highlighting. Created Reports, list prompts and drill through reports.

Environment: MS-SQL Server 7.0/2000, Cognos Impromptu7.0, MS DTS, MS Analysis Services, IWR, MS-OLAP Services and Windows NT, Cognos ReportNet