PROFESSIONAL SUMMARY:

• 8 Years of experience as an Information Technology professional in Database Designing, Programming and System Analysis and Design and Development in the Client - Server Environment.
• Complete knowledge on Software development life cycle (SDLC).
• Expertise in using different transformations provided by SSIS such as script component, Look UP, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• 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) (2012/2008/2005 ).
• Expert in creating various SQL server objects like tables, indexes, indexed Views, complex Stored Procedures (Dynamic and static), effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in Designing, Development and Deployment of complex SQL Server Integration Services (SSIS) packages in SQL Server 2012/2008/2005.
• Expert in using Bulk Copy (BCP), Data Transformation Services (DTS), and SQL Server Integration Services (SSIS) in SQL Server 2012/2008/2005.
• Expert in designing reports with Cross-Tab, Drill Down, Drill Through, Cascading Parameter, Sub-report in SQL Server 2012/2008/2005.
• Knowledge of designing, creating, processing of cubes using SSAS.
• Extensive knowledge in creating Jobs, Alerts, and scheduling SSIS packages.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Expertise in installing and configuring SQL Server 2005/2008/2012 on Windows Environment and managing the database using Microsoft SQL Server Management Studio.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experienced in using T-SQL in SQL Server 2012, 2008 and 2005 platform
• Experienced in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• In-depth knowledge of Transact-SQL (DDL, DML, DCL) and design and normalization of the database tables.
• Extensive knowledge in tuning T-SQL queries and improving database performance.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance
• Experience in working with databases like Oracle and Access.
• Proficient with creating Use Cases, Sequence Diagrams, Component Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Excellent communication, presentation and interpersonal skills.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Developed Reports using efficient data retrieval techniques
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Strong communication skills when working with stakeholders, developers, project managers, system implementers, and application end-users.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, SQL Server Configuration Manager, Database Engine Tuning, Dynamic Management Views and Functions

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

Productivity Applications: MS Word, MS Excel, MS Access, MS Project

ETL: SQL Server Integration services

Programming Languages: TSQL, PL/SQL, C#

Operating Systems: Windows Vista Business/Ultimate, Windows 7 Ultimate, Windows 10

DBA Tools: Import/Export, SQL Loader, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, Team Foundation System (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, NYC, New York

SQL server developer

Responsibilities:

• Worked in Software Development Life Cycle (SDLC) phases including Analysis, Design, Implementation, Testing and Maintenance.
• Update procedures, functions, triggers and packages.
• Write T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented complex business logic with Store procedures, User Defined Functions, Views and write T-SQL batches with CTE (Common Table Expressions) for recursive operations.
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse.
• Develop code on Teradata SQL Assistant
• Wrote complex T-SQL queries for reporting and data extraction from SQL 2005/2008 Server and WonderWare system.
• Developed and scheduled DTS packages for each system Interface using SQL code in combination with VB ActiveX scripts and built-in DTS transformations.
• Creating Power BI dashboards to showcase data freshness and user details.
• Set-up Enterprise Gateway and SSAS Connector on Azure VM for POWER BI Report Deployments.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio(BIDS) and Visual studio 2008.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Created SSIS projects to move data between environments using AWS S3
• Implemented migration on premises data repository and data loads (MS SQL Server, SSIS) to AWS RDS (MySQL, MS SQL), AWS Redshift using DMS, AWS data pipelines, Firehouse.
• Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports.
• Using Azure server for maintaining data to perform SSIS packages and SSRS reports.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET and C#.
• Responsible for Developing GUI Screens using ASP.Net and C#
• Wrote custom tasks using C# within SSIS to enhance processing of both Excel and flat-files into SQL Server
• Work on creating Team projects for Reporting and Integration using TFS.
• Scheduling and monitoring the ETL packages.
• Involved in performing migration of DTS packages to SSIS packages.
• Optimized Complex queries using Indexes and execution plan. Implemented normalization techniques on different database.
• Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.
• Work with testing teams; perform UAT testing with business users.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Environment: MS SQL Server 2014, R2/2010, Data warehouse, Azure, Wonderware, TFS 2010, MS Visual Studios 2008, SSRS 2012, SSIS 2012, SSAS 2012, ETL, SSMS, T-SQL, IWAR, Teradata SQL Assistant.

Confidential, Columbia, MD

MSBI Developer

Responsibilities:

• Coordinate with offshore development team, assign them tasks and help with any technical queries.
• Enable dynamic logging of package run into a text file.
• Enable error handling strategy i.e. transaction isolation to help rollback of transaction when package fails.
• Enable auditing of package and underlying expensive tasks into a database table, to help in performance tuning.
• Designed and developed reports with Cross-Tab, Drill Down, Drill Through, Cascading Parameter, and Sub-report using SQL Server Reporting Services (SSRS) 2012/2008 for claims, providers and membership related data.
• Created SSIS packages to load data into RHI SQL server from WellPoint’s data warehouse.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Developed Aggregations, partitions and calculated members for SSAS cube as per business requirements.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power Pivot, Power Query, Power View & Power BI.
• Creating Power BI dashboards to showcase data freshness and user details.
• Set-up Enterprise Gateway and SSAS Connector on Azure VM for POWER BI Report Deployments.
• Experience in Database design, Development, Data Modeling, Administration, ETL packages using DTS / SSAS, Performance Tuning, Stored Procedures for Database applications using MS SQL Server 2012, 2008 R2, 2008, 2005
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services(SSAS).
• Lead the team by Analysed, troubleshot and resolved complex production application defects.
• Identified root cause, devised and implemented permanent solutions to recurring defects.
• Monitored production jobs and environments, performed in-depth data and systems analysis.
• Devised or modified programs to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results.
• Created report snapshots to improve the performance of SSRS.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Use TFS (Team foundation server) source control tool to check in all the code on daily basis.
• Use waterfall SDLC process.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS 2008/2012. Extensively worked in sorting the data, defining subtotals for the reports
• Worked in SDLC (Systems Development Life Cycle) for developing systems/Software.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Tested the application for deployment, Function and behavior

Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services 2008/2012, SQL Server Analysis Services, Index Tuning Wizard, SDLC, Data Warehousing, Data Transformation Services (DTS).

Confidential, Long Beach CA

MS Business Intelligence Developer

Responsibilities:

• Created SSIS packages to clean and load data to data warehouse.
• Created SSIS Packages using Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Specialized in developing BI Solutions, worked with the full BI Stack, developed reports with SSRS and Power BI, and used SSIS for transforming data and data movement across systems, analyzed data using SSAS.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Created report models and deployed on report server.
• Created report snapshots for better performance.
• Provided knowledge transfer to the company’s SQL programmers.
• Created and tuned stored procedures, triggers and tables.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Created views by vertical partitions of tables.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

SQL Developer

Confidential

Responsibilities:

• Involved in analysis, design and development of large databases to solve complex business problems.
• Design of the Database and the Tables and built table relationships.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Wrote complex SQL statements using joins, sub queries and correlated sub queries.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL Joins for applications.
• Developed SQL procedures, functions, packages and triggers for building customized code in SQL Navigator.
• Optimized query performance by creating indexes.
• Enhancing and deploying the SSIS packages from development server to production server and scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Worked with various SSIS packages which involve Transactions, restart ability and roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Loaded the data from the source flat files and RDBMS tables to target tables meeting the user business requirements and business rules using the SQL Loader.
• Created Queries for generating drill down reports in SSRS 2005.
• Created Condition Objects in the Universe to restrict data
• Created simple SQL query filters, prompted filters and complex filters to restrict data in reports.
• Created report in SQL Server 2005 and deployed them on local-host for remote access.
• Created several stored procedures, triggers, views.
• Tuned many ad-hoc queries and stored procedures, by creating indexes, making proper joins.

Environment: MS SQL Server2005, SSRS, SSIS, SSAS, T-SQL, Asp.net, .NET, Stored Procedures.

SQL BI Developer

Confidential

Responsibilities:

• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Modified existing SSIS packages to meet current business needs.
• Wrote stored procedures to be used in the SSIS packages.
• Created custom and Ad hoc reports using SSRS.
• Extract, transform and load (ETL) the data from source applications systems into the data warehouse.
• Generated different types of Reports like Tabular, Matrix, Charts, Drill Down and Drill Through reports using SSRS.
• Deployed reports, created report schedules, subscriptions, securing reports.
• Identified the Data Source and defining them to build the Data Source Views.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Responsible for developing Stored Procedures, Triggers, Views and User defined functions.
• Made Efficient use of Joins and sub-queries in queries that involve data from multiple tables.
• Fine tuning of stored procedures to improve the performance.
• Performed Performance tuning on SQL queries, triggers and stored procedures. Used Audit functions to keep track of the changes made to the database.
• Had to modify the current stored procedures to meet the current design.
• Responsible for creating indexed views, and appropriate indexes to cut the complex query time.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Wrote T- SQL queries for data retrieval.
• Took part in the normalization and de-normalization of database.

Environment: SQL Server 2005, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2005 and Team Foundation Server.