Post Job Free

Resume

Sign in

Data Software Engineer

Location:
Ridgefield, CT
Posted:
September 07, 2020

Contact this candidate

Resume:

Om Sharan Mishra

adfvhc@r.postjobfree.com

* ********* **, ***

Danbury CT-06811

+1-203-***-****

Professional Summary:

•Certified Scrum Master with over 14 years of rich and progressive experience in Application Analysis, design, development, Implementation and post production support.

•Having Good Experience in Banking, Financial Services and Insurances and Ecommerce domains, Incentive Compensation Management and knowledge in Risk and Compliance and Anti Money Laundering(AML).

•Good understanding of KYC (Know your customer) process and right now performing KYC activity using Bridger Insight XG, in house KYC application and AML process.

•Experties in Data processing, Elastic Search and Kibana.

•Have good experience on RDBMS database technologies like SQL,PL\SQL, Oracle10g/11g and MySQL, Sybase.

•Strong experience in database design using DDL, DML, writing complex SQL Queries and Stored Procedures, Functions and triggers using T-SQL and PL\SQL.

•Proficiancey in Data Warehous and ETL using MSBI (SSIS, SSRS & SSAS) and Business Object.

•Extensively worked on n-tier architecture system with application system development using Microsoft .NET, ADO.NET, ASP.NET, C#, VB.NET, XML,XSLT, HTML, CSS, JavaScript, JQuery, AJAX and IDE Tool.

•Expertise in Client Side designing and validations using HTML5, CSS, JavaScript and JQuery.

•Expertise in XML technologies such as XSL, XSLT, XML schemas, XPath and parsers like SAX, DOM.

•Implemented Rich User Interfaces using ASP.NET, HTML5, CSS, CSS3, JavaScript and AJAX.

•Deployed and Configured Microsoft .NET web application in ISS server environments and also good expertise on windows, Console and Windows service.

•Very Strong conceptual and hands on programming skills on Collections, Multi-Threading, Garbage Collection, Exception Handling, OOPs concepts in Core Java

•Strong in Object oriented fundamentals and relational database principles and Patterns (OO Pattern)

•Developed Software using Agile Methodologies.

•Experienced in test driven development (TDD). Practiced test first development.

•Proficient in unit testing the application using NUnit.

•Able to learn and adapt emerging technologies in work area.

•Ability to multi-task, work independently and as part of multiple team.

•Highly motivated, analytical problem solver and troubleshooter with strong attention to detail.

•Excellent interpersonal abilities, communication skills, time management and team skills with an intention to

work hard to attain project deadlines under stressful environments.

•Conducted detailed requirement gathering through sessions, use case diagrams and prototypes.

•Highly passionate and curious about new Front-End development technologies and has ability in mastering

them with a keen awareness of new industry developments.

Education

•Master of Computer Applications from Pt. Ravi Shankar Shukla University Raipur C.G., India,2003.

•B.Sc. (Mathematics & Physics) from CSJM University Kanpur, India,1999.

Certificates

•Certified Scrum Master.

SKILLS:

RDBMS

SQL Server 2000/ 2005/2008 /2012, Oracle 10g, MySQL, Sybase

Application Server

ISS Server 6.0 / 7.5

Logging& Build Tools

Microsoft Visual Studio, SQL Server Management Studio, Nunit, TOAD, JIRA

Version Control

VSS,TFS, CVS, Star Team

Other Tools / Technologies

Varicent, Bridger Insight XG, Enterprise Architect, MS Visio, Support Cantal

Front-end Technologies

HTML5, JAVA, JavaScript, Ajax, Jquery,CSS,Web services, SOAP, XML

Programming Languages

C#,VB.NET, Java, T-SQL, PL/SQL

Operating Systems

Win XP/Vista/7/8, Unit, Linux.

Microsoft Technologies

C#,ADO.NET, WCF,MVC, ASP.NET, Microsoft .NET Framework 1.1/2.0/ 3.0/3.5/ 4, XML, Web Services.

Client / Server Side Programming

Node.js, javascript, HTML5, CSS, CSS3, AJAX, jQuery

Employer: Biralsoft Inc. Mar 2007 – Present

Professional Experience

Project: Know Your Customer (KYC) Feb 2018 – Present

Role: Solution Atchitect

Client: Wells Fargo N.A., USA

Description:

KYC Service is a due-diligence BRMS tool used for fraud check. KYC Compliance verifies the customer related data like name, address, party name, legal name against a set of Business Rules and policies related to Due-Diligence and Anti Money Laundering. It utilizes the AML, KYC, fraudulent watch list and Due Diligence rules to generate a risk score. The risk score enables the Risk Analyst to gather, synthesize and process information to develop an understanding of the risk of a particular entity or organization and set provide the loan approval or set loan underwriting accordingly.

Roles:

Data processing for Marijuana related businesses, Negative News (PEP – Politically Exposed Person and Adverse Media), Felony, Legal Name and Address Authentication.

Build process, criteria and plan for establishing an understanding of the current state of data quality across the data sets.

Perform the date load operation from various data sources based on key dimensions of Completeness, Consistency, Accuracy, Security, Quality and standards in internal developed tools using Elastic Search.

Build and enhance the current confidence score logic to provide decision support for AML Analyst.

Generate the need basis ad-hoc reports for AML analyst and Audit team.

Improve the current data processing logic and onboard new business to KYC umbrella.

Provide evidence for audit team for any screened name.

Perform the security risk review to avoid any vulnerabilities.

Gather requirements and establish data ownership, policies, procedures and guidelines.

Monitory Know Your Customer Process to makes sure application availability.

Integrate the data load process with various business based on business input requirement.

Consulting various functions in Varicent on Data Governance, tools and procedures.

Performing the incident management activity.

Drive, maintain Policy definition (quality, ownership, retention, regulatory, security, operational) and Report status for policy enforcement initiatives.

Contribute to standardized data definitions though collection and consolidation of Data Definitions across compensation plan.

Reconcile gaps, overlaps, and inconsistencies in policy, standards, or requirements.

Set accountabilities for the design, implementation, monitoring, and enforcement of policy, standards, or requirements.

Environment: SQL Server 2012, Elastic Search, Kibana,C#,ASP.NET, Bridger Insight XG, SOPA UI, ISS Server 7.5, MS Visio, Node js.

Project: GE Capital – GRC Compliance RTS (Know Your Customer) April 2014 – Feb 2018

Role: Technical Lead

Client: GE Capital, USA

Description:

GECA GRC Compliance RTS verifies the customer related data like name, address, party name, legal name against a set of Business Rules and policies related to Due-Diligence and Anti Money Laundering. It utilizes the AML, KYC, fraudulent watch list and Due Diligence rules to generate a risk score.The risk score enables the Risk Analyst to gather, synthesize and process information to develop an understanding of the risk of a particular entity or organization. Based on the decision made from above risk information, a loan is disbursed or denied to an entity or organization.

It is a due-diligence BRMS tool used for fraud check. It is used by various organizations for pre and post screening the data. It enables the Risk Analyst to gather, synthesize and process information to develop an understanding of the risk of a particular entity or organization. Based on the decision made from above risk information, a loan is disbursed or denied to an entity or organization.

Roles:

Working as Project Lead / onsite coordinator and performing client communication, quality process and other project related day to day task.

Segregating the GE Capital Divestiture deals and transitions them to respective buyers.

Carry on the watch list screening, KYC, AML check and due-diligence for all TSA.

Creating a user base and interface for GE Capital Divestiture employees so that they can access the application.

Deploy the KYC, AML Rules and Policies based on TSA guidelines in the Production environment.

Provide support (fixing defects, availability of application) to business during UAT.

Coordinating regular health checkups for the application.

Carry out the entire design, development and testing cycles for subsequent releases of the application.

Creating a user base and interface for GE Capital Divestiture employees so that they can access the application.

Warranty Support for the Application performing all the required support activities.

Incident Management activities

Environment: SQL Server 2008, SSIS, SSRS, Bridger Insight XG, AML Service, SOPA UI, ISS Server 7.5, MS Visio.

Project: GE Capital – HR RTS March 2012 - March 2014

Role: Technical Lead / Project Lead

Client: GE Capital, USA

Description:

Varicent drive sales productivity and effectiveness with industry-leading incentive compensation and sales performance management solutions. It is a modular application, enabling organizations to design, manage and automate the calculation of variable payment for lots of plans and thousands of employees simultaneously.

The feed data for Varicent come through different sources with the help of SSIS to the Varicent database.

Responsibilities:

Involved in the development of Software Development Life Cycle in Rational Unified Process.

Worked with Clients and the analyze to gather the requirements.

Prepared the designing Use-case, Sequence Diagrams, Class Diagrams and Data Flow Diagram

Interacts with Data Analyst to create Data Modeling for Incentive Compensation Plan.

Prepared Functional Specific & Technical Documents Design for each plan.

Created calculations to implement and make changes according to the business needs of the client.

Perfumed GAP analysis of already implemented business and did charge for 2012 Plan.

Created SSIS package to Load data from various sources and performing data massaging to apply business rule.

Written the RDBMS- SQL Query, Stored Procedure to get the values from the Database.

Conduct the Application review comments for the application

Executed Sanity and Smoke, Regression and Performance testing for application.

Environment: Windows 2003, Visual Studio 2008, SQL Server 2008, Varicent 6.0 / 7.1 and SSIS.

Project : Harleysville GBP-Support Oct 2010 to Mar 2012

Role : Technical Lead

End Client: Harleysville Insurance, USA

Description:

Harleysville Group Life Insurance business operations unit has decided to extend their life business improvement plans to serve the customers and initiated the GBP portal for the ease of agents and employers to manage their new business needs. The complete life cycle of managing the new business accounts is to be handled by GBP feature and upon implementing the same would achieve a standardized approach/ technology for Group Life business operations. This approach is to build enterprise Group Life solutions involving the multiple stake holder’s viz. employers, agents and Harleysville’s own employees i.e. Harleysville Carriers to achieve the complete value chain in a phased manner. This is basically a Support / Enhancement project to handle day to day business issues.

Responsibilities:

•Collected Business requirements from the client and Business Analyst, Functional Specification Document (FSD) have been developed

•Developed the High level Design Documents(HLDD) & Low Level Design Documents (LLDD).

•Developed the components that are used by internal members and for the application.

•Prepared the SDD based on the FSD from the scratch.

•Managed full lifecycle of software development including documenting functional specs, technical specs, coding, unit testing, system integration testing and implementation.

•Prepared the designing of Use-cases, Sequence Diagrams, Class Diagrams and Data Flow diagram

Incident Management activities

Providing support for incident tickets forwarded / assigned by the helpdesk team

Providing resolution for the tickets while adhering and complying to the specified SLAs

Determining whether for an assigned trouble ticket- an incident fix (workaround), Data fix or permanent emergency fix is required

Implementing emergency code changes in production where workarounds are not possible

Analyze and resolve medium and complex incidents from business partners

Providing support for requests / tasks that are repeatable or small in size and effort

Escalation of issue to respective stakeholders as per defined escalation mechanism

Performing root cause analysis on long term fixes as and when required

Handing over of tickets/requests to development team as per pre-defined procedure

Communication with user to update status and/or close ticket

Environment: Windows 2003, Visual Studio 2008, C#, SQL Server 2005, InfoPath 2007, ASP.NET and MOSS 2007.

Project : GE Capital - GECA ITO EDGE PROGRAM Oct 2010 to Mar 2012

Role : Technical Lead

Description:

This application includes four modules GE History, CSR, D&B Monthly Data and External Data Screens. These screens are part of the ICE system in today’s world. As per the new business requirement, these screens should be available in Siebel 8.0 Environment and all the existing functionalities should be available to Users. ICE and EDGE systems would not be available going forward.

Responsibilities:

Responsible to develop function and technical specification.

Responsible to automate the business rule to validate the functionality.

Responsible to prepare the delivery format for code and technical document.

Identification and management of schedule or scope changes to the projects.

Identify project related issues, risks, and opportunities that arise during the course of project.

Environment: Visual Studio 2008, ASP.NET, IBM MQ, VB.NET, Oracle 10g, Microsoft Visio.

Project : TCCA - The Core Banking Solution Jan 2009 to Sep 2010

Role : System Analyst

Client: Open Solution, USA.

Description:

The scope of the project is to provide the complete technical and functional documentation of a Core banking product named TCBS. Functional Documentation includes Flow Charts/Work Flows/Use Cases representing all Business Rules of the Application, Interdependencies between Functional Components, Exceptions, error conditions etc. Technical Documentation includes High Level Architecture, Low level Architecture, Data model understanding document, report of deviations from open Solution’s defined Coding Standards.

Responsibilities:

Responsible for making customer presentations & technical proposals.

Responsible to develop function and technical specification.

Responsible to automate the business rule to validate the functionality.

Responsible to prepare the delivery format for code mining, code review and technical document.

Identification and management of schedule or scope changes to the projects.

Identify project related issues, risks, and opportunities that arise during the course of project.

Environment: Windows 2000, Visual Studio 2008, C# 3.0, win forms, Oracle 10g, Microsoft Visio, Enterprise Architect 7.5

Project : Hollywood video Express Web tool. Mar 2007 to Dec 2008

Role : Sr. Software Engineer

Client: Movie Gallery, USA.

Description:

Hollywood video Express Web tool consists of graphical user interface of Online Video purchase and download system with PCI (Payment Card Industry Data Security Standard) compliance for interaction with end users and backend business processes. With the help of Hollywood video Express Web tool customers can place an order for purchasing or renting the DVDs and can download movies to their desktops or set top boxes using this component. For movie download and STB, Two different interfaces have been implemented from the site, one from movie beam to web site and second from web site to Client machine.

Responsibilities:

Analyzing the requirements and preparing High Level and Low Level Design of the system.

Onsite Coordination.

Design, development, testing, troubleshooting and debugging of the software.

Team Management, Work Allocation to team and Peer Review.

Deliveries, release and verification of the application.

Implemented Accurate Tax Calculations Using Alavara

PCI Implementation

Worked on Download Manager Implementation for Download to PC Environment.

Created solution for Online Movie Purchase/Renting/Download

Environment: Windows Server 2003, .NET Framework 2.0, ASP.NET, C#, IIS 6.0, Commerce Server 2007, SQL Server 2005, XML RPC Web Services, Ajax.

Employer: DELL Perot System (NTT DATA) Nov 2006 – Mar 2007

Project : HRMSWeb (Human Resource Management System). Nov 2006 to Mar 2007

Role : Software Engineer

Client: Tenet, USA

DELL Perot Systems, India

Description:

HRMSWeb is a system (to access the real-time employee information) designed to facilitate Tenet. It’s a Web Enabled Interface to Access the Central Employee Repository. Work In Progress Queue allows for Separation of Duties. Maintenance of Employee information - Employee Number, Account and Email Address creation. Employee name change/eTenet Login/Email Address change coordination. Edit any employee data (HR, Benefits, and Payroll) including new hires, rehires, status changes, and transfers.

Responsibilities:

Designing and Development of graphical user interface based on the system requirement

Involved in the unit testing.

Environment: .NET Framework 1.1, ASP.NET, C#, SQL Server 2000.

Employer: NIIT Technologies Apr 2004 – Oct 2006

Project : Various Big / Small Size projects April 2004 to Oct 2006

Role : Software Engineer

Client: ING, U.S.

NIIT Technologies, India.

This is basically an Investment banking client where we are primarily involved to work with portfolio managers to fulfil business needs. We are creating various applications in combination of Web / Windows / batch job/ Windows service / web service.

Responsibilities:

Designing and Development of graphical user interface based on the system requirement

Implementing business rule and logic.

Designing and coding of Web Forms, Designing of Reports

Involved in the unit testing.

Environment: C#, VB. NET, ASP.NET, XML, SQL SERVER 2005, SQL Server Reporting services, Crystal Report 9.0, Java Script.



Contact this candidate