PROFESSIONAL SUMMARY:

• Around 7+ years of experience in SQL Server Database Administration, Design, System Analysis, Testing, Development and Support of MS SQL Server 2016/2014/2012/2008 in Production and Development Environments.
• Having 6years of experience in Microsoft Business Intelligence Tools (SSIS, SSRS &SSAS).Experience working with MS SQL Server 2016/2014/2012 versions. Hands on experience in SQL Server, SSIS (SQL Server Integration Service) package design, constructing, and deployment.
• Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.
• Safeguarding data by instilling backup, managing user access and securing databases.
• Responsible for day to day tasks like re - indexing, checking integrity, backup and recovery.
• Regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, and block monitoring and troubleshoot using SEM (SQL Enterprise Manager). Installed and configured Microsoft Windows Clustering and SQL Server Clustering on Windows 2003 Server.
• Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc as requirement on SQL Server Environments.
• In-depth knowledge of Transact-SQL Server Architecture and Data Modeling techniques.
• Proficient in creating Tables, Indexes, Joins, Triggers, Views, Stored Procedures, Partitions, User Defined Data Types and Functions.
• Experienced in Sub-queries, CTE’s, Table Variables, Try/Catch blocks and Temp Tables.
• Extensive experience in database Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Dynamic Management Views, Resource Governor and Extended Events.
• Disaster Recovery planning and implementation - Database mirroring, Log shipping, Replication and Active Passive clustering.
• Experienced in creating OLAP cubes defining the dimensions and relationship between dimensions and measure groups.
• Having Knowledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
• Good knowledge on Subqueries, Joins, set operations and stored procedures.
• Excellent grasp of Data Warehousing Procedures including SCD and CDC.
• Excellent communication skills, organizing skills, highly punctual and an excellent listener.
• Extensive experience in Data Extraction and Transforming and Loading (ETL), Import/Export data, Bulk insert, package parameters and variables, Change Data Capture and custom C# and VB.net tasks
• Expert in SSIS Source Controls, Package and Project Deployment Models and SSIS Expression Language
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting.
• Experience in developing Custom Reports and using SQL Server Reporting Services (SSRS) and deploying them in Report Builder, Report Manager and Power View with SharePoint Integrated Mode.
• Expertise in data mining, analytics, predictive modeling, and business process modeling, ROLAP, MOLAP and proactive caching.
• Having a good Experience in Designing and Developing the SQL Server Integration Services-SSIS with Different Control Flow Tasks and Data Flow Transformations Securing Packages and Deploying Packages.
• Expert in creation of tables, views, triggers, stored procedures and functions using SQL (Structured Query Language) and T-SQL (Transact-SQL).
• Assisted on the Adhoc-Query requests based on the requirement by using Joins, Sub Queries and Co-Related Sub Queries.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas,snowflakes, Dimension and Fact Table.
• Knowledge on, dimensional modeling, reporting tools and implementing ETL Type 1, Type 2 Techniques.
• Designing of Security - Active Directory Groups, Roles, User.
• Experience in supporting Very Large Databases (VLDB).
• Expert in implementing high availability features ofSQL server solutions, including Logshipping, Replication, Mirroring and Cluster Environment.
• Experience in Logical and Physical Database Design and Capacity Planning.
• Experience in Automation of Schedule Maintenance jobs and defining Alerts.
• Experience in implementing Table Partitioning, CDS and Encryption features.
• Great ability to create and manage various database objects liketables, views.

TECHNICAL SKILLS:

Operating systems: Windows7, Windows8, Win2003 Server Android, iOS

Programing Languages: T-SQL, C, C++,C#, PL/SQL, XML,HTML,java

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services(DTS)

Databases: MS SQL Server 2008/2012/2016 and, MS-Access 2000/2003

SQL Server Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, Import & Export, Visual Studio Net

Web Technologies: HTML, XML,XPATH

Relational Databases: MS-SQL Server 2016/2012/2008

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

MS SQL Server /BI Developer

Responsibilities:

• Worked on Data migration using SSIS from Flat Files.
• Worked on ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load and Analyzed the Project requirement and preparing the documentation for the ETL Package Flow.
• Worked on ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL Job Scheduled to run daily, weekly and monthly. Solved the issues associated with ETL Data Warehouse Failure.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like lookup, merge, merge join, script component and slowly changing dimension.
• Developed, monitored and deployed SSIS packages and Responsible for Scheduling Jobs, Alerting and Maintaining SSIS Packages.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column, Row Countetc.
• Designed SSIS Management Framework to monitoring, auditing and configurations and to track package failure and durations, so developer can solve issue accordingly.
• Implemented Data Transformation Services Packages in SQL Server Integration Services (SSIS) for transferring data and Data Loads.
• Interacted with the Business Users to analyze the Business process and gathered the requirements & provided documentation for all kinds of reports, DTS and SSIS packages.
• Wrote complex SQL queries using joins, stored procedures, and user defined functions to verify the data from the database to generate reports based on the business requirement.
• Utilized SSRS reports from different source formats satisfying clients by representing reports and presentations.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized report, ad-Hoc and parameterized reports using SQL server 2005/2008 R2 reporting Services.
• Responsible for Monitoring and Tuning Report performance.
• Worked on various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Script Component, Merge and Lookup while loading the data into Destination.

Environment: Integration Services (SSIS) T-SQL,SQL Server 2016,2014, 2012,Windows Server 2010,2008,2003, BIDS, T-SQL, Office 2013, 2010, 2007, 2003, OS 8/7/XP, XML, MS Excel, MS Access, MS visual Studio, BIDS.

Confidential, Hartford, CT

MS SQL Server/BI Developer

Responsibilities:

• Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2008R2.
• Configured SSIS packages using Package configuration wizard to allow Packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Coordinate with business users in gathering business requirements and translating them to technical specifications.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Create Different types of reports based on customer Request.
• Create Sub Reports and Drill-Through Reports and developer them to share Point Server.
• Working on performance tuning to Test the Query Execution.
• Created Ad-hoc Reports, Sub Reports, Drill-Through and Drill-Down Reports.
• Data migration using DTS services across different databases like Oracle, MS access 2003 and Flat Files.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Exposure in using Team Foundation Server as a source control, source repository and project tracking solution.
• Created Datasets inT-SQL, stored procedures forSSRS.
• Created Reports in SSRSwith different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Created Dashboards in SSRS2008.

Environment: Microsoft SQL Server 2008R2, Visual Studio 2008, Visual Studio 2005, T-SQL, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, MS Word, Ex-cell.

Confidential, Greensboro, NC

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

• Designed logical and physical data models SQL and created DDL scripts like tables, views, stored procedures, UDF and partitions.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the data Created Global Variables, Stored Procedures, Triggers, User-defined Functions, partitions and Views for both Online and Batch requests handling business logic and functionality of various modules.
• Migrated existing databases from SQL2008 to SQL2012 and created database snapshots from reporting purposes.
• Responsible for Deploying the SSIS packages into production and scheduling the package through Jobs, setting the Configuration files and created technical specs documents for all the enhancements.
• Developed programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Implemented Event Handlers and Error Handling in SSIS packages and notification framework.
• Worked on various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Automated daily administrative tasks like database backup and recovery using SQL Server Agent
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.
• Integrated database structure and data warehouse layers to supporting web services and web applications

Environment: SQL Server 2012, T-SQL, SSIS, SSRS, SSAS, Agile Scrum Methodology, Windows server 2012, Microsoft TFS, Power View, MS Office.

Confidential, Overland Park, KS

T-SQL Server Developer/SSAS Developer

Responsibilities:

• Designed logical and physical data models SQL and created DDL scripts like tables, views, stored procedures, UDF and partitions.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the data Created Global Variables, Stored Procedures, Triggers, User-defined Functions, partitions and Views for both Online and Batch requests handling business logic and functionality of various modules.
• Migrated existing databases from SQL2008 to SQL2012 and created database snapshots from reporting purposes.
• Responsible for Deploying the SSIS packages into production and scheduling the package through Jobs, setting the Configuration files and created technical specs documents for all the enhancements.
• Developed programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Implemented Event Handlers and Error Handling in SSIS packages and notification framework.
• Worked on various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Automated daily administrative tasks like database backup and recovery using SQL Server Agent
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.
• Integrated database structure and data warehouse layers to supporting web services and web applications
• Created Power View ad-hoc reports in SharePoint and used BI Semantic Model Connection File.

Environment: SQL Server 2012, T-SQL, SSIS, SSRS, SSAS, BCP, Agile Scrum Methodology, Windows server 2012, PowerShell, Microsoft TFS, Power View, SharePoint, MS Office.

Confidential

Junior Data Base Administrator

Responsibilities:

• DevelopedSQL scripts to Insert, Update and Deletedata in SQL database tables.
• Involved in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client-server environments.
• Creation of tables, views, triggers, stored procedures and functions using SQL (Structured Query Language) and T-SQL (Transact-SQL).
• Implemented Database Replication (Merge and Transactional).
• Created backup schedule for production, test and development servers.
• Creating databases and logins with permissions in SQL Server as per the developer’s request.
• CreatedViewsto enforce security and data customization.
• Created StoredProceduresfor commonly used complex queries involving join and union of multiple tables.
• CreatedNon-Clustered indexesto improve query performance and query optimization.