SUMMARY

• Microsoft Certified Solution Developer MCSD with over ten years of experience in Software Development that includes Team Lead Analysis Design Development Testing and Deployment of applications using .NET Technologies particularly ASP.NET C VB.NET and SQL Server.
• Experience in complete Software Development Life Cycle.
• Extensively involved in the Design Development and Unit testing of web based N-tier applications using .NET Framework for financial Hospitality and Healthcare sectors.
• Experienced in Object Oriented Programming OOP and in gathering user and functional requirements.
• Experience in converting the Business Requirements into Technical Specifications.
• Strong knowledge in Relational Database Management Systems and experience in writing T- SQL/PL SQL scripts Stored Procedures User Defined Functions and Triggers.
• Experience implementing various architectural patterns like SOA and MVC using Agile/ SCRUM methodologies.
• Proven ability to query and extract data from Data Warehouse and SSAS Cubes using T-SQL Excel Pivots and MDX.
• Very comfortable working in MSBI Suite SSRS SSAS SSIS .
• Highly skilled in creating reports using SSRS Crystal Reports XI/10/9.0
• Highly skilled in web building technologies like XML XSL XSLT DTD/Schemas HTML JavaScript CSS AJAX.
• Hands on experience in providing business intelligence solutions for big data environments using MSBI suite.
• Experienced in copying and transforming data from discrete data sources to SQL Server database using SSIS.
• Expertise in developing reusable libraries and deploying/debugging SSRS Reports in a web based environment.
• Excellent analytical inter-personal and communication skills with a strong desire to keep pace with latest technologies.

EXPERIENCE SUMMARY

Confidential

Technologies ASP.NET C VB.NET WCF SSRS SSIS SSAS Microsoft Visual Studio.NET 2008/2010 BIDS SQL Server 2008 SSMS MS Project Power Pivot MS Visio .NET Framework 3.5/4.0 and Subversion.

Confidential

Technologies ASP.NET C VB.NET WCF SAP .Net Connector 2.0/3.0 ADO.NET Microsoft Visual Studio.NET 2008 SQL Server 2008 MS Project AJAX MS Visio .NET Framework 3.5 Enterprise Library SAP HTTPWatch.

Confidential

Technologies ASP.NET C ASP ADO.NET Microsoft Visual Studio.NET 2003/2005 T- SQL XML XSLT SQL Server 2000/2005 Oracle 9i/10g Crystal Reports XI Telerik Controls MS Project MS Visio .NET Framework 1.1/2.0 MOSS 2007.

Confidential

Technologies ASP.NET C ADO.NET Microsoft Visual Studio.NET 2003/2005 T- SQL Visio XMLSPY XML XSLT SQL Server 2000/2005 .NET Framework 1.1/2.0 Infragistics MS Project MOSS and SharePoint Designer.

Confidential

Technologies ASP.NET C ADO.NET Visual Studio.NET 2003 CSS JavaScript HTML XML SQL Server 2000

Confidential

Technologies ASP.NET C ADO.NET Visual Studio.NET 2003 Visio XML VSS XSL HTML SQL Server 2000

Confidential

Technologies VB.NET C ASP.NET JavaScript XSD XML XSL SQL Server 2000 Oracle 8i.

TECHNICAL SKILLS

PROJECTS

Confidenital Senior Software Developer

Responsibilities

Architected developed and managed public web applications using C VB.Net ASP.Net and Infragistics tools. Maintained web based snapshot reporting application used to deploy reports and provision locations and enterprises. Enhanced existing and developed new benchmark reports for suppliers as per the business requirements. Designed and created WCF services for connecting third party POS systems to the in-house database for transactions. Designed and developed Category Management reports similar to the benchmark reports for enterprise specific needs. Modified the existing ETL scripts T- SQL for any improvements and changes in the data loading requirements. Assisted in ETL development during the migration of the legacy ETL stored procedures to SSIS packages. Developed several detail and summary reports including line pie charts trend analysis reports drill-through reports according to business requirements using SQL Server Reporting Services. Reengineered the existing web based reporting framework to improve scalability and maintainability. Designed BHD algorithm and implemented it as a service to replicate missing data for the CDS warehouse. Created and managed the development and staging environment on virtual machines for all the web applications. Enhanced the existing SSRS reports to create parameterized report templates rdl for functionally similar reports. Developed common stored procedures to be used as the datasets for the report templates. Designed and developed the ETL OLAP and dashboard reports for check level analytics on CDS warehouse. Enhanced SSRS reports to use SSAS cubes as the data source with dynamic MDX queries as the data sets. Created several MDX queries according to business requirements and for ad hoc reporting needs. Developed maintained and managed all analytical and mission-critical ad-hoc business reports for decision support. Debug and improve performance of slow running reports using SSMS SQL profiler and Activity Monitor. Responsible for weekly and month end data loads into CDS data warehouse and reprocess OLAP cubes. Assisted in database administration activities from time to time. Actively participate in various testing cycles to identify prioritize and resolve any defects as they arise based on priority.

Environment ASP.NET C VB.NET WCF SSRS SSIS SSAS Microsoft Visual Studio.NET 2008/2010 BIDS SQL Server 2008 SSMS MS Project Power Pivot MS Visio .NET Framework 3.5/4.0 and Subversion.

Confidenital Job Title Senior Software Developer

Travel Management System CMSP STCTS

Responsibilities

Participate actively in all phases of the project including planning and requirement gathering system analysis design of AJAX enabled Travel Management and STC Timesheet System. Perform impact and scope analysis of the various enhancement proposals and prepare detailed estimates with project schedule using MS Project 2003. Developed STCTS application based on MVC and LINQ that allows clients to work with timesheets over the web. Designed and Deployed all the necessary application and database framework to install CMSP GoPro.Net for the IFC. Acted as a single point of contact for all the maintenance related activities of CMSP between IFC and GoPro team. Developed Use Case diagrams in MS Visio and Screen-Mockups in HTML and Excel for effective communication in requirements gathering phase with the end users. Created and Used Master Pages and CSS for consistent look and feel. Developed ASP.Net AJAX enabled Web Application using .NET Framework 3.5 and having VB.NET as code behind. Developed Data Access layer to access SAP BAPI s using .NET SAP Connector 2.0/3.0 and SQL Stored Procedures using Enterprise Library in C . Responsible for developing WCF Service Libraries to exchange data between SAP backend and the web application. Created all database objects Stored Procedures Triggers Functions and Schemas for Storing Querying and manipulating data from SQL Server 2008 database Implemented common modules for session handling error logging and handling to be used in the website. Used Shunra application to do the performance test and analysis for remote site access from country offices. Created Test Cases and Test document for the web application in the Mercury Quality center.

Environment ASP.NET C VB.NET WCF ASP ADO.NET MVC LINQ .NET Connector 2.0 Microsoft Visual Studio.NET 2008 MS Visio .NET Framework 3.5. GoPro.Net

Confidenital Job Title Systems Analyst

.

Responsibilities

• Participate actively in all phases of the project including planning and requirement gathering system analysis design development release and implementation. Extensively involved in gathering user requirements and created design documents for database and web applications. Developed and Supported ASP.Net Web Application having C as code behind.
• Developed and modified existing Reports using Crystal Reports for various projects.
• Develop windows forms using VB.Net for the auto fax application.
• Created crystal report templates for each of the fax types in MAFCI application. Developed code to dynamically generate reports with logos and submit to the RightFax server to send the fax out. Created deployment documents for release management team. Prepare Weekly Reports Monthly Reports and Client Service Reports for the timely reporting of services rendered.

Environment ASP.NET C ASP ADO.NET Microsoft Visual Studio.NET 2003/2005 T- SQL Visio XML XSLT SQL Server 2000/2005 Oracle 9i/10g Crystal Reports XI Telerik Controls MS Project .NET Framework 1.1/2.0 and MS Visio.

Confidenital Senior Software Developer

Responsibilities

Extensively involved in gathering user requirements and created design documents for the database and the web application. Created Ajax Enabled Website to have partial page postback of WebPages. Downloaded and configured AJAX Control Toolkit for using controls in the application. Infragistics controls for web were used for displaying and editing hierarchical data. Used Master Pages and CSS for consistent look and feel Designed SQL Server 2005 Database such that data for each unit was stored in its individual Schema for ease of use maintenance and to facilitate each unit s custom reports that are to be generated from the database. Database users were dynamically impersonated from the web application based on the access of the logged in user. Created a project site in sharepoint for team collaboration and hosting project documents. Wrote database scripts that are executed every month for loading data from staging databases to the application s database. Worked with SAP and BW developers to load data from institutional repositories to the staging SQL databases. Worked with Quality Assurance developer and the Reports developer to write the Test Cases Test documents and generate excel reports out of database.

Strategy and Performance Contracts SPC and Afghanistan Reconstruction Trust Fund ARTF

Description Strategy and Performance and Contracts SPC is an intranet web-based application that is used by all the administrative units in the World Bank to monitor performance on a quarterly basis through the Quarterly Business Review QBR process informed by Key Performance Indicators KPIs that are being created and modified by the end users using the application user interface for Indicator Catalog. The application also creates an editable PDF from the database which displays the live data values that are being generated on the fly from the database tables in the XML format.

Responsibilities

Created the application logic using C and ASP.NET. Modified the XSD that is used by the PDF service to generate the editable PDF. Implemented the change of application architecture from storing the PDF XML in a database column to a set of database tables to facilitate easy reporting and maintenance. Created Load XSL Transformations so that the XML data retrieved from the SQL Server database fro generation of the PDF can be validated against the XSD. Created Save XSL Transformation to transform the XML data that is generated by the PDF Service into database consumable form before saving the data back into the database. Created new Stored Procedures and modified existing ones as required. Modified the existing SPC PDF service which is used to process the requests from the web application to generate a new PDF document. Created database scripts to automate the process of taking quarterly snapshots of the pdfs and implementing the quarterly rolling.

Environment ASP.NET C ADO.NET Microsoft Visual Studio.NET 2003/2005 T- SQL Visio XMLSPY XML XSLT SQL Server 2000/2005 Adobe Designer 7.0 .NET Framework 1.1/2.0 AJAX Control Toolkit Infragistics MS Project MOSS 2007 and Sharepoint Designer.

Confidenital Job Title Software Developer

Responsibilities

Extensively involved in gathering user requirements and created technical specifications. Rewrote the application using C and ASP.NET. Created database scripts to change the existing database schema for new requirements. Created new Stored Procedures and modified existing ones as required. Developed and Deployed Savings and Invoice reports so that the users can retrieve invoices and savings information.

Environment ASP.NET C ADO.NET Visual Studio.NET 2003 CSS JavaScript HTML XML SQL Server 2000 Visual Source Safe Crystal Reports 8.0 .NET Framework.

Confidenital Job Title Software Developer

Responsibilities

• Created Constraints and Triggers to ensure the Data Integrity of the database. Created Stored Procedures for all the database interactions from the web application. Developed WebForms using C ASP.NET CSS and JavaScript.
• Worked in creating Test Cases and Test document.
• Added new functionality for the Request Tracking System that exists for CSOIM Helpdesk.

Environment ASP.NET C ADO.NET Microsoft Visual Studio.NET 2003 T- SQL Visio XML XSL HTML SQL Server 2000 .NET Framework 1.1 Visual Source Safe.

Confidenital

Project s Web based Secure E-Mail System SEMS

Designed and developed virtual mall

Creation and Distribution of Digital Certificates for SSL implementation

Implementation of RBAC using XML for Web based Applications.

Job Title Graduate Research Assistant ULL

Description Designed and developed many cryptographic projects aimed at Internet Security under the guidance of my advisor Dr.T.R.N. Rao Z.L. Loflin Chair Professor . The major projects I have been involved in my tenure as a Research Assistant were Web Based Secure E-Mail System SEMS Development of a secured E-Commerce website Creation and Distribution of Digital Certificates for SSL protocol to access these secured sites Implementation of RBAC Role-Based Access Control for web-based applications using XML in .NET platform.

Environment VB.NET C ASP.NET JavaScript XSD XML XSL SQL Server 2000 Oracle 8i.