SKILLS:

• Personal: Excellent communication and technical writing skills.
• Programming: Strong MS SQL Server expertise with T-SQL in stored procedures, functions, triggers, SQL-DMO, Reporting Services, and performance tuning. XML with XSL/XSLT, ASP Classic, WSC, VBScript, JavaScript, HTML, VB 6.0, some Dot Net.
• Operating Systems: MS Windows 2000/XP/Vista/7, Ubuntu Linux, Android 2.x-4.x.
• Software: MS SQL Server 2000-2008, MS IIS 5.0-7.0, MS BizTalk 2004/2006, Subversion.
• Industry Skills: Electricity and Gas billing, EDI.

EXPERIENCE:

Confidential

Senior Software Engineer/Consultant

• Industry knowledge: Energy billing, EDI.
• Development:
• Consulting the development team on database tuning and optimizations.
• Maintaining and enhancing the billing solution using MS SQL Server 2008 with some VB.NET.
• Optimizing reporting queries and stored procedures.
• Re-architecting key components for greater system scalability.
• Creating various tools for automating processes such as data migrations and generating EDI files.
• Database Administration
• Tuning and maintaining table indexes.
• General database tasks such as backup and maintenance scheduling.
• Disaster recovery preparation.
• Ongoing performance monitoring of several SQL Servers.

Confidential

Senior Software Engineer

• Project management: Weekly status meetings, monthly progress reports, daily resource management, and time/costs tracking for software defect resolutions and enhancement development.
• Prospect acquisitions: Participated in RFP responses, came up with estimates, assisted with technical demos.
• Client relations: Technical lead and point-of-contact for several clients, which included expectation management, collaborative prioritization of feature requests/bug fixes, and end-user training.
• Agile: Participated in all stages of software development life cycle of solutions for the NirvanaSoft complex billing system using the agile methodology. Requirements gathering, estimation of work, writing specifications, managing of resources, design and code reviews, coding, testing, and documentation.
• Industry knowledge: Extensive experience with billing terminology, products, market specifics, and familiarity with EDI, in energy background.
• Development: Key member of a team working on enhancing and maintaining NirvanaSoft's suite of applications.
• Developed solutions to client specifications using MS SQL Server 2005/2008, MS BizTalk 2004/2006, Classic ASP with JavaScript/VBScript, XML, and some VB.NET.
• Maintained a 3-tier architecture solution with ASP front-end, SQL Server back-end, and BizTalk for transaction management.
• Lead development on several key portions of NirvanaSoft system such as reporting/invoicing using SQL Server Reporting Services, and auditing module. Participated in redesign of core components such as sales tax processing, rating engine, and invoicing.
• Analyzed various components of NirvanaSoft solution, and proposing architectural changes that would enhance performance, work-flow and usability.
• Database analysis and tuning for performance in heavy load processing in multi-user environment: re-factoring stored procedures, analyzing table indexes and statistics, taking advantage of newer SQL Server mechanisms.
• Leadership: Mentoring and training of junior developers. Prepared and presented knowledge sharing sessions on various subjects.

Confidential

Software Engineer

• Managed an SQL Server 2000 database that contains information about Mobile123's partner-dealers, daily airtime sales and purchases, accounting, commissions, inventory management and more.
• Integrated with various nationwide prepay airtime carriers including Verizon Wireless, AT T Wireless, Singular, T-Mobile and others for seamless transaction processing and reporting.
• Developed various front-end applications using Visual Basic 6.0, MS Access VBA with SQL Server 2000 on the back-end for customer support and accounting.
• Built a solution for integrating Point-of-Sale POS electronic pin dispensing terminals into the existing database system utilizing Visual Basic 6.0 as well as building a comprehensive web-based interface with HTML, ASP 3.0, VBScript and JavaScript.
• Developed a payment solution utilizing Visual Basic 6.0 with XML, stored procedures and triggers for the use by the POS system. Integrated with InterCept Payment Solutions and utilized their real-time transaction components for processing electronic payments.
• Developed a sub-dealer commission system based on Mobile123's sales reports and Veizon's airtime activity reports. Created utilities in VBA for integrating MS Word-based reports into Mobile123 database and using that data for calculation of sub-dealer commissions.
• Enhanced an existing airtime inventory, management and tracking system on SQL Server 2000.

Confidential

Software Developer/Consultant

• Developed a comprehensive solution for Jovus' client Lincoln Financial that automated generation of portfolio analysis reports.
• Created technical requirement specifications based on client's needs and feedback outlined project plans and realistic schedules for all phases of development.
• Participated in selecting appropriate tools and technologies Visual Basic 6.0, MS Excel VBA and XML for the development phase of the project based on requirements.
• Developed a data-entry application on Visual Basic 6.0 utilizing XML-DOM for generating output files that could be imported by various reporting applications.
• Developed MS Excel Templates and Add-Ins using VBA that automated client processes, such as manipulation of various data components, obtaining external feeds and providing client with reporting tools.
• Consulted the client on strategy for deploying the finished product nationwide among 400 users.

Confidential

Software Developer/Consultant

• Dealogic provides global coverage of corporate finance activity and global deal management systems and is a recognized leader in the field of deal management systems both in the US and internationally.
• Developed financial applications on PowerBuilder 6.5 and 7.0 with Sybase v.10 on back-end.
• Maintained and enhanced software package called SynDesk and its various components for clients such as Morgan Stanley, Merrill Lynch, Bear Stearns, Salomon Smith Barney and others
• Participated in development of the new generation of SynDesk software on ASP 3.0 with VBScript, JavaScript, HTML and XML/XSL.
• Customized applications and generated customized reports to comply with client specifications.
• Developed supporting applications that allowed clients to transmit data over the Internet.
• Converted existing applications to the latest version of PowerBuilder and optimized the code to take advantage of new features of the programming language to improve performance of the software.

Confidential

Senior Software Engineer/Web Developer

• Architected, designed, developed and deployed a new generation of database-driven multimedia presentation Engine called Iguana on Windows 2000 platform.
• Used the latest technologies such as Visual Basic 6.0, MS Access 2000, SQL Server 7.0 and advanced programming techniques such as ADO 2.6, ActiveX and COM to further improve the product and add functionality.
• Developed and maintained Web sites and applications using HTML, JavaScript, XML, XSL and CSS.
• Developed client-specific Intranet sites containing various managing and reporting utilities with SQL Server 7.0 on back-end using HTML, JavaScript, ASP and VBScript.
• Ensured that said Internet and Intranet sites operate properly under diverse Operating Systems and Browser version variations MS Windows, Mac, etc., Internet Explorer, Netscape Navigator/Communicator, etc.
• Developed Internet-hosted repository of information and media called the Cybrary Server based on SQL Server 7.0 for companies, such as GTE/Genuity, AOL, Oracle, NBA, NFL, Amex, Mercedes, Comedy Central, SFX and Bravo.
• Developed client and server side applications for Cybrary Server called Iguana Sync and Iguana Post for updating data and media over the Internet FTP protocol with SSL via the Cybrary Server, thus enabling clients to have a true information infrastructure by keeping the information synchronized across all users.
• Utilized triggers, stored procedures and SQL Server's replication capabilities to synchronize data over the Internet connection for Cybrary Server applications.
• Developed, deployed and maintained COM components for the server-side automation processes of Iguana Post and Iguana Sync applications. Deploying and maintaining these COM components on Internet Information Server 5.0.
• Used IIS 5 to host and maintain secure FTP sites to hold multiple clients' media that was updated via the Sync and Post applications. Employed IIS's advanced features to set up user accounts and groups to grant the subscribers access to only their own media.
• Wrote Stored Procedures and Triggers in SQL Server databases in order to implement the business logic in the Database tier.
• Maintained and serviced custom applications written in Visual Basic 6.0 and Visual C 6.0 with SQL Server 7.0.

Confidential

Software Developer

• Developed database-driven Multimedia Presentation engine called Pitchman using Visual Basic 5.0 and MS Access 97.
• Developed Multimedia presentations using the Pitchman engine for Fortune 500 companies, such as Cigna, Hilton, NBC, FOX, British Airways, GE, Sony, Lucent Technologies, IBM and Intel.
• Optimized the programs by introducing more efficient coding techniques.
• Used advanced utilities such as COM, DAO, ADO and API to further enhance the developed applications.
• Created customized, client-specific external applications for the Pitchman engine using Visual Basic 5.0, Visual C 5.0, Visual Basic for Applications VBA , MS Access and MS PowerPoint.
• Created COM components that were utilized by various software applications.
• Daily cataloged the changes made to the code through MS Visual SourceSafe 5.0.
• Debugged the applications and wrote error handling routines to ensure bug-free and user-friendly environment for the clients.
• Enhanced several financial projects for Merrill Lynch by converting the code from Macromedia Director 6.0 to Visual Basic 5.0 and adding new features.
• Assisted VC engineers in developing applications on Visual C 5.0.
• Created customized installation scripts using InstallShield Professional versions 3.1 and 5.0.

REFERENCES: Available upon request.