SUMMARY

• 8+ years of experience in Analysis, Design, Development, Testing and Maintenance of core business applications (Web, Windows, console, Class Library based applications and N - tier Architectures) involving all stages of Software Development Life Cycle (SDLC).
• Expertise in developing Web-based and Windows-based applications using C#.NET, WCF, VB.NET, ASP.NET, AJAX, JavaScript, JQuery, LINQ, VBScript, XML, HTML, CSS, IIS and Visual Studio 2003/05/08/10. Hands-on experience in a fast paced Agile Methodology Development Environment.
• Has good noledge in ASP.NET MVC 4, Entity Framework 4.0.
• Extensive working experience in database development, for creating complex database queries, Constraints, Indexes, Views, Cursor, Triggers, Stored Procedures and User Defined Functions using T-SQL and PL/SQL in SQL Server 2000/2005/2008, Oracle 10g using TOAD and SQL developer.
• Excellent experience in Creating, Consuming and Publishing Web Services.
• Strong noledge in Object Oriented Analysis & Design (OOAD) concepts including Inheritance, Polymorphism and Abstraction, Encapsulation, Constructor.
• Experience in migrating existing classic ASP to ASP.net, VB 6.0 to VB.net.
• Exclusively used ASP.NET Web Parts, Master Pages, User Controls, and Custom Controls to design the Rich User Interactive WebPages.
• Experience in developing Custom Reports and different types of Tabular, Ad-hoc and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) and Web I reports.
• Hands on experience in SSIS and SSAS.
• Experience in designing conceptual, logical and physical data models (DB design) based on Normalization principles.
• Worked in conversion of OLTP data to OLAP data to define facts and dimensions which helps to create SSAS cube.
• Experience in designing SSIS Packages for transferring data from multiple data sources to SQL server.
• Passing XML based input to Stored Procedure and parses the data.
• Has hands-on experience in publishing and deploying web based applications in IIS 5.0/6.0/7.0.
• Hands on experience in using Source Code Control Systems like MS Visual Source Safe (VSS) and Team Foundation Server (TFS).
• Developed .NET/SSIS batch jobs (scheduled jobs) which send out email notifications to users and perform other DB transaction tasks.
• Experience in preparation of detailed design document (DLD), Unit Test case, System test plan, Integration test plans and Traceability Matrix.
• Experience in defining application flow in pseudo code, Sequence and Class diagram (UML).
• Experience in designing images and stylish buttons in Photoshop.
• Performed Job scheduling, Performance tuning, Execution Monitoring (SQL Profiler) and production support for critical applications.
• Good team player wif excellent communication and interpersonal skills and an ability to work individually or part of a team and good learner to adapt new technologies that improves the organization business.

TECHNICAL SKILLS

Microsoft .NET: ASP.NET MVC 4, ASP.NET 2003/2005/2008/2010/2012, .NET Framework 1.1/2.0/3.5/4.0, C#.NET, VB.NET, ADO.NETWebServices and WCF, XML, AJAX, LINQ, ASP, VB 6.0, CSS.

Inter Technology: HTML, JQuery, Java script, VB script.

Applications Type: Web, Windows/desktop, Console (batch jobs/windows services) and Class library.

RDBMS: SQL Server 2008, TOAD (Oracle 9i), My SQL 5.0.

Business Intelligence (MSBI): SQL Server Analysis Services (SSAS), MDX query, SQL Server Reporting Services (SSRS), Reporting Manager, and SQL Server Integration Services (SSIS), SQL Jobs.

Web Server: Internet Information Service 6.0

Code Base: Team Foundation Server (TFS), Visual Source Safe (VSS).

Data Modeling: ER Studio 8.0.3(Logical, Conceptual and Physical data models)

Data Handling: OLTP and OLAP

SAP Business Objects: Data Services Designer (ETL), Universe, Web I, and Info view.

Third Party: IBM Message Queue, Theobald SAP Connector, GC Power tooland Ultimate Spell, iTextsharp.dll

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

Developer

Responsibilities:

• Designed a custom control for SSN, Phone and Date box in order to minimize validation effort thought out the application.
• Created User Defined Functions to encrypt and decrypt the SSN and store in database.
• Converted image files to PDF and uploaded into server and show the Iframe popup.
• Passing XML based input to Stored Procedure and parses the data.
• Implemented HUB verification (Web service call) wif state data and federal data hub in order to verify SSN, Citizenship, Age, Residency, and Income.
• Designed a Notice tool which attaches the PDF layouts dynamically and send email notifications to customer wif RFI attachments.
• Designed a verification popup which can be used by different user roles and content would change dynamically.
• Designed an error control which is being used in all pages for server side validation to display the error messages from database.
• Implemented quick find functionality which would search the records showed in the grid view and highlight and filter only those.
• Implemented CALC module for verification documents which would decide what are the documents required from consumer.
• Implemented audio file uploading.
• Worked on renewal module which would automatically copy the data from old application to new application wif required due dates.
• Created a Track module to configure the state workers skills and location.
• Implemented eligibility results page which would summarize the enrollment details and potential eligible programs.
• Created several web forms in the application.

Confidential, Dallas, Texas

Onsite Coordinator, Project Lead, Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) such as business requirement gathering, preparation functional requirement and Detailed Design Document (DLD), estimation(Resource and time), Traceability matrix, build, testing(UT, IT, ST), UAT, deployment and hyper care support.
• Worked as per Agile Methodology (Scrum) to meet customer expectation, timelines wif quality deliverables.
• Implemented object oriented concepts such as inheritance, polymorphism, interface and abstract class.
• Implemented in 3 tier Architecture which has UI, Business Layer and Data Access Layer.
• To improve the performance of the system from DB - created index to fast retrieval of the data, fine tune stored procedure join & where clause and followed the normalization principles while creating tables. Analyzed the execution plan for each T-SQL & stored procedures.
• To improve the performance of the system from UI(C# code) - Removed declaring unnecessary variables and creation of objects, released memory/resource of unused objects (Garbage collection), performed NULL check and used AJAX tool kit to refresh only portion of the page instead of refreshing the entire page and avoided the use of server side controls as much as possible.
• Implemented 5 different language translations in the UI using resource files (.resx) and language culture properties.
• Created web service to fetch functional locations from various local site DBs.
• To avoid post back on page control events, AJAX script manager and update panel used which avoids refreshing the entire page.
• Created SSAS cube based on OLAP data (measures and dimensions) which has defined STAR schema.
• Created SSRS reports which pass input parameters to stored procedures.
• Created stored procedures, triggers, cursors, views and user defined functions for maintaining business functionalities.
• Created batch file which automatically deploys web.Config and header images in each application environments to avoid human mistakes while deploying.
• Implemented view state to pass the objects/values wif in the same page using serialization attribute. Used query string and hidden fields to maintain/pass certain values from one page to another.
• Used AJAX tab container tool in order to avoid the page scrolling horizontally and vertically.
• Implemented exception handling and all exceptions were logged in SQL table and event viewer.
• Used third party component “Theobald Connector” which was used in SSIS package to fetch SAP PP system process order to SQL server database table via Remote function call.
• Scheduled SSIS package which synchronize the Process Order from SAP to Central DB every one hour.
• Web. Sitemap file used to display the menu items based on user roles defined.
• Provided excel import option to facilitate bulk import into the system to avoid manual entry.
• Implemented Java script error/warning message for client side validation.
• Implemented grid view control which has dropdown list as nested control in each row. Based on user role, only particular rows are editable in grid view.
• Developed ASP.NET (ASPX) class/modules to display backend data on the web browser using ADO.NET.
• Intensive use of Master Page where windows login id is autanticated against database user id and stored in session object. Created common layout of the application and used dis master page access all UI pages.
• Styles implemented using CSS, theme and skin.
• Created public properties (get and set) to access the data from different user controls.
• SMTP protocol used in the application to send email notifications to plant engineer/supervisor on successful loss allocation.
• Using Photoshop, created header images and stylish buttons.
• Programmed ADO.NET for communication between application and database and extensively used data Set, Data Table, execute scalar, data reader and Data Adapter.
• Followed .NET coding standards and MODLOG.
• Used Team Foundation Server (TFS) for Version Control, creating and managing projects and accessing the items.

Confidential, Dallas, Texas

Onsite Coordinator, Project Lead, Developer

Responsibilities:

• Implemented 7 different language translations in the UI using resource files (.resx) and language culture properties.
• Created SSIS package to fetch global users list from SAP HR module using “Theobald connector” via RFC (Remote Function Call). While loading the user list, user’s site, units, business line and other master data would be mapped.
• Used ASP.NET tree view control to display the result as per organization employee hierarchy.
• Action PPR can upload the Evidence to SharePoint site.
• Created web service which submits work Notifications to SAP CRP system.
• Used AJAX Auto Extender control to implement outlook style search while typing the characters which uses web service to fetch the user list from SQL database.
• Used and to customize the user’s home screen.
• Scheduled SSIS package sends out email notifications to PPR and event owner based due date and other scenarios.
• Used AJAX tab container tool to avoid the page scrolling horizontally and vertically.
• Sorting and paging implemented in grid view control.
• Implemented Cookie object to store the user’s default search criteria.
• Implemented Data list control to display the event viewers list in column wise.
• Implemented Progress Template control to show image/text while loading page.
• Created SQL reports for Events, Actions and supervisors.

Confidential, Rochester, New York

Onsite Coordinator, Project Lead, Developer

Responsibilities:

• Crated ETL jobs which pull source data from SAP BW (Which fetches data from SAP CRM) and legacy mainframe systems (such as SMIS, ESS and STAR) and load those data into IBASE and Contract data models.
• Involved in business requirement gathering, functional requirement document, Build, Unit and Integration testing and Production Go live and support.
• Created Installed based (IB) and Service Contract data model as per SAP CRM implementation which would link product, customer and geographical master data.
• Based on billing plan, contract/warranty information (as per CRM implementation), Designed a new SQL database/table structure as per Normalization principles. ETL jobs run on a daily basis and loads the data into these data models.
• Created conceptual, logical and Physical data models using ER studio.
• All transaction data (OLTP) has been migrated to OLAP data mart in order to slice and dice the data which helped to create a SSAS cube.
• Created Web I and SSRS reports which helps business users to analyze the results based on customer location, product hierarchy, install base, component types, contract time period/expiration date, Business segment/Sub Segment etc.
• Created Universe on top of OLAP database.
• Cube security has been implemented using a .NET dll which executes the stored procedure and returns the user roles in MDX query format.