SUMMARY

• 11 plus years of experience in IT industry as BI Developer/Architect, with expertise in BI tools including Qlik Sense, Tableau, Power BI, Cognos, SQL Server with strong background in Databases and Data warehousing concepts.
• Experience in MS - SSRS, SSIS, SSAS, OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration.
• Experience working with Business Intelligence data visualization tools with specialization on Tableau, Power BI.
• 4 + Years of experience in Power BI, Power BI Pro and Power BI Mobile.
• Expert in creating feature rich Power BI Dashboards and Ad-hoc reports, data driven subscription reports using Report Builder.
• Involved in designing, developing, testing, publishing, maintaining, and supporting Qlik Sense applications.
• BuildingQlik Sense QVDs,QVWs, QVFs using source systems Oracle, SQL Server, Teradata & Excel files.
• Experience in designing, development and deployment of Data Warehouse and Business Intelligence applications using COGNOS (Report studio, Query studio, Power Play and Transformer).
• Strong knowledge of Data Warehousing methodologies and concepts, including star schema, snowflake, ETL processes, dimensional modeling and reporting tools.
• Well experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in a Data Warehouse using SSIS.
• Worked on AWS services like S3 bucket and syncing data between servers.
• Hands on experience working in different domains including financial, insurance, healthcare and Retail domain.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports using SSRS, Tableau/Cognos.
• Extensive experience in reviewing Business Requirement Documents(BRD), Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experienced in interacting with end users to gather requirements for BI reporting.
• Lead projects, Team player and self-starter with strong communication skills and ability to work independently and as a part of the team.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.

TECHNICAL SKILLS

Business Intelligence tools: Power BI, Power Automate, Power BI Desktop, SQL Server (SSRS), Report Builder, Tableau 6.x to 9.x (Desktop, Server and Tabcmd)Cognos 10/8.4v/7v, MS Visual Studio 2017Qlik Sense Desktop, QMC, Qlik Hub, MicroStrategy 9.x

ETL Tools: SQL Server SSIS, DTS

Database: Oracle, SQL Server, Teradata, DB2 and MS Access

Programming Languages: C++, Java, SQL, PL/SQL, Python3.8

DB Interfaces and Web: TOAD for Oracle, SQL Tools, VB-Scripting, Java Scripting

PROFESSIONAL EXPERIENCE

Confidential, BOSTON, MA

Sr.BI Developer

Responsibilities:

• Mainly worked with different internal departments to identify the business requirements to develop BI solutions using SQL Server and Power BI.
• Designed and developed various Power BI dashboards using various data sources like SQL server, Excel files, and flat files.
• Worked extensively with the Governor’s office to create the COVID PPE Logistics dashboard using the data from PPE Order Log Excel files. Dashboards are refreshed daily to get the updated data. Reports are circulated to all the Senior Management daily.
• By using Power BI desktop connected to various data sources, working with different visualizations.
• Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
• Involved in QA and unit testing of reports and validating the reports against database before delivering to the users.
• Involved in pre-production support to remediate the defects for reports.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created SSRS reports for the COMMBUYS marketing team to see the expenditure by the Municipality/City/Town vs utilizing the COMMBUYS service.
• Created a Python script to consume D&B data from the API and saved the JSON data to SQL Server database.
• Created SSIS packages to source data from Oracle based Datawarehouse to the SQL server reporting datamarts.
• Trained internal business users on the Qlik data literacy program.
• Involved in full project life cycle implementation (requirement gathering to production) QlikSense dashboards.
• Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the QlikSense dashboards.
• Managed user access by creating roles and rules in QMC and Hub.
• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle, API) and flat files to create and schedule different complex reports as per given business requirement by leveraging the components of Qlik Sense.
• Created multiple tab dashboards with Trend graphs, Bar graphs, Stacked Graphs using Qlik Sense.
• Created S3 buckets in theAWSenvironment to store files and move data between AWS servers.

Environment: SQL Server 2017, Power BI, AWS (EC2, S3), Visual Studio 2017, Qlik Sense Desktop, QMC, Qlik Hub, Python 3.8

Confidential, JOHNSTON, RI

Principal BI ENGINEER

Responsibilities:

• Worked as a key resource in BI team from identifying the business requirements and developing BI solutions using SSRS and Power BI.
• Worked with the business users and internal clients to develop uniform metric definitions across the company.
• Design and develop Power BI content including reports, dashboards, presentation portals etc.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Created calculated columns, Measures in Power BI desktop to show data analysis techniques.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries.
• Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.
• Experienced in scheduling refresh of Power BI reports, hourly and on-demand.
• Designed and maintained SQL Server Integration Services (SSIS) packages and T-SQL code for importing data and tuned ETL packages for better performance.
• After the Confidential acquisition, worked on creating data mapping and migrating the databases from legacy system to the new databases on the parent company.
• Converted the legacy SSRS reports/dashboards into Tableau and Power BI reports based on the user preference.
• Created tabular data models and created measures and calculations in Power BI for use in the reports.
• Created ETL packages using stored procedures to migrate the legacy data into the new system and scheduled them for nightly refreshes.
• Hands on experience with home insurance compliance reports following the State guidelines and timelines.
• Created stored procedures for cleaning, manipulating, and processing data between the databases.
• Extensively used Joins and Common table expressions to simplify complex queries involving multiple tables
• Successfully worked with the third-party vendors providing guidelines and test strategies during the data conversion.
• Acted as the liaison between different Business teams, Developers and project management groups for the requirement definitions and mentored other developers on the new tools like Tableau and for support of newly created reports.
• Created data extracts for users using SQL developer on weekly basis.
• Provided production support of the ETL procedures and the reports by troubleshooting the errors and tuning the packages for performance.

Environment: SQL Server 2014, Power BI, MS Visual Studio 2013, MS Access, Tableau 10.0, Power BI Desktop.

Confidential, RI

Buisness Intelligence Analyst

Responsibilities:

• Developed Business requirement documents with detailed strategy for performance measurement mainly for the email programs, Direct mail programs, Offers at the register.
• Extensively used SQL and SAS programs for extracting customer data from Teradata Datawarehouse.
• Developed insights showing customer purchase patterns, response to the Extracare coupon programs, identified top performing categories.
• Worked with senior business partners to develop a strategy for measuring Digital receipt enrollment program and developed insights to show the effect of the program on Extracare.
• Developed code to analyze the Digital receipt pilot program and also the full program when it was rolled out into stores. Created synthetic control group to use as benchmark for performance measurement.
• Worked with the store managers identifying Thefts and loss & Prevention also on customer enquiries.
• Extensively used Excel Pivot tables, Vlookups, HLookup and macros to summarize the customer data and develop the reports for the business partners.
• Created datamarts with physical layer and business layer for the dashboard and refreshed the data weekly.
• Performed Administrative tasks like creating user profiles, vendor profiles and granting permissions for the Extracare Vendor Portal.
• Trained users on the Vendor Portal usage and helped them develop the reports effectively.
• Worked closely with the external vendors gathering requirements and created documents with thorough details.
• Worked with the Promo Director defining the data requirements, scope of the project and documented the process.
• Collaborated with the advertising team and merchandising team to acquire data for the reporting project.
• Extracted data from Retail data warehouse schema (RDW) and Teradata tables and performed data cleansing to create a MS Access database.
• Blended data from different data sources using PIVOT TABLES and created reports.
• Summarized data by categories and subcategories, and created custom calculations and formulas using VLOOKUP, HLOOKUP, WHAT-IF-ANALYSIS.
• Working with the Category Managers and the advertising team to set Sign targets for each category by week for the rest of the year.
• Performed daily report activities by executing the SQL code and importing data into Excel files and MS Access database.
• Use Reports generated from various BI tools like Tableau and MicroStrategy and sourced it for predictive Analytics.

Environment: Tableau 9.0.1, Teradata, MicroStrategy 9.4.1, Oracle 10g, SAS EG 5.1, Promo Analytics tool, Retail Warehouse Work Bench, MS Excel 2010, MS Access 2010.

Confidential, Rochester, NY

Data warehouse Analyst

Responsibilities:

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, Published onTableau Server for usage with Operational or Monitoring Dashboards.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections and in-memory in Tableau.
• Tested reports and uploadedTableau dashboards on to server and provided production support for Tableau users.
• Scheduled data refresh on Tableau Server for periodic refresh and based on requirement created full refresh and incremental refresh of Tableau data extract files.
• Integrated Cognos Reports within Salesforce.com by customizing SFDC pages and objects and S-Control for creating API to pass SFDC field values to Cognos parameters.
• Created Cognos Framework model with clearly defined Database layer, Dimensional layer and Business Layers.
• Developed several complex Dashboards to Ad Hoc reports in report studio to support Commercial and Supply chain business needs.
• Developed order management dashboard in Report Studio and scheduled to distribute the report in PDF format to User’s inbox on weekly and daily basis.
• Provided Scheduling and Bursting Reports to distribution lists and individuals folders from Cognos connection.

Environment: Tableau Desktop 9.0.1/8.2.6 , Tableau Server, Cognos 10.1.2/8.4( Framework Manager & Report Studio), Saleforce.com, MS Excel 2010, MS Access 2010, Quality Centre, Oracle 10g.

Confidential, BUFFALO NY

Bi analytics consultant

Responsibilities:

• Worked with FNFG and HSBC QA teams to develop an effective communication method for a smooth data transformation.
• Worked with the relevant QA teams to Discover, Describe, and Document detailed QA Requirements.
• Developed detail business logic for the ETL team pertaining to different types of accounts (checking, savings, CD’s, loans).
• Created Test Plans and test scripts, executed test scripts, and wrote Test Reports once executed.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, transformations, lookups, aggregations and expressions.
• Created views, SQL joins DTS packages and statements for applications.
• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports using SQL Server Reporting Services (SSRS) from the newly created data source after the acquisition.
• Deployed reports to report server, added subscription and snapshot for end users.
• Scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports
• Tuned and optimized queries by altering database design, analyzing different query options and Indexing strategies. monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Implemented various data sources live connections with embedded credentials toTableauServer for report and dashboard development.
• Manage the application’s users, groups, licenses and integration with Active Directory.

Environment: MS-SQL Server Management Studio 2000/2005, SSRS, SSIS, Tableau Desktop 6.1/7.0, Tableau Server 6.1/7.0, Tabcmd, MS Excel 2010, MS Access 2010.

Confidential, Detroit, MI

BI Developer/Analyst

Responsibilities:

• Worked with the relevant business partners to Discover, Describe, and Document detailed Business Functional Requirements (BFR) and Informational Requirements for new projects, modifications to improve existing systems and for business intelligence and reporting/ETL projects.
• Created SSIS packages to load data from heterogeneous data sources like Oracle, DB2, Flat files, Excel to SQL server.
• Designed Datamarts using data modeling techniques like Star schema and Snowflake schema.
• Developed Data Mapping documents, DDL scripts, and Data Dictionary and Meta data of the models and maintained them.
• Assigned roles, permissions and created email subscriptions for data driven reports using Report Manager.
• Wrote complex SQL, SAS and/or Access queries to extract data from a variety of SQL environments (e.g. MS SQL Server, Oracle, DB2) for internal business use or transfer to external vendors.
• Performed extensive analysis on membership, provider, medical and pharmacy claims data to suffice requirements of the various projects and also to help external clients.
• Scheduled the reports for refresh on a weekly basis and deliver them to their Inboxes.
• Performed vigorous UAT testing in a BI environment with SQL, excel, Cognos.
• Worked on documenting the data conversion process for future reference.
• Wrotetest cases to validate the data between source and target databases.

Environment: SQL server Management Studio 2005, SSRS,SSIS, Cognos 10/8.4 Framework Manager & Report Studio, MS Access, Quality Centre, PC SAS, DB2, Oracle 10g.

Confidential, Iselin, NJ

Sr. Cognos BI Analyst

Responsibilities:

• Worked closely with end users and DBA in understanding Business requirements and designing models.
• Designed metadata Models in Framework Manager.
• Designing and Documenting Technical Specifications following Best Practice Designs.
• Model designing includes analyzing Relationships and cardinality. Adding Business Rules such as Security, Calculations, Filters and Prompts. Creating a Business view for Report Authors. Defining Packages and publishing them to ReportNet server.
• Design & development of multiple reports using various templates like list reports, cross-tab reports, chart reports and drill-through (having multiple drill parameters).
• Developed several AdHoc Reports from Operational Data Sources (ODS).
• Developed Master Menu Report with Hyperlink features, which in turn route to Quarter reports.
• Developed auto refreshing Cognos reports in Cognos Viewer using JavaScript and HTML.
• Involved in deploying the package from development to stage for testing and production environments.
• Experience in resolving and troubleshooting tickets raised in Testing and Production.
• Trained Business Users in background scheduling and bursting through email.

Environment: Cognos 8 MR2, Reportnet1.1 MR3 (Framework manager, Cognos connection, report studio and query studio), DB2 8.1, Mainframe v7.11, Erwin 4.0, Lotus Notes, Windows 2000 Server.