We provide IT Staff Augmentation Services!

Application And Database Programmer Resume

Skokie, IL

SUMMARY

  • C# / NET developer specializing in Microsoft Technology Stack on business applications, SQL Server and B2B data exchange services.
  • Experience as a Software Developer with deep understanding of the N - Tier .NET based Distributed Systems and Microsoft Technology Stack.
  • 10 years experience with UNIX/Linux, troubleshooting, networking, socket programming
  • Experience working with Visual Studio 2003/2005/2008 , .NET, Winform, DevExpress, ClickOnce, Web Service, ASP.NET
  • Extensive knowledge of C#, C++, C, T-SQL, BASH/SHELL/Perl
  • Experience working with SQL Server 2005/ 2008, SSRS, SSIS packages, ETL tools
  • Extensive knowledge of .NET/ C# development including networking programming.
  • Experience with interfacing with other enterprise systems through various messaging technologies such as web services, MQ.

TECHNICAL SKILLS

Programming Languages: C#, C++, C, MS Visual Studio 2005/2008/2010/2013

Software/Databases: .NET 2.0 - 4.5, SQL Server 2005/2008/2014 , ETL tool, SSIS/SSRS, IBM MQ, Structure Map/IoC, CodeSmith, ClickOnce NHibernate, Citrix, KORN/BASH SHELL/GCC Collection, STL, Multicast, Network/socket Libraries

Operating Systems: UNIX (Solaris, HP-UX, Linux)

Networking: TCP/UDP/IP, MQ, Web Service

PROFESSIONAL EXPERIENCE

Confidential, Skokie, IL

Application and Database Programmer

Responsibilities:

  • Enhancement and maintenance of a distributed electronic document processing workflow and integration.
  • Responsible for implementation, support and maintenance of all applications used for business operations of the firm.
  • Translate user requests into user interface applications (RePrintCheck, Dashboard Analytics and Auto Slide Dashboard, Live Check Processing, and Campaign Search) and implement back-end using EntityFramework/T-SQL.
  • Develop DevExpress/ClickOnce based Dashboard Designer and Dashboard Viewer with a custom security and used by risk analyst.
  • Analyzes production issue and find causes of errors and revises programs/queries/stored procedures. Backup for networking, VMWare, Ctrix and help desk/user support as needed.
  • Enhanced ETL process by reducing over 1 hour, Automation Procedures, BCP utility, Bulk Insert, etc. Migrated Sql Server 2005 into 2012/Windows 2012 R2.
  • Administrate and configure Cloud Hosting web service via Amazon WS/Bitnami/DreamFactory REST API. Participate REST API testing using Postman and Rest client tools.
  • Create DevExpress reports for infrastructure support etc., server disk space, sql agents job.
  • Citrix environment administration and user support. maintain production database backup, sql agents, and optimize sluggish query.

Confidential, Glenview, IL

Software Developer

Responsibilities:

  • Create and modify tables, views, stored procedures and Ad Hoc queries.
  • Create/update reports in SSRS 2008, creating sql objects and working with cascading parameters, linked reports, sub reports, filters, and charts.
  • Conversion, customization of legacy classic ASP application to ASP.NET.
  • Design, customization and implementation of web reports, Web Services.
  • Enhancement of a .NET 2.0 based proprietary CRM UI with DevExpress and .NET native controls.
  • Developed DevExpress based Dashboard Designer and Dashboard Viewer with a custom security and used by risk analyst.
  • Developing customizations, evaluate 3rd party tooling and further building out our custom CRM integrations that support our growing global CRM user base.
  • Coded to solve TCP/IP v4 vs v6 comparability.
  • Import/export data between SQL servers and various data sources using SSIS, Automation Procedures, BCP utility, Bulk Insert, etc.
  • Implement ASP.NET based projects sales reps, managers, administrative departments, operations, etc.
  • Added “Account Search” in CRM that communicates over Server Side CRM Web Service.
  • Integrated Reporting Services (SSRS) web service into a batch scheduling (Control-M) software for remote report generation.
  • Import/export data between SQL servers and various data sources using SSIS Automation Procedures, BCP utility, Bulk Insert, etc.
  • Added enhanced tracing and logging in CRM using log4net framework and Windows Performance Counters that aids support desk to troubleshoot effectively.

Confidential, Chicago, IL

Senior Software Developer

Responsibilities:

  • Developed Software for a multi-tier client/server stock loan application and trade capture system.
  • Implement C# libraries/middleware that provides MQ connectivity to SUNGARD Stock Lending Network.
  • Implement Make Return, Recall Return, Auto Borrow, End of Day Process Winforms and their associated business objects.
  • Implement C# library from SQL 2000 DTS workflow for faster user experience. Used ADO.NET objects in DAL to flow through the same work.
  • Implement C# customized exception manager class reported to Windows Event Service and error logging with log4net frame.
  • Participate in DB normalization, maintain physical DB integrity and optimize SQL queries for maximum efficiency.
  • Rewrite in set-based stored procedures from cursor-based.
  • Utilize Execution Plan and SQL Profiler to optimize sluggish queries.
  • Tune store procedures regularly, rebuild indexes, adding hint and eliminating unnecessary joins.
  • Analyze and test database objects & stored procedures before deployment to the production.
  • Add a real-time borrow/loan reclaims notification via SQL Mail Agent.
  • Implement ASP.NET forms for the morning import, short and long projections
  • Configure SSRS for Caching to Snapshot for better performance, scheduling and setting permission to report and user basis.
  • Develop drilldown, navigation, matrix for SSRS web reports per user request.
  • Support work for daily production issue.
  • Develop numerous SSIS packages that load import, transfer to feed external counter brokers.

Confidential, Chicago, IL

Software Consultant

Responsibilities:

  • Responsible for ongoing daily production support and continuous enhancement to GLOBEX Trader, a CME-provided N-tier client-server trading platform used by floor traders, from the maintenance to enhancement to Order Router/credit limit control, trader front-end (Win32/MFC/C++) and back-end (Linux/C++) market feed and order flow.
  • Provide daily support for traders with data issues, connectivity and response to failures and emergency fixes.
  • Port the backend order router from Solaris platform to Linux.
  • Supporting QA heavy load and functional test bed, following up the production deployment.
  • The work include analysis, environment setup and make file change to creation, GNU versus Solaris compiler and linker fixes, testing/debugging, diagnosing complier/platform issues and tool-induced build breaks fixes.

Confidential, Hoffman Estates, IL

Software Consultant

Responsibilities:

  • Implemented Oracle back-end DB C++ wrapper (PRO*C) in embedded SQL development and unit/integration testing
  • Target to run nightly Pro*C application that generates with embedded queries from 42 Confidential supported Centrex Switch System
  • Support business desks daily production issue, SQL logic re-evaluation, troubleshooting, schema change and coordination/ deployment
  • Responsible for QA and production weekly build process, resolve compiling/linking issue, workaround/tool limitation, deployment and integration testing across multiple releases
  • Developed a user interface that integrates in-house supply chain application with Tickle and UNIX scripts

Confidential, Chicago, IL

Software Developer

Responsibilities:

  • Developed C++ Order Book Feed for Instinet ECN, which provides a recoverable stream of orders and trades to Instinet customers through a dedicated TCP/IP session. The application receives depth of market and trade data, calculates Bid/Ask and publishes to a Sybase front server
  • Developed a TCL/TK GUI script interface that traps into the market data feed so as to loads/unload instruments in run-time thus eliminating intra-day shutdown
  • Monitor the trading environment, troubleshot the network/system and responded to failures
  • Optimized C++, Shell, SQL and Perl code and created numerous Shell/Perl scripts for traders, significantly increasing efficiency
  • Built a PERL application to connect to the CBOE URL from where to download daily option series, performs a rule-based check and inserts them into Sybase

Confidential, Chicago, IL

Software Developer

Responsibilities:

  • NASDAQ: Built Book Feed for NQDS real-time quotes for each Market Maker and Electronic Communication Network (ECN) in NASDAQ National Market and Small Cap issues
  • ISLAND ECN: Built the Book Feed for ITCH that disseminated its order and trade information and contained buy and sell orders, last match price and other information that is specific to Islands system
  • Korea Exchange: Built the Price Feed and Order Router for future/option order and trade information.
  • Each Feed and Order Router ran simultaneously on 2 sets of X.25 PVC channels, later ported to TCP and UDP ports
  • Chicago Stock Exchange: Built the Price Feed for quote, best price and size for all listed issues on the Exchange

Hire Now