PROFESSIONAL SUMMARY:

• Over 7 years of IT experience with a strong background in SQL Database Development, Data warehousing projects, Developing BI applications utilizing SQL server, Integration Implementation and Maintenance of Business Intelligence in various domain like Banking and Finance, Insurance and Health Care.
• Experience in Development and maintenance of database applications on MS SQL Server 2019/2017/2014/2012/2008 R2/2005, OLTP/OLAP, BI stack and (SSIS/SSRS/SSAS) environment.
• Expertise in writing T - SQL (DML & DDL) Code, Dynamic SQL, Query optimization & performance tuning using SQL Profiler, Execution plan, Performance Monitor and DBCC commands.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Excellent backend skills in creating SQL objects like Tables, complex Stored Procedures, Views, Indexes, effective Functions and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Joins, Indexes, Data Import/Export, Triggers.
• Experience using Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Wrote Complex SQL queries for verifying data integrity in Dimension and Fact tables and created and have In-depth knowledge in various RDBMS concepts.
• Experience in Data Modeling, Normalization and building Referential Integrity Constraints, Database Design and Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2012/2014/2016/2017 for both OLTP & Business Intelligence applications.
• Expertise in Creating Cluster Index and Non-Cluster Index, Covered Index, and Indexed View to improve performance on Database side.
• Very Good Understanding and 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.
• Expertise in SSIS direct and Indirect Configuration (XML, SQL Server) set up, SSIS Audit and Logging, Error Handling, Expressions and Variables.
• Experience in creating Historical and Incremental Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Proficient at data transformations like lookups, Derived Column, Conditional Splits, Sort, Data Conversation, Multicast and Derived columns, Union All, Merge Joins, Merge, Fuzzy Lookup, Fuzzy Grouping, Pivot, Un-pivot and SCD to load data in SQL Server destination.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Expertise in performance tuning of Data Flow Task in SSIS Packages.
• Developed ETL process using SSIS with various Control flow, Data flow tasks and Stored Procedures for the work order validation process.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like Dynamic, Linked, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Document Map and Sub-Reports.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts
• Familiar with Agile development and waterfall methodologies.

TECHNOLOGY EXPERIENCE:

Tools: Enterprise Manager, SQL Server Management Studio (SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SQL SERVER BIDS, Visual Studio 2012/2014/2017, Visual SourceSafe 8.0

Programming Languages: Pascal, C, C++, Visual Basic 6.0. VB.Net, ADO.NET, ASP.NET, T-SQL, PL/SQL, HTML, XML, MDX, MDS, MDM, DAX.

Tools: DTS, SSIS, SSRS, SSAS, Erwin

DATABASE: MS Access, MS SQL Server 2005/2008/2008 R2/ 2012/2, Oracle8i/9i/10g, DB2

Operating Systems: Windows NT/98/2000/XP/2003/2008 server

Software: MS Office Visio, MS-Project 2000, Dashboard using Crystal Reports

IT Processes: Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. SQL Server SSIS/SSRS Developer

Responsibilities:

• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Work directly with the business users in order to gather requirements and understand their usage of the data in depth.
• Based on business requirements, developed complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implement the business rules and transformations.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes.
• Involved in Performance Tuning of the Stored Procedures, User Defined Functions and long running queries.
• Created Partition Tables based upon Partition Functions and Partition Schemas
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Design and develop ETL process to integrate data among business systems and Data warehouses in MS SQL Server, Oracle and DB2.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2017.
• Created SSIS packages both design and code to process data to target databases.
• Created packages in SSIS with error handling and worked with different methods of logging.
• Extracted data from data sources Excel files, CSV files, text files, SQL-Server and applied required transformations to clean the data.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Created jobs to collect status information from various servers and feed them to the Master Server.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Design, code and test and trouble shoot business reporting for end users in Business objects Crystal Reports, SSRS and Power BI.
• Created reports from complex SQL queries and MDX queries.
• Created Dashboards with interactive views, trends and drill downs.
• Designed and built SQL dash board for reporting to allow ad hoc reports for management and Intelligence.
• Used TFS (Team Foundation Server) and Visual studio Team services (VSTS) to share all the work, code, to sort out the exceptions raised during work.

Environment: SQL Server 2017/2019, T-SQL Windows Enterprise Server 2017, OLAP, OLTP, Enterprise Manager, SQL Server Management Studio, Oracle 11g, SQL Server Business Intelligence Studio, Crystal Reports, SQL Server Profiler, XML, BizTalk Server 2004 Erwin, Microsoft Visio 2017, Dashboard using Crystal Reports, SFTP.

Confidential, Nashville, TN

MS SQL Server SSAS/SSRS Developer

Responsibilities:

• Extensive T-SQL Programming using Views, Functions, Stored procedures, CTE’s and functions.
• Performed performance tuning by analyzing indexes, queries, and table size etc. Database Engine tuning advisor and query execution plan tools.
• Developed database objects like tables, views, stored procedures in SQL Server 2012/2014.
• Created DTS Packages for extracting data from Flat Files, Excel, MS Access, Oracle and MS SQL Server 2014.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Created reports based on the format specified in the design document
• Documentation of all the processes involved in maintaining the database for future reference
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer
• Involved in development and modification of existing Financial Reports and Marketing Reports, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 200R2 and in adding calculations using MDX.
• Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS.
• Created reports using SQL Server reporting services SSRS, which is then exported as PDF. Reports variables are passed from ASP.NET web pages.
• Designed and built the ETL for mass uploading of product attribute changes into a custom-built analytical MDM solution.
• Developed Subject Areas for MDM using SQL Business Intelligence
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS
• Created reports using SQL Server reporting services (SSRS), which is then exported as PDF. Reports variables are passed from ASP.NET web pages.
• Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks

Environment: MS SQL Server 2008/2012/2014, Visual Studio 2012, COM/COM+, VC++, C#, Windows 2000, Windows XP, T-SQL, VB.NET, ADO.NET, ASP.NET, Visual SourceSafe, XML, MDM, MDX, Crystal Reports, SSAS, SSRS, ERWIN, Brio.

Confidential, Franklin Lakes, NJ

MS SQL Developer

Responsibilities:

• Gathered, organized, and validated data to answer business questions as need by the management.
• Written Complex Stored Procedure for the reports using T-SQL and dynamic SQL.
• Identified slow running query and optimization of stored procedures to tweak the performance.
• Create and implement ETL design patterns (SSIS best practices) for each of the OLTP /OLAP and ad-hoc requests for the business users.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Develop ETL (SSIS) solutions to provide data for Analytics, visualizations, dashboards and reports.
• Involved in day-to- day maintenance and solved any issues related to reports.
• Responsible for deploying the SSIS packages and scheduling the package through jobs in all tiers including dev, test, and production.
• Worked on Type 1 and Type 2 packages for incremental loading to load data from source to DataMart.
• Performed tuning of tables using normalization and by creating indexes.
• Managed day-to- day operations of the database systems activities and worked on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
• Code Reviews, customization, and maintenance of code across applications using TFS.
• Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS 2012 packages.
• Worked with scheduling and publishing of reports in SQL server reporting services and integration with Microsoft Office tools like automatically emailing reports in various formats such as Excel, PDF etc.
• Responsible for release of code into QA and production.
• Design and develop various BI reporting and visualization solutions including drill through and drill down reports, Matrix, Sub-report, Key Performance Indicator (KPI) using SSRS.

Environment: SQL Server 2012, SSIS, SSRS, C#.Net, Excel, TOAD, TFS, VB.Net, Visual Studio 2012, COSMOS, SharePoint, XML, HTML.