SUMMARY

• Overall 7 years of IT Experience in developing BI applications using SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000 in Development, Data warehouse, Test and Production Environments on various business domains.
• Expertise knowledge in Data modeling - both normalized for OLTP and de-normalized for OLAP
• T-SQL development skills in Objects creation such as Tables and Views, User Defined functions, Indexes, Stored Procedures, CTE, Cursors and Triggers using SQL Server 2008R 2/2012/2014.
• Expertise in writing T-SQL Stored procedures, Triggers, Constraints, Temp tables, Temp Variables, Encryption, Decryption, Views (Schema Binding) and Indexes using various DDL and DML commands.
• Developed and involved in creating facts, dimensions, and Star Schema representation for the data mart.
• Strongly experienced in Database Installation, Database Backup, Restoration, Linked Servers and Database Maintenance Planning.
• Experienced in Upgrade/Migration of MS SQL Server 2008 to MS SQL Server 2008R2, from SQL Server 2012 and SQL Server 2014.
• Experienced in Backup and Recovery, Query Optimization and Security.
• Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third-party solutions.
• Experienced in securing SQL Server, user management, assigning permissions and roles.
• Experienced in checking high availability and/or disaster recovery process logs.
• Experienced in designing native scripts using T-SQL to monitor Replication, Mirroring, Log shipping.
• Experienced in monitoring log shipping and mirroring using the customized stored procs.
• Experienced in checking both SQL Server logs and Windows logs. If you find any strange issues notify the network or storage teams. Most of the times we find Network related or I/O related issues.
• Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, and Heat Map.
• Experience in project management methodologies such as Waterfall, Iterative, and Agile - Scrum.
• Involved in tracking project progress, prioritizing workstreams and supporting strategic workstreams related to strategy, business development, and/or corporate initiatives.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting, and organizational skills.

TECHNICAL SKILLS

Databases: SQL, PL/SQL, T-SQL, SQL Server 2019/ 2017/2016/2014/2012/2008 R 2/2008/2005/2000 , MY SQL, DB2, SQLite, MS Access

Data Warehousing & BI: SQL Server, SQL Server DTS, BIDS, SSIS, SSRS, SSAS

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, Index Tuning Wizard, SQL server mail service, DBCC, SQL server profiler, Power Query, Power Pivot

Reporting Tools: SQL Server Reporting Service (SSRS) 2014/2008 R2, Power BI Desktop/Service/Report Server

Version Tools: Git, Source Tree, Visual Source Safe, Team Foundation Server, SVN, Smart CVS 7.1

Other Tools: MS Office Suite (Microsoft Excel, Word, Power Point, MS Visio)

Operating Systems: Windows NT/98/2000/XP/Vista/8.1/10, MS-DOS, Linux

PROFESSIONAL EXPERIENCE

Power BI Developer

Confidential | Redmond, WA

Responsibilities:

• Generated periodic reports based on the statistical analysis of the data from various time frame and division using power pivot, power query, power view.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.
• Gathering the requirements and writing the ad-hoc SQL query batches to update the data and metadata for delta and history loads.
• Utilized ( Power BI, Pivot/View ) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created data marts and multi-dimensional models like Star schema and Snowflake schema.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI .
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis.
• Extensive use of DAX (Data Analysis Expressions) functions for the reports and for the tabular models.
• Designed/Developed table driven ETL process with Perl and shell scripts, which in turn calls OWB mappings, Informatica oracle code to load EDW .
• 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.
• Experience in custom visuals and groups creation in Power BI .
• Experience in scheduling refresh of Power BI reports, hourly and on-demand.
• Apply the Business rules on the data coming from multiple operating companies. Maintain the business rules in a table for visibility to all required processes to develop Power BI reports & effective dashboards.
• Load the processed data into final view point centralized DWH for further Power BI reporting.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Working experience with column store indexes, table partitioning in SQL SERVER 2012.
• Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of event handlers, loggings, checkpoints, transactions and package configurations.
• Implementation and delivery of BI platform solutions to develop and deploy ETL, analytical, reporting and scorecard\dash boarding on SQL Server 2012 using SSAS, SSIS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes. Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration. Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work. Migrated existing self-service reports and adhoc reports to Power BI.
• Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Performed Database Refresh tasks from production to Development and Staging Servers Documenting Business requirements and requirements tracking.
• Document Business Scenarios and testing Objectives.

Environment: MS SQL Server 2008R2, T-SQL, SQL Profiler, Visual Studio (2012), Power Bi Desktop, Team Foundation Server (2012), MS Analysis Services 2005, MS Reporting Services, MS Access, Import & Export Data, Oracle Warehouse Builder, Power Bi Desktop, Power Bi pro, Source Control Management System Windows XP, Index

Business Intelligence Developer

Confidential

Responsibilities:

• Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript.
• Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Build GSHS Reports in Power BI from scratch.
• Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
• Developed various dashboards to know the school climate, school safety, risk factors, and risk behaviors.
• Created dashboard for school system financial information which includes revenue and expenditure by district.
• Developed custom Georgia district map visual, the SVG is written inline within a Bootstrap 2 container.
• Written some Java script plugin that makes the polygons work like hyperlinks.
• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI .
• Used various sources to pull data into Power BI such as SQL Server, oracle.
• Experience in providing Logging, Error handling by using Event Handler and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service
• Generated custom and parameterized reports using SSRS. Created various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI. Knowledge of publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets. Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Created basic reports using Confidential files as source to fetch the data in Power BI. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Environment: MS SQL Server 2012/2008, Visual Studio 2008, Oracle, MS SQL Server Management Studio SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Pig, Azure, SQL Profiler, T-SQL, Power Bi Desktop, Data Warehousing, Data Transformation Services (DTS).

SQL Developer

Confidential

Responsibilities:

• Extensive experience in Analysis, Design, Development, and support of various applications using SQL Server.
• Use of agile SDLC approach to complete and track tasks on time.
• Designed the Databases, Tables, Views, Stored Procedures and Triggers.
• Created User Defined Functions, Views, and stored procedures as per business requirements.
• Optimized the performance of queries with simplifying queries like removing unnecessary columns, eliminated redundant and inconsistence data.
• Create ETL packages to move data from feed files (XML, CSV, and TXT) to database.
• Create packages to migrate data from oracle to SQL server, Teradata to SQL server.
• Create packages to migrate data from Hadoop to SQL server using Hive SQL.
• Created SSIS packages to load data into staging table and data mart and Performed logging in SSIS packages to capture error data and for error handling.
• Proficient in Creating, Configuring ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL Server.
• Maintaining the Log and Audit information in SQL tables, experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages
• Generated different SSIS packages using transformations such as fuzzy lookup, derived column and slowly changing Dimensions (SCD) to perform different business requirements.
• Designed and developed dynamic SSIS packages to process dynamic queries and dynamically produce flat files at runtime.
• Designed and developed dynamic SSIS packages to process dynamic queries and dynamically produce and Update Excel files at runtime.
• Migrated data to transfer database objects among servers using different SSIS packages in Visual Studio.
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Tuned several slow running queries in Production. Implemented Indexes to achieve time performance
• Created SSIS packages to integrate data from text files and excel files and file Transfer from one location to the other using FTP tasks.
• Performed Normalization and De-Normalization techniques from both OLTP and OLAP system in creating Database objects.
• Used control flow tasks like for Loop Container, for each Loop Container, Sequential Container, Execute Tasks, Email task and different Data Flow Tasks.
• Worked on Transforming and Loading data using SSIS Import/Export wizard.
• Providing inputs on the creation of User Stories to the Scrum Master like giving the estimates.
• Completing the committed user stories in a sprint and develop the list of tasks based on the User Story.
• Attending daily scrum calls and other scrum meetings like Sprint plan, retrospective.

Environment: SQL Server 2019/2017/2016 , MSBI Suite (SSIS/SSRS/SSAS) 2017/2016/2012/2008/2005 , T-SQL, Query Analyzer, SQL Profiler, Query Optimizer, Performance Tuning, Power Query, Power Pivot, Agile Scrum, ServiceNow, C#, Visual Studio 2019/2017/2015.