Manager Data

KIRAN VALLABHANENI

678-***-**** adcmif@r.postjobfree.com

Data & Analytics Architect

Senior Data and Analytics Solution Architect with hands-on experience in analysis, design, development, testing and architecture analysis of scalable and highly available solutions. Expert in in delivering solutions with large scale distributed computing and data processing to enable analytics driven decisions.

Proficient in an assortment of technologies, including Cognos, Tableau, Qlik, Hive, AWS, Python, COBOL, Oracle BI, Power BI, Informatica, Data Stage, Oracle, DB2, Teradata, SQL Server, My SQL, Data Science, SSIS/SSRS, Unix, Mainframe Systems. Strong communications skills combined with the ability to lead diverse teams to achieve organizational objectives.

AREAS OF EXPERTISE

Business Intelligence ● Big Data Strategy ● Data Visualization ● Information Delivery Design ● Architecture

Data and Analytics ● Data Analysis and Discovery ● Data Science

Leadership ● Team Building and Mentoring ● Project Management ● Agile ● Strategic Planning

PROFESSIONAL EXPERIENCE

AMERICAN AIRLINES INC, Dallas, TX

Principle Programmer/Tech Lead, 2011-Present

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.

Floor and Décor Outlets of America, Kennesaw, GA

Senior Business Intelligence Architect, Mar 2011- June 2011

Partner with senior leadership to ensure business objects are appropriately utilized for all required management and ad hoc reporting, as well as data extracts for shared data agreements.

Design and implement systems that meet the requirements of business intelligence systems; perform technical and advisory functions in the development of business objects architecture and the creation of frameworks for reporting, dashboards, delivery, scheduling, and object retention policies for complex information systems.

Designed Logical Data Model and database objects and developed Semantics Layers

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

Migrated existing Cubes from 7.4 environments to Cognos 8.4 and used the deployment feature to avoid cube swap issue from the existing system.

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

Used the existing Cognos 8.4 Content store and Data Manager Catalog database during migration so as to carry over the existing security.

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

Created Dashboards depicting daily and weekly trends for the Delivered and Written sales in different categories like Ceramic, Porcelain, Glass, Accessories and Wood.

Created Fact builds, Dimension builds and Job Streams to extract transform and load application data generated by GERS 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 Powerplay 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 Powerplay 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.

Designing Data Modeling and Loading data from multiple data sources.

Collaborated with business users on effective regression testing of Enterprise Reports.

Authored and distributed white papers, best practices, and template documents.

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

VERIZON WIRELESS, Orangeburg, NY

Business Intelligence Architect, Jan 2010 – Mar-2010

Installed, defined architecture standards and best practices, and provided full technical support for the Enterprise Cognos platforms within a shared networking environment.

Installed client software development kits (SDKs) and client/server single sign-on (SSO) configuration with Windows Active Directory (AD) authentication.

Architected and installed Disaster Recovery and Performance optimization techniques.

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

Built Multidimensional Cubes using Transformer.

Implemented cube groups, incremental updates and time based partitioning to improve the performance of the Powerplay cubes.

Automated the cube builds using windows batch scripts.

Responsible for the cube performance tuning and reducing cube build time.

Created metadata models against relational databases for creating OLTP reports and also created DMR models in Framework Manager for OLAP reports against live data.

Utilized HTML & JavaScript to customize Cognos reports as per the business requirements.

Set up alerts using event studio.

Created report mockups to set user expectations.

Worked extensively with ETL team.

Performed deployments across different cognos environments.

Optimized performance of existing data warehouse and BI applications.

Created multiple Models for ad-hoc and canned reports based on the relational data model that will replace the existing Stored Procedures as the data sources.

Conducted end-user training to assist in the understanding of data models, building queries, and use of the Business Objects tool.

UPS, Alpharetta, GA

Senior Business Intelligence Consultant, Oct 2007- Nov 2009

Installation and Configuration of the Cognos 8 and Cognos Reportnet 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.

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.

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

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.

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

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

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.

Created prompts using Java scripts in Cognos Reportnet and Cognos 8 environments.

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

Worked as a Quick Turn team member to resolve Production issues.

Involved in understanding existing Business Model and Customer Requirements by participating in the SRS review meetings and created Technical Design Documents and created Unit Test Case documents.

Created reference documentation for some of the important tasks to be performed in cognos environment.

Built Power Play Reports based on the cubes and published to ReportNet 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 PowerPlay objects.

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

Datasteam - Infor, Greenville, SC

Business Intelligence Consultant, June 2006-Oct 2007

Worked with the clients to generate their own Custom Reports.

Took Training Classes on Cognos Reportnet for various clients.

Designed models using Framework Manager and deployed packages to the Report Net Servers

Implemented Star Schema Grouping

Customizing Cognos Connection Portal based on user specifications.

Joins are not Predefined in Datastream 7i so used Tabular SQL on most of the reports.

Worked on Tabular Model, Tabular reference, Tabular Set.

Worked on Predefined Functions provided by Datastream 7i.

Installation and configuration of the Cognos Report Net Environment.

Designed models using Framework Manager and deployed packages to the Report Net Servers.

Created database layer and business layer, defining appropriate relationship between query subjects.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query, Burst Reports against database.

Created custom templates and custom toolboxes for the use of reporting.

Designed Power Play reports to provide summarized results by measures and dimensions.

Created custom prompted reports in Report Studio, Bursting reports to different user groups.

Moved projects from development to QA and then Production servers

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

Creating a Drill through from Power Play to Cognos Reportnet.

EDUCATION

Masters in Computer Science

New Jersey Institute of Technology, New Jersey, USA

Bachelor of Engineering in Computer Science

R.M.K. College of Engineering, Chennai, India

CAREER HIGHLIGHTS

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

TECHNICAL PROFICIENCIES

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

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

AWS, Amazon Redshift, Azure, Big Data, SQL, Apache Hadoop, Python, Unix, HTML, Java, Tomcat, WebLogic, WebSphere, Microsoft IIS

Alteryx, Tableau Prep, SSIS, Informatica, Data Stage

Contact this candidate