OBJECTIVE

• BI Developer /Tableau Developer /ETL Developer/ SQL Developer /Database Analyst

SUMMARY

• Experience with SQL Server 2019/ 2016/2014/2012/2008 , Oracle 19c/11g/10g, Access 2007 database and Data Loading and Reporting tools such as: Power BI Desktop, Tableau Desktop 10.0/9.3, SSAS, SSRS and Crystal Report 2008.
• Strong data management and reporting experience in quantitative analysis.
• Professional experience with most advanced SQL Server 2019/ 2016/2014/2012/2008 Database server installation, login and user creation, role and permission configuration.
• Professional experience with load variety of large volume data files into SQL server /2 database tables, migrate Oracle tables into SQL Server 2016/2014/2012/2008 database tables and generate Report with SSRS, Tableau and Power BI.
• Solid knowledge of data warehousing concepts.
• Explored data in a variety of ways and across multiple visualizations using Power BI.
• Strategic expertise in design of experiments, data collection, analysis and visualization
• Proficient in DAX, SQL and M Code (Power Query)
• Experience in Tableau functionalities for creating different reports, Interactive Dashboards with page and Dashboard prompts using sets, joins, hierarchies, sorting, grouping etc.
• Experience with high performance data integration solutions - Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages for data warehousing.
• Robust MS Access and Excel skills with Pivot tables.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Strong team player with great verbal, written communication and interpersonal skills.
• Proven ability to approach problems effectively, prioritize and complete multiple tasks.
• Expertise in working closely with stakeholders to define problems and design data visualization solutions.
• Good understanding of Azure SQL Database, Azure Data Factory, Azure Data Lake.
• Excellent communication and listening skills.
• Quick learner, take initiative and hard worker. Willing to take on responsibilities.

TECHNICAL SKILLS

Database: SQL Server 2008/2012/2014/2016/2019 , Azure SQL DB, MySQL, SSIS, SSAS, SSRS, Oracle, Access 2007/2010

Reporting: Power BI, Tableau, SSRS, SSAS, Access 2007

Language: SQL, T-SQL, Advanced DAX, Power Query (M), Excel Visual Basic

MS Office: Word, Excel, PowerPoint, Access

PROFESSIONAL EXPERIENCE

Software Engineer

Confidential

Responsibilities:

• Strong experience in creating Ad Hoc, parameterized reports, drilldown and drill through reports using SSRS
• Modify / update SSRS reports based on business requirements (BRD)
• Responsible for deploying SSRS report to QA and Production environment
• Converted batch files to Windows PowerShell to execute SSIS package along with the configuration files
• Troubleshoot issues such as SSIS packages, SSRS reports
• Documents all requirements for implementations and changes
• Using Team Foundation Server (TFS) for managing source code changes

Environment: Oracle 19c, MS SQL Server 2014, TSQL, SQL Server Integration Service 2014, SQL Server Service 2014, SQL Server Management Studio 2015

BI Engineer

Confidential

Responsibilities:

• Understand business requirements in the context of business intelligence (BI) and create data models to transform raw data into useful information.
• Strong experience on Power BI to import data from various sources such as SQL Server, Azure SQL DB, MS Excel etc. to generate reports
• Created Azure Blob storage for import/export data to/from .CSV file
• Developed analysis reports and visualization from customized datasets; using DAX functions like table function, aggregation function and iteration functions.
• Created DAX queries to generated computed columns, computed tables in Power BI
• Using Power BI features such as bookmarks, selection pane, drill down drill-throughs.
• Excellent analytical thinking skills for converting data into visually appealing reports and graphs.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Used Power BI Gateway to keep the dashboards and reports up to date.
• Scheduled Automatic refresh and scheduling refresh in power bi service
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality
• Perform preventive maintenance activities such as causal analysis, restructuring program codes, data problems resolution and performance tuning.
• Strong knowledge in dimensional Star Schema and Snowflakes Schema
• Contributed in the development of knowledge transfer documentation
• Skilled in problem solving such as investigate and solve complex technical problems and data discrepancies.

Environment: MySQL Workbench 8.0 CE, MS SQL Server 2019, T-SQL, Visual Studio 2017, SQL Server Profiler, SQL Server Management Studio, Azure SQL DB, Power BI

BI Developer

Confidential

Responsibilities:

• Designed and development of various dashboards, reports utilizing Tableau Visualizations
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Merged multiple data sources by join multiple tables and used data blending and assigned various extract schedules to optimize the performance
• Created user-friendly and dynamicTableaudashboards with KPIs, Heat Maps, Scatterplots, Bar Charts, Slicers, Drill down, Drill up and other features
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Created groups and users inTableauserver for user authentication.
• Extensive experience in designing, developing and delivering business intelligence solutions using SSIS, SSAS and SSRS
• Strong SQL skills in writing complex Transact SQL (T-SQL) including writing Stored Procedures, Triggers, Views, User Defined Functions and Cursors.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, Teradata and Access to SQL Server or OLAP systems using SSIS
• Developed complex SSRS reports that including Parameterized, Cascading, Drill down, Drill through, Sub reports, Matrix and Dashboard reports
• Developed parameterized/hierarchical reports in SSRS using SSAS as a data source
• Experience in Performance Tuning and Query Optimization
• Good team player with strong analytical skills

BI Developer

Confidential

Responsibilities:

• Migrate MSSQL 2008 database to MSSQL 2012
• Using different logistics databases cross-reference other database with Primary Key, Foreign Key and linking their related knowledge together.
• Retrieve and modify data using SQL Server2008/2012 and BIDS and acquire information from different database.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in deploying and securing reports and administering and troubleshooting report servers
• Experienced in configuring SQL server agent to back up, restore, and automate repetitive tasks.
• Modeled data in support of ETL processing and reporting systems
• Deployed SSIS packages and scheduled job in SQL Server Agent to run the packages automatically.

Data Analyst

Confidential

Responsibilities:

• Created joins and sub-queries for complex queries involving multiple tables.
• Worked with Dynamic SQL, Global Temporary Tables.
• Familiar with single row functions, group functions, set operations, CTE.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Solving day-to-day problems, giving support to the users.
• Wrote system documentation for all projects in my area of responsibility

Data Analyst

Confidential

Responsibilities:

• Created simple and complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Experience in Developing SSAS Cubes and provided access to end users through Excel services.
• Extracted data from diverse data sources such as CSV, Excel and Text file from Client servers and through FTP and loaded to SQL Server
• Used DDL and DML commands for writing triggers, stored procedures, and data manipulation.
• Created Database objects - tables, views, functions and developed procedures for implemented application functionality at the database side for performance improvement.
• Prepared Ad-hoc reports through report builders and published through Report Manager
• Involved in Production Support and troubleshooting data quality and integrity issues
• Report Development using SQL Server, stored procedures and T-SQL scripts
• Pivot Tables and V-look-ups using MS Excel.

Data Analyst

Confidential

Responsibilities:

• Developed Oracle Packages, Procedures, Functions, SQL Scripts and Triggers to implement business requirements
• Extensively used PL/SQL, SQL & UNIX
• Created indexes and implemented query hints to tune SQL queries for optimum results
• Understand business requirements, design and document technical design for the business requirements
• Created the materialized views.
• Supported testing, integration system test, implementation

Program Manager

Confidential

Responsibilities:

• Implement methods for reporting and managing project data and files using Microsoft Excel and Access Databases
• Created graphs for spread sheets and MS Access reports
• Translating cell formulas in Excel into VBA code and using Excel based VBA to design and analyze
• Proficient in all Microsoft applications, Word and PowerPoint, with advanced Excel skills (Pivot Tables, VLOOKUP, Macros)