Professional Summary:

• About 6 years of IT experience with exceptional skills in all phases of SDLC, which includes requirement gathering, Analysis, Design, Development, Testing and Implementation of high scalable Client/Server, Multi-tiered Web Applications, Distributed Applications and Web Services using Microsoft Technologies in Petrochemical and Healthcare domains.
• Expertise in programming with Microsoft .Net technologies using C , VB.NET, ASP.NET, ADO.NET, SQL-Server 2008R2/2008/2005, Oracle 10g/9i/8i and Visual Studio 2012/2010/2008.
• Expertise in Object Oriented Analysis OOA and Object Oriented Design OOD using Unified Modelling Language UML and Object Oriented Programming OOPS concepts .
• Experience in windows mobile sdk and worked on mobile application development.
• Experience in implementing several Design Patterns Singleton Factory and MVC to standardize the application architecture.
• Proficient in Entity Framework ORM implementation. Experienced in designing the entire data access layer on entity framework.
• Proficient with .NET Web Services, Windows Communication Foundation WCF using WSDL and SOAP protocols.
• Extensive working experience with different methodologies like Agile Scrum and Waterfall methodologies.
• Solid knowledge and experience with Web Forms, AJAX, JavaScript, JQuery, UI design and development, consuming and manipulating data using ADO. NET.
• Expertise in Design and Development of Interfaces, User Controls and Custom Controls using ASP.NET and C .
• Experience in handling various backend data sources like MS SQL Server 2008R2/2008/2005, MS Access, and XML Data source.
• Extensive working experience in database design and development, for creating complex database queries, writing Constraints, Indexes, Views, Stored Procedures and Functions using T-SQL in SQL Server 2008R2/2008/2005.
• Knowledge on Windows Workflow Foundation WWF , Windows Presentation Foundation WPF and LINQ Frameworks.
• Worked on .NET Security features such as Authentication Authorization using Form-based and Window-based Authentication, Authorizing Users, Roles and User Account Impersonation.
• Experience in generating Custom Reports and different types of Tabular, Matrix, Ad-hoc and distributed reports in multiple formats using SQL Server Reporting Services SSRS .
• Knowledge of test driven development using N-Unit.
• Proven ability to analyse problems, root causes, and develop innovative solutions to business challenges and streamlining operations.
• Exceptional ability to quickly master new Technologies and capable of working in-group as well as independently with a sense of responsibility and ownership.
• Proficient in Big Data Technologies and C implementation of Hadoop Map Reduce Jobs.
• Knowledge of cloud based deployment using Windows Azure.

Technical Skills:

Work Experience:

Software Consultant

Confidential is a two module system, where data is managed through web portal and mobile application. Oil field operators use the mobile application and through centralized synchronization service the data is exported to the web portal. Similarly the asset configurations and the inspection jobs can be updated on the web portal by the admin and the information is transferred to the all the mobile phones on the field.

Responsibilities:

• Developed the logistics module in web portal.
• Developed the logistics module in mobile application.
• Optimized the Synchronization service. Added exceptional handling.
• Setup the central repository for the source code.
• Developed an asset management utility for Texas Flow Iron.
• Documented the logistics module design.

Environment: ASP.NET 4.0/3.5, C , ADO.NET, WCF, Visual Studio 2010/2008, SQL Server 2008R2, Telerik, Windows mobile SDK, IIS.

Software Engineer

Confidential project was designed to provide a secure and organized data repository for all relevant Louisiana data in response to the deep water horizon oil spill. The two main components of the project are technical work group tracking system and the data repository to maintain all the scientific data collected. The data repository will archive tens of thousands of documents, videos, photos, digital sound recordings, and other data needed by scientists to determine the extent of damage to Louisiana's marshes and coastline.

Responsibilities:

• Lead developer in the project. Initiated the implementation of design patterns.
• Streamlined the ETL process and improved the performance by almost 40 .
• Convinced the team to upgrade the application from framework 3.5 to 4.0. Improved the application performance by reducing cyclomatic complexity. Improved the performance by identifying issues from code review tools and recoding the method calls.
• Created SSIS packages for more than 150 forms. Improved the windows services and added configurations to log the ETL process.
• Build a few automation tools in C to create data objects and database structures to handle data migration.
• Worked with Business Analysts in understanding business requirements and analyzing use cases.
• Designed Use cases, Class diagrams and Sequence diagrams using MS Visio.
• Worked with ASP.NET Web Forms, State Management, Caching features for optimization and configuration of the web application using C .
• Implemented entire security layer using WCF in VB.NET. Hosted the service in IIS and centralized the security for all the sub projects in LOSDMS.
• Used LINQ to SQL extensively for data transfer across the components.
• Utilized ASP.NET Validation controls and JavaScript to perform client side validation.
• Worked on creating an interface to upload large data files > 300 MB using FTP to reduce the load on the IIS.
• Used Forms-based Authentication and Role-based Authorization for security.
• Developed Stored Procedures and Functions for data manipulation using T-SQL.
• Used Agile Scrum Methodology during implementation.
• Responsible for application support by performing root-cause analysis and bug fixing those were raised as Trouble Reports.
• Mentored junior developers in improving their coding skills, adhering to the client standards and best policies of the SDLC process.

Environment: ASP.NET 3.5, C , VB.NET, ADO.NET, WCF, CSS, Java Script, Visual Studio 2010/2008, SQL Server 2008R2, T-SQL, LINQ, MS Visio, SSIS, Crystal Reports, HTML, XML,Web Server, Windows Server 2008, IIS.

Confidential . Earlier all the sample data files are send in the form of XML files and they are processed. It's a new component and build on the top of LOSDMS data repository to add/edit the samples and their associated files. In the future, it will be utilized as a front end for both LOSDMS and DIS projects.

Responsibilities:

• All the intricacies of sample generation and their format is analysed from the PDF files and the raw xml files.
• Created as a separate project with its own database and wrote services to make calls to LOSDMS database.
• Responsible for deciding the requirements, database design, some of the project management tasks and implementing the stored procedures.
• Implemented transactional scope and unit of work design for the samples collection.
• Development major data objects in data access layer.
• Created a tool to read the PDF files and extract the samples from the forms directly.
• Created an interface to upload and download large sample associated files through FTP.
• Added project specific security and utilized the central security service to authorize the users.
• Used AJAX panels and CSS extensively.
• Used LINQ to SQL extensively for data transfer across the components.
• Utilized ASP.NET Validation controls and JavaScript to perform client side validation. Also handled few of the browser based compatibility issues.
• Implemented tree level folder structure for associated files to handle the indexing problem with windows explorer.
• Created a tool to filter all the raw associated files into their respective folders based on collection type and file type.
• Implemented captcha and nobot control.
• Used Agile Scrum Methodology during implementation.
• Responsible for application support by performing root-cause analysis and bug fixing those were raised as Trouble Reports.

Confidential system gets data from a lot of sources and the data is not in the same structure. It's a new component added on top of LOSDMS project to unify the data processing task.

Responsibilities:

• Lead developer in the data modelling and metric design.
• Responsible for deciding the requirements, database design, some of the project management tasks and implementing the stored procedures.
• Created measures and dimensions for initial cube design.
• Created SSIS packages for data transformation to better utilize the dimensions.
• Created reports on the raw data available. Involved in discussions with software architect on the design and requirements.
• Documented business workflows textually as well as in UML diagrams.

Environment: ASP.NET 4.0/3.5, C , VB.NET, SSAS, Visual Studio 2008, SQL Server 2008R2, UML diagrams.

Responsibilities:

• Participated in requirements gathering and compiled them into design document.
• Created Use case and Class diagrams in MS Visio using UML notations.
• Used Cascading Style Sheets CSS for a unified look and feel of the application.
• Used ODP.NET for data retrieving, querying, storage and manipulating interface screens developed using ASP.NET.
• Created and used User Controls and Custom Controls.
• Utilized ASP.NET validation controls and JavaScript to perform client side validation.
• Optimize the reports to handle the millions of complaints using materialized views. Created new data models to avoid high cost database operations while generating the reports.
• Created Joins, functions, stored procedures and triggers as part of the database programming.
• Involved in performance tuning and query optimization.
• Maintenance/Enhancement of Project and handling/fixing bug on daily basis.
• Created a tool to process HL7 format files.

Environment: ASP.NET 3.5, Visual Studio 2008, C , VB.NET, Oracle 10g, HTML, CSS, JavaScript, Windows Services, XML, UML, MS Visio, Web Server, Windows Server, IIS.

The system provides an interface for certified police departments agencies and sheriff offices to submit crime statistics to the FBI electronically. All the agencies place the incident files in a virtual directory and a windows service is used to track the new files and processes them to generate the detail error reports and UCR reports.

Responsibilities:

• Developed applications based on departmental requirements and specifications
• Prepared and executed test scenarios to test the functionality of the application
• Converted word document reports to rtf reports.
• Used ADO.NET to perform the CRUD Create, Retrieve, Update, Delete operations on the database
• Participated in database modelling and development using SQL Server, Stored Procedures and Functions.
• Generated Reports using Crystal Reports.
• Involved in resolving operational problems and systems failures by directing and/or performing systems audits, analysing problems and developing clear, concise methods for resolution.

Environment: ASP.NET 3.5, Visual Studio 2008, SQL Server 2008R2 , C , VB.NET, HTML, CSS, JavaScript, Windows Services, XML, UML, MS Visio, Web Server, Windows Server, IIS.

Database Analyst

Confidential is an airplane maintenance company. I have worked on a project taken up by the Louisiana state university to optimize the maintenance time duration and design an efficient schedule for airplane maintenance. The company's last 2 years records were analysed to optimize the present working schedule.

Responsibilities:

• Analysed the raw data and identified patterns in maintenance duration.
• Developed prototype to assign work shifts and automate the scheduler to avoid delays in aeroplane maintenance.
• Generated reports on average work schedule.
• Created stored procedures to filter the related and useful data from all the wrong entries and miscalculated times based on few of the flags as suggested by the DBA.
• Proposed database structural changes and a new interface was presented to better handle the maintenance tasks.

Environment: Visual Studio 2010, Microsoft project 2010, Ms-Access, SQL Server 2008

A research study was conducted to understand the performance of pipeline operators in the management of alarm systems and to measure the performance of operators in handling abnormal situations like pressure loss, liquid inflow/outflow variation and alarm floods. To evaluate the impact of different alarm rates and interfaces on operator performance, a liquid pipeline simulation experiment of 1 hour was developed and different alarm rates are tested using different scenarios. Thirty pipeline operator's data is collected and analyzed in the study.

Responsibilities:

• Created pipeline simulation including all the regular alarm scenarios.
• Travelled to few of the petro chemical control centres and trained the operators to run the simulation.
• Trained the petro-chemical and refinery operators about the simulation and guided them in completing the experiments.
• Data collected over 250 hours is studied and analysed to prove/disprove the hypothesis.
• Collected data from petro-chemical and refinery operators and did statistical analysis on the operator's performance.
• Presented master's thesis and submitted a paper to control room operator's consortium.

Environment: Stoner pipeline simulator SPS , Iconic Genesis-32, Ms-Access

Confidential for computerization of various activities of seed testing laboratory was developed. The seed testing laboratory provides a number of services to the farmers, seed certifying agencies and seed dealers which include regulatory monitoring and testing of the seeds, standardized purity and germination tests to determine the planting value of the submitted seed samples. Online modules were developed for registration of samples, testing procedures like physical purity test, Germination test.

Responsibilities:

• Designed online modules for registration of samples.
• Design documentation.
• Involved in the Requirements gathering and project demos.

Environment: Visual Studio 2008, C , SQL Server 2008