SUMMARY

• 8 years of strong experience with demonstrated success in Microsoft SQL Server Database design and development.
• Expertise with DDL and DML statements, RDBMS, data dictionaries.
• Great deal of experience with MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL Server Analysis Services (SSAS), Integration services catalogs, Data Cube and Datawarehouse.
• Profound noledge working with Team Foundation Server (TFS) and GitHub.
• Experienced in working with Azure Datawarehouse, Azure Data Lake Store, Azure Blob Storage, Data Lake Analytics and AWS S3.
• Familiar in using IDE’ s such as Jupyter and Spyder for Python
• Involved in optimizing code and improving efficiency in databases including re - indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Good understanding and designing of Star and Snow-Flake schemas used in relational, dimensional and multidimensional data modeling.
• Profound noledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various sources.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, adhoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached reports using SSRS.

TECHNICAL SKILLS

• Microsoft SQL
• SSIS
• SSRS
• SSAS
• PowerBI
• Azure Datawarehouse
• Data Lake
• Data Factories
• Blob Storage
• SQL Profiler
• Integration Services Catalog
• Python
• Powershell
• Elastic Search
• Logstatsh
• Kibana
• C#.NET
• TFS
• GitHub

PROFESSIONAL EXPERIENCE

Confidential, DC

Senior Database Developer/Senior Data Analyst

Responsibilities:

• Analyze data and create PowerBI reports for Online Security/Risk team.
• Create complex stored procedures to support Data Analytics and Data Science team.
• Create adhoc queries/ reports to support Service Assurance and Customer Service teams.
• Created/modified ETL process to load Feeds data into SQL Server.
• Create complex queries to analyze Identity Verification and Listing Verification data.
• Actively participated in data integration between Confidential and CoStar Database Servers.
• Created SQL Scripts and SSIS packages to transfer Leads and Activity data from Confidential Datawarehouse to CoStar Datawarehouse.
• Configured SQL Server Agent jobs to populate data into CoStar systems.
• Involved in creating new Confidential and Confidential Analytics databases to store legacy Confidential Data.
• Familiar with Enterprise Database, CoStar Datawarehouse and PDS Databases.

Confidential, VA

Database Developer/SQL Server Technical Analyst

Responsibilities:

• Customer Churn Analysis year over year.
• Analyze Lead Generating vs Non-Lead Generating products.
• Analyze data discrepancies between Billing to Production databases.
• Implemented Microsoft Azure SQL Data Warehouse to store massive data logged from Internal Event Logging
• Embedded U-SQL code in Data Lake Analytics jobs to parse the JSON event log files.
• Created Data Factory Pipelines to import data into Azure Datawarehouse.
• Created Stored Procedures in Azure SQL Datawarehouse to power Market Profile Reports.
• Used SQL Server Integration Services (ETL Tool) to automate the entire process by creating SSIS package which includes PowerShell scripts.
• Created SQL Server Agent Jobs and called the SSIS packages embedded in Integration Services Catalogs.
• Actively involved in event logging and imported data using Hadoop and tan into Hive.
• Created Hive queries for event logging analysis and testing.
• Used Ambari Hive view to write, execute and debug Hive queries. Used Ambari Dashboard to monitor Hadoop clusters.
• Optimized stored procedures and queries for TEMPeffective data retrieval and to increase performance.
• Created Real-time Data Warehouse in SQL Server Management Studio (SSMS2012).
• Created complex SSIS packages to transfer data from OLTP Databases to Data Warehouse.
• Created complex Stored Procedures on Data Warehouse which power SSRS reports.
• Used SQL Server Data Tools (SSDT) and Team Foundation Server (TFS) in Build and Deploy process.

Confidential

Programmer Analyst

Responsibilities:

• Installation and configuration of SQL Server 2012.
• Created new databases and database objects.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• TEMPEffectively worked on declarative database development using SQL Server Data Tools (SSDT).
• Developed/modified SSIS packages to Extract, Transform and Load (ETL) data from various sources.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Worked on Team Foundation Server (TFS) as a Version Control Tool in Agile Methodology.

Confidential

Programmer Analyst

Responsibilities:

• Develop SSIS packages to load data from data warehouse and other sources.
• Created SQL agent jobs to run the SSIS packages from the catalogs.
• Transfer data from OLTP to OLAP databases using SSIS packages.
• Created Reports using Business Intelligence Development Studio (BIDS).
• Review C#.NET code
• Wrote complex Stored Procedures to power Reports.
• Created various types of reports such as Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SSRS.