SUMMARY

• Over 9+ years of extensive experience in database design, development, and administration with MS SQL Server versions 2019/2018/2017/2016/2014/2012/2008 R2/2005/2000 using SSIS, SSAS, SSRS in Financial, Retail, Healthcare, Insurance, and Banking industries.
• Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Strong experience in logical and physical database design and development, Normalization and data modeling using MS SQL Server Enterprise manager.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
• Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources.
• Worked withT-SQL, DDL,andDMLScripts and established relationships between tables usingPrimary KeysandForeign Keys.
• Experience working with complex data sets in a multi-sector environment.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• In depth Knowledge inER ModelingandDimensional modeling(Star and Snowflake Schema) building Dimension, Data marts and Fact tables.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expert in transforming data from different source (CSV, Flat Files, Excel) to SQL Server databases.
• Good Knowledge with VBA Excel.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Intermediate knowledge in Qlik.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Experience in deriving cube calculations using MDX scripting and MDX driven SSRS reports.
• Experience in Developing Power BI Reports.
• Good Knowledge on creating and Supporting Tableau Reports.
• Experienced with Agile/Scrum Methodologies.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experience working with Salesforce CRM Team handling the Customer Account, Address, and Contact details on salesforce.
• Efficient in upgrading and migration from SQL Server 2000 to SQL Server 2012/2008R2/2017.
• Good Knowledge and understanding in PL/SQL, Python, HTML, XML.
• Excellent interpersonal skills and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS

SQL Server/BI Tools: SQL Server Management Studio (SSMS), MS Visual Studio 2010/2008, Business Intelligence development Studio (BIDS), Export & Import (DTS), Query Analyzer, SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), Tableau, SharePoint 2010/2007, MicroStrategy, Power BI

Databases: MS SQL Server 2019/2018/2017/2016/2014/2012/2008 R 2/2008/2005/2000 , MS Access, Oracle11g/10g/ 9i

Languages: T-SQL, PL/SQL, C#, VB.Net,MDX, HTML, Python, CSS, XML, VBA Excel

Operating Systems: MS-DOS, Windows 7/XP/NT 4.0/2000/2003/2008 Server, UNIX(LINUX)

Database Design Tools and Data Modeling: MS Visio 2008/2011, ERWIN r7/r4/r3.5, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

Database Tools and Utilities: SQL Server Management Studio, Enterprise Manager Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor

Version Control Tools: VSS, Sub version, TFS

PROFESSIONAL EXPERIENCE

Confidential, Norwell MA

Sr. SQL Developer/SSIS Developer

Responsibilities:

• Develop, implement database objects like Tables, Views, Functions, Stored Procedures using T-SQL
• Perform DDL and DML command operations on database objects.
• Handling existing stored Procedures and performing new enhancements based on business request.
• Develop Complex SQL for using in ETL applications.
• Creating SSIS ETL work flow to transform the data and load it into the SQLite db tables.
• Handling SSIS Packages created to flow data between Salesforce, Beacon and SQL Databases and monitoring the SQL agent jobs on daily bases.
• Creating and Maintaining SQL Agent jobs to perform data loads between different servers.
• Migrating SSIS Packages from 2008R2 to 2017
• Creating estimates for Sprints to accurately reflect the effort required.
• Unit testing SQL Codes/SSIS
• Documenting the work on daily basis of all the changes I am making and saving it on TFS for future references.

Environment: s: MS SQL Server 2008R2,2012,2017, Visual Studios 2008, 2017,2019, DB Visualizer 9.2.14, Microsoft Integration Services (SSIS), Windows 7, PowerShell, ASP.Net.

Confidential, Owings Mills MD

Sr. SQL Server Developer/Production Support

Responsibilities:

• Assists in the development and delivery of technical and process-oriented solutions and recommendations in support of the production environment.
• Analyzing of business and user needs, documentation of current system requirements, translation into proper system specifications, and writing and execution of test cases.
• Worked on application coded in Agile environment utilizing a test-driven development approach.
• Designing databases and ensuring their stability and performance.
• Created complex functions, stored procedures, and triggers to support application development and Improve performance.
• Work at a high level of most phases of systems analysis and considers the business implications of the application of technology to the current and future business environment.
• Deploy, Configure, Maintain compute on Azure Cloud.
• Development and configuration of report server and report manager, handle permissions to users of various levels with SSRS.
• Create Reports using Crystal reports 8.5,11 and PowerShell Scripting.
• Writing SQL Queries to extract data using DBVisualizer.
• Developing Power BI reports and dashboards from multiple data sources using data blending.
• Using Power BI to explore data in different ways and across multiple visualizations.
• Created reusable SSIS packages to extract data from data sources into SQL databases and DB2 systems.
• Working on existing SSIS packages and performing new enhancements as per business request.
• Modifying the existing the SSIS packages of the legacy application and match it with various integration sources.
• Troubleshooting high level issues to identify and resolve issues caused by database, source data, ETL, or the Business Intelligence software (For example: NULLS causing Joins to function incorrectly, ETL running out of sequence, Microstrategy objects not set up properly)
• Troubleshoot Azure related issues and work with internal teams to resolve the issues.
• Scheduling jobs using a third-party application (Confluence Workstation) and SQL Server job agent to extract data from crystal reports and place the files in the outbound folder.
• Manage all DB maintenance plan activities including backups, indexing, integrity and consistency checks, etc.
• Scheduling the SQL Jobs using Autosys and Maintaining.
• Analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Designing Power BI data visualization using cross tabs, scatter plots, pie, bar and density charts.
• Migrating reports from Crystal reports 8.5 version to Crystal Reports 11.5 version as per business requirement.

Environment: MS SQL Server 2012,2014,2016,2018/2019, Crystal Reports 8.5,11.5, DBVisualizer 9.2.14, Microsoft Integration Services (SSIS), Microsoft Reporting Services (SSRS), Windows 7, PowerShell, ASP.Net.

Confidential, Miramar FL

Sr. SQL Server Developer/BI Developer

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Use the Warehouse Catalog to move and update tables in MicroStrategy.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, web-enabled reporting to create reports that draw content from a variety of data sources.
• Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
• Involved inPerformance Tuningof Code using execution plan and SQL profiler and addedIndexesto improve performance on tables
• Using SQL Server Integration Services (SSIS) to design and maintain ETL Solutions.
• Generated Reports using Global Variables, Expressions and Functions for the reports usingSSRS2010, 2012, 2017.
• Participating in defining ETL strategies, preparing transformation rulesand mappingdatafrom source to target
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Creating solutions and help prepare test plans by having good knowledge of data warehousing concepts, dimensional/ cube data modeling techniques, including MDX and DAX scripting.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Designed and developed efficientSSISpackages for processing fact and dimension tables with complextransformations.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
• CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Extracting data from Datawarehouse and Data Mart through SSIS.
• Experienced using Visio database design.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints
• SQL Server Index Maintenance and Performance Tuning for Large Tables
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Experienced working with Autosys scheduler for reporting and monitoring jobs.
• Experience inETL Data Warehouseenvironment. Created Jobs inSSISand was responsible for ETL job scheduled to run daily.
• Designing and implementing a variety ofSSRSreports such asParameterized,Drilldown, Ad hoc and Sub-reports using Report Designer andReport Builder based on the requirements.
• DesignedSSRSreports withsub reports, dynamic sorting, defining data source and subtotals for the report.
• Generating Ad-hoc reports in Excel Power Pivot and break them using Power BI for planning purpose.
• Developed, monitored and deployedSSISpackages.
• CreatingReportsas per user requirements usingSQL Server Reporting Services 2012.
• Design and developing custom reports and deploy them using Power BI.
• Collaborating with Scrum master, Testing team and BA in Agile methodology.
• Providing data support for Tableau Reporting.
• Written complexT-SQLqueries and created Stored Procedures, Triggers, Functions and Views using SQL Server 2017, 2016, 2014, 2012.
• Worked on backend related C# code for windows and web applications to perform CRUDE operations.
• Build Back-end support for Application from ground up using Python, Shell scripts & Perl.
• Involve in the development of the application using Python3.3, HTML5, CSS3, AJAX, JSON and jQuery.
• Worked on entity framework in .Net applications.
• Created Unit test cases for all service methods.
• Experience in SQL DBA.

Environment: MS SQL Server 2008 R2/2012,2014,2016,2017 Excel 2010, Microsoft Integration Services (SSIS), Microsoft Reporting Services (SSRS), Power BI, Tableau Visual Studio 2010, Windows 7, PowerShell, ASP.Net, C#, UNIX

Confidential, Tulsa, OK

SQL Developer/BI Developer

Responsibilities:

• Worked on Migration from SQL Server 2000/2005 to SQL Server 2008R2 and SQL Server 2012.
• Worked on upgrading SQL Server 2000 and 2005 databases to SQL Server 2008 R2 and SQL Server 2012.
• Experience in moving data from heterogeneous data sources to SQL Server usingDTS/SSIS.
• Experience in Bulk Copy (BCP), Script task and Script component for complex SSIS transformations.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Ad hoc, Sub Reports and created report subscriptions.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services(SSAS).
• Participated in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and SnowFlake Schema for developing Cubes in SQL Server Analysis Services (SSAS).
• Utilise SSAS and MDX coding to design and develop multi-dimensional models of large data sets.
• Migrated DTS packages into SSIS packages.
• Experience in working and fixing defects on upgrades to systems from SQL Server 2005 to SQL server 2012.
• MS SQL Server Configuration,Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Experience in using profilers, IndexTuning Wizard and performance monitor to monitor SQL Server.
• Experience inCreating and Updating Clustered and Non-Clustered Indexesto keep up the SQL Server Performance
• Worked with test and production teams to Promote Stored Procedures, SSIS packages and Reports into production.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

Environment: SQL Server 2012/2008R2 Enterprise Edition, Windows Enterprise Server 2008R2, IIS 7.5, C#, SSRS, SSIS, Excel 2007/2010.

Confidential

SQL Server Developer

Responsibilities:

• Implemented a well-planned backup and restore strategy that protects databases against data loss
• Responsible for design, development and implementation of mappings/transformations based in source-to-target specifications, definingETL (extract transform, load).
• Developed complexSQL queries,stored procedures, andDTSpackages
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation
• Involved in designing and writingStored Procedures,functionsand packages using T-SQL for SQL Server 2005
• Used DBCC utilities to fix data corruption in application databases
• Development of Business rules implemented asConstraints, Triggersand orStored Procedures
• Actively involved in Normalization & De-normalization of database.
• Installed and ConfiguredSQL Server 2005on servers.
• Designed DDL and DML for MS SQL Server 2005.
• UsingSQL Server Integration Services (SSIS)to populate data from various data sources
• Optimized query performance by creating indexes.
• Involved in writingSQL batch scripts.
• Created scripts for tables,stored procedures andDTS.
• WritingT-SQLstatements for retrieval of data and involved inperformance tuningof TSQL
• Involved in merging existing databases and designed new datamodels to meet the requirements.
• Createjoinsandsub-queriesfor complex queries involving multiple tables.
• Used DML for writingtriggers, stored procedures, and data manipulation.
• Taking Databasefull Backup, Transaction log backup & differential backupin daily Routine
• Monitor production Server Activity
• Worked with DTS packages to load the massaged data into Data warehousing system
• Tuned the SQL queries using SQL profiler and involved in tuning the database

Environment: SQL Server 2005 Enterprise, Windows Enterprise Server 2003, Erwin, Microsoft Visio, DTS, SQL Profiler, Query Analyzer.