SUMMARY

• Over 11 years of experience in software analysys, design, development, implementation and testing of web and client server applications.
• Extensive knowledge in Database Designing, Programming, Modeling and Development using MS SQL Server 2012/2008/2005 and MS Access.
• Good experience in SQL (T - SQL), Triggers, Views, Cursors, Stored Procedures and User Defined Functions.
• Extensive experience with Confidential .Net Technologies (.Net Framework, MS Visual Studio, ADO.Net, ASP.Net, VB.Net, C#. Net).
• Extensive experience in Web development in Dot Net Framework 3.0/3.5/4.0/4.5 , Visual Studio 2013/2012/2010/2008 and GUI with JavaScript, VBScript, and HTML.
• Experience in working with configuration management and version control tools like Team Foundation Server (TFS), Visual Source Safe (VSS) and ADE.
• Good experience in WPF, Win forms, WCF and web services.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in designing and developing reports on SSRS (SQL Server Reporting Services), OLAP (Creating cubes).
• Good exprerience in Data Extraction, Transforming and Loading (ETL) in SQL Server Integration Services (SSIS)
• Good knowledge in JIRA, TFS
• Expertise in upgrading from DTS to SSIS packages, Logging, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables Deploying, resolving complex issues and Error Handling in SSIS.
• Expertise in creating Drill-through and Drill-down, multi parameterized, Sub Reports, Matrix reports, Linked reports, ad-hoc reports using MS SSRS 2008.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS
• Familiarity in building Web Services using WSDL, UDDI, DISCO and SOAP Protocol.
• Experience in Working with ASP.NET Web Forms, ASP.NET State Management, ASP.NET Caching features, Securing ASP.NET Web Applications and PHP.
• Experience in Installing, deploying, configuring, and monitoring troubleshooting web applications on IIS servers that run on Windows Server 2008/2012, Client/Server, and Web applications.
• Experience in building web Applications using ASP.NET MVC 3.0/4.0/5.0 Framework that allows you to implement Model View Controller Pattern.
• Experience in Software Development Life Cycle, testing, and Implementation of Client/Server applications using C#, with N-tier development environment.
• Dedicated, quick starter, solution driven pattern programmer, Strong inObject Oriented AnalysisandDesign, Excellent at solving complex problems under strict deadlines.
• Good experience in handling clients & meeting their requirements and willing to adapt to new Technologies /work environments, well organized Analytical & Leadership skills.
• Excellent verbal communication skills and highly motivated and ability to work independently or as an integral part of a team.

TECHNICAL SKILLS

Development Tool(IDE): Visual Studio 2013/2012/2010/2008/2005. Programming Languages .Net Framework 3.0/3.5/4.0/4.5 , VB.net, C#.Net, C, C++ Win Forms, WPF, VC++, ATL and COM

Web Technologies: ASP.Net, Web Forms, Web Services, MVC, Entity Framework, ADO.Net, LINQ, WCF and Unit Testing

Reporting Tools: Crystal Reports, SSRS, Confidential power BI

Databases: SQL Server 2012/2008/2005 , Oracle9i/10g/11g, PL/SQL.

Operating Systems: Windows 8.1, Windows 7 Windows Server 2008/2003.

Configuration & Version Control: Visual Source Safe -VSS, Team Foundation Server-TFS, ADE, JIRA

Scripting & Markup Languages: JavaScript, VB Script, HTML, DHTML, XML, CSS. Perl scripting and shell Scripting, PHP

Application Servers: IIS 5.0/6.0/7.0.

XML Technologies: AJAX, XML, SOAP, WSDL, UDDI, DISCO, Web Services.

Packages: MS Office (MS Word, MS Excel, PowerPoint etc.)

Design and Process: OOAD, Design Patterns, Waterfall, AGILE, SCRUM.

BigDATA: Hadoop, HDFS, HIVE, HBASE, SQOOP, MAPREDUCE

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Dot Net Developer and SQL Consultant

Responsibilities:

• Designed database architecture and in the full life cycle of the software project management, gathering, analyzing, and designing UI/Middle /data base layers.
• Created functional designs and designed technical document to be used for project development.
• Used Infragistics grid controls for user friendly data entry and exporting and importing features.
• Develop desktop applications involving N-Tier architecture; create components and libraries using vb.Net, C#.Net, XML and SQL-Server 2012/2008.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
• Implemented database standards and naming convention for the database objects.
• Extensive knowledge in using JIRA
• Used TFS and source control system for this project
• Developing SQL scripts for maintaining administration tasks.
• Implemented a data warehouse with SQL server.
• Designed OLAP cubes in SSIS
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Developed reports using Crystal report and used SSRS reporting for Adhoc reports.
• Created drill down, drill through, sub and linked reports using MS SSRS 2012 and Confidential power BI as well as managed the subscription of the reports.
• Converted MS SSRS 2005 and Excel based reports to MS SSRS 2012 based reports
• Created dashboards for products using benchmarked data to provide an analytical snapshot.
• Used cascaded parameters to generate a report from two different Data Sets.

Environment: ADO.NET, VB.NET, C#.NET, LINQ, SQL-Server 2012/2008, MS Power BI, JIRA, TFS, XML

Confidential, Houston, TX

Sr. Dot Net Developer and SQL Consultant

Responsibilities:

• Designed database architecture and in the full life cycle of the software project management, gathering, analyzing, and designing UI/Middle /data base layers.
• Created user friendly reporting through multi parameterized reports in MS SSRS 2012 and Confidential power BI which allows users the ability to make selections.
• Created Database Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Created functional designs and designed technical document to be used for project development.
• Conversion the legacy systems data into MS SQL server using DTS packages.
• Developing SQL scripts for maintaining administration tasks.
• Created multiple Drill-through and Drill-down reports using MS SSRS 2012.
• Provided MS SSRS 2012 training to clients in order for them to develop their own ad-hoc reports.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Involved with Query Optimization to increase the performance of the Report.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Converted .Net application to Confidential Azure Cloud Service Project as part of cloud deployment.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures. Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Transformed reports from Excel based reports to SSRS based reports.
• Loading data from Excel sheets into database.
• Migrated SQL Server 2008 database to Windows Azure SQL Database and updating the Connection Strings based on this
• Developed reports using Crystal report and used SSRS reporting for Adhoc reports.
• Used Infragistics grid controls for user friendly data entry and exporting and importing features.
• Developed windows based application using Win forms and WPF.
• Developed desktop and secured web applications involving N-Tier architecture; create components and libraries using ASP.Net, C#.Net, IIS, XML and SQL-Server 2008/2012 and Oracle.
• Used web services and .NET services to read data from other system and also provided services to other system to read Terminal system data.
• Used market application for various reports, documentation.

Environment: ASP.NET, ADO.NET, WCF, WPF, C#.NET, MVC, LINQ, SQL-Server 2012, Azure, JIRA, TFS, XML

Confidential

Responsibilities:

• As a Principle Member of Technical Staff, supporting high-performance computing plugins for the smooth build process.
• Design, develop and coding various plugins for Integration of builds
• Maintain uniform build process and developer needs through Hudson plugins
• Develop software using latest cutting edge technologies.
• Develop desktop and secured web applications involving N-Tier architecture, create components and libraries using ASP.Net C#, Net, XML and Oracle 10g/11g.
• Used PHP for as scripting language for effective presentation.
• Performed database tuning and stored procedures for better SQL server scalability and reliability.

Environment: C#, ASP .NET, LINQ, MVC, Oracle 10g/11g, Perl, ADE and Hudson

Confidential

Senior Member Technical Staff

Responsibilities:

• As a Senior Member of Technical Staff, developed an interface between ADE and integration for the smooth process of components builds.
• Supporting high-performance computing plugins for the smooth build process.
• Developed web service for the handheld functionality.
• Performed database tuning and stored procedures for better SQL server scalability and reliability.

Environment: VB.Net, .Net Framework 3.5, Sql Server, Oracle 9i/10g, PERL and ADE

Confidential

Build Engineer

Responsibilities:

• As a Member Technical Staff, involved in bug fixes of earlier versions
• Design, implement and coding of various features to automate the process
• Developed scripts using Perl and shell scripting to maintain the uniformity of the builds and automate the process
• Involved in various Release and deployment of Oracle products
• Actively involved in maintaining, fixes of different issues in Oracle 9i from version control perspective

Environment: Oracle 9i, PERL, ADE, farm and Ifarm

Confidential

Software Engineer

Responsibilities:

• Supporting Speech and Natural Language Group (SNL) in the Natural and Interactive Services Division (NISD)
• Design, develop and coding various plugins for Versions 3.0 and 3.1
• Worked on number of features, such as KWIC and filter keywords and NLS
• Develop software using latest cutting edge technologies.
• Develop desktop application involving N-Tier architecture; create components and libraries using VC++, ATL, STL and COM.
• Fixed no. Of bugs that were in versions 2.0 and 2.1
• Developed web service for the handheld functionality.

Environment: VC++ (MFC), Win32 API, STL and COM

Confidential

Software Engineer

Responsibilities:

• Involved and developed various functions and tested the functions in VB .net and My Basic.
• Design and Develop IDE for the MyBasic language create components and libraries using VC++
• Developed number of controls to support MyBasic.
• Design and develop UML like structure and functionality to support MyBasic

Environment: ASP.NET, VC++, VB.NET, HTML, SQL Server 2000, Visual Studio 2003