Pluton Dutta
E-mail: acs5f4@r.postjobfree.com Mobile No: +91-983*******
Business Analytics Manager with exceptional record of delivering cost effective, high performance technology solutions to meet challenging business demands. Extensive qualifications in all facets of information systems methodology understanding business requirements, creating requirement and functional documents, coordinating with business and technical teams during project life cycle, user training and quality review. Worked extensively with Fortune 500 companies. Demonstrated skills in analyzing current market conditions, understanding industry trends and recommending most appropriate courses of action for clients and partner companies. Creating dashboards and BI reports for senior management. Able to build strong, sustainable relationships with internal and external individuals. Perform effectively under high-pressure situations. Maintain high level of ethics.
Key Competencies & Skills
TNI and TNA
Supporting Strategy Rollout
Banking and Ecommerce domain
Business Analysis
Change management
Client relations
Business Intelligence
MIS and Reporting
Data Migration Mapping
Project Management
CRM & Workflow
Test planning
Analytical & Quantitative Skills(SAS)
Strategic Research & Analysis
Data Warehouse / Data Mining
Career Objective
To succeed in an environment of growth and excellence and earn a job which provides me job satisfaction and self-development and help me achieve personal as well as organizational goals. Seeking a role in the Analytics or MIS functionary in an esteemed organization which emphasizes on an employee’s career development, progression and growth prospects.
Professional/Academic qualification
2011-2012: Stock market trading from Shivam Equities. (Training duration 1.5 years)
1998-2002: Bachelor of Engineering (Computer Science) from Burdwan University, WB {1st class}
1996-1998: Higher Secondary - WBCHSE – {1st class 72% marks}
Technical Skills
Creating Dashboard Reports using MS-Office.
SAS Products: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS/ODS
[Data Extraction; Data Validation; Data Modification; Data Management;]
[Data Analysis & Data Reporting using DATA & PROC Steps in SAS]
Retrieving Sales and Financial Data using SQL queries; analyzing these data to create business/financial reports for CEO and Top Executives for clients like IBM.
Analyze the data using SAS and create financial reports for customers like HSBC.
Database experience SQL Server 2005, MS Access.
Extensive experience working with Microsoft Office Suite Products (Word, Excel, PowerPoint, Visio and MS Access)
Operating Systems: MS Windows NT, 2000 PROFESSIONAL, 95/98, XP, Windows 7, MS-DOS, Unix-CLI, LINUX.
Scripting: VBScript, VBA & Macros, DOS-BAT, SQL – Access, Server.
Application Packages
MS Office (All versions) {Word, Excel, Access, PowerPoint & Visio}
SAS {Statistical Analysis software} (versions 9+)
Remote environment: Putty, Win SCP, Remote Desktop Protocol, Citrix web access.
Stock Market trading:
Knowledge of online e-stock trading software for buying and selling of shares as per client’s requirements. (Training period Jun -2011 to Sep-2012)
Work experience
Job profile – (08)
Working as a Business Analytics Manager in Utsav Fashions Private Limited
Work Synopsis
Primarily engaged in business analytics and comparative studies, by the way of applied statistics. Instrumental in the conceptualization of customer interaction optimization framework by creating meaningful data structures to be ensued by the generation of excel based control charts / MIS / dashboards / scatter plots etc. following the principles of DMAIC protocols. This profile is a level higher than the previous profile (07) wherein, I had been endowed with multifaceted and more complex responsibilities, however in the same domain, which is primarily based on information science, MIS, reporting and analytics.
Job profile – (07)
Worked as a MIS and Analytics team leader - in the e-Commerce Customer Service domain in Utsav Fashions Private Limited starting from 02 May 2013
Work Synopsis
Am responsible for strict SLA based deliverables pertaining to MIS and analytics, across verticals in the customer service domain pertaining to e-commerce industry. Collation, integration and automation of Customer data from various sources, including Sugar CRM, MS ACCESS, Excel to a single point of application and control. Creation of data marts for generation of a single version of truth. Provide support to adhoc-analysis requests related to Cross Verticals in Operations. I am a part of Engagement Analysis team, evaluating the effectiveness of the marketing campaigns & promotions looking at different performance metrics.
Job profile – (06)
Worked as a self employed stock trader for my father’s stock trading business, post getting trained from Shivam Equities, under the sub-brokership of Ashika Stock Broking Limited during the year 2012.
Work Synopsis
Developed and maintained client base. Updated client’s plan and acquired new clients on an ongoing basis. Determined changes in client’s financial status. Provided knowledgeable, objective equity and guidance to consumer. Worked with margin accounts, give buying power, and balances. Followed up on leads from potential customers.
Job profile – (05)
Worked in HSBC-HDPI as Business Analyst in the customer information management team from Apr-2009 to Apr-2011
Work Synopsis
Was responsible for strict SLA based deliverables pertaining to credit risk strategy monitoring reports, score-card evaluation reports, call center MIS process migration for Operations analytics from various sites to a single point of application and control. Provided data support to credit card risk management, modeling and strategy teams. Also worked in close collaboration with various business intelligence teams by understanding their information requirements and delivered projects and analysis within agreed timescales for credit cards, personal loans and auto-finance. Worked on end to end in SAS/BASE, SAS/SQL, SAS/ODS, SAS/ACCESS, AND SAS/MACRO. Responsible for accessing and managing data and for performing complex queries and analysis.
Extensive programming experience with various procedures like PROC FREQ, PROC SUMMARY, PROC TABULATE, PROC REPORT, PROC FORMAT, PROC CORR and PROC SQL.
SAS Coding, SQL Query writing knowledge.
Data manipulation and merging techniques.
A consistent track record of successfully employing best business practices that improve efficiency, whilst increasing productivity, at all times.
Experienced in creating reports in PDF, HTML, RTF formats using ODS statements
Fine analytical, inter-personal & communication skills with experience in interacting with clients, multiple user groups and managing development teams. Ability to work in a fast paced environment and under deadlines.
Experience in SQL query and Joins along with pass through query.
Programming in MACROS to improve the efficiency.
Excellent written and communication skills.
Achievements
Received the “Best Performance” Award for successful migration, deployment and maintenance of call center operations analytics from multiple regional sites to a central point of application and control. This project helped the stake holders to have a structured and simplistic web based view of processes status on a daily basis that sourced data from a complex set of varied information systems and platforms.
Job profile – (04)
Working in HSBC-HDPI as Business Analyst in the credit risk analytics team from Apr-2008 to Mar-2009
Work Synopsis
Development and maintenance of credit cards and loans Data-mart system, using SAS for efficient and effective execution of data analysis. Was also responsible for producing credit risk strategy monitoring reports, score-card evaluation reports, and various other business critical and data quality monitoring reports. Actively participated in the “Service Excellence Program” launched by HSBC Group for Innovation in the Internal Business Processes
Achievements
Received the “Best Employee” Award for successful completion and maintenance of Credit Card and Personal Loans Data-mart systems for helping various teams to achieve their analytics goals through using clean, concise, structured, accessible, stable and well documented customer information that facilitates the development of a standardized and uniform single version of truth.
Job profile – (03)
Worked in HSBC HDPI as assistant manager learning and development from Apr-2006 to Mar-2008
Work Synopsis
Preparing Training Material and conducting Training sessions.
Managing Headcount/Payroll systems for Training department.
Measurement & Analysis of Trainers Performance/ Trainers' Performance Trend.
Analysis of Training Feedback on Monthly basis.
Inventory management.
Implementation of Six Sigma for measuring training (ROI) Return on Investments.
Achievements
Completed Six Sigma Yellow Belt Certification under the mentorship of HSBC Corporate Quality Team.
Received the Best Employee award for successful Integration of Six Sigma methodologies in the training department.
Became the member of the prestigious HSBC One Hundred Club and received the Best Team Player Award for building and managing an efficient system to facilitate training analysis and measurement.
Pursued and completed variety of leadership courses & programs offered by the HSBC Group.
Completed the “7 Habits of Highly Effective People” program mentored by the Stephen Covey Worldwide Institute.
Job profile – (02)
Worked in IBM BTO as Senior Technical Trainer from Sep-2003 to Mar-2006
Work Synopsis
Preparing Training Material and conducting Training sessions.
Managing Headcount/Payroll systems for Training department.
Measurement & Analysis of Trainers Performance/ Trainers' Performance Trend.
Analysis of Training Feedback on weekly basis.
Training needs Analysis
Inventory management.
Technical Writing.
Achievements
Developing user-friendly courseware for technical support teams.
Conducting Facilitation skills training.
Received the Award for the best technical support specialist.
Completed the IBM Daksh Training Operations Quality Certification.
Job profile – (01)
Worked in Computech International as a systems administrator from Jan-2003 to Aug-2003
Work Synopsis
Handling the customer queries (Hardware and software).
Timely call Escalation, active follow up and timely closure for the same.
Developing medical software using VB and SQL Server.
Maintaining in house local area networking.
Additional Information
Personality traits
I consider myself to be a hard worker, enthusiastic, self-motivated, and energetic person. I consider co-cooperativeness and positive attitude as my additional assets. I am also an efficient team player having good analytical and problem solving skills.
Extra-curricular activities
Was awarded the 2nd position by the Ramakrishna Mission for an Inter-school debate competition.
Successfully organized, and monitored IT fairs and fests at college, and other activities involving seminars and quizzes.
Interests
I enjoy socializing with friends and spending time with my family and have great interest in music. I'm tech savvy and always try to keep up with the ever growing digital/computer technology we have today. I also like to travel and explore various places.
Personal Details
Date of Birth : May 1st, 1979.
Marital status : Married.
Permanent Address : 36, Purbaloke, Kalikapur. Near Metro Cash and Carry, West Bengal, Kolkata – 700099
Place: Kolkata – 700099
Date:
Pluton Dutta