SUMMARY:

• Microsoft Certified Technology Specialist with 7+ years of professional experience involving in all the stages of software development life cycle, studying the user requirements, analyzing, designing, preparing necessary documentations, coding, implementation, testing and deployment.
• Extensive experience in web technologies like ASP.NET, WCF & Web Services, IIS 6.0, HTML, XML, SOAP, XSLT, VBScript, JavaScript.
• Hands on experience in designing and developing .Net applications with C#.Net and SQL Server.
• Rich experience in ETL and reports development using SQL Server Integration Services (SSIS) packages and SQL Server Reporting Services(SSRS).
• Extensive experience in US Healthcare domains and products like QNXT, CCA.
• Proficient in database programming like developing complex stored procedures, triggers, tables, views, user defined functions, relational database models.
• Sound knowledge of N - tier layered architecture.
• Specialized in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, multi tabbed reports, charts, dashboard using SQL Server Reporting Services, Tableau.
• Rich development experience in Automation tools using ASP.Net, C#.Net, SQL Server and Excel macro for minimizing manual efforts.
• Extensive experience in performance tuning, disaster recovery, troubleshooting, backup and restore procedures.
• Good documentation skills in preparing Technical Specification Document, Detail Design Document, Unit Test Planning, Requirement Traceability Matrix.
• Experience in creating SSIS packages, jobs, alerts, SQL mail agent and scheduling SSIS packages.
• Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team. Perform code review with the developers and fine-tune the code for performance improvement.
• Specialized as a Configuration Manager for managing the necessary artifacts and share the audit report to teams, publishing documents in SharePoint and managing the users.
• Good technical analysis/design skills, Strong understanding of business needs objectives and interests in projects, able to quickly learn and adapt to new technologies.
• Excellent experience in onsite-offshore model interacting with clients and Onsite managers.

TECHNICAL SKILLS:

Programming Languages: C#.Net, ASP.NET, ADO.NET, .Net Framework 3.0/3.5, SSIS, RESTFUL Web Services, WCF Services

Scripting Languages: HTML, CSS, XML, AJAX, JavaScript, JQuery, JSON, PHP, Shell

Databases: MS SQL Server 2008R2/2012/2014,PL/SQL

ETL Tool: SSIS

Reporting Tools: SSRS, Excel Reporting

Operating Systems: Windows Server 2008/2012, LINUX, UNIX

Products: QNXT, CCA

Version Controls: TFS, SVN, Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential

Senior .Net/BI Developer

• Involving in requirement gathering, analysis, design, documentation, coding, unit testing and coordinating with offshore.
• Developing .Net applications, supporting the existing application, working on enhancements.
• Developing SSIS packages to validate the data by extracting and applying appropriate transformations over the data and loading data from OLTP system to data warehouse.
• Creating parameterized, cascaded, drill-down, cross-tab and drill-through reports using SSRS 2008 R2/2012, distributed the reports in multiple formats into specified locations.
• Managing report delivery based on Time driven and Data driven subscriptions.
• Creating ad hoc queries, complex stored procedures and views to store the data of clients, and use them in SSRS reports to generate reports on the fly.
• Migrating Oracle OBIEE reports into SSRS reports and migrated the existing SSRS reports into higher versions.

Environment: C#.NET, ASP.Net MVC, MS SQL Server 2012/2014, SSIS, SSRS, SQL Profiler, Excel reporting, JQuery, JavaScript, Excel Macros, Oracle 11g, TFS.

Confidential

Responsibilities:

• Involving in requirement gathering, analysis, design, coding and unit testing.
• Creating documentations such as Technical Specification Document, Detailed Design Document, Unit Test Plan and Requirement Traceability Matrix and status reports.
• Developing custom solutions using C#.Net for implementing pre and post add-ins to satisfy the business needs.
• Developing stored procedures, functions, triggers, Indexes and views for the application.
• Creating business critical stored procedures/functions and used them in reports directly to generate reports on the fly.
• Solving production issues in timely manner and enhancing the applications based on the business request.
• Developing automation tools for minimizing manual script execution, Complex rate code generation, EDI file splitting using SQL and .Net programming.

Environment: ASP.Net, C#.NET, MS SQL Server 2008R2, SQL Profiler, TFS, JQuery, JavaScript, SSIS, Excel Macros.

Confidential

.Net with BI Developer

Responsibilities:

• Involving in understanding user requirements, analysis, design, documentation, build, code review and deployment activities.
• Creating services to fetch the process information from multiple sources like TIDAL, hosted servers.
• Creating windows service to get logging details from log files and log tables.
• Providing timely support for critical deliverables and end-to-end testing.
• Involving in performance tuning and optimization of queries, functions and stored procedures.

Environment: ASP.Net, C#.NET, MS SQL Server 2008R2, Web Service, Win Forms, TFS, JSON, JQuery, JavaScript, Oracle 11g, Excel Macros.

Confidential

Responsibilities:

• Developing a generic solution with C#.Net, SSIS and SQL Server to sync the legacy data with 13-month retro processing to QNXT.
• Developing SSIS packages using various transformations like business intelligence transformations like conditional split, data conversion, lookup, merge, sort, union all, join.
• Designing packages with parallel processing
• Creating automation scripts for unit testing, QA validation to reduce the time by creating SQL and VBA scripts.

Environment: MS SQL Server 2012, SSIS, SSRS, SQL Profiler, C#.NET, TFS, Excel Macros.

Confidential

.Net with BI Developer

Responsibilities:

• Involving in complete software development life cycle process by analyzing business requirements and understanding the functional work flow of information.
• Developing interfaces using AutoQ framework - a solution to handle the PEND claims and Rhino framework - a solution to extract, transform and load data from source to destination in the form of heterogeneous types.
• Developing SSIS Packages to load and extract data from heterogeneous data to/from SQL Server.
• Solving production issues in timely manner and enhancing the applications based on the request.
• Working on migration projects from QNXT 5.2 to 5.3 versions.
• Developing pre and post add-ins for applying client based requirements into/from the system.
• Developing automation tools using .Net and Excel macros.
• Developing various reports like Drill Down, Drill through, Cross tab, sub reports and Parameterized Reports.
• Scheduling SQL jobs and managing subscriptions for SSRS reports using SSRS 2008 R2/2012.
• Responsible for writing complex SQL queries, stored procedures, triggers, views, cursors, constraints, indexes and user defined functions to implement the business logic.

Environment: SQL Server 2008 R2, SSIS, SSRS, MS Visual Studio 2010, SQL profiler, C#.NET, ASP.Net, TFS, JavaScript, JQuery.

Confidential

.Net/SQL Developer

Responsibilities:

• Involving in requirement gathering, analysis, design, coding, unit testing and deployment of deliverables.
• Creating Technical Specification Document, Requirement Traceability Matrix and Unit Test Plans based on the functional requirements.
• Creating web services.
• Involving in designing database, applied coding standards in all the objects like tables, indexes, constraints, functions, stored procedures, views and triggers.
• Developing generic outbound solutions for different vendors using ASP.Net and SQL Server.
• Writing complex and efficient DML queries, view, tables, indexes, stored procedures, functions, triggers, linked servers and maintaining referential integrity.
• Writing shell scripts to extract, transform and loading data to/from flat file to database.
• Creating indexed views and appropriate indexes to reduce the running time for complex queries.
• Developing PHP reports for the projects running in Unix environment with MySQL as data store.

Environment: ASP.Net, WinForms, SQL Server 2008 R2, SSIS, SSRS, C#.NET, Perl & Shell Scripting, MySQL, PHP, VS Source Safe, Perforce.