PROFESSIONAL SUMMARY:

• Experience includes managing the functional aspects of the software development life cycle, including gathering requirements, testing and training end users.
• Years of industry experience in Client Server technology environments.
• A client - focused software development consultant with strong problem domain definition, architectural, design and object oriented a development skill; that brings an in-depth, real world experience with all phases of development from problem definition and requirements gathering, to design and architecture specification, component development, system integration, QA, staging, deployment and documentation.
• Experience with a broad range of skills including: multi-threaded event driven development, integration of multiple client and server technologies, semantic architecture, database design, data transformation and enterprise application integration.

BUSINESS / TECHNICAL SKILLS:

• DEVELOPMENT LANGUAGES
• Visual C++
• C#
• C++
• HTML
• HTML5
• VB.NET
• PowerBuilder
• SQL
• VC++.NET
• SAS
• DEVELOPMENT TOOLS
• ATL
• Crystal Reports
• Structured Query Language (SQL)
• SQL Anywhere
• MFC
• Visio
• VBScript/JavaScript
• MS Word
• ActiveReports
• Install Shield
• Ghost Pro
• MS PowerPoint
• MS Excel
• Active Sync
• STL
• Telerik Reports
• DATABASES
• Microsoft SQL Server
• Sybase
• Oracle
• Informix
• Microsoft Access
• Btrieve
• SQL Azure
• OPERATING SYSTEMS
• LINUX
• VMS
• Microsoft Windows 2000/XP/7
• Windows CE
• NT Server
• UNIX TOOLS
• Visual Difference
• Perl
• GZIP
• TAR/FTP
• VERSION CONTROL
• TFS/SourceSafe
• PVCS
• ClearCase/ClearQuest
• Serena
• MODELING TOOLS
• ERwin
• Rational Rose
• DATA ACCESS TOOLS
• TOAD
• OLEDB
• Oracle SQL Plus
• XML
• MIDDLEWARE
• COM/DCOM
• COM+
• WF
• Web Services (WS*, WCF)
• WCF (Windows Communication Foundation - Web Services)
• WPF (Windows Presentation Foundation / XAML)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Software Consultant

Responsibilities:

• Writing software and documentation for church-based application using C#.
• Converting modules from PowerBuilder to C#. Application is a Model-View-Controller pattern.
• Using Business Analysis skills to gather requirements for new features from the customer.
• T-SQL development is used to create, edit, update and delete statements in Sql Server environment.
• Crystal Reports used to create reports launched on user pc while SSRS is being used to generate overall centralized data reports.
• Creating stored procedures for account tracking and balance updates.

Confidential

Senior Software Consultant

Responsibilities:

• Maintaining software and documentation for church-based application using PowerBuilder.
• Use Microsoft Access to create a GUI application in VB.NET which uses ADO.NET to edit, update and delete data based on user modifications. Extensive experience with Microsoft Access in the Visual Studio 6 and .NET environments using Visual Basic and C++.
• PL/SQL development is used to create, edit, update and delete statements in Oracle environment.

Confidential

Full Stack SQL BI Consultant

Responsibilities:

• Lead Software developer on an.NET 4.0, C#, VB.NET applications team responsible for creating and supporting .NET applications.
• Reviewed, created and modified advanced SQL statements. Applied fixes and enhancements to SQL scripts through SQL Server 2014 and 2016.
• Used TOAD to make SQL and script modifications along with table maintenance.
• Functional lead and primary point of contact for users and client on issues.
• .NET applications interact with both Oracle and SQL Server.
• Converted several batch processes to C#.
• Utilized the DataGridView class to add filtering capability to application features. Implemented several filtering controls.
• Streamlined the retrieval, processing and updating of data.
• Maintained and Developed Stored Procedures used for generating different reports.
• Involved in database design on SQL Server 2008 and development of different database objects containing functions, triggers, store procedures.
• Assisted in the front-end development and documentation, UI development, assist other developers in methodology documentation when needed.
• Programmed the Data Access Layer using C# .Net.
• Used Business Analysis skills to gather requirements for new features from the customer and to document existing features.
• Analyzed, debugged and resolved technical issues for remediation. Also, trouble-shot and fixed problems through customer requests, and QA.
• Installed, configured and maintained scripts for client and server systems.
• Suggested effective techniques for administration of existing CM tools.
• Provided technical support for ticket processing and network administration tasks.
• Participated in technical assistance for core applications.
• PL/SQL development is used to create, edit, update and delete statements in Oracle environment.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Developing reports on SSRS on SQL Server ( 2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Great ability to create and manage various database objects like tables, views.
• Worked extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms.
• Experience in Performance Tuning and Query Optimization.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Confidential

Senior Software Consultant

Responsibilities:

• Lead Software developer on an.NET 2.0, 3.5, 4.0, VB.NET, C#, Entity Framework, and ASP (.NET) MVC developed applications.
• Reviewed, created and modified advanced SQL statements.
• Maintained several web-based applications developed in ASP.NET, C# and VB.NET running on Microsoft SQL Server 2008 and Oracle 11g.
• Used TOAD to make SQL and script modifications along with table maintenance.
• Using ASP.NET scripts in SQL Server/Oracle environment.
• Functional lead, business analyst and primary point of contact for users and client on issues. Used Business Analysts skills to gather requirements for new features from the customer.
• Performed maintenance on ColdFusion 9 application.

Confidential

Senior Software Consultant

Responsibilities:

• Developed C# application using standards for software architecture in an agile environment.
• Managed project from conception to release, through multiple full product lifecycles.
• Used Microsoft SQL Server Management Studio (SSMS) to make SQL and script modifications along with table maintenance.
• Used Telerik for report creation and Elmah for error logging.
• Used ASP.NET scripts in SQL Server to test backend functionality.

Confidential

Senior Software Consultant

Responsibilities:

• Developed C# applications - developed standards for software architecture.
• Experience: C#, XML/XSLT, HTML, Multi-threading, Unit Testing, Documentation, SQL.
• Used Microsoft SQL Server Management Studio (SSMS) to make SQL and script modifications along with table maintenance.

Confidential

Senior Systems Engineer

Responsibilities:

• Participated in defining and implementing new product or enhanced designs of software modules and components for medical devices that met functional specifications and target due dates.
• Used C# in SQL Server environment to create and manipulate data to test application functionality.
• Performed day to day administration of Team Foundation Server (TFS) system in support of various project development teams.

Confidential

Senior Software Consultant

Responsibilities:

• Participated, managed and contributed to the design phase of software development life cycle which included gathering specifications from end users, flow charting business processes and data requirements.
• Used C++ in PSQL (Btrieve) environment to modify and create new functionality for accounting and banking application.

Confidential

Senior Software Consultant

Responsibilities:

• Participated, managed and contributed to the design phase of software development life cycle which included gathering specifications from end users, flow charting business processes and data requirements.
• Used SQL Navigator to create, edit, update and delete PL/SQL statements and functionality in Stored Procedures, Triggers and cron jobs and to perform database queries, browse schema and validate transactions.

Confidential

Senior Consultant

Responsibilities:

• Enhanced two previously written COM Wrapper DLLs written in both STL and MFC format using Visual C++.NET 2003 (.NET Framework V 1.5) to manipulate to retrieve and perform transactions against a vendor supplied application and update files on Oracle and Informix servers using a subset of an API supplied by the vendor.
• Enhanced VB.NET 2003 application used to test both version of the DLL. The VB.NET application connects to the server then retrieves data from the server and displays data retrieved in an XML format. The VB.NET application also applies updates to the server.

Confidential

Windows Software Engineer Consultant

Responsibilities:

• Used Visual Studio.NET 2005 to convert (migrate) windows executable software from Visual Studio 6 - Service Pack 6 to Windows Mobile 5.0.
• Used the Handheld PC Pro Emulation environment and Active Sync 4.1 to debug newly built executables along with testing out the software on the PDA.

Confidential

Senior Consultant

Responsibilities:

• Developed, documented and coded applications (VB6 - VBA - Informix 4gl - SQL - ADO record sets) based on specifications provided by the BA/Project Management teams.
• Used windows emulator to access UNIX environment.

Confidential

Senior Consultant

Responsibilities:

• Wrote a VB 6 executable to interface with a Visual C++ 6 DLL to test performance against a vendor supplied application WIN32 API’s.
• Wrote a DLL using Visual C++.NET in STL, ATL and MFC formats to manipulate to retrieve and update files on Oracle and Informix servers.

Confidential

Senior Software Consultant

Responsibilities:

• Wrote applications in WIN 32 Paradigm / Visual Basic 6.0 / Visual Studio 6 to read error codes and provide a meaning to the user based on specific pre-defined error codes.
• Performed software engineering research for future naval projects.

Confidential

Senior Consultant

Responsibilities:

• Used statistical software (SAS) and wrote Perl scripts to maintain the UNIX environment.
• Used SAS to convert data from CSV files into SAS datasets.

Confidential

Senior Consultant

Responsibilities:

• Used the Handheld PC Pro Emulation environment, Active Sync and Visual C++ to debug newly built executables along with testing out the software on the PDA. Also modified the front-end GUI for the medical sales force using C++, ATL and MFC.
• Used C# and Embedded Visual C++ to write software to enable and disable what products the field representative had the ability to offer based on the budget amount available during a transaction.

Confidential

Senior Consultant

Responsibilities:

• Tested SAS datasets using statistical software (SAS). Duties included reviewing batch programs, processes and specifications to adhere to Lilly Corporate system standards.
• Used SAS utilities to transport datasets in the form of CSV or SAS Transport files.

Confidential

Senior Consultant

Responsibilities:

• Created Web Pages using NT Server and IIS.
• Designed, coded and created a web server using VB, ActiveX, COM, ADO, ASP, VBScript, JavaScript and Visual Interdev.

Confidential

Senior Client/Server Developer

Responsibilities:

• Developed, wrote test plans for completed models, attended code reviews and tested Visual Basic/C++ software along with prototypes in VB and C++ using MSMQ and MTS.
• RUP (Rational Unified Process) was used to capture the analysis and design artifacts, including object model, use cases, sequence diagrams, state diagrams and activity diagrams.

Confidential

Senior Programming Consultant

Responsibilities:

• Developed software to schedule tasks and store user modifications using XML, Visual Basic/ Visual C++, Windows 2000/Windows 98. The backend for the environment was SQL Server.

Confidential

Senior Client/Server Developer

Responsibilities:

• Performed middle tier integration including (OLEDB and ODBC) and business services component design using (COM+/COM, DCOM and ActiveX), and C++.

Confidential

Windows Software Engineer Consultant

Responsibilities:

• Developed, designed and tested Client/Server schema for access control systems using ERwin and MS Access.
• Wrote work instructions for access control systems applications using Visual C++.