SUMMARY

• Hands on Experience in optimizing the queries by creating various clustered, non - clustered indexes and indexed views.
• Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2012-2016.
• Strong analytical knowledge coupled with excellent communication and interpersonal skills. Proficient in developing clear and concise documentation of all work performed.
• Worked well independently and on a team to solve problems.
• Served as a friendly, hardworking, and punctual employee. Organized and prioritized work to complete assignments in a timely, efficient manner.
• Responded to problems with excellent troubleshooting abilities. Consistently exhibited loyalty and passion for success. Helped the Business Analysis team in preparing documentation such as data mapping files and data analysis forms.
• Excellent knowledge in creating databases, tables, writing complex T-SQL codes, Stored Procedures, Functions, Indexes (clustered, non-clustered, column stored), CTE's, Views, Joins and DDL/DML Triggers
• Expert in Performance Tuning/query optimization and troubleshooting of complex T-SQL Stored Procedure and slow running queries.
• Excellent understanding of design goals of ER Modeling for OLTP and dimensional modeling for OLAP and Data Warehouse Systems
• Knowledge in developing visual reports, dashboards and KPI’s (ADR, REVPAR, AAR, OCC, LOS, ARI etc.) by using both Power BI desktop and Power BI Services platforms and in uploading them into Report Server and Cloud Services with establishing necessary row level security settings. Hands on experience in writing complex DAX for tabular cubes and MDX queries for Multidimensional cubes in Power BI desktop
• Applied row level securities in all Power BI reports and assigned Active Directory AAD Groups, scheduled and monitored data sources to be refreshed accordingly, Row Level Security RLS data security techniques.
• Experience in both on-prem and cloud solutions. Extensive experience with Microsoft Azure ecosystem such as: Power Bi Service, ADF2, Azure SQL Server, Azure SQL IAAS/SAAS/PAAS, Azure SQL DW, Azure Blob, Datal Lakes, Azure Synapse, Databricks, Azure Analysis, AKV Management.
• Hands-on AWS cloud solutions such as AWS RDS SQL server, MySQL, Amazon Redshift, AWS EC2, AWS S3 buckets, etc.
• Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Breakpoints, Checkpoints, and Logging for Complex SSIS Packages
• Experience in various kinds of SSIS Deployments like File Based Deployment, and SQL Server Deployment
• Solid understanding in maintenance and administration of SSIS packages by creating SQL Agent Jobs, Alerts, Mail Notifications, and schedule DTS/SSIS Packages by SQL Agent, Windows Scheduler, and other third-party tools.
• Experience with Lift & Shift of SSIS packages into Microsoft Azure using Azure Data Factory (ADF2) to create ADF pipelines with Copy Data and Data Flow Activities. Hands-on experience with ADF linked services, Integration Runtime, Tumbling Window Triggers and debugging ELTs using ADF Monitors.
• Strong skills on deploy and operate large scale cloud infrastructure and application services in global data centers on Amazon Web Services (AWS), Microsoft Azure and other Cloud providers.
• Hands on experience in designing and creating Star and Snowflake Schemas for Data Warehouse systems for various data domains such as healthcare/finance/hr/acouting/manufacturing/ecommerce/supply-chain.

TECHNICAL SKILLS

OS: Windows XP/7/10, Windows Server 2019/16/12, UNIX/LINUX

Databases: SQL Server, Oracle, MySQL, DB2, Azure SQL PAAS, Azure SQL VM, AWS RDS

Languages: T-SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, MYSQL, HTML, ASP.NET, .NET Framework, C, C++, JavaScript, Power Shell, Python, Scala SQL

ETL & Reporting: SQL Server Integration Services (SSIS), Azure Data Factory (ADF v2), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), Domo, Cognos, Crystal Reports, Tableau

Others: MS Office, Visio, Service Oriented Architecture (SOA), SQL Server Notification Services, Visual web developer, MS FrontPage, Erwin Data Modeler, MS Visual, SAS/Access, Tableau, Crystal Reports SAP Business Objects, Crystal Reports XI, DataStage, Informatica, Hadoop, Windows Scripting Host, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, Synergy, HP Quality Center & Jira

PROFESSIONAL EXPERIENCE

Senior BI Engineer

Confidential

Responsibilities:

• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database. Converted various SQL statements into Stored Procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time).
• Performed tune to optimize SQL queries using SQL profiler and query analyzer. Involved in performance tuning of the database and T-SQL queries using Explain Plan. Created Indexes, Constraints and Rules on database objects.
• Created and modified Clustered and Non-Clustered Indexes to optimize the queries using Index Tuning Wizard. Designed and developed MS SQL Server Stored Procedures using T-SQL statements from scratch. Developed Triggers on Views to populate base tables.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Created Jobs that called Stored Procedure that automatically populated tables with Proc Date column. This allowed us to use Merge Replication when we needed to transfer data to History Database.
• Create stored procedures and user defines functions to supports efficient data storage and manipulation. Handling database objects with Enterprise Manager. Provided Technical Documentation for future enhancements.
• Gathered, analyzed, and documented the business requirements and business rules by directly working with end users/clients. Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan.
• Responsible for installations and configurations of Operation Systems and Servers which connects workers on the overseas country.
• Created database applications utilizing multitier ideas with the utilization of SQL statement and Store Procedure to fetch, update, and control databases on SQL Server 2012 and Oracle 11g.
• In-depth knowledge in Normalization /De-normalization and database design methodology, SQL query performance tuning through creating or modifying clustered and non-clustered indexes, setting transaction isolation levels as well as changing complex query structures.
• Expert at checking, rebuilding, and reorganizing internal and external fragmentation in SQL.
• Structured and created plenty of SSIS packages using Data Flow Task, Execute SQL Task, Script Task for ETL projects.
• Designed several For Loop containers, Foreach Loop, and Sequence containers in SSIS.
• Profound knowledge in understanding ERDs and Database Models.
• Skilled in using Synchronous (Data Conversion and Derived Column, Multicast, Row count, etc.) and Asynchronous transformation (including Sort, Fuzzy Lookup, etc.) to perform various transformations to SSIS package.
• Utilized complex UDF, Store Procedure, Views, and Triggers for solving different business requirements.
• Used DML triggers (such as after/instead of Update, Delete, and Insert) to maintain the referential integrity of data.
• Assisted Data Architects in building data warehouse entities like fact tables, dimensions that are involved in Snowflake Schemas.
• Used Breakpoint and Checkpoints to debug/troubleshoot the package while loading into the data warehouse.
• Performed continuously incremental loads to load data OLTP environment to OLAP environment.
• Built many OLAP cubes in SSAS.
• Created perspectives for Finance, Operational Management, Accounting, Sales departments using OLAP cubes.
• Wrote complex DAX queries in SSAS to generate computed columns according to business requirements before pushing it to GitHub.
• Deployed many SSIS packages into the SSIS catalog. Scheduled several jobs to run SSIS packages into the SSIS catalog.
• Experience in both on-prem and cloud solutions. Extensive experience with Microsoft Azure ecosystem such as: Power Bi Service, ADF2, Azure SQL Server, Azure SQL IAAS/SAAS/PAAS, Azure SQL DW, Azure Blob, Datal Lakes, Azure Synapse, Databricks, Azure Analysis, Cosmos DB, Poly-Base, AKV Management
• Also, hands-on experience with AWS cloud solutions such as AWS RDS SQL server, MySQL, Amazon Redshift, AWS EC2, AWS S3 buckets.
• Created Azure Data Factory (ADF v2) ELT structure dataflow pipelines utilizing Copy data, Data Flows, Databricks, Scheduled / Tumbling Window and Event based triggers, linked servers, Azure Key Vaults
• Worked with all departments such as management, hiring, accounting, dispatching, maintenance, and safety teams to implement row-level security and policies.
• Hands-on experience in creating summary reports and ad-hoc reports using SQL Server Reporting Services.
• Created reports using Power BI Desktop and deployed to Power BI Service to share with end users via Workspaces and Apps which implemented Row Level Security and User Group management.
• Deployed a lot of custom PowerBI, SSRS and Tableau reports, parameterized reports, drill down and drill through reports, as well as, created numerous subscriptions for Management.

Senior SQL BI Developer/SSRS/SSIS

Confidential

Responsibilities:

• Communicated Data team project status information to team members and analyst team to understand / analyze the requirements of business need and achieved the successful results.
• Developed complex T-SQL Stored Procedures, UDFs, CTEs, Indexed Views, and Staging Tables to process the data and populate them into the appropriate destination tables.
• Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to Compliance Group, Order Flow management (OFO) Group, Network Planning Group, TN Management Group etc.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Optimized queries, improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures, and performing other maintenance tasks. Tuned and improved application by finding optimal solutions for slow running queries and procedures using SQL profiler and performance monitor.
• Created SSIS Packages using such tasks on control flow as Execute SQL task, Execute Package Task, Bulk Insert task etc. On Data flow level extracted data from different sources like ODBC, OLE DB, Excel, Flat file, XML File and etc. Used transformations as Aggregate, Derived Columns, Condition Split, Merge, Union all and etc. to generate data for the reports and to export cleaned data to data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Designed a Datawarehouse Star and Snowflake schemas. Maintained different dimensions and facts.
• Extensively created, worked, managed OLAP cubes using SSAS and in adding calculations using MDX.
• Created Incremental Load ETL packages using Look up transformation, Merge statement, CDC Control task etc. Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1/ type 2 changes;
• Created dynamic SSIS Packages to transfer data between servers, load data into database and tuned the existing packages. Worked on Error handling by using checkpoints, configure error outputs and president constraints and event handlers.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server. Integrated ASP.Net pages with SQL server Database. Designing and building data load procedures using MS SQL Server.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects. Documented all the procedures and processes for future references.

Network Administrator

Confidential

Responsibilities:

• Performed all essential operations and engineering team support functions including hardware/software configuration, testing, network/PC configuration, networking, troubleshooting, database administration/maintenance, and data analysis, research, and development.
• Successfully maintained connectivity between host systems, including native operating system protocols, TCP/IP, IPX/SPX, NETBIOS, and peripheral sharing devices using NFS.
• Directed electrician to install network cabling to industry standards during renovation project.
• Successfully maintained Windows 7 domains, permissions, and file structures for 500 users.
• Performed Windows 7 and 2008 server builds for hardware and OS installation.
• Performed daily monitoring, maintenance, and backup of Windows 7 domain.
• Installed WatchGuard firewalls and managed rule set with VPN using Radius authentication.
• Completed server and PC hardware assemblies.
• Performed audio video cabling and hardware installations both interior and exterior work including, ceiling mounts of projectors, screens, smartboards, cameras, speakers, televisions, etc.