Summary
Overview
Work History
Education
Skills
Timeline
Generic

RAVI POLINENI

Aurora,IL

Summary

Over 12 years of professional experience in client requirement Analysis, Physical and Logical design, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2017/2014/2012/2008/2005. 8+ years of experience in Data warehousing and Business Intelligence using ETL/OLAP tools to provide Business Intelligence solutions using SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Data Transformation Services (DTS). 4+ years of experience in cloud technologies AWS and GCP. Extensive Experience and in-depth working knowledge in various SQL Server tools and business intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, Database Engine tuning Advisor, Query Analyzer. Extensive experience in all aspects of system development life cycle (SDLC) such as requirement analysis, design, development, testing, implementation, deployment & maintenance of projects. Experience with database migration from SQL server 2005 to SQL server 2008 / SQL server 2008 to SQL Server 2012 / SQL server 2012 to SQL Server 2014. Experience with full life-cycle from large data set migration to data warehouse loading production, data analysis, cleaning, scrubbing, manipulation, data extraction for reporting, and data management. Solid understanding of RDBMS database concepts including Normalization and solid experience in creating database objects such as tables, views, stored procedures, triggers, cursors, functions, indexes and other T-SQL (DDL, DML) statements for various applications. Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views. Experience with high availability systems (100+GB databases), hundreds of databases in a highly transactional environment with proper Data Archive and Purge processes. Knowledge in SQL Server Clustering, Replication, Data Mirroring, Space Management, Linked Servers and Log Shipping. Regarded for the ability to deliver outstanding customer service with respect to all support and post project, post migration issue resolution. Intuitive person with outstanding analytical skills required for delivering cutting edge BI Solutions. Experience in developing different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS). Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SQL Server Reporting Services (SSRS). Strong ability in defining query for generating drill down reports, handling parameterized reports, linked reports, sub reports and creating stylish report layouts in SQL Server Reporting Services (SSRS). Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report formatting, Report distribution, Report subscriptions, Report delivery and Report security. Expert in Creating, Configuring and tuning ETL workflows designed in SSIS Solid experience on Extraction Transformation and Loading (ETL) processes using tools like SSIS, DTS, BCP and Bulk Insert between different homogeneous/heterogeneous systems. Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages and maintaining Error logging using Exceptional Handling in T-SQL and SSIS. Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using (SSRS). Good experience in Dimensional modeling using Star Schema/Snowflake modeling concepts and Kimball/Inman strategies. Experience with Physical & logical data modeling using All-Fusion Erwin Data Modeler. Extensive experience in writing MDX Scripting and MDX Queries. Hands on experience with Testing Life Cycle (Component testing, Unit testing, System/Integration testing and User acceptance testing etc.) Experience in migrating existing databases from on premise to AWS Redshift using various AWS services. Involved in designing and deploying applications using AWS services like EC2, S3, RDS, Dynamo DB, SNS, SQS, IAM focusing on high availability, fault tolerance and auto-scaling in AWS Cloud formation. Experienced in Automating, Configuring and deploying instances on AWS and familiar with EC2, Cloud watch, Cloud Formation. Worked on CI/CD pipeline for code deployment using tools like Git, Jenkins, Code Pipeline in the process of development and Production deployment. Experience in working on version controller tool GitHub. Experienced in migrating legacy applications/database to AWS cloud ecosystem using Services like VPC, EC2, S3, RDS for Compute, Big Data Analytics and Storage. Worked on multiple projects and possess strong skills in Application Enhancements, Performance Tuning and Production Support and highly experienced in converting data from legacy systems and flat files. Excellent communication skills, both oral and written and pleasing interpersonal skills.

Overview

18
18
years of professional experience

Work History

Sr. Data Engineer/ Cloud Migration Lead

Redbox
07.2017 - Current
  • Involved in Software Development Life Cycle including gathering Requirements, Analysis, Design, Implementation, Testing and Maintenance
  • Implementation and documentation of best practices, assessment of new tools and technologies
  • Design detailed Migration Plans for Workloads from SQL Server platform to AWS
  • Created well architected application on AWS using Auto scaling, SQS, SNS, Caching and database layer as necessary
  • Built S3 buckets and managed policies for to use them for storage and backup on AWS
  • Develop AWS centralized logging solutions for security teams to consolidate AWS logs and analyze them using ElasticSearch and CloudWatch Services
  • Gathered Semi structured data from S3 and relational structured data from RDS and keeping data sets into centralized metadata Catalog using AWS GLUE and extract the datasets and load them into Redshift
  • Performance tuning the tables in Redshift
  • Worked on various data normalization jobs for new data ingested into Redshift
  • Designed tables and columns in Redshift for data distribution across data nodes in the cluster keeping columnar database design considerations
  • Wrote Redshift UDFs and Lambda functions using Python for custom data transformation and ETL
  • Used AWS Redshift, S3, Spectrum and Athena services to query large amount data stored on S3 to create a Virtual Data Lake without having to go through ETL process
  • Loaded data from different sources to Redshift using python in AWS Lambdas
  • Experience in automating the build and deployment of scalable projects through Gitlab CI/ CD, Jenkins, etc
  • Used python scripts for data validations and designed validations modules
  • Integrated services like GitLab, Jenkins and Spinnaker to create a deployment pipeline
  • Worked on Jira for tracking defects, issues logging and documented work process using Confluence
  • Work in Agile methodology to design, develop, test, implement, and support technical solutions across a full stack of development tools and technologies
  • Involved in bug finding and fixing in production environment
  • Support development initiatives by working with application design and development teams to reach optimal data design, quality, and integration patterns
  • Support development of ad-hoc and canned reports to support business initiatives and objectives
  • Took responsibility of individual projects and ensured timely completion without data quality issues
  • Environment: SQL Server 2017/2014, Windows 10, Visual Studio 2013, SSDT, Team Foundation Server, Jira, Tableau, Power BI, Confluence, GitLab, AWS, GCP, Jenkins, S3, Kinesis, Firehose, Lambda, Glue, Aurora, Redshift, Quicksight, Snowflake, Athena, Python.

Sr. BI Developer/ Fortification Lead

Accenture
12.2016 - 06.2017
  • Owns and drive the Interface fortification process, and on-going support of Enterprise Batch Integration and associated ETL processes
  • Worked with Accenture owned tool Integration Migration Tool (IMT) to upload and deploy SSIS packages along with configurations
  • Took responsibility of individual projects and ensured timely completion without data quality issues
  • Worked with multiple application teams across world to provide quality services for clients
  • Responsible for requirements gathering, status reporting, creating various metrics, project deliverables
  • Migrating Databases from SQL Server 2008 to SQL Server 2014
  • Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, Teradata and flat files
  • Involved in migration of packages from SSIS 2008 to SSIS 2013 environment
  • Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL/SSIS mapping processes and maintained the mapping documents
  • Reviewed and fine-tuned stored procedures and triggers before production migration
  • Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects
  • Built efficient ETL packages with SSIS to fetch, cleanse and transform data from various types of sources
  • Develop package configurations dynamically as well as populating variables dynamically
  • Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for ETL
  • Written complex SQL statements using joins, sub queries, correlated sub queries and CTE
  • Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases
  • Experience in configuring and deploying SSRS reports on BI portal share point server
  • Hands on SSIS, SSAS development and production support of many data marts and the Enterprise Data Warehouse, Meta data and Universe creation for reporting
  • Experience in creating Tablix Reports, Matrix Reports, charts, Parameterized Reports, Sub reports using SSRS
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts
  • Worked on-call rotation to support the production environment
  • Coordinating with offshore team and leading the onsite team
  • Environment: SQL Server 2008/2014/2016, ORACLE, EXCEL, HTML, XML, Windows 07, ASP.NET, C#, VB.NET, Power Shell, Visual Studio 2013, BIDS, SSDT, Team Foundation Server, Power BI, Service now and IMT.

Sr. BI Developer/ Production Support Lead

McDonald’s
04.2016 - 11.2016
  • Owns and drive the technical design, development, and on-going support of Enterprise Data Warehouse and associated ETL processes
  • Lead the Production Support Team, dealt with business users
  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems
  • Created new database objects like tables, views, indexes, stored procedures, user defined functions and triggers on user databases in SQL Server 2014
  • Support the ongoing data quality and data integrity initiatives through the creation and expansion of audit, balance, and control procedures, alerts and reports
  • Generated and managed reports using SQL Server 2008 Reporting Services (SSRS) and deployed on to report manager
  • Worked on all types of reports like tables, matrix, charts, sub reports etc
  • Designed and developed SSIS Packages to import and export data from MS Excel, Flat files, XML, Oracle and SQL Server 2014
  • Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services 2014
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages
  • Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table
  • Involved in ETL architecture enhancements to increase the performance using query optimizer
  • Worked on migrating packages from SSIS 2008/2012 to SSIS 2014, deploying the packages across Dev/UAT/Prod environments
  • Managing historical data from various heterogeneous data sources
  • Wrote T-SQL queries, Store Procedures and used them to build packages to maintain the history of the data
  • Worked on incidents created on service now application to resolve the issues in production
  • Monitoring SQL Agent jobs, Incoming files and outgoing files on daily basis
  • Assist with resolving data anomalies and data quality issues
  • Involved in creating reports, dash boards to track incident aging in Service café application
  • Assist with writing and maintaining project documentation, including but not limited to formal requirements, design documents and test plans
  • Environment: SQL Server 2012/2014, SQL Server Master Data Services, ORACLE, EXCEL, HTML, XML, Windows 07, ASP.NET, C#, VB.NET, Visual Studio 2010/2013, BIDS, SSDT, Master Data Management (MDM), Team Foundation Server, Tableau, Power BI, Service now.

Sr. BI Developer

Redbox
10.2010 - 03.2016
  • Designed Facts and Dimensions for providing summarized and aggregate views of large database sets
  • Implemented strategies to keep up with their rapidly growing business
  • Participating in Requirement gathering meetings with stakeholders and the System Analysts
  • Creating a Solution with the DEV architect to the requirements from the business stake holders
  • Build centralization of customer data for both customer profiles of online customers and Accounts of kiosk users
  • Played key role in several other optimization projects and achieved scalability of rapidly growing data in Financial and Marketing data marts
  • Heavily involved in architecture and designed meetings to provide solutions for valued projects
  • Involved in design and implementation of data warehouse
  • Instrumental in creating process, procedures, policies and standards for data warehouse implementation
  • Heavily involved in design of Customer Master Project which identifies unique customers based on email, credit card and household address etc
  • Developed process with complex logic to build customer master tables and load the tables with SSIS packages
  • Participated in business meetings to help marketing team to generate their campaigns for promotions
  • Provide data for kiosk loads, removals and smartly deployment for operations team
  • Developed tables and structures to load customer engagement metrics
  • Build process for customer segmentation based on the customer engagement metrics
  • Experience in providing competitive solutions to help marketing team identify the trends and adopt optimal marketing approaches
  • Worked with external vendors to implement a Campaign Management tool that would allow the Marketing team to send multiple campaigns in the most effective manner
  • Experience in providing scrubbing data for marketing and S&A teams to do analysis
  • Worked on migration of low performing pending revenue reports
  • Worked with business analysts for the design of summary tables for efficient Report Design
  • Responsible for creating different kind of reports based on business user requirements
  • Created packages with Error handling and different methods of logging in SSIS
  • Monitored and modified Performance using execution plans and index tuning
  • Extensive use of C# code in reports and C#.NET in SSIS packages
  • Build reports from Cube using MDX scripting
  • Created many Adhocs for Finance, Inventory, and Loss prevention and Marketing teams
  • Designed and develop SSIS packages to Extract transform and load data from various data sources into SQL server
  • Developed full and incremental feeds for Email Service Provider
  • Worked on weekly and monthly data feeds for studios
  • Developed transaction, customer and many other feeds for third party analyzing vendors
  • Build process to consume incoming feeds from email and text vendors to get customer data back
  • Worked on file transfer like flat and excel files from vendors on FTP site through cozy roc SFTP component
  • Designed historical tables in data warehouse with SSIS slowly changing transformation
  • Heavily worked on Email and Text vendor migration projects
  • Experience in Query Optimization and performance tuning of stored procedures, functions etc
  • Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent
  • Developed cube from scratch through Microsoft Sql Server Analysis Service
  • Created new Named calculations and named on SSAS cubes using MDX
  • Added new Dimensions in the cube and pulled these new columns in to reports
  • Created MDX script to full process and data process of SSAS cube
  • Deployed Cubes to the production server
  • Created SSIS Packages to Export data to tables from SSAS Cubes using MDX Queries and Tasks in SSIS Packages
  • Created Tabular Views from the views in SQL Server data base
  • Involved in creating dashboards by extracting data from different sources using Tableau
  • Created dashboard using parameters, sets, groups and calculations
  • Involved in creating data blending in case of merging different sources and creating a dual axis bar chart with multiple measures
  • Giving production support for job failures after hours and worked with DBA to fix the failures
  • Helped the Testing team to set up their QA environments and helped them in testing process
  • Build database queries and test cases for the testing team to test the reports
  • Worked with the business and development teams to write test scenarios along with acceptance criteria that would be utilized by the QA team
  • Working with the Database Administrators and evaluating the SQL Server job failures after Deployments to Production
  • Worked with Mingle an Agile tool to create Epic, Feature and Story cards to facilitate the movement of work from Analysis to Deployment
  • Worked closely with the Product and other teams to conduct Sprint Planning Sessions meeting with the teams to determine velocity to ensure better planning
  • Worked closely with team members to bring them up to speed on agile methodology
  • Extensively worked with TFS to keep track of all changes made in the SSRS, SSIS and database projects
  • Migrated projects from source control Vault to Team Foundation Server
  • Environment: SQL Server 2008/2012/2014,MS Access, Query/Report Studio, Power shell, ORACLE, EXCEL, HTML, XML, Windows 07, ASP.NET, C#, VB.NET, Visual Studio2008/2010/2013, BIDS, SSDT, Team Foundation Server, Cozy Roc, Red Gate, Tableau, Power BI.

SSRS/SSIS Developer

HP Enterprise Services
01.2010 - 09.2010
  • Involved in User Requirement Gathering and Technical Specification Documentation
  • Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics
  • Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indexes and functions for databases
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
  • Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS)
  • Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server
  • Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube
  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task
  • Used various SSIS tasks such as Conditional Split, Derived Column which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
  • Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
  • Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks using SSIS
  • Catalogue data file into the Visual source safe (VSS) to be ready to be transmitted to the client machines
  • Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager
  • Environment: SQL Server 2005/2008, MS Access, Query/Report Studio, Power shell, ORACLE, EXCEL, VBScript, HTML, XML, Windows Server 2000/2003, ASP.NET, C#, VB.NET, BIDS.

SQL Server Developer

Indus Network Ltd
05.2005 - 12.2007
  • Created complex Stored Procedures, Triggers, Cursors, Tables, Views, SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic
  • Designed and analyzed the SQL Server database and involved in gathering the user requirements
  • Logical and Physical design of database for project on basis of user requirements
  • Performed data conversions from flat files into a normalized database structure
  • Coordinated with the front-end developer to put in the business rules
  • Created procedure to check some of the rules at the backend at the time of entering data
  • Involved in the Data modeling, Physical and Logical Design of Database
  • Involved in Query optimization and performance tuning
  • Written triggers and stored procedures and optimizing it
  • Running DBCC consistency checks, fixing data corruption in application databases
  • Analyzed long running, slow queries and tuned the same to optimize application and system performance
  • Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.

Education

B.Tech - Computer Science Engineering

JNT University

Masters - Computer Science

Herguan University

Skills

  • TECHNICAL SKILLS
  • Languages
  • C, C, VBNet, C#Net, Java, T-SQL, PL-SQL, Python
  • DBMS
  • MS-Access, MS SQL Server 2017, 2014, 2012, 2008, 2005, Master Data Services, Oracle, Redshift, Snowflake, Aurora, Dynamo DB
  • SQL Server Tools
  • Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SSAS
  • Web Technologies
  • HTML, XML
  • Data Modeling Tool
  • ERWIN, Visio
  • Operating System
  • Windows 95/98/2000/XP/NT/VISTA/7/10, Power Shell MS Dos, Unix and Linux
  • Tools
  • Microsoft Visual Studio 2005/2008/2010/2013, MS Office, BIDS 2008/2005, SSDT Tools, Accenture IMT
  • Cloud Technologies

Timeline

Sr. Data Engineer/ Cloud Migration Lead

Redbox
07.2017 - Current

Sr. BI Developer/ Fortification Lead

Accenture
12.2016 - 06.2017

Sr. BI Developer/ Production Support Lead

McDonald’s
04.2016 - 11.2016

Sr. BI Developer

Redbox
10.2010 - 03.2016

SSRS/SSIS Developer

HP Enterprise Services
01.2010 - 09.2010

SQL Server Developer

Indus Network Ltd
05.2005 - 12.2007

B.Tech - Computer Science Engineering

JNT University

Masters - Computer Science

Herguan University

Similar Profiles

CREATE PROFILE
RAVI POLINENI