Manager Data

SUMMARY:

Over **+ years of total IT experience with Sound knowledge and experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production.

Strong understanding of relational database design concepts and in-depth knowledge of OLAP solutions using Cognos EP Series 7 Tools such as Cognos 11.X/10.2.1/10.1.1/ 8.4 CognosReportnet 1.1.MR3, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Power Prompts, and Analysis Tools such as Cognos Transformer &Power Play 7.x/6.x, Cognos Visualizer 7.0, Access Manager, Server Installation & Maintenance.

Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building.

Strong Knowledge with Transformer model design and Power Play cube building.

Data Modeling Tools like Erwin using Oracle, DB2, UDB, Teradata, and MSSQL Server databases.

Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.

Involved in migrating Cognos EP Series 7 to CognosReportnet. Involved in a data migration process between different versions of Cognos.

Worked on Planview Lifecycle process and Planview Manager. Convert Planview knowledge into Cognos Framework manager and Cognos Planning reports.

Worked on migration of Impromptu catalogs to Cognos 8.4 and upgraded Frame Work Packages from Report Net 1.1MR3to Cognos 8and reports from Report Net 1.1MR3 to Cognos8.4

Extensively worked on customization of Cognos Connection Portal to resemble application look and feel.

Extensively worked on building prompts and prompt pages using Java Scripts.

Extensively worked on Data Warehouse and Business Intelligence projects with ETL teams

Extensively worked with SQL Analyzer, SQL Plus, Oracle SQL Developer and TOAD.

Team player with excellent interpersonal skills and the ability to work well with co-workers.

Excellent in communicating at all levels of management with experience in coordinating various client meetings, seminars, presentations and group discussions.

Co-ordinated with various offshore teams on Design and Development of code.

Provided technical and functional consulting to corporate and divisional users for Cognos.

Involved in creating and working with PL/SQL stored procedures.

Extensive work on Data Extraction with Oracle, SQL Server& MS-Access.

Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem-solving skills.

Educational Qualification:

Graduate – Master’s in software engineering.

Certifications:

IBM COGNOS 10.1.1 IBM Certified Designer

Technical Proficiencies:

Cognos, Tableau, Qlik, Power BI, MicroStrategy, Oracle BIEE, SSIS, SSRS, SAP BI/BW, Crystal Reports

Oracle, Teradata, Amazon Redshift, DB2, SQL Server, My SQL, Ingres II, FoxPro, MS Access, Lawson

SQL, PL/SQL, HTML, WebLogic, WebSphere, Microsoft IIS

Alteryx, Tableau Prep, SSIS, Informatica, Data Stage

EXPERIENCE:

American Airlines - Dallas TX Feb’17 to Present

Position: Sr. Business Intelligence Consultant

Description:

The projects involved developing Business Intelligence (BI) applications for the Airlines Technical Operations Division (Tech OPS).

Worked on various applications creating BI Reports/Analysts for the Sr Leadership on Operations, Maintenance and Supply Chain front to take prompt actions for better results. Worked with various Application/Database Architects to produce seamless navigation across BI Products and Applications.

Some of the High-Profile Projects that I had worked on that helped different Business Units and Leadership across the company are,

Projects –

1)ODR - Open Discrepancies

2)OSP – Oil Servicing Program

3)ASOM – Aircraft Out of Service

Aircraft Open Discrepancies –

It is an operational tool that provides the Material Planning group with Scheduled Maintenance Bill of Work (BOW) and Bill of Material (BOM). The planners review the exceptions to ensure we have stock at the stations to support the requirements. Without the report/tool the Material planning group has no visibility of Part shortages and can impact the Airline operations.

I developed a product called Open Discrepancies, (ODR) which helps Material Planners, AOG and IOC to forecast on what is required for overnight maintenance and helps them to forecast Material Requirements and Part Movements for the next 90 days.

To gather this information, I had to tap into multiple source systems ART/ WCMS/FOS DECS/SAP/MAPS which gives them picture ahead of time on

1) What AC’s that overnight at the Maintenance Stations.

2) What Maintenance needs to be performed on these ACs.

3) What Parts/Tools/Materials are required for the Maintenance.

4) What’s the Part stock availability at these Stations.

5) Quantity Filled – Various Parts movements happen throughout the day Inter/Intra Station Loan Transfers and the stations don’t have a clear visibility on where they are and when they arrive. Part Movements are handled differently in AAPICS and SAP systems and I had to implement some complex business rules within the report.

This product was developed using Cognos as the BI tool and had lot of performance issues, which I overcome by using various query optimization techniques that were available on both the Database front and on the BI platforms.

Hourly Maintenance Dashboard –

The Hourly Maintenance Dashboard is used for identification, summarization, and distribution of information about Flight Operations including Delays and Cancels, Maintenance, Minimum Equipment List (MEL), Non-Essential Furnishing (NEF), and Aircraft out of Service (OTS) by fleet.

The Dashboard helped the Senior Leadership to get an overview of the Tech Ops operations and helped them to make some key Business changes.

Responsibilities:

Held responsibility for improving scalability, efficiency by managing and monitoring execution in the development operations and worked closely with the development team.

Wrote complex data transformation and calculation logics which provides insights on Flight Operations including Delays and Cancels, Maintenance, Minimum Equipment List (MEL), Non-Essential Furnishing (NEF), and Aircraft out of Service (OTS) by fleet.

Performed deep-dive statistical analysis and created predictive models that were used to predict Aircraft Health.

Created and setup Datalake environments by extracting data from the IMS databases and generated queries for Stores/Parts Receiving/Ordering and Engineering Applications.

Designed and developed multiple forecasting and utilization dashboards using Tableau and Cognos

Created Active Reports (using data tabs, data decks etc.) and Dynamic Cubes in Cognos.

Created Materialized views in the database to improve run time performance of the reports.

Develop Metadata models in Framework manager as per the business requirements.

Identified and implemented Agile best practices that help team velocity and effectiveness.

Analyse complex distributed production deployments, and develop a plan to optimize performance

Oversaw analysis and functional specifications of business models, executing complex operational and statistical analyses for Customer Insights and Analytics initiatives.

Designed and developed BI solutions, Tableau dashboards and for various teams like Reliability, Supply Chain, MOC, IOC Techops at American Airlines.

Worked within an Agile BI framework driving the users to self-serve BI and offer flexibility in Delivery, User Adoption.

Created interactive Tableau dashboards/stories with Advanced Mapping Techniques, Parameters, Custom Geocoding, Data Blending and complex calculations.

Designed Dynamic Cubes – in memory tool using Cube Designer tool and deployed in the Cognos 10 environment to increase the performance which is using large data sets.

Expertise in Performance optimization techniques.

Worked extensively on Teradata SQL scripts to generate the data sources for the dashboards.

Exhibit strong data analysis skills to identify, review and evaluate the data structures.

Identify and report risks throughout the life of the project and provide mitigation strategy for those risks.

Identify, review, and evaluate existing data structures.

Construct data decomposition diagrams provide data flow diagrams and document the process.

Identify and document data quality issues and data patterns.

Identify opportunities for improvement as well as innovate

Manage a team of onshore/offshore developers charged with supporting cost-effective corporate BI development.

Environment:

Cognos 11, Cognos 10.1.1 BI, Cognos 8.4 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Power Play Studio, Cognos GO Office, Tableau, Power BI, IBM DataStage ETL, Alteryx,, Python, R, SQL Server Teradata, Oracle

Cigna HealthSpring – Nashville Jan’15 – Jan’17

Position: Sr. Business Intelligence Developer

Description:

QNXT drives the Medicare and Medicaid business for HealthSpring. Cigna-HealthSpring integration projects include Arizona, Centricity, Catamaran and FACETS. SDM is to accumulate and analyze the sales commissions for healthcare products. ODS is the initial store of all source systems with audits. IRDM has the analytical information for various dashboards such as Member, Provider, Critical care, etc. In parallel the Oracle and SQL Server databases reports are being migrated to Teradata databases.

Responsibilities:

Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.

Analysis of data necessary to resolve issues uncovered relating to source data

Optimize the Cognos 10.2.2 reports performance.

Defined, stored and maintained security information using Access manager.

Implement Package Security.

Troubleshoot and resolve functional issues.

Installing the Content Store

Creating User Classes in Access Manager and adding users to those user classes

Creation of procedures, views, tables and functions according to business requirements in Oracle.

Involved in Migrating metadata and reports from Cognos 10 to Cognos 10.2.2 using utilities.

Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio and Report Studio

Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.

Expertise in developing Dashboards, Visualizations and Active Reports.

Created Active reports (using data tabs, data decks etc.) and updated Active Reports using Scheduled jobs.

Solved schema-designing problems by creating aliases, defining contexts and using features available in Designer to separate queries on measures or contexts

Created a portal page in Cognos to depict a web page on company portal having links to Cognos Power play reports and Cognos 8 reports.

Created reports such as Job Size, Port Warehouse Inventory Management, Gross Margin Reports against the finalized Freight and non-finalized freight factors present in the cube.

Maintained the scheduled data manager jobs to generate cubes to support legacy Power play reports and the Dimension and Fact tables in SQL Server 2012 Data warehouse.

Environment:

Cognos 10.2.2, Cognos 10.1.1 (Framework Manager, Query Studio, Report Studio), Cognos Mobile, Informatica, SQL Server 2008/2012, Oracle 11g, Teradata 14, Informatics 9.5.1, Tableau.

TVA (Tennessee Valley Authority) – TN Jan’10 to Dec '14

Position: Sr. Cognos Developer

Description:

The Tennessee Valley Authority is a federal corporation and the nation’s largest public power company, TVA’s power-service area covers 80,000 square miles in the southern United States, including almost all the Tennessee and parts of Mississippi, Kentucky, Alabama, Georgia, North Carolina and Virginia.

Responsibilities:

Installation and Configuration of the Cognos Reportnet 1.1 MR3 environment and upgraded to Cognos 10.2.1 on Test and Production Environments.

Worked on Cognos 10.2.1 framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Report Net server.

Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.

Analysis of data necessary to resolve issues uncovered relating to source data

Optimize the Cognos 10.2.1 reports performance.

Defined, stored and maintained security information using Access manager.

Implement Package Security.

Performed Pivoting, Drill-down, Slice & Dice and Filtering operations for all OLAP applications.

Created Active Report which provides an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.

Design, develop, and implement Cognos TM1 9.5.2 Applications for Financial planning and budgeting models with complex rules.

Troubleshoot and resolve functional issues.

Installing the Content Store

Creating User Classes in Access Manager and adding users to those user classes

Creation of procedures, views, tables and functions according to business requirements in Oracle.

Examined store procedures using PL/SQL, which were used to transform data

Optimized SQL for faster extraction.

Involved in Migrating metadata and reports from Cognos 8.4 to Cognos 10.1 using utilities.

Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio and Report Studio

Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.

Solved schema-designing problems by creating aliases, defining contexts and using features available in Designer to separate queries on measures or contexts

Implemented the Index Awareness and Aggregate Awareness for faster query responses and thereby improving the report performance.

Extensively worked in Scheduling and Deploying (Staging to Production) Reports.

Worked on complex reports using Tabular Objects, Static Prompt conditions.

Built Power Play Reports based on these cubes and published to Report Net Server.

Administering the business users in the portal based on the requirements.

Helped the team members in resolving any technical issues with Cognos Report net and Power Play objects.

Co-coordinating with Cognos Support team in resolving the technical issues of the Cognos suite of products.

Environment:

Cognos 10.2.1, Cognos 10.1.1, Cognos 8.4Cognos ReportNet1.1 MR3 (Framework Manager, Query Studio, Report Studio), Cognos Mobile, Migration Utilities, Informatica, TFS, SQL Loader, Access Manager, Oracle 10g/11i, Teradata, PL/SQL, TOAD, Performance Management (Dashboards), Windows NT, UNIX

Chrysler LLC - MI Jan 2009 to Dec 2009

Position: Sr. Cognos Developer

Description:

Manufacturing Resources Planning includes modules such as Product Development, Sales; Purchases module efficiently monitors purchase requisition inquiries, quotations, purchase order and tracking pending order supplies and follow-ups. It provides facility for purchase indent, authorization of indent, order preparation, order amendment and various reports. This module provides the information about the status of sales order and allies’ information.

Responsibilities:

Installed, configured and migrated the existing Cognos 10.1.1 BI POC/production installation consisting of Cognos Report Server, Framework Manager, Data Manager, Cognos GO Office, Transformer and Power Play Client.

Team player with excellent interpersonal skills and the ability to work well with co-workers.

Excellent in communicating at all levels of management with experience in coordinating various client meetings, seminars, presentations and group discussions.

Co-ordinated and closely worked with various offshore team on Design and Development of code.

Installed database Clients for SQL Server 2005 and Oracle, established and tested database and content store connectivity on the Cognos Production environment.

Involved in trouble shooting of ODBC connection to install 32 bit ODBC, as 32 bit Cognos was installed on 64 bit windows server.

Created reports using MDX.

Developed TM1 application to gather and consolidate data in support of the footnotes in the annual report.

Manage TM1 data through TM1 Reports (Active Form & Slice).

Created and arranged different TM1 rule statements and performed complex calculations for cubes at N&C level.

Created Executive level Dashboards in Cognos showing various high level key performance indicators.

Created complex reports using tabular sets and master-detail queries.

Carried out bursting of reports to distribute reports to different end users.

Provided data security, object security and package access in Framework Manager, and also secured the folders by setting up access permission in Cognos Connection.

Created SOP for migration of Framework Manager Packages, reports, Data Manager Packages, fact builds, dimension builds and the job streams.

Edited System.xml as per client requirements to display or hide options in Cognos Connection.

Created Fact builds, Dimension builds and Job Streams to extract transform and load application data generated by Data Stage in Oracle into SQL Server 2005 data warehouse to support varied reporting needs.

Created a portal page in Cognos to depict a web page on company portal having links to Cognos Power play reports and Cognos 8 reports.

Created reports such as Job Size, Port Warehouse Inventory Management, Gross Margin Reports against the finalized Freight and non-finalized freight factors present in the cube.

Maintained the scheduled data manager jobs to generate cubes to support legacy Power play reports and the Dimension and Fact tables in SQL Server 2005 Data warehouse.

Monitored and used the Data Manager logs on a daily basis to debug the Cube build failures and the data warehouse inconsistencies.

Unit tested the update reports for performance and consistency against different amounts of test data.

Environment:

Cognos 10.1.1 BI, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Cognos GO Office, Cognos Data Manager, Datastage, Cognos TM1, SQL Server 2005, Oracle, IIS webserver, Windows Server 2008 R2 and Toad, SQL Dbx

Client: AT&T – GA Jan 2008 to Dec 2008

Position: Cognos Developer/ETL Developer

Description:

An ODS and DWH implementation to build new set of Cognos reports for AT&T. A common data warehouse model is developed to collect the DMLs for the close of business day to create contracts and revenue. Oracle BPEL Process Manager is used to orchestrate disparate applications and Web services into business processes. The ability to quickly build and deploy these processes in a standards-based manner delivers critical functionality for developing a Service-Oriented Architecture (SOA).

Responsibilities:

Installation and Configuration of the Cognos 8 and Cognos Report net 1.1 MR3 environment and upgraded reports and packages to Cognos 8.4 on Development Environments.

Worked on Cognos 8.4 Framework Manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos Connection Portal.

Implemented Star Schema Grouping

Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.

Analysis of data necessary to resolve issues uncovered relating to source data

Optimize the Cognos 8.4 reports and SQL for faster performance.

Defined, stored and maintained security information using Access manager.

Implemented Folder level security on Cognos 8 Environment and to restrict access to the sensitive information.

Co-ordinated and closely worked with various offshore team on Design and Development of code

Created complex reports using tabular sets and master-detail queries

Team player with excellent interpersonal skills and the ability to work well with co-workers..

Carried out bursting of reports to distribute reports to different end users.

Provided data security, object security and package access in Framework Manager, and also secured the folders by setting up access permission in Cognos Connection.

Tuned the performance of the reports by using functions created at the database level and filtering out unwanted data at the framework manager level and also recommended and utilized the aggregate tables in the database to achieve user acceptable level of run-time for the reports.

Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.

Worked on complex reports using Tabular Objects, Static Prompt conditions.

Extensively worked in Scheduling and Deploying (Staging to Production) Reports.

Built Power Play Reports based on the cubes and published to Report Net Server.

Administering the business users in the portal based on the requirements.

Helped the team members in resolving any technical issues with Cognos 8, Cognos Reportnet and Power Play objects.

Environment:

Cognos8.4, ReportNet1.1 MR3 (Framework Manager, Cognos Connection, Query Studio, Analysis Studio, Report Studio), Oracle 10g, Datastage, Toad, Tivoli LDAP, Migration Utilities (Impcat2xml, Migratetoc8, Deploytoc8), SQL Loader, Access Manager, Business Objects Enterprise XI 3.1.

Contact this candidate