Manikanda Prabu S
Chennai
Summary
- 13+ years of development experience in the area of VBA & SQL.
- 4+ Years of experience in the area of MSBI(SSRS,SSIS) & Power BI
- 3+ years of software development experience in the area of c#,.Net MVC.
- Efficient in designing and developing the SQL Server integration services (SSIS packages) with different control flow task, data flow transformations, security packages and deploying the packages.
- Expertise in building and deploying the reports by using SQL server Reporting Services (SSRS) Mastered the entire cycle of SQL server integration services (SSIS packages).
- Developing/deploying/scheduling/troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
- Acquired knowledge on SQL server Analysis Services (SSAS) Gather data from various sources and transform data into insightful reports and dashboards using basic DAX formulas in Power BI.
- Optimized reporting solutions by creating various clustered, non-clustered indexes and views using SQL.
- Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, Cursors, Derived tables, Common Table Expressions (CTEs) and Complex Queries on Microsoft SQL Server.
- Extensive experience in design, development and Implementation of MS excel/MS Access/ VBA based application. Well versed in web scraping using VBA.
Overview
10
10
years of professional experience
Work History
Technical Lead
Societe Generale
Chennai
01.2020 - Current
- Responsible for all project lifecycle phases from specifications and coding through deployment, testing, debugging, documentation and maintenance
- Creating reports using Global variables, Expressions, Functions, sorting the data, define data source and datasets, calculating subtotals and grand totals using SSRS
- Generated Sub-Reports, Cross-tab, conditional, drill down reports, drill through reports and parameterized reports using SSRS
- Used ETL(SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
- Designed SSIS Packages to transfer data from flat files to SQL Server.
Specialist
Contact Center Company
Riyadh
07.2018 - 12.2019
- Responsible for all project lifecycle phases from specifications and coding through deployment, testing, debugging, documentation and maintenance
- Developed several VBA & SSRS programs to generate dashboard and reports to increase efficiency and performance
- Developed VBA Programs to upload data into FTP and SFTP server using Putty & WinSCP
- Developed .Net MVC application to provide access to new user and upload/download the leads (Customer details) in C-Centrix system which automatically routes the call to the agents via dialer
- Developed WhatsApp Automation which provides update on status of process to respective WhatsApp groups in particular time intervals using VBA web scrapping & WhatsApp application
- Developed MVC application using JavaScript, CSS and SQL server to provide the live updates about the process performance which would help to increase the FCR% (First call resolution) of the customers
- Developed Windows application Dashboard tool using vb.net and SQL
- Handling development team of 3 members in WFM and providing them with technical guidance.
Deputy Manager
Hinduja Global Solution
Bangalore
02.2017 - 06.2018
- Responsible for all project lifecycle phases from specifications and coding through deployment, testing, debugging, documentation and maintenance
- Created Dashboard which shows the Geographical, Vertical, Account and Line of Business wise performance in both List view and graphical view using VBA and windows API
- Developed stored procedures in SQL server to handle Canada scorecards
- Maintenance and support for all existing stored procedures, Functions, Indexes and views in SQL server.
Executive
Contact Center Company
Riyadh
12.2015 - 01.2017
- Responsible for all project lifecycle phases from specifications and coding through deployment, testing, debugging, documentation and maintenance
- Acted as team leader and assigned project responsibilities among team members to meet the project dead line as per defined SLA
- Developed various VBA programs to generate reports and PPT by processing data from different sources such as Avaya, MS Office (Excel, Access, and PowerPoint), SQL Server, Text and Raw File through ODBC and by its objects
- Created various VBA programs to automatically schedule the preparation of client reports by downloading the data from several web pages on a daily basis using Internet Explorer and Windows API.
Developer
RBS Business Corporation Limited
11.2014 - 11.2015
- Requirement analysis from the business and also responsible for all the project lifecycle phases from specifications and coding through deployment, testing, debugging, documentation and maintenance
- Developed several VBA programs to export & import data from external system like Back office (Attachmate)
- Developed SQL stored procedures to automatically trigger greeting mails to the individual on their birthday and on the servicing day
- Developed C# web application to upload the user details into the SQL Server and also to control the SQL jobs and scheduler timings
- Developed several VBA Programs to upload and download the details from the web applications, MS access and SQL Server
- Developed VBA Program to crack the windows application data using windows API.
Senior Executive
HSBC Corporation Limited
- 11.2014
- Responsible for end-to-end project lifecycle
- Developed several GUI interfaces using PCOMM to connect to the HUB (Mainframe System)
- Developed several Excel-VBA-VBScript based interfaces which interact with various screen of PCOMM (HUB – Mainframe Screen)
- Handled the Customer EMI hit for Smart Home Loan twice a month
- Handled the Recertification of the System and Recertification of Macro on quarterly basis
- Developed an interface to interact with various web pages using excel VBA to generate reports based on the business requirements.
Senior Executive
Cognizant Technology Solution
04.2011
- Created GUI interfaces using ODBC to connect RDBMS
- Created several automation tools to generate Client based Report and Client Review Reports on a daily, weekly and monthly basis
- Automated weekly and monthly performance Power point slide reports using VBA
- Created Excel VBA and Outlook based interface to validate the mailing address before sending and mail merging with suggested changes in the template.
Education
B.Tech.(IT) -
Oxford Engineering College, Trichy
01.2010
H.S.C. -
Fatima Matriculation Higher Secondary School, Vridhachalam
01.2006
Skills
- VBA
- C#
- Net MVC
- SQL Server
- MS Access
- SSIS
- SSRS
- Power BI
- HTML
- CSS
- Bootstrap
- JavaScript
- Putty
- WinSCP
Accomplishments
- Best Performer and Star of the Quarter award.
- Appreciated by the top management for several automations.
Timeline
Technical Lead
Societe Generale
01.2020 - Current
Specialist
Contact Center Company
07.2018 - 12.2019
Deputy Manager
Hinduja Global Solution
02.2017 - 06.2018
Executive
Contact Center Company
12.2015 - 01.2017
Developer
RBS Business Corporation Limited
11.2014 - 11.2015
Senior Executive
Cognizant Technology Solution
04.2011
Senior Executive
HSBC Corporation Limited
- 11.2014
B.Tech.(IT) -
Oxford Engineering College, Trichy
H.S.C. -
Fatima Matriculation Higher Secondary School, Vridhachalam
Similar Profiles
Aravind ChagantipatiAravind Chagantipati
Lead SERVICE ANALYST - RESILIENCY MANAGER at Societe Generale Global Solutions Center Pvt Ltd, Bangalore | Bangalore, INDIALead SERVICE ANALYST - RESILIENCY MANAGER at Societe Generale Global Solutions Center Pvt Ltd, Bangalore | Bangalore, INDIA
Vlad-Constantin DorungaVlad-Constantin Dorunga
Small Business Clientele Manager at BRD - Groupe Societe GeneraleSmall Business Clientele Manager at BRD - Groupe Societe Generale
Shadab HyderShadab Hyder
Delivery Manager at Societe Generale Global Solution CenterDelivery Manager at Societe Generale Global Solution Center
Ashly ShajanAshly Shajan
Financial Analyst – Equity/Fixed Income Settlement at Societe Generale Global Solution Centre, BangaloreFinancial Analyst – Equity/Fixed Income Settlement at Societe Generale Global Solution Centre, Bangalore
Herbert Jeffrin MHerbert Jeffrin M
Specialist - Global Funds Control at Bank of New YorkSpecialist - Global Funds Control at Bank of New York