SUMMARY

• Above 7 years of technical and functional expertise in Application/ Software Maintenance & Production Support.
• Sound knowledge of SQL, ETL and Data Warehousing methodologies and experience in using Microsoft Business Intelligence stack (SSIS, SSAS, SSMS)
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Excellent in High Level Design ofSSISPackages for performing ETL operations on data from heterogeneous data sources by using multiple transformations provided bySSIS
• Experience in deployment and performance tuning of SSIS packages
• Experience in maintenance and Administration ofSSISby creating Jobs, Alerts, SQL Mail Agent and scheduleSSIS Packages.
• Experience in StarandSnow Flake Schemas.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Views, Functions, Data Cleansing, Relational Database models and Data integrity and SQL joins.
• Expertise inPerformance tuning, Optimization, Data integrityandStatisticsby usingSQL Profiler
• Created different Power BI reports utilizing the desktop and the online service and schedule refresh.
• Assist end users with problems installing the Power BI desktop, installing and configuring the Personal and On-Premises gateway, connecting to data sources and adding the different users.
• Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data
• Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.
• Involved inUATand Integration testing withQAteam and good experience in AGILE /SCRUM
• Good knowledge on Python language.
• Ensure proper documentation and on-time delivery of all functional artifacts and deliverables
• Strong customer relationship skills with experience interfacing with customers to refine reporting requirements and build trusted relationships.
• Excellent problem-solving analytical, communication, presentation and interpersonal skills that help me be a core member of any team and passionate about innovation

TECHNICAL SKILLS

Programming: T-SQL, Python

ETL Tools: SSIS

Reporting Tools: SSRS, Power BI

Database Technologies: SQL Server 2014/2016/2017/2019

Version Control: TFS, GIT hub

IDE: Visual Studio 2014/2016, Pycharm, SSMS

PROFESSIONAL EXPERIENCE

Confidential, TX

SQL Developer

Responsibilities:

• Designed and implemented highly distributed, scalable processes - Staging, Data Enrichments and Strong data delivery techniques using Microsoft SQL Server, SSIS and Power BI
• Designed and developed SSIS Packages to load data from various sources like Flat files, Excel, CSV and SQL Server etc.
• Extracted various ad-hoc reports using SSIS packages
• Fine-tuned existing SSIS packages and existing store procedures
• Maintained the existing SSIS packages and SQL jobs
• Performed data research, analysis, conceptual and logical data modeling to solve data issues, validate and document business data artifacts
• Designed dimensional models with conformed dimensions, following the business processes
• Created stored procedures, Views, Triggers and leveraged a variety of other Database Objects to efficiently translate and manipulate healthcare data
• Supported ongoing ETL efforts for Development, QA and Production environments.
• Troubleshoot current processes and maintain business continuity as required
• Effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures.
• Collaborates with business analysts, development teams and project managers for requirements gathering and to resolve requirements gaps uncovered in design or within specifications or requirements
• Prepares technical documentation for platform, service or infrastructure technical components.
• Experienced with code management, change management and deployment controls and processes.

Environment: SQL Server 2016, T-SQL, SQL Server Integration Services (SSIS), SQL Profiler, Excel, SSMS, Visual Studio 2017, Power BI

Confidential, Fort Worth, TX

SQL Developer

Responsibilities:

• Design, build, and support all components of a data warehouse, such as ETL processes, databases and reporting environments
• Develop and automate ETL processes that involve data cleansing, error, reconciliation handling and process monitoring utilizing Microsoft SQL Server Integration Services (SSIS)
• Prepared technical documentation for platform, service or infrastructure technical components
• Design dimensional models with conformed dimensions, following the business processes
• Create stored procedures, Views, cursors and leverage a variety of other Database Objects to efficiently translate and manipulate healthcare data
• Troubleshoot current processes and maintain business continuity as required
• Deployed and scheduled SSIS ETL packages using SQL server job agent
• Develop and maintain business intelligence applications including operational reports, dashboards, scorecards, and ad hoc reporting requests

Environment: SQL Server 2016, T-SQL, SQL Server Integration Services (SSIS), SQL Profiler, Excel, SSMS, Visual Studio 2017, Power BI

Confidential, Westchester, IL

SQL Developer

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Extracted data from various sources like SQL Server 2016, CSV, Microsoft Excel and Text file from Client servers.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Designed and documented the entire Architecture of Power BI POC.
• Implementation and delivery ofMSBIplatform solutions to develop and deploy ETL, analytical cubes on SQL Server usingSSIS,SSAS.
• Monitoring SQL server performance using SQL Profiler to find performance and Deadlocks.
• Involved in design, development, data analysis, identifying and gathering business requirements, user testing and maintenance of BI applications and information systems including database management systems like MS SQL Server.
• Design and developed new Power BI solutions and migrated reports from SSRS to PowerBI
• Created Datamarts for sales team to create Ad-hoc reports using report builder.
• Developed custom calculated measures using DAX for various Fact calculations for efficient data visualization in Power BI.

Environment: MS SQL Server 2016, SSIS, SSRS, SSAS, Visual Studio 2012, Power pivot, T-SQL, Power BI, MS TFS.

SQL Developer

Responsibilities:

• Involved in complete database design including conceptual, logical and physical models.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
• Created SSIS packages for loading the data from Excels files, which get triggered when users upload files
• Deployed and scheduled SSIS ETL packages using SQL server job agent
• Wrotestored proceduresandUser Define Functions (UDFs)to be used in the SSIS packages andSQL scripts.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on maintaining, generating reports and data migration usingSQL Server, SSIS, Power Bi.
• T-SQL development included queries using joins, sub queries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, constraints & database triggers
• Implemented custom error logging and event logging in SSIS

Environment: SQL Server 2012 & 2017, T-SQL, SQL Server Integration Services (SSIS), Visual Studio 2012& 2015, SSMS