SUMMARY

• Over 9 years of experience in database (both OLTP and Data Warehouse area) development, administration, Business Intelligence work using Microsoft SQL Server 2012/2014/2016.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Solid skills in using tools like index Tuning Wizard, SQL Profiler, Extended Events and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experienced in MS SQL Server 2012/2014/2016/2017/2019 and solid hands-on experience in installing, configuring, managing, monitoring, and troubleshooting SQL Server in various environments, like Dev, Testing, QA, and Production environments.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using Microsoft SQL Server Reporting Services 2014/2016 (SSRS).
• In-depth knowledge of complex Transact-SQL. Power user of advanced SQL queries with multi-table joins, group functions, sub-queries, set operations and functions.
• Proficiency in System Life Cycle including developing and testing the applications.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2016.
• Experience using DAX to create aggregate measures and complex formulas in PowerBI.
• Exposure to PowerQuery (M) to load and transform data into required models.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in Microsoft SQL Server Integration Services (SSIS); experience using SSIS custom logging, SSIS event handlers and data encryption.
• Efficient team member with excellent work/time management skills, excellent leadership, communications and Interpersonal Skills, ability to work under strict deadlines.
• Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

TECHNICAL SKILLS

LANGUAGE: SQL, T-SQL, PostgreSQL, MySQL, Python, PL/SQL

DATABASE: Microsoft SQL Server 2008R 2/2012/2014/2016 , POSTGRE SQL

DEVELOPMENT: Microsoft Visual Studio 2012/2013/2015 , SSMS, DBeaver, Hive, Agile/Scrum, Jira, Git, Jenkins, Azure

SQL Server Tools: SSRS / SSAS / SSIS

Reporting Tools: Microsoft SSRS, Crystal Report 2012, MS Access, POWERBI, Tableau

Operation System: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL Server Developer

Responsibilities:

• Worked in Data warehouse ETL & BI platforms and had a good understanding of related development activities and challenges.
• Worked with team leads to prioritize business and information needs and translating business requirements to project design, development, and execution.
• Developed complex code data scripts (Primarily PostgreSQL) for ETL and also writing JSON files.
• Developed and implemented complex PostgreSQL and ETL process to realize loading data from different source systems into the data mart in PostgreSQL Server.
• Developed and implemented complex PostgreSQL script that improved high volume database performance by automating a process that re-indexed newly created table partition on daily basis.
• Analyzed complex SQL joins and stored procedures to find out the base table where are duplicate records from and deduping the code, removing duplicate records in the tables.
• Assisted in development of software technical documentation.
• Adapted at queries, report writing and presenting findings Expertise in Data Analysis, Data Profiling, and SQL Tuning.
• Troubleshooted & determined best resolution for data issues and anomalies Manage exploratory data analysis to support database and dashboard development, as well as advanced analytics efforts.
• Read logging files, debugging the code, deploying the code and run the job in various environments.
• Experienced Transferring data from various data sources including MS Excel, Flat Files, Oracle etc. to SQL Server using SSIS various features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion.
• Experienced implementing Power BI reports that combine multiple data sets and provide insight across them.
• Experienced developing solutions in connecting different types of data sources: MS Excel, CSV, SQL Server, Oracle, etc.
• Developed visual reports, dashboards and KPI scorecards using Power BI desktop.
• Connected Power BI to different data sources, import data and transform data for Business Intelligence.
• Utilized Transact-SQL to source information as well as PowerQuery (M) and DAX in POWER BI to transform various data sets into enterprise models and application specific solutions.
• Worked primarily within Power BI Azure Cloud, maintain connections to on-premises as well as databases in AWS, Salesforce and other Cloud environments.
• Validated data between various database, like PostgreSQL, MySQL and analyzed the issue to find the root cause of unmatched and fix the code.
• Clearly communicated capabilities, opportunities, and recommendations to both technical and nontechnical audiences.
• Used git command to update the modification of code to repo in TFS.
• Interpreted and analyzed data from various source systems to support data integration using SSIS and data reporting using Power BI.
• Identified, analyzed, and interpreted trends or patterns in complex data sets.
• Collected, organized, analyzed, and disseminated significant amounts of information with attention to detail and accuracy.
• Prepared high-level ETL mapping specifications in Entity relationship model(ER) for data integration and reporting.

Confidential, Charlotte, NC

Senior Microsoft SQL and SSIS Developer

Responsibilities:

• Developed and maintained data integration infrastructure with SSIS. Optimizing company ETL framework and operational reporting platform including data warehouse environment.
• Created data conversion business solutions and data cleansing processes using SSIS and T-SQL stored procedures, views, tables and schemas.
• Provided production database support and maintenance plan management and automation. Designing new database objects as required by the business for deliverables.
• Designed ETL for SQL auditing compliance requirements. Standardized package deployments and configuration files for production environments.
• Performed daily package monitoring and modifications, query tuning, and database health archiving using T-SQL stored procedures
• Implemented BI framework for quality assurance, archiving of files and logging the data migration SSIS jobs and ETL performance.
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve slowing running queries.
• Worked closely and providing guidance to other SQL developers, code reviewing, and support the development team by promoting established standards, processes, procedure and tools throughout the software development life cycle.
• Provided expertise in T-SQL to the software development team, including writing complex stored procedures, views and triggers.
• Performed production SQL deployments including rollback preparation and testing. Ensure all database environments are in sync and keep tracks of database versions for all environments.
• SQL Server Reporting Service development and administration. Develop, implement and monitor the overnight SSIS ETL process for reporting data mart as source schemas change.
• Developed table partitioning as an optimization solution for purging and retaining data in an agile/scrum environment.
• Engaged in the project to design and modified the healthcare online application with the SQL Server as back-end database.

Confidential, Columbus, OH

Senior Microsoft SQL Developer

Responsibilities:

• Collaborated with information architects, designers and other developers in scrum-based development through our use of Agile development methodologies.
• Involved in Gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target Data Warehouse.
• Configured SSRS instance for reconciliation reporting efforts and database monitoring reports.
• Created very complicated tabular, list, matrix, charts, drill-down and drill-through/linked reports and parameterized SSRS reports.
• Provided application development support and SSIS debugging solutions for database administrator and line of business.
• Creation of more than 180 custom reports and 600 stored procedure.
• Designed technical documentation, relational diagram (ERD) of residuals and participations application.
• Data analysis and design for an electronic submission system and the import of applications from the web to MS SQL server.
• Optimized the existing SSIS frameworks for the data imports and exports per department request system and sharing documents with the offshore team members on SharePoint.
• Analyzed the existing star schema database and built a priority matrix to be implemented in order to optimize database reporting and user queries.
• Daily support, troubleshooting, monitoring, optimization and tuning of SQL Server Jobs, Package and SQL Server environment across entire system.
• Daily data analysis and bug fixing in staging, development and production MS SQL Server.

Confidential, Southlake, TX

Microsoft SQL Developer

Responsibilities:

• Planned, built, and supported table partitioning (data purge) process using complex T-SQL code for high volume databases.
• Improved SQL Server and application performance by coding multipart T-SQL script that modified table, purged millions of records in batches, and then restored table schema to its original state.
• Developed a nightly database maintenance plan to backup all MS SQL Server database objects.
• Designed and developed automated ETL process and reporting platform using SSIS and SSRS. Implemented data loading, calling of third party tools from within SSIS package, and weekly file extracts for broadcasting.
• Coded T-SQL stored procedures for SSRS reports and deployed the reports for account managers to access via web browser.
• Optimized MS SQL Server 2008 database for reporting queries using Database Engine Tuning Advisor.
• Design of daily workflow databases, automation of manual tasks using SQL Server and Oracle 11g database. Ad-hoc request, updating policy and procedures.
• Documented MS SQL Server Best Practice reference notes for filed engineers and the offshore team.