SUMMARY

• Over six years of professional experience as a Cognos Business Intelligence Developer-Analyst with key activities such as support, analysis, designing and testing Cognos BI solutions across multiple industries.
• Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR), & OLAP) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension); using Data Modeling tools such as Cognos Transformer and Framework Manager.
• Installed, configured and worked on Cognos BI suite, including Business Insight & Advanced, Report Studio, Query Studio, Analysis Studio, Event Studio and Metric Studio.
• Developed solutions for Management dashboards, BI Analytics or Operational BI; and documented technology roadmaps through collaboration with the data management, ETL and business teams.
• Configured and optimized Cognos BI environment, which includes relational, and OLAP layers, and data migration components; working in collaboration with the data warehouse environment and team.
• Experience in understanding existing business processes, gathering business systems requirements analysis and design; thereby converting requirements into detailed reports for strategic decision making.
• Delivered solution-oriented complex reports using Report Studio, ad-hoc reporting interfaces using Query Studio, multi-dimensional analysis & visualizations from OLAP cubes using Analysis Studio, created checkpoints & alerts in Event Studio, and developed scorecards & metrics in Metric Studio.
• Generated SQL/MDX queries and analyzed Cognos SQL, Native SQL to troubleshoot report issues.
• Implemented Web Technologies to customize the reporting environment in order to organize and visualize Business Metrics and KPIs into logical sets of dashboards and data visualizations.
• Customized Cognos Connection with appropriate reports, scheduling and maintenance of reports, and security measures; to define user, group and role-based access; in order to provide access control to events, cubes, views, dimensions, rules, alerts, scorecards, portlets and dashboards.
• Mentored and trained users in Query Studio and worked closely with business leaders, data modelers and data warehouse developers to ensure consistent and accurate reporting using Report Studio.
• Experience in deploying, migrating, analyzing, performance tuning and optimizing models, packages, reports and cubes from Development to QA, and then from QA to Production environments.
• Actively participated in industry network seminars & webinars to ensure awareness of BI trends and best practices in order to strengthen technical expertise and improve organization performance.

EDUCATION

Bachelors in Engineering

SKILLS

Reporting Tools:

Cognos BI 10.1.x/ 8.x BI (Report Studio, Query Studio, Analysis Studio, Event Studio, Metrics Studio), Business Insight & Advanced, Cognos Connection, Cognos Series 7.x (Impromptu, Impromptu Web Reports, Upfront, Visualizer, Cognos Query, Metric Manager), Cognos GO! (Dashboard, Office, Mobile), Cognos Report Net 1.x (Report Studio, Query Studio), Cognos Scheduler, Cognos Access Manager

Data Modeling Tools:

Cognos Powerplay Transformer, Framework Manager, Metric Designer, MS Visio

ETL Tools:

Cognos Decision Stream, Cognos Data Manager, Informatica

Database Integration:

Oracle 11g/10g/9i/8i, MS SQL Server 2008 R2/2008/2005, MS Access/Excel, Salesforce, SharePoint, SAP BW, FLEXCUBE

Enterprise Tools:

SQL Server Enterprise Manager, SQL Query Analyzer, SQL Developer, TOAD

Languages:

C, C++, Java, SQL, MDX

Web Technologies:

HTML, XML, CSS, JavaScript, Web Services (SOAP, WSDL, UDDI), Drupal CMS

Servers:

Cognos Server, PowerPlay Enterprise Server, Apache HTTP, IIS, Windows Server

OS:

Windows, Linux, UNIX

Other:

MS Office, MS Project Office, Google Tools (Analytics, Website Optimizer, AdWords, Maps) Weka, MATLAB, Adobe Photoshop/Dreamweaver, PeopleSoft

EXPERIENCE

May ’11 - Till Date , Cognos BI Developer-Analyst, Confidential,New York, NY

Modell\'s Sporting Goods is the nation\'s oldest, family-owned and operated, retailer of sporting goods. The project here involved development of a variety of reports to support marketing activities such as campaigns, sales forecasting, market segmentation, etc., in order to help the business users better understand customer profiling and make effective decisions.

• Coordinated testing, rollout & deployment of Cognos 10.1 Business Intelligence reporting solutions.
• Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain, and secure Cognos reports.
• Closely worked with ETL team to design Data Marts by understanding user requirements and increasing the reporting efficiency.
• Developed Metadata models and DMR models using Framework Manager and created filters, prompts, calculations, summaries and functions as per Functional Requirement Specifications.
• Implemented Framework Manager Security for row level access and package access based on the Department, Region and Store Level.
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, charts, master-detail, maps, various calculations and joins using tabular sets and models.
• Extensively worked on Active reports to create static reports for offline users.
• Performed burst of Reports against the regions, districts, and stores for delivering by email; appropriate outputs to the concerned District Managers & Team Ambassadors in Cognos Connection.
• Created several different types of Ad-hoc (simple list, grouped list, section heading, crosstab, and nested crosstab) reports and represented data graphically by charts using Query Studio.
• Implemented prompt validation and added various functionalities to prompt pages using JavaScript in order to extend and customize the reporting functionality, visualization and presentation experience.
• Created Cube and partitioned cube manually; added User Class views, Dimension Views, and Drill through capability using various data sources in Transformer to be analyzed in Analysis Studio.
• Created agents and added tasks in Event Studio to run reports based on specific business criteria.
• Performed scheduling and maintenance of reports using Cognos Connection and Microsoft SharePoint based support portals.
• Interacted extensively with Information Services, being a key resource in most phases of the sales & traffic reporting capability development lifecycle, serving as liaison between IT and end users.

Environment: Cognos 10.1.0 (Report Studio, Active Reports, Query Studio, Cognos Connection, Framework Manager, Analysis Studio, Event Studio, PowerPlay, Transformer), Unica Campaign, Oracle 10g, TOAD 10.6, IIS 6.0, HTML, MS-Access/Excel/SharePoint, JDA Retail Ideas, Google Analytics, Windows XP

Mar ’10 - Mar ’11, Cognos Developer/Report Author , Confidential,Charlotte, NC

Time Warner Cable (TWC) is the second-largest cable company in the United States. Scope of the project was to enhance Customer Growth analysis through improvements in acquisition, cross-sell/up-sell, retention, customer satisfaction, and sales & service efficiency. This was accomplished by designing detail level & summary reports in Cognos based on Knowledge Management and Data Warehouse components.

• Worked with Business Analysts, client users and internal systems resources on Cognos installations, upgrades, troubleshooting, and bug resolution.
• Created models using Framework Manager consisting of star schemas, dimensions, facts, calculations, links and multiple namespaces; applying proper securities and publishing packages.
• Improved performance by analysis of relational data by creating aggregate tables at multiple levels within and across hierarchies in the dimension tables using Data Manager.
• Collaborated with the ETL/Informatica team to determine the necessary data models and UI designs to support Cognos reports by defining relevant attributes, dimensions, hierarchies and metrics.
• Developed list reports, cross tab reports, chart reports, reports with multiple prompts, cascading prompts and Filters, conditional formatting, multi-page layouts, and custom-code SQL queries in Report Studio to respond to the complex business requirements.
• Created Scorecards and Dashboards with drill-through capabilities for analysis purposes to enable managers to monitor progress and results for sales and marketing data.
• Created tabular sets with except, unions, as well as master-detail queries, dashboards and multidimensional reports using Analysis Studio and Scorecards using Metrics Manager.
• Created multi-dimensional cubes using Power Play Transformer and deployed the same along with reports using Power Play Enterprise Server.
• Performed Pivoting, Drill-down, Slice & Dice and Filtering operations for all OLAP applications.
• Provided insights and recommendations for each Product hierarchy based on the Customer Portfolio data / metrics, thereby optimizing queries and streamlining of reporting services.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
• Involved in preparing Technical Design specification for the reports, and transferred Technical Knowledge specific to Cognos tools and the existing data model to other team members.
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Evaluated by troubleshooting; the data discrepancies and other issues in the canned reports, discovered by the users during the UAT phase.

Environment: Environment: Cognos 8.4 & 8.4.1 (Cognos Connection, Framework Manager, Report Studio, Query Studios, Metric Studio, Data Manager, Metric Manager and PowerPlay Transformer), Microsoft Excel/Visio, IIS 6.0, Informatica 8, SQL Server 2005/2008 R2

Jun ‘09 - Jan ’10 , Cognos BI Developer, Confidential,Berkley Heights, NJ

Celgene is a global biopharmaceutical company committed to improving the lives of patients worldwide. The project involved assisting the Finance Division to evaluate and implement an Enterprise Financial Reporting & Budgeting System. By developing reporting & analytics capability using Cognos BI tools, the reports created were based on summarized financial statements, qualitative business insights, and operating metrics.

• Effectively partnered with finance customers; ensure consistent and accurate flow of information from business project sponsors to application/database developers.
• Communicated with business users, business analysts to analyze, design, develop the Cognos Reports, Dashboards, DMRs and Cubes.
• Worked with the team to design, develop the ETL process using Cognos Data Manager and enhance the ETL job streams using Cognos DecisionStream.
• Used Framework Manager to build models, Query Subjects, Query items, Relationships, Calculations, Filters, Prompts, Functions, Folders, and Data Sources; to publish packages to Server.
• Set up cardinality (minimum, maximum & optional), determinants to avoid double counting, and supported loop joins, optimized data source, and identified dimensions and facts.
• Developed using Report Studio advanced functionalities such as building complex prompt pages; render variables; parameters & parameter passing; master-detail; drill down vs. drill through; union and join queries with cardinality; and generating, reviewing, & troubleshooting report SQL.
• Designed reports by using HTML, XML and also used JavaScript for prompt validation.
• Worked extensively on various report layouts such as Chart, List, Crosstab and Repeater for presenting the data in efficient manner in Report Studio.
• Traced the performance of reports from the Database & Framework Manager level to the Report Studio level; and tuned reports for query optimization in order to achieve better performance.
• Performed Data Analysis for verifying Retail Data Warehouse (RDW) data, by generating and comparing reports from RDW with reports from existing legacy systems.
• Created the Data level security for various objects like P&L, Market Summary, and Fact Query Subjects in the Cognos Framework Manger for to restrict users to access the level of data
• Exported the Framework Manager models in IQD format; and created business model; calculated measures, special categories, multiple dimensional cubes using PowerPlay Transformer.
• Inserted the Cubes into PowerPlay Enterprise Server and published the cubes to Upfront portal so that users could analyze them in the PowerPlay Web Client.
• Involved in the generation of different reports for different sets of data to target customer segments, in order to slice & dice and drill-through data for multidimensional OLAP analysis.
• Decreased the Cube build times drastically and increased runtime performance.
• Prepared end user documentation on models, packages, and reports for end users that help in using the developed reports and build ad-hoc reports using Query Studio.

Environment: Cognos 8.1 & 8.3 (Framework Manager, Cognos connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Access Manager), PowerPlay Transformer 7.3, SQL Server 2005, PowerPlay Enterprise Server 7.3 Oracle 9i, TOAD, Data Manager, Decision Stream, SQL, HTML, JavaScript

Nov ‘08 - May ’09, Cognos Reporting Analyst, Confidential, Parsippany, NJ

T-Mobile USA is a national provider of wireless voice, messaging, and data services. The objective of the project is to develop new reports, and modify existing models by incorporating Voice and RF based data. Reports were meant for mobile operators, field sales, engineering and marketing to analyze, document and communicate actionable intelligence with business implications and business recommendations. Executive Dashboards were created for certain KPI Reports on metrics such as Traffic, Retain Rate, and Access Rate.

• Created business data models in accordance with functional and system requirements for the workflow analysis using Framework Manager.
• Extensively worked on dynamic drill through reports (Analysis studio to Report Studio reports, Query studio to Analysis studio reports), and handled MUN issues.
• Performed detailed SQL code reviews and provide technical design to ETL development resources.
• Supported RF Engineers and Field Operations team with process improvement initiatives in order to maintain alignment with performance assurance, measurement and modeling processes.
• Maintained technical and business documentation for creation of Data Dictionary Metadata on tools, reports, and data elements.
• Responsible for framework modeling, report writing (relational and multidimensional), and creating dashboard components using the Cognos 8 suite of products.
• Designed the ERwin data model using Oracle 9i tables and generated Cognos Framework Manager Metadata Model.
• Spearheaded cost saving processes by creating a set of dynamic Report Studio reports which limited the necessity for Query Studio licenses.
• Interfaced with Engineers to define report deliverables, issues, questions, needs, trends, and timing.
• Developed Reports in both Cognos 7 and 8 suites to support Ad Hoc requests, and perform Data Warehouse testing by comparing the current C7 environment to the new C8 environment.
• Involved in designing and building the PowerPlay cubes using Transformer.
• Migrated Cubes from Cognos 7.1 to Cognos 8 and Reports from ReportNet 1.1 MR3 to Cognos 8.
• Involved in Troubleshooting and Maintenance of Migrated Reports from Version 1.1 to 8.0 and cubes from PowerPlay 7.3 to Cognos 8.
• Built reports with focus on optimization: used indexes on tables and made recommendations for summary tables where needed.
• Customized the portal to show client logo, details and other modifications like changing color, fonts and size of different objects, inserting new links etc.
• Created reports, analytic cubes, and performed cross environment deployments by integrating with other team streams (QA, DB, & ETL).

Environment: Cognos 8 (Report Studio, Analysis Studio, Query Studio, Cognos Connection), PowerPlay Transformer 7.3, Cognos Impromptu Administrator 7.3, Access Manager, ReportNet 1.1, Framework Manager, IWR, Upfront, Oracle 9i, SQL Server 2000, Data Stage 7.0, TOAD 7.2, Erwin 4.0, MapInfo

May ‘06 - Oct ’08, Business Intelligence Analyst, Confidential,Bangalore, KA, India

The Project involved assisting in the development and maintenance of supply chain related reports using Cognos Business Intelligence for distribution to the Clients and key stakeholders. The data used to build the Decision Support System was based on rigorous analysis of the current supply chain; including revenue growth, cost reduction and efficiency, profit acquisition, and customer retention.

• Worked with the company in their efforts to upgrade from a Microsoft Access and Excel reporting system, to a more efficient Data Warehouse which utilizes Cognos.
• Worked in conjunction with the Oracle Database team to design a Data Warehouse and Framework Manager Metadata Model to work with the imported data.
• Developed and maintained Cognos Impromptu & ReportNet reports for various IBM host applications and resolved Data issues by interacting with various host teams across the world.
• Presented technical and functional flow of the application to Client on report design and was involved in meetings to discuss technical challenges.
• Performed functional, technical testing and participated in application validation including QA efforts as they pertained to reporting, data, metrics, and report creation and executions.
• Integrated reports such as Channel Inventory Detail, Sales Out, and Buy/Sell Detail to project website; and monitored permissions to required members according to the business guidelines.
• Developed and maintained IBM Buy Analysis Tool Cognos reports for integrated Supply Chain Management that combined innovative forecasting and inventory analytics with up-to-date visibility of inventories and channel sales information.
• Developed technical solutions for the delivery of auto generated mails to clients for proactive alerting stock-out/excess inventory situations.
• Evaluated data integrity issues in reports by interacting with DBA and technical teams.
• Executed advanced troubleshooting and performance monitoring of the IBM e-Commerce application by coordinating with multiple teams across the globe.
• Performed duties related to migration and conversion of data in present systems to one centralized database structure of the Oracle FLEXCUBE.
• Provided application consultancy to Canara Bank for pre & post migration issues (i.e. RTGS, NEFT, ATM Transactions and e-Banking services).
• Delegated and managed performance and maintenance of Talisma (CRM) servers.

Environment: Cognos Impromptu & Impromptu Web Reports (IWR) 7.2, Power Play & Power Play Transformer 7.2, Cognos ReportNet 1.0 (Framework Manager, Query Studio, Report Studio), SQL*Loader, Windows 2000, Oracle 8i, Oracle FLEXCUBE, UNIX, Windows 2000/IBM-AIX, IIS 5.1, Talisma Server