SUMMARY

• 10 years 6 months of professional experience in IT Industry involving in various phases of Software Designing and Development including requirement gathering, design, development, testing, maintenance and production support.
• 2 years 6 months of total experience in Oracle PL/SQL performance tuning and development.
• 2 years 6 months of total experience in Restful API using .Net framework 4.6, Owin pipeline.
• Entity framework 4.6, Unity of work, logging of exception using extensive exception policies.
• 3 years 7 months of total experience on web applications using .Net Web Application 4.0, 4.5, ASP.Net 4.0, 4.5, Java Script, Ajax and JQuery.
• Extensively worked with the SQL 2008, 2012, 2014 and SSIS 2008, 2012, 2013 and 2015.
• Professional experience in the Services, Manufacturing, Finance, Energies Utilities and Taxation.
• Expertise in several .Net technologies like C#.Net 4.0, 4.5, ASP.Net 4.0, 4.5, Web Services, WCF and Restful API’s.
• Hands - on experience in using the Integrated Development Environments such as VS 2008, 2010, 2012, 2013 and 2015.
• Experience working with different deployment models of SSIS 2012, 2013 like Project Deployment & Package Deployment Model.
• Experience working with web services using SOAP, UDDI, WSDL, REST and implementation using Web Services and WCF.
• Expert knowledge over SQL Database Administrator activities like Backup, SQL Jobs Migration, SQL Authentication Logins Migration and Maintenance Activities, Shrinking log files & Data files.
• Generating Scripts from Database to move to higher environment. Creating Proxies to use for running SQL Jobs.
• Good Understanding of DBMS through Database Design, writing queries using databases like SQL Server 2008, 2012, 2014 versions.
• Expertise in using & administrating version control systems like Microsoft Team Foundation Server.
• Extensive experience in XML related technologies such as XML, DOM.
• Ability to work independently with minimum supervision in a team environment.
• Ability to lead medium sized teams.
• Has performed various levels of Testing such as Unit testing, System testing, Functional testing, and Pre-Prod UAT testing.
• In-depth expertise in all aspects of the requirement analysis, design, development, testing, troubleshooting, and debugging
• Experience in creating in documentation Requirement Specification Document, functional, mapping and technical document.
• Agile Project Management experience.
• Experience in creating automated build deployment using Visual Studio IDE.
• Expert in Configuring Source Controls tools such as TFS.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Extensive experience of offshore - onshore module.
• Possess excellent technical, logical, code debugging and problem solving capabilities.
• A project oriented team player with solid communication and interpersonal skills.

TECHNICAL SKILLS

Languages/ Technologies: C#.NET, Restful API, Entity Framework, Oracle PL/SQL, WCF, WinForms, ASP.Net, Java Script, JQuery, SSIS 2008/2012/2013/2015 , SQL 2008 R2/2012/2014

Web Technologies: ASP.NET 3.5/4.0, AJAX, JQuery, Web API, HTML, CSS

Databases: MS SQL Server 2008/2012/2014

GUI Tools: MS Visual Studio.NET 2008/2010/2012/2013 , SSMS

Methodologies: UML, Ado.net

Source Control: VSS/TFS 2015

Deployment Tools: MS Build, IIS 7.0/7.5

Operating Systems: Windows 10.0/Windows 7.0/ Windows Server 2008 R2/Windows 2012 Server R2

Tools: used: Telerik Controls, Aspose Tools, HP Fortify, Microsoft Office, Microsoft Visio, Microsoft Project, Build forge Deployment, PPM

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Technology Lead

Responsibilities:

• Primary Contact of the Application, responsible for all activities related to Application as well as acts as Project Lead.
• Involved in gathering requirement from business and then analyze the requirement in depth.
• Convert business requirement into technical requirement.
• Responsible to creating Prototype for the business requirements and follow up with business to finalize the requirement.
• Responsible for creating business and functional requirement document.
• Assign task to offshore team & follow up.
• Plan future release cycle deliverables in advance.
• Created release processes to deliver quality releases.
• Creating SQL Objects like Stored procedures, user defined functions using Oracle PL/SQL and SQL Server 2014/SSIS 2013.
• Development of Restful API’s using .Net Framework 4.6 with latest features of .Net i.e. Entity Framework, Owin Pipeline, Unity of work etc.
• Used latest exception logging techniques using .Net Framework 4.6.
• Migration of Data from Oracle to SQL using the Oracle PL/SQL Stored Procedures which will store data into temporary tables on Oracle side. Same is migrated to T2 using SSIS Packages.
• Providing on-call support for the application. Performing root cause analysis and provide a permanent fix to the problem.
• Attending the triage calls with testing & business during SIT and Business User Validation phase of project.
• Coordinate delivery of development and production releases that meet quality assurance standards.
• Designed Database.
• Document high level, detailed level design of Application, which includes SSIS & Web Application.
• Created Visio’s for Architecture of applications.
• Involved in requirement, design and implementation 10+ SSIS packages & one Web Application.
• Successfully got the Project to Closure with zero SIT & Business Validation Testing.
• Dealt with 10+ clients to gather requirements and Involved in Design changes with Confidential IT team.

Environment: SSIS 2015, SQL 2014, Entity Framework, Restful API’s, Owin Pipeline, Unity of work, C#.Net 4.6.

Confidential, Tampa, FL

Project Technical Lead

Responsibilities:

• Primary Contact of the Application, responsible for all activities related to Application as well as acts as scrum master.
• Involved in gathering requirement from business and then analyze the requirement in depth.
• Convert business requirement into technical requirement.
• Responsible to creating Prototype for the business requirements and follow up with business to finalize the requirement.
• Responsible for creating business and functional requirement document.
• Assign task to offshore team & follow up.
• Plan future release cycle deliverables in advance.
• Created release processes to deliver quality releases.
• Involved in the migration of Webserver, SQL Server environments.
• Creating SQL Objects like Stored procedures, user defined functions using SQL Server 2014/SSIS 2013
• Providing on-call support for the application. Performing root cause analysis and provide a permanent fix to the problem.
• Coordinate delivery of development and production releases that meet quality assurance standards.
• Designed Database.
• Document high level, detailed level design of Application, which includes SSIS & Web Application.
• Created Visio’s for Architecture of applications.
• Involved in requirement, design and implementation 15 SSIS packages & one Web Application.
• Implemented PgP Encryption of feed files functionality with open source utility.
• Successfully got the Project to Closure with zero SIT & Business Validation Testing.
• Dealt with 10+ clients to gather requirements and Involved in Design changes with PwC IT team.

Environment: SSIS 2013, IP Switch, SQL 2014, PgP Encryption Utility, ASP.Net 4.0, C#.Net 4.0 and JavaScript, CSS

Confidential

Technology Analyst

Responsibilities:

• Provided required assistance to the Onsite BA to gather the requirement by providing the enough Prototypes and Use-cases
• Created web application using ASP.NET Web Forms, AJAX Toolkit and Windows Communication Foundation (WCF)
• Designed and Created database objects such as stored procedures, functions and indexes using SQL Server 2012
• Involved in unit testing, module testing and integration testing.
• Configured application on TFS source control and created process for release deployment
• Deployed web application on Internet Information Server for DEV and QA/Test environment
• Followed Agile methodology
• Created Excel reports using Aspose Cells that would simulate reports on the web page by accessing the database
• Participated in requirement gathering.
• Converted requirements to design using Enterprise Architect.
• Contributed in DB design.
• Developed SSIS Packages in 2012 SQL Server and same were deployed using File System Deployment Model.
• Involved in most of Database Administrator Activities such as Always On, Indexing, Column Store Indexing, SSIS Package deployment models, Table Partitioning etc.
• Extracted data from different sources of data such as Oracle, Text file, Excel file, .Dat file and MDF files (Access database).
• Used Notification services to send email from SSIS.
• Performance Tuning & System Optimization Tasks.

Environment: SQL Server 2012, C#.Net 4.0, SSIS 2012, SQL Server Advisory Tool, SQL DB Comparer, MS Team Foundation Server. Database Administrator activities such as DB Back up, Cloning Database, Restore to different environments. Proxy for SQL Jobs.

Confidential

Technology Analyst

Responsibilities:

• Participated in requirement gathering.
• Converted technical requirements to design documents.
• Created Visio’s to show Workflow.
• Contributed in DB design.
• Developed SSIS Packages in SQL Server Integration Services 2008 and migrated all the SQL databases from 2000 to 2008 using SQL Server Advisory tool.
• Used SQL Server Integration Package Import Wizard to SSIS 2008 after development from lower environment to higher environment.
• Developed SSIS Packages around 120 in which 35 complex SSIS packages were having transformations which is implemented using SSIS Script Component in Data Flow task.
• Implemented Mail sending task in SSIS using both Send Mail task and script task.
• Performed unit testing, module testing and integration testing.
• Configured application on TFS source control and created process for release deployment
• Deployed web application on Internet Information Server for DEV and QA/Test environment
• Followed Waterfall model for project SDLC cycle

Environment: SQL Server 2008 R2, C#.Net 3.5, SSIS 2008, Database Administrator activities

Confidential

Senior Software Developer

Responsibilities:

• Analyzed the requirements and created Prototypes as Proof of concept
• Created Technical Design Document, UML (Use Case Diagrams, Sequence Diagram, and Class Diagram), Process flow Diagram, Data Flow Diagram.
• Developed Web Application using C# .Net 3.5, ASP.Net 3.5,SQL Server 2008 R2, Java Script, JQuery, Ajax Toolkit
• Implemented functionality of building different screens, menus and using C# as programming language
• Used Visual Studio.NET 2008 IDE to design the forms, develop and debug the application.
• Implemented version controlling using TFS.
• Performed Unit testing using N-Unit Framework by writing the Automated test cases
• Followed Agile methodology and Waterfall methodology
• Developed, Tested different aspects of Application

Environment: Windows 2008 R2 Server, SQL Server 2008R2, ASP.NET 3.5, C#.Net 3.5, Ajax, Java Script and SSRS reporting for reports.

Confidential

Senior Software Developer

Responsibilities:

• Analyzed the requirements and created Prototypes as Proof of concept
• Developed Web Application using C# .NET, ASP.Net 3.5, SQL Server 2008, Java Script, JQuery, Ajax Toolkit
• Implemented functionality of building different screens, menus and using ASP.Net, C# as programming language
• Used Visual Studio.NET 2008 IDE to design the forms, develop and debug the application.
• Used XML as flat file for Database
• Implemented version controlling using TFS 2010.
• Performed Unit testing using N-Unit Framework by writing the Automated test cases,
• Followed Water Fall methodology and Waterfall methodology
• Developed, Tested different aspects of Application

Environment: Windows 2008 R2 Server, SQL Server 2008R2, C#.Net 3.5, ASP.Net 3.5, AJAX, Java script.

Confidential

Developer

Responsibilities:

• Analyzed the requirements and created Prototypes as Proof of concept
• Developed Web Application using C# .NET, ASP.Net 3.5, SQL Server 2008, Java Script, JQuery, Ajax Toolkit
• Implemented functionality of building different screens, menus and using ASP.Net, C# as programming language.
• Used Visual Studio.NET 2008 IDE to design the forms, develop and debug the application.
• Used XML as flat file for Database
• Implemented version controlling using TFS 2010.
• Performed Unit testing using N-Unit Framework by writing the Automated test cases,
• Followed Water Fall methodology and Waterfall methodology
• Developed, Tested different aspects of Application

Environment: Windows 2008 R2 Server, SQL Server 2008R2, C#.Net 3.5, ASP.Net 3.5, AJAX, Java script.

Confidential

Developer

Responsibilities:

• Analyzed the requirements and created Prototypes as Proof of concept
• Developed Web Application using C# .NET, ASP.Net 3.5, SQL Server 2008, Java Script, JQuery and Ajax Toolkit.
• Implemented functionality of building different screens, menus and using ASP.Net, C# as programming language.
• Used Visual Studio.NET 2008 IDE to design the forms, develop and debug the application.
• Used XML as flat file for Database
• Implemented version controlling using TFS 2010.
• Performed Unit testing using N-Unit Framework by writing the Automated test cases,
• Followed Water Fall methodology and Waterfall methodology
• Developed, Tested different aspects of Application

Environment: Windows 2008 R2 Server, SQL Server 2008R2, C#.Net 3.5, ASP.Net 3.5, AJAX, Java script.