Sql Server Data
Resume:
Praveen Poosapati [pic]
****************@*****.***
SUMMARY
. Microsoft Certified IT Professional with 4+ years of strong Experience
in Relational Database Management systems & software development.
Major experience in SQL Server 2005/2008, SSIS, SSRS.
. Extensive knowledge in T-SQL queries (DDL and DML).
. Solid working experience in Transact SQL writing complex Stored
Procedures, Functions, Triggers and Packages.
. Experience with Software Development Life Cycle (SDLC) and
methodologies.
. Experience in documenting and educating users in providing required
data through FTP folders.
. Solid working experience in working with WAREHOUSE DB development.
. Involved in providing ETL support for the production server.
. Transformed data from various data sources using OLE DB / MS AS
connection by creating various DTS packages.
. Involved in creating windows batch scripts to automate transferring of
files from one Server to the Other Production server using Putty and
WINSCP.
. Knowledge in ASP.Net coding for integration with Business
Intelligence.
. Created Reports with complex formulas and to query the database for
Business Intelligence.
. Good understanding in Oracle 9i/10g Database.
. Good understanding in database and data warehousing concepts (OLTP &
OLAP). Experience with logical and physical data modeling and database
design using Erwin.
. Extensive knowledge and experience in using different Transformation
tools like DTS packages, BCP, and BULKINSERT.
. Responsible for developing drilldown reports using MDX and SQL.
. Deploy RDL files using Report Manager.
. Deploying a Reporting Services (SSRS) Solution.
. Generated, Developed, and Scheduled variety of Reports like List,
Matrix, and Chart and Sub Reports etc. and Standardized company
reports by implementing SQL Server 2005 Reporting Services (SSRS).
. Experience in building Data Integration and Workflow Solutions and
Extract, Transform, and Load (ETL) solutions for data warehousing
using SQL Server Integration Service (SSIS).
. Experience in developing User reports and management reports using MS
SQL Server Reporting Services (SSRS).
. Experience in developing Custom Report and different types of Tabular
Reports, Matrix Reports, Ad hoc reports and distributed reports in
multiple formats using SQL Server Reporting Services (SSRS) in
Business intelligence development studio (BIDS).
. Experience in administrative tasks such as data loading, batch jobs,
data unloading, Backup, Recovery and scheduling the backups.
. Used Pro clarity for accessing and analyzing cubes and dimensions, and
also worked on integration of SharePoint with SSRS.
. Knowledge in building cubes using SQL Server 2000/2005 Analysis
Services (SSAS).
. Successfully designed logical and physical database models using ERWIN
data modeler; designed initial database migration plans and procedures
for migrating data.
. Building and writing MDX Queries, Calculated Members, and KPI's using
Microsoft sql Server 2005/2008 Analysis Services Business Intelligence
(SSAS,SSRS)
. Has very strong background in a disciplined software development life
cycle (SDLC Agile, Waterfall) process and has excellent analytical,
programming and problem solving skills.
. Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
. Proven abilities in establishing effective task priorities, working
independently, and participating as an integral part of a team.
. Motivated Team Player who works well independently and in a team
environment and has the ability to learn new concepts.
. Superior communication, presentation, analytical and problem solving
skills.
. Good Business and System Analysis skills to understand the
requirements and design application to accomplish the business needs.
TECHNICAL COMPETENCIES
SQL Server Tools : Enterprise Manager, Profiler, Query Analyser,
Export & Import (DTS), SSIS, SSRS, SSAS.
RDBMS : MS SQL Server 2000/2005/2008, Oracle 9i/10g, Access
ETL : DTS, SSIS, Data Stage
Programming Languages : SQL, T-SQL, PL-SQL
Internet Technologies : XML, HTML
Productivity Applications : MS Word, MS Excel, MS Access,
MS FrontPage
Operating System : Windows95/98, Windows 2000/NT/XP, MS
DOS
Reporting Tools : Crystal Reports 11,10,9,
SSRS
CERTIFICATION
Microsoft Certified Technology Specialist.
PROFESSIONAL EXPERIENCE
Clayton, Shelton, CT
Feb' 11 - Till Date
SQL Server/Reports developer (Contractor)
. Developed various T-SQL stored procedures triggers, views, and
adding/changing tables for data load and transformation, and data
extraction.
. Involved in creating Reports from scratch and also modifying the
existing reports to include the enhancements required.
. Involved in creating custom enhancements to the reports using .net.
. Creating cascaded parameters in reporting services.
. Involved in creating SSIS packages to perform the data validations and
transformations and staging the data in a staging database coming back
from the investors using FTP task.
. Worked on creating new database objects like Stored Procedures, User
defined functions, tables etc for using them in the report creation.
. Working on creating a new relational database to migrate from one of
the old databases (MARS).
. Created a lot of stored procedures to archive the existing data and
automate the data transfer from different servers on to the staging
database.
. Involved in creating and altering SSIS packages to get data from flat
files and oracle sources to the SQL Server database.
. Involved in migrating the power builder reports to SSRS reports.
Environment: Windows 2003/2000, MS SQL Server 2005, T-SQL, SSIS, VB, BIDS
2005.
UNFI, Providence, RI
Nov' 10 - Feb' 11
SSIS/SSRS Reports developer (Contractor)
. Involved in creating SSRS reports for pricing structures.
. Create new SSIS packages to transfer data from Live DB to the
warehouse DB.
. Managing and modifying the existing SSIS packages to populate the
warehouse DB with the newly required columns for the reports.
. Develop stored procedures and complex SQL Queries for using in the
report datasets.
. Develop SSRS reports from scratch including matrix reports and
Gauges to support cross-tab requirements and use custom coding to
support the needs and requirements in the reports.
. Use pivoting and switch columns and rows in the tables to
facilitate the reporting needs.
Environment: Windows 2003/2000, MS SQL Server 2005/2008, T-SQL, SSIS, VB,
BIDS 2008.
Caliber Funding, Tucson, AZ
April' 10 - Oct' 10
SQL Server/BI Developer
. Working on T-SQL programming, stored procedures, user-defined
functions, cursors, views, setup and management of linked servers to
Non-SQL-Server databases.
. Worked along with manager in creating a new Data warehouse from
scratch to create reports.
. Extracting the data from the different sources (CSV files, oracle) and
stored the data into the warehouse database using SSIS.
. Involved in providing ETL support for the production server.
. Created SSIS packages to Oracle and other SQL Server instances.
. Imported Share point lists to SQL tables through Share point list
adapters in SSIS.
. Creating stored procedures to use in the ETL process as a path towards
performance tuning and make the process identical for all the ETL's.
. Created Indexes for fast retrieval of the data and involved in
Performance tuning.
. Created new database/tables to put in the extracted data and rebuild
the relationship.
. Working with Technical Architects and Database analysts for the Design
of Summary tables required for efficient Report.
. Experience in working with front end UI developers and architects to
implement the functions written in C# and VB.NET in t-sql.
. Created reports using SSRS from various sources like SQL Server
2005/2008 and Cubes from Analysis Services.
. Created various SSRS Reports involving variety of features like
Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-
valued parameters etc
. Experience in Developing and Extending OLAP Cubes, Dimensions and data
source view.
. Developed complex stored procedure using T-SQL to generate Ad hoc
reports using SSRS.
. Scheduled the Reports to run on daily and weekly basis in Report
Manager and also email them to director and analysts to review in
Excel Sheet.
. Experience in writing custom codes in for reporting for column
visibility and exporting to different file extensions.
. Experience in Developing and Extending OLAP Cubes, Dimensions and
data source view
. Developed complex stored procedure using T-SQL to generate Ad hoc
reports using SSRS.
. Scheduled the Reports to run on daily and weekly basis in Report
Manager and also email them to the director and analysts to review in
Excel Sheet.
. Build database queries and test cases for the testing team to test the
reports.
. Working closely with users to gather the requirements for building
reports.
. Created report models, so that the users can create ad-hoc reports
through report Builder.
Environment: Windows 2003, MS SQL Server 2005/2008, T-SQL, DTS, SSIS,
SSRS.
Siemens, Mason, OH
Feb'09 - March' 10
SQL Server Developer/BI Developer (Contractor)
Responsibilities:
. Involved in the process of automating the Manual Billing process for
more than 120 clients.
. Designed the functional and technical documents, report templates and
reporting standards for the developers to work on the report
development.
. Involved in providing ETL support for the production server.
. Involved in creating Named calculations and named queries.
. Integration of SSRS Reports using various web parts into Sharepoint
and various delivery mechanisms.
. Involved in creating windows batch scripts to automate transferring of
files from one Server to the Other Production server using Putty and
WINSCP.
. Created Dimensions with the cube wizard and also individually.
. Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-
charts on data from cubes and SQL Server in Excel 2007.
. Built Drill Down, Drill through, linked and sub reports using SSRS
2008.
. Refreshing the cube to get the latest information updated.
. Building cubes with SQL server 2005 analysis services.
. Deployment of Cubes to the production server.
. Created new reports from the scratch for new requirements and modified
some of the existing reports using Business Reports.
. Published reports on to Share-Point and created Web Parts in Share-
Point to show various reports generated from Excel and SSRS in one
Page.
. Created forms on share-point to show live data from underlying data-
sources like SQL Server to Clients enabling them to edit the data and
update the data in the underlying data-sources.
. Configured SSRS with MOSS 2007 for directly deploying the report in
SharePoint 2007.
. Generation of reports from the cubes by connecting to Analysis server
from SSRS.
. Wrote scripts in ASP.NET to integrate reports with SQL / Oracle Server
. Developed the SQL Server Integration Services (SSIS) packages to
transform data from SQL 2000 to MS SQL 2005 as well as Created
interface stored procedures used in SSIS to load/transform data to the
database.
. Performed maintenance of Stored Procedures to improve Performance of
different front end Applications.
. Extracted data from SAP applications in the form of raw files and
loaded them into the Data warehouse.
. Extensively involved in the SSAS storage and partitions, and
Aggregations, calculation of queries with MDX, Data Mining Models,
developing reports using MDX and SQL.
. Involved in creating ASP.NET pages, which gathers input from GUI
components and stores them into database.
. Used Excel to deploy SharePoint solutions and implement Excel webs
services to do custom calculations.
. Configured SSRS with MOSS 2007 for directly deploying the report in
SharePoint 2007.
. Generation of reports from the cubes by connecting to Analysis server
from SSRS.
. Developed the SQL Server Integration Services (SSIS) packages to
transform data from SQL 2000 to MS SQL 2005 as well as Created
interface stored procedures used in SSIS to load/transform data to the
database.
. Responsible for logical and physical data modeling, database design,
star schema, data analysis, programming, documentation and
implementation.
. Extracting the data from the different sources (CSV files, oracle, and
MS SQL 2000) and stored the data into the intermediate Staging
Database using the SSIS ETL tool.
. Transform the data from the staging database and perform the
transformation using the Data Flow Tasks
. Prepared the reports for the day-to-day as well as weekly/monthly
purposes in various formats like MS Excel, PDF, HTML, and XML etc.
Environment: Windows 2003/2000, MS SQL Server 2005/2000, T-SQL, DTS, SSIS,
VB, ASP, Share Point servers.
J-Knipper Health care Marketing Solutions, NJ
May'08 - NOV'08
SQL Server developer / Intern
Responsibilities:
. Involved in gathering user Requirements, application design, and
analysis of hardware requirements to meet business needs.
. Responsible for configuration of Microsoft Server/Client Products and
implementation.
. Having a good experience in Data modeling and involved in Designing
Logical and Physical Data model using Erwin Tool.
. Systems analysis, design, development and utilization of SDLC.
. Asp.Net for gathering data information for web based applications.
. Extensively used XL web services in SharePoint Portal 2007.
. Developed various T-SQL stored procedures triggers, views, and
adding/changing tables for data load and transformation, and data
extraction.
. Created database maintenance planner for the performance of SQL
Server, which covers Database integrity checks, update Database
statistics and re-indexing
. Created Database Objects like Tables, Stored Procedures, Views,
Triggers, Rules,
. Defaults, user defined data types and functions in SQL Server 2005.
. Asp.Net web pages using Visual Basic Language.
. Actively involved in creation of database, modifying tables, triggers,
and store procedures.
. Creating Dashboard pages and Reporting Services web parts.
. Created SSIS Packages to migrate slowly changing dimensions.
. building cubes with sql server 2005 analysis services
. Migrated data from the MS Access database using SSIS Packages.
. Built MDX queries and Data Mining Expression (DMX) queries for
Analysis Services & Reporting Services.
. Experience in creating scorecards, dashboard reports and critical
management reports .in Performance point.
. Involved in the Data modeling, Physical and Logical Design of Database
. Incorporated business logic in SSIS while converting from MS Access
and Text to SQL Server.
. Created Backups for databases and automated the process.
. Created Transactional Replication, Pull Subscription and defined
editions to transfer data from branch to head office and vice versa.
. Created Dashboards from reports and XL work books in SharePoint (MOSS)
2007.
. Created reports as per user requirement using SQL Server reporting
services (SSRS) which delivers enterprise and Web-enabled reports.
. Involved in Backing Up & Restoring User Databases.
. Extracted data from SQL Server for report, backup, testing purposes by
using DTS,
. BCP and Import / Export option.
. Created different user level groups, and assigned appropriate
permission level to the database.
Environment: SQL Server 2005/2000, SQL Server Integration Services,
SharePoint Moss 2007. MDX, Oracle 9i, SQL Server Reporting Services, MS
Access & Excel.
New India Assurance, INDIA.
April '06 - Dec '06
SQL Server Developer
Responsibilities:
. Developed database objects such as stored procedures, functions,
triggers, and tables using T-SQL and SQL Server Management Studio.
. Created views for designated user interfacing and triggers on them for
consistent data entry.
. Generated complex stored procedures and functions for better
performance and flexibility.
. Performed optimization of query, triggers and stored procedures using
performance tools.
. Performed Index analysis on tables and developed more efficient
solutions using Clustered, Non-Clustered and online Indexes for
performance boost.
. Generated daily reports using SSRS.
. Created technical specification and design document using Microsoft
word and Visio.
. Done Unit and System Integrating Testing (SIT) of the interface
between Web methods and SAP systems, tracked defects, logged and
solved them.
Environment: SQL Server 2000 Enterprise Edition, Query Analyzer,
Enterprise Manager, Windows 2000/NT.
EDUCATION
. MS, Computer Engineering at University of North Texas, Denton, TX.
. B-Tech, Computer Science, M.V.G.R College of Engineering, India.
.
SCHOLARSHIPS
. Recipient, Texas Public Education Grant, UNT for Fall 2007.
. Recipient, Texas Public Education Grant, UNT for Fall 2008.
REFERENCES
. Available on request
Contact this candidate