Data Python

BABU DAKSHNAMURTHY

**** ******** ****

Lone Tree, CO 80124

720-***-**** *****************@*****.***

Professional Summary

Overall 14.5 years of IT experience with full software development life-cycle, agile methodology, architecting scalable platforms, object oriented programming and database design.

Highly qualified MongoDB DBA and MS SQL/BI consultant with over 6 years of experience in designing replica sets, multi-shared cluster, installation, migration, designing, backup, recovery, scripting and performance tuning in development, test and production database.

Experience in upgrading and migrating various versions of Mongo database on different platforms and provide solutions related to the migration to MongoDB.

Experience in Mongo utilities (mongostat, mongotop, mongoperf, mongodump and mongorestore) and participate in scalability testing to ensure MongoDB high performance.

Optimizes system operation, SSL encryption, analysis of data usage for proper index creation, data modeling, performance, resource utilization and participate in system capacity analysis and planning.

Assists in designing, building, deploying and maintaining MongoDB databases and involved in the daily activities of configuration and system administration associated with non-production environments.

Resolves issues regarding patches and impact analysis and application issue resolution with developers, business analysts and end users to provide system administration support.

Good experience on advanced queries, query conditionals and aggregation frameworks.

Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working.

Experience with Requests, Numpy, Scipy, Matplotlib, and Pandas python libraries during development lifecycle.

Skills set Highlights

MongoDB 4.0 – database installation, configuration, user creation & maintenance, database backup & recovery, database performance tuning and optimization.

MongoDB Compass – interact with data, ad-hoc queries, CRUD functionality, reporting, decisions about indexing, document validation

MongoDB Atlas - migrating MongoDB replica set to Atlas, building cluster, comprehensive monitoring and customizable alerts.

Database: MongoDB, MS-SQL, Oracle, Sybase Database

BI application: SSIS/SSRS

Language: Python, C, C++, VB, JavaScript

Change management tools: TFS (Team Foundation Server), GitHub & VSS

Data analysis\Libraries: NumPy, Panda, SciPy

IDLE’s: PyCharm, Eclipse, PyDev

Middleware: Soap web services

Operating System: Windows, Unix, Linux, Mac OS X.

MS Office: Excel, PowerPoint, MS Project, Visio and Sharepoint.

Project task/defect tracking tool: Nimsoft, ALM, Quality center, Service-now

IBM AS400: RPGLE, RPG/400, CL/400, COBOL.

Healthcare product (Trizetto): Facets 5.4, FET (Facets Enrollment Toolkit), TCS (Trizetto Communication System)

Software Courses/Certification completed through Cognizant Academy:

No

Name of Institution/Certification

Diploma or Certificate

Year of Completion

1

ITIL External certification

Certificate

2014

2

Scrum Master External certification

Certificate

2014

Professional Experience

Employer: Cognizant Technology Solutions

Mongo DBA - Englewood, CO (Apr 2016 – Present)

Client: Emblem Health Inc., USA

Roles and Responsibilities:

Designed, Installed and configured a multi node MongoDB sharded cluster and replica sets on Linux and Windows platforms right from Dev, Stage and Production environments.

Responsible for administration, maintenance, Performance analysis, and Capacity planning for Mongodb clusters.

Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point of view according to the business criteria.

Supported Bulk Write operation jobs and analyzing the queries and performed tuning based on environment.

Built index on secondary’s to minimize the impact of building an index on replica set, potentially long running index building operations performed by creating Index in background.

Configured Role-Based Access Control with custom roles and privileges and running MongoDB with secure configuration options.

Understanding Aggregation pipeline operations have an optimization phase which attempts to reshape the pipeline for improved performance.

Tracing connections to the Mongo database and monitoring utilization of resources for each process.

Using MongoDB Compass, view the real time server statistics, key server metrics and database operations and understand the most active collections.

Migrated multiple shards from MMAPV1 storage engine to Wiredtiger. Implemented MMS monitoring and backup solution for sharded clusters.

Consulted with the operations team on deploying, migrating data, monitoring, analyzing, and tuning MongoDB applications.

Optimizes system operation, performance, and resource utilization and participate in system capacity analysis and planning

Wrote and executed various MYSQL database queries from python using Python-MySQL connector and MySQL dB package.

Prepared several analytical reports comprised of different data modeling techniques such as time series analysis, financial modeling, and trend mapping

Employer: Cognizant Technology Solutions

Database Admin – Chennai, India (June 2012 – Mar 2016)

Client: BCBS-NJ (Horizon), USA

Roles and Responsibilities:

Responsible for setting up effective monitoring for alerts and capacity analysis. Also, tuning the database environment to insure optimal performance and resource utilization

Write and maintain scripts in support of database maintenance to ensure consistent performance. Maintain solid working knowledge of functionality of existing platforms and future enhancements

Provide 24 x 7 on call support as part of a scheduled rotation with other team members

Responsible for creating, maintaining and updating documentation necessary to support the database operations by the DBA team

Coordinate with vendors to assure the continuing functionality of NoSQL as regards upgrades, versions, services packs, new releases

Provide advanced troubleshooting for applications and systems and advanced technical support for database related project activities

Responsible for installation and configuration of databases in clusters and setup & maintain replication for active/active solutions between data centers

Responsible for configuring backup / restore utilities and developing disaster recovery policies and procedures

Responsible for recommending database solutions to recognized problems and for design and implementation of new Oracle databases

Function as the technical liaison between System Administrators and DBA teams. Provide mentoring to fellow administrators

Wrote scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also wrote UNIX scripts to process batch jobs.

Involved in the change control process and Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.

Employer: Cognizant Technology Solutions

SQL Developer – Columbia, MD (June 2007 – May 2012)

Client: United HealthCare, USA

Roles and Responsibilities:

Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.

Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.

Understanding business requirements and provide suggestions to client on the functional requirements that makes their business process highly productive.

Provide accurate estimations on the projects based on functional requirement using complexity point estimation. We use Cognizant proprietary tool named to E-tracker to achieve accurate Order of Magnitude estimations.

Reviewed the Technical design specifications sent by offshore to make sure Design meets specific functional requirements. We use cognizant proprietary tool named to E-tracker to log any defects on design.

Prepared the System Integration Test cases and execute the test cases. I also perform UAT walk through with client.

Database engineering is based on SDLC pattern. Involved all the steps like requirement analysis, Design, Development and Testing and then deployment.

Performed the code deployment and post deployment monitoring by reviewing the implementation notice received from offshore and deploy the code in production. We also perform post deployment monitoring until system stabilizes in production.

Provided the production support on the business areas like case install, claims processing, provider relations and accounting.

Monitoring and Troubleshooting SQL Server using windows system monitor, creating an alert in windows system monitor, SQL server performance alerts.

Developed SSIS Templates which can be used to develop SSIS packages such a way that they can be dynamically deployed in Dev, Test and Production environments.

Employer: Cognizant Technology Solutions

Programmer Analyst– Chennai, India (April 2005 – May 2007)

Client: United HealthCare, USA

Created database, tables, security and backup database along with stored procedures, triggers, user permissions, pass through queries and temporary tables.

Responsible for studying and analyzing the change request or Enhancement Projects and provide estimation.

Responsible for preparing the Detail Design and the technical specifications for the new requirements and change request raised by the client.

Conducted Code review, Testing & Delivery, Organizing peer reviews, Unit testing and timely delivery to Onsite. Involved in interacting with the onsite team to get clarifications and requirements for the functionality, integration testing and implementation support.

Designed and created backend data access modules using PL/SQL stored procedures and Oracle.

Generate Daily, Weekly and Monthly Trigger based reports regarding assigned projects to appropriate Managers and Clients.

Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.

Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle DB to SQL server.

Responsible for ongoing maintenance and change management to existing reports and optimize report performance.

Created ad-hoc reports using report builder and report modules using BI Development studio to provide a template for end users to create report by themselves with a preselected group of relational tables.

Education Details

Specialization

College\University

Score

Year of Passing (mm/yyyy)

Bachelor of Engineering (ECE)

Govt. College of Engineering, Bargur

75%

04/2005

Higher Secondary School

St Joseph’s higher secondary school, Cuddalore

88%

05/2000

Tenth standard

St Joseph’s higher secondary school, Cuddalore

80%

05/1998

Contact this candidate