Freelancer Srujana Lakshmi Banala
BASIC
100 $

SQL server Database administrator Srujana Lakshmi Banala, Websites, IT & Software

Srujana Lakshmi Banala
India, Hyderabad
Joined Sep 25, 2020

About Srujana Lakshmi

Having 2+ Years of Experience in SQL Server DBA.  Experience in Installation in different versions 2008, 2008R2, 2012, 2014 and 2016.  Experience in Ticket management tool like Service now.  Experience in Backup & Recovery.  Experience in apply the service pack in different versions.  Experience in Replication, Mirroring and Log shipping ...Expand

Location

Portfolio

SQL DBA

About freelancer

Srujana Lakshmi
BASIC
Srujana Lakshmi Banala
(0 reviews)
Joined Sep 2020
Last seen
5 months ago
Having 2 years of experience as SQL server database administrator
Pricing

Recommended For You

Willie Li
BASIC
SQL Developer - remote Willie Li, Websites, IT & Software
SUMMARY OF QUALIFICATIONS • Strong business analytical skills, outstanding business knowledge in Finance, Insurance, Healthcare, Ecommerce, Retail and Media. • Excellent database/data warehouse design and administration, data transformation and data analysis expertise. • Solid full life cycle business application development experience. • Great background in Computer Science, Mathematics and Statistics. • Seasoned object-oriented/Web/E-Commerce/Window application programming and problem-solving experience. COMPUTER SKILLS: • Languages: C#, ASP/ASP.NET, SQL, PL/SQL/T-SQL, Python, PowerShell, VBScript/JavaScript/jQuery/CSS/SCSS/XSL, Visual Basic, C/C++, Java, XML/JSON/HTML/DHTML, Ajax, PHP • Database: MS SQL Server (from SQL 6.5 to SQL 2017), Redshift, MySQL, Oracle, MS Access, DB2, Firebird, MongoDB • Software/Tool: Visual Studio, SQL Server SSIS/SSRS/SSAS, SSMS/Azure Data Studio, SQL Workbench, MS Power BI, Tableau, Crystal Reports, Elasticsearch/Kibana, ER/Studio Data Architect, MS Office/FrontPage/PowerPoint/Share Point, Visual Source Safe, Agile, Bitbucket/Git, Jira, ZappSys, Magneto, Fishbowl, Shipworks PROFESSIONAL EXPERIENCE Radiological Society of North America (Oak brook, IL) SQL /ETL Developer 04/2019-Present Work closely with business user and application developer to analyze/enhance the existing relational/non-relational database solution, create new database solution, redesign the data warehouse to better serve the business. • Highly proficient in T-SQL programming, create/update complex stored procedure, user defined function/type, view, trigger and index on SQL Server, improve the query performance, decrease the CPU usage and disk IO. • Create/enhance ETL packages to auto retrieve data from FTP server, dynamic web page and different API call, transform data from different format to relational data, store the transformed data to Redshift and SQL database. Store and manage data files in Amaze S3. • Use SSRS/Power BI to build customized interactive/parameterized/drill down reports and dashboard. • Create ETL project to update company level Elasticsearch data. • Design and develop ETL solution using SSIS/C# to read and reformat special survey data for business reporting. • Create ETL solution using SSIS/Python to read vendor data file, fix the input data issue and transfer the data for analysis needs. • Redesign the data warehouse schema, improving the loading data job’s efficient, decrease job’s running time. • Create and maintain varies daily/weekly/monthly SQL Server Agent jobs. These jobs are used to prepare and transform data from different source to SQL database and enterprise data warehouse. • Set up a new SQL ETL development server, create new SQL Server Agent jobs. Unique Fitness Concepts (Vermont Hills, IL) Senior Developer/Data Analyst 03/2017 – 04/2019 Interact with business user to define the requirements for business need. Work with different software vendors to customize their solution to fit Unique Fitness’s need. Use SSIS/C# to build ETL tools to integrate data from different sources. Enhance and support Unique Fitness’s web site, troubleshoot site related issues. • Created, maintained and updated email, invoice, label and packing slip templates in Shipworks. • Maintained and updated Unique Fitness website using Magento software. • Monitored, cleansed and mapped more than 100 vendors' product and price data source. • Designed and developed ETL solution using SSIS/C# to maintain product and pricing. • Used SSRS/Power BI to generate reports to satisfy business needs. Li & Association (Westmont, IL) Consultant 09/2004 - 03/2017 Built business solution for different clients. • Designed, created and maintained a stock trade analytical tool. Developed a ETL tool to auto retrieve market data from different web sites. Built and maintained a SQL server database to store trade and market data, generated different trend reports for business user. • Designed and developed different solutions to help client monitoring/cleansing/mapping/integrating healthcare data. • Designed, created and enhanced business reports for different clients. Bank One/JPMorgan Chase (Chicago, IL) Senior Developer /DBA 08/2002 - 08/2004 Worked with Bank One capital marketing business supervisor, designed and built applications/database to achieve SuperBase model (fix income prepayment modeling), created industrial recognized software and reports. • Designed, created, maintained and fine-turning SQL Server database and managed the database security. There are more than 100 GB data in 11 databases, more than 300 stored procedures and 50 DTS and jobs to implement the business rules. • Processed the loan level data received from six different issuers, pool level data from Intex to produce the data for SuperBase application. • Built and enhanced SuperBase application. This is an analysis tool used to analyze loan level (current and future) and pool level (current) data. It also generated monthly residential ABS reports, loan forecast data (ARM and Fixed), on-demanding reports/data required by business users and clients. • Built a data warehouse using SuperBase monthly report’s results and marketing data. • Built SuperBase client software to allow client analyzing their loan information and generating forecast data based on the marketing information. • Created Microsoft Word templates used for monthly reports. Tellabs (Lisle, IL) Consultant (Web Developer) 10/2001- 05/2002 • Enhanced and supported Detailed Specification System. The DSS software is an intranet application designed to increase the productivity of the deployment engineering group. Technium (Chicago, IL) Consultant 09/2000 – 08/2001 Designed and built applications for eSkye Solutions, Inc. (a service network and technology solutions provider for the global beverage industry) • As a web developer: built a web application allowing eSkye customer service setting up and maintaining user's profile and their priority on-line. • As a SQL server developer: mapped data between existing data structure and newly implement data structure, converted data from existing database and other sources to new database. Created and modified stored procedure, triggers, user defined functions and built DTS packages and jobs. Designed and built applications for RollingStone.com (an internet music distribution) • As a web developer: involved in the full life cycle development of client's system. Built a web-based administrator tool to allow user to change their data on-line. Created and modified COM components to add new functionalities. • As a SQL developer: created COM components to be used in SQL server jobs. Created and modified stored procedures, triggers, user defined functions and built DTS packages and jobs. Stargate Communications Inc. (Oak Brook, IL) Web Developer 03/2000 – 09/2000 Designed and built several applications for different client. • Sole responsible for building the B2B web site www.comm-2000.com. Worked with business owner to define the business need, created the database, designed and coded the web site. Used SQL DTS/Jobs to translate the product and client information between UL and www.comm-2000.com. • Enhanced www.mba2mba.com web site and its database. Coded most of the site functionality including member sign on/registration, colleague search and site administration functionality used to maintain member information on-line. • Used SQL Server, Crystal Report as the tools to sort and group the raw data from www.OurHouse.com and produced meaning reports for the client. Newspaper Services of American (Naperville, IL) Senior Developer 07/1998 – 03/2000 • Designed and built a client-server application to maintain the company’s vendor information. • Installed a new MS SQL Server. Designed and set up a new MS SQL Server database, converting the existing data into the newly created database. • Designed and built an interface application to map client’s data into NSA system. • Designed and coded company’s intranet application. NCH Promotional Service (Lincolnshire, IL) Developer 01/1997 – 07/1998 • Designed and modified current system (Batch and Front-end) to accomplish business changes. • Directly contacted manufacturers, obtained requests and completed tasks. • Supported current retailer system. Metamor Technologies (Chicago, IL) Consultant 06/1996 – 01/1997 Designed and built several applications for client United Healthcare of Chicago. • Created, reformed current system (batch process) to achieve client’s request • Communicated directly with clients, finished ad-hoc requests. • On call support. EDUCATION AND CERTIFICATE Master of Science Degree (Computer Science, Loyola University of Chicago, January 1994 - May 1996)
Websites, IT & Software
C# Programming
Database Development
ETL
Microsoft SQL Server
SSIS (SQL Server Integration Services)
60 $
use cookies. By continuing to use this website you consent to our cookies policy. Privacy Policy
WONO