PROFESSIONAL SUMMARY

More than * years of extensive IT Experience especially in Data Warehousing and Business Intelligence applications in Financial, Retail, Insurance and Technology Solutions industries.

Experience in Operational Data Store (ODS), Business Intelligence, Data Modeling, Data Warehousing Concepts, OLAP, ETL tools and Analytics.

Good Experience in conducting JAD sessions with business users, technical leads, and development personnel in all aspects of the SDLC.

Expertise in writing SQL Queries, Dynamic-Queries and Complex Joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.

Experienced in Agile, Scrum with elaborating and record requirements using Epics and User Stories and to clarify requirements to the development team using the Agile best practices.

Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Business Process Analysis and Physical & Logical Data modelling.

Extensively used Looker, Tableau, Crystal Reports XI, Business Objects, Informatica Power Centre, SSIS, SQL Server, Oracle, Teradata and DB2.

Experienced in designing the data conversion strategy, development of data mappings and in the designing of ETL (Extraction, Transformation and Load) routines for migrating data from non-relational or source relational to target relational.

Hands-On experience on publishing various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers and Web Pages.

Capable of data extraction, dashboarding / visualization, and analytical modelling. Can execute analyses correctly and rigorously.

Logical Data Modelling, Data Warehouse design concepts, Dimensional Modelling using Star, Snowflake, Normalized and De-Normalized schemas with respect to query and analysis requirements.

Strong experience with Informatica Tools-Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformations Developer, Informatica Repository.

4 Years of Looker experience in Development and Administration, worked on Looker from 3.X to 6.X versions.

Strong experience in Looker Explore, Project and Views.

Good experience with LookML, Looker version controlling, Looker Blocks and data modelling in Looker.

Experienced in Performance Tuning of Looker Dashboards and experienced in Advanced D3 Visualizations and adding them to Looker.

Experienced in Geographic Analytics using Looker, setting up the actions in Looker, Looker custom table calculations like offset etc. and error handling & debugging in Looker reports.

Converted reports from Qlik Sense & Tableau to Looker and migrating the dashboards from other BI Tools to Looker.

Experienced in migrating legacy systems into Google Cloud Platform (GCP).

I Design and Build GCP data driven solutions for enterprise data warehouse and data lakes.

Experience in SSIS, SSRS, SSAS tools in SQL Server & Support different ETL process flows.

Experience with cloud data warehouses such as Snowflake, BigQuery, etc.

Skilled at optimizing/performance tuning of complicated SQL statements.

Experienced in Microsoft SQL Server, T-SQL, and supporting production databases.

Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.

Involved in Requirement analysis, Functional analysis, Design, Development, Implementation, Testing, Debugging, and maintenance of Power BI applications.

Good skills in testing the Enterprise Data Warehouses using Informatica Power Centre, Data Stage, Ab Initio and SSIS ETL tools.

Experienced in using Data Modelling tools like Erwin, MS Access, and Microsoft Visio.

Worked and provided guidance with Data Architect and DBAs to design, develop, implement, and maintain the conceptual, logical, and physical data models for OLTP and ODS to meet customer requirements and support ETL (Informatica) and Reporting (Cognos).

Successful as a team player to work in conjunction with other DBA's, Testers, Developers and Other team members in validation, testing complex scenarios and projects and in the maintenance of Quality Standards in projects especially with various test suites.

Ability to manage multiple and varied tasks with enthusiasm, deal with tough and demanding work priorities and Prioritize workload with attention to details.

EDUCATION DETAILS

San Francisco Bay University

Fremont, California, USA

Sep’ 2014 – Dec’ 2015

Master of Science in Electrical Engineering

Jawaharlal Nehru Technological University

Hyderabad, India

Sep’ 2008 – May’ 2012

Bachelor of Technology in Electronics & Communication Engineering

TECHNICAL SKILLS

BI Tools

Looker6.x,5.x, Tableau (Desktop/ Server/ Reader/ Public/ Mobile), QlikSense, Crystal Reports XI, Business Objects, Power BI, Google Analytics, Alteryx, MicroStrategy, IBM Cognos Analytics, OBIEE, and SSRS

ETL Tools

Informatica, SSIS, Data Stage, Talend, and Oracle Data Integrator

Databases & Data Warehouses

Microsoft SQL Server, Oracle, PostgreSQL, MySQL, DB2, Teradata, Snowflake, Greenplum, Netezza, Google BigQuery, Sybase, Hadoop, and Impala

Database Tools

Oracle SQL Developer, TOAD, and Teradata SQL Assistant

Applications

Microsoft Office Suite (Excel, Visio, PowerPoint), Adobe PDF

Scripting Languages

HTML, SQL, PL/SQL, XML, VB, Shell, Java, Java Script, Java API, C, Python, Perl

Data Modelling Tools

PowerDesigner, Erwin, ER/Studio, MS Visio, Toad, MySQL Workbench

Operating Systems

Windows 2005/2008/2012, Windows XP/7, iOS, Unix, Linux

PROFESSIONAL WORK EXPERIENCE

Client: Capgemini, San Diego, CA

Role: Sr. SQL Developer/ Sr. Data Analyst

Time: September’ 2021 - Present

Responsibilities:

I schedule design sessions and meet with internal Stakeholders to develop reporting/ dashboard requirements and UAT plans.

Build engaging rapport with client leadership through relevant conversations and genuine business recommendations that impact the growth and profitability of the organization.

Design a solution architecture that is scalable, reusable, efficient and effective.

Design and implement dashboard roadmaps and take ownership of improving aspect of

the security metrics program.

Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server and Oracle databases.

I develop technical solutions on Big Query, Looker, Composer, Terraform components: SQL data modelling and automation.

Developed complex SQL scripts to transform the source data into a dimensional model and we then created views in Oracle.

Wrote PL/SQL, SQL plus programs required to retrieve data using cursors and exception handling.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

I wrote stored procedures using PL/SQL and I performed PL/SQL tuning and application tuning using various tools like tkprof, autotrace and dbms_SQLtune.

Verified and validated SQL queries, Informatica automation and database views.

Analyse the source system and involve in designing the ETL data load.

Worked with ETL developers, Business Analysts, DBAs, to architect Data Model, design and implement database as well as write ETL related programs.

Developed the Informatica mappings by usage of aggregator, SQL overrides usage in lookups, source filter usage in source qualifiers, and data flow management into multiple targets.

Worked with DBA in creating aggregate tables and Indexes to increase the performance and meet the requirements for performance analysis and tuning the report.

Creating Looker projects and configuring the GitHub to Looker projects.

Designing effective layouts and Utilizing features in Looker to guide readers through a compelling data-driven story.

Implementing Looker center of excellence, coding standards and best practices for Looker.

I Build GCP data driven solutions for enterprise data warehouse and data lake house.

I Build data pipelines in airflow in GCP for ETL related jobs using different airflow operators.

Used cloud shell SDK in GCP to configure the services Data Proc, Storage Big Query.

I Support existing GCP Data Migration implementations.

I performed detailed analysis on tested and deployed Power BI scripts.

I have performed DAX queries and functions in Power BI.

Good experience in building interactive reports, integrating modelling results, visualization designing and analytical background by using Power BI and Tableau desktop.

Created various reports using Tableau based on client needs and developed Tableau desktop/ server dashboards.

Working industrially on solutions (Terraform, GitHub).

Ability to learn and understand application data table structure to create database schemas and ability to conditionally extract data directly from database to create complex database views with Strong SQL programming.

Involved in designing and developing Data Warehouses, Data Marts and Business Intelligence using multi-dimensional models such as Star schemas and Snowflake schemas for generating reports using SSRS.

Imported various heterogeneous files using Informatica power center 8.X source analyzer.

Performed unit testing, integration testing and system testing of Informatica mappings.

Environment: SSIS, SSRS, SSAS, Informatica, Tableau Server 8.1/8.2, Microsoft SQL Server, Google BigQuery, Looker6.x, Looker5.x, JIRA, Snowflake, Terraform, GitHub, Power BI, Microsoft Excel, Google Cloud Platform (GCP)

Client: Ernst & Young, San Jose, CA

Role: Sr. BI Developer/ Looker Developer

Time: August’ 2019 – May’ 2021

Responsibilities:

Work with a cross-functional team of developers and business analysts to deliver strategic data and analytics initiatives.

Utilize business analytics to create performance analysis reports and compile data to drive process improvement opportunities.

Drive the design and development of advanced interactive dashboards, reports, and visualizations using Tableau Desktop, while adhering to best practices and data visualization standards.

Perform thorough testing and optimization of Tableau visualizations and embedded analytics solutions to ensure optimal performance and user experience.

Develop new dashboards in Tableau to enhance data reporting, which includes gathering key metrics and transforming raw data into actionable insights.

Generated advanced Tableau dashboards with quick/context/global filters, parameters and calculated fields that allowed to track and improve customer units KPI by 12% within a month.

Responsible for creating SQL data sets for Tableau recurring and Ad-hoc reports.

Generated MicroStrategy reports and dashboards on Tableau depicting insights on KPIs facilitating fact-based smart decisions.

Extract and organize datasets using Excel to create business models and compile data for the organization’s risk index.

I extensively analyzed exiting data models and provides insights for future projects.

Experienced in writing SQL Queries for pulling large volume of records from Facets and Tax advisory database using stored procedures, and ETL process using SSIS.

Designed and developed SSIS interfaces for Customer Master, Investment process and Audit process etc., and created jobs using SQL procedures and different types of sources like Oracle, SQL Server and Flat files and FTP connections.

Develop reporting solutions for large data sets (Big Data) using SQL, SSRS, SSIS and Hadoop.

Enhance existing SSIS packages to use the new SAP data sources while maintaining the integrity of the DW.

Assist data integrity, data management, and data administration solutions for integration with SAP.

I experience with Microsoft SQL Server and Oracle database backup/restore processes and Microsoft SQL Server SSIS.

Provided technical assistance for maintenance of AutoSys and related scheduling solutions.

Responsible for design of ETL process and development of Informatica code by working with cross-functional teams to analyze requirements, develop technical design and deliver as per standards.

Creating and monitoring batches and sessions using Informatica PowerCenter server.

Extracted data from excel files, high volume of data sets from data files, Oracle, DB2, Salesforce.com (SFDC) using Informatica ETL Mappings/SQL PL SQL scripts and loaded to data store area.

Delivered migration projects related to upgrade of Informatica Power Centre from 6.1.1 to 8.1.1 and then to 8.6.1 along with Oracle upgrade from 9i to 10g.

I built automated reports and dashboards with the help of Power BI.

I delivered actionable insights by creating custom Microsoft Power BI dashboards, Visualizations, and 28 interfaces with Microsoft SSRS.

Used Power BI gateways to keep Dashboards and Reports up to date.

Implementing Looker best practices and embedding Looker in other tools.

Developing Explore models using LookML and extending Explores.

I design new LookML dimensions and measures within business requirements.

I analyze data models and business requirements to create LookML objects, including determination of source objects and how to join views into explores.

Created Looker dashboards, Looks and utilized Looker parameters to increase end user experience.

Responsible for maintaining security and data access models within Looker.

Worked on persistent derived tables and Experienced with Looker schedules.

Worked on Table filters and custom formatting.

Version controlling via GIT.

Mockups for the user cases of business.

Environment: Looker6.x, 5.x, Erwin, Oracle, MySQL, SQL Server, SSIS, SSRS, SSAS (DAX and MDX), SQL Developer, TOAD, JIRA, Rally, SFCC, HP Quality Centre, TensorFlow, Power BI, AutoSys, SAP, Data Architecture, ETL, Visualization, Tomcat, Tableau 7.0/8.0, QlikView, Qlik Sense, Talend, Share Point, Agile – Scrum, Java Script, CA Service Manager

Client: Anthem Inc, Woodland Hills, CA

Time: August’ 2017 – July’ 2019

Role: Sr. ETL Developer/ Sr. BI Developer

Responsibilities:

Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.

Involved in Debugging connection related problems, Query Design, Indexing recommendation and Performance Tuning.

Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database.

Handled various issues related to setup & configuration of 'Database Mirroring' solved issues related to synchronization of data in Development, Test, Smoke, Production environments.

Handled all complex queries, ETL/SSIS packages, stored procedures, and triggers.

Involved in writing complex SQL Scripts using excel sheets for loading data into maintenance tables. Handled all complex queries, ETL/SSIS packages, stored procedures, and triggers.

Extensively used SSIS Data Profiler Task to profile target source systems (tables & views) prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing table structures.

Designed high level ETL architecture for overall data transfer from OLTP to OLAP with help of SSIS.

Develop an ETL Database Model to carry out new procedures and create various database warehouse dimensions to accept ETL outputs.

Developed SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Union All, Sort and Execute SQL Task to load data into Database.

Involved in the migration to AWS cloud platform.

Involved in the deployment with scripting language Python and monitor scalable infrastructure on Amazon web services (AWS).

Experienced in writing PL/SQL queries to perform various database operations in Portico.

Loaded of tables from DB2 to SQL Server performed every night across multiple systems.

Used Sub queries, joins, CTE's and Analytical functions for data retrieval.

Analyzed complex queries tuned same optimize application system performance.

Experienced in building indexes at regular intervals for better performance.

Designed and implemented comprehensive backup plan and disaster recovery strategies.

Troubleshooting of claims database related issues during upgrading migration process and solved backup, copy, restore job failure, space, network, latency issues related to Log Shipping.

Created SQL Server Reports based on the requirements using SSRS 2014/2012.

Created data models and tables within Power BI to support efficient, optimized data warehousing and reporting workflows.

Documented DAX code and approach to the management of Power Bi Books.

Developed Reports, Views, KPI scorecards using Power BI Desktop and, Utilized Power BI to build interactive and visually appealing Dashboards.

Responsible for Hands-on development in QlikView, Qlik Sense, SQL, and Business Objects.

Developed business intelligence solutions using Business Objects, QlikView and Tableau.

Designed, Developed and Deployment of Tableau Business Intelligence Production environment for Insurance Policy and Marketing/ Project Portfolio management.

Calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers to implement the same in Development, Test and Production environment.

Extensively used advanced chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree Maps, Bubble Charts, Waterfall charts, Funnel charts etc., to assist business users in solving complex problems.

Created Alteryx workflows for such scenarios where data is not readily available.

Creating Tableau Scorecard, Dashboard, Bar Chart, Stacked Bar Chart, Scattered Plots, Geographical Map, Gantt Charts using Show Me functionality and publishing them to Tableau Server and Tableau Online.

Transformed Tableau into a managed service offering consumption across company capital and their investments.

Prepared Qlik sense proof of concepts as per the requirements and specifications.

Examines current BI dashboards, makes diagnoses, and continually improves and builds QlikView eco-system.

Experienced in designing dynamic dashboards using MicroStrategy Report Services.

Used Autosys tool for scheduling objects and running through UNIX commands.

Environment: MSSQL Server 2014/2016, MySQL, MS Access, MS Office Suite Word, PowerPoint, Excel, SSRS, SSAS, SSIS, Informatica, PL/SQL, T-SQL, Data Stage, Micro Strategy, Autosys, Alteryx, UNIX, MS Visio, Java, MS Project, AWS Oracle, TOAD, Teradata 13.10, Teradata SQL Assistant, Teradata Administrator, SQL Developer, Power Designer, Tableau, QlikView, Qlik Sense, Python

Client: Bank of America, Charlotte, NC

Time: June’ 2016 - July’ 2017

Role: SQL Data Analyst/ BI Developer

Responsibilities:

Involved in gathering, analyzing, and documenting business requirements and preparing technical documents for ETL, SSIS, Data Warehouse, SQL BI Development Worked with Business to document BRDs, Writing Functional Specifications.

Involved in performance tuning and optimization on Business Object Universes by creating Aggregate tables.

Created various user defined objects including Dimensional, Detail and Measure objects and tested them to ensure correct mapping of data.

Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.

Managed UAT with end users including coordination and user acceptance signoff.

Analyzed data using SQL to identify trends, patterns, and insights.

I write MS SQL and T-SQL scripts to transform raw data according to business requirements.

Performed ad hoc report analysis on the data behind the metrics and reports based on requests from the Line of Business.

Identify and resolve Data Quality issues. Developed and implemented data quality checks to ensure accuracy and completeness of data.

Developed and maintained database objects and ETL to support data preparation for BI reports, dashboards, scorecards, and Self-serve analytic capabilities.

I Validated the integrity and quality of data required for performing analysis.

Designed custom queries using Microsoft T-SQL and Crystal Reports as per defined technical specifications.

Created automate processes through stored procedures utilizing T-SQL to facilitate additional production capacity and not overburden the main data server.

Working with Toad and Oracle developers to prepare Oracle queries to validate the data in both source and target databases.

Developed Informatica mappings, reusable transformations and created PL/SQL stored procedures/packages for extracting data from source systems to staging and processing and loading to the data warehouse.

Created SSIS packages for data loading utilizing various tasks and transformations within the SSIS.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data mart databases.

Performed ETL process in Alteryx to extract data from multiple sources (SQL Server, XML, CSV, Excel) and schedule workflows.

I Developed complex reports, dashboards and supported the existing reports using SSRS and Power BI based on the end-user requirements, performed Ad hoc analyses using SSRS.

Developed and Tested Excel macros using VBA for reports and transferring data using DTS package.

Perform data validation and quality assurance checks, ensuring data accuracy and reliability.

Developed reports by linking different data providers in a single report and made all possible incompatible objects to compatible by merging the common objects.

Provided technical assistance/ support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/ interfaces.

Environment: Business Objects XI3.1/XIR2, Import Wizard, Publishing Wizard, Repository Migration Wizard, Oracle 10g, Sybase, SQL Server 2005, MS SQL Server, SSIS, SSRS, SSAS, Excel, Power BI, ETL, Informatica, TOAD, T-SQL, Teradata, PL/ SQL, Alteryx, MS SharePoint

Client: Reliance Retail

Implementation: IBM, Bangalore, India

Role: Jr. SQL BI Developer

Time: April’ 2012 – August’ 2014

Responsibilities:

Worked on all phases of Data Warehouse lifecycle from gathering requirements to testing, implementation and support.

Involved in developing the Audit, Complaint management and Event management related reports using Web Intelligence.

Involved in the Installation and Configuration of SQL Server 2008 and SQL Server 2012 with the latest Service Packs.

Used DDL and DML for writing Triggers, Stored procedures, and Data manipulation.

Created Ad Hoc and Parameterized reports using SQL Server Reporting Services (SSRS).

Used performance point services, SSRS, Excel as the reporting tools and wrote the expressions in SSRS wherever necessary.

Developed the reports in Reports Designer using Vertical stacked chart, Pie chart to view the quarterly metrics.

Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.

Deployed the SSRS reports in Microsoft Office SharePoint portal server (MOSS) 2012.

Involved in troubleshooting and tuning of the existing reports.

Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from and to various RDBMS and Non-RDBMS sources and destinations.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server, and Flat files.

Involved in the development of complex mappings using SSIS to transform and load the data from Oracle into the SQL 2008 R2/2012 Server target staging database.

Created Linked Servers to connect OLE DB data sources and providers participated in designing a data warehouse to store all information from OLTP to Staging and Staging to Enterprise data warehouse to do better analysis.

Extracted data from many operational systems, including flat files, spreadsheets and RDBMSs like SQL Server and Oracle 9i.

Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the multi-dimensional data warehouse.

Developed T-SQL programs required to retrieve data from data repository using cursors and exception handling and created T-SQL scripts to monitor deadlocks.

Developed SQL queries and PL/SQL procedures in Oracle database for the Application.

Created Universe consisting of Derived tables to create the report for different Business Segments.

Modified the existing Universe and created new Universe against Oracle database as per the reporting requirement to add new features to the reports.

Documented Design Documents for reports to provide detailed design and explanation of the reports and documented Unit Test documents to evaluate and validate reports.

Environment: Business Objects XIR2, Oracle 10g/9i, PL/SQL, TOAD and Windows NT, MS SQL Server 2008/2012, Visual Studio, PowerPoint, SharePoint, SSIS, SSRS, SSAS, Excel, T-SQL

Contact this candidate