Smita Singh
Navi Mumbai
Summary
- Working professional with over 7+ years of experience in the IT industry and 1 year in bank as IT Manager.
- Presently working as a CRM operations and marketing manager with key responsibility to interact with clients to understand their business requirements, prepare functional and technical documentation.
- Provide insights using visualization reports and dashboard on the ROI using reporting tools such as PowerBI.
- Also the project manages the CRM operations for leads, appointment and service (query, request, complaint and dispute) management solution.
- Overall experience in SAP CRM, Neocase HR, and UiPath RPA solution. For the reporting and data visualizing tools used PowerBI and MSBI (SSIS, SSAS and SSRS suite).
Overview
9
9
years of professional experience
Work History
Manager, Projects
IDBI Bank
08.2023 - Current
- As part of Customer relationship Management (CRM) team, worked on planning, designing and scheduled phases for large projects.
- Providing CRM platform/solution for leads, appointments, and opportunity management across bank.
- As bank's marketing solution, executed campaigns for different verticals and provided ROI for campaigns.
- Created and executed outbound demand generation campaigns, calls and emails to deliver qualified leads for sales team.
- Analyzed and reported on KPIs to validate and demonstrate success of marketing campaigns using PowerBI.
- Developed creative presentations, trend reports, kitted assets, and product data sheets.
- For omni channel integrations of lead management, coordinated with different applications stakeholders and developer for integration.
- CRM being also used as service management application for bank, to create QRCD(Query, request, complaint and dispute) management tool. Had experience in integration of branch and omnichannel to CRM for QRCD creation and tracking.
- Also part of procurement and onboarding of new CRM solution, such preparing RFP and BOM, meetings with bidders and senior officials to onboarding.
Business Analyst, RPA Consultant
Easy DIY Pvt. Ltd. (Secondment to Novel Conseil – France)
08.2021 - Current
- Being part of small team, worked on pre-sales documentation of tool such as proposal documents, project planning, project and resource cost estimation.
- Post approval, conducted workshops to understand client requirements, build solution documents, follow up with clients for sign off and deploy solution taking care of timeline
- Secondly, I have also worked on few UiPath projects using UiPath studio and orchestrator to develop bots
- Received certification on advanced UiPath RPA developer v1.0 in Feb 2022.
- Performed gap analysis procedures and detailed data reviews to optimize implementation.
Business Analyst, BI Developer
Capgemini India Pvt. Ltd.
12.2016 - 08.2021
- Experience in SQLSERVER 2016 and MSBI applications such as (SSIS, SSAS & mostly on SSRS)
- Have worked on Tabular (DAX scripting) and Multidimensional (MDX scripting) cube models
- Create SSIS packages to extract HR data post-integration and create OLAP cubes to be analyzed using PowerBI and SQL server report builder
- Created PowerBI dashboard from multiple sources
- Designed, developed, and deployed SSRS reports including paginated reports, highly graphical/charting report outputs, mobile reports, KPIs, data-driven subscriptions, and alerting mechanisms
- Experience working in Agile Methodologies from development process perspective
- Critical thinking, proactive impact analysis, and work attitude has built good relationship with clients
- Worked on business process automation on HR solutions (i.e., Hire to retire)
- Provided technical support for troubleshooting analytics and reporting issues.
- Created dashboards to monitor and track key performance indicators.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Identified patterns and trends in large data sets and provided actionable insights.
UI Developer
Infosys SEZ Campus
05.2015 - 09.2016
- Experience in developing front-end UI web pages using HTML5, CSS3, and JavaScript
- Delivered responsive, cross-browser compatible, and accessibility-compliant webpages.
- Hands-on experience in debugging application using tools provided by Visual Studio 2012.
- UI project provided client with creating notes and scheduling meetings with customer, which is stored in database and fetched in JQGrid.
Education
Bachelor of Technology (B.Tech) - Electronics And Telecommunication Engineering
Institute of Technical Education And Research
Bhubaneswar, Odisha (S’O’A Deemed University)05.2015
Skills
- Data Analysis and dashboard: Power BI, SQL server reporting services (SSRS), Excel analytics
- Integration services : SSIS and SAP API management, webservices
- Database and warehouse: SQL server 2016, Teradata
- ETL and OLAP : MSBI (SSIS, SSAS, SSRS)
- Project planning and management :Microsoft Office365 suite (Visio, planner, Sharepoint) and Jira
- Robotic Process Automation : UIPath (Certified) and orchestrator
- Contract and procurement Management
- UI development : HTML, CSS and Vanilla Javascript
- Testing tools : Selenium and RPA - UIPath
Accomplishments
- Certified UiPath advanced RPA developer v1.0 (UiARD) issued on 02/21/2022
- Received online certification on ‘Agile meets design thinking’ from the University of Virginia & ‘Agile software development’ from the University of Minnesota.
- Had a few onsite travels for project design workshops to Europe – France in 2017 & Czech Republic in 2020
Personal Information
- Age: 31 Years
- Father's Name: Late Pabitra Mohan Singh
- Date of Birth: 02/27/1993
- Marital Status: Married
Disclaimer
I hereby declare that all information provided above is correct to the best of my knowledge.
Timeline
Manager, Projects
IDBI Bank
08.2023 - Current
Business Analyst, RPA Consultant
Easy DIY Pvt. Ltd. (Secondment to Novel Conseil – France)
08.2021 - Current
Business Analyst, BI Developer
Capgemini India Pvt. Ltd.
12.2016 - 08.2021
UI Developer
Infosys SEZ Campus
05.2015 - 09.2016
Bachelor of Technology (B.Tech) - Electronics And Telecommunication Engineering
Institute of Technical Education And Research
Similar Profiles
MOHD. ATIK KHANMOHD. ATIK KHAN
Business-development-executive at IDBI BankBusiness-development-executive at IDBI Bank
Navya MittalNavya Mittal
Intern at IDBI BankIntern at IDBI Bank
Ram Prasad PatiRam Prasad Pati
Manager – HR at IDBI BankManager – HR at IDBI Bank