Pranay Sankepally

Project: Executive Summary Dashboards - Created 25 Executive Summary Dashboards and presented to Chief Information Officer (CIO) and Senior Vice Presidents every week that consists of all Business KPIs(Orders / Activations/ Payments/ Customer Service Cases) and across all countries.

Project: Enterprise Data Discrepancy - Created extensive ETL and Dashboards to compare 40 key customer attributes across all business systems daily to identify data discrepancy between systems. This helped company stabilize and maintain clean and consistent data across all systems and proactively fix lot of process issues and application bugs even before reported by business users and customer escalations.

Project: Feature Adoption and Churn Analysis - Developed Dashboards that trend new feature adoption in emerging markets to provide CIO and Executive Management to understand Return of Investment (ROI) for business features implemented. This helped them to make key decisions in regard to company road map. Reduced 40% customer service calls with data driven insights and help build new features.

• Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
• Migrated numerous legacy systems to newer technologies, reducing costs and enhancing efficiency of computing tasks.
• Architected and involved in large-scale projects and initiatives including, introducing new systems, tools, and processes to support attainment of challenging objectives

• Involved in full Software Development Life Cycle (SDLC) for product development from Requirements gathering directly from Business users, conceptual design, analysis, detail design, development, system testing, and user acceptance and production support.
• Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
• Developed, implemented and maintained data analytics protocols, standards and documentation.
• Responsible for triaging, investigating, and resolving user issues and working on enhancements requested by business teams and for process improvements.
• Designed and Developed mappings in Informatica using different transformations like Source qualifier, XML transformations, Lookup (connected and unconnected), Aggregator, Expressions, Update, Filter, Joiner are mostly used.
• Involved in database design/preparing SQL scripts to support the larger databases that involves terabytes of data.
• Worked on Amazon web services and implemented many IAAS services (EC2, Load Balancer, Elastic search, SNS, S3 Buckets, Route 53 and many more).
• Involved in audit logging and storing the logs in JSON format in Mongo DB
  Used GIT as Source Control Repository.
• Deployed applications in AWS and implemented many IAAS services.
• Used Splunk as a monitoring tool to monitor the logs in both Development and Production environments

• Directed software design and development to meet client needs for functionality and performance.
• Worked closely with clients to establish specifications and system designs.
• Tuned inefficient queries using combinations of index creation, alternate indexing strategies, join strategies and query level optimization hints
• Developed Oracle PL/SQL Stored Procedures.
• Written database scripts to create and update tables in MySQL database.
• Configured and installed PHPv5, Apache and MySQL on Linux (RHEL 7) servers.
• Developed and maintained Linux, Bash and Perl scripts
• Used Drupal and Joomla and involved in development of Content Management Web applications

• Updated old code bases to modern development standards, improving functionality.
• Translated customer requirements into written use cases.
• Utilized Agile / Scrum methodology with daily standup meetings.
• Used Perl and shell scripting to automate the batch process and run SQL scripts.
• Wrote Linux scripts to automate Jenkins jobs and send a notification through email.
• Actively involved in the DevOps streamlining process through Jenkins CI and CA Release Automation.