Sql Server Data

ARAVIND THATIPAMULA

Sr. Principal Consultant / 402-***-****/ ac1gtd@r.postjobfree.com

https://www.linkedin.com/in/aravind-thatipamula-33b95256

Professional Summary

Microsoft Certified Professional with 12+ years of experience as a Database Developer/ Database Administrator using MS SQL Server 2016/2014/2012/2008R2/2008, 2005 in OLTP/OLAP Data warehousing environments working with various domains such as Education, Retail.

Worked extensively on system analysis, design, development, testing and implementation of projects (SDLC).

Experience developing solutions from business requirements and created technical architectural documents and Functional Documentation.

Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.

Worked on Setting of Infrastructure for Medixsoft/eKohi Products in AWS (Amazon Web Service) Environment.

Experience in core AWS services (S3, EC2, ELB, EBS, Route53, VPC, Auto scaling etc.) and deployment services (Elastic Beanstalk) and security practices (IAM, Cloudwatch and Cloudtrail).

Setting up databases in AWS using RDS, storage using S3 buckets and configuring instance backups to S3 bucket. Used AWS CLI to automate backups of data-stores to S3 buckets, EBS.

Develop and maintain database design documentation, including database diagrams, data mapping documents, data dictionaries, database objects (tables, indexes, etc.), SQL code snippets etc.

Strong experience in MS SQL Server with Business Intelligence in SSAS, SSRS and SSIS of MS SQL Server 2005.

Hands on experience in database development using Stored Procedures, Cursors, Indexes, Views, Triggers (DDL, DML) and User-Defined Functions to facilitate efficient data manipulation and data consistency.

Extensive working experience in using/generating Visual Studio 2005 / 2008 / 2008 R2/ 2012 / 2014 /2016 Client Side Report, SQL Server 2005 SSRS (SQL Server Reporting Service), ad-hoc reports, Crystal Reports, simple and parameterized reports. Development, deployment and Publishing Reports on the Intranet as well.

Hands on experience in creating Parameterized reports and Linked reports with thorough knowledge of report service architecture. (Table, chart and matrix report).

Proficient in writing Queries for generating drill down reports and designing report layout using MS SQL Server Reporting Services (SSRS).Created custom report parts, adding custom logos, custom report name, date and time, page numbers etc using Report Builder 3.0.

Excellent in designing SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc..

Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS. Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduling Packages.

Expertise in Extracting, Transforming and Loading (ETL) data using DTS (Data Transformation Services) and SSIS (SQL Server Integration Services).

Hands on experience in writing SSIS script task /script component using C# for customized data manipulation of SSIS packages.

Experience in SQL Server 2008R2/2012/2014/2016 administration and support, including database installation, configuration, maintenance, refreshing databases, performance tuning, optimization and monitoring. Knowledge on High availability options like Clustering and Log Shipping.

Extensive experience with Database Backups, Recovery Procedures, Backup strategies and scheduling.

Proficient in using tools like SQL Profiler, index Tuning Wizard, Performance Dashboard, Windows Performance Monitor, Database Engine Tuning Advisor for Monitoring and Tuning MS SQL Server Performance.

Experience with Version Control TFS to move the files for different environment (DEV, PPROD, Production).

Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database Consistency Checks using DBCC Utilities.

Knowledge on Reporting tools like Tableau, Power BI and integration Tools like Talend.

Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

PROFESSIONAL EXPERIENCE

San Filipe CISD, Del Rio, TX May 2016 – Till Date

Sr. Principal Consultant / SQL Server DBA & BI Developer

Product-1: eKohi C&I

Description: eKohi C&I Planning Protocol enabling school districts to successfully transition to 100% online resources, making the teacher experience the best in the industry and providing custom C&I coding solutions. eKohi C&I is for teachers/Principals/Parent or Students/Substitute to view/edit their curriculum, planning guides, textbooks, yearly documents, and calendar. Admin has the privilege to upload the documents, edit the documents and view them, they can see all the school’s information, cycle information and audit information & they can filter and sort the data.

Involved in creating the infrastructure for eKohi C& I Product in Windows virtual private colud on AWS (Amazon Web Services) EC2 instance. Created windows 2016 and installing SQL Server 2016 in the same instance. Experience working with AWS services (S3, EC2, ELB, EBS, Route53, VPC, Auto scaling etc.) and deployment services (Elastic Beanstalk) and security practices (IAM, Cloud watch and Cloud trail).

Setting up databases in AWS using RDS, storage using S3 buckets and configuring instance backups to S3 bucket.

Experienced on creating AMI (AWS Machine Images) that utilizes ELB (Elastic Load Balancer) and Auto Scaling.

Experienced with Powershell to work on AWS commands to upload windows files to AWS.

Involved in Database Design and database like creating Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

Used Power Shell to copy the files from Local to AWS server.

Involved in setting up and configuration of SQL Server 2012 on Production Servers environments. Applied patches and service packs to keep the database at current patch level.

Created and maintained various logins and managed security based on the required access.

Involved in Data Administration and Database Design. Used SQL server management studio for Creating Database Objects like Tables, Stored Procedures, Views, Triggers, and functions.

Created Maintenance plans for production and involved in creating application backups files.

Designed and developed all the store procedures for eKohi C& I Product.

Used TFS for maintaining latest copy of stored procedures, functions and technical documentation.

Work as part of a team and provide 24x7 supports when required.

Designed User Friendly Front End Wireframes screens for different Modules like Admin, Substitute Management, and Reports, Report a Bully, My School, My District, My Apps etc.

Product-2: eKohi CMS

Description: eKohi CMS (Content Management System) is based on .NET with Robust Design with SQL Server provides a solid back ground. It was developed using Umbraco content management system.

The architecture is designed for both Scalability and Performance and it has Elastic beanstalk configured webservers automatically scale up and down based on the network traffic. Users can create their content by logging in back-office dashboards where you can create content, media, and workflow, Analytics, Forms and User Management.

Currently hosted eKohi CMS Production Environment in AWS with Elastic beanstalk configured webservers automatically scale up and down based on the network traffic.

Involved in creating the infrastructure for eKohi CMS Product in Windows virtual servers on AWS (Amazon Web Services) EC2 instance. Created windows 2016 and installing SQL Server 2016 in the same instance. Experience working with AWS services (S3, EC2, ELB, EBS, Route53, VPC, Auto scaling etc.) and deployment services (Elastic Beanstalk) and security practices (IAM, Cloud watch and Cloud trail).

Setting up databases in AWS using RDS, storage using S3 buckets and configuring instance backups to S3 bucket.

Excelled on creating AMI (AWS Machine Images) that utilizes ELB (Elastic Load Balancer) and Auto Scaling.

Used Power shell to break single windows file to multiple files to upload to AWS server for installing into multiple windows platform Database as well as Web servers.

Involved in setting up and configuration of SQL Server 2016 on Production Servers environments. Applied patches and service packs to keep the database at current patch level.

Used TFS for moving Application files from Dev to Production. Check-in and check-out the latest copy.

Created and maintained various logins and managed security based on the required access.

Created Maintenance plans for production and involved in creating application backups files.

Designed and developed all the store procedures for eKohi CMS Product.

Work as part of a team and provide 24x7 supports when required.

Product – 3: eSkoolz

Description: Our two new Native Apple iOS and Android Apps are designed with the latest technology Swift and Java to provide versatile and instant way for Staff/Students/Parents to access everything, communicate, tracking, reminders, news, easy-to-use technology.

Product – 4: eBits

Description: eBits is ekohi Bugs and Issue Tracking System. It manages and maintains lists of issues that are needed for medixsoft Products. It’s was developed in PHP with backend PostgreSQL.

Involved in setting up and configuration of PostgreSQL on Production Servers environments.

Project – 1: Medixsoft.com/Ekohi.com

Description: Medixsoft always follow the latest trends, technologies and design patterns that emerge in software industry. These are 2 Company websites that are design on eKohi CMS. ekōhī is a brand which relying on best of breed technologies, our solutions have gained important benefits such as security, reliability, flexibility, scalability, fast time to market, efficient integration and interoperability. This N-Tier architecture has given us the ability to implement solutions that exploit the benefits of various technologies such as:

1. HTTP based solutions providing interoperability and flexibility

2. TCP based solutions with WPF smart clients providing scalability performance and great user experience

Currently it will be hosted in AWS Infrastructure.

Involved in setting up DNS Server (ekohi) and setting up the Active directory.

Created Prodution and Dev/Training Environments in AWS.

Migration of medixsoft and eKohi databases from physical location to AWS.

Configured instance backups to S3 bucket.

Work as part of a team and provide 24x7 supports when required.

Designed User Friendly Front End Wireframes screens.

Created and maintained various logins and managed security based on the required access.

Worked on Microsoft Team Foundation Server for versioning of production documentation reports installs, Software patches etc.

Created Maintenance plans for production and involved in creating application backups files.

Environment: MS SQL Server 2005/2008 R2/2012/2014/2016, T-SQL, SSIS, SSRS, Business Intelligence Development studio, Red gate, Informatica, .Net Framework, ASP.NET, C#, VB, HTML 5, CSS 3, Fusion Charts, XML, JavaScript, WinSCP, MS Visio, Visual Studio 2005/2008/2010/2013/2015, Windows server 2003/2008 R2/2012/2016, TFS, umbraco.

Dallas Independent School District (DISD), TX April 2011 - February 2017

Sr. Principal Consultant / SQL Server DBA & BI Developer

Description: The Project deals with creating reports, creating SSIS packages to support the flow of data for the Chancery Pearson Software databases, Gradespeed, Exceed Special Education System. Upgrading the chancery software and webservers, Analyzing, creating and modifying of cubes for student healthcare system for supporting the student health care system, performing day to day maintenance for database servers, webservers, scheduling and running of jobs etc.

DBA

Providing Services on Requirement gathering, preparing test plans, Development and testing on projects such as Chancery Student Information system, Grade Speed, Exceed Special Education System and supporting other interfaces with many systems such as Food services, Library system, Truancy and so forth.

Worked on Upgrading and Migration of SSIS Packages from SQL Server 2005 to SQL Server 2014.

Involved in Admin activities by creating users & login ids with appropriate roles & grant privileges to users and roles.

Worked in providing solution for business users based on technical and functional information.

Worked with QlikView servers to create dashboards for the management.

Involved in LaserFiche Document Management infrastructure setup. Build the Databases and Web servers.

Develop Customization using chancery built-in-c-Tools Development Tool Kits

Involved in installation and configuration of SQL Server 2008R2 on Production Servers and lower level environments. Applied patches and service packs to keep the database at current patch level.

Manage and resolve performance and availability Issues ln alignment with established SLAs.

Fine-tuned the database objects and server to ensure efficient data retrieve.

Daily monitoring the backups to validate that they were successfully created per process.

Validating Schools related reports in PPROD environment and installing them in production server.

Refreshing Lower level environments from backup copy of production server.

Building servers from the scratch by installing the chancery database and web servers, creating job for refreshing, setting email alerts.

Worked on scheduling the rebuilding indexes every week to ease the performance of Production database server.

Involved in snapshots of the production servers. Implemented high availability on the various servers using replication/mirroring.

Used SQL server management studio for Creating Database Objects.

Take corrective actions based on the issues and/or errors that are found on the servers.

Involved in upgrading and the chancery software databases and web servers.

Involved in Data Administration and Database Design. Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

Used TFS for Version control of DBA Activity Documents like ART Toolkit Software, Ninja scripts and all Chancery software upgradation documentations.

Actively designed the database to fasten certain daily jobs and some stored procedure.

Work as part of a team and provide 24x7 supports when required.

Do general technical trouble shooting and give consultation to development teams.

Performed development support, document reviews, test plan, integration of the system.

SSIS

Analyzing the business requirements and building logical and physical data models.

Develop Extract Transform Load packages to the Chancery Student Information System.

Worked on Upgrading and Migration of SSIS Packages from SQL Server 2005 to SQL Server 2014.

Develop/Maintain interfaces with other systems such as Exceed Special Education System, Library System, Food Services and Operational Data Store.

Creating high level design of the ETL process.

Designing of SSIS Packages to get data files SFTP Server and batch processing of incoming data and purging of old files.

Used C# in Script task to insert or delete the latest file from the folder of SSIS Packages.

Developed SSIS Packages Customized C# logic in SSIS Script task, Script component to customize data transformation purpose.

Involved in creating big multi step SSIS package that are involved in daily loads. Combined all the interfaces into one big package and this package runs nightly basis.

Created SSIS packages to migrate data from different data sources to data warehouse.

Created SSIS packages for different vendor applications like I-station, GTflag, Health Master, LEP, Homeless, Hippy, Euphoria, SpecialED, CareerCrusing, and Test Assessments.

Successfully extracted transformed and load data into data warehouse.

Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.

Created DTS Packages for Exceed Special Education application.

Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Used different control flow and data flow transformation to developed packages.

Performed testing after running the packages by writing T-SQL query.

Used TFS version Control to maintain each SSIS package.

Worked with Pragmatic works BI Express to configure connection strings, Alerts, events and check the schedule jobs activities.

Involved in daily maintenance activities like scheduling and running the SSIS jobs.

SSRS

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.

Wrote complex Stored Procedures and triggers to capture updated and deleted data from OLTP systems.

Involved in discussion of new database creation and migrate object from old database to new development database.

Designed and created Report templates, bar graphs and pie charts based on the student health care system data.

Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008 R2.

Designed reports using MS SQL server Power Pivot-tables, bar-charts, Line-charts and Pie-charts on data from ODS and SQL Server in Excel 2007.

Used TFS version Control to maintain SSRS RDL files for moving DEV to PPROD and PPROD to Production.

Created data driven subscriptions for different users using Report Manager.

Environment: MS SQL Server 2000/2005/2008 R2/2012/2014, T-SQL, DTS, SSIS, SSRS, Report Builder 3.0, Business Intelligence Development studio, Red gate, Informatica, .Net Framework, TFS, ASP.NET, C#, VB, HTML 5, CSS 3, Fusion Charts, XML, JavaScript, WinSCP, MS Visio, Visual Studio 2005/2008/2010/2012, Windows server 2003/2008 R2, SharePoint 2007, Microstrategy, QlikView.

J.B. Poindexter & Co., Inc, TX December 2010 - February 2011

SSRS Developer

Description: J.B. Poindexter & Co., Inc. is a privately held diversified manufacturing company with operating subsidiaries engaged in the production of commercial van bodies, step-vans, funeral coaches, limousines, mid-sized buses, pick-up truck bed enclosures, precision machined components and expandable foam plastics. The Project deals with converting Jet-SQL (MS-Access) to T-SQL and creating reports in SSRS.

Involved in gathering business requirements from clients about the credentials needed to access their servers and management about the table structures that are to be defined.

Converting Jet-SQL to T-SQL according to the client requirement.

Created main Summary tabular report and based on the main report we have sub reports divides into Summary by Customer, Summary Part Number and Summary for Product code.

Worked with Accounting and Finance department and created 55-60 reports like Backlog reports, Inventory report, AP Aging and AR Aging reports, Late Orders Report, On-Time Shipments and Work Orders Reports.

Used Report Builder 3.0 to generate Adhoc reports and created Reports parts like charts, Tablix reports, matrix reports, etc.

Configure and developed report parts in SSRS.

Publishing report parts in Report server to reuse in other reports.

Used SQL server management studio for Creating Database Objects like Tables, Stored Procedures, Views, Triggers and functions.

Generated different types of Reports like Tabular, Matrix, and Charts.

Created Report templates for future reports and added logos, page numbers as needed for client requirement.

Created Report Parts to enable customization and configuration to bring sub charts/widgets.

Created Sub reports and Cross Tab Reports using Report Definition Language (RDL).

Deployed and configured the reports in the Report Server.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Identified and worked with Parameters for parameterized reports in SSRS 2008 R2.

Designed SSRS reports with sub reports, Filters, dynamic sorting, defining data source and subtotals for the report.

Used TFS for version control of SSRS files.

Created stored procedures and user-defined functions for different Reports. Fine tuning of stored procedures to improve the performance.

Involved in Data Administration like creating Login users, refreshing Lower level environments from backup copy of production server, Building developments servers from backup of Production Environment.

Developed the report in Dev System and tested in the quality and moved to the production.

Environment: SQL Server 2000/2005 /2008 R2, Visual Studio 2008, MS Access, TFS, Jet-SQL, T-SQL, Windows 7, Windows 2003 Server, DTS, SSIS MS Office 2000, SSRS.

Sally Beauty Holding Inc., TX November 2009 - November 2010

BI Developer

Description: Sally Beauty holding, Inc. specializes is an international specialty retailer and distributor of professional beauty supplies. The project is mainly involved in reengineering of store procedures to SSIS.

Interacted with users to gather business requirements.

Designed the POS pricing process requires the loading of various input files and processing of these files.

Project involves 3 stages initial loading phase where first stage involves data is loaded from flat files to temporary tables, in the second stage data is flowing through temp tables to staging and in final stage data is moved to main tables Prod roles, Promotions and product.

Create ETL process to move data from AS400 to SQL Server using SSIS.

Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.

Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them.

Created C# Script for Data Flow task to fetch data from server and load it into database through Script component.

Used Red gate SQL Compare to create a report and SQL change script with schema differences between production, development and testing servers.

Used Red gate SQL Data Compare to generate a script with data differences between production servers.

Involved in usage of various SSIS components like for loop, Foreachloop, Derived column, sql execution task, Variables, and Error Handling etc.

Extensively worked with SSIS (ETL) tool suite; designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Aggregator, Multicast and Derived Column.

Designed ETL packages for extracting the data and load into the appropriate tables in the database using SQL Server Integration Services (SSIS).

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them.

Transformed the logical data model into the physical data model.

Used various transforms in SSIS to load data from flat file to the MS SQL database.

Created error handling for all the control flows.

Involved in design and analysis of underlying database schema, altering and creation of the table structure.

Created test scenarios for the application which involves in three stages.

Documented the technical specifications and test scenarios for the project.

Environment: MS SQL Server 2008/2008 R2, T-SQL, SSIS Business Intelligence Development studio, Red gate, .Net Framework, VB Script, TFS, MS Visio, Visual Studio 05, Visual source safe, Windows server 2008 R2.

Grede Foundries, WI July 2008-November 2009

ETL Developer

Description: Grede Foundries, Inc. specializes in ferrous metals: gray iron, ductile iron, stainless steel, and specialty iron castings. The project mainly involved in creating new databases, Performance tuning, creating, deploying and scheduling reports.

Interacted with users to gather business requirements.

Designing the logical and physical architecture for database.

Installed and Configured SQL Server 2005. Upgraded the existing database to SQL Server 2005.

Data conversion from SQL 2000 to SQL 2005.

Involved in creation of database objects like schemas, logins, tables, clustered and non-clustered indexes, views, functions and stored procedures. Created SQL scripts for tuning and scheduling. Working with development team to optimize application specific database operations and implement security restrictions.

Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).

Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).

Created Drill Down reports using Microsoft SQL Server Reporting Services (SSRS).

Enhanced reports by the charts and graphs using Microsoft SQL Server Reporting Services (SSRS).

Worked on report viewer control to embed the reports on to the applications using Visual Studio.

Worked on Drill through Report links and Hyperlinks to jump to other reports and web pages using Microsoft SQL Server Reporting Services (SSRS).

Worked on Common Table Expression which uses rank function to calculate the ranking of the current mold back log to previous year mold backlog.

Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.

Involved in usage of various SSIS components like for loop, Foreachloop, Derived column, sql execution task, Variables, and Error Handling etc.

Designed ETL packages for extracting the data and load into the appropriate tables in the database using SQL Server Integration Services (ETL).

Created the automated processes for the activities such as database backup processes using the Integration Services.

Scheduled jobs to run the DTS Packages/ SSIS packages on daily basis using SQL Server Agent.

Wrote complex stored procedures and user defined functions for the reports using T-SQL.

Created SSIS Packages to migrate the data from database to flat files

Respond to and resolve database access and performance issues.

Setting up alerting system by using performance counters for monitoring system performance.

Environment: MS SQL Server 2000/2005/2008, T-SQL, SSIS, SSAS, SSRS, Business Intelligence Development studio, VB.Net, .Net Framework, XML, TFS, MS Visio, Windows 2003, Visual Studio 05

Electronic Corporation of India Limited, India August 2005 – December 2006

SQL Developer

Worked as a developer in creating complex Stored Procedures, cursors, tables, and views and other SQL joins and statements for applications.

Wrote complex stored procedures to process patient records pertaining to dosage, condition and other demographic factors such as age, sex, ethnicity, etc.

Designed and implemented Stored Procedures and Triggers for automating tasks.

Implemented Constraints, Rules, Defaults, User defined data types and Indexes on tables.

Resolved deadlocks issues with the Databases/Servers on a real-time basis.

Used Joins and Union concept for extracting data from multiple tables.

Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Creating and Maintaining DTS Packages, BCP and resolved issues with data imports.

Performed performance tuning using performance monitor and maintained database.

Environment: MS SQL Server 2000, DTS, Enterprise Manager, Query Analyzer, T-SQL, Windows 2000 Server.

TECHNICAL SKILLS

Databases

MS-SQL Server 2000,2005, 2008,2008R2,2012, 2014,2016 Microsoft Access, MongoDB, PostgreSQL

Programming Languages

TSQL, Java, ASP.Net, C#.Net, HTML.

IDE Tools

Visual Studio .Net 2005/2008,2010,2013,2015

Framework

Microsoft .Net Framework 2.0/3.0/3.5/4.0,4.5

Data Modeling

Erwin, MS Visio

ETL Tools

SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Talend

Reporting Tools

SQL Server Reporting Services (SSRS), Report Builder 3.0, Crystal Reports, Qlik View, Tableau, Power BI

SQL Server Tools

SQL Server Management Studio, SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export(DTS), performance point server 2007.

Operating System

Windows Server 2003/2008/2008R2/2012/2016, Windows 2000 Advanced Server/Professional, Windows NT, Windows 7/10/XP Professional /Standard

Other Tools

Laserfiche, Pragmatic works BI Express

EDUCATION

Master’s in Industrial Technology at Texas A & M University- Commerce – 2007

Bachelor’s in Mechanical Engineering at JNTU, Hyderabad - 2005

Contact this candidate