SUMMARY

• Expert in Business Intelligence Applications using Cognos Tools such as Cognos10.2, Report Net (Framework manager, report studio, query studio and Analysis studio)
• Experience in Designing and developing multi - level Drill down reports.
• Proficient in Data analysis, Data modeling, Database design and Data migration.
• Developing Data Stage jobs using star schema and snowflake schema modeling and conversant with Data Warehouse concepts like fact tables and dimension tables.
• Participated in discussions with Project Manager, Business Analysts and Team Members on technical or business requirements
• Experience in extracting data from various database sources like Oracle 11g, DB2, Flat files, SQL server.
• Experience in working on operating systems like UNIX and Windows.
• Expert level knowledge in BI environment involving Cognos/Crystal Reports and production support.
• Extensively used PROC PRINT, PROC REPORT and PROC TABULATE for reporting.
• Refreshing tables in Oracle Schemas with the SAS data sets.
• Strong expertise on SQL; extracted, manipulated and retrieved data from relational databases with SQL; Adept in DW techniques and Data Management.
• Technically hands-on commercially experience mainly with full range of BI Skills with Tableau 7x,Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server.
• Mastered in creating solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Excellent Knowledge on Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Change, Data Capture, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modeling.
• Strong working knowledge of SDLC methodologies like Rational Unified Process, Waterfall and Agile Scrum methodologies.
• Experience in managing large amounts of data in multiple formats from disparate sources.
• Experienced in various Industries like Health insurance, Financial Services, Pharmaceuticals, Banking, social Service Sectors.
• Tableau tools include Tableau Desktop versions, Tableau Reader, Tableau Public, and Tableau Server.
• Experienced with multiple Relational Databases including Oracle, MS SQL Server and DB2 and Client/Server application development.
• Strong interpersonal skills, ability to interact with people at all levels and have Good communication and presentation skills.
• Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Strong experience in Business and DataAnalysis, DataProfiling, DataMigration, Data Integration and Metadata Management Services.

TECHNICAL SKILLS

BI Tools: Cognos 10 (Report studio, Query Studio, Framework Manager), Cognos 8.4 (Report Studio, Query Studio, Analysis Studio), Tableau.

Web Development: HTML 4, HTML 5, CSS2, CSS3.

Programming Languages: C, C++, Java.

Testing Tools: Selenium Web-driver, Selenium IDE, QTP.

Operating Systems: Windows, Android.

DATABASE: MySQL, ORACLE.

Other Tools: SAS.

Data modelling: Framework manager, Transformer.

PROFESSIONAL EXPERIENCE

Confidential, New York

Cognos Reporting Analyst/Developer

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers
• Worked on Framework Manager and have developed the 2-dimensional Model and published the package.
• Provided the Drill thru reports to nail down to the lowest level of data.
• Designed and developed the Dimensions and Facts and mapped to the requirements and developed the granular levels.
• Involved in the requirement gathering have converted the business requirements into Technical requirements.
• Worked on SQL Server scripts, procedure development using SQL Server 2008 R2.
• Involved in system testing, integration testing and performance testing using QC by interacting with QA team.
• Developing Data Stage jobs using the star schema and snowflake schema modeling and conversant with Data Warehouse concepts like fact tables and dimension tables.
• Worked on Access Manager and Configuration Manager.
• Experience in working with Administration tools like server administration/Deployment/Schedule management.
• Tuned data models and SQL to better performance on the reports.
• Maintained User security using third party tool (Security Studio). Worked on folder level and data level user security.
• Involved in creating models with Relational Data using Framework Manager including best practices and deployed packages to the Report Servers.
• Published Package for Cognos query to Upfront.
• Experience in Creating Entities and relationships, filters, prompts for Business Layers.

Confidential, Herndon, VA

Cognos Developer

Responsibilities:

• Used Data Access Layer to maintain keys, joins, SQL queries.
• Migrated existing Packages from Architect to FM model.
• Configured access manager namespace in Cognos connection and created new users and user groups in access manager.
• Used Conditional blocks and conditional variables for generation of reports.
• Building models and publishing packages in Framework Manager to the Report Net server.
• Applied Page Breaks and created page header, page footer, list header and list footer as per the requirement.
• Extensively used PROC PRINT, PROC REPORT and PROC TABULATE for reporting.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports
• Experience in creating Cascade Prompts, Bookmarks, Query prompts, Filters, and Multilingual Reports Using Report Studio.
• Created the list, cross tab, repeater and Drill-through reports, master-detail reports, prompts, complex calculations, formatting, conditional formatting, Bursting reports, charts and created the reports in different formats like PDF, XML, HTML and CSV.
• Experience in Developing Multi-Dimensional Analysis and building Power Cubes using Cognos Power play and Transformer and created the drill through reports for the cubes.
• Scheduling and distributing reports through Schedule Management in Cognos Connection.
• Experience in Creating Complex reports using custom prompts and Tabular Objects.
• Used Framework Manager to build models, packages and publish packages to the Report Net Server.
• Built models containing with complex security requirements from imported metadata.
• Modified packages to suit the business needs and improved the performance of the reports by defining filters and adding calculations.

Confidential, Warren, NJ

Cognos Developer

Responsibilities:

• Extensive experience in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth by developing reports to show in detail.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Collaborate with development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Confidential, Abbott Park, IL

Analyst/Developer

Responsibilities:

• Developed reports and presentations for data migration by analyzing data from multiple sources to one system.
• Presented daily, weekly and monthly reports to multiple store managers to strategize future planning and determinefinancial consequences of alternative methods, plans and strategies.
• Demonstrates an informed knowledge of business functions to resolve problems and capitalize on improvement opportunities
• Analyze, interpret and identify outliers from online data with advanced Excel and SQL functions.
• Using SAS Procedures/Writing SAS Code to Import/Analyze SAS and Present Result.
• Performeddata entry of historical and current data ensuring data accuracy
• Gathers requirements from business units and translates those to programmers and developers.
• Implemented Lean and DMAIC strategies to develop a reliable and higher quality product.
• Participated in development of new product introduction Dashboards to assist in the tech transfer of biologics and pharmaceutical product lines from clinical to commercial production.
• Responsible for monitoring process tools, generating ideas for process control improvements and maintenance of advanced process control.
• Assigned tasks of optimizing industrial processes to increase profitability by meeting product specification and regulations.
• Created Data analysis reports as required to enhance process monitoring process.