Developer Data

Experience Summary:

Samir Sevak is an experienced IT professional. Samir’s past experience includes but is not limited to: PowerBuilder 11.x, SQL, Oracle, Sybase, web services, SSIS, ASP.Net (C#), and Data Modeling.

In addition, Samir has a solid understanding of object oriented client Server Internet concepts and writing distributed systems with focus on load balancing, security and scalability. He is also skilled with the Software Development Life Cycle (SDLC) and Capability Maturity Model (CMM) model.

Education:

MS Mathematics

St Xavier’s College, India

BS Mathematics

Post Graduate Coursework in Computer Applications

Xavier's Institute of Computer Science

Certifications/Training:

PowerBuilder Certification

Fast Track to Replication Server, System 11

Fast Track to SQL Server

Introduction to SQL

Data Warehouse

Data Modeling

Architecting the Data Warehouse

Technical Skills:

Languages: C, C#, JAVA, JavaScript, DynaScript, and HTML.

Operating Systems: Windows 9x/NT, NetWare 3.1.

Ancillary Skills: PowerBuilder 11.x, Infomaker, Visual Basic, Visual Studio, FoxPro 2.x/3.x,Crystal report; Oracle, Sybase, MS SQL; Power Dynamo, Cold Fusion, Jaguar (EAStudio, EAServer),ASP.NET; ERWIN, Power Designer, UML

Experience:

01/01/2014 – Current – Dept of Taxation,VA

ADVANTAGE Revenue is an integrated software suite for tax and revenue management. It supports

Taxpayer identification and registration, and returns processing, as well as taxpayer and revenue

Accounting to provide an integrated tax processing solution for all major tax types.

Review Current documentation related to different tax type and registration process

Enhance and modified Current System and implemented new processing system to generate appropriate letter for lax payer.

Involved in day to day data fix and production support

Tool : PowerBuilder 12.5,Oracle 11.5, Lotus Notes

06/21/2013 – 12/12/2013 – Blue Cross Blue Shield

Quest System - Implemented. ADO security feture within application.Created XML datawindow template to implement Java Webservice to get patient data from external sources

Tool : PowerBuilder 12.5,Java,Oracle 12.5

05/21/2012 – 12/12/2012 - Bank of America

Title: PowerBuilder Developer

Foreclosure Processing System

FPS tracks default loan files through the foreclosure process, providing workflow automation from the day each file is referred through to auction. The application has internally built interfaces with external and internal business clients and vendors

worked closely with Business analyst, Line of Business and offshore team to reviewed requirement and specification document for project.

Analyzed existing code and created LLD (Lower Level design document).

Enhance and modified Foreclosure Processing System to convert PowerBuilder report into Word document’s mail merge functionality. Modified Fax/Email functionality to executes foreclosure documents within state and investor timeframes.

Created PowerBuilder application to extract data window’s attribute into Excel to create specification for each document.

Created .NET utility to search merge field within all word documents.

Tool : PowerBuilder 12.5,MS SQL Server 2008, Visual C# .NET 2010, AS 400

08/15/11 - 12/31/2011 Department of Motor Vehicle, Las Vegas,NV

Title: ASP.Net / PowerBuilder Developer

Involved in Requirements Analysis & Design and time estimation for Duplicate Driver’s License/ID card project

Analyzed business systems requirements and design technical solutions based on those requirements

Created Web Form and Web Services using existing Multi-Tier frame work using ASP.NET/C#.net

Created new module using PowerBuilder 12.5 to execute created web services for validation of Duplicate Driver’s License/ID card project

Use Team Foundation Server for source control, work items, and builds

05/09/11 - 07/11 JBS, Colorado

Title: Tech Lead PowerBuilder/ .Net

Set up environment for PowerBuilder and EAServer

Analyze business systems requirements and design technical solutions based on those requirements

Assist in development of test scripts, product builds and installation programs

Support debugging and enhancement of existing programs and modules

Write functional and technical specification documents

Participate in code reviews, unit testing, and unit test documentation

Coordinate Offshore Team

08/10 – 04/11 Bank of America

Title: PowerBuilder Developer

Involved in SSN remediation project for CLMS application. This project is initiated due to government regulatory requirements. Analyzes CLMS and LMS applications for impact if SSN is removed or masked. Creates reports for all effected databases and objects for SSN remediation.

Creates store procedure to change SSN with bank approved id for all databases.

For a critical compliance project for the bank, did extensive analysis of the front end PBL code, analyzed Sybase table and index structures, was instrumental in developing a conversion module (Extract, transform,load module) for automated data conversion of a column multiple databases for critical customer leads application.

Extensive testing on PowerBuilder/Sybase applications to determine impact of data conversion.

Analysis and research of an application frontend PBL application to determine the feasibility of data encryption.

Involved in creating Low lever design/impact analysis document for future Charge card product.

04/08 – 07/10 Reed Business Information Inc

Title: Sr. Developer

Reed Business Information has a custom-built order management and invoicing system called Cahners Customer Information System (CCIS).This system is a core business application in the IS space of Reed Business handling contracts, orders, production and related invoicing information.

Analyzed exiting PowerBuilder and Sybase Database. Created new Order conversion and invoices module with Credit card process. This module creates actual order received from Customer and produce invoice. Involved in designing database, writing stored procedures and triggers.

Migrated PowerBuilder 8.0 application to 11.5, Involved in Converting PowerBuilder 11.5 application to ASP.NET(C#) and ADO.NET.

Optimized store procedures in SQL 2008 get better performance using ADO.NET.

Used AJAX and Java Script code to update webpage asynchronously and validate various forms.

12/06 – 03/08 J P Morgan

Title: Sr. Consultant

Examined existing PowerBuilder and MS Access Trading Applications.

Participated in the effort estimation and impact analysis of the new enhancements.

Migrated PowerBuilder 8.0 applications to PowerBuilder 10.5.

Involved in migrating Sybase databases to MS SQL Server 2005 databases and involved with developer to make necessary changes in their various applications (JAVA, C# .NET platform) and Crystal reports. Modified Store procedures to get better performance.

Developed details technical specification for the team developers.

Added new ADO security mechanism into new PowerBuilder application.

Contributed in creating test cases for UAT.

Implemented new enhancements, fixed bugs, provided online support and troubleshooting.

06/06 – 12/06 HRA

Title: Sr. Consultant

Analyzed existing POS (Paperless Office System) Application. Added further business rule to the system. Designed, developed new FOOD Stamp module to current POS application.

Performed Unit testing of all program modifications. Created Sybase Data Window .NET component to generate report for Microsoft Visual basic .NET (ASP.NET) applications.

Developed PL/SQL procedures. Worked directly with development team by leading daily Scrums and providing technical leadership for Conversion of client server PowerBuilder application to web based VB.NET and ADO.NET platform.

03/00 – 05/06 Sybase Inc

Title: Sr. Consultant Analyst/ Developer

Migrated various PowerBuilder Applications. Involved in performance and tuning of the Application.

Performed Unit testing of all program modifications. Responsible for technical analysis and review of requirements with Business Users. Involved in the effort estimation and impact analysis of the new enhancements. Implemented new enhancements, fix bugs, provide online support and troubleshooting.

Developed Jaguar CTS components enabling distributed computing environment. Solved PowerBuilder System errors in PFC based service-oriented architecture. Enhanced existing PFC’s (Power builder Foundation Class libraries) service based architecture custom code.

Managed business transactions hitting upon database tables utilizing interdependencies among each other. Custom implemented packages, stored procedures and triggers to achieve mission critical business logic with the aid of advanced, complex SQL queries. Created Conceptual Data Model (CDM) and Physical Data Model (PDM) using Power Designer 10.X. Converted MS Access application into PowerBuilder 10.x. Implemented software for blood analyzer device for Abbot Laboratory. This software sends patients’ data to Hospital Information System.

04/97 – 03/00 Small Business Administration

Title: Programmer Analyst

This System was an Internet-based client/partner and servicing-history-reporting system for ED, which provides program Offices with the capability of centralizing their client/partner and servicing history data collection. Designed the Web pages in HTML.

Used the PowerDynamo SQL tag to make Methods as Stored Procedures (MASP) calls from Jaguar CTS (Component Transaction Server). Used JavaScript for validation of data.

Created Java Servlets, which allowed executing business logic from Web browser using the Hypertext Transfer Protocol (HTTP). Created and maintained stored procedures.

Contact this candidate