SUMMARY:

• 3 years of IT experience in SQL Server Database Administration, Design, System Analysis, Testing, Development and Support of MS SQL Server 2014/2012/2008 R2/2008/2005 in PRODUCTION and DEVELOPMENT Environments
• Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Data Transformation Services and Database Security.
• Generated Transact SQL (T - SQL) Quires, Sub quires, Co-related sub quires and Dynamic SQL quires and Creating Tables.
• Programming in SQL Server using the indexes, stored procedures, views, triggers and user defined functions and Common Table Expressions (CTEs).
• Expert in Implementing High Availability Solutions such as for Log Shipping, Mirroring and Replication (Snapshot & Transactional) in MS SQL Server Environments
• Experiences in troubleshooting issue, Performance Tuning using SQL Servers for Index Fragmentation, Query Plans, and Deadlocks.
• Highly proficient in high-level design and develop of ETL SSIS and DTS packages for integrating data from heterogeneous sources (Excel, flat file, Text Format Data) to MS SQL Server.
• Experience in MS SQL Server Migration from SQL Server 2000 to SQL Server 2005 and SQL server 2005 to SQL server 2008 by creating ETL package from Scratch.
• Worked on SSRS to create Tabular, Matrix, Drill down and Drill through Reports using SQL BI 2005, 2008 and 2014.
• Worked on SSRS Report Model project for ad-hoc query so user can create their own version of reports using Report Builder application.
• Created SSRS reporting security so end user only access specific reports and report model which they intend to.
• Experience in Data legacy mart.
• Experience in creating Jobs, Alerts on SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Good understanding of Normalization/De-normalization, Normal Form and database design methodology.
• Experience in creation of logins, users and configuring permissions and assigning roles to users.
• Worked in Clustering environment and configured SQL server cluster groups as a High Availability Solution
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in management of Database Space, Growth Monitoring of Data & Transaction log files.
• Strong troubleshooting and organizational skill, independent, self-managing and teamwork.

TECHNICAL SKILLS:

Operating System: Windows 10/8/7, Windows Server 2003/2008/2012

Languages: MS SQL Server 2005/2000/2008/2012/2014 , T-SQL, PL/SQL

Databases: MS SQL SERVER 2012/2008/2005 MS Access, Excel

Database Tools: T-SQL, MS Enterprise manager, SQL profiler, Query Analyzer, OLTP, DBCC, BPC, SQLCMD, SQL Agent, MS DTS (export and import), Index Analyzer, DTS Backup Server, SQL Alerts, SQL Jobs, Microsoft office

Development Tools: DTS, SSIS, SSAS, SSRS

Modeling Tools: Microsoft Visio, DB Designer, Front Page, Erwin

Other Tools: MS Office 2013/2007/2003/2000/ XP, MS Outlook 97/2000/2013

PROFESSIONAL EXPERIENCE:

Confidential, Long Island

SQL Server Developer/ BI Developer

Roles and Responsibilities:

• Exhaustive experience in Data Extraction, Transforming, and Loading (ETL) using SSIS package in MS SQL Server 2008r2, Import/Export data, Bulk insert and BCP.
• Developed Triggers, Stored Procedures, Views and Functions for the custom database objects using SQL Server 2008r2
• Created Stored Procedures and functions, and experienced in writing high performance code.
• Created physical and logical structure of the new data warehouse (SQL database) and process workflow by using MS Visio 2007.
• Experience in creating SSIS packages using different type of task, with Error Handling on the control flow task and dataflow task, use logging to log the events and Worked on package configuration to run package in different server.
• Used different transformation like Pivot Transformation, Look up, Conditional Split, Data Conversion, Aggregation, Merge Join, Union, Union all, Multicast< Sort, OLE DB command, Fuzzy Lookup and Derived Columns, to export cleansed data from SQL Server 2005, Excel Spreadsheets, Text files and CSV files to data warehouse.
• Used Sequence Container, Execute SQL Task, Send Mail Task, Precedence Constraint, Script Task to achieve business requirement in the control flow.
• Developed the Slowly Changing Transformation to maintain The Historical Data.
• Experience in Delta Load for Data Warehouse after finish initially process full load using ETL process.
• Designed Data model for Data Warehouse (Logical and Physical model) using Star Schema.
• Created configuration files in order to deploy packages in different environments.
• Created various ETL Packages to load data from transactional system DB2 to staging (ODS) and staging to Enterprise Data-warehouse.
• Experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data.
• Created Matrix reports, Tabular Reports, Parameterized Reports, Drill down and Drill Through for various applications.
• Generating Couple of Report in Power BI Tool like geographical Report.

Environment: MS SQL Server 2005/2008r2, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting service 2005/2008r2, MS SQL Server Analysis Service 2005/2008r2, MS Access, MS Excel, MS Visio 2007, and T-SQL.

Confidential

MS SQL Server Developer

Roles and Responsibilities:

• Gathered requirements from the business users
• Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules
• Designed and implemented Stored Procedures and Triggers for automating tasks
• Managed all indexing, debugging, optimization and performance tuning using T-SQL
• Wrote T-SQL queries, Store Procedures and used them to build packages
• Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse
• Created configuration packages in SSIS to move the package from development server to production server
• Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS
• Installed MS SQL Server and Management tools using MS SQL Server Setup Program
• Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server
• Run and tested required queries and reports before publishing
• Published the reports and scheduled the reports in different formats (Email, Public folder)
• Scheduled the reports on different servers to run on daily/weekly monthly basis and email the results to the business users in the required format.
• Scheduled tasks to run every day to update changes in the base tables

Environment: MS SQL Server 2008, SSRS, SSIS, SSMS, T-SQL, Access and Excel

Confidential

Jr. SQL Developer / DBA

Roles and Responsibilities:

• Created database objects such as tables, procedures, triggers, indexes and views
• Developed processes, automation of maintenance jobs, tuning SQL Server, administered SQL Server security and SQL Server automatic e-mail notification
• Worked on project planning, scheduling for database module with project manager
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions
• Tested to optimize the procedures and queries to be used in production
• Helped analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements
• Configured replication servers and transactional replication between production and standby server for disaster recovery
• Did performance tuning to optimize the SQL queries using query analyzer
• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Responsible routine DBA jobs like Backups and Restores
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Monitored and modified Performance using execution plans and Index tuning

Environment: MS SQL Server 2005/2008, T-SQL, DTS, Windows 2003 Server,