Saurabh Pramanick Phone: 9967918427 / 9773430981 Mailto: [email protected] __________________________________________________________________________________ __________________________________________________________________________________ Objective
Seek a challenging position that offers professional growth and creative work environment to utilize my knowledge in various spheres such as Finance, Intellectual Property, I.T, and Management.
Seeking assignments in Managerial Roles and Functional Services to utilize my skills & experience to deliver business solutions to complex requirements and to continuously update abilities to keep pace with requirements of clients.
Overview
• MBA in Business Design with over 5 years’ experience in financial domain.
• 10 months as Business Analyst for Tata Capital. Primary role included implementing Core Banking Solution TCS B@NCs and its modules for the Client.
• 2 years 2 months as Quality Assurance Analyst using PL SQL developer, Manual & Automation testing for Web based applications & database testing for Bank of America. • 3 months experience as Subject Matter Expert with Cheers Interactive Pvt Ltd in
Intellectual Property Rights, Patents law, Copyrights and Trademarks. Excellent understanding of the Intellectual Property processes, patent classification systems, patent and non-patent literature database, search tools and methodologies, and IP related work like Prior art, Freedom to practice, Patentability, Infringement search & analysis, Patent portfolio management, white space analysis, Patent competitive landscapes, monitoring IP activities of competitors etc., Drafting and prosecuting patent applications.
Post Graduate Diploma in Patents Law, Nalsar Hyderabad.
• 3 months experience as Management Trainee with First Rand Bank, South Africa in developing Financial products for Financial Inclusion
• 2 months experience as Management Trainee with Mauj Mobile in Content Management for Value Added Services of Leading Telecom operators like Airtel, Vodafone, Tata Docomo, Aircel, Idea etc.
• Domain Knowledge – Data Analyst, Finance, IT, Intellectual Property, Media.
• Excellent knowledge of Data Analytics, Statistical Concepts and use of statistical tools like Advance features of MS-Excel, SPSS.
• ISTQB Certification
• FTC Certification in Non-Banking Financial Corporations • FTC Certification in Business Analytics
• FTC Certification in Retail Banking
TCS Experience Summary
Project Tata Capital
Role Business Analyst
Period 21/03/2014 to 31/01/2014 - 10 Months
Technical Skills Functional knowledge of Banking and NBFC, Remedial Process, SQL,UNIX Achievement - Implemented several Change Requirements as requested by the Client for
their Loan and Deposit Modules.
- Handled the deposit, loan and credit-processing requirements of the client as well as interfaces to general ledger systems and reporting tools
- Implemented integration of other source and destination system with TCS - B@NCs
- Handled customer queries in production and tracked them to closure. - Single point of contact in implementing Remedial Module for Tata Capital
using a third party application.
Description - Requirement Analysis which includes gathering requirements and preparing specifications from client for TCS B@NCs.
- Contribution to TCS B@NCs product and customize development.
- Understand Business Requirements from Internal and External Customer for TCS B@NCs.
- Detail Scope and assumptions as well as constraints, Release the scope document with stakeholders, Review and receive Sign-off from stakeholders. - Product Enhancements for TCS B@NCs which includes identifying product
enhancements opportunities, Drive the entire product enhancement project in line with Business Consultation to Products and Solutions group.
- Articulate and enlist business requirements into a Business Scope Document, Write requirements/specifications for all new product features & additions to existing features.
Project Bank of America – Merrill Lynch
Role Quality Assurance Expert
Period 20/09/2010 to 31/05/2012 - 21 Months Technical Skills STLC, SDLC, UNIX, SQL, PL/SQL
Achievement - Module Lead for Auto-Merge module of Client and Account Data of GWIM Team of Merrill Lynch
- Process improvement for various testing methods used in the project. - Received several client appreciations for detecting Production issues and
tracking them to closure.
- Implemented Resource availability Metric for tracking resource on-time and off time records.
Description - Analyzing Requirements, Planning and Execution of projects under Client and Account Data of Bank of America/Merrill Lynch Client.
- Analyzing quantitative legacy data using analytical tools like SPSS and Microsoft Excel to customer segmentation and go to market strategy for each customer segment.
- Perform various financial analysis like Revenue analysis, Revenue optimization, and Competitive analysis and come up with pricing models to target the new customer segment.
Project ILP Training - Mumbai
Role Trainee
Period 01/04/2010 to 10/07/2010 - 3.33 Months Technical Skills UNIX, SQL, PL/SQL
Achievement - Completed the ILP successfully
- Worked with the RMG Head (Pune) and was the single point of contact to allocate resources to various projects as per the requirement.
Description - Essential Training in UNIX, SQL, PL/SQL
Technical Skills
Software SQL, PL/SQL, UNIX, Visual Basic, C, C++, Advanced concepts of Microsoft Excel, Oracle 10g
Hardware Well versed with computer hardware knowledge and its peripherals
Tools HP Quality Center, Toad for Oracle, Putty, TCS Application Life cycle Manager, Basic and Advanced MS Office, PL/SQL Developer
Methods STLC, SDLC, Idea to Execution Domain
Experience
- Retail Banking - Mobile VAS
- Wealth Management.
- Intellectual Property Rights (IPR)
- Data Migration, Data Analytic and Business Intelligence - Loans and Deposits
- Remedial Process for Overdue Contracts
Management Experience
Project FIRST RAND BANK
Role Management Intern
Period May, 2013 – July, 2013 - 3 Months
Domain Finance
Achievement - Analyzing market requirement and developing new products for financial inclusion.
- FRB Health Clinic – Unique offering for peri-urban target segment
- FRB Thane – Market establishment & coverage, BC identification in Thane District.
- Planning and execution of live project for Bank’s client.
Education Summary
Qualification Subject Percentage/Grade
Post Graduate Diploma In Management Business Management 7.20 Bachelor Of Engineering Electronics & Communication 72.52% Standard XII / H.S.C. Physics, Chemistry & Mathematics 82.33%
S.S.C All 86.93%
Certifications and Recognitions
ISTQB Certified Tester.
FTC Certification in Non-Banking Financial Corporations FTC Certification in Business Analytics
FTC Certification in Retail Banking
Certification in Life Insurance conducted by IRDA
Completed TCS Web Based Trainings and Brain Bench Tests in RDBMS concepts, SQL, PL/SQL, OS concepts, Programming Techniques and Concepts, UNIX, Testing concepts and methodologies.
Completed Modules and examinations in Anti-Money Laundering and Information Protection Act of Bank of America.
Completed TCS Competencies in Analytical ability, Coaching, Communication, Organizing and Planning, Team Skill, Continual learning.
Attended Rational Performance Testing course conducted by TCS. Infosys Campus Connect from Datta Meghe College of Engineering. MS-CIT examination in 2005
Typing and Shorthand course in 2003.
Skill sets & Capabilities
- Excellent knowledge of MS Word, Excel (Advanced Techniques and Macros) and PowerPoint. - Knowledge and expertise in testing tools like HP Quality Center (QC) 10.00, HP Quick Test
Professional 9.5, and TOAD for Oracle and SQL Developer.
- Knowledge and Work experience in operating systems like UNIX, UNIX shell scripting and Windows, Query language like SQL, PL/SQL (Oracle 9i and 10G), web technologies like, XML
- Expertise in GUI application testing, Functional Testing, Regression Testing and web-based applications.
- Lead Guitarist in TCS band. Performed in various events.
- Received I-speak award from Tata Consultancy Services in Technical Paper Writing. - Participated in Technical paper presentation organized by IEEE.
- Participated in Technical paper presentation organized by EESA.
Personal Details
Date of Birth 30th October,1987
Marital Status Single
Nationality Indian
Languages Known English, German, Bengali, Hindi, Marathi
Assets Reliable, Dedicated, Hard Worker,
Positive Attitude
PAN ASTPP3063F