PROFESSIONAL SUMMARY:

• 7 years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2014/2012/2008 R 2/2008/2005/2000 in Development, Test and Production Environments with various business domains. Migration of SSRS reports from SQL 2012 to SQL 2014.
• Extensive experience with Data Modeling Techniques, logical and physical database design. Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Hands on experience in Installation, Configuration and Migration of SQL Server 2014/2012/2008 R 2/2008/2005/2000, apply periodic service packs and hot fixes (cumulative updates) and complimentary third - party tools.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in working with Salesforce to update/create/ new calculated data fields in SQL and push them back to the server using SSIS and TSQL.
• Used PowerShell Scripting, Autosys to schedule batch jobs and handle deployments to production during release of new development going live.
• Used MDX to interact with the back end OLAP Services. Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas. Created Reports with complex formulas and query the database for business Intelligence.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in enhancing and deploying the SSIS Packages from development server to production server. Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS). Experience in Creation and deployment of cubes on SSAS. Good understanding in Oracle 9i/10g Database.
• Expert ETL design, Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks. Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
• Worked Extensively on ETL process using SSIS package. Experience in using variables, expressions and functions and defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple table's inner and outer joins, stored procedures.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.
• Integration Services (DTS/SSIS)
• Extensive knowledge in ETL Process & Progressive knowledge in using DTS/SSIS utilities.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTSSSIS, and BCP & Bulk Insert utilities.
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Involved in migration of DTS Packages (2000) to SSIS (2005/2008R2/2012/2014) and troubleshoot migration issues. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

TECHNICAL PROFICIENCIES:

Databases: SQL Server 2014/2008 R2/2008/2005, Oracle 11g/10g/9i, PostgreSQL 9.3, Sybase 15x.

Platforms: Windows Server 2008/2003/2000/ NT, UNIX, WAMPSERVER 2.0, Apache 2.2.

Reporting Tools: SSRS, Crystal Reports

Languages/Utilities: SQL, T-SQL, PL/SQL, VB, VB.NET, C, C#, ASP.NET, PL/pgSQL

Tools: Visual Studio 2003/2005/2008, BCP, BIDS, SSMS, SQLCMD, DTA, Profiler, SQL Agent, MS VISIO, ERWin 4.1/7.0

Web Technologies: HTML, DHTML, XML, CSS, SharePoint

ETL Tools: SSIS/DTS, Crystal Reports.

Version Control: VSS, TFS, SVN

Microsoft Office Applications: Excel, Word, Access, PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. MS SQL Server Developer

Responsibilities:

• Involved in requirements gathering and participated in all phases of development life cycle.
• Involved in doing majority of SSIS development to handle the ETL procedure and upload the data back to salesforce using Microsoft SQL Server Integration Services (SSIS) 2015.
• Creating new stored procedures to make updates to the data or clean up any unrequited production data according to the changes coming up from business.
• Worked with Salesforce development team to understand different mappings from salesforce equivalent to SQL columns and make data match accordingly.
• Handle and take care of deployments myself from lower environments to testing to UAT and to production.
• Develop Autosys jobs, batch scripts using shell scripting to call the SSIS package and run the jobs in different environments changing the environment variables for each deployment.
• Used salesforce sandbox editor to handle bulk data load jobs and monitor the status of ETL runs at different stages of job for record counts, time took and failures.
• Coordinated with informatica team and salesforce team to do pre-deployment activities related to databases and data loads to continue development and migration of database objects in DM team.
• Used frame work procedures and templates in SSIS to log audits related to data updates, deletes and modifications to the tables and objects.
• Worked directly with business in understanding the requirements and taking environment sign offs after testing in UAT to meet expected outputs before deployments to production.
• Understanding data dictionary for different database object structures and schema mapping between SQL and business to find latest updates to columns.
• Handled raw data in excel and csv formats to import them into SQL sever and make data updates using stored procedures before loading them into salesforce sandbox server.
• Used ALM (Application Lifecycle Management), Lassi to work on defects/issues and worked in agile/waterfall mixed project environment.

Environment: Windows server 2010/2012, MS SQL Server-2017/2014 Enterprise Edition, SSIS, SSRS, T-SQL, Salesforce v9, SSIS Integration toolkit for salesforce v9.0 (9.0.0.5409 ), SQL Profiler, OLAP, OLTP, Office- 2010/2012/2016, MS Excel, Business Intelligence Development Studio 2015/2014, SQL Data tools 2015

Confidential - Brookfield, WI

MS SQL Server Developer

Responsibilities:

• Involved in developing SSIS packages and modifying existing ones as per the requirements using SQL Server data tools in Microsoft SQL Server Integration Services (SSIS) 2012/2013/2014/2015
• Involved in writing number of stored procedures, functions and testing them as per the requirements to meet the criteria.
• Used various query performance and SQL tuning techniques to improve the output time and the quality of the SQL database objects.
• Used SQL Server Agent to create various jobs and configured different steps to load different types of marts like mail, email etc.
• Worked with the UNICA customers to load the interactions into ORACLE destination. Modified and fixed various production support issues related to UNICA
• Monitored mart load alerts and supported in resolving the issues when mart run fails which is notified to the team using SSIS error notification emails.
• Used various SSIS transformations to pull the data from source and load them into different destinations such as ORACLE, OLEDB tables etc.
• Tested various data systems present internally in ALSAC such as DMS, MDM, and TA etc. that feeds the ETL marts to run the SSIS jobs.
• Used SSIS templates, which includes header and footer as default structures to be available for easy development of a SSIS packages by configuring the data flow.
• Involved in deployment of SQL data objects and SSIS packages from dev environment to QA.
• Worked with different source control systems like TFS and GIT, which are integrated with IDE to maintain shared environment for code and deployments within the team.
• Worked on automating some of the manual ETL loads and calculations, which are classified as prod support issues into automated SSIS packages and scheduled using SQL agent jobs.
• Worked in a waterfall model project environment initially and migrated to Agile/ Scrum.
• Involved in the ETL architecture migration projects and BI data models network architectural flips from one data center to another project named as COLOFLIP.
• Worked closely with business users and donors to understand the specific purpose of each task and the process involved in each campaign used for fundraising.
• Involved in the migration process of SQL server management studio (SSMS) and Visual studio along with SQL Server Data tools.
• Worked with business users for developing their reports using tableau and change sets for the dashboards, which is loaded using the ETL objects from SSIS.

Environment: Windows server 2008/2010/2012, MS SQL Server- 2017/ 2014/2012/2010/2008 Enterprise Edition, SSIS, SSRS, T-SQL, UNICA, SQL Profiler, OLAP, OLTP, Performance Point Sever, Office- 2010/2012/2016, MS Excel, C#.NET, TFS, GIT, Business Intelligence Development Studio 2017/2015/ 2014/2012/2008, SQL Data tools 2015, FileZilla

Confidential, Atlanta, GA

MS SQL BI Developer

Responsibilities:

• Create dimensions and members based on the business requirements and modify them accordingly whenever change control documents are updated.
• Involved in building cubes from scratch using Microsoft SQL Server Analysis Services (SSAS) 2008R 2/2008/2012/2014
• Developed SSIS packages to run daily jobs in the control system and ran extracts using BCP process.
• Created various ETL processes to modify the configuration files and ran batch files to run the extract files and load data into cubes.
• Designed Pivot table, drill through and many other complex reports using SSRS 2008R2, 2012, 2014 for client to check the final data for reporting.
• Involved in writing scripts in Teradata to export the source data into SQL database. Created many calculated measures using MDX scripting in SSAS.
• Involved in writing complex stored procedures, creating views, triggers, Joins, Constraints, DDL, DML and functions based on the requirement.
• Involved in upgrading of SQL server 2008R2 to 2012 and Visual Studio . Created usage based and normal aggregations for the cube to improve the performance.
• Used SQL Profiler to monitor the performance of queries, which are causing deadlocks and made performance tuning to the databases by removing historic query list.
• Designed pivot charts and provided links from spreadsheet to the database through excel for client to connect to the database to view the reports and select required data.
• Modified data flow tasks in SSIS Packages to configure them with new bill cycles or any new change requests and add them to the loop containers.
• Worked on automating daily jobs, monthly jobs and scheduling them in Control system. Configured error messages of daily loads through SSIS packages and sent them manually sometimes when the notification or processing is done through BCP.
• Involved in moving the fast export extract from Teradata as a source to SQL server database destination tables and views.
• Created hierarchies, partitions and base measures in cube as per client requirements. Majorly responsible for development and management of SSAS and SSIS projects
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2008, MS SQL Server- 2014/2012/2010/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Performance Point Sever, Office-2010, MS Excel, C#.NET, Teradata SQL Assistant 14.10, JEdit 5.0, Putty 0.60.0.0, Business Intelligence Development Studio 2014/2012/2008 .

Confidential

SQL Developer

Responsibilities:

• Migrated SSIS packages from R2, Developed and deployed new packages.
• Migrated SSRS reports from R2.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in 3 environments (Development, QA and Production).
• Involved in testing SSIS packages in QA environment.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup etc.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
• Providing design, development, and testing support to assigned application teams.
• Installing SQL Server products; managed patching and compliance issues.
• Maintaining Transactional SQL Replication between source and target SQL Server databases.
• Involved in migration of SQL Databases using Migration Utility.
• Setting up linked servers between SQL and DB2 data sources.
• Configured SQL Mail where in the SQL Server will send notification through a page on failure of a job on production and email on non-production environments.
• Worked on data modeling projects from starting to finishing, generated scripts for objects, Developed Relationship, and created E-R Diagram using ERWIN.
• Export & Import data from Flat file, CSV file to/from SQL Server databases using DTS, and BCP
• Monitored Database Backup and other jobs in the maintenance plan Restoration and Point-in-Time Recovery. Scheduling of operation and outages.
• Creating, modifying and managing tables, Index, Constraints, Views, Stored Procedures, and Triggers.
• Optimized long running Stored Procedures for effective data retrieval.
• Created and deployed various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Responsible for scheduling jobs, Alerting and maintaining SSIS packages.
• Promoted database objects from test/development to production. Coordinated and communicated production schedules within development team
• Involved in preparing training document for application development and QA/UAT teams.
• Prepared documentation for the disaster recovery plan.

Environment: MS SQL Server 2005/2008 R2, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Oracle, Teradata, MS Access 2007, XML, MS Excel, Erwin 3.5.2, MS-Visio 11.0.

Confidential

SQL Developer

Responsibilities:

• Determined the MS SQL Server 2008 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented different security modes.
• Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances
• Analyzed and designed new business processes.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
• Assisted in generating business process flows, functional design documents and test plans.
• Developed ETL Packages in SSIS to transform data to MS SQL Server from Excel for further analysis.
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Designed ETL package, with ETL Import/Export wizard for transferring data using Informatica
• Data migration (Import & Export - BCP) from text to SQL Server.
• Applied schema change scripts to existing objects to synchronize with changing business rules by adding or enhancing relevant entities/tables, columns etc.
• Implemented database consistency and security by creating groups, roles, users, and triggers on views

Environment: T-SQL, MS SQL Server 2008, MS Access 2008 MS-BI 2008, Data Warehouse (OLAP, ROLAP, MOLAP), Reporting Services, Crystal Report 8.0, ETL (SSIS, Informatica).