SUMMARY

• 9.5 years of strong experience in teh 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 knowledge 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 knowledge 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 wif good Technical, Analytical skill. Conversant wif 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 teh areas of analytical, communication, organizational, administrative, interpersonal and leadership wif Role playing capabilities.
• Very experience in handling onsite-offshore operations, as well as in working directly wif 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
• Gathered 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 wif 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 teh 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 wif teh application.
• Designed SSIS Package for loading teh transformed data into teh destination. To load teh data, added an OLE DB destination to teh data flow. Teh 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 teh 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 wif MSMQ Policy fulfilment services and communicating wif 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, wif 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 teh automating teh process for teh Referral Process.
• Teh 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 teh 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 teh 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 teh 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 teh Access database.
• Customized lookups, links, and graphic charts in Excel to fulfill trader needs of various clients.
• Followed SDLC procedure throughout teh modules and reports development.
• Involved in documentation of teh 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 teh daily download process and teh excel reports from retrieving raw data.
• Developed prototypes and updated changes based on feedback.
• Performed unit testing and uploaded teh 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 teh 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 teh existing DTS packages to SSIS for teh 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 wif 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 wif Multi-instances.
• Configured and Monitored Database Mirroring for Application Development environment
• Involved in Installation, Configuration of Reports using SSRS wif Scale-Out topology.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Involved in daily code drops and archives on teh 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 teh 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 wif DBCC, Defrag, Index tuning and monitored error logs
• Database Performance of Index tuning wif 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 wif Litespeed 5.0 and monitored teh 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 teh 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 wifin application.
• Checking and verifying teh reports.

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

Confidential

Developer

Responsibilities:

• Developed architecture and code for data exchange wif BSNL Web Service.
• Maintain cash/Finance management and audit history for distributor.
• Used of XML Programming for handling teh 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 wifin application.
• Checking and verifying teh reports.

Environment: XML Programming