Data Software Engineer
Resume:
Om Sharan Mishra
******@*****.***
Danbury CT-06811
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