SUMMARY:

• 12 Years of Experience in Data Warehouse Applications, Data Analytics, and Client\Server Applications on Windows and Unix platforms.
• BI Development expertise in Tableau 2022.1, 2021.4.6, 2020.4, Cognos (Cognos 11. x,10.2,10.1) Cognos Analytics, Dashboards, Scorecards, Framework Manager, Transformer, Report Studio, Event Studio Analysis Studio, Business Insight, Cognos TM1, Hadoop, Grafana.
• Experience in Business Data Analysis, Data Model Design (Erwin), Cognos Architecture Data Mining, and Segmentation techniques.
• Excel in fine - tuning queries for optimum performance on Snowflake and Relational Databases (RDBMS) Oracle, SQL Server, DB2, and Teradata.
• Customized Web portals, Integrated Cognos with Third Party Applications using Cognos SDK
• Macros, JavaScript, SQL queries, PL/SQL Procedures, Shell scripting, and Python
• Expertise in building Relational and DMR Framework Models, Multidimensional Cognos Cubes, Customized Portal Pages, Scorecards, Multipage Dashboards and Report Studio reports for higher management.
• Expertise in building Dashboards with the Tableau software.
• Experience in Extraction Transformation Loading (ETL) Process, Creation of Data Marts using Decision Stream Worked with Informatica Power Center, Power Mart (Repository Manager, Designer, and Server Manager)
• Strong Expertise in Star Schema and Snowflake Schema Methodologies
• Worked in BI for major Mortgage, Financial, Telecom, Pharmaceutical, and Health Insurance Companies.

TECHNICAL SKILLS:

BI Tools: Tableau 2022.1, 2021.4.6, 2020.4, Cognos 11x,10.2,10.1, Dashboards, Scorecards, Business Insight, Report Studio, Analysis Studio, Report net1.x, (with Apache Web Server, LDAP) Cognos SDK, Business Objects, Web Intelligence, Grafana

ETL Tool: Decision Stream 7. x, Informatica

Modeling: Ellie Mae Snowflake Data Connect, Framework Manager, Architect, Erwin

Methodologies: Star Schema, Snowflake schema, Influx DB

Web Server: WebSphere, Apache Server 2.0.48

RDBMS: Netezza, DB2, Oracle, Microsoft SQL Server, DB2

Languages: C #, PHP and Asp .Net Technologies, Javascripts, HTML, XML, Socket programming,SQL, PL/SQL, Visual Basic

Script Languages: Python, Cognos Script, Bourne Sh, Csh

PROFESSIONAL EXPERIENCE:

Confidential

Senior Tableau Developer

Responsibilities:

• Participated in full lifecycle design, functional analysis, development, and execution of Tableau Requirements.
• Develop Functional and Business specifications of the reports and E2E test cases for Business users.
• Develop Business rules for Encompass tool and develop queries for Mortgage Cycle.
• Develop Snowflake queries for the Dashboards and cross verify with Encompass Data.
• Implemented Tableau Security for Branch Managers and Loan Officers with Context Filters.
• Built multisets with dropdowns and develop set functionality on the reports.
• Coded complex calculations on Rolling twelve months, LODs, Graphs, and set up drill-through reports.
• Developed reports with Tableau Extracts / Live Data and published as per user requirements.
• Maintained different data sources for the Dashboards and administered.
• Published and scheduled customized interactive Tableau reports and dashboards
• Improved performance by fine-tuning Queries from different Data sources
• Reports based on time analysis were done with Visualization charts
• Created Loan performance data using stacked bars, geographical maps, and Gantt charts

Tools: Tableau 2020.4,2021.4.6 and 2022.1, Ellie Mae Encompass, DataConnect, and SnowFake Technology

Confidential, Chicago,IL

Business System Analyst

Responsibilities:

• Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions for Checklists.
• Defining software requirements for the developers.
• Implemented Workflow for Fraud Bot and Rate sheets projects.
• Meet Business needs such as functional, operational, or usability requirements for VA Appraisal BOT.
• Deliver business requirements by doing end-to-end analysis for product/ systems with respect to data requirements, data flows,
• Review code and query database for validating data.
• Develop custom fields and plug ins for Encompass users.
• Build Python scripts for TabPy to display Optimized vs Actual Results sets from the Confidential Analysts Datasets using Tableau Prep Builder.

Tools: TabPy, Tableau Prep Builder 20202.1.1, MySQL, UiPath, C#, ASP .NET, PHP, Encompass22.1, Python 3.

Confidential, Middletown, NJ

Lead Developer

Responsibilities:

• Developed demo for Real-Time Analysis of data using Grafana and Influx DB.
• Developed and customized the existing Framework Models l from CQM to DQM and enable caching.
• Upgraded existing Cognos Reports into Interactive reports and fine-tuned queries to improve performance.
• Convert the third-party interactive reports for DDOS Phase 2 with Cognos Visualization and Interactive methods.
• Develop Executive Dashboards on U- verse Data.
• Developed complex customized Cognos reports on the U-Verse project as part of the first phase of converting Cymbal queries to Cognos queries.
• Develop DMR Model for CTE Marketing reports with Tree Prompts and Crosstab reports and Date functionality with JavaScript.
• Developed Active Reports with Slider, Iterators interaction features, and Visualization using Cognos 10.2.
• Implement Framework Model on HIVE Connection for Project Stream with Open session commands and develop reports using partitioned fields for better performance.
• Work Closely with the ETL and database developers for the implementation of aggregate tables.
• Develop Templates to Standardize all existing and newly developed ATT Internal reports.
• Upgrade the Cognos 10 version to Cognos 11.1.2 Analytics for better performance and usage.

Tools: Cognos 11.1.2, Cognos 10.2 (Framework Manager, Report Studio, Visualization, IBM Cognos Server Administration), Netezza 9.x, IBM Big Insights Infosphere, Linux, Dynamic Cubes, Dynamic Analyzer, Data Stage.

Confidential

Application Developer

Responsibilities:

• Developed High-Level Design-Low Level Design documents for RDS and GRE Reporting as part of the analysis
• Imported Tables, Views customized query subjects for the GRE Reporting Framework Model
• Various versions of the FM models were maintained for the entire development team.
• Implemented complex queries for Referrals Program and MOM Reports as the combination of List and Crosstab reports using Report studio.
• Created Report views for each Program report in GRE Reporting. Queries included Union queries, Conditional blocks, and writing pass-through SQL as per report logic requirements.
• Developed GCB dashboard as per user needs.
• Relational and DMR FM models were developed for the Volumes and Error star schema with multiple Fact tables
• Relational Framework Models were developed for Customer To Account, DQ, and IIS Audit Reports.
• Worked closely with Database and ETL teams for timely loading of data.
• Worked closely with ETL groups and database groups for Table/Column reporting requirements
• Develop Active KBM reports and implemented as a multipage dashboard along with Data Quality Reports.
• Trained RDS users to use Cognos Workspace, Query Studio Tools.
• Developed Multi-dimensional Cubes with drill throughs and signoff txt to create and build the COMMIT ECR, CSA and WMBS cubes. Complaint Resolutions cubes were re designed to point to Reports instead of iqds after migrating to Linux environment.
• Developed Complex Trend Reports, Category Case reports, with MTD, YTD logic with drill throughs.

Tools: Cognos Report Studio 10.2, Framework Manager 10.2, Query Studio 10.2, Analysis Studio, Event Studio, Business Insight, Toad for SQL Server 5.5

Confidential, Jersey City, NJ

Senior Cognos Developer/Business Analyst

Responsibilities:

• BBH is a private investment bank providing financial services to its clients all over the world. Worked in the CIE Development team for major two products
• Transaction Reporting and Positions Reporting designed to provide transactional Customer Account data both on the Java Grid and in the form of scheduled Cognos Excel,
• CSV, Customized delimiter and PDF reports. The front-end UI is integrated with Cognos reports through Web Services.
• The projects were extended to Japanese clients and customized reports by saving parameters as Favorites and running Async exports as per business requirements.
• Developed Relational Data models using Framework Manager for CIE Subscriptions and CIE Positions. Worked with DBAs to fine-tune large DB2 report queries.
• Coordinated and supported Cognos administration during the loading balancing on various dispatchers. All projects were executed using the Agile Process.
• Built metadata TR and PR Framework models, extensively using Macros for developing security and My settings Security ID ‘s functionality.
• Designed Cognos data models with various customized query subjects and macros referring to existing Positions Grid and Transaction Reporting Applications.
• Solved major design issues with the existing Framework Model for Fund Admin and TER projects.
• Built customized stored procs, and published CIE Subscription and CIE Positions package using Framework Manager.
• Various versions of FM models were maintained on Serena Dimensions during RD, QC, and Production deployments.
• Developed multiple pages multi-query PDF TRADES SUMMARY reports with complex business calculations using Report Studio.
• Developed Standard Templates for Fund Admin Dashboard for TER and Complex Summary POSITIONS Reports.
• Built Stored Procedures using PL SQL for Date Functionality.
• Implemented the UI Grid functionally from MY settings as per user requirements on Security IDs, Time and Date functionality on all Positions Reports using Macros.
• Worked along with Java developers in Scheduling and Distributing of reports through email, attachments, and to UI Inbox using Cognos SDK
• Performed Report Optimization on Positions Reports on oracle database with data on fact tables ranging from million rows of data.
• Developed and worked on 72 Reports ETF Reports. The reports were triggered from the Front end and were scheduled using Event studio.

Tools: Cognos 10.1, Framework Manager, Cognos dispatchers, Report Studio, Event Studio, LDAP, IBM WebSphere, DB2, Oracle 10i, Business Insight Advance, Cognos SDK, IBM Rational, PL SQL

Confidential, Basking Ridge,NJ

Senior Cognos Developer

Responsibilities:

• Worked as senior Cognos developer for Confidential Telecom Marketing Department.
• Deal Margin and Promotions Project reports were developed to see the increase in sales of products after applying promotion codes

Tools: Report Studio 8.4, Framework Manager, Decision Stream 7.x, Java Eclipse, Cognos SDK.