Sql Server Manager
Resume:
L akshmi Sravanthi Gutha
Mobile: 949-***-****
*************@*****.***
Professional Summary:
• Over 7 years of MS SQL Server Development experience in Entertainment, Digital
Asset Management, Fulfillment and Servicing domains with expertise in SQL
Server 2005/2008/2008R2/2012 on large and complex databases
• Have Complete Knowledge on Microsoft.Net Technology web applications, windows
applications, interfaces (console applications) and Web Services
• Expertise in Software Development Life Cycle (SDLC) of Projects – System Analysis,
Design, Development, Testing and Documentation
• Experienced in Logical and Physical database modeling using Microsoft Visio Data
modeler
• Experience in implementing Normalization and De-normalization
• Highly proficient in wri ting and performance tuning Stored Procedures, User
F unctions, Views, Triggers, Joins and T-SQL queries for efficient Data Manipulation
and Data In tegrity
• Expertise in Developing SSIS Packages to Extract, Transform, Load (ETL) data into
t he Data warehouse from heterogeneous databases, Flat Files, Excel and MS Access
• Used various SSIS tasks such as Conditional Split, Derived Column, which did Data
Scrubbing, including data validation checks during Staging, before loading the data
i nto the Data warehouse
• Used ETL to implement the Slowly Changing Transformation, to maintain
H istorical Data in Data warehouse
• Expertise in Developing and Extending MS SQL Server Analysis Services (SSAS)
Cubes, Data M ining Models, Deploying and Processing SSAS objects, and wri ting
M DX queries
• Created calculated measures and dimension members using multi-dimensional
expressions (MDX), mathematical formulas, and user-defined functions
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis
• Experience in creating MDX queries to extract data from the Data Warehouse and
data from the cube to display SSRS reports
• Defined relationships between Measure groups and Dimensions
• Implemented the calculations to aggregate physical measures
• Created different type of enterprise reports including Drill-down, Drill-through, Ad-
hoc, Linked and Sub reports using SQL Server Reporting Services (SSRS)
• Extensive experience in wri ting Parameterized Queries for generating Tabular
reports, Formatting report layout using functions, sorting data and sub totals using
SSRS
• Generated Dynamic reports from Cubes (SSAS) using SSRS
• Experienced in Deploying and Maintaining the reports in SharePoint Server
• Proficient in Creating, Configuring and Fine-tuning SSIS Packages, SSRS reports
and T-SQL queries using tools like SQL Profiler, Performance monitor
• Experienced in logical and physical database design and development, normalization
and data modeling using Erwin and SQL Server Enterprise Manager
• Experienced in Database Backup, Restoration, Linked Servers and Database
M aintenance Planning.
Education Qualification:
Bachelors of Technology in I nformation Technology f rom Jawaharlal Nehru
Technological University
T echnical/Business Skills:
Databases: M S SQL Server 2008 R2/2008/2005
Languages: T-SQL, .Net Framework 4.0, ASP.Net, C#.Net, VB.Net, ADO.Net, Web
Services, XML, HTM L, DHTM L, JavaScript and CSS
E TL and Reporting Tools: SQL Server In tegration Services (SSIS), SQL Server Analysis
Services (SSAS), SQL Server Reporting Services (SSRS), MS SQL Profiler
GU I and Tools: B usiness In telligence Development Studio, Visual Studio .Net, I IS, MS
Access 2010/2007, MS Excel and Team Foundation Server (TFS).
Professional Experience:
Client: 20th Century Fox – Television Distribution, Los Angeles, CA M arch 2011 -
T ill Date
Role: SQL Server Developer
Description: 20th Century Fox – Television Distribution department is the exclusive
d istributor for all Fox produced and acquired programming. Responsibili ty of this
department includes U.S. network sales, domestic and international broadcast, Pay TV,
F ree TV and SVOD of long form content and overseeing their ownership interests all over
t he world. In order to that, it has two systems TVDAPR (admin system) and FOXFAST
(customer facing portal). At the high level,
• TVDAPR is Digital Asset Management System which manages the
customers, marketing and digital content/assets and their r ights.
• FoxFast is a customer facing portal which delivers the marketing and digital
assets to customers based on their r ights/access control list (ACL)
P roject: FoxFast Digital Delivery Dashboard December 2012 – Till Date
Fox-TVD has an initiative to deliver the broadcast quality (BQ) assets to the customer using
an automatic PUSH mechanism instead of manual PULL (download) by customer from the
FoxFast Web Portal. FoxFast provided a Client/Server mechanism where the broadcast files
w ill be delivered (PUSH) automatically to client machine depending on his r ights (ACL).
FoxFast also provided a Digital Delivery Dashboard screen to show and manage the priority
of the customer Queue (of BQ Assets) based on r ights. This Dashboard also provides the
h istory of the assets were delivered for reporting purposes.
Project: FoxFast Mobile Apps for iPAD and Windows 8 March 2012 –
December 2012
Fox-TVD has an initiative to provide some of the services from FoxFast customer facing
portal through mobile platforms. So that customers and executives use their mobile devices
to view digital and marketing content and screen VAM and long form screeners
online/offline through screening room and manage digital asset download cart.
Project: FoxFast Screening Room and EditBay March 2011 - March
2012
Fox-TVD has an initiative to provide two modules in FoxFast where customers can screen
a ll the video screeners (VAM/Full Length) assets based on their r ights and also extract the
P romo Clips or Localize/Censor the content from a broadcast file.
Screening Room: FoxFast provided this functionality where displays recent ti tles where the
new content was added in reverse chronological order of the content added, which enables
t he user to screen the latest content. I t also provides various other features to search a
v ideo and create playlists.
E ditBay: This tool provides ability to customers where they can watch the video online and
mark the t ime intervals where localization/censorship/Promo Clips required. Depending on
t hat Fox deliver the Broadcast material through FoxFast Portal.
Responsibilities:
• Involved in Database design and data modeling discussions
• Involved in analysis, database design, creating database and tables.
• Involved in database Normalization, logical and physical data modeling using
M icrosoft Visio Data modeler
• Developed and optimized database structures, s tored procedures, Dynamic
M anagement views, D DL t r iggers and user-defined functions
• Used Joins, correlated and non-correlated sub queries for complex business queries
• Identified, tested and resolved database performance issues (monitoring and
t uning) t o ensure data optimization
• Improved Performance of the database by creating Clustered and non-clustered
I ndexes and by optimizing the T-SQL statements using SQL profiler
• Involved in creating Synonyms and Linked Servers to communicate between
d ifferent databases across different servers
• Developed SSIS Packages (ETL) to load the Enterprise Order XML and Excel files to
database and process them to generate content authorizations
• Used Bulk Insert and BCP to load data from f lat files
• Migrated packages from development server to production server using package
configuration and created Jobs to call the SSIS Packages and Stored Procedures
• Used ETL to implement the Slowly Changing Transform to maintain historical data
i n Data Warehouse
• Implemented SSAS cubes from Facts and Dimension tables to perform Analysis
• Defined relationships between Measure groups and Dimensions and implemented
M DX queries to extract data from the Data Warehouse
• Implemented calculations to aggregate physical Measures
• Created Calculated Measured and Dimension members using Mul ti-Dimensional
E xpressions, mathematical formulas and user defined functions
• Responsible for generating the Ad-hoc, monthly, quar terly and annual reports for
download and play activity
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill
down, Drill through, Sub reports using SSRS
• Continuous Support for Database Programming related issues
• Created OLAP cubes using SSAS and made use of them in generating reports.
• Conducted user t raining sections and supported the requests for enhancements,
modifications and new reports
• Implemented C#.Net interfaces to connect with other enterprise systems Databases
to get the Title Metadata, Asset Metadata and Rights
• Implemented C#.Net In terfaces to connect with other Fox Digital Asset Management
systems to t r igger Asset Auto PUSH
Environment: SQL Server 2008 R2/2008, Visual Studio .Net 2010, C#.Net, XML, Windows
Server 2008 R2, Business In telligence Development Studio, SQL Enterprise Manager, SQL
P rofiler, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),
Team Foundation Server(TFS).
Client: arvato digital services, LLC, Valencia, CA November 2008 - February
2011
Role: SQL Server Developer
Description : arvato digital services – Valencia branch provides the web-based sales, order
management and process through call centers and online. I t caters to automotive,
telecommunications, information technology, media, financial services, healthcare and
t ravel industries.
P roject: I T Academy ( ITA) - Digital Downloads and Purchase Dec 2009 - Feb 2011
M icrosoft IT Academy enables all the members/schools to download the digital certifications
for their Academies. Also allow the academy administrators to personalize the
certifications. This project provides academy administrators an ability to login, personalize
and preview the certificates for a given academic year. Also it provides the ability to
download the digital certificates (both IT academy or personalized) and purchase them.
T his project has administration tool where arvato administrators can login and manage the
f ront-end portal content and generate the reports.
P roject: MCP Certs and Wallet cards Digital Downloads and Purchase Nov 2008 –
Dec 2009
This is a web portal where all the M icrosoft Certified Professionals login using their
W indows Live ID to view the list of their certifications earned, preview and download
d igital certifications. This also provides an option to purchase the physical certificates. In
order to allow customers to purchase physical certificates online, it integrated with Cyber
Source for credit card and PayPal integration. Also i t internally has interfaces to submit the
orders to BizTalk and SAP. This enables the arvato printing department to view the orders
and print the physical certificates and mailing labels to fulfill the customer order.
This project has administration tool where arvato administrators can login and manage the
f ront-end portal content and generate the reports. . I t provides the ability to
administrators to resubmit the failed orders or impersonate a MCP user to generate the
certificates on behalf of him.
R esponsibilities:
• Involved in creating databases and tables
• Involved in SQL Programming to develop Stored Procedures, Dynamic Management
V iews and User-defined functions
• Used SQL Joins and Sub queries for complex business rules
• Identified, tested and resolved database performance issues (monitoring and
t uning) t o ensure data optimization
• Improved Performance of the database by creating Clustered and non-clustered
I ndexes and by optimizing the T-SQL statements using SQL profiler
• Responsible for generating the reports for download and purchase activity
• Experienced in deploying reports into the Share point location and updating those
reports through that Share point location
• Developed SSIS Packages (ETL) to download XML files from FTP location to local
folder and to load daily data to database
• Used Bulk Insert and BCP to load data from f lat files
• Worked on D TS, Import and Export u tili ty, for t ransferring data
• Implemented SSAS cubes using Facts and Dimension tables to perform analysis
• Defined relationships between Measure groups and Dimensions and created MDX
queries to extract data from the Data Warehouse.
• Created Ad-hoc and dynamic reports from cubes (SSAS)using SSRS
• Continuous Support for Database Programming related issues
Environment: SQL Server 2008/2005, Visual Studio .Net 2008, Windows Server 2008 R2,
B usiness In telligence Development Studio, SQL Enterprise Manager, SQL Profiler, SQL
Server In tegration Services (SSIS), SQL Server Reporting Services (SSRS), Team
Foundation Server (TFS).
C lient: M icrosoft, Hyderabad, I ndia March 2007 -
October 2008
Role: SQL Programmer
Project: M icrosoft Windows Vista Ha rdware Assessment (WVHA)
The WVHA is an inventory, assessment and reporting tool that will find computers on a
network and determine if they are ready to run Windows Vista operating system and report
t hem. This was used by all the customers to determine the Windows Vista readiness within
t heir network.
Responsibilities:
• Developed S tored Procedures, Views and User Defined Functions using T-SQL
s tatements
• Used SQL J O INs, Temporary tables and Sub Queries
• Used performance optimizations tools like SQL Profiler to improve the
performance
• Involved in performance tuning of Stored Procedures and T-SQL statements
• Involved in creating clustered and Non-Clustered I ndexes to improve the database
t ransactions performance.
• Worked on importing/transferring the data to database tables using D TS, Import
a nd Export u tili ty
• Worked on preparing summary reports and ad hoc reports
• Support for Database programming related issues
Environment: SQL Server 2005, Windows Server 2003, SQL Enterprise Manager, SQL
Query Analyzer, SQL Profiler, Data Transformation Services (DTS)
Client: Aztecsoft, Hyderabad, I ndia August 2006 – February
2007
Role: SQL Programmer
Description: Aztecsoft is a software engineering service company provides development
and testing services in India and internationally.
P roject: Issue T racking System ( ITS)
This project is aimed at improving the productivity, efficiency of a software development
team by t racking various issues or bugs in a project. I ts efficient handling of various
issues/bugs provides the much needed t racking facility. Usage of XML and import facility
f rom other systems gives a competitive edge to the system
Responsibilities:
• Trained in SQL Programming to create databases, T-SQL Programming, Using
JOINs, Sub-Queries, designing and implementing Views, T riggers, User Defined
F unctions and Stored Procedures
• Implemented Views, Stored Procedures using JOINs and Sub-Queries
• Involved in T-SQL Programming to generated Ad hoc Reports
E nvironment: SQL Server 2005, Windows Server 2003, SQL Enterprise Manager, SQL
Query Analyzer, SQL Profiler
Contact this candidate