Murali Nanduri

DW/DBA/Data Architect

510-***-**** ac3b45@r.postjobfree.com

Summary

Experienced in developing,deploying and supporting utilizing a wide range of Databases(OLTP,OLAP,In Memory), enterprise and opensource tools .

Consistently recognized by executive management and clients, called upon to improve organizational effectiveness and efficiency that aligns the business processes and IT infrastructure accelerate performance, and sustain strategic flexibility and scalability.

Demonstrated skills in dynamic and demanding environments, self-driven ability to collaboration between critical business functions.

Technical Skills

AWS :VPC Architecture,Data Services(S3,RDS, Redshft, DMS, DataPipeline), Automation(awscli, python)

OLTP: Oracle, Mysql, PostgreSql, SqlAnywhere, Sybase IQ, SqlServer

IN Memory: SAP HANA, Spark

Automation: Python, Bourne shell, Sql Scripting

Data warehouse: Star schema, data validation, Data migration(Extraction) (Exports/Imports, ETL/ELT, DB Load Utilities), Data Pipelines

HA: Data guard, DB mirroring, Replication

Data Visualization: Tableau, Looker

Data Analysis: Pandas, Excel,R( Intermediate)

Open Soure: Hadoop, Hive, Sqoop, Spark (Sprak Sql),NiFi,Kafka (POC)

Performance Analysis:DB Perfomance ( Query Tuning, Index Validation, Load metrics)

DB Design: Physical, Logical/ER-Modeling),Star Schema

Additional: Feasibility study, Requirement Analysis, Functional Specifications, Technical Presentations and POC, Microservice Architecture, Monitoring,Data Life Cycle Management, Disaster Recovery Documents and Implementation, java, scala, git, confluence, jira, Nagios,

Professional Experience

Credit Sesame Inc

DW/DB performance&Administration (Redshift/Mysql ) June 2017 – present

As a consultant for Product based on credit monitoring and credit improvement,provided end-to-end data platform solution . Workflow consists of extracting data from Mysql OLTP to AWS S3 through ETL and Load data from S3 to Redshift.

Responsibilities include DW Design, Performance analysis, SQL Tuning and develop automation scripts .

Document the best practices,train analysts to tune SQL queries.

Tools Used : AWS (ec2, s3,datapipeline,Redshift,IAM), shell scripts, python Scripts,,awscli

Upgrade Inc Dec 2016 -May 2017

DW Solution Architect

As a solution architect in devops/data services administered and configured Postgres RDS and Redshift. Created Data Pipelines from Multiple Postgres Databases, Ms Sql server to AWS Redshift with AWS Data migration services .Created Foreign data wrappers for data to be available for reporting and analysis. Developed automation scripts in awscli, psql, shell for software deployments. Designed the OLTP(PostgreSQL ) and Redshift physical and logical models for optimal performance confirming to SLA. Gathered and analyzed Postgres logs to identify the queries to tune and developed a high level POC for data ingestion from several sources to kafka, nifi, data lake platform to be consumed by visualization and analysis tools.

Tools Used: AWS,PostgreSql RDS,Redshift,Datapipeline,Data Migration services,Unix scripts,awscli automation scripts

Zed Ventures San Jose Jan 2016 – Oct 2016

Solution Architect

Solution architect for the reporting and Analytics platform, deployed the solution on AWS VPC.

Solution is an integration of SAP ERP, Data services, Business objects SAP RDS(Rapid Deployment Solutions,Predictive Analytics )

Build Big Data Platform ingesting data from JDBC sources, Spreadsheets,Social Feeds to HIVE Data warehouse using sqoop and Python. Deployed spark cluster for in memory processing using SparkSql, Pyspark and Tableau to analyze and build dashboards.

Primary Responsible for AWS architecture for big data platform,Train and manage a team of developers across the world to meet the milestones to deliver the product, and created the confluence pages for runbooks, play books.

Technical presentations, POC and pre sales process

Tools Used: AWS, Databricks,Tableau,Hadoop,Hive,Python,Sql scripts

SAP Labs, Palo Alto, CA May 2012 – Dec 2015

SR DBA/Architect HANA

As SR DBA/Architect managed business Intelligence, Online collaboration products on remise/Cloud.OLTP(Sqlserver,Mysql),EDW(Sybase IQ),OLAP(SAP HANA). Migrated the products to Sybase Sqlanyware from Mysql, Migrate entire stack for datacenter consolidation saving significant resources. Developed tools for the management to analyze the product usage and migration the customers to new platforms. Supported Oracle 11g, SqlServer as secondry and SME HANA Upgraded HANA from SP02 to SP09. Extracted DATA from Oracle Multi-Tenant DB for individual customers on demand basis

Tools &DB Used:HANA,Sybase IQ,Mysql,SqlAnywhere,Hadoop,Oracle,Shell scripts and python(limited)

Lyris Inc., San Jose CA Oct 2011- March 2012

Sr MySQL database Administrator

Managing the day to day operations of the Customer Facing LHQ (hosted/Cloud Based) product on Mysql database. Most of the monitoring is done through Mysql Enterprise monitor and MySQL client tools. As a part of the day to day operations schema modifications, database promotions (manual switch over of replication) and data management. Upgraded all the Mysql instances to 5.1.49 from 5.0. Building infrastructure for Mysql 5.6 QA environment for future upgrade validation.

Performant Corporation, Livermore, CA Sep 2005– Sep 2011

Sr DBA / Architect /Analyst (Oracle 10gR2 RAC,11gR2)

Provide technical direction and leadership to the design, test, and deployment of database environment consisting of ORACLE, MySQL. Configure development and QA environments. Establish data warehousing standards to meet requirements and business needs. Cultivate relationships with key decision-makers through in-depth needs analysis and facilitate effective technical presentations. Translate functional / technical specifications and logical data models into working databases, including relational and dimensional designs.

Work with application developers and other Database Analysts to research, define, and correct application performance issues. Deploy and track database releases as well as document database and application work flow.

PREVIOUS PROFESSIONAL EXPERIENCE

Early career experience includes application programming developing Financial, Marketing, and Inventory modules for clients including Hewlett Packard,Bart, DHL and Teleatlas .Performed as a DBA for Dev/QA environments,

EDUCATION

Master of Science, Mathematics / Statistics Hyderabad Central University Hyderabad, India

Diploma in Computer Applications,Hyderabad Central University,Hyderabad,India

Contact this candidate