H Kumar

202-***-****

acvnji@r.postjobfree.com

Virginia Beach, VA

Summary

6+ years of IT experience as a MS SQL Developer and .Net developer with Experience MS SQL Server 2012/2008/2005, Ms Access, .Net.

Diverse experience of managing BI environment, which includes Business model, Data Model, Data sources, Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Transformation Services.

Diverse experience in all phases of software development life cycle (SDLC) with Agile Methodologies.

Experience in SQL Server 2005/2008/2012 (database design, Database maintenance, stored procedures, DDL/DML triggers, user-defined functions, jobs, database backup) to implement Business Logic.

Experience working on SQL database installation, upgrades, backups, restores, jobs, SQL queries etc.

Utilize ETL processes using SSIS. Responsible for writing ETLs for various lines of business using SQL Server 2008 and SSIS packages. Troubleshooting reporting and ETL issues.

Normalized schemas and optimized query performance for existing schemas and queries. Have a Good knowledge with performance traces, replication and maintenance scheduling.

Expertise in Merging data from various Heterogeneous Data sources, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.

Expertise in Designing, Developing and deploying various SSRS Reports like Sub-Reports, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.

Experience in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports.

Well versed with Source Code Control Systems like MS TFS, Microsoft Visual Source Safe.

Have ample of experience in developing Crystal Reports for report generation and integrate into .NET applications.

Functional domain experience involves Healthcare, Valuation, Hotel Management, Diamond Process Industry and e-Commerce, payment gateways, real estate workflows.

Worked closely with management and staff related to projects meeting, progress and tasks.

Experience in understanding user requirements and translating business requirements into technical solutions.

Good knowledge of design and interfaces. Keen learner with a positive attitude and Self-motivated & ambitious, develop skill in new technologies as well.

Technical Skills

Database/ RDBMS:

SQL Server 2012/2008/2005, MySql, Oracle, MS Access, Store Procedure, Query Optimization, Indexing, Views, Triggers, Function

Language:

T-SQL, PL/SQL, C#, ASP, VB .Net,

SQL Server Tools

SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler, SQL Agent, SQL Trace, Performance Monitor

ETL And Reporting

SQL Server Integration Services (SSIS), SQL Server DTS,SQL Server Reporting Service(SSRS), Crystal Reports, RDLC, TIDAL Enterprise Scheduler

.NET Technologies:

.NET Framework 4.0/3.5/3.0, ASP.NET, C# . NET, VB.NET, ADO.NET

Development Tools:

VisualStudio.NET 2005, 2008, 2010 and 2013, Microsoft Visio, Dream Viewer, Fire Bug, Krypton Control Toolkit

Application Servers:

IIS, Apache, Tomcat

Version Control:

Team Foundation Server, Microsoft Visual Source Safe 2005, Rational Clear case

Documentation Tools:

MS Office Visio, Word

FTP Client:

Filezilla, Cute FTP

Operating Systems:

Windows 8/7,Windows XP, Vista

Professional Experience

Anthem Inc - Norfolk, VA Oct 2015 to Present Position : SQL Developer

Responsibilities:

Developed ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files and loaded the data into target tables by performing different kinds of transformations using SSIS.

Used For Each loop Containers, Sequence containers, Data flow tasks, Event handlers and transformations like aggregate, Derived columns, Lookup transformations, Merge, Merge join, union all and sort transformations etc., to move the data from flat files to staging and the functional databases in SSIS.

Utilized T-SQL extensively in order to replace SSIS transformations in order to improve the performance of packages.

Migrated Jobs that extract data from different sources using SSIS packages that would aggregate the data and load them in table.

Understanding SSIS Packages, SQL Stored Procedures, Ad-hoc queries and their dependencies .

Created Error and Performance Notification on SSIS Packages, Jobs, Stored procedures for troubleshooting.

Created database objects, user defined functions, stored procedures, Cursors, views, indexes, and triggers.

Build customized SSIS Packages using C#, VB script tasks and component.

Experience in Creating and Scheduling jobs in SQL Server And Tidal Scheduler. Migrated Jobs for 4 different sql server to Tidal with all the necessary modification in job for Dev/QA/Prod Environment.

Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures.

Used Tortoise SVN in order to share the code with other programmers and as a source control Document, design, develop, optimize and maintain reliable, repeatable and scalable ETL packages.

Involved in developing SSRS reports using T-SQL.

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in SSDT.

Environment: SQL BI Suite ( SSIS, SSRS), Visual Studio Professional 2010, SQL Server 2008/2012, TIDAL Enterprise Scheduler, Windows 7.

Macy's System And Technology - OH May 2015 to Oct 2015 Position : SQL Developer

Responsibilities:

Worked in Agile Scrum Methodology with daily stand up meetings.

Involved in upgrading the databases and servers of SQL Server 2008R2 to SQL Server 2012.

Experience in creating packages to transfer data between ORACLE, FLAT FILES, Excel Files, to SQL SERVER 2012 using SSIS.

configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.

Deployed the SSIS Packages and created jobs for efficient running of the packages.

Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.

Design and develop technical specification document for the module development phase.

Created tables, views, user defined functions, stored procedures and triggers using Sql Server 2012.

Implemented and Deployed SSRS reports to Report Manager and created linked reports, snapshots, and subscriptions for the reports and worked on scheduling of the reports.

Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

Used SQL Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.

Implemented Logging module in application that capture all error and performance log of application and service call.

Responsible for Unit testing, fixing the bugs and troubleshooting the technical problems.

Maintaining versions of source code using Team forge, Tortoise SVN and AnkhSVN .

Environment: Microsoft MS SQL Server2012/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, Microsoft Excel.

Obverse Inc, Washington DC March 2014 to April 2015 Position : SQL Developer

Responsibilities:

Gather report requirements from business to ensure report encapsulates all the data needs the business requires to operate the business or to make fact based business decisions

Designing and developing SQL Server 2014 Database, Tables, Indexes, Stored procedures, Views, Triggers.

Fine-tuning with SQL Server Tuning Advisor and optimization of SQL queries and Stored Procedures using SQL Profiler.

Created Indexes - Clustered and Non Clustered Indexes.

Performance tuning of SQL statements and SQL Code reviews.

ETL implementation using SQL Server Integration Services (SSIS), applying some business logic and data cleaning in staging server to maintain child and parent relationship.

Involved in defect fixing, maintenance and enhancement of the current application.

Worked on deployment of SSIS packages on SQL management studio and created SQL Agent Jobs to schedule run of SSIS Projects.

Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion.

Worked with different Control Flow elements like For Loop Container, for each Loop Container.

Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.

Create database objects in SQL Server 2008 including Tables, Triggers, Views, Stored Procedures, User Defined Functions (UDF) and Indexes.

Designed and developed dynamic ASPX web pages using C#. NET, ASP.NET 3.5, HTML, Java Script.

Involved in Unit testing and Integration testing with other modules Participated in the team technical reviews to formulate development best practices

Environment: SQL Server 2012/2008/2008 R2, SQL Profiler, SSIS, SSRS, ASP.Net 3.5, C#, Visual Studio 2010, IIS 7.0, Java Script, JQuery, AJAX

Capital Technosys April 2011 to Feb 2014

Position : SQL / .Net Developer

Responsibilities:

Administrating & developing MS SQL 2005/2008/2012 databases

Creating a suite of financial, customer and employee performance reports using SSRS.

Automating processes and developing stand alone .Net applications for specific business segments internal needs.

Created an SSIS Package which can load multiple sheets in an excel work book

Migrated Old data from MS access into SQL Server 2012 using SSIS Packages.

Expert in scripting T-SQL queries, creating and using Stored Procedures, Views, user Defined Functions, triggers, implementing Business Intelligence solutions using SQL Server 2012/2008 R2/2008/2005.

Responsible for upgrading and migrating of various applications in Access to SQL Server.

Automating the Database Maintenance tasks by creating Jobs and Alerts using the Database mail and SQL Server Agent.

SQL Server Administration involving planning and implementing Backup and Recovery.

Analysis of SQL queries and optimizing performance through modifying table design and application code.

Configuring the standby servers and setting guidelines to automate recovery scenarios.

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data.

Generated test data and tested new databases consistency with existing databases to meet the functionalities requirements.

Experienced in Developing and Enhancing Web forms, Master Pages, User Controls and Custom Controls by using HTML, CSS and Asp.Net Controls.

Implemented Server and Client side validations using ASP.NET validation controls and JavaScript.

Meeting with Business Analyst and data modeling team to understand requirements and existing.

Environment: MS SQL Server 2012/2008/2005, Visual Studio2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Windows Server 2008, MS Access, TSQL, .NET, MS - Visio, ASp.Net, C#.

Metizsoft Solution June 2009 to March 2011

SQL and .Net Developer

Responsibilities:

Actively involved in analysis, design, development and testing with team.

Involved in the design of database, creation of tables and stored procedures using MS SQL Server 2005.

Identified and validated client requirements for developing this application.

Perform continues maintenance and support of the application PMS, attendance, Payroll.

Developed the C# code for implementing business logic in middle tier in 3-tier application interacting with SQL Server database.

Designed and developed various reports using Crystal Reports and rdlc report and gave option to export to Excel and .PDF files. The reports have an option to enter parameter values from the form.

Involved in the testing of application on regular basis and managed exception handling in application.

Environment: .NET Framework 3.0, Visual Studio 2005, C#.NET, ADO.NET, HTML, SQL Server 2005,RDLC Report, Crystal report.

Education

Bachelor in Information Technology 2009

Dharmsinh Desai University Institute of Technology

Nadiad Gujarat India

Contact this candidate