SUMMARY

• Around 7 years of experience as a BI consultant in core concepts of Data Warehousing, Tableau, Microsoft Power BI and Reports development in Microsoft SQL Server Suite of Products.
• Experience in Business Objects, Business Intelligence, Data Analysis profiles with strong knowledge of Software Development Lifecycle (SDLC).
• Adept at working with Agile and Scrum methodologies to accomplish project milestones according to specific time frames.
• Experience in working with SQL server Integrated Services (SSIS), SQL Server Analytical Services (SSAS) and SQL Server Reporting Services (SSRS).
• Experience in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Experience in Extraction, Transformation, loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Knowledgeable about a wide range of design and testing approaches.
• Experience with Data Warehouse Concepts like Dimension Tables, Fact tables, slowly changing dimensions, DataMart, and dimensional modeling schemas.
• Experience in Relational Databases like Oracle, MS SQL Server, MS Access, SQL, PL/SQL and Operating Systems like Windows, Linux, and UNIX.
• Experience in Diagnosing and Troubleshooting performance issues in SQL Server Databases using DMV’s and DTA.
• Experience in writing complex SQL queries.
• Knowledge in creating and using different Database objects like tables, views, Stored procedures, functions, keys, DDL queries and DML queries.
• Used SSIS, Informatica and ODI to create ETL packages to validate, extract, transform and load data to data warehouse.
• Experience in writing DAX queries in Analysis Services and Reporting Services.
• Experience in creating measures and calculated columns in Tabular cube.
• Experience in developing reports such as paginated, parameterized, drill down, drill through reports.
• Extensive knowledge on creating reports using Power Query, Power Pivot and Power view.
• Extensive knowledge and experience in creating reports and dashboards using various visual objects like Line chart, Bar chart, Donut chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals using Tableau and Power BI.
• Experience in Publishing and rendering reports based on demand.
• Knowledge in implementing security and integrity of reports and data by creating workspaces for different user groups and implementing row level security by restricting data access to users.
• Experience in configuring the data sources to schedule the data refresh using Power BI gateways (Personal and Enterprise).
• Experience using On - Premises and SaaS (Software as a Service) Power BI, Power BI Desktop and Power BI Services.
• Knowledge of implementing Snowflake and Star schema design for DWH.
• Designing Dimensions and Facts using KIMBALL/ INMON methodologies.
• Excellent analytical, problem-solving skills with good technical background and interpersonal skills.
• Efficient team player with excellent communication skills and good interaction.

TECHNICAL SKILLS

Languages: PL SQL, T-SQL, Dynamic SQL, MDX, Shell scripting, basics of Python

Databases: Oracle, MS SQL SERVER 2016/14/12/08/05 , MySQL, MS Access

DWH/BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual studio, Informatica, Looker, Oracle Data Integrator

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, FACT and Dimensions tables, Physical and logical data modeling and De-normalization techniques, RDBMS, OLTP, OLAP

Package: MS Office, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Power BI, Tableau, OBIEE, Crystal Reports, Power Pivot, Microsoft Office, ALM

Operating Systems: Windows NT & Windows 9x, MS-DOS

PROFESSIONAL EXPERIENCE

Business Intelligence/ ETL Developer

Confidential

Responsibilities:

• Collected business requirements from users and drafted them as Business Requirement Document.
• Extensively worked with the Business Analysts in understanding the requirements.
• Played a major role in preparing STM (Source to Target Mapping) design with the business users.
• 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.
• Good knowledge of data analytics tool Looker, performed POC to explore, analyze and share real-time business analytics using Looker.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Developed dashboard prototypes using Cloud Dashboard Tools Looker and AWS Quicksight managing all aspects of the technical development.
• Worked on designing, creating, and deploying SSIS packages for transferring data from flat files, Excel, Oracle, XML and heterogeneous data to and from SQL Server.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Automate monthly excel reports into Tableau Workbooks and Dashboards.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Published Power BI Apps from Power BI workspace and pushed the Apps in to User App tab.
• Created standard Reports and Chart Reports, Cross Tab Reports and Drill Through reports.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Design and write elastic queries to access data across database and migrate an existing SQL Server Database to use Azure SQL Database.
• Generated reports using the Reporting Services analyzed using Server analysis (SSAS).
• Analyzed different data sources and create data flow document for Data validation.
• Developed code and have written complex SQL queries to use in mappings.
• Create measure and dimensions on Looker based on the data and the business requirements.
• Extracted data from various sources like Oracle and flat files and loaded into the target Oracle database.
• Created mappings in ODI using different transformations.
• Done extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, and sessions.
• Prepared Test Cases and executed test cases using HP ALM.Tested the code in SIT and Production environments.
• Created stored procedures using PLSQL.
• Created several power BI using different visuals like filters, slicers, graphs, bar graphs.

Environment: Power BI, SSIS, SSAS, SSRS, OBIEE 12c, ODI 11g, Oracle 11g, SQL Developer, PL/SQL, Informatica 9.0.1, MDM, Quality Centre 11.0, Win 7, UNIX - Solaris, COBOL, Tableau 10.1/9.3, Azure Cloud, MS Excel

Business Intelligence/ ETL Developer

Confidential

Responsibilities:

• Understanding the KPIs and Requirements Documents, Designing, Developing, and testing reports in Power BI/Tableau/Looker.
• Performing quality check on data, identifying outliers, normality and standardizing the data
• Extensively involved in the Analysis, design, and Modeling. Worked on Snowflake Schema, Data Modeling, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
• Generating Risk stratification reports using MS Power BI to manage the higher cost treatment plans and improve the quality of care by highlighting the risk summary and impact ability by chronic conditions
• Developed linear regression predictive risk and impact ability models to predict the members with high risk and helps care-providers to quantify the care-gaps prioritization for each member
• Established platform to process raw data and convert them to datasets
• Created dashboards by extracting data from different sources
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created customized reports using complex SQL queries, Created Database connections and Spotfire Dashboard file (DXP) in Spotfire server.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Developed, deployed, and monitored SSIS Packages.
• Produced comprehensive analysis report on legacy data, data structure and statistical summary with Python.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Involved in creating interactive dashboard and applied actions (filter, highlight, and URL) to dashboard
• Created hierarchies and partitions for improving SSAS cube performance.
• Involved in creation and maintenance of SSAS cubes, perspectives, aggregations, and named sets for reporting.
• Experience with Office 365 tools SharePoint, PowerApps, Power Automate (Flow), Delve, MS Teams, Project, Forms, and Video
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports and Drill down reports using SSRS.
• Involved in creating data blending in case of merging different sources and in creating a dual-axis bar chart with multiple measures
• Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks).
• Working on generating various dashboards in Power BI using different data sources such as Oracle, Microsoft SQL Server, and Files
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Experience in creating ERD, database schema and performing data modelling in SQL Server database using SQL scripting. Ability to write stored procedures and queries to perform tasks in SQL Server.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Working on generating various dashboards in Tableau using different data sources such as Oracle, Microsoft SQL Server, and Files
• Involved in supporting other Tableau applications which includes creation and cosmetic changes of different charts
• Performed Tableau/Power BI type conversion functions when connected to relational data sources
• Develop, organize, manage, and maintain graph, table, slide, and document templates that will allow for efficient creation of reports
• Involved in supporting other Power BI applications which includes creation and cosmetic changes of different charts
• Created ARM, MOM Document and maintain the root cause analysis & issues tracker sheet and maintain log files, screenshot
• Participating in the daily call status updates to discuss progress, issues, and any new requirements

Environment: SSIS, SSAS, SSRS, Power BI, Azure Cloud Services, Python, Informatica 9.6/10.1, Workflow Manager, Workflow Monitor, Informatica Power Connect/ Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 12c/11g, SQL server 2016/2014, SQL, Micro Strategy, Share point, SVN, Unix, Excel.

Intern

Confidential

Responsibilities:

• Participated in the requirements elicitation and technical specification processes.
• Developed stored procedures, triggers, cursors, views, audit tables in SQL Server.
• Designed Entity-Relationship diagrams and thus the database schema.
• Performed job scheduling in the SQL Server Environment.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
• Developed logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.
• Developed XML tags to structure data and improve the data migration process.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc.
• Used various Control flow tasks like For Loop, execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, and monthly reports.
• Responsible for ongoing maintenance and change management to existing reports and Optimize report performance in SSRS-2008.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts, and processes. Created Linked Servers to connect OLE DB data sources and providers.

Environment: SQL Server 2008/2012 Enterprise Edition, SQL, SSRS, SSIS, MS SharePoint, MS Access, VB.NET, ERWIN, SQL Server Management Studio, Visual Studio.