SUMMARY

• Around 7 years of IT experience as MS - SQL Server Developer, involved in Design, Development and Support of MS SQL Server 2005/2008/2008 r2/2014,2016.
• Proficient in Relational Database Management Systems (RDBMS).
• Strong knowledge in Sybase ASE database programming using T-SQL Stored Procedures, Built in Functions, Triggers, Cursors etc.
• Experienced with creating IT solutions for a large inventory of SQL Servers using technologies such as high availability clusters, Always-On, Mirroring, Log-Shipping and Replication.
• Expertise experience in installation and configuration of SQL 2016/2014/2012/2008/2005/2000 SQL Server database services.
• Working experience in testing SQL server 2016 new features like Availability group failover when there are drive issue.
• Expertise experience in database Performance tuning, query optimization using DMV’s and DMF’s.
• Expertise Experience in building complex SSIS and DTS packages using Business Intelligence Development Studio.
• Experience in SQL Server Database partitioning on very large databases (VLDB’s).
• Expertise experience in Data scrubbing using TSQL(Optima and TDM)
• Expertise experience in handling level-one, mission critical applications.
• Experience with on-call problem resolution and triage in SQL Server environments.
• Experience in working with teams such as Infrastructure, Storage, Networking, Development and QA.
• Developed, maintained, and published the Standard Operating Procedures (SOP) for Close Support, Engineering, and Application & Web Development on SharePoint
• Been an active team member and has worked on developing utilities using C, SYBASE, ORACLE PL/SQL, with UNIX PERL, UNIX Shell Scripting.
• Very good understanding of Partition, Indexing and Optimization Goals of Sybase 15x.
• Good Work experience of Embedded SQL and C Sybase Open servers and remote Procedures.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Extensive experience in SQL Server Database Architecture, Performance tuning, Performance Monitor, Plan assessment andSQL scripts.
• Proficient in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS and BCP.
• Excellent in High level Design of SSIS packages for Integration and Migration of data from heterogeneous sources like Flat files, Excel, CSV, Text Format Data, and Oracle to MS SQL Server.
• Hands on experience in trouble shooting database issues.
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
• Expert in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Ad-Hoc, Drill down, Drill Through, Parameterized, Matrix, Chart, Cascading, Table and sub reports based on Relational and OLAP databases
• Excellent SQL Server administration skills including User Authorizations, Database Creation, Tables, Indexes and Clusters creation
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule ETL Packages.
• Worked extensively on all facets of the project (Complete SDLC).
• Experience in Software development methodologies such as Agile, Scrum and RUP models.

TECHNICAL SKILLS

Databases: SQL Server 2016/2014/2008 R2/2008/2005, Oracle 11g/10g/9i, PostgreSQL 9.3, Sybase 15x.

Platforms: Windows Server 2008/2003/2000/ NT, UNIX, WAMPSERVER 2.0, Apache 2.2.

Reporting Tools: SSRS, Crystal Reports

Languages/Utilities: SQL, T-SQL, PL/SQL, VB, VB.NET, C, C#, ASP.NET, PL/pgSQL

Tools: Visual Studio 2003/2005/2008 , BCP, BIDS, SSMS, SQLCMD, DTA, Profiler, SQL Agent, MS VISIO, ERWin 4.1/7.0

Web Technologies: HTML, DHTML, XML, CSS, SharePoint

ETL Tools: SSIS/DTS, Crystal Reports.

Version Control: VSS, TFS, SVN

Microsoft Office Applications: Excel, Word, Access, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential - Webster, NY

SQL BI Developer

Responsibilities:

• Developed complex data extracts and ad-hoc queries as requested by internal and external clients using SQL and SSIS.
• Developed complex mappings using SSIS to transform and load data received from clients into the central repository.
• Used various SSIS tasks such as Conditional Split, Derived Column, script task using visual basic which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Databases.
• Enabled Check points in SSIS package. Created break points to view the status of data, variables and over all status of SSIS package.
• Created stored procedures to retrieve data periodically that was used in SSIS and SSRS.
• Elicited requirements and generated ad-hoc and custom reports for executive reporting and business analysis using SQL Server Reporting Services (SSRS).
• Worked on configuring Open SSL on MySQL Database 5.6 and configuring TDS on MySQL Database version 5.7
• Responsible for administration and supportingoracle12c, 11g, 10g and 9i databases
• Performance tuning of applications and the databasesOracle11g/10g
• Build and managed 2-node RAC Cluster on Linux.
• Build Data Guard for RAC Cluster and setup Disaster Recovery site.
• Documented procedures and provided training to Jr. DBAs.
• Proactive database monitoring using 11g grid monitoring tool.
• InstallOraclesupplied tools to assist in database and SQL Tuning like SQLT and remove unnecessary histograms in highly volatile schemas.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Database dot release upgrades usingoracleuniversal installer and catpatch.sql.
• Applied various recovery scenarios for complete and incomplete recovery in case of failure
• Monitored data files, logical data storage and data growth activities
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Worked with offshore DBAs and coordinated with releases and deployment.
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call pager support for mission critical financial databases.

Environment: SQL BI, SQL DBA, SQLT, catpatch.sql, oracle12c, Unix, Buffer Cache, Redo Log Buffer

Confidential - Bridgewater, NJ

SQL BI Developer/ SQL Server DBA

Responsibilities:

• Involved in requirements gathering and participated in all phases of development life cycle.
• Determined the technical requirements of the project and came up with the architecture design. Played a key role in designing the database and created the required entities, attributes and relationships between database objects.
• Created stored procedures, triggers, user defined functions, views, indexes etc.
• Installed, configured and administered SQL Servers on IAAS - Infrastructure as A Service on Microsoft Cloud Environment.
• Installed, configured and maintained high available solutions such as Database Mirroring, Always-on, Replication, and Log Shipping.
• Installed, configured, and administered SQL Server Reporting Services (SSRS) for different purposes like DBA Reports, and user reports using SSRS.
• Developed stored procedures and scripts for automation of several daily maintenance tasks, monitor critical database alerts, monitor any blocking process for more than 3 minutes.
• Implemented partitioning on very large databases (VLDB’s) to improve data archiving process.
• Implemented Transparent Data Encryption on level one database which contains sensitive customer information.
• Monitored and tuned the performance of complex T-SQL queries and stored procedures by analyzing the execution plan.
• Created Cross-Tab report (Grid report), Mailing Label report, Blank report, Sub report, OLAB cube report.
• Exported reports to different format as (Excel, word, PDF, database, RTF, text, and CSV). ETL concepts.
• Understand, evaluate and implement tools and trends in database systems administration.
• Develop and implement core Sybase databases including ASE 12.5 and 15.
• Maintain and manage backup, recovery, storage and user administration.
• Assist and support in production installations of various ASE releases.
• Designed ETL packages dealing with different data sources (Oracle, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created and deployed various reports like ad-hoc reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Responsible for maintaining existing SSRS reports, developed and deployed different types of customer facing reports like matrix, drill down, sub reports, drill through, chart etc.
• Developed process using tools such as AZ Copy to transfer data between different subscriptions and containers on Microsoft Cloud Environment. Process also included data transfer between on-premise and cloud.
• Used dynamic management views and dynamic management functions as well as DBCC to check database conditions, fix database corruption, rebuild indexes.
• Supported lease replacements of SQL Servers which included identifying servers coming out of lease, providing specifications for provisioning of new servers and migrating databases to new servers.
• Used application like Data Masker for data scrambling, which helped to back up the database and restored in UAT
• Supported monthly SQL server patch process which included patching SQL servers with latest service pack and time sensitive security patches. Provided user support during post patch validation of the databases and applications
• Involved in preparing training document for application development and QA/UAT teams.

Environment: MS SQL Server 2008 R2/2014, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Oracle, PostgreSQL, MS Excel, DBSchema

Confidential - Cerritos, CA

SQL BI Developer

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Text files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup etc.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
• Created and deployed various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment.
• Promoted database objects from test/development to production. Coordinated and communicated production schedules within development team
• Involved in preparing training document for application development and QA/UAT teams.
• Actively involved in agile development methodology.

Environment: MS SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MS Access 2007, XML, MS Excel, Erwin 3.5.2, MS-Visio 11.0.

Confidential

SQL Developer

Responsibilities:

• Migrated SSIS packages from R2, Developed and deployed new packages.
• Migrated SSRS reports from R2.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in 3 environments (Development, QA and Production).
• Involved in testing SSIS packages in QA environment.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup etc.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
• Providing design, development, and testing support to assigned application teams.
• Installing SQL Server products; managed patching and compliance issues.
• Maintaining Transactional SQL Replication between source and target SQL Server databases.
• Involved in migration of SQL Databases using Migration Utility.
• Setting up linked servers between SQL and DB2 data sources.
• Configured SQL Mail where in the SQL Server will send notification through a page on failure of a job on production and email on non-production environments.
• Worked on data modeling projects from starting to finishing, generated scripts for objects, Developed Relationship, and created E-R Diagram using ERWIN.
• Export & Import data from Flat file, CSV file to/from SQL Server databases using DTS, and BCP
• Monitored Database Backup and other jobs in the maintenance plan Restoration and Point-in-Time Recovery.Scheduling of operation and outages.
• Creating, modifying and managing tables, Index, Constraints, Views, Stored Procedures, and Triggers.
• Optimized long running Stored Procedures for effective data retrieval.
• Created and deployed various reports like ad-hoc reports, Crystal Reports, simple and parameterized reports using SQL Server Reporting services (SSRS).
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Responsible for scheduling jobs, Alerting and maintaining SSIS packages.
• Promoted database objects from test/development to production. Coordinated and communicated production schedules within development team
• Involved in preparing training document for application development and QA/UAT teams.
• Prepared documentation for the disaster recovery plan.

Environment: MS SQL Server 2005/2008 R2, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Oracle, Teradata, MS Access 2007, XML, MS Excel, Erwin 3.5.2, MS-Visio 11.0.