Summary
Overview
Work History
Education
Skills
Work Availability
Timeline
Babysitter

Ravikiran G

Springfield,IL

Summary

Proactive ETL Developer with 10 years carefully handling and transforming data loads to suit customer needs. Versed in all dominant information modeling designs and mapping technologies. Dedicated to flawless ETL integrity and impeccable data security during all database maintenance and modification tasks. History of mining, warehousing and analyzing data at the company-wide level. Knowledgeable about the principles and implementation of machine and deep learning. Results-oriented and proactive with top-notch skills in project management and communication. Talented business intelligence professional bringing advanced understanding successful strategies for identifying, protecting and capitalizing on data assets. Constructs new systems to answer complex business needs. Highly-motivated employee with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills. Hardworking employee with customer service, multitasking and time management abilities. Devoted to giving every customer a positive and memorable experience.

Overview

12
12
years of professional experience

Work History

ETL Developer

Social Security Adminstration
Gwynn Oak, MD
07.2021 - Current
  • Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
  • Created SQL Server Integration Services packages for incremental and full loads of data from various sources.
  • Configured SSIS package variables, parameters and expressions for dynamic package execution.
  • Designed and developed stored procedures, functions, views and triggers using T-SQL for efficient data transformation.
  • Monitored performance of the ETL processes by creating log files with SSIS logging features.
  • Involved in creating database objects such as tables, views, indexes based on business requirements.
  • Resolved complex issues related to ETL process through debugging existing code or writing new programs.
  • Maintained source system metadata information in order to ensure accuracy of the ETL process.
  • Evaluated source systems data quality and identified opportunities for improvement.
  • Analyzed large volumes of data to determine trends and patterns that can be used to improve business processes.
  • Implemented best practices while developing ETL packages like error handling, logging.
  • Performed unit testing of all the mappings developed in the ETL layer before delivering it to production environment.
  • Developed scripts for automating daily jobs like backups, reindexing.
  • Provided technical support to other team members regarding ETL development activities.
  • Participated in code reviews with other developers providing feedback on design techniques used in programming tasks.
  • Worked closely with Business Analysts, System Analysts, Data Architects in gathering requirements for developing ETL solutions.
  • Assisted BI Developers in building cubes utilizing extracted transformed data from Data Warehouse.
  • Worked as part of project teams to coordinate database development and determine project scopes and limitations.
  • Created and implemented complex business intelligence solutions.
  • Collected, outlined and refined requirements, led design processes and oversaw project progress.

ETL/MSBI Developer

Comcast
Mount Laurel, NJ
08.2020 - 06.2021
  • Implemented ETL processes to extract, transform and load data from multiple sources into the Data Warehouse.
  • Developed stored procedures, user defined functions, views and triggers using T-SQL for data manipulation.
  • Designed SSIS packages for incremental loads of data from various sources such as flat files, excel files and databases.
  • Created SSAS Cubes, Dimensions and Measures with MDX query language for better understanding of data.
  • Configured SSRS reports by creating report models, parameterized reports and linked reports.
  • Tuned SQL queries to improve performance of the overall system by optimizing indexes on tables in database.
  • Monitored ETL jobs running on a daily basis ensuring all jobs ran successfully without any errors or delays.
  • Migrated existing DTS packages to new versions of SQL Server using Migration Wizard tool in SSIS.
  • Built complex custom solutions leveraging Microsoft BI tools like PowerBI and Azure Analysis Services.
  • Coordinated with different teams for gathering requirements related to Business Intelligence projects.
  • Participated in design sessions with stakeholders to understand business needs and develop BI solutions accordingly.
  • Worked extensively on developing Tableau dashboards along with their respective datasets and calculations.
  • Assisted in troubleshooting issues related to ETL processes while also providing technical support during production deployments.
  • Provided expertise in areas like Performance Tuning, Query Optimization, Indexing Strategies and Database Design principles.
  • Engaged in unit testing activities at every stage of software development life cycle ensuring quality delivery.
  • Created complex SQL queries and database objects to pull and manage data.
  • Engaged with business users to gather, define and document reporting requirements.
  • Developed, tested and deployed standard reports and dashboards based on business requirement document specifications.
  • Documented requirements through functional specifications and technical design documents.
  • Updated tracking documents, generated different reports and gave presentations on findings.
  • Created and oversaw dashboards with Power BI.
  • Conceived, developed and implemented wide range of BI solutions.
  • Reviewed and improved performance of SQL server.
  • Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.
  • Wrote user manuals and other documentation for roll-out in customer training sessions.
  • Employed integrated development environments (IDEs).
  • Obtained and evaluated information on hardware configuration costs, reporting requirements and security needs.

ETL/BI Developer

Golden Gate University
San Francisco, CA
05.2019 - 06.2020
  • Developed data models and ETL processes to extract, transform, and load data from various sources into the BI platform.
  • Designed and implemented dashboards using Power BI to provide interactive visualizations of business data.
  • Collaborated with stakeholders to identify key performance indicators for reporting purposes.
  • Created reports, scorecards, and KPIs in Microsoft PowerBI to measure business performance metrics.
  • Configured databases, cubes, and queries for optimal performance in the BI environment.
  • Performed data analysis tasks to uncover trends and insights from large datasets.
  • Optimized existing SQL queries for better performance when running against large datasets.
  • Integrated new systems with legacy applications using APIs or web services as needed.
  • Provided technical support for users experiencing issues with the BI platform or toolsets.
  • Monitored system health and proactively identified potential problems before they arise.
  • Maintained documentation on all aspects of the BI environment including data models, ETL processes.
  • Researched new technologies that can be leveraged within the BI environment to improve efficiency.
  • Analyzed user requirements and designed solutions that meet their needs while adhering to industry standards.
  • Built OLAP cubes using SSAS for advanced analytics capabilities.
  • Optimized data gathering processes, analysis procedures and visualization strategies.
  • Updated tracking documents, generated different reports and gave presentations on findings.
  • Conceived, developed and implemented wide range of BI solutions.
  • Documented requirements through functional specifications and technical design documents.
  • Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
  • Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.
  • Coordinated testing and validation procedures through software development lifecycle.
  • Devised automation, backup and recovery protocols to preserve and safeguard data.
  • Identified opportunities for process improvements to decrease in support calls.

SQL BI Developer

State Farm
Bloomington, IL
07.2017 - 04.2019
  • Created SSIS packages to extract, transform and load data from multiple sources into the Data Warehouse.
  • Working on Migration of SSIS 2008 packages to SSIS 2012.
  • Developed and implemented data warehouse models for various reporting requirements using SQL Server 2008, 2012, 2014.

● Installing and Configuring SQL Servers Analysis service on cluster environment.

● Involved generating reports like profit & loss statement and balance sheet statement for client.

● Identified and defined Key Performance Indicators (KPIs) in SSAS.

● Troubleshooting failed jobs daily and fix them.

● Proactively monitoring and identifying the problem queries and missing indexes.

● Working with Application Teams and third-party vendors to setup a new database environment for the new apps.

● Working on Built and wrote, calculated members.

● Developed custom reports and distributed Reports in multiple formats.

● Working on linked dimensions.

● Extracting data from .txt files and importing into SQL Server monthly once using import/export Wizard.

● Resolving problem/incident tickets based on their priority and working with end users to get them resolved as quickly as possible.

● Responsible for planning Database backup strategy and Disaster Recovery procedures.

● Built and wrote MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server Analysis Services Business Intelligence (SSAS, SSRS).

● Troubleshooting CPU bottlenecks and Memory bottlenecks

Data Analyst

Cisco
San Jose, CA
03.2016 - 06.2017

· Monitor the Database for duplicate records. Merge the duplicate records and ensure that the information is associated with company records.

· Standardize company names, addresses, and ensure that necessary data fields are populated.

· Review the database proactively t3identify inconsistencies in the data, conduct research using internal and external sources to determine information is accurate.

· Resolve the data issues by following up with the end user.

· Coordinate activities and workflow with other data Stewards in the firm to ensure data changes are done effectively and efficiently.

· Extract the data from database and provide data analysis using SQL to the business user based on the requirements. Create pivots and charts in excel sheet to report data in the format requested

· Used VBA for excel to automate the data entry forms to help standardize data

· Assist CRM Analyst with Email Marketing Campaigns, including Client Publications, Newsletters, and announcements.

· Assist other data Stewards with Data Change Management (DCM) Inbox in resolving various tickets created by the User Change Request in Interaction Database.

· Developed and Created Logical and Physical Database Architecture using ERWIN.

· Designed STARSchemas for the detailed data Marts and plan Data Marts involving Shared Dimensions.

· Coordinated with different users in UATprocess.

· Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.

· Ensured the feasibility of the logical and physical design models.

· Conducted the required GAPanalysis between their AS-IS submission process and TO-BEEncounter Data Submission Process.

SQL Developer

Thirdware Solutions
Mumbai, India
11.2013 - 11.2014
  • Optimized existing queries for better performance using SQL query tuning techniques.
  • Designed complex reports using SQL Server Reporting Services.
  • Implemented data migration from legacy systems to new databases.
  • Performed backup and recovery of databases on a regular basis.
  • Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
  • Analyzed business requirements and translated them into logical data models.
  • Configured high availability solutions such as clustering, log shipping and replication for mission critical applications.
  • Tested changes to ensure that the system works correctly after implementation.
  • Resolved customer service requests related to database errors or performance issues quickly and efficiently.
  • Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
  • Integrated multiple data sources into one unified view using views or joins in SQL queries.
  • Generated ad hoc reports upon request from stakeholders utilizing Microsoft Excel Pivot Tables or Access Queries.
  • Conducted unit testing of all database objects before deploying them into production environment.
  • Tested databases and performed bug fixes.
  • Designed and created database systems after reviewing end user's requirements.
  • Prepared documentation for database applications
  • Performed root cause analysis to identify system issues.
  • Designed code to help company develop necessary applications and websites.
  • Entered important data into computer programs with minimal errors to streamline workflow.
  • Implemented debugging programs to determine vulnerabilities and issues in software.

Data Warehouse Consultant

Seasons Healthcare Limited
Hyde, India
06.2012 - 09.2013

· Configured the project on WebSphere 6.1 application servers.

· Deployed GUI pages by using JSP, JSTL, HTML, DHTML, XHTML, CSS, JavaScript, and AJAX.

· Communicated with other Health Care info by using Web Services with the help of SOAP, WSDLJAX-RPC.

· Implemented the online application by using CoreJava, Jdbc, JSP, Servletsand EJB1.1, WebServices, SOAP, WSDL.

· Used SAXand DOMparsers to parse the raw XML documents.

· Used Singleton, factory design pattern, DAO Design Patterns based on the application requirements

· Preparing and executing Unit test cases.

· Used RADas Development IDE for web applications.

· Involved in fixing bugs and minor enhancements for the front-end modules.

· Used Log4Jlogging framework to write Log messages with various levels.

· Doing functional and technical reviews.

· Implemented MicrosoftVisioand RationalRosefor designing the Use Case Diagrams, Class model, Sequence diagrams, and Activity diagrams for SDLC process of the application.

· Guaranteeing quality in the deliverables.

· Maintenance in the testing team for System testing/Integration/UAT.

· Conducted Design reviews and Technical reviews with other project stakeholders.

· Implemented the project in Linux environment.

· Created test plan documents for all back-end database modules.

Education

Master of Science - Computer And Information Systems Security

Stratford University
Falls Church, VA
03-2016

Bachelor of Science - Computer Science And Engineering

JNTUH
Hyderabad
06-2012

Skills

  • Python Programming
  • Data Modeling
  • Data Validation
  • Data Warehousing
  • Data Quality Management
  • Data Migration
  • Business Intelligence
  • Data Security
  • Database Design
  • Performance Tuning
  • Data Mapping
  • Scripting Languages
  • Technical Support
  • Multitasking
  • Database Development
  • Problem-Solving
  • SQL and Databases
  • Data Mining
  • Analytical Skills
  • Warehouse Models
  • XML Web Services
  • Report Generation
  • RDBMS
  • SQL Programming
  • Database Model Conversion

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

ETL Developer

Social Security Adminstration
07.2021 - Current

ETL/MSBI Developer

Comcast
08.2020 - 06.2021

ETL/BI Developer

Golden Gate University
05.2019 - 06.2020

SQL BI Developer

State Farm
07.2017 - 04.2019

Data Analyst

Cisco
03.2016 - 06.2017

SQL Developer

Thirdware Solutions
11.2013 - 11.2014

Data Warehouse Consultant

Seasons Healthcare Limited
06.2012 - 09.2013

Master of Science - Computer And Information Systems Security

Stratford University

Bachelor of Science - Computer Science And Engineering

JNTUH
Ravikiran G