Senior SQL Developer

• Feb 2022 - Present

Business Intelligence Developer

• Oct 2019 - Feb 2022

● Managed projects end-to-end including project management, data gathering, modeling, analysis, and development. ● Interacted with business users and developers to gather and document the requirements and translate these to technical specifications and create reports and dashboards to fulfill customer requirements. ● Performed data analysis and design for mapping logic between source systems and the enterprise data warehouse. ● Analyzed data in source systems to assess data quality and make recommendations for addressing within the source systems or as part of the ETL process. ● Created interactive Dashboards and Visualizations using Power BI and presented it to the business teams for review and application. ● Maintained and enhanced legacy SSRS reports by adding new functionality and drill down data which helped the client with better decision making. ● Provided production support, troubleshooting and maintenance to database environments and data loads. ● Improved performance of the existing processes and reports. ● Reviewed and documented operational processes and data sources to establish support for reporting requirements. Show less

Sr. SQL Developer, Scrum Master & Project Manager

• Aug 2017 - Oct 2019

● Established the data management framework that improves the data quality and standards for both database structures and the warehouse repository. ● Responsible for Data modeling to visualize database structures. ● Designed and created database tables to store the application’s data. ● Developed queries used for front-end applications (websites, desktop applications, or cloud apps). ● Designed and developed unit test cases for the changes to ensure quality. ● Worked in an agile team and ensuring timely delivery of the database tasks. ● Ensured all database code and scripts meet company and performance requirements. ● Reviewed query performance and optimized code. ● Responsible for Creating indexes to improve database performance. ● Facilitated daily scrum meetings, sprint retrospective, sprint planning and backlog planning. Managed a team of 8 members. ● Improved team performance as measured in velocity and software delivery every 2 weeks. Show less

Sr. Business Intelligence Developer

• Aug 2016 - Jul 2017

● Responsible for analyzing and reviewing Business Requirements and functional specifications. ● Created TSQL scripts for data clean up in the production environment. ● Developed SQL server scripts to get the relevant data. ● Developed Dashboards and reports based on the business requirement. ● Performed Code reviews for Production Deployments. ● Developed T-SQL queries, Store Procedures to build SSIS packages. ● Used SSIS Packages for cleaning up data and transferring data from one internal system to another. ● Involved in testing the data with Business Analysts and testing team. ● Worked on Performance tuning, query optimization and execution plan of queries for better performance. ● Experience in setting up automated processes using SQL Server Agent. ● Configured, designed, and built visualizations and dashboards using Tableau. Show less

Sr. MS SQL Server BI Developer

• Oct 2014 - May 2016

● Performed data mapping and transferred data from staging tables to data warehouse tables using SSIS packages. ● Designed, developed, optimized, maintained, and supported ETL processes using Stored Procedures and Microsoft SSIS. ● Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary. ● Validated that the Data Integration design and technical specifications are complete, consistent, concise, and achievable. ● Produced DI solutions meeting 100 percent of technical specifications and business requirements according to the established designs. ● Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions. ● Participated in DI design reviews. ● Conducted DI unit tests and code reviews. ● Participated in system and integration tests; identifies and remedies solution defects. Show less

MS SQL Server Developer

• Oct 2012 - Oct 2014

● Responsible for requirement gathering, design, development, maintenance and enhancement of applications/portals and databases that are used by clinicians and generate reports for various quality initiative programs. ● Used SSIS Packages to extract, transform and load data from multiple input sources like Excel files, Production SQL Servers into SQL Server Staging Database. ● Performed data mapping and transferred data from staging tables to data warehouse tables using SSIS packages. ● Used Team Foundation Server to check in and check out SQL server objects such as T SQL scripts, SSRS reports ● Responsible for Creating Technical Specification documents and Process Flow documents. ● Tested medical related data management systems to improve the workflow of clinical end users. ● Designed, developed, tested, and evaluated clinical, operational, and administrative dashboards as well as KPI metrics for the department. ● Hands-on experience with the ETL process. Show less

SQL Server Developer/Data Analyst

• Jan 2011 - Aug 2012

Roles and Responsibilities: Participated in the complete SDLC of the project ( Analysis, Design, Development, Test and Implementation) Designed and administered databases in a MS SQL Server environment. Implemented the ETL processes to generate a data warehouse from operational databases. Evaluated test result logs to identify performance issues. Computed monthly, quarterly and annual usage patterns reports to help make better decisions. Created development strategies utilizing tools: Microsoft Access. Assessed project requirements and the development of project timelines and milestones. Ensured user satisfaction and support of projects through on-going communication and verification. Prepared reports that required the highest level of accountability due to the financial or legal repercussions. Participated in joint application development teams and conducted user training and collected user feedback.; MS SQL Server 2008R2, Data Transformation Services (DTS), MS Access Show less

System Engineer

• Aug 2010 - Nov 2010

Roles and Responsibilities: Extensively involved in design, development, coding, testing, and implementation of the allocated modules. Generated QC reports by validating various relational databases. Designed and developed reusable data processes. Optimized and tuned BI load processes. Roles and Responsibilities: Extensively involved in design, development, coding, testing, and implementation of the allocated modules. Generated QC reports by validating various relational databases. Designed and developed reusable data processes. Optimized and tuned BI load processes.