SUMMARY

• Six years of professional experiences in application and database development with thorough knowledge of different phases of software development life cycles including analysis, design, development, documentation, deployment and system support.
• Experience in designing of database in SQL Server 2012, 2008, 2005 and 2000.
• Hands on experience in writing T - SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Derived Tables, Views and Triggers.
• Expert in Performance Tuning and Optimization of SQL Server, SQL scripts and Stored Procedures.
• In-depth knowledge of Transact-SQL (DDL, DML and DQL).
• Advance knowledge in RDBMS concepts, logical/physical data models.
• Able to install, upgrade and configure of Microsoft SQL Server and Databases.
• Experience with SQL Server Integration Services (SSIS).
• Experienced in designing Data Model and Building reports using SQL Server Reporting Services (SSRS).
• Experienced in data migration from different database platforms.
• Experienced in Extraction, Transformation and Loading (ETL) in SQL Server database.
• Knowledge of Oracle 10g Database, PL/SQL, Sybase.
• Strong analytical, problem solving and troubleshooting skills.
• Able to work collaboratively, quickly understand system architecture and business needs while committed to achieving corporate goals.
• Good verbal and written communication skills. Positive attitude towards superiors & peers.
• Ability to work independently and in large team environment.
• Quick learner and good performer both in team and independent job environments.
• Knowledge on Teradata database.
• Knowledge on Coding Standard, Version control, Declarative Database Development, SQL Server Tools, Data-Modeling and Data Architecture, Diagnose Replication.

TECHNICAL SKILLS

Database Technologies: SQL Server 2012/2008/2005/2000, Oracle 10gSybase.

Languages: SQL, T-SQL, PL/SQL, MySQL, Sybase, Teradata, .NET, XML, HTML, Microsoft C# 2012, MDX Query.

BI Tools and other tools.: Query Studio, SSIS, SSRS, SQL Server Data Tool (SSDT) 2012. JIRA, TRACK, Hip Chat, #slack, Google hangout.

Operating Systems: Windows NT/2000/XP/Vista/Window 7

Web Technologies: HTML, FTP, HTTP

Domain: Health Care, Marketing Service, Apartment.

PROFESSIONAL EXPERIENCE

Confidential, VA, Richmond

Responsibilities:

• Creating Tables,Business Views, stored procedures and modify them as per requirements.
• Writing complex SQL code using T - SQL.
• Perform Data Manipulation Language DML operations.
• Alter and Drop various database objects as per business needs.
• Retrieving data and send back to the client as per requirements by writing complex SQL queries.
• Building SSIS package and modify them as per business need.
• Run the SSIS package and check the data populated to the destination by writing SQL Code using SSMS.
• Data Migration using ETL from various source to the destination.
• Creating dimensions to dump data to the data warehouse.
• Removing the columns from the staging tables having null value prior creating the dimensions.
• Creating automation process in BPA server to automate for loading data to data warehouse.
• Verify the data following the automation process completed in the respective tables.
• Supporting Lights On team to monitor and fix the issue raised while getting data from the vendor.
• Create and configure different tasks to automate the process of data migration and fix the issue occurs on the process.
• Regularly support BPA server to monitor the automation task.
• Synchronize data with Informatica Cloud.
• Filtered data from the cloud as per business requirement and perform data compare.
• Deals with different data sources (salesforce, telesales etc.)
• Work in Agile environment.
• Participating daily stand up meeting to discuss on the updates at assigned tasks and set up meetings with the team and the client as necessary
• Coordinate with onshore and offshore team on day to day assignment and updates.
• Perform Testing before pushing code to the production.
• Coordinate with the new team member regarding credential, security check and access to databases, a kind of DBA role.

Environment: s: Informatica Cloud, SQL Server 2008R2, SSIS, SSRS, BIDS 2008, SFDC, Salesforce, Telesales, Teradata, Remote Desktop, CyberArk, BPA, Data Warehouse, OLAP and OLTP.

Confidential, VA, Norfolk

SQL Server Database Developer

Responsibilities:

• Creating tables, stored procedures, views, functions, indexes and modify them as per business requirements for forrent.com.
• Writing T-SQL Script, Complex Custom Query, Merge statements, Joins, pre-deployment scripts in SQL Server 2012 and2008R2 and post-deployment scripts in SQL Server Data Tool (SSDT) 2012.
• Building SSIS package and modify it using SSDT.
• Data Migration.
• Data Modeling: produced ERD of databases.
• Run SQL jobs and SSIS package.
• Modify Reports/Create Report and Data Cube as per business requirements.
• Writing Custom Query as per business need and verify results in Management Console Backend .
• Writing SQL scripts in SSMS and execute directly in production.
• Assisting Quality Assurance Engineers for Testing.
• Restore User Database and fix the database issues in own environment.
• Participating various meetings as a part of Agile Software Development Life Cycle.
• Participated various periodical database security trainings, various project workshops, peer programming.
• Performed Code Review in the SSDT for maintaining coding standard.
• Schema Compare and Data Compare using SSDT. Updating tables by data comparing in SSDT.
• Creating different CORE release folders and branches in Team Foundation Server (TFS) to work for project and the Sprint.
• Produced the flowchart of the version control process TFS.
• Merge down and Merge up database changes into different branches.
• Resolve conflicts in SSDT after database changes.
• Build solutions before pushing codes to production and different servers.
• Update the release branches following the database Release, cleaning TFS.
• Commit pending changes in Team Explorer, publish database changes and deploy SSIS package to production as well as different servers.
• Updating sprint task daily in JIRA and TRACK ticketing tools.
• Knowledge on Coding Standard, Version control, Declarative Database Development, SQL Server Tools, Data-Modeling and Data Architecture, Diagnose Replication in dev and beta environment.
• Version Control process used by database in TFS, Development and deployment using visual studio/SSDT, ERD and Data warehouse concepts, understanding of the overall architecture and approach taken to address issues within a sprint, understanding of data exchange basics.
• Write complex custom query.
• Update database without having restore using SSDT Data Compare .

Environment: s: SQL Server Data Tools (SSDT) 2012, SQL Server 2012 & 2008R2. SSIS, SSRS, SSAS, Data Cube, Sharepoint, Source Control, Solution Explorer, Team Explorer, JIRA, TRACK, MongoDB, Sybase, Transparence-TSP, Hip Chat, #slack, Google Hang out, MS Excel, MS Word, Note Pad ++, Microsoft C# 2012

Confidential, CA, Sacramento

SQL Server Developer

Responsibilities:

• Creating tables, views functions, triggers, stored procedures and T-SQL script for application and to meet the business requirements.
• Installation and Configuration ofSQLServer 2008.
• Fine tuning of the database queries. Creating appropriate indexes for better performance plans.
• Used SSIS packages/jobs broadly to migrate and transform data from legacy database system.
• Actively participated in creation of logical database model, physical database design and implementation of large database models.
• Migrated data across different data sources and SQL server environments.
• Testing data / stored procedures with complex queries, correlated sub queries and joins.
• Created log shipping on servers for back up, copy and restore transaction logs.
• Created packages to migrate data from different data sources to data warehouse.
• Created packages for database protection and applied Security roles/permissions to the database users.
• Worked on health care transactions: 834, 835, 837 as well as ICD 10.

Environment: MS SQL Server 2008, Windows Server 2003, SSIS, SSRS, ASP. NET, Windows 2000 / XP, Visual Studio 2008, UNIX, MS Access07, Sharepoint, Visual Source Safe and Mainframe.

Confidential, Herndon, VA

SQL Server Developer

Responsibilities:

• Creating database, functions, triggers, stored procedures, views, tables, packages and TSQL script for application and to meet the requirements of the business.
• Installation and Configuration ofSQLServer 2008.
• Fine tuning of the database queries. Creating appropriate indexes for better performance plans.
• Used Data stage jobs broadly to migrate and transform data from legacy database system.
• Actively participated in creation of logical database model, physical database design and implementation of large database models.
• Migrated data across different data sources and SQL server environments.
• Testing data / stored procedures with complex queries, correlated sub queries and joins.
• Created log shipping on servers for back up, copy and restore transaction logs.
• Developed and tested business and IT process automation jobs, agents and processes.

Environment: MS SQL Server 2008, Windows Server 2003, ASP. NET, IBM Info Sphere Data Stage, Windows 2000 / XP, Visual Studio 2008, MS Excel, MS Office, Team Foundation Server, Test Manager, Agile, Sharepoint and Mainframe.