PROFESSIONAL SUMMARY:

• Around 7 years of experience in designing and implementing databases and data warehouses for IT, Healthcare and Banking industries.
• Experienced in designing database schema using Microsoft SQL Server 2008/2012/2014.
• Experienced in performing database normalization to create RDBMS databases.
• Excellent ability to write complex SQL queries, stored procedures, views and triggers to achieve business requirements.
• Experienced in Data Cleansing, Transformation and Integration using Microsoft BI technologies.
• Expert knowledge of data extraction, transforming and loading (ETL) using SQL Server integration services (SSIS)
• Good knowledge in creating different types of reports using SSRS.
• Expert knowledge in creating dashboards with different types of visualizations using Tableau.
• Experienced in using version control systems like TortoiseSVN and TFS.
• Ability to use Java to develop and/or maintain software products.
• An excellent team player and technically strong person capable to work with any team size.
• Interested in learning new technologies as per project requirements.

TECHNICAL SKILLS:

Programming Languages: Python, Java, JavaScript

Database Skills: Data modeling, Database Normalization, SQL.

Development Tools: Microsoft Visual Studio, SQL Server Management Studio

Project Methodologies: SDLC, Agile

Operating Systems: Windows, Linux

Business Intelligence: Microsoft SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS), SSAS,SQL Analytics, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Largo, MD

Sr. SQL/BI Developer

Responsibilities:

• Gather and analyze requirements from business users.
• Create Data warehouse databases to store data used for analysis and reporting purposes.
• Design and development of data integration packages using Microsoft SQL Server Integration Services (SSIS).
• Create SSIS Packages to extract data from different data sources like OLE DB, Flat files, Excel, XML files etc., into different destinations like SQL Server databases, Flat files, Excel files.
• Extensively used various tasks like ‘Execute Package’, ‘Execute Process’ ‘File System’, ‘FTP’, ‘Script’ and ‘Send Mail’ covering most of the major task types available in Visual Studio tool.
• Expert knowledge in debugging the SSIS packages and fixing the errors.
• Test and deploy the SSIS packages on development and production servers.
• Scheduled Jobs for executing the deployedSSISpackages to update the database on Daily/Weekly/Monthly basis using SQL Server Agent.
• Created SSAS cubes with multiple fact measure groups and hierarchies based on the OLAP Reporting needs.
• Designed fact and dimension tables and defined fact relationships.
• Used Socrata’s provided open data portal to publish various data sets to the public.
• Used Data Sync tool provided by Socrata to automate the data sets update functionality on a scheduled basis.
• Work in conjunction with project managers to assign project level tasks to the development team.

Tools: Microsoft Visual Studio 2012, SQL Server Management Studio

Confidential, Logan, Utah

SQL/BI Developer

Responsibilities:

• Design and modify database schema.
• Develop code for stored procedures and modify existing ones as per business requirements.
• Write complex SQL queries by applying joins on multiple tables to retrieve desired data.
• Optimize stored procedures, views and other database operations.
• Create SSIS Packages to extract data from different data sources like Flat files, Excel, XML files etc., into SQL Server databases.
• Good knowledge in using transformations like ‘Data Conversion’, ‘Aggregate’, ‘Conditional Split’, ‘Lookup’, ‘Derived Column’, ‘Merge Join’, ‘Sort’, ‘OLE DB Command’, ‘Union All’ and ‘Script Component’.
• Extensively used various tasks like ‘Execute Process’, ‘File System’, ‘FTP’ and ‘Script’ covering some of the major task types available in Visual Studio tool.
• Test and deploy the SSIS packages on development and production servers.
• Create dashboards using Tableau to provide required information to different business users in the organization.

Tools: Microsoft Visual Studio 2012, SQL Server Management Studio, Tableau 9.1

Confidential

Business Intelligence Developer

Responsibilities:

• Gather and analyze requirements.
• Create SSIS packages to extract and transform data provided by client and load into project database.
• Modify existing SSIS packages to meet the changes required by the users.
• Schedule jobs for executing the stored SSIS packages that updates the database on daily, weekly and monthly basis using SQL Server Agent.
• Design and develop a variety of business reports using SSRS.
• Involved in designing Parameterized reports for generating Ad - Hoc reports as per the client requirements.
• Generated reports using Global Variables, Expressions and Functions.
• Developed drill down, drill through and sub reports.
• Developed ad-hoc SSRS reports that used Analysis Services databases as a data source.
• Gained expertise in doing report subscriptions and timely schedules.

Tools: Microsoft Visual Studio 2010 and SQL Server Management Studio.

Confidential

SQL/C# Developer

Responsibilities:

• Design database tables and perform normalization.
• Ensure referential and transactional integrities on database tables
• Create stored procedures and SQL queries to perform different database operations as per business requirements.
• Develop code using C# to do ETL tasks.
• Use SSIS to create ETL packages to extract, transform and load data to data warehouse and data mart databases.
• Create SSIS Packages to extract data from different data sources like Flat files, Excel, XML files etc., into SQL Server databases using all necessary transformations and data cleansing tasks available in Visual Studio application.
• Modify the existing SSIS packages to meet the changes specified by the business users.
• Perform peer-to-peer testing and manual testing to ensure quality of the product.

Tools: Microsoft Visual Studio 2008 and SQL Server Management Studio.