SUMMARY

• Having 8 years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2016/2014/2012/2008/2005.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Good experience in Data Extraction, Transforming and Loading (ETL/ELT) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Excellent experience in developing stylish Drill-Down, Drill-through, Cascading, Parameterized, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
• Used Star and Snow Flake schema in designing cubes for creating SSAS packages.
• Expertise on coding in different technologies i.e. Python, Unix shell scripting
• Developed object-oriented web applications using MVC architecture using Python and SQL.
• Experience with Git, JIRA and working with an Agile/Scrum workflow.
• Good documentation skills with the ability to meet project deadlines.
• Excellent knowledge in numerical and scientific libraries such as Pandas and NumPy
• ER diagrams for developing normalized database.
• Actively involved in all phases of data science project life cycle including Data Extraction, Data Cleaning, Data Visualization and building Models
• Proficient in data visualization tools such as Tableau and Python Matplotlib (plotly) to create visually powerful and actionable interactive reports and dashboards.
• Strong healthcare knowledge worked on Data-migration and Data-Conversions Keeping HIPAA policies intact.
• Worked on clinical data, patient demographics, inpatient, outpatient, orders and reports, claims, eligibility, lab data etc.

TECHNICAL SKILLS

Statistical Tool: Python (NumPy, Pandas, Scikit-learn), R Studio, JSON, Spyder, Jupyter Lab

Data Visualization: Tableau, ggplot2, Matplotlib, Seaborn,

DBMS: SQL Server, PL/SQL, My SQL, Oracle 10g (NoSQL - Mongo DB)

Big Data Analytics: Linux, Hadoop, MapReduce, Hive, Sqoop, Pig, PySpark

Development Tools: Agile/Scrum - JIRA

ETL Tools: SSIS, SSAS, Informatica

Programming: SQL, VB Scripts, Python, JavaScript, React JS

AWS Services: S3, EMR, EC2, Athena, Data Pipeline, Lambda, Glue, SNS, SES

Data Analysis library: Pandas, NumPy, SciPy, Scikit-learn, NLTK, Plotly, Matplotlib

PROFESSIONAL EXPERIENCE

SQL Developer

Confidential

Responsibilities:

• Implemented Graphql API for the logging system and permission accessibility in MVC architecture in React JS and PHP.
• Used SCRUM for agile development and participated in team-led solutions, reviewed peer’s code for quality and completeness.
• Optimized complex joins stored procedures to improve query performance and reduce their runtime from 5 hours to 2 hours.
• Implement a staging database and functions in PHP facilitating the approval of data changes to be made on production.
• Reduced unnecessary commits to production by 36% by creating staging database in place.
• Safe deletion with approval and redirects removed broken link issues entirely.
• Handled large volume of dataflows from various data sources, performed transformation using Hive, MapReduce and loaded data into HDFS and extracted from Oracle into HDFS.
• Implement security and data protection solutions in Python.
• Performed root cause analysis to determine the effectiveness of applications.
• Developed Python based RESTful API to track sales and perform sales analysis using Flask, SQLAlchemy and PostgreSQL.
• Collected data in Hadoop 2.x and retrieved the data required for building models using Hive.
• Developed Spark Python modules for machine learning & predictive analytics in Hadoop.
• Designed and optimized complex stored procedures to perform data profiling and auditing.
• Created T-SQL scripts, which generated tables, relationships, based on the finalized ER-diagram.
• Identified source, destination, staging area per ETL strategy and performed data cleansing and data profiling.
• Expertise in writing T-SQL Queries and complex joins for generating Complex Stored Procedures, User-defined Functions, Views and Cursors, Data Integrity (constraints), Performance Tuning, Query Optimization and Validation issues.
• Worked with business owners, developers, technical experts and users for analyzing and identifying ETL processes along with working with the team for requirement gathering and gap analysis.
• Worked Extensively on ETL, which involved with different Data Sources like Flat Files, SQL Server and CSV Files, which needs Data Transformation and Loading to data warehouses via staging using SSIS.
• Enhancing and deploying the SSIS Packages from development server to production server. Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Worked on daily SSIS support for job failure on production. Fixed issues with T-SQL code on production.
• Migrated SSRS reports to Power BI and configured Power BI Premium Capacity Workspaces.
• Utilized Power BI tool (power view) to create various analytical dashboards that depicts critical KPIs along with slicers and dicers enabling end user to make filter.
• Interacted with application team for the requirement and created database objects according to their needs. Worked on lot of requirement from the application team.
• Using ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Strong technical skills in designing, developing, debugging, documenting, and implementing applications.

Environment: Windows 2016 Server, MS SQL Server 2014/2016, MS SQL Server data tools 2010/2012/2015/2017 , MS Excel, Access, Visual Studio, BIDS, Visual Source, C#, Outlook 2016, Business Skype, TFS SVN, TFS for ticketing tool, semi agile, waterfall.

SQL/BI Developer

Confidential

Responsibilities:

• Experienced in writing complex SQL Queries, Stored Procedures, Triggers (DML, DDL& logon), Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions (Scalar, Inline TVF & MSTV) to implement the business logic and created clustered and non-clustered indexes.
• Outstanding experience in specifying issues in database, Performance Tuning (SQL profiler & Set based tuning), Debugging, Troubleshooting and improving database performance.
• Created packages using Integration Services (SSIS) for extracting data from XML, Excel files, OLEDB to SQL Server staging tables before loading into destination.
• Experience in MS SQL Server with OLTP/OLAP and Business Intelligence delivery using SQL Server Integration Services and SQL Server Reporting Services
• Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems
• Extensively involved in designing SSIS packages to export data from various source to SQL Server database.
• Experience in creating complex SSIS packages using proper control flow and Data flow elements with error handling.
• Created SSIS packages for data loads, also performed data migration and data conversion.
• Experienced using BCP IN/OUT with SSIS, command line, SQL server (T-SQL), have expertise with import/export wizard.
• Addressed data quality by using Conditional Split, Fuzzy Look-Up, Derived Column transformations
• Modifying the SSIS packages per the Business requirements.
• Identified various data sources and established connections between source and the Destinations using SSIS based on the business requirements.
• Developed SSIS Packages to run the Batch scripts and FTP (File Transfer Protocol) to other servers using UNIX and DOS commands.
• Experience in ability to debug and write C# code for various SSIS script tasks
• Developed SSIS packages for archiving the files after the FTP Process using Script Task.
• Debug and tune SSIS to ensure accurate flow of data is achieved.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked on SQL server 2016 version.
• Worked on special projects like data de-Identification which involves masking PHI information on non-prod environments.
• Involved in requirement gathering, design documentation and code review.
• Excellent communication skills and through understanding of processes.

Environment: Windows XP/2003 Server, MS SQL Server 2008 R 2/2012/2014/2016 , MS SQL Server data tools 2008/2010/2012/2016, MS Excel, Access, Visual Studio, BIDS, Visual Source, C#