SUMMARY:

• 19+ years of IT experience, which includes an expertise in the field of Architect, Design and develop Object Oriented systems and Web development as well as machine interfacing, with sound knowledge of RDBMS.
• My present work area is RAD (Rapid App. development) Qlikview, NPrinting, SharePoint and Essbase. Currently, I’m working as Software Engineer where my responsibilities start from gathering user requirements, designing, developing (writing and Re - writing), documenting projects ending in managing support.
• I work with waterfall or agile methods with equal comfort.

TECHNICAL SKILLS:

Rapid Application Development: .NET (C# Win-forms and ASP .NET with Web-services, WCF), XAML, Silverlight. VBA, HTML, CSS, JavaScript, SharePoint 2010

.Net: AJAX, XML, Crystal Reports, MS-Reporting Service reports, SSIS, Silverlight, WCF

RDBMS: Microsoft SQL Server, SYBASE, Adaptive server anywhere, Oracle

Data Warehousing/Business Intelligence: Essbase 11, SmartView, QlikView, Nprinting, Quilliup, Metric Insights

Other: MS Office, IIS (Internet Information server), OPC (OLE for process control)

WORK EXPERIENCE:

Confidential, Stamford CT

Software Developer

Responsibilities:

• Currently working with Business Intelligence dept., supporting, developing/redesigning dashboards in QlikView and NPrinting as business moves from homegrown application to Broadridge financial applications. Also working on Data warehousing with Hyperion Essbase
• Supported Shared Services, Treasury, FP&A departments. Recently completed migrating SharePoint 2007 to SharePoint 2010. Planning on migration of SharePoint 2010 applications to SharePoint 2013
• Completed SSRS reports for Treasury. Also converted some batch jobs from Perl to C# .Net applications
• Finished encryption for framework working for Essbase under C# application
• Completed SharePoint 2010 interface for scheduling and refreshing cubes
• Recently finished Data Reconciliation between Essbase, Oracle and file systems. Some processes were written in C# .Net
• Completed Single Book Hierarchy Management in SharePoint, .Net and Silverlight
• Designed, developed and implemented Finance Reporting Calendar in SharePoint 2010. Architected, designed, developed and deployed. Mostly in JQuery and SharePoint libraries in C# .Net
• Completed Architecting, design, develop and deployed project QuickBase to SharePoint 2010 named as Project manager. Used HTML, JQuery and SharePoint libraries in C# .Net
• Completed project for Regulatory reports workflow in SharePoint Designer, JavaScript and .Net
• Completed Architecting, design, develop project Summit, Transfer Pricing, for Finance and project is in SharePoint 2007, Silverlight and Oracle.
• Completed project MSP which interfaces between external vendor and RBS North America. Feeds data to Local ledger and RBS UK global feed. Used Sybase, C# .Net in Windows services
• Completed project Unicorn with Silverlight (4.0) in C# .Net 2010, SharePoint (2007), Oracle and Essbase. User interface is in Silverlight. Data access layer is designed in WCF (Windows service). Authorization and authentication for the project is handled by SharePoint. RDBMS is Oracle 11 and once workflow gets completed Essbase MAXL scripts are triggered; these scripts transfer data to Essbase cubes.
• Project handles financial accounts workflow and cost/account centers for general ledger.
• Developed user interface for project Matrix for Finance dept. in ASP .Net, deployed on SharePoint 2007. This project user interface was designed in ASP.Net. Used RDBMS SQL Server 2008. User interface application updated Essbase cubes using Windows service which was also serving as WCF service.
• Developed automatic financial report generation batch job in .C# .Net Console application, which generates reports at different times by combining data from multiple types of Databases (Sybase 12, Oracle and SQL Server 2008) and converts them to Excel. Then emails them to user.
• Architected and Developed human resource project Time Entry . Platform is C# ASP .NET 2008 with Framework 2.0, Web-Services, JavaScript, Ajax control toolkit and Sybase 12.5. Currently leading team of 2 who are supporting it.
• Data transfers between different systems in Web-Services, SQL server 2008 and Time Entry system was designed in SSIS. Reports for Time entry were designed in SSRS.

Application Developer

Responsibilities:

• Completed project “Blue-Cross Blue-Shield AZ” for health insurance.
• This is web based (C# ASP.NET 2.0, SQL Server 2005) with Crystal reports and heavy AJAX usage. Source control is TFS. Fixed source code, stored procedures written in SQL 2005 and wrote some of the JavaScript code. Was responsible for fixing (source code in .Net, .JS, HTML and stored procedures) and deploying the entire software

Software Engineer

Responsibilities:

• Worked with Tomra North America as Software engineer. Maintaining and upgrading existing software written in C# (.Net 2.0) and SQL Server 2005. This software creates automatic SQL Server Jobs and then using Modem, updates the remote machines automatically. Main software is in C# win-forms uses Web-services and Reporting is in ASPX pages. Version control was TFS and VSS
• Developed Software MHX Unloader with sample sheets. In C# - SQL 2005. This is Win-form Application with Web-services accessing stored procedures deployed using IIS (Smart client).

Sr. Programmer Analyst

Responsibilities:

• Worked on conversion of project Quest from PowerBuilder to C# .NET 2.0. This project constitutes of two projects. Main one is based on Win-forms (Smart Client) and secondary based on ASP .NET and Share-Point. Business logic was written in Web-services. Lead the team of 4. Used Database Oracle 10. version control was SVN.
• Architected as a team leader and partially developed TARMAC project for Commercial Equipment on Smart client and Web services for data transfer. Used Database Oracle, SQL Server 2005
• Upgraded existing ASP .NET projects from .NET 1.0 to .NET2.0 also from Infragistics 6 to 7. At the same time upgraded projects (some SSIS packages used Oracle Backend) to run on Vista 64. Used Database Oracle, SQL Server 2005 for data storage and stored procedures.
• Designed and Implemented insurance claims processing system in C# - ASP.NET (2.0) and Web-services Used Database - Oracle
• Fixed Data warehouse related problems in DTS and enhanced some of the functionality.
• Implemented Unearned Premium and Gross Written Premium reporting system for senior management. in C# - ASP.NET (2.0). Used Database - Oracle
• Developed website for N.A.D.A. in C# - ASP.NET(2.0). Used Database SQL Server 2005
• Analyzed and documented user requirements.
• Wrote system specs, Reports in Microsoft Reports (.RDLC)
• Supported and added modules to existing software.
• Quest: Power-Builder 9.0 based program, which is the backbone of this insurance industry. Supported, fixed bugs and enhanced the software.

Sr. Programmer Analyst

Responsibilities:

• Analyzed and documented user requirements. Wrote system specs.
• Design, Develop, Implement, optimize, document and support the software according to user needs.
• Experiment with new technology and finding out new solutions for the existing problems (decision making).
• Maintaining source control (VSS and object cycle), troubleshoot existing systems and databases, educate and mentoring junior colleagues.
• Lead the team in India for new projects designed in ASP .Net (Intranet)
• Help-Desk: This program is developed in Win-forms C# .NET(2.0). Program runs on server, reads e-mails sent to helpdesk and creates work orders in Main saver, and then returns work order no. to the user who sent the e-mail. Used Database SQL Server 2005
• Planning System: This system was developed in two parts: one in PowerBuilder 9.0 and second part in Microsoft Project 2003. This system works like Quintig software designed to match orders, assets, materials and manpower to generate the production plan. Used Database SQL Server 2005
• Warehouse weather control: To avoid oxidization of coils, temperature sensing and controlling is important. This is done in Win-forms and Windows service C# .NET programming and PLC communications via OPC.
• Automatic Shape Control: Completed in Win-forms C# .NET and Microsoft SQL Server 2000. This program reads from shape-meters and controls the crowns in the mill to give coil a better shape.
• Database Moving and Consolidation: Moved databases from Sybase 11.0 to Microsoft SQL server 2000 also merged two separate MS SQL server databases into one. After migration did necessary changes to Windows based applications and pointed them to right databases. Helped in VAX based applications to get proper DB connectivity.
• PowerBuilder to C# batch job Conversion: Designed and developed project in which, Batch jobs developed in PowerBuilder and Visual Basic 6.0 are integrated into windows service and Win-forms created in C# .NET.
• Shop Floor: Used as OLTP in Shop floor for all necessary tasks done for coil. It interacts between operators, machines and databases. This was developed on CITRIX (Thin Client), Power Builder (9.00), Borland C++ (5.0), Visual Basic (6.0 and embedded), OPC, Sybase 11 and Microsoft SQL Server.
• INTERNET: Web services for UA customers for online ordering and tracking. Project was developed under C# .NET, Microsoft SQL Server 2000 Sybase 11.
• EDI (Electronic Data Interchange): Batch job for communications with clients and vendors. Uploading and downloading then encoding and decoding documents from and to ftp.KleintSchmidt.com site. Tools used were Power Builder (9.00), Borland C++ (5.0), Microsoft SQL Server and Sybase 11.
• SERVER CHECKER: This is a windows service located on monitor server to monitor if servers (machines), databases, OPC servers and data collection servers are running flawless. If not generate emails and cell phone text messages to the respective personnel. Developed in C# .NET
• PERIODICITY: Directly connected to mills to monitor FFT (Fast Fourier Transformations). OLTP part was created in Borland C++ and data transfer and OLAP part was created in Power Builder. Databases used were Sybase 11 and Microsoft SQL Server.
• Tow-Trucks and Handheld Units: Wireless touch screen PCS or Handheld devices record all material movements. Programs in multi-tiered architecture are created entire project was developed in Power Builder (9.00), Visual Basic (6.0 and embedded for windows CE handheld units), Sybase 11 and Microsoft SQL Server. COM objects were used for similar functionality
• INTEGRATION with E-time, Main Saver, Goldmine and Database: All distributed data was centralized and batch jobs were written to synchronize the data between different systems. These batch jobs also created data for OLAP purposes.
• Scrap: Entire system to handle the scrap. System starts from reading scales to shipping the scrap. Batch jobs print invoices. Developed in Power Builder (9.00), Borland C++ (5.0), Barcode fonts and Sybase 11.
• Data Dictionary: Metadata project for all depts. Including IT dept. using Power Builder (9) and Sybase 11
• United Aluminum (project name): OLAP tool with reports and some entry screens. Designed framework, created standards and let other users add reports. Developed in Power Builder (9.00), Borland C++ (5.0), Sybase 11 and Microsoft SQL Server.
• Corrective Actions: This program was created functionally similar to Harrington Groups CAR program but it is multi-user with enhanced reports this project is developed in Power Builder (7.00 and now in 9.0) and Sybase 11 but it was converted to Microsoft SQL server 2000 as RDBMS.

Software Engineer

Responsibilities:

• Understood functionality of systems written in COBOL procedural language and interpreting them in Power Builder terms
• Developed and documented the EDDIE system.
• Quality testing done using SQA tool
• EDDIE - Reinsurance for GENRE: Re-insurance program divided in two modules complete 85% of casualty side and 20% property side using Power Builder (6.0) and Sybase 11