Manager Data

Puneet Bhatia

Mobile No.: +1-602-***-**** Location: Phoenix, AZ

Email: **************@*****.*** Work Authorization: H1-B PROFESSIONAL EXPERIENCE

Syntel Inc. Feb’ 12 –Till Now

● Total 8 Years of competitive experience in IT industry having almost 5 years of in Design and Development using ‘RSA Archer’ & 3 years of experience using Microsoft Technologies (C#, ASP.NET,SQL 2008R2, AJAX, ADO.NET, Java Script)

● Good understanding of SDLC; Well-versed with AGILE Software development practices, RSA Archer Certified Associate, Certified SAFe Practitioner 4.0

● Proficient in building and mapping business requirement into Archer Platform.

● Well versed with Archer concepts and specializes in the architecture, high level design and low-level development of ODAs and questionnaires, end to end development and maintenance of solutions and applications as per clients’ requirements.

● Worked with business to guide them on RSA Archer and to help them envisage implementations by creating Prototypes/POCs.

● Strong skills in Data-feed, Access Control, Calculations, Data Driven Events, Mail Merge Templates, Custom Objects and Reporting with Proficiency in creating custom reports using Mail Merge templates.

● Designing access control, customizing applications and solutions, creation and customization of the existing workflow in Archer, designing integrations with the help of data-feed manager, designing notification letterheads, configuration of iView, dashboard and workspace, questionnaires and findings, ACLs and other actions.

● Proficient in Data Import and Data Feed (Archer to Archer and File Transporter data- feed) in Archer.

● Strong knowledge of .NET framework, HTML/CSS, JavaScript & SQL- Server 2008 R2 as a backend database, Writing Database queries, Stored Procedures, Function, Views using it

● Experience on documentation skills like Design Document, Estimation of new and maintenance projects, Knowledge Case for delivered projects, SIT cases, Quality Assurance documentation

● Hands on experience of LARA Deployment, Service Now, Cast dashboard, Rally, Cenzic hailstrom for production and development project

● A hard working, adaptable and articulate Team Member, having good experience in working with the team at offshore and coordinating with the onsite counterparts for the smooth functioning of the project.

● Excellent customer facing with strong interpersonal & relationship management skills

● Project experience includes customer interaction, leading responsibility and project quality related activities.

● Well versed with AGILE SDLC methodologies; part of a mature scrum team. Possess experience in driving scrum teams; have performed the role of an intermittent Scrum Master. PROFICIENCIES/TOOLS

Process & Methodologies Agile, Waterfall Development Model, SDLC Programming Languages RSA Archer, C#, ASP.Net, WCF, Web Services, ADO.Net Technologies CSS, JavaScript

Database SQL, PL/SQL

Tools RSA Archer, Visual Studio 2010, SQL Server Management Studio 2008, NPanday, HP Quality Center, Nuget, Tortoise SVN, MS Visio, CA Agile Requirements Designer SCHOLASTICS

● Bachelor of Technology (Information Technology) from Rajasthan Technical University, India Year: 2011

● Certified SAFe Practitioner 4.0

● Certified Scrum Master accredited team member

KEY PROJECTS HANDLED

Project Second Line Compliance Testing (SLCT) Client American Express Location Phoenix, AZ USA Technologies Used RSA Archer SLCT is a compliance function to monitor various specific risks such as non-compliance with applicable laws and regulations. There can be multiple compliance function reporting directly to senior management/governing body, with responsibility for specific types of compliance monitoring.

Profile- Technical Lead

● Built and mapped business requirement into Archer Platform.

● Designing the access control for sensitive compliance data.

● Leading the architectural design of the solution & Facilitating the technical team for other requirements of the solution

● Designing the ingestion path for compliance data being received through Promontory and KPMG.

● Leading the migration efforts of all manual, excel data being imported to the SLCT application.

● Created high level and low-level design, end to end development and maintenance of solutions and applications as per clients’ requirements.

● Designed access control, customized applications and solutions, creation and customization of the existing workflow in Archer, designed integrations with the help of data-feed manager, designed notification letterheads, configuration of iView, dashboard and workspace, questionnaires and findings, ACLs and other actions. Project Project Management & Tracking Client American Express Location Phoenix, AZ USA Technologies Used RSA Archer PMT manages the lifecycle of a Project which get opened as part of the approved applicable Business Unit for any law or regulations which is in-flight to become Law. This Application then will collaborate with the RCM module. Profile- Technical Lead

● Built and mapped business requirement into Archer Platform.

● Designing the access control for sensitive compliance data.

● Leading the architectural design of the solution & Facilitating the technical team for other requirements of the solution

● Leading the migration efforts of all manual, excel data being imported to the PMT application, the data for which the life cycle was managed manually earlier

● Created high level and low-level design, end to end development and maintenance of solutions and applications as per clients’ requirements which Includes Cascading & Revocation through data feeds.

● Designed access control, customized applications and solutions, creation and customization of the existing workflow in Archer, designed integrations with the help of data-feed manager, designed notification letterheads, configuration of iView, dashboard and workspace, questionnaires and findings, ACLs and other actions. Project Global Legal Inventory (GLI) Client American Express Location Phoenix, AZ USA Technologies Used RSA Archer GLI is an inventory to manage all In-force Laws & Regulations which will be managed & identified as applicable/Not-Applicable based on Products and Legal Entities with respect to American Express. Profile- Technical Lead

● Built and mapped business requirement into Archer Platform.

● Designing the access control for sensitive compliance data.

● Leading the architectural design of the solution & Facilitating the technical team for other requirements of the solution

● Designing the ingestion path for compliance data being received through Promontory and KPMG.

● Leading the migration efforts of all manual, excel data being imported to the SLCT application.

● Created high level and low-level design, end to end development and maintenance of solutions and applications as per clients’ requirements which Includes Cascading & Revocation through data feeds.

● Designed access control, customized applications and solutions, creation and customization of the existing workflow in Archer, designed integrations with the help of data-feed manager, designed notification letterheads, configuration of iView, dashboard and workspace, questionnaires and findings, ACLs and other actions. Project Regulatory Change Management Client American Express Location Phoenix, AZ USA Technologies Used RSA Archer RCM is a compliance function to monitor various specific laws and regulations which are in-flight to become Laws. All the in- flight changes need to be tracked with Project tracking where LOBCOs & SMEs come & drive the tracking with approval workflows

There can be multiple compliance function reporting directly to senior management/governing body, with responsibility for specific types of compliance monitoring.

Profile- Technical Lead

● Built and mapped business requirement into Archer Platform.

● Leading the architectural design of the solution.

● Designing the access control for sensitive compliance data.

● Designing the ingestion path for compliance data being received through Promontory and KPMG.

● Leading the migration efforts of all manual, excel data being imported to the SLCT application.

● Created high level and low-level design, end to end development and maintenance of solutions and applications as per clients’ requirements.

● Designed access control, customized applications and solutions, creation and customization of the existing workflow in Archer, designed integrations with the help of data-feed manager, designed notification letterheads, configuration of iView, dashboard and workspace, questionnaires and findings, ACLs and other actions. Project Internal Audit Group Client American Express Location Phoenix, AZ USA Technologies Used RSA Archer Internal Audit Group (IAG) is empowered to execute assurance activities to evaluate internal control risks and furnish the Committee with analysis, recommendations, and counsel concerning activities reviewed. The scope of internal audit activities is designed to provide reasonable assurance that.

Profile- Programmer

● Created DDE such as Apply Conditional Layout, Generate Notification, Set Date, Set Filter Value List as per the business need and Configured Workspace, dashboards, iView’s.

● Transforming Legacy Data Files into various formats to facilitate data load in Newly built system also Performed data Migration from Legacy system to Point of Arrival solution in Archer

● Created various data feeds to facilitate the data migration

● Responsible for upgrading Archer from v5 to v6; recently upgraded from v6.3.0.5 to v6.4 HL1.

● Creating and executing data feed for migrating legacy data of applications.

● Worked in the team responsible to increase user experience. This included interacting with end-users to know their experience, feedback and overall ease in using the tool. Project Process Risk Compliance Assessment Client American Express Location Phoenix, AZ USA Technologies Used RSA Archer Process Risk Self-Assessment (“PRSA”) has been developed to provide a consistent and effective process for the evaluation of operational risk at Organization. The methodology is designed to capture and evaluate all types of operational risk that impact the Company, including financial reporting, compliance, and operations. Profile- Programmer

● Created DDE such as Apply Conditional Layout, Generate Notification, Set Date, Set Filter Value List.

● Configured Workspace, dashboards, iView’s.

● Performed data import by using dummy data file.

● Understanding how various requirements are getting mapped and implemented into the RSA Archer application.

● Created various data feeds

● Analysis and development of various requirements and configure those requirements into the RSA Archer application Project Office Of Ombuds Portal R2 Client American Express Location Gurgaon, India Technologies Used ASP.net, C#, SQL, Ajax, Javascript OfficeofOmbudsperson is the office which handles all the AMEX employee’s issues in a securely & anonymously and that too directly been supervised through Director’s office. The project was the enhancement of features which existing application provides in terms of Group reporting Interface, New Filter criteria’s, Bulk Updates. Profile- Programmer

● Worked with Onsite counterpart for Requirement Gathering, Functional & Technical Feasibility Analysis

● Responsible for all front end & business logic developmental activities on ASP .Net (C#) code as well as back end development on MSSQL

● SME for whole application & Prepared Test Cases and various Design documents

● Design Business Process Flows for Regression testing using Third party tools like CA Agile Designer & Critical Logic’s Test Management Execution (TMX)

● Subject Matter Expert for the application

● Wrote stored procedures and triggers for application’s DataBase also implemented LINQ to DataSet in Business Layer.

● Independently handled build of the application modules (registration, audit trails, etc.)

● Prepared Test Cases and various Design documents Project Disclosures Client American Express

Location Gurgaon, India Technologies Used ASP.net, C#, WCF, SQL Disclosures application is hosted over GCO Portal reusable services. All employees which are authorized by GCO Portal can access this application. Primarily this application is used to disclose the concerns like conflict of Interests which can be an issue for American Express.

Profile- Programmer

● Feasibility analysis, Requirements gathering, SME & point of contact for all business functionality related queries for offshore

● Design and Development of Front End (ASP.net, C#, WCF) as well as backend code

● GCO Portal Web Services Integration and Implemented client side Project GCO Portal Client American Express

Location Gurgaon, India Technologies Used ASP.net, C#, WCF, SQL, Ajax, Javascript This application serves as a platform for hosting multiple applications. Exclusively for American Express GCT office in which user can access all the applications for which they are authorized by use of portal dashboard. Primarily this application exposes web services for Reusable components which are consumed by other applications. Profile- Programmer

● Design and Development of Front End (ASP.net, C#, WCF), backend code of reusable components like master data management, Discussion thread, Application Management, User Management

● Enhanced code reusability by implementing better class hierarchy

● Implemented Dynamic procedures

● Code improvement by following coding standards and removing application warnings

● Unit testing and integration testing of the application

● Delivering knowledge sharing sessions to the project team

Contact this candidate