Chandana Akula
NC
Summary
Database Engineer with over 9 years of IT experience in development, analysis, design, Testing, presentation and implementation using SQL Server 2016/2012/2008R2/2008. Experience in Banking / Financials/ Mortgages/Healthcare sectors as a Database Engineer that includes Database Design and Development using SQL Server 2016/2012/2008R2/2008. Expertise in all areas of SQL Server including OLTP, OLAP, T-SQL, Stored procedures, query optimization, performance tuning and providing database security by creating users, permissions, and role-based access to data. In-depth experience of Transact-SQL (DDL, DML, DCL), Designing and Normalization techniques on the database tables. Experience in using SSIS for data extraction, transformation and loading (ETL) and in using SSIS tools like Import and Export Wizard, Package installation, SSIS package designer. Experience with CI/CD tools like Jenkins (Management, Job configuration Management and CI/CD pipeline creating/Management). Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder. Expert in MS Office Suite (Word, Excel, Outlook, Project, PowerPoint, and Visio) Good ability to quickly grasp and master new concepts and technologies.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Sr. Systems Analyst
Health Care Service Corporation (HCSC)
10.2019 - Current
- Company Overview: Health Care Service Corporation is a not-for-profit corporation health insurance company in the United States
- Health Care Service Corporation is the licensee of the Blue Cross and Blue Shield Association for 5 states
- It concentrates its operations in Illinois, Montana, New Mexico, Oklahoma, and Texas
- Involve in requirements gathering/analysis meetings with Client and provide description about the analysis and approach
- Involve in Data modeling and creation of Database objects like Tables, PKs, FKs and referential Integrity Constraints
- Created a GIT project structure for database changes and implemented release process for database changes
- Implemented Jenkins build pipeline for different applications like java and nodejs
- Wrote Jenkins automation for database changes using liquibase cli
- Create tables in relational database model with referential integrity constraints
- Develop SQL stored procedure that generates a XML file with information from various HR transaction tables
- Design and develop SSIS to do incremental load in Change Data Capture (CDC) fashion in SCD type 2 and Developed dynamic SQL program that performs CDC and SCD type 2 based on the metadata of any table using Merge statements
- Create complex ETL Packages to import CSV/Excel files with more than 200 columns and different file layouts to SQL Server database
- Design and develop rich Graphic Visualizations using Tableau reporting tool
- Create, monitor and maintain jobs using Sql Server Agent
- Involve in Migration of SQL server from 2012 to 2016 including database and SSIS package and performed data comparison and validations
- Active involvement in Go-live activities
- Work on Microsoft Team Foundation Server (TFS) as Code repository tool
- Health Care Service Corporation is a not-for-profit corporation health insurance company in the United States
- Health Care Service Corporation is the licensee of the Blue Cross and Blue Shield Association for 5 states
- It concentrates its operations in Illinois, Montana, New Mexico, Oklahoma, and Texas
- Environment: Microsoft SQL Server 2012/2016, Microsoft Team Foundation Server 2017, Microsoft SQL Server Reporting Services 2012/2016, Tableau 10.4, Tableau Sever, IBM DB2, SSIS-2012, Jenkins
Sr. Database Developer
Iowa VR
04.2019 - 09.2019
- Company Overview: Iowa VR is an employment program for individuals who experience a disability
- Focuses on service delivery that assists individuals to prepare for, obtain, retain, and advance in employment
- Developing and maintaining T-SQL code and using SSRS to design and create new reports and maintain existing reports
- Involved in database schema changes and additions will be necessary to satisfy the business rule requirements
- Responsible for implementing and maintaining commercial ETL application(s)
- Worked on creating dependencies of activities in Azure Data factory
- Creating Stored Procedure and Scheduled them in Azure Environment
- Testing all approved changes before user acceptance testing
- Participate in requirement meetings with business teams to understand and collect requirements
- Iowa VR is an employment program for individuals who experience a disability
- Focuses on service delivery that assists individuals to prepare for, obtain, retain, and advance in employment
- Environment: Microsoft SQL Server 2016, Microsoft Team Foundation Server 2017, Microsoft SQL Server Reporting Services 2016, Azure Data Factory Version1 (GA) and Azure Data Factory Version2 (In Preview), SSIS, Microsoft SharePoint 2010
Credit Portfolio Consultant
Wells Fargo & Company
08.2018 - 03.2019
- Company Overview: Wells Fargo & Company is the world's second-largest bank by market capitalization and the fourth largest bank in the US by total assets
- Quantitative analytics using SQL/SAS to analyze data from a variety of sources to develop, recommend and implement account management strategies
- Provide insights to senior leadership regarding ongoing program performance
- Partner with cross functional teams and internal stakeholders, including Product, Marketing, Finance, Operations, and Execution/Implementation
- Maintain on-going processes and data updates to ensure data integrity, accuracy and timeliness
- Lead/support ad-hoc business analytics as needed
- Support audit and customer-escalation related inquiries
- Developed SSIS packages that can extract data from various sources and merge into one only source for Power BI reports
- Created notifications and alerts, subscriptions to reports in the Power BI service
- Wells Fargo & Company is the world's second-largest bank by market capitalization and the fourth largest bank in the US by total assets
- Environment: MS SQL Server2008/2012, SAS/EG, SQL Server Reporting Services, Visual Studio 2012, Windows XP, T-SQL, HP ALM, Power BI
Database Engineer
Chicago Public Schools
12.2017 - 07.2018
- Company Overview: Chicago Public Schools is overseeing 660 schools, including 484 elementary schools and 176 high schools
- The district serves over 396,000 students
- Maintain and manage the existing CPS Enterprise Data Warehouse and ODS builds
- Model extensions to the existing Data Warehouse
- Builds ETL components according to ETL specifications
- Code must address performance, dependency, auditing, error handling and data quality issues
- Create Dashboard pages and metrics within CPS custom dashboard solution
- Responsible for data integrity as well as the quality of data within Dashboard presentation layer
- Support system and user acceptance testing activities, including issue resolution
- Complete technical documentation to ensure system is fully documented
- Chicago Public Schools is overseeing 660 schools, including 484 elementary schools and 176 high schools
- The district serves over 396,000 students
- Environment: MS SQL Server2008/2012, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2012, Windows XP, T-SQL, CPS custom dashboard
BI Developer
Ascension Information Services
03.2017 - 11.2017
- Company Overview: As the largest non-profit health system in the U.S
- Ascension’s Healthcare Division operates 2,500 sites of care, while its Solutions Division provides a variety of services and solutions including physician practice management, venture capital investing, investment management, biomedical engineering, facilities management, clinical care management, information services, risk management, and contracting through Ascension’s own group purchasing organization
- Worked with Business Analysts in gathering requirements and translating them to technical specifications
- Used Sub queries, joins, CTE’s and Analytical functions for data retrieval
- Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
- Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables
- Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012/2008
- Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transforms
- Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS)
- Experience in ETL Data Warehouse environment
- Created Jobs in SSIS and was responsible for ETL job scheduled to run daily
- Solved the issues associated with ETL Data Warehouse Failure
- Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements
- Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report
- Created Tableau Dashboards using show me functionality
- Converted existing reports to tableau dashboards
- As the largest non-profit health system in the U.S
- Ascension’s Healthcare Division operates 2,500 sites of care, while its Solutions Division provides a variety of services and solutions including physician practice management, venture capital investing, investment management, biomedical engineering, facilities management, clinical care management, information services, risk management, and contracting through Ascension’s own group purchasing organization
- Environment: MS SQL Server2008/2012, MySQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2005, Windows XP, T-SQL, Tableau Desktop 9.1.1
Data Analyst
Lifespan Corporation
02.2016 - 02.2017
- Company Overview: Lifespan is a not-for-profit organization
- Lifespan's present partners also include Rhode Island Hospital's pediatric division, Hasbro Children's Hospital, Bradley Hospital and Newport Hospital
- Worked closely with Business Analysts and Application Developers to produce all required documentation
- Create functional and technical specifications for projects
- Involved in gathering and analysis of user requirements
- Create documentation as required
- Migrating Sources from Mainframes to SQL Server
- Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
- Used various tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column
- Involved in ETL architecture enhancements to increase the performance using query optimizer
- Implemented Event Handlers and Error Handling in SSIS packages
- Created automated reports using SSRS (SQL Server Reporting Services)
- Develop Database Queries required to accomplish the application development
- Lifespan is a not-for-profit organization
- Lifespan's present partners also include Rhode Island Hospital's pediatric division, Hasbro Children's Hospital, Bradley Hospital and Newport Hospital
- Environment: MS SQL Server 2012/2008R2, SSIS-2012, SSRS, Visual Studio 2012, MS Office 2010/2013, VISIO 2010, SQL Query Analyzer
Database Developer
Farm Credit Services of America
05.2015 - 01.2016
- Company Overview: Farm Credit Services of America, a customer-owned financial cooperative, finances farmers and ranchers in Iowa, Nebraska, South Dakota and Wyoming
- Creating Multiple Data Sets in Azure worked in migration of SQL Server 2008R2 to SQL Server 2016
- Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data
- Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity
- Maintained the security, integrity and availability of SQL Server
- Performed data extraction and migration activities for populating test (or non-production) and customer databases
- Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications
- Farm Credit Services of America, a customer-owned financial cooperative, finances farmers and ranchers in Iowa, Nebraska, South Dakota and Wyoming
- Environment: MS SQL Server 2016/2008R2, SSIS-2012, SSRS, Visual Studio 2012, Red Gate, Agent Ransack, VS 2008, PowerShell Scripting, Azure Data Bases
SQL/SSIS Developer
First Bank
12.2014 - 04.2015
- Company Overview: First Banks, Inc
- And its subsidiaries and affiliates offer a vast portfolio of products and services for both individuals and businesses
- Developed stored procedures, advanced queries, User Defined Functions (UFD), Triggers, Indexes, Views, SQL joins to implement business rules
- Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports
- Developed SSIS Packages to load daily changes of Org Hierarchy data into Flat Files using various Transformation Tasks
- Automated ETL Data loads and established efficient ways of Error Handling in SSIS
- Implemented Event Handlers, Package Configurations, Logging, System and User-defined Variables, and Expressions for SSIS Packages
- Provided production support for the ETL jobs and also to the code deployment into QA & production environment
- Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services
- Highly proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform drill down, drill-through operations in SSRS
- First Banks, Inc
- And its subsidiaries and affiliates offer a vast portfolio of products and services for both individuals and businesses
- Environment: MS SQL Server 2012/2008R2, SSIS-2008R2, OLAP, OLTP, SSRS-2008R2, VS 2008
Database Engineer
Quicken Loans
06.2013 - 11.2014
- Company Overview: Quicken Loans is a Mortgage company and America’s biggest online
- The project mainly involves maintaining databases
- Worked closely with development, QA and architecture teams
- Responsible for physical database design and implementing performance tuning
- Assist writing complex stored procedures
- Enhance database applications in an ever changing environment
- Perform code and design reviews
- Meet with management to ensure satisfaction with the data collection, presentation, and other efforts
- Developed and implemented ETL processes using SSIS for data conversion from multiple data sources of legacy system data to target database schema
- Provided logging and data auditing for packages to show number of records process and data errors
- Create SSIS packages to deploy packages between development, testing and production
- Developed various operational Drill-through and Drill-down reports using SSRS
- Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports
- Quicken Loans is a Mortgage company and America’s biggest online
- The project mainly involves maintaining databases
- Environment: MS SQL Server 2008, MS SQL Server 2005, SSIS-2008, SSRS-2008, Visual Studio 2008, Rapid SQL 7.7.1, Toad, Share point 2010
SQL Developer
Bealls
06.2012 - 05.2013
- Company Overview: Bealls is a departmental store and this corporation, through its subsidiaries, operates over 530 retail store sites across the southern and eastern United States
- Involved in gathering Business requirements, building up a solution to implement business logic
- Involved in verification of data for accuracy and also validating the data after BRD changes are made in the code
- Closely worked with QA team to verify the results moved to test servers from development servers
- Created sub-reports, Drill-down reports, summary reports and Parameterized reports in SSRS
- Wrote stored procedures and functions for automations in processing and loading data into tables
- Created Open queries, stored procedures, Dynamic SQL Procedures, Triggers and Views in T-SQL
- Responsible for defining Check constraints, business rules, tuning data, indexes, and queries
- Bealls is a departmental store and this corporation, through its subsidiaries, operates over 530 retail store sites across the southern and eastern United States
- Environment: MS SQL Server 2008, SSRS-2008, Visual Studio 2008, Microsoft office share point portal server 2003, Red gate
Education
Master of Science - Computer Science
Troy University
05.2012
Bachelors - Computer Science
JNTU
Hyderabad, Andhra Pradesh05.2010
Skills
- RDBMS
- MS SQL Server 2016
- MS SQL Server 2012
- MS SQL Server 2008R2
- MS SQL Server 2008
- Azure SQL Server
- C
- C#
- Net
- SAS
- Python
- Business Intelligence Development studio (BIDS)
- ETL
- Visual Studio
- Team Foundation Server (TFS)
- Rapid SQL
- Informatica
- Tableau
- MS Word
- MS Visio
- MS Outlook
- MS Excel
- MS Access
- SQL Server Management Studio
- Enterprise Manager
- Query Analyzer
- Profiler Export & Import (DTS)
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- SQL Server Analysis Services (SSAS)
- Windows 2010
- Windows 2007
- Windows 2003
- Windows XP
Certification
MB70-461 Querying Microsoft SQL Server 2012/2014
Timeline
Sr. Systems Analyst
Health Care Service Corporation (HCSC)
10.2019 - Current
Sr. Database Developer
Iowa VR
04.2019 - 09.2019
Credit Portfolio Consultant
Wells Fargo & Company
08.2018 - 03.2019
Database Engineer
Chicago Public Schools
12.2017 - 07.2018
BI Developer
Ascension Information Services
03.2017 - 11.2017
Data Analyst
Lifespan Corporation
02.2016 - 02.2017
Database Developer
Farm Credit Services of America
05.2015 - 01.2016
SQL/SSIS Developer
First Bank
12.2014 - 04.2015
Database Engineer
Quicken Loans
06.2013 - 11.2014
SQL Developer
Bealls
06.2012 - 05.2013
Bachelors - Computer Science
JNTU
MB70-461 Querying Microsoft SQL Server 2012/2014
Master of Science - Computer Science
Troy University
Similar Profiles
ARNOLD ALUFANETIARNOLD ALUFANETI
Project Coordinator at Health Care Service Corporation, HCSCProject Coordinator at Health Care Service Corporation, HCSC
Jan DeLunaJan DeLuna
Business Consultant at Health Care Service Corporation, HCSCBusiness Consultant at Health Care Service Corporation, HCSC
Safiya ArmstrongSafiya Armstrong
Health Coordinator at Health Care Service Corporation, HCSCHealth Coordinator at Health Care Service Corporation, HCSC