SUMMARY

• 11 plus years of Professional IT Experience, inclusive of more TEMPthan 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, Lumira, Design Studio, Dashboards, IDT, SAP BusinessObjects Mobile, BEx Query Designer, SAP BW, Data Services), Cognos 10.1 (Cognos Connection, Framework Manager, Report Studio, Analysis Studio, Event Studio, Business Insight, Query Studio), Cognos 8.x and Power Play Transformer, Cognos SDK.
• More TEMPthan 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.
• Expertise in using SAP Business Objects Data Services integration with SAP modules and Non - SAP data sources.
• 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.
• 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.
• 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 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 noledge 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.
• Served as a mentor and lead the offshore team for more TEMPthan two years.
• 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, SQL Server 2005, 2008 (SSIS, SSAS, SQL Server Studio), DB2/400 and Microsoft Access

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) QlikView 10, Tableau, Power BI, Fusion Ops/Aera Technology 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)

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

Financial Performance Management Tools: Cognos TM1 9.5/9.4.1, TM1 Executive Viewer, Cognos Planning 8.3 (Analyst and Contributor)

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, Springfield, IL

Sr. Business Intelligence Developer/Analyst

Responsibilities:

• 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. dis 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.
• Extensively used business objects data services (BODS) to generate and schedule flat files in ftp format to external customers and in addressing adhoc business requests to pull data from ECC. Created jobs to extract and transform billing and sales data from SAP to SQL server on daily basis in building a pricing DataMart.
• Worked on POC’s to bring excel data to HANA database using data services. Designed Attribute, Analytical and Calculation views.
• Involved in design, development & unit test SAP BusinessObjects solution using Web Intelligence, Information Design Tool, 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. Has 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 TEMPhas 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), EPP (Enterprise Product Platform).
• TEMPEffectively 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 2005 / 2008.
• 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 noledge.
• 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 (Walt Disney 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 Consultant

Responsibilities:

• The Confidential 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 Confidential, 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.
• Developed strategic partnerships with the business unit to develop a solid noledge 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.
• Conducted gap analysis to identify the compatibility between the legacy system and the new business requirements.
• 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