Sql Server Developer
Resume:
VENKATA RAMANA POLASA
Sql Server Developer/Reports Developer
***.******@*****.***
SUMMARY
> Over 8 Years of IT & Highly motivated Microsoft Sql Server Developer
using SQL Server 2000/2005/2008 and Microsoft Technologies.
Successfully designed, developed and implemented custom client
solutions including; financial, insurance, manufacturing and services
industries. Experience manipulating various data sources to support
Senior Management decisions. Demonstrated leadership abilities
and team work skills as well as the ability to accomplish tasks under
minimal direction and supervision.
> Hands on knowledge with MS SQL Server 2005/2008 Business Intelligence
products - Analysis Services, Reporting Services and Integration
Services
> Strong experience in developing Sub Reports, Matrix Reports, Charts,Drill down reports, using SQL Server Reporting Service
> Extensive experience and detailed knowledge of Insurance, Product,
management and Securities Industry & Provided Solutions for them
> Expert Knowledge in creating Reports using Reporting Services (SSRS).
> Experience in Database Development, Data Warehousing, Design and
Technical Management.
> Extensive experience in taking requirements from business users and
business analysts, developing the sql required to retrieve the data
for the report and developing the required report
> Ability to juggle multiple projects and priorities and reprioritize as
necessary to align with current business objectives.
> Excellent T-SQL Development skills to write complex queries involving
multiple tables, great ability to develop and maintain Stored
procedures, Triggers and User Defined functions.
> Excellent problem solving & decision making skills and proven track
record in analyzing situations and offering innovative cost effective
solutions.
> Extensive knowledge in Tuning SQL queries & Improving the performance
of the Database.
> Efficiently helped in the Software Development Life Cycle (SDLC)
processes including Analysis, Design, development, Testing and
implementation.
> Experience in enhancing and deploying the SSIS Packages from
development server to production server.
TECHNICAL SKILLS:
Languages : T-SQL, PL/ SQL, C++, Java Script, XML
Tools : SQL SERVER Enterprise Manager,
Management Studio, SSIS,
Query Analyzer, Analysis
Services, SQL Profiler, SSRS, Microsoft BIDS
Operating Systems : Windows 98/2000/2003/XP/Vista, Win 2000 Server.
Database : SQL Server 2005, 2000,Oracle 8i, 9i,
EDUCATION
. Bachelor's of Engineering, Amravati University, India.
KEY SKILLS
YEARS
Sql server
6 Yrs
SSRS
4 Yrs
Oracle
1 Yr
SSIS
4 Yrs
SSAS
4 Yrs
Business Objects 2
yrs
Office/Excel
2 Yrs
PROFESSIONAL EXPERIENCE:
Reynolds, Richmond, VA
Aug '08 - June '10
Sql server developer/Reports Developer
Roles & Responsibilities
. Converted sql server DTS packages to SSIS packages and loaded into Sql
Server database
. Created different objects: Stored Procedures to populate data into
different tables according to different parameters specified.
. Analyzed the Data quality, Data validating, Data mapping to migrate
data to SQL server to over 60 tables.
. Developed various stored procedures used in the application using T-
SQL.
. Detailed, strong problem solving, debugging, trouble shooting skills,
deals with ambiguity & self motivated
. Prepared and Implementation of functional specifications,design
documentation,configurations,t
Test Plan review and user documentation.
. Designed the cubes, mdx scripts using BIDS (SSAS)
. Used Business Objects reportings tools for Customer Reports.
. Extracted,Validated xml files & Loaded into database
. worked closely and collaborate independently across a feature team.
. Wrote complex T-SQL queries,Stored procedures,Triggers for data
extraction.
. Files transferred,Validated & Files Streamed in SQL Server using SSIS
Tool
. Created/modified several Daily running and Month-End Jobs to meet the
project specifications.
. Bulk copy operation using BCP and Bulk Insert for transferring data to
the SQL server from different database sources.
. Candidate should be able to independently design solutions and should
be a quick learner.
. Created indexes and proper re-indexing for intensive OLTP system to
ensure best performance.
Environment: SSRS, sql server 2005, crystal reports,Business
objects,Transact-SQL,SOX,excel, SSAS,SSIS, OBIEE,Database Backups, Crystal
Reports, Oracle,Avectra netForum
Microsoft Corporation, Redmond, WA
March'08- July'08
Sql Server Developer/SSRS developer/BI Lead developer
Develop, implement and maintain all databases including stored and complex
queries, which include the administration of various databases in both
development and production environment. Focused on maintaining, and
optimizing the existing databases
Responsibilities:
. Analyzed and resolved performance issues with database code involving
SSIS and MS SQL DB
. Supported install/upgrades of Third Party SoftwareWorked with
business/functional analysts to determine reports and analytical
requirements.
. Developed Sub Reports, Matrix Reports, Dynamic Charts,Drill down
reports, using SSRS
. Performed activities such as database creation, database tuning,
performance planning, backup planning and database administration.
. Actively involved in Normalization & De-normalization of database
. Designed & developed Microsoft Stack with the development team
. Materialized views, dimensions and stored outlines for optimal
performance
. Wrote Triggers and Stored Procedures to capture updated and deleted
data from OLTP systems.
. Wrote the MDX queries for OLAP Reporting
. Files transferred,Validated & Files Streamed in SQL Server using SSIS
Tool
. Used Performance Monitor and SQL Profiler to optimize queries and
enhance the performance of database servers.
. Used SSRS Reports to write complex formulas and to query the database
to generate different types of ad-hoc reports for Business
Intelligence.
. Published high-level technical documentation to set standards,
guidelines and best practices for SQL Server Database Design, Coding
Standards, Periodic Data refresh, database upgrades across the
enterprise.
Environment: SQL Server reporting services 2005, Visual Studio 2003,SSRS,
Transact-SQL, Excel, SSIS,Microsoft Stack, SSAS.
HRH (hilb rogal & Hobbs), Richmond, VA
Oct '07 - March '08 SQL Server Reports Analyst/SQL BI
Developer
Responsibilities:
. Connected to Oracle Data source from an ETL Tool and filtered bad data
& loaded Filtered data into Data ware house & Created Reports for
Business Users
. Converted crystal reports to sql server reports using Reporting
Services
. Involved in Fine tuning and standardizing of all reports, reporting
processes, delivery systems and Data Transformation Services (DTS),
queries and stored procedures.
. Developed data model based on the BA's and the reporting Team using
SSAS, SSRS.
. Worked on SQL Server Integration Services (SSIS) to integrate and
analyze data from multiple heterogeneous information sources
. Created packages in SSIS with error handling..
Environment: SSRS, Transact-SQL, SSIS, Agile Crystal Reports, Oracle,
OLAP, MDX
FedEx, Memphis, TN
May'06 - Sep '07
Sql server Developer/sql server Analyst
Responsibilities:
. Creating tables, relationships, triggers and indexes for enforcing
business rules
. Involved in development teams including project planning, estimating,
programming and testing
. Developed Sub Reports, Matrix Reports, Charts,Drill down reports,
using SQL Server Reporting Services
. Developed the Functional specification documentation for the modules
to be developed.
. Writing stored procedures, triggers, cursors, and views to improve the
quality of application, and manage mission-critical information using
T-SQL.
. Develop and support reports built with Microsoft Reporting Services on
SQL 2005 SSRS.
. Created/developed/maintained the stored procedures, triggers to
interpret complex business rules, history data and audit analysis.
. Designed logical / physical data models and defined primary key,
foreign key using Erwin tool.
. Scheduled and monitored all maintenance activities of SQL Server
2000/2005 including database consistency checks and index
defragmentation
. Ensure that periodic (daily, weekly and monthly) reports are delivered
in a timely and accurate fashion using Reporting services SSRS.
. Designed and developed DTS packages for transferring data from flat
files and Access files
. Using Integration Services (SSIS), built high performance Data
Integration Solutions, including extraction, transformation and
loading (ETL) packages for data warehousing.
. Helped design and implement processes for deploying, upgrading,
managing, archiving and extracting data for reporting.
Environment: SQL Server reporting services 2005, Visual Studio 2003,
OLAP,Crystal Reports, SSRS, Sql Server Integration Services.
Radix Info, India
Feb'02 - March '06
Sql Server Developer
Responsibilities:
. Created & scheduled Jobs & Established database backup, restore.
. Created tables, indexes, sequences, constraints, triggers and
procedures.
. Managing of databases objects like Tables, views, indexes etc.
. Managing of users including creation/alteration, grant of system/db
roles and permission on various database objects.
. Used DDL and DML for writing triggers, stored procedures, and data
manipulation.
. Extensively used joins and sub queries to simplify complex queries
involving multiple tables.
Environment: T-SQL, Agile, Stored Procedures, SQL Server 2000
Contact this candidate