Asp.Net Sql Developer

Summary

**+ years of IT experience across all aspects of SDLC; Architecture/Design/Dev/QA/Implementation & support.

Strong database development skills and experience for Insurance, Fed & State Govts, Retail, Engg and Financial sectors.

10+ years of Architecture experience to implement solutions with different technologies and patterns/methodologies.

Extensive experience using SQL, PL/SQL or T-SQL where applicable to create & use Tables, Views, Materialized Views,

Constraints, Indexes, complex Stored Procedures, Functions, Packages including Oracle system packages like

DBMS_SQL, UTL_FILE, Triggers, CTE’s and WITH clause.

Experience using Dynamic SQL, Records and PL/SQL Tables, data loading with SQL Loader, range partitioning etc.

Extensive experience with using Ref Cursor, External Tables, Collections, Dynamic SQL, Exception handling, SQL

performance tuning/improvement using Parallel PL/SQL, FOR ALL, BULK COLLECT, Analytic functions, Cost-Based

Optimization (CBO).

Experience with logical and physical Data Modeling, Data flow diagrams, Data dictionary, and ER modeling for OLTP.

Familiar with beginner to intermediate experience in Data warehouse concepts, dimension modeling for OLAP and ETL.

Leading & Collaboration - Team-Oriented, Self-motivated and Adaptable; Lead teams on/off shore, and successfully

delivered projects.

Proven troubleshooting & problem-solving skills with structured analysis & approach. Keen on process improvisation,

knowledge dissemination and interaction of ideas.

Skills

OS: Windows/Unix/Linux

Database Systems: Oracle, Sql Server, T-SQL, IBM DB2, Teradata, MS Access, MySql, Postgres.

Languages: SQL, PL/SQL, T-SQL, C#, VB.NET, VB6, PowerBuilder, Perl, Java;

IDE: VS.NET, Eclipse; Sql Developer, TOAD, PL/SQL Developer, SSMS.

CMS/Integration/Application Servers: Sitecore, SharePoint, Joomla; Biztalk, MQSeries; IIS, Apache, Tomcat.

Analysis/Reporting: SSIS, Informatica, SSRS, Crystal Reports, Actuate;

File Transfer: FTP/SFTP/MFT/MOVEit.

Source Control: TFS, Git, Subversion, CVS, Rational Clear Case, VSS.

CICD: Azure DevOps, CruiseControl.NET, MSBuild;

Testing: Selenium, nUnit, nAnt.

Design/Modelling: Erwin, Visio. UML, RUP, Agile, Scrum, TDD.

Other: Inspro, Aprimo, OnBase, Kofax, Control-M, Autosys, Telerik, Infragistics.

Markup/Scripting/Formats/Frameworks: HTML, XML, Json, VBScript, JavaScript, jQuery/Angular, Bootstrap.

Education

Bachelor’s, TS, India.

Certification(s)/Training

Microsoft Certified Application Developer (MCAD) For Microsoft .NET - 070-310, 070-316, 070-315, 070-229.

Microsoft Certified Professional in Designing and Implementing Desktop Applications with VB 6.0

Sitecore Certified .Net developer.

Control-M

Experience

Sr Software Application Engineer Wellcare, Tampa Apr.17-Apr.22

WellCare provides government-sponsored managed care services to Individuals and Groups through Medicaid, MA and Medicare PDP’s in the Health Insurance Marketplace, serving approximately 6+ million members nationwide.

Roles & Responsibilities: Design, Develop and Support Applications, Processes, Systems or Tools related to:

Billing Integration; Azure; Appeals/Grievances; Claims Processing; Image Conversion/Processing; and EDI/Data extracts.

Projects & Technologies Worked:

AR2Cash Billing Integration systems: Applications/Processes to integrate data between systems. Refactoring, tuning and

refining PL/SQL packages for performance improvement.

PL/SQL, MV’s, Parallel PL/SQL, FOR ALLL, BULK COLLECT, SQL Loader, Oracle Financials, C#, .Net.

Migrate C#/Asp.Net controller’s logic to PL/SQL Procedures, functions and packages. PL/SQL Tables, Collections, Analytic

Fn’s etc

Appeals & Grievances: PL/SQL backend data layer to support and handle appeals/grievances for front end application.

Performance tuning of Oracle PL/SQL scripts, procedures, functions and packages.

Claims Inquiry: PL/SQL Packages/SP’s/Functions to handle Claims Inquiry. PL/SQL. MS Access VBA.

Kofax image index file processing and loading. PL/SQL, C#.

Provider data management system (PDMS): Provider/Credentialing, Contracting Info, Network Expansion, and HSD

information. Oracle, APEX, C#, ASP.NET, MVC, REST, JSON.

Functional & Performance Test Automation Framework for Web Applications. Selenium, Load Runner, C#, Java, STS.

EDI Data extracts for TennCare/AR regulatory/compliance requirements. SSIS, PL/SQL, .Net, Java, Unix Shell scripts.

Technology:

Sql Server, Web Applications, REST, Web Services, Microservices, JSON, Load Runner, Selenium, WebDriver, Jenkins, TFS, Kofax, Unix Shell Scripts, Sql Devloper, TOAD, Windows, Web API, TDD.

Programmer III Windsor Health Group/Sterling, Brentwood/Bellingham Nov.09-Apr.17

WHG/SterlingLife provides the senior community with insurance products to improve their health and well-being by offering a mix of Medicare, Drug, Critical Care, Long Term Care and Life insurance products.

Roles & Responsibilities: Architect, Develop and Support Applications, Systems or Tools related to: Enrollment; Providers; Claims Processing; Leads Management; Agent On-Boarding and EDI/Data extracts.

Lead and mentor team(s) to accomplish Development and QA tasks/milestones.

Projects, Tasks:

Provider data management system (PDMS): Oracle APEX based Web application to Manage Provider/Credentialing Info,

Network Expansion, and HSD information. Oracle, PL/SQL, APEX, SQL Loader, MV’s.

EDI, Data extracts: Solutions to generate and automate 834/835/837 EDI(4010/5010/X12) transactions/files. Oracle

PL/SQL, SQL Loader, SSIS, Biztalk.

TPA/Partner solutions: Implement complete system/administration services (agent commissions, member enrollment,

claims processing, etc.) to third parties. Oracle, PL/SQL, SQL Loader, JCS, Sql Server, C#, Powerbuilder,.

Inspro Integration: Migrate/Integrate Sterling Applications, Data and processes with Inspro, a COTS SAAS insurance IT

services provider. Oracle, PL/SQL, SQL Loader, MV’s, Sql Server, C#, .Net, WCF, Web services, Java, Informatica.

eEnroll, MSOLE: Enrollment and supporting Applications to enroll members into Medicare plans offered by WHG/Sterling.

ASP.NET Web/Offline/ Mobile, WPF and Silverlight. C#, Web Services, Xamarin, Oracle, Sql Server, MVC, MVVM,

Responsive

Create new or Update existing solutions to implement various business requirements of partners (AAA, IHC and

AonHewitt) with different business models. C#, Powerbuilder, Oracle, Sql Server.

Job Control System (JCS): Custom scheduling system to extract and transmit EDI files for partner/vendor/fulfillment

needs. Later integrated with Control-M. C#, Powerbuilder, Oracle, Sql Server, Conotrol-M.

Agent On-Boarding: Update and automate Agent Commissions processes/solutions. Powerbuilder, Oracle, PL/SQL.

Leads Management: C# WinForms tool to receive, transform and integrate leads data from different vendors with Aprimo.

Claims Adjudication Process: Updates to custom processes to include OV/IP PerDiem CoPay/benfit limits and related

dependencies. Powerbuilder, Oracle, PL/SQL.

Technology

.NET/C#/ASP.NET, WCF/Web Services/REST, Javascript/jQuery, Angular, Bootstrap, CSS, Responsive, AJAX, jQuery,Joomla/PhP, SQL Server/Oracle/MySQL, PLSQL/T-SQL, SSIS, Biztalk, Sitecore/SharePoint, Informatica, Subversion, Powerbuilder, Telerik, Xamarin, Mobile, Control-M, CruiseControl.Net, nUnit, nAnt, Log4Net, etc.,

Sr Developer/Programmer AET Solutions, Sterling Heights, MI Jan.02-Nov.09

AET Solutions, a global Information Technology consulting company provides eBusiness and mBusiness solutions to Fortune 500 companies in the United States. Worked on different projects for following clients: WSDOT; Meijer; Siemens.

Roles & Responsibilities: Architect, Develop and Support Applications, Systems or Tools related to Travel Options; Stormwater management; PCard; STIP/TIP; OrgChart

Projects, Tasks:

WSDOT

Travel Options: Web Portal to manage transportation routes/info of transportation service providers. C#/ASP.NET,

Postgres.

Stormwater Management System: C#/ASP.NET based Statewide stormwater information management system.

STIP/TIP: C#/ASP applications to Manage/track/report DOT's transportation projects.

Meijer

Work Assignment Maintenance: C# WinForms based Maintains Pricing work assignments to group Pricing application functionality

Reconcile2: Metadata and Dynamic SQL driven, C# Console application for data reconciliation between Oracle and IBM DB2 databases.

Audits Maintenance Tool: VB.NET/ASP.NET Intranet application for tuning and editing Audit Control Table information that hold WMQI/MQ Series transaction/workflow information.

Siemens

Materials Adjustment Request: Workflow application for adjusting/ordering the parts/materials.

Matrix One Documents management and viewing system.

QuickQuote(Q2): Excel/C#/Web Services based application to integrate Autocad generated drawings/quotes to database and manage via web application.

Technology: C#, VB.NET, ASP.NET, VS, WinForms, IIS, SQL Server, Postgres, SSRS, ArcGIS, Web Services, CVS/Subversion, JavaScript/AJAX, Excel, Visio, Telerik, SharePoint, Infragistics, nUnit, VSS, Visio, Crystal Reports 9, Unix/Windows, IBM WebSphere, IBM DB2, IBM Stored Procedure Builder, Oracle 9i, OfficeXP/XML/OfficeXP Web Services Tool Kit 2.0, Autocad

Sr Programmer/Programmer IDS, Troy, MI Oct.98-Dec.01

IDS Inc, a Michigan based IT consulting company, provides businesses across the USA the resources and solutions to meet their IT/business needs/goals.

Clients Worked For: Fujitsu Business Communication Systems(FBCS); Intel; MIMHP.

Roles & Responsibilities: Develop and Support Web, Desktop and eCommerce solutions/applications.

Projects, Tasks:

USDA

SCIMS: ASP.NET/VB based multi-tier Web application to manage USDA Customer/Land information.

Data Migration: SqlServer Data Import Scripts to load/mihrate data from other systems via text/csv formats.

MIMHP

Develop ASP based Pharmacy eCommerce portals.

Support/Updated legacy Perl/CGI applications to web applications.

Intel

IntelWebOutfittercom: Web Application offering free enhancements for customers with PentiumIII® computers.

FBCS

Registration Server System: ASP Web Apps to configure the User/Customer/Product information and an Admin Console.

Technology: VS, IIS, SQLServer, VB, ASP, HTML, ASP, JavaScript, VBScript, COM, Windows NT, Oracle, C++, Perl.

Contact this candidate