SUMMARY

• 9.5 years of strong experience in the IT industry as a Tech Lead in HealthCare - Clinical Information Systems, Predictive modelling, and Messaging, as well as Telecom domains.
• Currently working on Migration of database to PDW (Parallel Data Warehouse).
• Strong noledge of SSIS 2012, SSIS, SSRS, and Service Broker in SQL server 2008, Tuning using Row Transformations, Block and Unblock Transformations.
• Instrumental in Huge ETL using SSIS 2012, Bulk Copy Program (BCP) and Bulk Insert.
• Extensive experience in SQL Database design, indexes, optimization, stored procedures, data modelling, Service broker and strong noledge of ETL SSIS. Also Crystal Reports, QlikView and MS Excel spread sheets.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics using SQL Profiler and PerfMon.
• Designing of Reports for End-User requests using Web Interface & SSRS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extensive experience in software development methodologies Waterfall/Agile SCRUM with good Technical, Analytical skill. Conversant with all phase of Software Development Life Cycle (SDLC)
• Experience in Application and Database Architecture. Good understanding of Enterprise Application blocks, Design Patterns and SOA architecture.
• Excellent skills in the areas of analytical, communication, organizational, administrative, interpersonal and leadership with Role playing capabilities.
• Very experience in handling onsite-offshore operations, as well as in working directly with clients to define requirements and specifications, project work planning and management, design, development and successful implementation of applications and systems.

TECHNICAL SKILLS

Languages: C#, VB.Net, ASP.Net, HTML5, JQuery, JavaScript

.Net: WCF, Web Services, LINQ, Entity Framework4.0, WebAPI, .Net 2.0, .Net 4.0

ETL Tools: SSIS, SSRS, SSAS

Tools: Visual Studio 2008/2010/2012 , Visio, IIS 7.0, MS ProjectSecureFx, $Universe, TFS, Informatica, MS Testing Framework and nUnit unit testing tool.

RDBMS: SQL Server 2000/2005/2008 R2/2012, Red Gate, Oracle

Third Party: Task factory, Telerik & Infragistics windows controls, Concentra Dialler, Blaze Rule Engine, TFS, Qlikview

Design &Architecture: Application design and architecture, Design Patterns, Database design

OS: Windows 98/NT/ 2000/2003/2008/ XP and Windows 7

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Project Tech Lead

Responsibilities:

• Developed Stored Procedures/Triggers in SQL Server 2008/2012.
• Microsoft SQL Server: Normalization, T-SQL, Stored Procedures, Rules, Views, Indexes
• Gatheird requirements from clients and business analysts for end user applications.
• Created Solution Architecture Document design for SCRUM team.
• Created UML design diagrams - incl. Class, Object, Component
• Developed Web Forms using different controls - Data Grid, List View controls, etc., and various validation controls.
• Building web applications with ASP.NET MVC, JavaScript, jQuery, JSON, HTML, XHTML, CSS
• Used as presentation layer and used C# in Business and Data Access Layers to write Validation objects.
• Used Various Design Pattern Techniques, like Singleton, Facade.
• Developed applications leveraging ADO.NET, LINQ to SQL, Entity Framework 4, and the Microsoft Enterprise Library Data Access Application Block
• SOA based WCF Member’s Participation based on domain oriented architecture.
• Used XML skill to store and fetch data using stored procedure from SQL Server 2008 Database.
• Responsible for performing data investigation to assess problems associated with the application.
• Designed SSIS Package for loading the transformed data into the destination. To load the data, added an OLE DB destination to the data flow. The OLE DB destination can use a database table, view, or an SQL command to load data into a variety of OLE DB-compliant databases.
• Ongoing responsible for troubleshooting defects for SIT, UAT, and Production.
• Writing MS Unit Test for WCF business services classes by mocking the objects.
• Writing SQL complex queries for Billing Management and subsidy maintenance module.
• Developing and maintain few SQL SSIS packages and schedule those from UI.
• Integration with MSMQ Policy fulfilment services and communicating with corresponding services for sending email, SMS and mail communication.
• Writing business logics for integrate and manipulate data from domain Entity framework. Used LINQ at extended level.
• Handled TFS stabilization tasks and auto contagious build integration. Especially to adding database project and including C# and DB unit testing project.

Environment: ASP.NET MVC, JavaScript, jQuery, JSON, HTML, XHTML, CSS, ADO.NET, LINQ to SQL, Entity Framework 4

Confidential

Development Lead

Responsibilities:

• Designing and developing new functionality in SIV application.
• Impact analysis of new changes on current system and preparing technical specification document.
• Used Test cases for writing unit testing for enhanced components testing.
• Writing entities for tables, SP and creating their relations for Entity framework.
• Writing stored procedures for complex database business logics.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modelling process.
• Created Data-driven Packages in SSIS as part of the automating the process for the Referral Process.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved to planning and designing SSAS 2008 Cubes and building attribute relationships for optimal performance of Hierarchies and Fact Dimensions.
• Involved in performing Audits and recovery operations of SSAS objects.
• Assess the risks and recommend/ install service packs or hot fixes when needed.
• Code review and performance tuning.
• Implementation of logging framework.
• Experience of good Agile 2 weeks sprint, used to part of stand-up calls, retrospective and iteration planning meetings.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

Environment: SQL Server 2005/2008, Oracle, Entity framework, SSAS

Confidential

Development Lead

Responsibilities:

• Responsible for leading the team and client interaction and requirement gathering.
• Designed and created Excel spreadsheet forms for data input to provide an attractive user interface.
• Built a VBA based reporting engine for standard reports and Adhoc querying.
• Used Access to retrieve data from SQL server and created and maintained the Access database.
• Customized lookups, links, and graphic charts in Excel to fulfill trader needs of various clients.
• Followed SDLC procedure throughout the modules and reports development.
• Involved in documentation of the future enhancements.
• Responsible for collection of goal and projection files from upstream.
• Extensively used various functions in building spreadsheets.
• Developed a Metrics tool to capture reports usage.
• Implemented add-ins features into Excel screens for custom calculations.
• Analyzed several existing Excel macros and enhanced them to customize client reports.
• Performed system testing and measured performance during Beta - Testing phase.
• Automated the daily download process and the excel reports from retrieving raw data.
• Developed prototypes and updated changes based on feedback.
• Performed unit testing and uploaded the enhancements into SharePoint server.
• Designed, defined and documented workflow diagrams and processes.
• Re-engineered CRM software systems used by DVO/IVO teams. Web based user interfaces for clients who can access online pickup status.
• Developed Fulfillment management system for all collection agencies of our clients.
• Developed and implemented new Issue Tracker system for users concerns, bugs, and defect tracking regarding use and functionality of new interfaces.
• Generating reports using SSRS package and Qlikview.
• Integration of Dialer (ocx control e.g. ASPECT, CISCO) in CRM windows application for Computer specialist.
• Creation of windows file watcher services for application in c#.net 2.0
• Involved in Creation, Development of SSIS packages in SQL Server 2008.
• Used Process Explorer for maintenance of stuck process, and to release the handles on files
• Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.
• Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks
• Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
• Implemented new T-SQL features in SQL Server 2005 like Partitioning, Advanced Error handling, Common Table Expression (CTE) and LINQ.

Environment: SQL, SharePoint, SSIS, T-SQL

Confidential

Sr. Software Developer

Responsibilities:

• Implementation and delivery of BI platform solutions to develop and deploy ETL, analytical, reporting and scorecard\dash boarding on SQL Server 2005 using SSAS, SSIS/DTS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of DTS packages to SSIS packages
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Planned, Configured, Installed, Maintained SQL Server in environment of Multi-node Cluster with Multi-instances.
• Configured and Monitored Database Mirroring for Application Development environment
• Involved in Installation, Configuration of Reports using SSRS with Scale-Out topology.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Performed Database Refresh tasks from production to Development and Staging Servers
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Work involvement in performance monitoring of Memory, Processor, Disk/O and fine tuning.
• Handled Scheduled backups and restore operations with Litespeed 5.0 and monitored the Tasks, Maintenance plans.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks
• Maintain cash/Finance management and audit history for distributor.
• Used of XML Programming for handling the incoming and outgoing request to Web Service.
• Created and Consumed Web Service for security and performance testing.
• Implemented a window Service for automatically daily database backup.
• Took Responsibility for updating and checking application on Production Service.
• Generated code for creating log file for every activity within application.
• Checking and verifying the reports.

Environment: ETL, SQL Server, SSAS, SSIS/DTS, SSRS, Olap, litespeed

Confidential

Developer

Responsibilities:

• Developed architecture and code for data exchange with BSNL Web Service.
• Maintain cash/Finance management and audit history for distributor.
• Used of XML Programming for handling the incoming and outgoing request to Web Service.
• Created and Consumed Web Service for security and performance testing.
• Implemented a window Service for automatically daily database backup.
• Created stored procedure and executed complex queries.
• Took Responsibility for updating and checking application on Production Service.
• Generated code for creating log file for every activity within application.
• Checking and verifying the reports.

Environment: XML Programming