SUMMARY:

• Around 9+ Years of IT experience with expertise in Software Analysis, Design, Development, Production, Documentation, Testing and Implementation of Client Server and Web Applications.
• Experience in Tableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau 9.x and Tableau 10.x.
• Proficient in design and development of various dashboards, reports utilizing Tableau visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Extracting, transforming and loading data from multiple sources into Tableau applications.
• Excellent analytical, problem solving and Tableau and SQL debugging skills.
• Mastered in using Filters, sorts, groups and sets, reference lines, Bands and Boxes in different kinds of charts.
• In depth knowledge in Tableau advance analysis features like Actions, Calculations, Forecasting, Parameters and Trend Lines.
• Mastered the ability to design and deploy rich Graphic Visualizations Parameters using Tableau.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownership, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Good knowledge in designing and developing Tableau dashboards by extracting data from different sources like SQL Server, Oracle, Excel files.
• Decent hands on experience in scripting, developing and designing dashboards using QlikSense by extracting data from multiple sources (Oracle, Excel, SQL Server, Flat Files) by connecting through ODBC and OLEDB.
• Experience with QlikSense sheet objects Pivot, Table, multiple charts types, KPI’s, Gauge for Management Dashboard reporting.
• Excellent hands on experience in the area of Financial Planning Solutions using Cognos TM 1 9.5/10.1/10.2 Applications (Architect, Perspectives, Performance Modeler, TM1 Web and Turbo Integrator) from requirements through design and testing, implementation and production support (full SDLC).
• Experience in TM1 server maintenance and Administration.
• Extensively worked on Rules to apply business rules to a cube.
• Experience in scheduling Turbo Integrator process using Chores.
• Expertise in Turbo Integrator processes to load and retrieve data from database tables and other data sources, creating complex Active Forms.
• Proficient on working with TM1 cube reporting by integrating Cognos with TM1.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Table, Matrix, Chart and Sub Reports.
• Excellent hands on experience in the area of Business Intelligence tools using IBM Cognos Analytics v11.0, IBM Cognos 8.x/10.x (Framework Manager, Report studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Cognos Workspace/Business Insight, Cognos Workspace/Business Insight Advanced, Transformer).
• Expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using Cognos Suite 8.x/10.x/11.0, Cognos Enterprise Planning and Cognos Report Net.
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Experience in creating Events/Score Cards using Event Studio and Metric Studio.
• Designed and developed Dynamic dashboards and Multipage portal Dashboards to evaluate the Company’s performance using Cognos Workspace and Cognos Connection.
• Experience in Production/Customer Support Deployment Development and Integration.
• Involved in Onsite-Offsite coordination in delivering Business Intelligence Solutions.
• Excellent interpersonal and communication skills technically competent and result oriented with strong problem solving skills.

PROFESSIONAL EXPERIENCE:

Confidential, Tempe, AZ

Sr. Tableau/ BI Developer

Responsibilities:

• Responsible for gathering business requirements and technical specifications from the users.
• Extracting, transforming and loading data from multiple sources into Tableau applications.
• Developed various dashboards illustrating data visualizations using Tableau Desktop.
• Defined best practices for Tableau report development.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Analysing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, charts, and pivot tables.
• Worked across departments to identify and understand key business questions, and standardize key metrics and measure.
• Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server.
• Created calculated fields, parameters and action filters for building dashboards and worksheets in tableau.
• Created Workbooks and dashboards for analysing statistical billing data using Tableau.
• Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs.
• Defined best practices for Tableau report development.
• Design and build successful technical solutions that involve TM1 cubes, dimensions, TI processes, rules, and executing the completion of the TM1 architecture per project.
• Edit/create rules while utilizing Turbo Integrator.
• Develop and support Cognos reports on TM1.
• Develop and implement TM1 coding standards
• Working with the users, Analyzing, design and plan Reports.
• Analysis of the specifications provided by the clients.
• Creating TM1 forecasting calculations based on requirements.
• Involved in creating TM1 servers, Dimensions, Cubes, Subsets, etc. using TM1 Architect.
• Created new Cubes and Dimensions manually, using dimension worksheets and also using Turbo Integrator.
• Imported data into dimensions and cubes using Turbo Integrator
• Involved in Migration of reports from Cognos to Tableau.

Confidential, Tempe, AZ

Sr. Cognos TM1/BI Developer

Responsibilities:

• Involved in all phases of the data warehouse project lifecycle, which includes business requirements gathering, data modelling and database.
• Involved in Modelling and Reporting against a Warehouse system as data sources.
• Maintained management variance reports of Balance Sheet items.
• Prepared management budget presentations for global distribution.
• Collaborated with corporate finance to assist with global P&L analysis.
• Reported P&L and Budgets.
• Analysed Revenue, Gross Margin, and Profitability.
• Design, develop, and implement Cognos TM1 Applications for Financial Planning and Budgeting models with complex rules.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Maintenance of TM1 users, roles, and security.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Created TI Processes to transfer currency data to currency cube.
• Created rules to transfer data between cubes.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Worked extensively with Business groups and developed technical specifications.
• Analysed the business requirements, identify the bottlenecks and iterate them with business groups.
• Involved in Modelling and Reporting against a Warehouse system as data sources.
• Worked extensively on Relationships between Query subject to better represent the logic structure of business and user requirements.
• Imported metadata from various sources such as relational Database, Cognos models and .IQD Files into Framework Manager.
• Good knowledge on Cognos data manager to load the data into data marts from flat files.
• Developed Dimensionally Model Relational for standard reporting, Ad-hoc reporting and for Multi-Dimensional analysis using multi-layer approach and modelling best practices to meet the reporting requirements.
• Publishing to Cognos connection and implemented the Security for the packages.
• Developed multi format reports (PDF, Word, HTML & Excel).
• Involved in Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups.
• Involved in Upgrading of existing Cognos 10.2.2 reports into Cognos Analytics v11.0.
• Liaised with internal and external IBM/ Cognos teams to resolve tickets and troubleshoot errors.
• Unit testing of the reports to ensure the correctness of the data.

Confidential, Tempe, AZ

Sr. Cognos TM1/BI Developer

Responsibilities:

• Interacting with Business Customers, Users and Analysts for Risk and Compliance Reports Using Cognos BI and Involve in Preparation of Design/Mock documents
• Agile Estimating for Each Sprint and Developing the Cognos BI Reports Based on Customer Requirements for each of the Objects and their Mappings based on the business data model association paths defined
• Cognos Audit Setup & Report development: Report Usage Statistics, Daily notifications monitoring etc.
• Develop Event studio agents for specific business notification scenarios and schedule the report output or notification message accordingly.
• Reports Migration and Maintenance in DEV, QA, TEST, DEMO and Sandbox environments.
• Computed fields and Reporting Fragments development (new development, enhancements or defects)
• Cognos system Services Restarts / Scheduling / Deployments / Cognos Configuration changes etc.
• Content Store Retention /Archival maintenance.
• Training end users / peers.
• Reviewing deliverables received from offshore and ensuring the quality of deliverables.
• Coordination between onsite and offshore on daily basis and provide status.

Confidential, Riverside, RI

Cognos BI Developer

Responsibilities:

• Analysed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Involved in Modelling and Reporting against a Warehouse (OLAP), OLTP systems as data sources.
• Published Packages to Cognos Connection and implemented security for the Packages.
• Ensured Ambiguous Relationships are resolved and implemented Model enhancement techniques to improve Model Performance.
• Worked on migration of models, cubes, reporting solutions from Cognos 8.4 to Cognos 10.
• Performed Reports validations, Unit testing and involved in integration & Regression testing.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups.
• Provided end user training and support.
• Created Model Query Subjects, Data Source Query Subjects, Stand alone and Embedded Filters to implement the Complex business Logic.
• Involved in Design and Development of Security Architecture to meet the Business needs.
• Implemented various reporting techniques like Drill up, Drill down and Drill through Functionality, Conditional Formatting, Conditional Blocks, Conditional Layouts, Dynamic Grouping and Sorting, Master-Detail and secured the Reports and Folders to specific user groups.

Confidential, Los Angeles, CA

Cognos BI Consultant

Responsibilities:

• Worked extensively with Business groups and developed technical specifications.
• Analysed the business requirements, identify the bottlenecks and iterate them with business groups.
• Involved in Modelling and Reporting against a Warehouse system as data sources.
• Worked extensively on Relationships between Query subject to better represent the logic structure of business and user requirements.
• Imported metadata from various sources such as relational Database, Cognos models and .IQD Files into Framework Manager.
• Good knowledge on Cognos data manager to load the data into data marts from flat files.
• Developed Dimensionally Model Relational for standard reporting, Ad-hoc reporting and for Multi-Dimensional analysis using multi-layer approach and modelling best practices to meet the reporting requirements.
• Publishing to Cognos connection and implemented the Security for the packages.

Confidential

Database Developer

R esponsibilities:

• Involved in Requirements Gathering, Analysis, Design, Implementation and Maintenance of theentire project.
• Created and maintaining table spaces and data files.
• Involved in maintaining the security level of the database.
• Set up new user login accounts and access rights.
• Responsible for trouble shooting operation, reporting the problem, giving resolution and tracking.
• Analyzing and estimating the statistics of various tables & improving the execution time.

TECHNICAL SKILLS:

Reporting & Visualization Tools: Tableau, QlikSense, Planning Analytics/ Cognos TM1, Cognos Analytics/ Cognos BI and SSRS

Databases Oracle, db2, MS Access, MS SQL Server

Languages, Frameworks, Technologies VBA, VBScript, XML, HTML, JavaScript, SharePoint

Tools: HP Quality Centre, QTP, Selenium

Project Management Tools MS Word, MS Excel, MS PowerPoint, MS Visio