Sql Server Manager
Resume:
Arvind Mamidi
*********@*****.***
Contact no: 571-***-****
Summary
. About 6 years of experience as SQL Server/Business Intelligence
Developer in the analysis, design, development, implementation,
testing, and maintenance of application systems in Client Server
environments.
. Experience with MS SQL Server 2000, MS SQL Server 2005 and MS SQL
Server 2008 and worked extensively on Reporting services (SSRS),
Integration services (SSIS) and Analysis services (SSAS).
. Extensive experience and proficiency on the design, construction and
implementation of Business Intelligence tools (Star Schema, Data-
Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process
(Data Extraction, Transformation layer) with DTS/SSIS, and MDX ad-hoc
Reporting.
. Proficiency in building and maintaining SSRS and Crystal Reports, Data
Marts and Data warehousing, SSIS Packages and Analysis Services
Cubes(SSAS) and writing T-SQL Queries.
. Experienced in Creating and maintaining SQL Views, Store Procedures.
. Proficiency in delivering Business Intelligence Solutions using
Microsoft SharePoint Server 2007/2010 and other BI Tools like Business
Objects.
. Exposure to VB.NET, HTML, C Sharp, JAVA.
. Experience in building and maintaining static and dynamic Websites.
. Experience in administrative tasks such as data loading, batch jobs,
data unloading, Backup, Recovery and scheduling the backups.
. Experience in Web and Windows based application development using
ASP.Net, VB.Net.
. Experience in Data Warehouse Modeling with SQL Server Analysis Service
(SSAS)
. Good understanding of Microsoft Reporting Service (SSRS) with Report
authoring, Report management, Report formatting, Report distribution,
Report delivery and Report security.
. Experience working with Microsoft BI tools in a TM1 environment.
. Experience working with Multidimensional databases and data mining in
SQL Server 2008 Analysis Services.
. Communicate effectively in writing and in meetings, workshops, and
face-to-face situations, Preparing Training manuals and training end
users.
. Experience in working with outsourcing companies with onsite-offsite
staff.
. Good Team player with ability to work on own initiative.
. Ability to understand functional requirements and design documents.
Skills:
Databases : MS SQL Server 2000/05/08 (R2)
Reporting : Crystal reports XI, Report Builder III and SQL Server
Reporting Services
BI Tools : Performance Point Dashboard Designer 2007, MS SharePoint
Server
2007, Business Information Development Studio 2005/08, Bussiness
Objects and ProClarity.
ETL Tools : SQL Server Integration Services, DTS, Data Integrator,
11.7.2, Designer, Admin Console, Repository Manager
Other Tools: Visual Studio 2003/05, Adobe Dreamweaver, MS Web Expression
2, MS
SharePoint Designer 2007
Programming: Experienced in T-SQL Queries, Knowledge of C Sharp & VB. Net
Professional Work Experience
Organization: FMG Support Ltd, Huddersfield
Designation: Business Intelligence Developer
Tenure: Jun 2008 - Till Date
Environment: SQL server 2000/05/08/08 R2, OLAP Cubes, Business Intelligence
Development Studio (SSAS, SSRS & SSIS), Crystal Reports XI, SharePoint
2007/2010, Performance 2007/2010, SharePoint Designer 2007
Key Responsibilities
. Delivering useful Information/data to business leaders and clients
using complete set of Business Intelligence Suit to help them make
decisions for betterment of the Business.
. Building and extending Data Marts and Data warehousing.
. Building, Maintaining and extending OLAP Cube Dimensions and Measures
using BIDS 2008/05.
. Extracting data from Cubes using Report Builder II, MS Excel and
PerformancePoint 2007 dashboard Designer.
. Creating, maintaining and scheduling SSRS Reports using Business
Intelligence Development Studio 2008/05 and Report Manager
. Rewriting all the existing Crystal reports to SSRS as a part of
Crystal Reports Migration project.
. Performed database transfers and queries tune-up, integrity
verification, data cleansing, analysis and interpretation. Developed,
monitored and deployed SSIS packages.
. Creating and maintaining SQL Views, Stored Procedures in SQL Server
2008/05
. Creating Dashboards, Key Performance Indicators, Scorecards,
Analytical Grids & Charts using PerformancePoint 2007 and publishing
them over to SharePoint Intranet.
. Maintain Internal SharePoint Intranet using SharePoint Designer 2007.
. Creating and maintaining SharePoint sites, list, Alerts, Document
Libraries and workflows
. Building and maintaining customer portals in SharePoint for clients.
. Training end users to use Business intelligence suit Via SharePoint,
Report Builder II, intranet and MS Excel.
. Writing complex T-SQL Queries to query data from SQL Server Database.
Organization: FMG Support
Designation: Business Intelligence Developer
Tenure: Jan 2007 - Jan 2008
Environment: SQL server 2000, Crystal Reports XI, SSRS, SSAS, C Sharp, .Net
Key Responsibilities
. Coordinating with Stake Holders for Business process improvements,
providing Presentation Statistic reports to help them make decisions.
. Providing overall leadership to Setup a Business Intelligence project
. Building and maintaining Crystal reports using Crystal XI, Object
Manager, Crystal Info view and Info Scheduler
. Developed SQL Server Stored procedures and SSIS packages to extract
data from database.
. Implemented constraints on tables.
. Developed the SQL Server Integration Services (SSIS) packages to
transform data from SQL 2005 to MS SQL 2008 as well as Created
interface stored procedures used in SSIS to load/transform data to the
database.
. Maintaining Different servers and Data Sources for Crystal reports
using Central Management Console.(CMC)
. Creating and maintaining SQL Views, Stored Procedures in SQL Server
2000/05
. Building and Maintaining OLAP Cube Dimensions and Measures using BIDS.
. Writing complex T-SQL Queries to query data from SQL Database.
. Writing Reports in SSRS using Report Builder to access the data from
Marts OLAP Cubes.
. Training end users to Extract Data from OLAP Cubes using MS Excel and
Microsoft ProClarity for visual Analysis of data and Preparing.
. Organizing workshops and seminars for end users and clients to
demonstrate the importance of the Business Intelligence suit and
training them to use it.
. Assist in Building Small C Sharp. Net Applications.
Organization: Hectech Computers, India
Designation: Database Developer
Tenure: Aug 2005 - Aug 2006
Environment: SQL Server 2000, MS Excel, Dreamweaver, Cute FTP
Key Responsibilities
. Writing basic level T-SQL Queries to fetch data from database.
. Creating and maintaing Views and Store Procs.
. Creating Reports Using MS Excel, VBA.
. Creating reports using Crystal Reports and scheduling using Info View.
. Design and maintaining static websites using Macromedia Dreamweaver.
. Assist in writing code to gather information from the web forms.
. Assist in connecting the developed web forms and the database using
ADO. Net.
. Implemented manual testing on all the WebPages and written few test
cases
. Creating and maintaining Websites using Dreamweaver, MS Expression and
visual studio
. Using Cute FTP download files from a server of any website.
. Upload websites to a web hosting server
Education:
Name of the School
Level
London School of E-commerce, Masters in
Information Technology
London, United Kingdom
Jawaharlal Nehru Technological Bachelors of
Technology
University, Hyderabad, AP, India in Computer
Science and
Engineering
Professional Training:
. Attended Microsoft Certified Training in Writing SQL Queries at QA
Leeds, UK.
. Attended Microsoft Certified Training in Business Intelligence End to
End in QA Leeds, UK.
. Attended Microsoft Certified Training in SSRS & SSIS 2008 at Remarc,
Manchester, UK.
. Attended Microsoft Certified Training in SharePoint Administration
2007 Step By Step at Remarc, Manchester, UK.
. Attended Onsite Training on maintaining and extending OLAP Cubes and
Data Analysis & Mining in ProClarity.
. Attended Corporate Training in ASP.NET with C Sharp and SQL Server
2005 Development in India
1
Contact this candidate