SUMMARY:

• SDLC: 8+ years of Software Industry experience in various phases of projects such as Requirement analysis, Design, Development, Testing and Deployment.
• DATABASE: 7+ years of work experience on various RDBMS Technologies - SQL Server 2016/2014/2012/2008 R2/2005/2000, Oracle 9i.
• Experience in database designing with the use of various database Objects Tables, Views, Indexes, Stored Procedures, Cursors, Functions, types and Triggers for back end development.
• Proficient in Installing & configuring SQL Server 2005/2008R 2/2012/2014/2016 per best practices.
• Solid experience in designing SSIS Packages to implement complex business logic. Experience in working with heterogeneous sources like CSV, Fixed Width, Oracle, MS-Access, EXCEL, Flat File, XML
• Experience in SQL Server Administration tasks including backup/restore, database maintenance, migration, replication, user authorizations, Index maintenance.
• Experience in setting up SQL Server databases on Virtualized Environment using best practices.
• Experience in measuring and troubleshooting SQL Server Performance through detailed performance matrix.
• Experience in Planning and performing Data Center Migration.
• Experience in performing database health check and disaster recovery.
• Experience in managing WSFC and FCI to support HA.
• Possessing clear understanding of fundamentals of RDBMS and Database Internals.
• Experience in configuring and maintaining SSISDB/IntegrationServiceCatalog per best practices.
• Experience in implementing & using complex database features like Extended Events.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Experience in correcting poorly performing queries and stored procedures and have in-depth knowledge of utilizing performance tools like SQL profiler, Extended Events, DBCC commands.
• Experience in migration process from Development to Test and Production Environments using Red Gate and TFS.
• Experience in using naming conventions and documenting the project flow.
• A self-motivated professional, fast learner, good team player and natural communicator possessing excellent analytical, problem solving, and communication skills.

TECHNICAL SKILLS: Languages:  PL/SQL, T-SQL, Power Shell, Core Java, C, C++, XML/XQuery

DBMS-RDBMS:  SQL Server 2016/2014/2012/2008 R2/2005, Oracle 9i, MS Access

DW/DB Tools:  SSIS, SSMS,SSRS, SSAS, SQL Server Profiler, BIDS, Import-Export Wizard, Bulk Copy Program (BCP), MS- Visio 2007, SQL Sentry, Extended Events, Profiler

System Design & Development:  Requirements Gathering and Analysis, Data Analysis, ETL Design, Reporting Environment Design, Development, UAT, Implementation and Deployment, Client-Server DevelopmentPROFESSIONAL EXPERIENCE:

Confidential, SOUTH WINDSOR, CT

Database Administrator

Responsibilities:

• Experience in database modeling process including relational modeling, dimensional modeling using various designing schema like star, snowflake
• Experience in installing and maintaining SQL SERVER 2005/2008R 2/2012/2014/2016 .
• Experience in virtualization of Database Server using best practices.
• Experience in database server performance tuning and resource analysis using various performance matrix and perfMon Counters and Extended Events.
• Install & Configure SQL Server as per latest standards and best practices.
• Provide HA/DR Solutions via Backup/Restore,  Replication, AOAG.
• Perform routine database maintenance to ensure efficiency and integrity.   
• Apply best security practices.
• Experience in managing WSFC and FCI in Active-Passive Cluster.
• Provide ETL Solutions using various technologies like SSIS, BCP and Linked Server.
• Perform health check of database of servers on daily basis.
• Regularly upgrade/update database servers to the latest stable version and Implement new features using best practices.
• Successfully performed multiple server migration during Data Center Migration.
• Used SQL Server profiler traces to analyze some performance issue and to identify unused objects.
• Created and maintained mail profile and accounts to support database mail feature.
• Created and maintained complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
• Created and maintained Parameterized SSIS Packages via Environment Variables to automate ETL processes.
• Used execution plan and index usage statics to optimize slow running stored procedures.
• Used SQL Server profile traces to analyze some performance issue and to identify unused objects.
• Reconstructed the indexes to improve overall performance and keep database in healthy condition.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and extended events.

Environment: MS SQL Server 2016/2014/2012/2008 R2/2005, MS-Excel, SSIS, SSMS, Windows7, Windows Server 2003/2008/2012 , VMWare VSphere 5.1-5.5, SQL Compare 8-11, Visual Studio 2012/2015, Team Foundation Server, SolarWinds, SentryOne

Confidential,NJ

Programmer Analyst

Responsibilities:

• Interacted with the business community to identify the Business requirements and data realties.
• Involved in translating business requirements into technical requirements.
• Involved in each phase of SDLC including design, development, testing and deployment.
• Implement business logic into software using sql server and asp.net
• Provide support and enhance the existing applications.
• Involved into migrating application code to production.
• Involved into documenting technical details for future use.
• Participate into weekly meetings and scrum meetings to verify the project status.

Environment: SQL Server 2005, Asp .Net, MS-outlook, Windows XP/2003, Tortoise SVN

Confidential, NYC

Database Developer

Responsibilities:

• Interacted with the business community to identify the Business requirements and data realties.
• Performed logical & physical data modeling primarily using entity-relationship (E-R) format for the application.
• Involved in database modeling process including relational modeling, dimensional modeling using various designing schema like star, snowflake
• Involved in database development, modification, normalization to effectively maintain databases.
• Created and maintained indexes (Clustered, Non-clustered) & constraints (PK, FK) on database.
• Created SSIS package to load data from heterogeneous sources and massage in staging area using various transformations like Derived Columns, Condition Split, Fuzzy Lookup, Aggregate, Merge Join, Pivot Transformation, and Slowly Changing Dimension.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies of the Cube.
• Used Error handling and Error logging techniques to capture error in the SSIS packages into the table for analysis purpose.
• Used checkpoint files to automate the restarting process from the point of failure up to some extent.
• Experience with various database optimization techniques like update statistic, rebuilding/reorganizing indexes, re-structuring the indexes.
• Created windows batch files to automate some ad-hoc requirements.
• Developed Views and Materialized Views to accomplish complex reporting requirement.
• Dropped and recreated the indices on tables during incremental loading for performance improvements.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Performance tuning of Queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Used Bulk Insert utility to perform ETL for fixed width flat files using format file.
• Used query design wizard, SQL Views, Design view to perform SQL Operations in MS-Access databases.
• Involved in technical and non-technical documentation for the database.
• Participated in weekly walkthrough & inspection scrum meetings to verify the project status.

Environment: MS SQL Server 2005/2008, Flat files, MS-Access, ARCGIS, MS-Excel, SSIS, SSMS SSRS, VB.Net, VB Script, Window XP, XML

Confidential, NJ

Data Analyst 

Responsibilities:

• Involved in translating business requirements to integrate into existing datamart design.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries
• Involved in database design process and data modeling process using Microsoft Visio.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc based on the requirements.
• Provide business intelligence through various data analysis methodology.
• Performing regular database backups and tuning.
• Involved into documenting technical details for future use.
• Used SSIS Logs and audit transformation in order to debug and keep track of ETL Jobs.
• Worked with different methods of logging in SSIS.

Environment: SQL Server 2005, Flat Files, SSIS, SSRS, Microsoft Visio-2007, WebServices Windows XP

Confidential, NYC

Test Automation Analyst 

Responsibilities:

• Conduct functional, regression, integration testing including HTML page Interactions using various browsers (IE & Mozilla) and application security.
• Involved in manual testing of the application.
• As an Analyst involved in gathering business requirement, studying the application and collecting the information from developers & Business Analysts.
• Developed Test Plan, Test Scripts and overall predefined Test Strategy to do regression testing of the Application thoroughly including functional testing, security testing, Role-Rights Matrix based testing, Cosmetic Testing etc.
• Involved in the execution of test scripts as part of Regression Testing.
• Involved in the execution of smoke test for every new build on different environments.
• Log the defects found during application testing & follow up with developers.
• Involved in weekly walkthrough & inspection scrum meetings, to verify the testing status.
• Support and Troubleshoot Java based Test Automation Tools.  
• Work on developing state of the art, third generation testing tools.
• Debug and fix java code, ant, maven, and shell scripts.
• Developed Test Plan, Test Scripts and overall predefined Test Strategy to do regression testing of the Application thoroughly including functional testing, security testing, Role-Rights Matrix based testing, Cosmetic Testing etc.
• Log the defects/bugs found during application testing using defect tracking tools & follow up with developers.
• Participate in weekly walkthrough & inspection scrum meetings to verify the testing status.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.

Environment: SQL Server 2005,JIRA, Confluence,Tortoise SVN, JIRA, WebServices, Windows XP, MS-EXCEL