SUMMARY

• Over 9+ Years of extensive experience in SQL Server Development, Design, administrate (2019,2017, 2016, 2014, 2012, 2008R2, 2005) including writing T - SQL Programming, Data Warehouse Design.
• Expertise in Power BI, Power BI Pro, Power BI Mobile
• Strong experience in Azure Cloud platforms
• Experience on Migrating SQL database to Azure data Lake, Azure data lake Analytics,Azure SQL Database, Data Bricks and Azure SQL Data warehouse
• Database migrations from on premise to Microsoft Azure cloud
• Experienced in Design and implementing end to end Data Warehouse Models.
• SQL Server backup/restore, high availability i.e mirroring, replication and Log shipping.
• Conventional cluster, AlwaysOn (Starting 2012) setup for SQL Server
• Saved huge costs for the client by recommending Standard Edition database for few non 24/7 applications where Enterprise was not required.
• Independently develop DM documents including but not limited to DMPs, CRFs, CRF Completion Guidelines, Edit Checks, UAT specifications, centralized monitoring plans, data flow and integrity plans, blinding plans, and data review plans
• Independently lead data cleaning activities such as but not limited to Study Team data reviews, Non-system Edit Check Output review, SAE reconciliation, and non-CRF data reconciliation.
• Develop/build, document and perform validation of database structure, data capture screens, code lists, edit checks, reports and other functions in EDC (e.g. User Acceptance Testing)
• Write and review DM SOPs in accordance with GCP and ICH guidelines, and develop associated training and competency testing
• Maintain CRFs database standards
• Work in conjunction with Clinical Operations, Clinical Research, and other operations to ensure accurate, efficient, and complete data collection
• Experienced in creating Databases, Tables, Stored Procedure, DDL/DML, Triggers, Views, User defined data types, Cursors, Indexes, Derived Tables and Common Table Expressions (CTEs) using T-SQL programming to facilitate efficient data manipulation and data consistency.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Primary Keys and Foreign Keys.
• Expertise in Creating, Deploying and managing SSIS package.
• Monitored and Optimized SSIS package performance to reach the expected time frame for data loading.
• Used SSIS for Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Expertise in Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS).
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Developed Standard Reports, Sub Reports, Cross Tab Reports, Used various Charts and graphs like Bar Chart and Line graphs in SSRS.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Experience in Advanced Excel and its features like Pivot Tables, Charts, Functions, etc.
• Used MS Excel/Access VBA SQL to send system generated e-mails, manage and report embedded Excel documents.
• Created Dashboard in MS Excel.
• Expertise in enhancing an existing Excel application consisting of several VBA programs and macros.
• Experienced in developing macros for data automation.
• Experience with Excel VBA/Macros, MS Access and SQL queries to make reports in different styles and then distributed them as PowerPoint slides to various level of management.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and Dimension modeling for OLAP.
• Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high-pressure environment.
• Expert in Query Optimization and tuning the query, creating Indexes to improve the query performance.
• Expert in writing T-SQL, working on SSIS, SSRS, SSAS, and Data Migration projects.
• Expertise in Data Extraction, Transforming and Loading (ETL) between different Systems using SQL tools (SSIS, DTS, Bulk Insert, and BCP)
• Experience with API based transaction and bulk integrations with cloud based platforms
• Converted HL7 V.2 messages to Xml format to facilitate proper mapping onto the CCDA document templates.
• Has experience incorporating API’s into data reporting experience.
• Ensured consistency in assessing, coding and recording of healthcare events by coordinating with clinical project team
• Design and develop new source system integrations from a variety of formats including files, database extracts and APIs.
• Good knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experience in SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Experience in database Designing/Modeling of new applications and database changes to existing applications.
• Upgraded the existing environments from SQL Server 2005 to 2008.
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.
• Extensive experience in developing, enhancing and maintaining web application.
• Participated in all phases of SDLC starting from Analysis to Delivery of the application development projects and supported enhancements and maintenance of existing applications.
• Good analytical and programming skills in C#, ASP, ASP.NET, VB Script and Java Script.
• Cloud Services (IaaS, PaaS and SaaS).
• Experience on working in Production Support team and providing support on 24x7 bases.
• Excellent analytical, high level and low-level design and problem-solving skills.
• Hands on experience in project management tools like Team Foundation Server (TFS), Clear case and VSS.
• Research-oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills.

TECHNICAL SKILLS

Relational Databases: MS SQL Server 2019,2017,2016,2014,2012, 2008R2,2008, 2005, Oracle 8i/9i/10g, Azure Data lake, Data factory, Azure Databricks, Azure SQL database, Azure SQL Datawarehouse

Tools: and Packages: SQL Server Management studio, MySQL, Enterprise Manager, Profiler, SSIS, SSRS, Microsoft Visual Source Safe, Visual Studio .Net. Cloud Services (IaaS, PaaS and SaaS). VERITAS, Quest Lite Speed, Red Gate, Erwin, Tivoli, SCOM, ESM, RSAM, Guardium

Languages: T-SQL, PL/SQL, C, C#, ASP.Net

Web Technologies: HTML, XML, XSL, IIS (4.0/5.0/6/0)

BI Tools: SQL Server Integration Services(SSIS), SQL Server Reporting Tools (SSRS), Crystal Reports, Power BI, Tableau

Configuration Management Tools: Visual Source Safe, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential - Miami Gardens, FL

Sr. Data Engineer

Responsibilities:

• Involved in analysis, design, development and enhancement of the application that applies business rules on the data on weekly basis.
• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in InAzure Databricks.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Running packages deployed into the SSIS catalog SSISDB hosted by an Azure SQL Database server or a managed instance Project Deployment Model.
• Responsible for creating SSIS packages to extract data from different sources (Excel, Flat File, HDFC File, ODBC, OLEDB, Salesforce, and SAP BW) consolidate and merge into one single source.
• Worked closely with the team to determine the preferred solutions and assist in the accomplishment of designated objectives to include routing and reporting design, configuration, scripting and testing/validation.
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.
• Responsible for loading monthly membership data from different payers to UAT and Production.
• DevelopedPowerBImodel used for financial reporting of P & L and Headcount.
• Expertise in writing complex DAX functions inPower BI and Power Pivot
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Designed and documented the entire Architecture of Power bi Poc
• Consuming Data from Data Lake and loading into the required tables on time. So that pcp’s can use the patient data as required.
• Developed macros for accounting and financial purpose.
• Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, Billing report and other file transfer reports
• Installed, Configured, Managed and Monitored SQL Server 2008R 2/2012/2014/2016.
• Extensive use of joins and sub queries to simplify complex queries involving multiple tables.
• Creating Indexes and use Scan and Seeks for performance tuning.
• Design and create data marts, databases, indexes, views, aggregations, stored procedures, partitions, calculated measures and data integrity.
• Responsible for Scheduling reports to run daily, weekly and monthly basis using Report Manager.
• Create Jobs, Alerts, Activity logs, Error logs to capture any possible errors usingSQL server Agent.
• Create Backend validations using Insert/ Update and Delete triggers.
• Configure SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Develop and deploy SSIS packages in Production Server.
• Creating SSIS Packages by using advanced tools (i.e. Lookup, Derived Columns, Condition Split, Term Extraction, Aggregations, Multicasting).
• Manage the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Utilize SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-Threading Concepts with Synchronous and Asynchronous transactions.
• Create logging, custom logging and error handling packages.
• Create SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Use SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Design Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports Charts, Functions and Maps.
• Responsible for creating Crystal Reports on demand, Adhoc Reports, Frequency Reports and Summary Reports.
• Develop various types of reports like Matrix, Table and Chart controls using SQL Server 2012 Reporting Services.

Environment: SQL Server 2017,2016, 20142012/2008 R2/2005, SSRS 2008, SSIS 2008, C#, ASP.NET, DB2, Oracle 9i/10g, Visual Studio 2005, Crystal Reports 10/2008, XML, XSLT, MS Office and Visual source safe, GIT, Bitbucket, SaaS.

Confidential - Bowie, MD

SQL Server SSIS/SSRS Developer

Responsibilities:

• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Installed, Configured, Managed and Monitored SQL Server 2008R2/2012.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Designed and created data marts, databases, indexes, views, aggregations, stored procedures, partitions, calculated measures and data integrity.
• Created Backend validations using Insert/ Update and Delete triggers.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Developed and deployed SSIS packages in Production Server.
• Creating SSIS Packages by using advanced tools (i.e. Lookup, Derived Columns, Condition Split, Term Extraction, Aggregations, Multicasting).
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-Threading Concepts with Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Created SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports Charts, Functions and Maps.
• Developed various types of reports like Matrix, Table and Chart controls using SQL Server 2012 Reporting Services.
• Responsible for developing various excel reports like Pivot table, static table reports, graphs. Developed & deployed the SSRS reports using MS reports builder.
• Implemented various Exception handling cases for proper flow of data into database. Identified Dimensions and Facts, used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tool.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.

Environment: SQL Server 2012/2008R2/2005, SSRS 2008, SSIS 2008, C#, ASP.NET, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Confidential - Richmond, VA

Senior SQL Server Developer

Responsibilities:

• Created and maintained the database for all the products.
• Teamed with developers to create the most optimal code and database connectivity to meet client-timing requirements.
• Worked on stored procedures, triggers and on large number of business analytical functions.
• Add and modify all required tables/databases to support the requests from the system analysts and the systems Integrator and provide daily production support for the operations of databases.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from Excel Spreadsheet to SQL Server 2008R2.
• Scheduling the SSIS packages and Jobs.
• The packages created included a variety of transformations, for example Aggregate, Group BY, SUM, Average, Count, Count Distinct and Maximum.
• Prepared the completedata mappingfor all the migrated jobs.
• Hands-on training in the use, maintenance, and development of databases using MS SQL Server 2008R2.
• Involved in supporting and maintaining the database servers, performing database installation, configuration, and upgrade.
• Involved in designing, implementing of database backup and restore procedures.
• Responsible for creating summary Reports, Sub Reports, Drill down Report, dynamic grouping.
• Created automated reports using SSRS (SQL Server Reporting Services).
• Monitored server performance, creating user logins and granting security privileges.
• Create alerts, notifications and emails for system errors, insufficient resources, fatal database errors, and hardware errors.
• Migrated stored procedures and databases from one server to another.

Environment: Windows 2003 Server, MS-SQL Server 2000/2008R2, HTML, XML, and MS Office 2003.

Confidential - Carrollton, TX

SQL Developer

Responsibilities:

• Gathered all the requirements from the end users for design and development of the application.
• Developed the star schema and the snowflake schemas depending on the requirements while designing the database.
• Involved in the enhancement of existing database schema by adding new tables, views, indexes and defining the relations.
• Developed and implemented database design documentation, including database diagrams, data mapping documents, data dictionaries etc.
• Designed, created, analyzed and executed business intelligence reports necessary to meet the needs of the clients.
• Migrated reports from SQL Server 2008 to SQL Server 2012 and configured new data with the existing data.
• Maintained SSIS packages for internal and external feeds and involved in deploying and troubleshooting those packages.
• Created and design Cubes for faster Analysis Using SSAS OLAP Report.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Involved in creating all key database objects - Tables, Views, Triggers, Indexes, Stored Procedure, User Defined Functions, and Dynamic SQL.
• Creating Drill down reports, Drill through reports, Parameterized reports for clients to meet the business needs.
• Created ad-hoc queries and reports as requested and provided an ongoing analytical support for these requests.
• Actively interfacing with other teams to gather requirements, design, code, debug, document, implement and maintain various database projects.
• Worked with the DBA and other developer team to assist and support SQL performance tuning and query tuning.

Environment: MS SQL Server 2008R2/2012, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (SSIS, SSRS), TFS, XML.

Confidential, Mt. Laurel, NJ

MS SQL / BI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Created linked, unlinked and on-demand sub Reports.
• Understood the various complex reporting requirements of company and created web reports using Reporting Services.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Modified report content and exported reports in multiple formats based on user input.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Created User Defined functions for sharing formulas across multiple reports.
• Modified existing reports according to requirements of the end users.
• Gathered business requirements from customers and created status reports.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL