SUMMARY:

A highly effective senior software developer with more than 20 plus years of programming and development experience in client/server and intranet web applications

TECHNICAL EXPERTISE:

Languages:

Proficient in: MS C#, VB.Net, ASP.Net, Powershell, Visual Basic, ASP.Net, JavaScript, VBScript, VBA, SQL, TSQL/Stored Procedures, ETL, Oracle PL/SQL Packages

Technology: Web Services (SOA), .NET Remoting, AJAX Controls Toolkit, SSIS (Integration Services), SQL Reporting Services (SSRS), Confidential (Data Transforming Services), MS - ADO/OLE DB, MS-DAO, MS-RDO, ActiveX COM/DCOM, Oracle for OLE, MS-RDS, MS-Remote Scripting, CSS, HTML, DHTML, XML, XSL, XMLDOM, XPath, RegExp

Software:

Tools: UIPath, Winautomation, MS Visual Studio, SQL Server Mgmt. Studio, MS-Visual Source Safe, SQL Navigator, TOAD, Crystal Reports

Database/Programming: Oracle (PL/SQL), Microsoft SQL Server (Transaction SQL), and Microsoft Access (VBA)

Platforms: Microsoft Windows

PROFESSIONAL EXPERIENCE:

Confidential

Team developer

Responsibilities:

• Design and implemented a Robot (bot) to automate and provide role access to a windows VoIP application named ECCS Dialer. The sturdy bot runs unattended and processes closed to a hundred user requests on a daily basis.
• Created and deployed many other role provisioning bots which automate critical applications including Consumer Banking Risk Management, Correspondent Product and Pricing Engine, Consensys Exchange Limits, and FTS SAS Technology Platform
• Provided support, maintain and making enhancements to existing bots on applications that require version upgrades or UI changes
• Documented all design process and workflow on each bot deployment/implementation

Confidential

Report Developer

Responsibilities:

• Identify and implement company business requirements/workflow that are supported by Siemens software CompliantPro
• Setup SQL Server 2008, and designed a multi-user relational reporting database to interact with SSRS
• Perform SSRS report design, development, visualization and publishing that allow for compelling report generation for both power and entry users alike including the use of executive dashboards, showing business activity and KPI by using various type of pie/bar/line charts and with necessary drilled-down detailed reports
• Extensively using joints and sub-queries for complex queries which were involving multiple tables. Analyzing data and re-mapping fields based on business requirements.
• Created and design store procedures, User defined functions, Views, T-SQL scripting for complex business logic. Optimized the database tables by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.
• Created, configured, and scheduled SSIS packages (ETL) to import data from proprietary CompliantPro database into SQL Server Reporting database, and created SSIS packages to monitor and capture daily data changes from CompliantPro database into SQL Server Reporting database
• Coded necessary SSRS custom expressions and functions using VB.Net scripting in BIDS to achieve and overcome some complexities of certain reports
• Designed and programmed Excel VBA modules and classes to acquire data, and to assist with custom controls embedded in offline Excel templates that are being used by quality inspection engineers out in the field
• Used C# to wrap up complex business logic and create COM Interop objects to interact with Excel VBA.

Confidential

Responsibilities:

• Setup SQL Server 2005, designed, created and implemented a multi-user relational database
• Coded in C# with ASP.Net, a web application, AppRat, for QA users to maintain application testing status on Windows 7 compatibility
• Modules consist of views, functions, and stored procedures using Transaction SQL, .Net web services (SOA) combining with DHTML for web front-end real-time data refresh, ADO.Net interfacing with SQL Server stored procedures, client-side AJAX Controls Toolkit, and DHTML with Javascript on the web front-end
• Perform ETL, using SSIS with C# scripting development to help gather data from other sources for the team and other teams
• Produced weekly complex Excel pivot reports for executives to monitor project’s progress and budgeting decision
• The enhanced application is also used throughout the GOP project to capture inventory, document decisions, and steward progress and issues.
• Support and enhance on-going development throughout all projects at Confidential
• Setup SQL Server 2000, designed and implemented a multi-user relational database to accommodate for mass data aggregation.
• Coded Confidential jobs (ETL) using VBScript, and scheduled them for data collection from many different database sources (AssetCenter, SMS, Active Directory, HR system, etc.)
• Gathered functional requirements from users and design, develop, and support a VB.Net with ASP.Net web application, GAToR, interfacing with SQL Server.
• The application provides the users with various types of real-time metrics on hardware assets, software licensing, and installs
• Coded all stored procedures and web services for Confidential jobs and web application interaction

Confidential

Responsibilities:

• Responsible for supports and enhancements on an IVRU system that interfaces with .Net components. The system allows cardholders to access their debit/prepaid card information through telephone calls.
• Support and enhance existing .Net components to interact with IRVU system.
• Support and enhance existing web interfaces (processor, issuer, and consumer) to accommodate for new features or fixes on certain web pages.
• Designed and code all stored procedures to work with .Net components and code-behind pages. Currently developing using ASP.Net 1.1.
• Work with QA team to come up with test cases for quality assurance on all new enhancements and developments before product release.

Confidential

Responsibilities:

• Coded ASP.Net website using C# and ADO.Net for clients to access our database in real-time to check their credit/debit cards balance and transactions history
• Created Oracle views, triggers, and stored procedures (PL/SQL) for C# and ASP.Net pages to access the database as well as for C++ back end code to process transactions
• Designed and developed a C# application for generating credit/debit and prepaid cards, importing fees, importing OnUsRules data from Excel spreadsheets
• Designed and developed in C#, an ACH application for processing direct deposits and fund transfer processing
• Created a DCOM object to interface with Outlook Express for sending mails
• Enhanced and supported IValue, an internet/intranet web interface, for accessing and maintaining cards transaction processing
• Wrote VBScripts and JScript to automate data file exchange between clients
• Developed, tested and scheduled financial reports using Crystal Reports and Oracle stored procedures

Confidential

Responsibilities:

• Add and modify ASP.Net code using VB.Net for data processing per customer’s requests
• Created and customized ASP.Net websites for customers to do online benefits, new hires, life events and HR related administrations
• Customized websites by modifying html and xml files to fulfill customers requests
• Coded all JavaScript for front end user’s input validations
• Supported and enhanced VB COM objects to access Oracle data from within ASP.Net pages

Confidential

Responsibilities:

• Designed and developed a client application and an out-process DCOM object.
• Designed and developed a pager/email application using VB6 as the front end and Oracle 7.3 as the back end. The application allows users to page a text message to anyone who is carrying a pager. It also allows users to send or check emails on their Exchange account.
• Designed and converted the pager application to a web application. This application was written using ASP/DHTML/Remote Scripting as the GUI interface to an Oracle database. The web application allows users to page a text message to anyone who is carrying a pager.
• Designed and converted a web application using ASP/HTML as the GUI interface to an Oracle database. The application allows users to request new or maintain current contractors that are temporarily employed at SSI.
• Designed and developed an NT service using VB6 and a third-party OCX tool. For better report performance purpose, the application running on an NT server box, as an NT service, replicates data, in real-time, from one Oracle database to another.

Confidential

Consultant

Responsibilities:

• Designed a Visual Gas application using OLE Automation technology to automate with Excel. The application linked to an Excel template through OLE Automation, sort out the unwanted gas data and import them into an Access database.

Confidential

Responsibilities:

• Used Rapid Application Development (RAD) techniques and analysis in the design of a client/server environment that involved VB 4.0, DAO, MS SQL Server 6.5 and Oracle 7.0.
• Used Erwin CASE tools to help generate database script
• Used Visual Basic to develop an application that allows Confidential engineers to query Space Shuttle part numbers based on the Vehicle ID and Serial Lot number. The result is then displayed in a formatted Crystal Report.
• Worked closely with Confidential engineers to design and code the application to their needs
• All queries and transaction processing were coded in SQL Server stored procedures