CHRONOLOGICAL SUMMARY of Experience

Sr.Tableau/BI Developer

Confidential

• Gathered Business Requirements to develop various reports
• Analyzed, designed, built and tested reporting solutions based on business requirements.
• Created Star Schema/Snowflake Models inorder to accommodate reporting needs.
• 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 in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• 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 key's 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.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 8.1, Tableu Reader, Tableau Server, Teradata, Oracle, MS Excel

Sr.Tableau Developer

Confidential

• Worked on Proof of Concepts POC presentation and review with project and IT lead along with developing Tableau Dashboards.
• Recommended OS configuration for installing Win Server 2012 R2, Tableau Server, and MS SQL Server 2012 R2.
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations.
• Adjust views/dashboards after initial POC presentation.
• Brainstorm ideas on what to include in views/dashboards from the data source and document on the fly business requirements.
• Create views and dashboards on end client's sales data. Produce powerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily.
• Cleanse and normalize data in MS Excel by combining from various data sources.
• Perform Tableau Server admin duties add users/groups from Active Directory and schedule instances in Tableau Server including weekly data dump.
• Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
• Involved in migration of Cognos adhoc reports to Tableau workbooks.

Environment: Tableau Desktop 7.0/8.1, Tableau Server 7.0/8.1, Cognos 10.1, MS Excel, MS SQL Server 2012 R2, Win Server 2012 R2, Active Directory

Sr.BI Developer

Confidential

• Involved in upgrading existing reports in cognos 8.4 to cognos 10.
• Converted business requirements into technical specification and design for Reporting Database/data mart, and Adhoc/standard reporting using Cognos 8BI.
• Implementation of Cognos 8.4 developed and assisted with development of long-term strategy for implementation of Cognos 8 features/integration into Enterprise Risk Management Technology departments' custom portal / infrastructure.
• Developed and enhanced reports incorporating sophisticated HTML/JavaScript techniques for navigation/usability.
• Re-designed Framework Manager Model to leverage Best practices to ensure predictable queries.
• Established framework for gathering and analyzing business requirements designed a star-schema datamart to meet requirements developed Cognos solutions to deliver information trained client's staff.
• Built metadata models, modified, and published several packages using Framework Manager according to the business needs which can be used by Report Developers
• Performed detailed documentation of design, development, testing and deployment activities
• Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, using Report Studio and Query Studio in Cognos 8.3 and 8.4
• Used different Score carding models using Metric Studio based on the existing organizational structure which will help identify meaningful metrics and KPI's Key Performance Indicators
• Monitored ad-hoc analysis using SQL and performed dimensional analysis using MDX functions in Report Studio
• Calculated measures and dimension members using MDX, statistical formulas, and other user defined functions for complex reports using Report Studio
• Developed filters, calculations, prompts, conditions, and created various reports, using Report Studio for users
• Worked with Relational Databases - Oracle and MS SQL and involved in ETL team discussions for Data conversion process.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Designed, developed, administered and deployed Cognos Cubes based on requirement.
• Made judgments and took decisions while addressing complex business issues with minimal supervision
• Developed work estimates for assigned tasks, assessed constraints and dependencies, escalate and resolve issues in a timely manner
• Created user groups in Cognos Connection from Active Directory groups
• Maintained source/version control for Cognos models, reports and involved in Documentation for user training
• Administered installation, configuration, and software upgrades of Cognos applications and monitor Cognos servers
• Maintained Development/QA/Production Environments, including new installations, upgrades
• Written handwritten SQL inorder to validate the data and data fixes in order to improve the performance.
• Provided technical support on day-to-day basis and troubleshoot installations

Environment:Cognos 10.1,Cognos 8.4 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio, Metric Designer, Metric Studio Event Studio , Power Play Transformer, DB2 8.1,Cognos Access Manger, Oracle 10g, Unix Shell scripting, Oracle E-Business Suite, Teradata, Shell scripting, UNIX, Tomcat/Apache.

Cognos Developer

Confidential

• Gathered Business Requirements to develop reports using IBM Cognos 8.4
• Analyzed, designed, built and tested reporting solutions based on business requirements.
• Created Cognos 8.4 Framework Manager models including relationships, filters, aggregations, rollup processing, calculations, organized folders, merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer, and have setup data/object security and successfully published the packages.
• Created different reports using Query Studio and Report Studio.
• Developed various reports like List reports, Cross Tab reports and Drill through Reports using Report studio.
• Developed several complex reports using cascaded prompts, Drill Through, master-detail relationships, Page sets, Joins, Unions using report studio.
• Worked extensively on conditional variables utilizing conditional explorer in report studio.
• Created, organized and formatted reports, folders and other contents on Cognos Connection portal.
• Created joins with queries in Report Studio to generate the required Report queries.
• Extensively worked on Dashboards using report studio including render variables, master-detail relationships, singletons, prompts, filters, Conditional variables, HTML items, layout component reference and formatting the objects within report design.
• Tested reports for uniqueness of data using Toad.
• Also performed unit/system testing of the reporting application including analysis of the data and wrote a number of SQL queries against Oracle database using Toad 10.6.
• Applied Security and User Authentication to the various User Groups.
• Resolved technically complex assignments and mentored junior staff.
• Worked on Toad 10.6 for writing, updating and modifying the SQL Queries.

Environment: IBM Cognos 8.4, Framework Manager, Report Studio, Query Studio, Cognos Connection, SQL, IBM Http Servers, Web Sphere, Toad, Unix.

Senior Cognos Developer

Confidential

• Designed meta model in Framework Manager 10.1by Creating database layer and business layer, defining appropriate relationship between query subjects in Framework Manager and then deployed packages into Cognos connection portal.
• Implemented Framework manager security for Data access, Object level access and Package access.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager. Model.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query in Cognos 10.1/8.4 Report Studio.
• Involved in Bursting Reports against database.
• Created custom templates and custom tool boxes for the use of reporting.
• Involved in creating cubes using Transformer and experience with analysis studio to analyze the cubes.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Moved Packages and reports from development to QA and then Production servers
• Deployed the cube from Testing Environment to Production Environment using Batch script.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved into move to Deployment to UAT and Production.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Involved in writing Stored Procedures and functions in Oracle PLSQL.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: Cognos 10.1/8.4 BI, Oracle 11g, DB2 0, Framework Manager, Report Studio,Transformer, Analysis Studio, Cognos XML, Generic/Cognos JavaScript, BATCH SCRIPT.

CognosAdmin Developer

Confidential

• Involved in Requirement gathering from Business Users.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Design and Developed the Framework Manager models and Published into Cognos Portal.
• Design development of the reports using Cognos 8.4 Report Studio, Analysis Studio reports. Also worked as an administrator in working with report and analysis studio
• Design development of multiple reports using various templates like list reports, cross-tab reports and Chart reports and involved in complex reporting.
• Extensively worked on Analysis Studio to develop multi dimensional reporting.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports..
• Created Ad-hoc reports using Query Studio.
• Worked as report studio administrator, to create complex reports and dashboards for the given requirements.
• Created Scorecards/Metrics Using Metric Studio and also created Complex dashboards in Metric Studio.
• Created complex dashboards with area charts, pie charts, crosstab and Multi prompts in Report Studio.
• Exposure on Cognos development Software development kit like SDK in order to customize reports.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Coordinating with Development Team tasks Deliverables and working on high priority issues
• Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Cognos 8.3/8.4 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Office Connection , Oracle 10g, Cognos Access Manger, Windows 2003 Server, IIS Web Server, SQL Server 2005, Informatica 7.2 Clear quest, DB2, Unix.

Cognos Developer

Confidential

• Generated catalogs by connecting to different databases.
• Developed reports from multiple queries using Impromptu and Power Play, and published them for end-users in Upfront.
• Created various types of reports such as List, Grouped List, Crosstab, Nested Crosstab, Drill through, and Standard List
• Created cascading prompts and worked with various prompt controls such as Value prompt, Pick list prompt, and Date and Time prompt.
• Customized Power Play Reports by using Slice and Dice, Drill through, Ranking, Conditional formatting, and Sorting options.
• Worked with the join functionality to create various reports.
• Experienced Cognos 8.4 BI Studio, Cognos 8.4 Framework Manager, Cognos 8 Administration, and Cognos SDK
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management.
• Generated reports for comparative analysis based on the Projected v/s Actual.
• Used Cognos Scheduler to update a report for specific or recurring times and dates
• Designed Multi Dimensional Cubes using Transformer and Optimized Cube performance to improve report run time.
• Installed Cognos v8.x on Windows environment with Oracle 10g as a backend database
• Deployed cube security to give only specific users the access to specific hierarchies.
• Designed and develop SSIS packages, store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance.
• Worked on Informatica for master data management, data migration
• Experienced with TM1Executive Viewer for pivoting, drilling, charting and conditional formatting.
• Successful implementations of the Analyst, Manager, and Contributor applications within Cognos 8 Planning
• Extract Transform Load ETL development using SQL Server Integration Services SSIS

Environment: Cognos 8.4/8.2, Planning, Impromptu, Impromptu Web Reports IWR 6.6, Power Play 6.6, Power Play Transformer 6.6, Upfront, Access Manager, and SQL Server

Cognos Developer

Confidential

• Involved in creating Metadata Models Using multiple data sources using Framework Manager.
• Created Several Parameter Maps, Calculations and Relationships in Framework Manager.
• Involved in organizing the Framework Manager model into several different Business views based on end user requirements.
• Created list, Crosstab, Charts Nested Cross-tab reports in Report Studio. Worked as administrator with Prompts, Conditions, Filters and Calculations.
• Trained Professional Authors to write complex reports using Report Studio and trained power users to use Query Studio for Ad Hoc Reporting.
• Worked extensively on applying and maintaining Security for several different users in Report Net developing prompt pages and conditional variables
• Involved in Testing and Improving Report Performance.
• Installed and Configured Cognos series 7 IWR, Upfront, PPES and Access Manager .
• Catalogs and Reports using Impromptu Administrator and designed Power Play Models using Transformer.
• Created Drill-Thru, Sub-Reports and Chart Reports using Impromptu Administrator.
• Created Special Categories and Secured Power Play models using Power Play Transformer.
• Worked with Access Manager Administrator to provide security for Cognos applications
• Tuned the Impromptu/IWR reports and Power Play cubes.
• Published Impromptu Reports and Power Play Cubes to Upfront using Cognos IWR Administration and Power Play Enterprise Server respectively.
• Supported IWR/PPES Users in production.
• Involved in resolving issues in the ETL load process. Worked on SDK Concept.
• Involved in the development of Data Mart and populating the data marts using Informatica.
• Used Informatica Power Center/Power mart Server manager to create sessions, batches to run with the logic embedded in the mappings.
• Implemented performance tuning with the Transformations, Sessions and on the Source Databases to load the data efficiently in to the target.
• Assisted Informatica team in creating complex mappings based on the functional specifications provided by business users.
• Created UTP's to test data loads and check whether the components adhere to the technical design.
• Involved in Cognos Planning, BI server administration, Portal administration and installations of reporting tools.

Environment: Cognos7.1/ Report net1.1 Framework Manager, Cognos Connection, Report Studio, Query Studio , Impromptu 7.1, Power play 7.1, Power play Transformer 7.1, Informatica Power Center/ PowerMart, SQL Server 2000, Teradata, SAP BW, Flat files, MS Excel and Erwin