Sql Server Data

SQL Server Developer

Professional Summary:

• Highly motivated SQL server Developer with 4 + Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2008/2005, SSIS and SSRS.

• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2008/2005/2000.

• Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000, DTS, SSIS, SSAS and SSRS 2005/2008.

• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

• Experience in writing complex SQL queries involving multiple tables inner and outer joins.

• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.

• Worked Extensively on ETL process using SSIS package.

• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.

• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.

• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.

• Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.

• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

Technical Skills:

Web Technologies

Oracle application server (9i, 10g), Apache etc.

Development Tools

Web Tech

Productivity Tools

Oracle discoverer 9i, 10g, SQL*Plus, OEM 9i, 10g, Export/Import, Middleware.

ERP Tools

Oracle Applications EBS 11i, R12, Oracle collaboration suite.

Operating Systems

Windows 95/98/2000/XP/Vista/7/8/10, Mac, RedHat Linux AS 2.1, 3.0, 4.0, 5.0, Sun-Solaris 5.8, 5.10, and UNIX,

Database

Oracle 8.x, Oracle 9.x, Oracle 10gR2, MySQL, OLE-DB, SSAS and OLAP, Transact SQL, VB.Net, ASP.Net, C/C++, SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export Data, BIDS Studio, SQL Server Reporting Services (SSRS)

Professional Experience:

Client:

Nova Southeastern University, FL Aug 2015 - Nov 2015

Role: Project Intern

Responsibilities:

Developed SQL scripts to Insert, Update and Delete data in T-SQL database tables in OLTP environment.

Created SSIS Packages, which contained different transformations and tasks.

Responsible for creating and maintaining SQL/UNIX databases.

Developed enormous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.

Created Tables, Views, Functions, Stored Procedures and Triggers using the SQL Server Management Studio.

Implemented Clustered and Non-Clustered Indexes, maintained database size and fragmentation levels in order to increase the performance of SQL Queries.

Improved data load performance by analyzing the database design and query plans and is responsible for the Performance Tuning of the queries.

Developed and optimized Stored Procedures using input, output, table valued parameters and Query Analyzer.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy Lookups, Lookups.

Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multicasting.

Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Responsible for creating/migrating undocumented crystal/SSRS reports.

Created Cross-Tab, Drill-down, Drill-through, Parameterized and Sub-Report using SSRS.

Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.

Experience in managing automated Data Flow, Control Flow, Events and Logging programmatically using Micrsoft.Net framework for SSIS packages.

Client:

Levonsys, Hyderabad, TG Jul 2013 - Jul 2014

Role: SQL Server Developer

Description: Levon Systems is a Domestic IT consultancy dedicated to using the Microsoft platform to help enterprises achieve profitable growth. Through proven solutions that extend Microsoft products, Levon Systems helps enterprises increase revenue, reduce costs, and reinvest in innovation to gain competitive advantage.

Responsibilities:

• Developed Logical and physical data model using ERWIN and mapped the data into database objects.

• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.

• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

• Optimized the database by creating various clustered, non-clustered indexes and indexed views.

• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.

• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse

• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.

• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.

• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

• Problem identification, troubleshooting, resolution, and index tuning databases.

• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.

• Created Alerts for successful or unsuccessful completion of scheduled Jobs.

• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SSIS, SSRS, MS SQL Server 2008/2005, C#, Visual studio 2008, MS Access, MS Excel, MS Office Access 2007

Client:

BSNL-RTTC, Hyderabad, TG April 2010 – April 2013

Role: Intern (SQL Developer)

Description: Bharat Sanchar Nigam Ltd. took over the business of providing of telecom services and network management from the erstwhile Central Government Departments of Telecom Services (DTS) and Telecom Operations (DTO) and has installed Quality Telecom Network in the country & now focusing on improving it, expanding the network, introducing new telecom services with ICT applications in villages & winning customer's confidence.

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.

• Configured and monitored database application.

• Created tables, indexes and constraints.

• Defined stored procedures for module integrity and application.

• Wrote database triggers in T-SQL to check the referential integrity of the database.

• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

• Managed the use of disk space, memory and connections.

• Designed and implemented several complex reports and administration modules.

• Designed VB forms using the forms and crystal reports were made for business reporting purpose.

• Involved in performance tuning of the database and T-SQL queries using Explain Plan.

• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.

• Prepared of project documentation.

• Prepared test plans for assembly testing & System Integration testing.

Environment: SQL server 2000, Visual Basic 5.0, Win NT, Crystal Reports 8.0

Educational Background:

Masters in Computer Science – Nova Southeastern University, Florida.

Bachelors in Information Technology- P.Indra Reddy Memorial Engg. College, JNTUH, India.

Contact this candidate