Bharat Acharya

Pune, Maharashtra/India

About

Title: Project Lead

Bharat Acharya, CSM

          Mobile: +919860005945,

                        Email: [email protected]

PROFESSIONAL SUMMARY                 

 

BFSI – Techno Functional implementation specialist:

REGULATORY REPORTING

 

Techno-Functional Consultant ~ Professional Services ~ CSM ~ Solution Architect ~ Database Design ~ Presales ~ Project Management  

  • Sixteen years of rich IT Techno-functional experience in system study, analysis, design, development, Testing & Implementation of business systems
  • Working experience as Scrum Developer and Scrum Master
  • Professional Services experience with major banks
  • Banks worked with OCBC, RBS, BNPP, BARCLAYs, SocGen, Nataxis in Singapore and Hongkong and USA.
  • Understanding of Bank environments, like Source system, Citrix, worked on testing of issues of citrix and product  
  • Techno-Functional experience Product development to Implementation
  • Excellent Knowledge of Banking and Finance Products,
  • Good exposure to Financial Reporting, Regulatory reporting, Risk Reporting
  • Worked on ETL development on OWB, Terra data, Oracle
  • Good Knowledge of Data warehousing,
  • Database Performance tuning – Functional
  • Worked on Proof of Concept (POC) with Vijaya Bank
  • Worked on Request For Proposal (RFP) for various banks in India
  • Strong analytical and conceptual skills in database design and development.
  • Proven skills of transforming business requirement into software data model and technical specifications.
  • Excellent communication, amicable leadership, enjoys new challenges, continuous urge to acquire knowledge.
  • Certified ScrumMaster, from Scrum Alliance

 

CORE COMPETENCIES

  • Banking and Finance Domain Knowledge.
  • Functional knowledge of Regulatory Reporting of India, Singapore, Australia, Japan, Hong Kong.
  • Professional Services
  • Client/Vendor Management.
  • Presales and Post sales Management.
  • Agile Project Management
  • Project Plans.
  • Interface development of ‘Extract Transform Load’ (ETL).
    • Expert on Monetary Authority of Singapore reporting
    • Knowledge of India ‘Automated Dataflow’ (ADF) Reporting.
  • Delivery Specification Implementation of Regulatory Reporting for various countries like XML, XBRL.

                                             

TECHNOLOGY IMPLEMENTATION

  • Visual Basic, C#.Net, Strong OOP’s Concept
  • COM/DCOM, SQL, ETL development, basic knowledge of Terra data, OWB
  • Team Foundation Server, VSS.
  • Oracle 9i/10g/11g, Oracle P/L SQL,

                  

ACKNOWLEDGMENT AND AWARDS                

  1. Four Times Awarded with “Manager on the Spot” awards for being the most hardworking and consistent growing performer of the team by Company.
  2. Received “Achievement/Appreciation Letters” directly from the Customers for Best Performer. Customers acknowledging the performance.
  3. Travelled Onsite to US (B1 VISA Valid till 2016), worked in Singapore (EP for 2 years), and HK for providing Training, Support and Project Discussions and PS work.2
  4. Represented Company by demonstrating the Product Demos to multiple Top Graded Private and Public Sector Banks across India.

 

  1. Involved in the Pre-Sales activities along with Request for Proposal (RFP) and Proof of concept (POC).

 

  1. Successfully lead steering committee meetings and PMO activities within project.

                                               

EMPLOYMENT HISTORY

 

Wolter Kluwer Financial Services, India

Project Lead

Mar 2006 – Till Date

Quagnitia Systems Pvt Ltd., Pune

Sr. Software Engineer

Oct 2005 – Mar 2006 

Quadrant Technologies, Nagpur

Team Leader         

Apr 2002 – Sep 2005 

Krish Infotech, Nagpur

Team Leader         

Aug 2000 – Apr 2002

M.B.Koparkar Consultants, Kolhapur

Software Engineer   

July 1998 – Aug 2000

 

 

 

 

Career History

I.Wolter’s Kluwer Financial Services India Pvt. Ltd (WKFS) –

Project Name – ReportGenerator (RG)                                                   From March 2006 till date

Project Lead

Tech Used –Visual Basic Script, C# .Net, COM, Oracle PL SQL, SQLServer

Source Control – TFS, SOS, VSS

 

WKFS is market leaders in providing regulatory solution across the global. Regulatory Intelligence, our in-house experts are solely focused on the compliance and risk management challenges of financial services organizations. These former regulators, attorneys and compliance analysts continually mine and analyze the changing regulatory landscape and procedural requirements. As a result, we provide our customers with the information, processes and tools needed to integrate compliance and risk management into their workflow. Our solutions and insight enable them to make better decisions for their business and best balance the dynamic tension between risk and opportunity.

 

Roles and Responsibility –

In current company, I played the roles of System Analyst, Technical/Business Consultant and currently Project Lead.

 

As Project Lead directly responsible for –

  1. Managing the Implementation of products to the customer END to END.
  2. Defining reporting workflow for customers for product.
  3. ETL Development Source System and Product
  4. Consulting on business/reporting requirements
  5. Handling technical queries and providing technical solutions to Team.
  6. Support SIT/UAT and Go Live
  7. Providing Functional Solutions to Customer.
  8. Ensuring best Quality Product Delivery.

 

Brief Description –

 

  • Product consultations,
  • Customer Engagement,
  • ETL Design Support
  • Managing complete product implementation with life cycle for customers
  • Product training for customers.
  • Mentoring for all the Professional Services and Technical Development team across Asia Pacific Group zone.
  • Interacting and coordinating with cross functional and cross region teams.
  • Risk Management, providing regular updated to stakeholders through status reporting cost and time escalations, notification on the risk associated with the project.
  • High involvement in the design and architectural discussions. Technical Query Handling.
  • Performance benchmarking activity for applications.
  • Pre- Sales activities.
  • Worked on RFP and POC for multiple banks, foreign and local.
  • Worked on performance benchmarking of products
  • Worked on performance tuning
  • Worked as scrum master/ scrum developer

 

Engaged with Customers successfully –

1. Barclays,  

2. RBS,   

3. SocGen,   

4. Nataxis,   

5. OCBC,

6. BNPP, 

7. BP2S, 

8. JPM,

9. Bank of India

 

Following Project Implemented and Delivered successfully -

1. HKA – Hong Kong,

2. SGA - Singapore,

3. JPA - Japan,

4. TWA - Taiwan,

5. MYA – Malaysia,

6. AUS – Australia,

7. INA – India

 

Automation :

The purpose of automation module is to ensure daily end-to-end reporting as overnight process. The process designed in such way that it can be triggered/controlled using tools like Control-M, MS Task Scheduler. This includes loading of data in Report Generator- Global Data Model using sqlldr. Using with XML parameterization/csv it controls the execution of process involved in reporting such as

  • Data Load
  • Technical Validation
  • Mapping between Source, DWH to Data Mart
  • Cross Validation
  • Netting
  • Coverage
  • Consolidation of Data
  • Report Allocation
  • Report Validations

 

Netting:

The purpose of the netting module is to provide a mechanism to net related balances in a dataset so that they are all having the same Credit/Debit indicator (TYP_DC_INDICATOR). Then accordingly, when they are allocated on the reports, they will all be reported in the same line item.

It hopes to solve the following representative cases:

  • Net all FX-spot control accounts & report them either in Asset side if net asset or liabilities if otherwise
  • P&L Gain on sale of securities: report them on net basis.

 

Coverage: (Credit Risk Mitigation)

Coverage process is a process which is used to calculate the covered and uncovered exposure against limits and collateral provided. This is used to provide a critical information of uncovered exposure which could be a risk to any bank, wherein the chances of default are high.

Collateral and guarantees if properly taken in account will help in credit risk management.

  • To mitigate credit risk by providing secondary source of repayment in the even that borrower defaults on a credit facility.
  • To gain control of the collateral which is the primary source of repayment of a facility if defaulted.
  • To apply a lower capital risk weight to credit which are secured by collateral of guarantees.

 

 

II.Quagnitia Systems Pvt Ltd.,

Project Name – Mingle Time                                                     From Oct 2005 – Mar 2006

Sr Software Engineer

Tech Used –Visual Basic, COM, OCX

Source Control –VSS

 

Roles and Responsibility –

 

As Sr. Software Engineer, I was involved in design and development of multi-Player games. These games can be played over internet between two or more players

 

Games Developed and Tested

  1. BackGammon
  2. Yahtzee
  3. Spades
  4. Poker
  5. Darts
  6. Chess (Multiplayer)

 

 

III.Quadrant Technologies, Nagpur                               From April 2002 – Oct 2005

Team lead-Partner

Tech Used –Visual Basic, COM, OCX

Source Control –VSS

 

Roles and Responsibility –

As Team leader developed various products and Projects as a part of delivery. I was part of design and development of product for banks and credit co-operative unions. This is live with more than 100 customers.

I worked on projects which were part of automation delivered to BARC.

Developed the products for on-line Portals     

 

Automation of Test Console for Reactivity Control Mechanism

Technologies Used: Visual Basic.net, MS Access, and Windows.

Hardware: Industrial PC make Axiomtech, Axiomtech PCI 52282 ADC card, Axiomtech PCI 52056 DIO Card

Client: M/S Prolific Systems & Technologies Pvt. Ltd., Thane

Team Size: 3

Duration: Jan 2005 – July 2005

Details: This project developed to automate the testing procedures of reactivity control mechanism. This is algorithm implementation of testing procedures. Here I have used the API of different PCI Cards.

Responsibilities: Requirement Gathering, Transforms the knowledge articulately in form of System Requirement, Functional Design & User Interface design, Coding, Unit Testing, Implementation, User Training

Special Mention from Client on completion

 

 Mudra Banking Software

Technologies Used: Visual Basic 6.0, MS SQL Server/ MS Access, Windows, and ActiveX.

Client: M/S Quadrant Technologies, Nagpur

Team Size: 7

Duration: April 2002 – Oct 2004

Achievement: This product is successfully working at more than 80 clients

Details: This is product of QT, which developed for office automation system for rural and small sector co-operative banks. This product has been developed for non-skilled users. They find this product very easy to understand. We have used multilingual platform where we can draw reports in two languages. We are using various technologies to benefit the client’s clients.

Responsibilities: Requirement Gathering, Transforms the knowledge articulately in form of System Requirement, Functional Design & User, Interface design, Database Design, Coding, Implementation, System Integration, Directions for Integration Test Plan, Version Management

 

Net Café

Technologies Used: Visual Basic 6.0, MS Access, Windows, Socket Programming, and ActiveX.

Client: M/S Quadrant Technologies, Nagpur

Team Size: 3

Duration: Oct 2002 – Dec 2002

Details: This product is developed for office automation and data maintenance of Internet café. This product has two modules one is on the server and other is present in the client. The software uses the socket server for communication.

Responsibilities: Requirement Gathering, Transforms the knowledge articulately in form of System Requirement, Functional Design & User, Interface design, Database Design, Coding, Implementation, System Integration, Directions for Integration Test Plan, Version Management

 

Inventory Management System

Technologies Used: Visual Basic 6.0, MS SQL Server/ MS Access, Windows, and ActiveX.

Client: M/S Sanstar Microsystems Pvt. Ltd, Nagpur

Team Size: 3

Duration: Jan 2003 – June 2003

Details: This product is developed for office automation, Inventory management and stock maintenance. This project covers the inventory of items that are in transit or for which order is placed.

Responsibilities: Requirement Gathering, Transforms the knowledge articulately in form of System Requirement, Functional Design & User Interface design, Coding, Implementation, System Integration, Directions for Integration Test Plan

 

Office Automation for Printing House

Technologies Used: Visual Basic 6.0, MS SQL Server/ MS Access, Windows, and ActiveX.

Client: M/S Image Producers, Nagpur

Team Size: 3

Duration: July 2004 – Dec 2004

Details: This product is developed for office automation, Inventory management and stock maintenance, Finance & Accounting, Order booking. This project was developed in form of modules. These modules further integrated.

Responsibilities: Requirement Gathering, Transforms the knowledge articulately in form of System Requirement, Functional Design & User Interface design, Database Design, Coding, Implementation, Directions for Integration Test Plan

 

Inventory Management System for retailers

Technologies Used: Visual Basic 6.0, MS Access, Windows and ActiveX.

Client: M/S Quadrant Technologies, Nagpur

Team Size: 2

Duration: July 2003 – Dec 2003

Details: This product is developed for office automation, Inventory management and stock maintenance, Finance & Accounting, Order booking. This project was developed in form of modules. These modules further integrated.

Responsibilities: Requirement Gathering, Transforms the knowledge articulately in form of System Requirement, Functional Design & User Interface design, Coding, Implementation, System Integration, Directions for Integration Test Plan, Version Management

 

IV.Krish Infotech, Nagpur                                              From – Aug 2000 - Mar 2002

Team Lead

Tech Used –Visual Basic, COM, OCX

Source Control –VSS

 

V.M.B.Koparkar Consultants, Kolhapur                      From – Oct 1998 - Aug 2000

Software Engineer

Tech Used –Visual Basic, COM, OCX

Source Control –VSS

Pushkar Banking Software

Technologies Used: Visual Basic 6.0, MS Access, and Windows.

Client: M/s M. B. Koparkar Consultants, Kolhapur.

Team Size: 5

Duration: Oct 1998 – March 2000

Achievement: This product is successfully working at more than 5 clients

Details: This is product of MBKC, which developed for office automation system for rural and small sector co-operative banks. This product has been developed for non-skilled users. They find this product very easy to understand. We have used multilingual platform where we can draw reports in two languages.

Responsibilities:  Functional Design & User Interface design, Coding, Unit Testing, Implementation, User Training, Version Management

 

ERP for spinning mill

Technologies Used: Visual Basic 6.0, MS Access, and Windows.

Client: M/s Priyadarshini Co-operative spinning mill, Shirpur, Dhule.

Team Size: 4

Duration: Jan 1999 – Aug 1999

Details: This product is developed for office automation, Inventory management and stock maintenance, Finance & Accounting, Order booking. This project was developed in form of modules. These modules further integrated.

Responsibilities: Requirement Gathering, Transforms the knowledge articulately in form of System Requirement, Functional Design & User Interface design, Coding, Unit Testing, Implementation, User Training

 

ERP for Co-operative Sugar Industries

Technologies Used: Visual Basic 6.0, MS Access, and Windows.

Client: M/s M. B. Koparkar Consultants, Kolhapur.

Team Size: 5

Duration: Sept 1999 –Dec 1999

Achievement: This product is successfully working at more than 3 clients

Details: This product is developed for office automation, Inventory management and stock maintenance, Finance & Accounting, Order booking. This project was developed in form of modules. These modules further integrated.

Responsibilities: Requirement Gathering, Transforms the knowledge articulately in form of System Requirement, Functional Design, User Interface design, Coding, Implementation

 

Asset Liability management

Technologies Used: Visual Basic 6.0, MS Access, and Windows.

Client: M/s M. B. Koparkar Consultants, Kolhapur.

 

Automation for co-operative Irrigation Scheme

Technologies Used: Visual Basic 6.0, MS Access, Windows, Map Info, and MapX.

Client: M/s M. B. Koparkar Consultants, Kolhapur.

Team Size: 3

Duration: May 2000 – Aug 2000

Details: This product is developed for office automation, Inventory management, Finance & Accounting. This project was developed with MapX tool. The maps of co-operative irrigations digitized and data related with ESR and other required details maintained.

Responsibilities: Requirement Gathering, Functional Design & User Interface design, Coding, Unit Testing

 

In addition to above mentioned project there were various other projects on which I had done considerable contribution and those are listed as below:

Direct time state estimator

Technologies Used: Visual Basic.net, Windows XP.

Hardware: Industrial PC make Axiomtech, Adlink PCI 9114 ADC card, Axiomtech PCI 52104 DAC Card

Client: M/S Prolific Systems & Technologies Pvt. Ltd., Thane

 

Mixer Profile Logger

Technologies Used: Visual Basic 6.0, MS Access, Windows, DDE, Modbus server.

Hardware: Home PC, Communication with PLC

Client: M/S Prolific Systems & Technologies Pvt. Ltd., Thane

 

SCADA for CRP

Technologies Used: Visual Basic 6.0, MS Access, Windows XP, NAP OPC server.

Client: M/S Prolific Systems & Technologies Pvt. Ltd., Thane

 

www.chriscookies.com

Technologies Used: ASP, MS Access, HTML, DHTML, FrontPage, and Photoshop.

Client: LEIT, NJ, USA

 

www.ytechwireless.com

Technologies Used: ASP, MS Access, HTML, DHTML, FrontPage, and Photoshop.

Client: LEIT, NJ, USA

 

www.ucallmobile.com

Technologies Used: ASP, MS Access, HTML, DHTML, FrontPage, and Photoshop.

Client: U Call Communication, NY, USA

 

www.softcaliber.com

Technologies Used: HTML, DHTML, FrontPages, Photoshop and PHP.

Client: Softcaliber Inc., VA, USA

 

www.bagchibooks.com

Client: bagchi Publisher

Technologies Used: My SQL, Java, JDK 1.2, Java Servlet Programming, JSP, JDBC, Java, and Linux

 

Inventory and Site Management for construction company

Technologies Used: Visual Basic 6.0, MS Access and Windows.

Client: M/s Parwani Builders, Nagpur

 

                                               

EDUCATION QUALIFICATION

 

BE Electrical

Shivaji University

July 1994 to June 1998

Certified ScrumMaster

ScrumAlliance.org

Oct 2014

 

 

 

 

                                               

PERSONAL DETAILS

 

Name

Bharat Vasantrao Acharya

Email ID

 [email protected]

Address

 B-102, Eisha Empire, Handewadi Road,

 

 Hadapsar, PUNE – 411028

Phone

+91-9860005945