SUMMARY

• Over 5 years of experience in database programming, system analysis, design, development & support of MS SQL Server 2008/2012/2014/2016 and 2017
• Very good use of SSRS Report Builder, Power BI Report Builder, Bulk insert (e. t .c)
• More than 3 years of experience in SSRS, Power BI, SQL Server tools SSIS and SSAS
• Expert in writing complex and efficient SQL scripts and store procedures with experience in tuning SQL Server, create SQL Indexes to optimize query performance
• More than One - year experience with Alteryx design and data analytic using Alteryx, design of analytic App and Macro experience with Visual Studio 2015.2017.
• Create workbooks and dashboards for analyzing statistical billing data using Tableau 9.x/10.x
• Good experience on developing and implementing backup and recovery strategies, create SQL Server Login for end user and grant them permission to SQL Server object
• Create and maintained SQL server agent jobs, batch processes and SQL scripts.
• Design and developed complex ETL processes using SSIS 2014/2016.
• Experience in extracting and transforming (ETL process) data using DTS/SSIS Import export data from various sources, Bulk Insert, BCP and SSIS packages.
• Extensive experience in development of reports using SQL Server 2012/2016 reporting Services (SSRS) and Microsoft access database, developed custom report, different types of Tabular reports, matrix reports, drilldown reports and score cards in multiple formats using multi - dimensional objects.
• Used data quality services (DQS) to cleanse the data, remove duplicates and improve the quality. create domains in DQS and exported the activity results into SQL tables.
• Deployment of SSRS reports and power view reports on SharePoint Portal and integrating Reports, analyze reports with SharePoint 2013.

TECHNICAL SKILLS

• T-SQL, SQL 2008, SQL 2012, SQL 2014, SQL 2016, Alteryx Design
• SQL Server Tools Power BI, SSRS, SSIS, SSAS, power View, power Pivot.
• Database Administration, Tuning, SQL Profiler, Clustering, SQL Server Integration Services, Reporting Services, PowerShell, Microsoft office word, Microsoft office Excel, Microsoft Outlook, Microsoft office power point, solid edge,
• T-SQL, PL/SQL.
• Windows XP/Vista/7/8/10. Windows Servers 2008/2008R2/2012R2/2016
• Santana, IIS, .Net Framework, SAP, PeopleSoft, SharePoint and other custom company and vendor applications

PROFESSIONAL EXPERIENCE

Confidential, Grapevine, TX

BI Developer (Team Lead)

Responsibilities:

• Work on require analysis, design and development of modules using Power BI, Tableau, SSIS and SSRS.
• Weekly presentation to the business users about the reports and their changes as required.
• Work on client problem understanding their requirement, building, documentation and translation of the requirements into dashboard solutions.
• Building, publishing customized interactive reports and dashboards, report scheduling using both Power BI and Tableau server.
• Create stored procedures and SQL queries to pull data into power pivot model
• Create action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Develop Tableau visualizations and dashboards using Tableau Desktop.
• Develop Tableau workbooks, Power BI reports and dashboards from multiple data sources using data blending.
• Bulk insert of data to Database
• Develop Unit testing of the modules.
• Design power BI data visualization using cross tabs, maps, scatters plots, pie, bar and density charts.
• Schedule automatic refresh and scheduling refresh in power bi service.
• Write calculated columns, measures query's in power bi desktop to show good data analysis techniques.
• Work on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Work on all types of transformations that are available in Power BI query editor

Environment: SQL Server 2016, SSIS, Tabular, SSRS, Power BI, Power Pivot, Oracle, SharePoint 2013, Windows Server 2012, SQL Server, Tableau10, Windows 8.

Confidential, Fort Worth, TX

Power BI Developer/ Tableau

Responsibilities:

• Meet with business users, gathered business requirements and prepared the documentation for requirement analysis.
• Create centralized data warehouse (ODS) and developed de-normalized structures based on the requirements to improve the query performance for end users.
• Work on building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Create actions, parameters, filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Create ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.
• Create various SSIS packages to populate the data from Oracle and flat files into ODS (SQL Server). Performed full loads for current data and incremental uploads for historical data (transaction base data)
• Work on power pivot models and created calculations using DAX expressions to build various KPIs.
• Develop various types of reports drill down, drill through, matrix and sub reports using SSRS 2016.

Environment: SQL Server 2012, SSRS, Power BI, Power Pivot, Oracle, Report Builder 4.0, TFS, SharePoint 2013, Windows Server 2012, SQL Server, Windows 8.

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• Ensure customers can process transactions and view reports all times of the day by providing 24/7 support of production databases and ensuring databases are constantly up and running efficiently.
• Maintain security on database servers to meet Payment Card Industry (PCI) security stand
• Create SQL Server Login for end user and Grant them permission to SQL Server object
• Tune existing stored procedures, while helping developers create new stored procedures.
• Manage database backup/ recovery plan by ensuring daily backups of the databases and restoration of backups are efficient.
• Perform daily monitoring of stored procedures taking longer than usual to run, and when appropriate, tune procedures or recommend changes to keep system running efficiently.
• Monitor system for poor performing stored procedures; Tune them to ensure efficiency and technical requirements are met.
• Manage weekly process to rebuild or reorganize indexes depending on the amount of fragmentation.
• Check for missing or unused indexes monthly which is needed to keep calls to the database running efficiently without bloating the size of the database with unused
• Upgrade servers with minimal downtime while keeping technology up to date.
• Responsible for testing and deploying service packs, cumulative updates, and the database servers to keep the latest security updates and fixes to bugs on the servers.
• All other database administration tasks as assigned.

Confidential

IT Help Desk Technician

Responsibilities:

• Provide Microsoft Windows Server operating system support including monitoring server performance and availability
• Creating Service account and grant user permissions to various share drives
• Address operational systems issues including file and share permissions, user accounts and installing applications.
• Backing Up and restoring the system state
• Configuring distributed file system (D F S)
• Monitor server load and implement load balancing
• Encrypting Files with EFS to protect confidential data’s
• Configuring and managing group policy setting

Confidential

Installation Supervisor

Responsibilities:

• Provide daily leadership to employees, confer with supply chain planners to forecast parts and tools demand or create supply plans that ensure availability of materials on site
• Schedule and assign duties to employees, assess appropriate material handling equipment needed and staffing levels to load, unload, move, or store materials on site .
• Ensure availability and maintenance of work Tools and equipment, to ensure all equipment’s are always ready for job, and then request for supply when necessary.
• Update the project manager on daily progress and report any discrepancies