SUMMARY

• Post Graduate having around 15+ years of experience in consulting Software Development with Complete SDLC exposure, in which Data Warehousing Professional as a primary skill BI Visualization.
• Expertise in using Reporting Applications of different BI reporting tools like Power BI and Cognos Analytics.
• Demonstrated ability to understand complex business needs and translate business requests into reporting and analytical deliverables.
• Gathered requirements for Business Intelligence systems, participated in design and enhancement of those systems to improve the quality and accessibility.
• Identify, prioritize and resolve fit/gap issues between current and future Business Intelligence systems.
• In Depth Knowledge in designing and building Data warehouses using Ralph Kimball and Bill Inmon Approaches.
• Extensive documentation of Functional and Technical Specifications in Report Solution Design and Testing.
• Expertise in Data Visualization and Data Analytics using Power BI, Tableau and SSRS.
• Experience in using Power BI Apps and Content Packs.
• Understanding in Limitations and future features in Power BI
• Extensive experience in designing data models (Conceptual, Logical, and Physical data modeling techniques) for highly Normalized OLTP systems and Dimensional models for OLAP systems using ER modeling.
• Facilitate requirement, design, testing and training sessions with business customers and colleagues.
• Maintain active relationships with business customers to determine and document business and technical requirements.
• Expertise in SQL programming. Proficient in RDBMS concepts and writing T - SQL queries, Joins, Sub queries, CTE’s, Stored Procedures, Functions, Query optimization and Performance tuning.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard, SQL Server Extended Events.
• Expertise in creating SSIS packages using various Data transformations like conditional splitting, Derived column, Fuzzy Look Up, for each Loop, Multi Cast, column conversion, Fuzzy Grouping creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database.

TECHNICAL SKILLS

Data warehousing: Data warehousing Concepts, Snow Flake, Star Schema

ETL Tools: Informatica 9.1.0, Power center 9.1.0, Alteryx, SSIS

BI tools: Power View, Power Pivot, Power Pivot, Power BI Desktop, Power BI Server Cognos Analytics Tableau 7.0/Tableau 8.0/Tableau 8.1 Pentaho

Programming Languages: C++, VB

Scripting: HTML, Java Scripting, TSQL

Other: MS office, Motio

Operating System: Windows, Unix

Bug Tracking Tools: Remedy, Mantis, JIRA

Database Tools: SQL Query Analyzer, SQL Server Profiler, SQL Server Extended Events, Database Tuning Advisor, Oracle 9i/10g/11g, DB2, Toad, Rapid SQL, DB2, IBM Netezza Appliance, Green Plum, Teradata

Cloud Platforms: Microsoft Azure Synapse Analytics (SQL DW), Azure Data Lakes Storage, Azure Data Bricks, AWS Cloud

PROFESSIONAL EXPERIENCE

Confidential, Chicago

BI Consultant

Responsibilities:

• Maintain active relationships with business customers to determine and document business and technical requirements.
• Designed an ETL mapping document to help identify source, transformations and destination per business requirement.
• Maintain documentation for all processes and solutions implemented
• Collaborate with other teams within the organization and devise technical solutions to meet business/functional and technical requirements
• Performed trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and developed dashboards and tiles using Power BI site as well as Reports and Data Models using Power BI Desktop
• Convert existing manual Excel/Access/Power BI datasets/reports into SQL Server/Analysis Services/Power BI solutions
• Implemented direct query and import datasets methods.
• Developed reports using various visualizations such as Filled Map, Gauge, Donut, Funnel, Slicer, Multi-row Card, KPI
• Created calculations and measures using DAX expressions.
• Scheduled data refresh utilizing on-premise power BI gateway with Power BI services.
• Used Tableau as per some User requirements and created Worksheets and Dashboards by blending data from different data sources.
• Implemented different DAX features like calculated fields, groups, sets and filters in Dashboard creation.
• Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure cloud environment.
• Facilitate requirement, design, testing and training sessions with business customers and colleagues.
• Strong applied knowledge of Power Apps including in-depth understanding of customization, configuration, integration, and extensibility, as well as boundaries and constraints
• Should have experience in developing PowerApps in Canvas, Model-Driven & Portal as well as enhancing existing apps.

Environment: POWER BI ( Power BI, Power Pivot, Power Query, Power View), SQL Server, MS Excel, T-SQL, AWS, SharePoint, Teams, Tableau, Visual Studio 2015

Confidential, Chicago

BI Consultant

Responsibilities:

• Maintain active relationships with business customers to determine and document business and technical requirements.
• Designed an ETL mapping document to help identify source, transformations and destination per business requirement.
• Maintain documentation for all processes and solutions implemented
• Collaborate with other teams within the organization and devise technical solutions to meet business/functional and technical requirements
• Performed trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and developed dashboards and tiles using Power BI site as well as Reports and Data Models using Power BI Desktop
• Convert existing manual Excel/Access/Power BI datasets/reports into SQL Server/Analysis Services/Power BI solutions
• Implemented direct query and import datasets methods.
• Developed reports using various visualizations such as Filled Map, Gauge, Donut, Funnel, Slicer, Multi-row Card, KPI
• Created calculations and measures using DAX expressions.
• Scheduled data refresh utilizing on-premise power BI gateway with Power BI services.
• Used Tableau as per some User requirements and created Worksheets and Dashboards by blending data from different data sources.
• Implemented different DAX features like calculated fields, groups, sets and filters in Dashboard creation.
• Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure cloud environment.
• Facilitate requirement, design, testing and training sessions with business customers and colleagues.

Environment: POWER BI ( Power BI, Power Pivot, Power Query, Power View), SQL Server, MS Excel, T-SQL, AWS, SharePoint, Teams, Tableau, Visual Studio 2015

Confidential, Detroit

BI Consultant.

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers. Ensured that the existing data warehouse, reporting systems and various tools were adequately supported
• Restructured the database normal forms to implement normalization techniques for both existing and new tables to avoid insert, update and delete anomalies
• Designed mappings between sources and operational staging targets utilizing star schema.
• Wrote dynamic T-SQL scripts that used Table Variables and CTEs to apply business logic
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, staging DB to data warehouse and data marts.
• Developed and deployed data transfers packages using SSIS and maintained the jobs running on servers
• Applied various data transformations like data conversion, multicasting, conditional split, derived column in SSIS.
• Created New measures with calculation expressions using DAX functions.
• Designed an ETL mapping document to help identify source, transformations and destination per business requirement.
• Implemented checkpoints, breakpoints, and data viewers within the SSIS packages for flexible troubleshooting.
• Modified existing SSAS cubes with key performance Indicators, hierarchies, calculations to support new report requirement.
• Performed trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and developed dashboards and tiles using Power BI site as well as Reports and Data Models using Power BI Desktop
• Implemented Direct query and import datasets
• Developed reports using various visualizations such as Filled Map, Gauge, Donut, Funnel, Slicer, Multi-row Card, KPI
• Designed various financial reports on top of cube and relation databases utilizing Power BI .
• Created calculations and measures using DAX expressions.
• Scheduled data refresh utilizing on-premise power BI gateway with Power BI services.
• Used Tableau as per some User requirements and created Worksheets and Dashboards by blending data from different data sources.
• Implemented different DAX features like calculated fields, groups, sets and filters in Dashboard creation.
• Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure cloud environment.

Environment: POWER BI Power BI, Power Pivot, Power Query, Power View), SQL Server 2014, DAX, MS Excel, Azure SQL Database, SharePoint, Teams, Visual Studio 2015

Confidential, TN

BI Developer.

Responsibilities:

• In depth interaction with Database Architects, SME’s for requirement gathering for solution implementation for analytics Reporting system.
• Expertise in Extraction, Transformation, loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using Power Query.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kinds of Power BI Reports and Dashboards.
• Created, Maintained & scheduled various reports in Power BI.
• Published Power BI reports from Power BI desktop to Power BI service.
• Created different visualization in Power BI according to the requirements.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
• Experience in creating Report Models for building Ad hoc reports using Power BI.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in Power BI.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in Power BI.
• Generated the weekly, monthly, and quarterly Visualizations reports by using Power BI.
• Very good experience modifying and writing expressions in Power BI.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases, Created Models using Power Pivot.
• Created many complexes Query's and used them in Power BI Reports directly to generate reports on the fly.
• Developed self-service BI model, Implemented new measures and calculations using DAX expressions
• Created different visualizations (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
• Created Page Level Filters, Report Level Filters and Visual Level Filters in Power BI according to the requirements.

Environment: Power BI (Power Pivot, Power Query, Power View), SQL Server 2012, DAX, SharePoint Server, MS Access, MS Excel, Visio. Visual Studio 2013

Confidential, TN

Sr. BI Writer| Developer

Responsibilities:

• Involved in the Installation and Configuration of Cognos 10 BI tools and Framework Manager
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Gather requirements directly from clients and Business Analysts through meeting and group discussions for presenting data set.
• Created database layer, business layer and presentation layer, defining appropriate relationship between query subjects in Framework Manager
• Created Active Reports, List, Crosstab, Dashboard Reports and Drill-Through Reports using advanced reporting techniques and Bursting Several reports for Business users on regular intervals on their Business demand request.
• Performance tuning of reports at Reporting layer and Framework Manager Model layer
• Extensively worked on the complex prompt page design of various reports for different customized report requirements.
• Creating Framework model for ad-hoc reporting needs of the business and training users to build and customize their ad-hoc reports in Query Studio
• Created ad hoc framework manager model and trained business users to work with the ad hoc package in Cognos Query Studio
• Provided security at different levels for Cognos reports and Framework model
• Used JavaScript for certain validations to overcome the limitations in Cognos report studio
• Created Test Plan and involved in test cases preparation and execution of the test plan
• Handled deployment of packages in lower to higher environment, user training, knowledge transfer, and support and transition activities as per SDLC process Sprint Releases.

Environment: Cognos 10.2 Suite (Framework Manager, Cognos Connection, Query Studio, Report Studio), MS SQL Server, Erwin Data Modeler 4.5, Windows

Confidential

BI Consultant

Responsibilities:

• Extensively using BI reporting Cognos Tool Feasibilities for presenting data set on reports according to the multilingual data presentation according to user profile Language and requirements.
• Gather requirements directly from clients and Business Analysts through meeting and group discussions for presenting data set.
• Created Multilingual Reports using Cognos for Japanese Business Analytics system for their analytical solutions for sprint releases.
• Modeling using Framework work manager to present preferred data set Chosen by user in and providing solutions on demand accordingly and deploying package.
• Incorporated Filters and Prompts in reports to display data set according to the user choice at the run time to get dataset present on reports.
• Reviewing High Level and Low level Design docs and clarified design solutions with Team and Business Users to Present data set.
• Proficient in designing, reviewing and documenting Technical and Data workflow, Advising g test Procedures for test cases on the basis of client’s requirements and related technical design documents.
• Performing data validation for report data set against testing using SQL and resolving data issues and providing solutions accordingly.
• Perform sanity check, security checks, and regression testing and data reconciliation.
• Co-ordinate with Internal team to explain requirements and work with them to achieve deliverables.
• Follow Defects in Bug tracking tool and Fix those in reports and test it thoroughly before handover to QA team and then deploying into higher environment after receiving QA signoff.
• Perform review with client for our activities and ensure all requirements are developed and tested properly.

Confidential, Hartford, CT

BI Consultant

Responsibilities:

• Design, develop, test and deploy new application /analytical /reporting solutions to meet end-user requirements as per Business Need.
• Generated Data Warehouse Design recommendations and alterations, based upon issues discovered during Business Requirements Definition Phase of Ad Hoc Reporting system.
• Creation and generation of various statistical Active reports for QA, and other portions of ongoing design Data Warehouse.
• Gather document requirements from end-users for new applications/Active reports/analytics.
• Regularly met with project teams and management to present options / project updates / obtain and document various Business Requirements.
• Presented options for automation of security to provide single, central point of maintenance with pass-through (via Access Manager Objects) from namespace to Power play cube, including points in between.
• Interaction with the Business Users to gather requirements, define the report formats, develop the Active reports and assist them to become familiar with the features of Cognos Web component of Query Studio.
• Analyzing Prompt Data source details for the filters available in the all Business need of Active reports and Captured those information for creating index for report Optimization.
• Good Explore on Report Performance tuning and optimization apart from Cognos Reporting.
• Providing resolution for the tickets by dig into the Database Objects and analyzing from the
• Report prospect with reference to the data model.
• Handing Independently Cognos Administration and Security of user’s role maintaining using LDAP.
• Kick of ESP Jobs to build Power play cubes and Checkout data before handover to Business for Validation.
• Adding Users to Global Group as a part of User access to Cognos Power play cubes and Active reports.
• Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those Internal to the organization
• Primary Coordinator for all Project related activities
• Ensure QA on all Project deliverables
• Monitor compliance with development and configuration standards
• Manage Project issues, actions and risk logs, Issue resolution and escalation
• Manage delivery of functional/configuration work assigned to My project team
• Identify risks and clearly communicate them to project stakeholders
• Define problem solving and risk mitigation strategies
• Oversee the compilation and analysis of project activity and will deliver statistical data/reports on a project's feasibility and progress.

Confidential, NYC.

Cognos BI Consultant

Responsibilities:

• Design, develop, and implement Cognos TM1and Cognos BI solutions for financial planning and budgeting projects using Turbo Integrator (TI) and complex business rules.
• Extensively used TI for loading data into Dimensions and Power play cubes, added new dimensions and Power play cubes to existing environment.
• Developed TM1 application to gather and consolidate data in support of the footnotes in the annual report.
• Manage TM1 data through TM1 Reports (Active Form & Slice).
• Created and arranged different TM1 rule statements and performed complex calculations for Power play cubes at N&C levels
• Created ad-hoc queries from multidimensional views for analysis.
• Developed Power play cubes, Reports, and Dashboards using Cognos BI.
• Created Dynamic Reports from Worksheets and Power play cube views using different functions (DNEXT, DFRST and ELCOMP).
• Worked on replicating the Power play cubes between servers, sharing data between Power play cubes and linking asymmetrical Power play cubes.
• Created ETL (Extraction, Transformation & Loading) processes in TM1 performing business rule mappings of relational data into dimensional model.
• Deployed the TM1 data into production environment.
• Prototyped system interfaces in Excel and facilitated reviews and capture project related documentation and maintain project repository.
• Facilitated discovery and documentation of multi-organizational planning and forecasting processes.
• Validated reports based on Functional Requirements.
• Prepared for Unit Testing, UAT and created Logs, Defect Tracking using Quality Center.

Confidential, US

BI Consultant AMSS Agile Manufacturing & Supply Strategy Agile Methodology

Responsibilities:

• Understanding Cognos Performance Applications (PApps) framework and reports
• Creating Detailed Design Document (DDS) for the user requirements
• Enhancing the existing PApps reports as per user requirements
• Develops high complexity Cognos reports
• Created List reports, Cross-tab reports with Conditional formatting and Drill-through Reports using Report Studio.
• Assist more junior Cognos resources in the development or medium and low complexity ETL programs.
• Analyzing Prompt data source details for the filters available in the all OTB reports and Captured those information for creating index for report Optimization.
• Performs Unit Testing of Cognos reports and ensures all Unit Tests carried out are documented and have passed
• Communicates status to PASCI PM & onsite Cognos Lead.
• Assists in performing Verification Testing
• Assists in the transition of the Reporting solution from development/test to production