SUMMARY

• 6 years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Implementation and Deployments using SQL Server 2016/2015/ 2014/2012/2008 /2005 .
• Skilled in Business Intelligence tools like SQL Server 2008 Integration Services (SSIS) and Reporting Services (SSRS).
• Expertise in Extracting, Transformation and Loading (ETL) data using SQL server Integration.
• Hands on experience in Software Development Life Cycle (SDLC) including Agile/Scrum and waterfall project management methodologies.
• Queries using SQL Server 2008
• Extensive SQL Development experience in the Retail industry with a strong understanding of data analytics.
• Proficient experience in SQL Server and T - SQL in designing and creating tables, views, Stored procedures, triggers, user defined functions, indexes, data dictionaries, and data integrity constraints.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Have basic knowledge on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Performed database consistency checks at regular intervals.
• Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).
• A well-organized, goal-oriented, highly motivated and effective team member with excellent analytical, troubleshooting, and problem-solving Skill.

TECHNICAL SKILLS

Databases Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Microsoft Azure

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Visual Studio 2010,2014

Modeling Tools: Microsoft Visio, SQL Diagrams

Reporting Tools: SQL Server Reporting Services (2005/2008 R2,2012,2014), MS Access, MS Excel

Database: MS SQL Server 2014/2012/2008 /2005 , MS Access

Programming: T-SQL, PL/SQL, VB.Net, XML, HTML, C#, C, C++

Web Technologies: HTML, DHTML, XML, XSL

Operating Systems: Windows 2012/2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5. Unix, Linux

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio, Excel)

PROFESSIONAL EXPERIENCE

Confidential, Greenbelt, MD

SQL Server / MSBI Developer

Responsibilities:

• Design SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio.
• Create Queries in T-SQL, Stored Procedures and Views to store the data of clients, advisors using SQL Server Management Studio. Create User Defined Functions, Views to store data into appropriate tables as and when data arrives and create indexes to the tables that have least updates to improve the query performance.
• Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity recommend changes as necessary.
• Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring. Create database design documentation at architectural and functional level.
• Recommend new strategies and architecture to enhance efficiency of data systems. Plan, manage and track database and SQL procedures system changes.
• Design, develop, test, and implement complex database code, such as stored procedures to customize reports based on specific parameters to allow for ongoing flexibility
• Design, develop, and test front end reports that can be implemented by the Application development team to push to production for release.
• Rewrite and correct existing inefficient or poorly performing queries and stored procedures to run more efficiently and to ensure stronger performance
• Assist application developers with data mapping, as well as helping them understand the layout of data warehouse tables
• Interacts with report owners to clarify requirements and customize to report specifications and features to ensure finished reporting product meets end user needs
• Ensure performance, security, and availability of databases
• Experience in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery.
• Data Factory for on-premises to Azure SQL and Azure SQL to Microsoft Cloud Internal Implementation.
• Prepare documentations and specifications
• Profile server resource usage, and optimize and tweak as necessary.
• Data migration (import & export - BCP) from Text to SQL server.

Tools: and Technologies: MS SQL Server 2017,2015 Visual Studio 2017,2015, SQL Server Integration Services (SSIS), Data Warehouse, Redgate Tools, Informatica Power Center 9.5.1, C#, Data Modeling, Share Point, Widows server 2012.

Confidential, Columbia, MD

SQL Server BI Developer

Responsibilities:

• Created many complex database code objects such as Stored Procedures/ views/ Functions and used them to generate reports and created indexes to the tables that have least updates to improve the query performance.
• Developed Tables, Views, and Stored Procedures using SQL Server Management Studio.
• Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Provide data quality advisory services to clients and to internal stakeholders.
• Recommend maintenance enhancements to data acquisition processes to improve accuracy of data warehouse data.
• Perform support functions and develop fixes accordingly for our Association Management System, Manage and actively participate in system and user acceptance testing.
• Provide technology options and recommendations to solve for business challenges, Strong knowledge of database and system performance monitoring.
• Ability to share and communicate ideas both written and verbally to staff at various levels within the organization in a clear and concise manner that is relevant to each level.
• Work with Service Management team to establish and monitor service level agreements, communication protocols with data suppliers and data quality assurance policies.
• Support Batch and Online processes involving development, enhancement and support of T-SQL procedures, views, triggers and query tuning.

Tools: and Technologies: MS SQL Server 2014/2012, Visual Studio 2013,2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) Microsoft Share Point, MS Project, VBA, MS Office, QA testing and Software Development Life Cycle (SDLC)

Confidential

SQL Developer

Responsibilities:

• Designed, developed and implemented DDL scripts to create database schemas, tables and views on SQL server 2008/2012/2014/2016.
• Developed Tables, Views, and Stored Procedures using SQL Server Management Studio.
• Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Involved in migrating databases from SQL server 2008 to SQL server 2012/2014.
• Developed Tabular Reports, using SQL Server Reporting Services (SSRS).
• Designed SSIS Packages in SSDT and BIDS to extract data from various data sources such as MS Access, Excel and flat files into SQL Server 2008/2012/2014/2016.
• Writing complex SQL queries, Triggers, Cursors, Joins, adding Constraint and user defined functions to implement business logic.
• Assisted in Business Analysts to gather technical requirements.
• Manage and actively participate in system and user acceptance testing.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in SQL server agent jobs.
• 24x7 Support for Application Development team with any production database issues, updates or new releases.

Tools: and Technologies: MS SQL Server 2014/2012/2008 , Visual Studio 2013,2010, SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS) Microsoft SharePoint, MS Project, VBA, MS Office, ALM for QA testing and Software Development Life Cycle (SDLC).