SUMMARY:

Developlarge scaledata driven programming applications for a company using microsoft technology.

COMPUTER SKILLS:

Programming Languages: HTML, DHTML, XML, CSS, Visual Basic 6.0, T - SQL, PL/SQL,SQL,XML,XSLT,VB.NET,C#.NET, DevExpress, ASP (VBScript, JavaScript), ASP.NET 4.0, Asp.Net MVC, jQuery,AJAX, C++, C, WCF, WPF

Database: Oracle 9i, MS Access, Oracle Developer i, SQL Server 7.0, 2000, 2005, 2008

Web Tools: FrontPage, Dreamweaver, IIS

Environment: s Visual Studio 2010, 2008, 2005, Visual Studio.NET, Visual InterdevSilverlight 4.0, TFS

Software Applications: Visio 2003, PhotoShop 6.0, Power Pivot Excel 2010, DotNetNuke

ERP Package: People Soft 7.5 (Crystal Reports)

Business Intelligence: SSIS, SSRS, SSAS

Development Methodology: Agile/Scrum

Design Patterns: Factory, Singleton, Facade

WORK EXPERIENCE:

Software Engineer

Confidential, Houston, TX

Responsibilities:

• Writing and modifying two crystal reports(version 11.0) usingVisual Studio 2013, TFS, Sql Server 2008 and C#.Net
• Creating a web application showing the atm transaction data that allowed the user to search for the data on a grid using Visual Studio 2013, TFS, Sql Server 2008 and C#.Net. By clicking the validate button on a row of the grid, the user is directed to another page where the routing # and bank account # can be entered and the data gets validated on the main page and the status of the row of the grid gets updated to “validated”.
• Creating a web application that allows the user to browse for an excel file on a local machine using Visual Studio 2013, TFS, Sql Server 2008 and C#.Net. The excel file is used to load the data on Sql server using SSIS. The data is validated against another table in the database. Any errors in the data are shown on a datagrid. If there are no errors on the excel file the data is inserted in a table and a success message is displayed.
• Wrote WCF web services and referenced them over the web and used them in the .Net program.
• Generated a well formed XML document through code.
• Worked with LINQ.

Software Engineer

Confidential, Houston, TX

Responsibilities:

• Modified and maintained a web project that is used to take care of pilot training requests using Visual Studio 2010, TFS,Sql Server 2008 and C#.Net. Created a data flow diagram using Visio for two modules of the project. Wrote a script in sql server job scheduler to take care of nightly requests. Modified one of the modules of the project that ran a web service when a military leave is requested.Automated emails are sent using the web service only when the leave is requested on a certain date and vacation dates fall within a certain range.
• Used scrum method of development methodology.

Software Engineer

Confidential, Houston, TX

Responsibilities:

• Modified and maintained a web project that is used to load, update well data to and from different data sources using Silverlight 4.0, Visual Studio 2010, Sql Server 2008, TFS and C#.Net.Web services written in PSL scripting language are being used to get the data from Sql server and assign it to a jsonObject and finally to the grid on the web page.
• The project consisted of a number of different web pages
• One of them contain a silverlight data grid that retrieves data from the Sql server database.
• The datagrids were used to filter, sort, insert and import as well as export the data into an excel sheet. One web page contained a silverlight panel control, a list box, and a tabbed control that contains the business rules defined by the user in the form of Sql statements, Javascript and grouped together in form of tabs. The scheduler manager web page is used to run jobs to load the data into the database.
• UsedC#.NET,ExtJs, Visual Studio 2010, TFS, SQL Server 2008, Oracle9i for writing different methods in Ensenada project. The methods are then tested in Petrotrek Scripting Library which contains Javascript. in order to make sure they are working fine.

Software Engineer

Confidential, Houston, TX

Responsibilities:

• Developed a web project using VB.NET, ASP.NET, Javascript, TFS,DevExpress and Oracle 10g. The project helps the end users such as the broker, attorney and Confidential users to go ahead and get the title clearance for the lands before drilling.
• Created a dashboard to show the status of the various entities like the abstract, well, units and unit leases and an explorer screen to show the details of the entities.
• Created a web form to upload documents to freedom application.
• Created forms authentication to validate both external as well as internal users for entering the web applications.
• Created a discussion board to check the status of the user submissions every few minutes.
• Created reports to show the title status and abstract curative priority of the lands.

Systems Analyst

Confidential, Houston, TX

Responsibilities:

• Developed web form for the strategic portfolio risk management group using C#.NET, ASP.NET, TFS, JavaScript and Dundas Chart.. The web forms displayed data prices for various commodities like oil, gas, power etc through the Dundas Chart tool for the time period specified by the user. The data prices calculated were based upon input parameters specified by the user which included peak/off-peak/round the clock, basis, spread, spark spread, multiplier, heat rates, correlation etc. The web application consists of a middle tier where different items are accessed through a generic list and LINQ. Web pages are designed using CSS, master and content pages.Created complex stored procedures in Sql serverthat are used to display the data onto the web page through the grid view control. Data can be exported to excel, pdf and powerpoint.
• Created a web project using Silverlight, Telerik controls, TFS andC#.Net. The web forms were displayed using grid view and telerik controls. The data was consumed usingWCF web services asynchronously and filled into an observable collection. The middle tier consisted of a separate class library which represented the various tables in the database. The user could look at the data on the web pages and either edit, update, insert or delete the data through the user interface into the corresponding database.
• Created and maintained an n-tier application using C#.NET, Visual Studio 2008, TFS and SQL Server 2008for the Strategic Portfolio Risk Management Group. The application uses excel file as user input which stores differentparameters such as curve type, price type, delivery and observation datesfor different commodities such as oil, gas, power etc. User can modify parameters through a lookup which in turn modifies values on other cells as per the formula entered.The input parameters are used in a complex stored procedure to extract either simulated or historical data prices which are further used in the middle tier to determine outputs such as historical volatility, cumulative volatility, spread, spark spread, dark spread, correlation, basis etc for different locations entered on the excel file.The calculations for the middle tier are done through a class library where the different items are accessed through a generic list and LINQ. The outputs such as volatility, highs and lows, correlation, slope, intercept etc for the different commodities are exported to excel file. The program then runs a VBA macro in a post processing tool that populates the prices in a desired presentation format requested by the group and sends the attachment as a pdf document to a group of people on a daily basis.
• Created a windows forms(Mdi parent/Mdi Child) application using C#, Visual Studio 2010, TFS and Sql Server 2008 for the SPRM group that takes the user input in terms of preference number and populates all the remaining parameters onto the form. The user then clicks onto another form where the data for the particular preference is displayed in a grid. The user can then click the print button on to a particular row of the grid to generate a XML file. A background worker process runs and monitors the response every 30 seconds from a 3rd party software for the newly generated XML in a particular folder and display the response to the end user. If the response is positive the user can go ahead and print the XML files.
• Created and maintaining an n-tier application using Visual C++, Visual Studio 2008, TFS and Sql Server 2008for the Strategic Portfolio Risk Management Group. The application uses excel file as the user input which contains data for different commodities and is used to calculate the simulated prices based upon historical prices in the database. The program helps in predicting the future prices for various commodities. The middle tier is designed using a class library which is used to retrieve the prices from a complex stored procedure in the database into a generic list which in turn is used to determine the simulated prices based upon the number of simulations entered by the user. The output of the program is stored in a text file which is then transferred into a cube for further analysis.
• Moved all programming applications to Windows 7 machine. The major code change involved was to change the build mode to a x86 machine instead of the usual x64.
• Created a SSIS project to take the output from text file containing the simulated prices and move into Sql Server 2008 table. The next step was to run a complex stored procedure that formatted the data and moved it into fact and dimension tables of a cube.Finally another task was added to process the Analysis Services cube and dimensions in the cube. The cube is run nightly to import the simulated prices into the fact and dimension tables. The package runs either on a test server or a production server with the switch in the value of the input parameter. A stored procedure is being used to retrieve connection strings related to either production or test server based upon the choice entered by the user.
• Created a SSISproject which loops through the various files stored in a folder and moves them to a destination folder depending upon the file name and timestamp using the script task. Only new files and changed files are moved over.
• Created several SSRS reports for the SPRM group to depict simulated prices for various commodity locations.
• Created a SSIS project that moves the data from oracle database to sql server database. The data is then moved to another sql server database where only new and modified records are inserted.
• Created a power pivot sheet in excel 2010 that replaced a macro sheet created in older version. The sheet calculated the prices based on a formula for different commodities and updated it automatically on a daily basis.
• Created a SSAS project that consists of a cube containing 4 dimension tables which included the delivery dates, observation dates, simulation ids and location ids. The fact table contains the simulated prices for different locations and references the dimension tables. The observation date and delivery date dimensions are stored in a hierarchial fashion. The prices for different curves were averaged using the average formula. Built 4 more cubes based upon similar principle.
• Created a complex stored procedure in Sql Server 2008 that took in the observation dates and built a dynamic sql statement based upon the formula entered in the database table. The statement was then used to update the price column in the temporary table which was later used to populate the fact and dimension tables of a cube.
• Created different kinds of views such as nested, encrypted, views with common table expressions, views with check option, indexed views, updatable views and distributed partition views for the SPRM group.
• Created different kinds of triggers such as instead of, after, DDL and SqlCLR triggers, scalar functions with different options like encryption, schemabinding, returns null on null input and execute as option, functions with parameters, inline table valued functions, multi-statement table valued functions.
• Created stored procedures with different kinds of transactions such as Explicit, autocommit, nested and implicit transactions in the database with different isolation levels (read committed, read committed etc). Used error handling in the stored procedures with the use of Try catch statements and Xact State clause for errors with severity greater than 17.

Software Engineer

Confidential, Houston, TX

Responsibilities:

• Developed web pages for the baggage management department using C#.NET,TFS, ASP.NET and AJAX. The web pages displayed information related to baggage losses, routing information through various stations, passenger information and error codes related to incorrect information present in the database. The web pages also supported custom datasets and web services created to communicate with an external data warehouse.
• Created complex reports using SSRS which communicate with sql server and Oracle as a backend and display the result onto the asp.NET pages.
• Created complex Oraclepackages, stored procedures and functions which are consumed by the reporting services.

Software Engineer

Confidential, Houston, TX

Responsibilities:

• Developed a tool using ASP.NET, VB.NETand MS Access that helps customers to register online, login and determine the status of placed orders. The tool shows the detailed job order information including the job location in a particular department and proposed shipping date. In case of shipped jobs, the program shows the actual ship date, items in the shipment, tracking numbers and carrier name. The data for the program is automatically updated every night using a VB.NET program which loads the information on shipped jobs and order details from the SQL Server 2000 database to the access database on the web.
• Developed a customer online helpdesk tool using ASP.NETAJAX, C#.NET and SQL Server 2005 that helps customers to register online, login and post issues related to a freely distributed software. The customers can post issues related to the software and online support personnel can respond live to the issues. The status of the issues is updated every few minutes through a timer tool. The tool has inbuilt capability for sending and receiving emails for new issues and response based upon those issues.The backend is through SQL Server2005 which contains numerous stored procedures and tables for holding data related to the helpdesk tool.
• Designed and built an online store using ASP.NET, C#.NET and SQL Server 2000 that helps customers shop for different types of products. The customer can build the order based upon requirements such as product type, quantity, material, accessories and other components. Based upon the chosen components the program shows how the final product will look like. The online store used Verisign’s SSL to securely process credit card transactions.
• Programmed and built an online form using ASP.NET and VB.NETthat allows the customers to register, login and request quotations for different company products. The program automatically sends an email message to the quotation manager and records the information entered by the user into the SQL Server 2000 database for further processing.
• Designed and programmed a tool using classicASP, VBScriptand MS Access that determines the detailed dimensions of a device called a clamp used as a load bearing member attached to pipelines. The user enters parameters like pipe size, temperature, material, load etc and the program designs the clamp best suited for the given conditions.
• Built a web based program using ASP.NETthat determines the correct size of the spring that can based upon the entered parameters like hot load, cold load and movement.
• Worked with a team of web programmers and graphic designers to build three company websites from scratch using FrontPage, Dreamweaver and Photoshop.
• Building and maintaining a program using VB.NET, Visual Studio.NET, MS Access and SQL Server 2000. The program designs a product called constants based upon parameters like load, travel, direction of travel and type of constant. Once the product is designed all the corresponding components are inserted into the SQL Server 2000 database. The program consists of reports built from crystal report tool that is used for viewing the detail bill of materials, line item summary and list of items to be cut in the shop.
• Designing, building and maintaining a program using C#.NET, Visual Studio.NET and SQL Server 2005. The program transfers the information for a job from the SQL Server 2000 database onto the local access database. The user can then enter dimensions of components into the program and execute them one at a time. The program has several validation functions that determine whether the details entered are correct. The program also additionalline items to the bill of materials depending upon the component type and dimension being executed.Several stored procedures and views stored on SQL Server database are used by the program for accessing, validating, querying and transferring the data back and forth between the client and the server. Crystal reports have been incorporated into the program for presenting the required data in a specified format. Different functions have been incorporated in the program to transfer the data to different departments once all the items in the job have been added to the bill of materials. The program also has a module to price different items in the job. Multipliers have been incorporated in the pricing module to modify unit prices based upon customer type. Search functionality incorporated in the program enables the user to search data for old jobs stored in the SQL Server based upon search parameters.
• Designed and built a program using C#.NET, Visual Studio.NET and SQL Server 2005. The program allows the user to post the jobs that are being shipped on a particular day. The user can post an entire shipment or a partial shipment entering the items to be shipped, the weight of the shipment, carrier name and tracking number. The user can also modify the shipment information and print shipped jobs, back order, shipment summary reports.
• Developed a program using VB.NET, Visual Studio.NET andSQL Server 2000 database. The program is used to determine the amount of product used for a specified time period. The user selects parameters like the product type, material, finish and certain constraints like maximum length. Based upon the parameters and constraints entered the program searches the SQL Server database, accesses and formats the data and presents it to the viewer on a crystal report. The product usage is helpful for the inventory program to determine how much quantity of raw material for a product to order in the next ordering cycle.
• Created a program using Visual Basic 6.0 for designing an entire pipe support assembly based upon input parameters like load, movement, material type and pipe size. Each component of the assembly is designed based on a complex logic and added to the bill of materials. The program can also create AutoCAD drawings showing detailed dimensions, elevations, layout plan and bill of materials. A large number of pipe supports can be designed simultaneously by making use of the spreadsheet tool with the parameter values entered in various columns.
• Used Query Analyzer to view estimated query execution plans, to debug queries withSQL debugger, and to automatically generate T-SQL statements for creating functions, stored procedures, views and triggers.
• Made extensive use of T-SQL statements for querying database and generating result sets for use in report creation and programming applications.
• Used Index Tuning Wizard to analyze database tables and queries to evaluate alternative indexes. Analyzed various reportsgenerated by the wizard to determine potential performance improvements.
• Wrote Stored Procedures, Views, Triggers, Functions and Cursors to move data acrossclient and server, to move data into temporary tables for further manipulation, toraise error messages and to generate result sets for crystal reports based upon parameter values.
• Created distributed views and queriesfor use with linked servers and split tables containing large data in the form of image columns.
• Analyzed different backup strategies by simulating a system failure and tested the backup and restored it effectively.
• Formulated database maintenance plan by creating schedules, specifying backup devices, performing database integrity checks and creating transaction log backups.
• Configured reports and created email notifications to operators based upon specific events occurring on the server.
• Configured application roles, user-defined database roles and permissions to enable application security and SQL Server administration.
• Used rich array of monitoring tools like SQL Server profiler, system monitor, system stored procedures and functions,current activity window in Enterprise Manager, trace files, error logs and application event logs toevaluateSQL Server performance.
• Configured SQL Server agent to create and edit alerts, jobs and operators.
• Moved data intoSQL Server databaseas well as other data sources through DTS. Modified existing DTS packages through the transformation tasks available in DTS designer.
• Evaluated different replication scenarios on a SQL Server database and configured subscriber, distributor and publisher fortransactional replication.
• Wrote SQL queries to extract data from the SQL Server database in xml format. Used XSLT to transform XML documents to HTML. Made extensive use of XPath querylanguage to query data from XML documents. Used DOM to create XML document programmatically and loaded the document as a tree structure to navigate through variousnodes and insert data into the database. Used updategrams to perform updates, inserts and deletes into a SQL Server database from a XML template.
• Made extensive use of Analysis Manager to create a cube with certain measures, dimensions and calculated members. Once the storage options were specified for data and aggregations,the data browser in analysis manager was used with different combinations of members to obtain sales and inventory usage data for specified time periods.
• Created clustered and non clustered indexes on large tables in order to enable faster data search.