Feb 2019 – Apr 2020 · 1 yr 2 mos · Malmö, Skåne County, Sweden

• Working as a Senior Developer in R&D team for Sandvine contracted by SiriAB, I am involved in software development of in-house data storage. I am also providing consultation and support to customers for their data warehousing solutions.

Sep 2017 – Feb 2019 · 1 yr 5 mos · Bangalore

• (Heritage HPE)
• Provided Big Data Consulting and Data Analytics Services to Purdue University(USA), NCELL(Kathmandu), Privalia-Ventee Privee(Spain), Intrum Justitia(Sweden), Guess(USA), IndusTowers(India) over the last two years.
• Helped customers improve existing Datawarehousing Solution or Deploy New one.
• Have also provided training services and mentored the Client teams to deliver Optimal Results.
• Database Administration, Development and Architect.
• An Expert in Data Modelling, Vertica Database Administration and Development, provided consulting services to various firms to deploy new solution and improve existing solutions.
• Good at Hadoop and MongoDB Database Administration, provided engineering support to production clusters.
• Deployed 2 9 nodes Hadoop Cluster using Ambari. Designed the Architecture and used Spark, Scala for Development.
• Good at MySQL Database Administration and Development.
• BI and Reporting
• Skilled in Pentaho ETL Design and Development.
• Posses good skills in Tableau Dashboard Designing.
• Development
• Good at Scala, used to contribute towards development of PSTL tool.
• Expert in UNIX shell scripting, have written over 100 scripts to assist ETL jobs, automate DBA tasks.
• Good at Python Scripting, developed projects to automate tasks for the Clients.
• Data Analytics and Visualization
• Used Python(Computer Vision) libraries for Image Analysis. Adept at developing machine learning models using Python.
• Expert in R, having developed machine learning models for developing good predictive models.
• Worked on Data Cleansing/Munging using Python to make available data fit for Data Analytics.

Jan 2017 – Sep 2017 · 8 mos · Bengaluru Area, India

• Using Analytics to drive growth for Customers.
• As a Big Data Consultant (Vertica and Pentaho)
• . Worked at Client Location(Kathmandu,Nepal) under tight deadline on identifying and documenting each issue, preparing plan for remediation for all aspects.
• . Lead the team to deliver the plan in a systematic manner to achieve the performance benchmarks and data sanity standards set by the clients.
• . Worked with the Sales team to propose new solutions to further remediate and improve existing application.
• Worked as a Vertica and MongoDB, DBA and Developer, and helped resolve major performance issue in the Client Datawarehouse.
• Helped client achieve DR in their Datawarehouse and established a Data Backup policy.
• Guided the Client team to adhere to best practises while developing queries so as to improve the overall performance.
• Worked with 3rd party consultant to improve various configuration Parameters related to Kafka to reduce the data bottleneck.

May 2016 – Dec 2016 · 7 mos · Thiruvananthapuram Area, India

• As a Vertica DBA and Developer,
• . Designed a new data model
• . Deployed a multi-node cluster on AWS
• . Created DB objects
• . Migrated data from MySQL to Vertica
• Worked with the Client(AIMIA) to Develop models for Consumer Analytics.
• Worked as a MySQL DBA and Developer.
• Good at Pentaho ETL Design and Development.
• Developed shell and python scripts for Monitoring Performance and Daily Maintenance Activity.
• Managed the team to deliver project on schedule.

May 2013 – May 2016 · 3 yrs

• Database Administration, Development and Architect.
• Adept in SQL Server Database Administration (2008, 2012), MySQL Database Administration and Development with experience in diverse projects.
• An Expert in MongoDB Database Administration and Good at MongoDB Development.
• Good at Hadoop Database Administration, having deployed a Hadoop Clusters in Production and Pre-Production environment.
• BI and Reporting
• Skilled in SQL Server Reporting and Integration Services, developed Complex ETLs to simplify the data processing and transformation pipelines.
• Tuned about 40 SSRS Reports via Code Optimization, Application Design Improvements, and Database Design Changes to reduce the average runtime from 90 minutes to 7 minutes.
• Development-Scripting
• Wrote Shell and Python scripts to automate Deployment of MongoDB Database in a Clustered Environment and also for log checking and cleaning activities.
• Good at Python Scripting, wrote few functional scripts to perform Data Cleansing and Simple job automation.
• Data Analytics and Visualization
• Worked on Data Cleansing/Munging using Python and Perl to make available data fit for Data Analytics.
• Created various Linear and Logistic Regression models to improve the prediction of key data points for the business.
• Operating Systems
• Posses extensive experience on various UNIX based Operating System.
• Posses extensive experience on Windows Server Operating System 2008, 2012.

Aug 2010 – May 2013 · 2 yrs 9 mos

• Database Administration, Development and Architect.
• An Expert in Oracle Database Administration (9i, 10g, 11g), Design and Development having worked on separate projects of varying complexities for AT&T Client.
• Good at MySQL and PostgreSQL Database Administration and Development.
• BI and Reporting
• Used Informatica 8.6 to modify and improve about 10 complex ETL jobs.
• Used Crystal Reports to generate value driven BI reports.
• Development-Scripting
• Expert in UNIX shell scripting, have written over 50 scripts to automate DBA tasks ranging from simple to complex ones.
• Good at Perl Scripting, designed and deployed a project to automate the Production Code Deployment Exercise in Perl and Shell Scripts. Reduced the time taken from 8 hours to 1 hour and Support personnel required from about 6 to 2.
• Good at Python Scripting, wrote few functional scripts to perform Data Cleansing and Simple job automation.
• Data Analytics and Visualization
• Good at R Programming. Built an interactive project in R to ingest data from csv files and plot resource strength in various Firm location in India.
• This visual tool aids the leads in allocating the resources within a city or between closest location thus improving resource planning and saving costs in the process.
• Operating Systems
• Posses extensive experience on UNIX based Operating System; RHEL, CentOS, Linux, Sun Solaris, Ubuntu, HP-UX, AIX.