Data Salesforce

*****************@*****.*** +91-728******* 770-***-****

Ravikant Baluni

Technical Competencies

Data Warehousing Software Development Lifecycle

Location Preference: Delhi/NCR Domain Expertise:

Banking & Telecom

Profile Summary Core Competencies

• Enthusiastic Professional with more than 10 years of experience in Sybase/Oracle SQL, PL/SQL development and analysis, design and implementation of business applications using Oracle Relational Database Management System (RDBMS)

• Worked on Data Warehousing & ETL Concepts; worked on data flow diagrams, Data dictionary, database normalization theory techniques, entity relation modeling and logical & physical data modelling design techniques

• Exposure in writing simple & complex SQL, PL/SQL functions & procedures, packages and creation of Oracle Objects such as Tables, Materialized views, Triggers, Cursors, Synonyms, User Defined Data Types, Nested Tables and Collections

• Experience in replicating the Test DB Environment for Sybase DB from Existing DB Server and all related activities such as disk partitioning, creating logical space, creating DB configuration and Dump and Load processes

• Possess Business Intelligence Software implementation knowledge using the tools Oracle BI, Siebel CRM, BI Publisher, Business Objects/ QlikView and worked on Linux & Windows Server connectivity and FTP files from Linux to Windows Server and other external servers.

• Extensive skill to leverage technology for end-to-end development of software products from requirement analysis, system study, designing, coding, testing, documentation to implementation

• Team-based management style coupled with the zeal to motivate peak individual performances for business excellence

• Worked on Performance Tuning, Reading AWR Reports to identify the problematic code and then fine tune to make the Execution Plan better by applying different Tuning techniques. Professional Experience

Landis + Gyr Pvt. Ltd., Noida as Oracle Technical Lead Jun19 - Present IRIS Software, Noida as Senior Technical Consultant May’17 – June’19 HCL Technologies, Bengaluru as Technical Lead Sep’16 – May’17 Wipro Technologies, Bengaluru as Senior Project Engineer Aug’10 – Aug’16 Key Result Areas:

• Setting up all configuration and profile files in Solaris & Linux environment and migrating those scripts/files from Solaris to Linux Box

• Working on stored procedures/functions to extract data from Siebel (SMART) to Salesforce (SFDC) through complete automation process including extraction from SMART to FTP files from Linux to Windows Server

• Participating in new package release and documenting & deploying along with fixing of defects & enhancements of the whole application & deployment of the revised code

• Developing scripts & queries for data extraction & manipulation and fine tuning of stored procedures & packages

• Executing transformation rules for all required fields & data mapping for all fields for each of the object from Siebel to Salesforce

• Writing script to export data from Oracle staging tables to CSV files and import from flat file to Oracle tables and loading data through data loader as a CSV data to Salesforce Data Environment

• Analyzing Dependency on Siebel Data Base and requirement to accomplish the customer needs in minimum time and writing scripts to sync all the environments

• Maintaining data integrity in main tables & code history using Version Controlling Tool (SVN) and archiving data with an automated process

• Liaising with customers to know their decision-making process, understanding data warehousing including stored procedures, querying for data analysis and UNIX Shell scripts while delivering scripts to automate some processes

• Managing Software Development Lifecycle including application planning & delivery, requirement analysis, documentation, coding and maintenance of proposed applications

• Translating business requirements into deployable solutions for functional & non-functional requirements

• Communicating with internal/external clients to determine specific requirements & expectations and managing client expectations as an indicator of quality

• Attending management meetings, client meetings, reporting on overall quality status, escalating issues and conducting post mortem on projects across domains

• Determining operational feasibility by defining the problem, analysing requirements and assessing proposed solutions

• Performance Tuning, reading AWR Reports and Analyzing the Execution Plans to make the query changes to make them more efficient.

• Developing and enhancing existing functionality of the Product being used. Developing and enhancing code written in Oracle and Unix Shell Scripts.

Education

• M.Tech. in Software Engineering

from BITS, Pilani in 2014

• BCA from Graphic Era University

in 2010

Technical Skills

RDBMS: Oracle 9i, 10g, 11g

Server: Linux and Unix

Languages: SQL, PL/SQL, Unix Shell Scripting, Basic of HTML and Java Script Applications/Tools: Oracle BI Publisher, Siebel CRM, SQL Developer, SAP BO Version Control & Build: SVN, VSS, IBM RTC

Creation/Deployment Tools: RLM

Scheduling Tools: Autosys, cron

(Please refer to Annexure for Project Details)

Annexure

Project Title: MDMS Sustenance Period: Jun 19s – Feb 21 Client: Smart Metering Industries Domain: Metering

Team Size: 13

Skills: Oracle, RDBMS - Database Development, Unix Shell Scripting, JIRA, GIT, Gerrit Description: Landis & Gyr provide customers with proven and future-ready energy solutions to realize the full potential of the smart grid industry transformation. Let's work together and shape the future of energy.

Project Title: CITI CGS Period: Jun’17 – Jun 19s Client: Citibank New York Domain: Banking and Finance

Team Size: 30

Skills: Oracle, RDBMS - Database Development

Description: Mainly deals with CIT Employee Database and customer/client deal creation and other transaction activities and application support.

Project Title: DBOI Period: Sep’16 – May’17 Client: Deutsche Bank Domain: Banking Team Size: 20

Skills: Oracle, RDBMS - Database Development

Description: Application Maintenance and Support, System Integration, Product Implementation and Design, Build and Test New Applications.

Project Title: VF-UK (Analytics and Reporting) Period: Sep’14 – Aug’16 Client: Vodafone UK Domain: Communication & Media

Team Size: 12

Skills: Oracle, RDBMS - Database Development, Unix Shell Scripting Description: Vodafone UK, now transformed to Vodafone Global is one of the lead companies in marketing. Work targets around the people, recording their orders for different customers and providing easy access to their day-to-day information and sales.

Project Title: BNYM-WMT-SF-MIGRATION (Siebel to Salesforce Data Migration) Period: Feb’13 – Sep’14 Client: Bank of New York Mellon Domain: Banking and Finance Team Size: 12

Skills: Oracle, RDBMS - Database Development, Unix Shell Scripting Description: BNYM is currently using SMART (Siebel CRM and related functionalities) for its 1500 strong user base for different Sales, Campaign and Marketing activities. BNYM Wealth Management group wants to perform migration of the existing Siebel functionality to Salesforce.com solution platform.

Project Title: CLIENTINSIGHTDEVSUP (Analytics and Reporting) Period: Feb’11 – Jan’13 Client: Citibank, Singapore Domain: Banking and Finance Team Size: 16

Skills: Oracle, RDBMS – Database Development, Unix Shell Scripting, SAP BO and QlikView Description: QlikView, Business Objects provide Robust Clients Analytic Platform to access smart analytics on clients including Client Flow Analysis, Slicing & Dicing, Quick Views on client opportunities (client holdings & interests). This Project consists of QlikView enhancement and business reporting.

Contact this candidate