SUMMARY

• 11 plus years of Professional IT Experience, inclusive of more than nine years of Business Intelligence and Data warehouse expertise in various business domains.
• Hands on experience in SAP Business Objects 4.0/4.2 (Web Intelligence, Crystal Reports, Dashboards, Lumira, IDT, SAP BusinessObjects Mobile, BEx Query Designer, SAP BW) and Cognos 10.1 (Cognos Connection, Framework Manager, Report Studio, Analysis Studio, Event Studio, Business Insight, Query Studio), Cognos 8.x and Cognos Reportnet, Impromptu 7.3, Cognos Power Play Enterprise Server 7.3, Power Play Transformer, Cognos SDK.
• Worked on the financial performance management tools - TM1, Cognos planning (Analyst & Contributor 8.3) by creating and analyzing the models to plan, budget and forecast activities in real time.
• More than two years of experience working in Tableau. Developed tableau data visualizations using various chart types viz. cross tab, bar chart, pie chart, heat maps, scatter plots, geographic map etc.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Expertise working with Qlikview components such as Qlikview Desktop, Qlikview Management Console (QMC), Qlikview Publisher, Qlikview Web Server and Ajax Clients.
• Adept in reviewing and analyzing the Business Processes, Business Process Flows and Implementing Qlikview Solutions.
• Expertise on creating models in Cognos 8 Framework Manager for reporting and in creating Business Layers, Hierarchies, macros & folders.
• Extensively worked with Cognos SDK (Java) as part of integrating with enterprise portal.
• Sound Knowledge on Report Studio in using Tabular Objects, Tabular SQL, Customized Prompts, Conditional Formatting and Complex Layouts - Cross tabs and sub reporting, bursting.
• Involved in Migrating the Cognos EP Series 7 to Cognos 8 Environment using Migration utilities.
• Experience with Installation and Configuring Cognos 7 and Cognos 8 Environment.
• Created Multi-dimensional models using Powerplay Transformer based on business gathering.
• Designed Developed and Implemented Cubes for various analyses / reporting purposes and worked with different Kinds of sources like Relational and Flat files.
• Designed, implemented normalized multi-dimensional Star schemas and Data Marts using Erwin4.0.
• Experience in gathering requirements and converting business requirements into functional specifications and in creating Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams and Class Diagrams with good knowledge of Business Process Modeling tools like UML, RUP and Rational Suite.
• Served as a mentor and lead the offshore team for more than two years.
• Experience in Oracle 10g/9i/8i/8.x/7.x, PL/SQL, SQL, Stored Procedures, Functions, Triggers, and SQL Server 2000, 2005 on UNIX and Windows platforms.
• Developed PL/SQL database stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Administration.
• Excellent knowledge on Data warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• Involved in the full Project Life Cycle of the Data Warehouse Project.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem-solving skills.

TECHNICAL SKILLS

Databases: Oracle7.x/8i/9i/10/11g, Teradata, DB2/400 and Microsoft Access, SQL Server 2005, 2008 (SSIS, SSAS,SQL Server Studio)

Operating Systems: Sun Solaris, Unix, Windows98/00, Windows2003, Windows XP, Windows NT4.0

Business Intelligence Tools: SAP Business Objects 4.0/4.2 (Web Intelligence, Crystal Reports, Dashboards, Design Studio, Lumira, Information Design Tool (IDT), CMC (Central Management Console), BEx Query Designer, SAP BW 7.01, Analysis for Excel) IBM Cognos 10.1 (Cognos Connection, Framework Manager, Report studio, Query studio, Business Insight, Powerplay Studio, Analysis Studio) Cognos 8 BI 8.4, 8.3, 8.2, 8.1.2 (MR2) suite (Cognos Connection, Framework Manager, Report studio, Query studio, Event Studio, Power play Studio, Analysis Studio, Metric Studio, Metric Designer), Cognos Power Play Transformer V8.x, 7.x, Cognos Report Net 1.1 (MR3) Cognos TM1 9.5/9.4.1, TM1 Executive Viewer. QlikView 10, Tableau, Power BI, Fusion Ops/Aera Technology

Financial Performance Management Tools: TM1 (v9.5), Cognos Planning 8.3 (Analyst and Contributor)

Web Developing Tools: HTML, JAVASCRIPT, FrontPage, Flash and XML

Web Servers: IIS, Netscape Enterprise Server, IE, SharePoint

Application Servers: WAS 6.0/5.1, Tomcat, Apache

ETL Tools: Data Services, Data Stage, SSIS, Informatica Power Center 5.x/6.x/7.x/8.1, Power Mart 5.0, Cognos Analytic Application

Data Modeling: Erwin 4.0, Rational Rose, MS Visio

Testing & Tracking Tools: QTP, Win Runner, Load Runner, Test DirectorQuality Center, Rational Clear Quest

Programming Languages: SQL, C, C++, JAVA and COBOL

PROFESSIONAL EXPERIENCE

Confidential, Springfield, IL

Sr. Business Intelligence (Cognos and SAP BO) Consultant

Responsibilities:

• Confidential, acquired by AmerisourceBergen in Nov 2017 is the largest privately held and fourth largest national pharmaceutical wholesaler headquartered in Springfield, Illinois. It provides a complete line of pharmaceuticals, OTCs, home healthcare products, durable medical equipment, seasonal merchandise and a wide array of marketing programs to retail pharmacies, regional chains and health systems.
• Worked with various business units such as Sales Operations, Purchasing, Finance, Category Management, Supply Chain and Pricing in developing several department specific reports for internal purposes.
• Extensively worked with business in building and maintaining Customer (Hospitals, HMO, Clinics etc.), Vendor (Bayer etc.) & GPO (group purchasing organization) reports (viz. Premier, Apexus, Novation, Innovatix, Vizient etc.) that are contractually obligated.
• Served as a business analyst in defining and implementing reporting solutions for few of the complex projects such as “CSOMP” (controlled substance order monitoring program) that monitors the controlled substance (C2 to C5) sales and “Contract Compliance” which assist customers on missed opportunities by evaluating their purchase history. This report is generated from business objects and published on Order Base Xpress as an iframe.
• Designed Service Level reports for certain vendors and dashboards with complex business logic viz. vendor dashboard prototype (for Bayer) and Pricing dashboard with all the required KPI’s.
• Developed dashboards in SAP BusinessObjects Mobile for sales reps to share business insights instantly and to uncover the data trends with the customers.
• Developed reports in Cognos and later migrated them all to SAP BusinessObjects pertaining to the tool change in the company.
• Involved in design, development & unit test SAP BusinessObjects solution using Web Intelligence, Information Design Tool, and Analysis for Web/Excel, Crystal Reports, BEx (Business Explorer), SAP BW (Business Warehouse).
• Experience in BEx Query Designer and SAP BW. Dynamic prompt (viz. YTD, MTD, rolling last 1 year, last 6 months etc.) is one of the functionality’s implemented which provides the flexibility to schedule the Business Objects (BOBJ) reports at various frequencies to external Customers, GPO’s and Vendors (Manufacturers).
• Developed Tableau workbooks from multiple data sources using Data Blending and in performing year over year, quarter over quarter, YTD, QTD and MTD analysis.
• Created dual bar charts with multiple measures. Developed action filters, parameters and calculated sets in creating dashboards and worksheets in Tableau.
• Involved in creating calculated fields, bins, sets and hierarchies using tableau desktop.
• Utilized tableau server in publishing the reports to the business users.
• Experience working in Fusion Ops (now called Aera Technology) which is a third-party reporting tool. Developed technical specs with business logic for the requirements implemented in Fusion Ops. Trained internal business users with the tool capabilities.
• Assisted users with installing Power BI and in setting up the connection to SAP BW. Have also guided them in running the adhoc BEx queries in Power BI.
• A Power BI dashboard is linked to the sales data in the SQL server to help forecasting the monthly sales for each category. Microsoft Access has also been linked to the sales data in the SQL server to assist with the calculation of monthly pricing scorecards.
• Developed custom dashboards/reports using Qlikview. Developed Qlikview scripts to extract, transform and load data from Excel Sheets and tested Qlikview dashboards to meet business requirements.
• Day to day activities include addressing business queries on data; fix and enhancement requests on reporting & underlining backend report queries; data validation with SAP ECC system.
• Trained end users in accessing the standard reports, interacting with prompts and in creating ad-hoc reports using OLAP. Developed data dictionary for all the adhoc queries built for end users. Trained other developers in BEx Query Designer and Business Objects (BOBJ) tools.

Environment: Tableau 10/10.1, SAP Business Objects 4.0/4.2 (Web Intelligence, Crystal Reports, Dashboards, Lumira, IDT), BEx Query Designer, SAP BW 7.01, Data Services, Cognos 10.x (Cognos Connection, Framework Manager, Report Studio, Analysis Studio, Event Studio, Business Insight, Query Studio), SQL Server 2005/2008, SAP ECC 6.0, Power BI, Qlikview 11.2

Confidential, Chicago, IL

Sr. Cognos BI Consultant

Responsibilities:

• Served as a liaison between Business & IT for multiple business areas such as BCC (Blue Care Connect), ASO (Administrative Services Only), and EPP (Enterprise Product Platform).
• Effectively communicated with Business to resolve design action items. Involved in providing both business and technical expertise in the requirements gathering, report design, report development by performing analysis of an underlying data source/schema, and support of all client/server layers and components of the data warehouse.
• Created requirement design documents used by the development team in Illinois, Texas, New Mexico & Oklahoma that addresses the business needs and the proposed reporting solutions.
• Created and worked with complex database schemas and large volumes of data (up to hundreds of millions of rows), leveraged the data to create solutions that present data through Cognos BI Dashboards and KPI's.
• Supplemented regular prompts, cascading prompts, filters, Conditional style, static headers, Drill Through, sub queries to add interactivity for users in Report Studio
• Created HTML Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Performed post-development peer review & coordinated migration/deployment of packages, reports and cube between environments.
• Assisted other developers in design and implementation of high availability/high performance SSAS solutions ensuring best practices are followed.
• Developed SQL Server Stored Procedures for data migration and transformation from Teradata extracts to SQL Server objects.
• Developed and ran Teradata SQL queries for data discovery and to identify the data issues in the source tables.
• Articulated and implemented OLAP solutions that drive strong return on investment and provide robust high availability and performance.
• Designed data models and developed back-end database solutions for high performance of SSAS cubes using T-SQL in SQL Server .
• Developed Cognos reports using MDX and Analysis Services as a data source, Passing Parameters (MDX and regular) to drill down reports, etc.
• Worked with HP Service manager and Service Desk to handle the Service calls, problem records and work orders to resolve the issues for the Business partners.
• Presented demos to the business users to expose the proficiency of upgraded versions of Cognos tools.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.
• Good understanding of systems engineering (to ensure high performance BI architecture using CPU, memory, storage, caching).

Environment: Cognos 10.1/8.4/8.3 (Cognos Connection, Framework Manager, Report Studio, Analysis Studio, Event Studio, Business Insight, Query Studio),, SSIS, SSAS, Powerplay Transformer, Teradata 13.1,SQL Server 2005/2008, MS Visio, Cognos 8.4 SDK, Hp Service Manager

Confidential, Los Angeles, CA

Sr. Cognos BI Lead

Responsibilities:

• Worked with Disney Studio segment & supported Disney worldwide users with day to day Cognos planning and BI reporting solutions from SAP BW sources.
• Implemented business process re-engineering for several business units such as Feature Animation, WDSHE ( Confidential Studio Home Entertainment), WWPOG, Pixar and Live Action, Stageplays using modern business technologies. Duties included gathering business requirements, making recommendations, preparing technical specifications and overseeing the implementation of the new processes.
• Lead a team of 8 offshore resources for the Feature Animation project by guiding the reporting solutions and ensuring timely delivery.
• Extracted data from the flat files from Cognos Finance Planning application in to staging area and populated into DB2 schemas.
• Designed and developed Framework manager models and Packages for various projects (Feature Animation, WDSHE, Pixar, Live Action..) with the source as DB2, SAP BIcubes.
• Migrated Cubes to Cognos 8 BI, Created externalized Query Subject to create Impromptu Query Definition files to use as source in building Powerplay Transformer cubes and used as a cube data source to create a package.
• Published IWRs and Power Play cubes, Power Play reports, on the portal using Cognos IWR administration, Power Play enterprise server.
• Designed and created dashboard reports and scorecards in Report Studio and Analysis Studio. Implemented Bursting for the reports.
• Developed complex reports consisting of multiple queries, and multiple joins, Unions, ranking, and drill through to other reports. Extensively used MDX OLAP functions in Creating report Studio Reports.
• Migrated Cognos objects from DEV - > QA - > PROD and Optimized Cube performance to improve the report run time.
• Involved in developing complex Informatica mappings to implement the business logic for the project. Alsoscheduled the ETLjobsin peek monthly forecasting cycles.
• Involved in production support of reports and debugging issues raised by worldwide users there by fixing them in Dev and deploying them back to Production.
• Worked on exception reports to report critical information using conditional formatting. Scheduled reports in Cognos Connection and output reports in various formats like HTML, PDF, CSV and EXCEL formats.
• Embedded cognos security within the enterprise portal as part of implementing single sign on.
• Extensively worked on java interface.
• Implemented parameterized URL's using Java SDK within enterprise web portal.
• Validated the reports against the planning data in the cognos contributor along with unit testing by writing manual SQL queries against the database. Also, validated the Planning application and the ETL to ensure data integrity between them.
• Articulated on the fly required changes in the ETL design to improvise the performance and reduce the maintenance of the reports.
• Trained end users in accessing the reports, interacting with prompts and in creating ad-hoc reports using Analysis Studio.
• Contributed in building multidimensional data models in TM1 (including Perspectives, Architect, Contributor, Web, Rules, and Turbo Integrator)
• Organized cube dimensions hierarchically in a pattern which can easily be used for reporting by Cognos BI suite (Report Studio, Query Studio and Analysis Studio).
• Contributed in the model building of FY2011 budget process. Transferred Data between contributor applications using admin links.
• Involved in developing batch scripts for running publish Marcos, GTP, and also for Transformer cubes. Worked with Cognos contributor teams for roll ups and access of data using Cognos contributor
• Developed necessary data import/export connections. Import Rights List, e.List, and Users List and Created Access Tables & Saved Selections.

Environment: IBM Cognos TM1 (v9.5), Cognos EP Analyst/ Contributor 8.3, Cognos 8.3/8.4/10.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection), Transformer 7.4, DB2,Toad, Cognos 8.4 SDK, HP Service Center, Informatica 8.6.1

Confidential, Los Angeles, CA

Sr. Cognos BI Consultant

Responsibilities:

• Interacted with the user to understand the user reporting requirements for various financial planning applications like PNL (Profit & Loss) Forecasting and Budgeting Model. Facilitated Joint Applications Development (JAD) Sessions for detailed definition of business requirements.
• Created ‘Requirement Specification document’ to define the requirement specification which addresses Functional and Non-Functional structure of the PNL BI reporting model.
• Created PNL Forecast reports for four decks (Monthly / Total Year Quarterly / Quarterly / Budget) for each individual company and created PNL Consolidated reports which captures the summarized data of the companies at different levels with drill through functionality.
• Expertise in developing Standard Reports, dash board, List Reports, Cross-tab Reports, Charts, and Multiple-levels of Drill through reports Using Report Studio.
• Deployed reports from dev environment to the prod ensuring the user group access and security.
• Validated the reports against the planning data in the cognos contributor along with writing manual SQL queries against the database. Also, validated the Planning application and the ETL to ensure data integrity between them.
• Articulated on the fly required changes in the ETL design to improvise the performance and reduce the maintenance of the reports.
• Implemented database partitioning to improve the performance tuning of all the reports that access the huge table.
• Analyzed and created indexes on certain fields to boost the performance of the reports.
• Responsible for the installation, configuration and day-to-day tasks associated with ensuring the smooth and efficient operation of Cognos environment with good Knowledge of Cognos 8 BI and Cognos Connection portal.
• Trained the users in accessing the models and assisted them in building the adhoc reports from Query studio and in creating dashboard reports using Analysis Studio.
• Participated in review meetings to propose enhancements to the existing application from business perspectives and coordinated with the users during the User acceptance phase.
• Expertise working on the Planning models built for the various applications to plan, budget & forecast activities in real time.
• Used access manager and Cognos Contributor to set user permissions and work flow access. Monitor and Maintain Job servers & Job Clusters.
• Published analyst cubes on the web using Cognos Contributor and set access using Access manager.
• Involved in developing the planning models that involved model enhancement, bug fixing and production support. Assistedend users on their budget processing for monthly, quarterly and yearly forecasting.
• Executed admin link macros upon the request for the real time reports, and performed GoToProduction on daily basis. Scheduled the batch files to publish the data from the planning to the ETL (AAF) and from ETL to the reporting.

Environment: IBM Cognos TM1 (v9.5), Cognos Planning 8.3 - Analyst / Contributor, Cognos 8.3 (Report Studio, Query Studio, Analysis Studio, Event Studio), IBM’s Adaptive Analytics Framework (AAF), SQL Server 2000 and Toad.

Confidential, Washington DC

Cognos Team Lead

Responsibilities:

• The International Finance Corporation is the private sector arm of the Confidential Group. Worked on multiple Financial Reporting Projects. Created, Upgraded and migrated Reports.
• Interacted with the user to understand the user requirements and facilitated Joint Applications Development (JAD) Sessions for detailed definition of business requirements.
• Developed business requirements document and identified all necessary Business Use Cases from requirements, created UML using Microsoft Visio.
• Participated in review meetings to suggest enhancements to the existing application from business perspectives and coordinated with users during the User acceptance phase.
• Reported various financial balances using Reportnet 1.1, Created Corporate Global Financials Reports and also worked on US-GAAP to IFRS changes proposed to Equity and Loan Reports.
• Created Catalogs, Joins, table aliases to build metadata model and created folders, reusable filters, conditions, prompts, pre-calculations which was used globally in all the reports built using the catalog for Portfolio Loss Reserves department.
• Developed Impromptu Reports for Portfolio Loss Reserves department and published to upfront portal using Cognos Server Administration tool.
• Collected Requirements for the US-GAAP to IFRS changes proposed to the Non Performing Loan Reports and created views to report the new balances and modified balances.
• Fixed the Upgraded reports and Framework Manager Models from Reportnet 1.1 to Cognos 8.2.
• Worked on understanding business objectives of IFC, Analyzed the existing reports in Series 7.1 and planned migration project procedure from Series 7 to Cognos 8.2
• Coordinated with the team as a lead and worked in phases to complete the migration project as we had 350 reports to fix.
• Worked on existing and migrated Framework Manager Models, created new Framework Manager Models, imported metadata from multiple data sources. Built Presentation Layers and published packages in Reportnet Server and also in Cognos 8 Server.
• Migrated Cubes & reports from Cognos 7 to Cognos 8 BI. Validated migrated metadata models and reports in Cognos 8 BI environment.
• Created externalized Query Subject to create Impromptu Query Definition files to use as source in building Powerplay Transformer cubes and used as a cube data source to create a package.
• Worked on Report Studio in creating List, Crosstab, and Chart reports to deliver the information that would otherwise require two or more reports. Worked on multiple page reports, multiple prompt pages, and prompts and cascading prompts.
• Worked on exception reports to report critical information using conditional formatting. Scheduled reports in Cognos Connection and output reports in various formats like HTML, PDF, CSV and EXCEL formats.
• Worked on unit testing by writing manual SQL queries against the database to validate reports.

Environment: Cognos 8.2, Cognos Reportnet 1.1 on Windows 2000, Framework Manager, Report Studio, Query Studio, Cognos Connection, Cognos Configuration, Cognos Series 7.1 Impromptu, Impromptu Web Reports (IWR), Powerplay Transformer and Powerplay Enterprise Server, Cognos Series 7.4. Oracle 9i, Oracle 10g, 11g and Toad.

Confidential, Allentown, PA

Jr. Business Analyst

Responsibilities:

• Analyzed the Project Definition Documents to provide work estimates to gather and document business and functional requirements.
• Assisted project sponsors to define the project scope.
• Analyzed, defined and manage the business needs.
• Gathered initial project requirements. Conduct individual and group sessions with sponsors and users to gather business requirements.
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products and processes.
• Documented the business requirements and help the business to signoff the business requirements.
• Created Use-Case diagrams and State diagrams using MS Visio
• Developed business and functional use cases, project plans and manage the project scope.
• Performed GAP analysis of business rules and process flows.
• Provided strategic support in development of detailed project plans, work assignments, target dates etc.
• Conducted gap analysis to identify the compatibility between the legacy system and the new business requirements.
• Recommended procedures for improvement - with an emphasis on automation and efficiency.
• Played a key role in the planning, testing, and implementing system enhancements and conversions
• Assisted Test Lead, Testers understanding the business process to help them successfully complete system testing.

Environment: RUP, Requirements Analysis, GAP Analysis, UML, MS Visio, MS Project, Testing tools

Confidential

Cognos Developer (Intern)

Responsibilities:

• Worked as an Intern on Market research data mart in creating reports on buyers and sales representatives to track and analyze revenue, identify top performers, or measure the effectiveness of marketing campaigns in different locations.
• Installed and Configured Cognos Environment to develop Impromptu reports and powercubes on Windows 2000 Server Environment.
• Worked on creating Impromptu Catalogs, customizing the Catalogs by creating joins, organizing the folders and defined the folder columns with Business related names, created Catalog filters, prompts, conditions and calculations.
• Worked on creating Impromptu Reports using Prompts, Cascading prompts, Sub Reports and Drill thru Reports. Worked on publishing The Impromptu reportnet using Impromptu report Administration.
• Worked on gathering user requirements in setting up the dimensions and identifying the measures the users need to Analyze. Worked on creating Power cubes, Powerplay reports and published in the web for different users.
• PowerPlay performance tuning using partitioning and data consolidation, alternate path dimensions, setting cube level security based upon dimensions and measures.
• Worked on Drill thru Reports by creating Summary Impromptu reports and Drilling thru to detailed Impromptu Reports. Also worked on drill thru from Power Cube to Impromptu Reports.
• Created user-classes and users in access manager and setup folder and report access in Upfront environment.
• Worked on IWR Report and Server Administration, Powerplay Enterprise Server Administration, Upfront and Access Manager Administration.
• Worked on creating Batch files to refresh power cubes and scheduling the same on nightly basis. Worked on unit testing by writing manual SQL queries against the database to validate reports.
• Worked on Migrating the reports and cubes from development to test and test to production.

Environment: Cognos Series 7 Impromptu, Impromptu Web Reports, Powerplay, Powerplay Enterprise Server, Upfront, Access Manager, IWR and PPES Admin Tools, Windows 2000 Server and SQL Server 2000.