Sql Server Developer
Resume:
Summary:
. Over * years of IT experience, which includes, Analysis, Design,
Development,
Testing, Implementation experience using MS SQL Servers 2008/2005/2000,
SSIS / SSRS
. Good knowledge of various states of System Development Life Cycle
(SDLC)
. Good Knowledge of SQL database design, architecture and data
modeling(Physical and logical)
. Experience in working with Windows 2000/2003 servers
. Excellent backend skills in creating SQL objects such as tables, stored
procedures, views, indexes, triggers, user defined functions
. In-depth knowledge in design and normalization of database tables
. Designed DDL, DML statements for MS SQL Server 2000/2005
. Expertise in software analysis, design, and development of applications
including providing Business Intelligence solutions using SQL Server
Business Intelligence Development Studio with tools such as SQL Server
integration services(SSIS),and SQL Server Reporting Services ( SSRS)
. Experience in developing ETL packages using SSIS including
transformations
. Experience with SSIS performance tuning using counters, error handling,
event handling, re-running of failed SSIS packages
. Experienced in design and development of reports using SQL Server
Reporting Services (SSRS)
. Good Working knowledge of SQL Server 2005/2008 tools and Visual Studio
. Used Bulk Copy Program (BCP) extensively for flat file import and export
operation to/from SQL Server
. Experience in Performance Tuning, Query Optimization, Client/Server
Connectivity, restore and backup
. Understanding of various source transformations, including flat files,
XML and relational systems
. Performed database health checks using SQL profiler, performance
monitor, performance counters and DBCC commands
. Management of users including creation/alteration, grant of system/db
roles and permissions on various database objects
. Knowledge in Clustering, Data Modeling (Physical and Logical) Using ERWIN
. Experience in Scheduling Jobs, Sending Alerts using SQL Mail
. Good team player, strong interpersonal and communication skills
combined with self-motivation, initiative and the ability to think
outside the box
Education & Certifications:
. Bachelors in Electrical and Electronics
. Diploma in Information Technology
Technical Skills:
Databases SQL Server 2005, 2000 & 7.0, MS-Access 2000, ORACLE 11i
Database Tools Management Studio, Enterprise Manager, Query Analyzer, SQL
Server Profiler, SSIS,, SSRS, DTS, BCP,MS Access Business
Intelligence Development Studio)
Languages .net
OS Windows 2003 Enterprise, Windows 2000 Datacenter, Windows
NT & XP
Web Servers IIS 5.0
Other Tools Erwin, Microsoft Visual Studio 2003/2005, Microsoft Visio
Architecture Relational DBMS, Client-Server Architecture, OLTP
Professional Experience:
C4 Reporting, Seattle, WA
May'08- Till data
Senior SQL Server Developer
The main objective of C4 Reporting project is Extracting, Transforming and
loading the data from the XML source files into OLTP tables C4 Reporting
will utilize Background Intelligent Transfer Service (BITS) for
transferring data from EK servers to MS servers.
The source feed files would be extracted and loaded into the database
staging layer by a set of ETL packages developed using SQL Server
Integration Services 2005 (SSIS 2005) after that the required
transformation data would be loaded into reporting DB. The data would be
stored in the XML format in separate files under a folder with the date
format.
Responsibilities:
. Actively participated in gathering Business Requirements and System
Specifications
. Thorough understanding of physical database design for constraints and
data types for figuring out the sequence for modification (insert,
update, delete) of data in various tables
. As a developer created complex Stored Procedures, tables, views and
complex SQL statements for applications
. Made recommendations to design, build and tune large transactional
databases for core business applications and development
. Created stored procedures, user defined functions, triggers to handle
complex business rules, history data and audit analysis
. Created jobs for database backups, transaction backups using SSIS
packages
. Tuned database applications using SQL profiler and modified complex
queries
. Used SQL Server 2005 tools such as SQL Server Management Studio, SQL
Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor for
day to day tasks including backup and restore
. Made recommendations for index creation, index removal, index
modification, file group modifications, and adding scheduled jobs to re-
index and update statistics in databases for better performance
. Expertise in rebuilding indexes at regular intervals
. Performed day to day tasks such as viewing error log, trouble shooting
client connections and applications
. Did transformations to cleanse and filter duplicate values in tables
using SSIS
. Created SSIS packages for extracting data From XML to SQL 2005
. Generated different types of reports (Tabular/Matrix) using SSRS
. Generated Daily, Weekly and Monthly reports (parameterized and cascading
parameterized) for the analysis by managers and end users
. Developed Master/Details Reports and Tabular Reports based on user
requirement from OLTP databases using SSRS
. Created reports on OLTP database using SSRS (T-SQL, Stored Procedures,
and Report Builder)
. Created ETL packages using SSIS objects
. Expertise in creating users and assign logins and permissions on specific
databases objects
. Worked on testing the databases for performance using spotlight
Environment: SQL Server 2005, Windows Enterprise Server 2003, IIS 6.0,
Erwin 7.2, SSIS [SQL Server Integration Services], SSRS [SQL Server
Reporting Services], OLTP.
Marathon Petroleum Corporation,India Jan 08 - March 2008
Senior SQL Server Developer
The Coast refers to contract and Sales Tracking. This data warehouse
currently was designed using Activex and DTS packages. This project is to
convert DTS related functionality, VB script and SQL Queries to SQL server
2005 ETL process and extract the data using SQL server Stored procedure.
Responsibilities:
. Performed analysis on the requirements of the project given by the
manager.
. Interacted with developers on various aspects ranging from usage of
utilities to SQL performance, test data and general troubleshooting and
performance issue
. Created Schema for upgrading database.
. Manually Modified Stored Procedure according to ANSI Standard (join
syntax, for locking hints, order by etc).
. Estimated the work effort to convert the DTS packages into SSIS
. Installed and Configured SQL Server 2005.
. Successfully migrated database from SQL Server 2000 to SQL Server2005
. Manually tested the modified stored procedures after converting the same
in 2005 environment to compare the results and estimate the runtime
. Performed Performance tuning on Modified SQL queries and stored
procedures using SQL profiler and Index tuning wizard
. Created views as required by front end developer for easier
implementation on web pages, and triggers on those views to provide
efficient data manipulation
. Defined check constraints, rules, indexes and views based on business
requirements.
. Scheduled and maintained routine Jobs, tasks, alerts and database backups
on weekly and monthly basis.
. Upgraded exiting complex DTS packages to corresponding SSIS by using
tools by using integration services Data Flow Transformation like
Transfer database Task, Transfer object task, Execute SQL Task, and
Export Column, Union All, Merge join, Sort, Fuzzy Lookup
transformation consecutively
. Created SSIS packages for extracting data From Excel, flat files, MS
access to SQL 2005
. Generated monthly reports on sales information and Performance for
various categories and regions based on business needs using SQL Server
Reporting services.
. Develop Custom view and scripts for Report Designer to design reports for
Data Warehouse reports
. Developed reports from basic tabular to parameterized reports include
Single/Multi/Boolean value parameters and linked reports.
. Unit testing of each and every Stored Procedures and Functions for
accuracy and documented all the processes for later easy reference.
. Prepare user manual and technical reports that contain all the migration
process for the other developers.
Environment: SQL Server 2005, Windows Enterprise Server 2003, IIS 6.0,
Erwin 7.2, SSIS [SQL Server Integration Services, OLTP
The Markets,India July 06 - Jan 08
Senior SQL Server Developer
TheMarkets.com delivers unprecedented access to the premier real-time
research, earnings models, and full website content and Quantitative tools
of their eleven Member Firms, plus US equity deal coverage and research
from over 850 global contributors Covering 16,000 companies worldwide.
TMC is an aggregator of information. They get the information from Rest of
street .TMC can publish its own document. Client Firms on recommendation of
member firms will interact with TMC docs. When the API's are called the
data is returned in xml format and using stored procedure the value in xml
elements are pushed in the tables. Reports are generated using reporting
Services
Responsibilities:
. Design of Database done using Erwin
. Requirements analysis and Designing
. Involved in writing procedure for Reporting Module using XQuery/XPath
. ETL Design and Preparing Technical Specification
. DBA activities-creating the database, running the DML statements, stored
procedures using the batch files, validating the queries and the data,
clearing the log files, taking backup and restoring the database,
monitoring the locks etc.
. Using SSIS package we were migrating the CIQ details after hitting the
CIQ API ie v5 database- CIQ(capital IQ) and again from CIQ(capital IQ)
back to V5
. Development of ETL Mappings to load data into the Datawarehouse
. Testing and debugging of all relevant programs
. Writing Windows batch scripts
. Scheduling of SQL server job to trigger the
. Performance tuning of SQL server database(Queries)
. Involved in testing the ETL application
. Involved in training the team on SQL server Reporting Services
Environment: SQL server Integration Services(SSIS),Windows Batch files
Erwin,SQL server Management studio
Metropolitan Life Insurance Company (MetLife),India July 2005 -
June 2006
Senior SQL Server Developer
SmartApp application provides new business processing and reporting
features for MetLife Home office employees and agents of different
franchises. The application is also used as the underwriting system for
Annuity Contracts.
Responsibilities:
. Expertise in entire project life cycle including database Design,
Development, Testing, Optimizing, deploying on development and
production servers
. Actively Expertise in Normalization of database
. Created and managed schema objects such as Tables, Views, Indexes,
Stored Procedures, Clusters, Triggers and maintaining referential
integrity
. Expertise in performance tuning of TSQL queries and Stored Procedures
. Wrote T-SQL statements for retrieval of data
. Expertise in writing SQL batch scripts.
. Created joins and sub-queries for complex queries involving multiple
tables
. Used DDL and DML for writing triggers, stored procedures, and data
manipulation
. Performed daily database backup & restoration and monitored the
performance of Database
Server.
. Optimized query performance by creating indexes.
. Trouble shooted the problems by using SQL server profiler.
. Pro actively identified the problems before user complaints.
Environment: SQL server 2000
Support of Data Management for Bombay Stock Exchange (BSE),India Jan 05
- June 05
SQL Server Developer
This project involves the complete database maintenance/support activities
for the Bombay Stock Exchange (BSE). Stock Buyers/Brokers can log into the
system and can study/know about the history of the corresponding
stock/company before buying any stock to know the Stock trend. This is a
three Tier architecture .This project is involved in displaying the day to
day report of various transactions done by the Brokers on behalf of dealer
or clients with the exchange. This also involves creating trading id for
trading by the clients
Responsibilities:
. Involved in writing up the critical stored procedures/triggers.
. Designing the front-end using ASP
. Using JavaScript - validations are done for the HTML user interface
controls.
. Implemented customizable web pages based on user preferences using
HTML/JavaScript and calling the procedures through server side pages
and interacting with database
. Writing test cases for the complete application
. Fixing the Bugs after testing
. Generation of Reports in ASP
. Supporting the customers for the maintenance of the product
. Writing Function Specification Design for the application
Environment: : ASP, JavaScript, HTML, SQL Server 2000.
PL Report Generation,India Sep '03-Jan
'05
SQL Server Developer
This project involves creating reports by interacting with oracle database.
This had two modules. Admin module and report module. In Admin module the
password and login check was done. To keep a track of the no of attempts
done by a client with application to open the application .Admin module
was interacting with SQL database but the report module was interacting
with oracle database. This is a Three tier architecture .Validations are
done using JavaScript . Front end design using ASP and Backend using SQL
server and Oracle
Responsibilities:
. Involved in writing up the queries using Oracle
. Designed the screens and implemented order entry and product catalog
web pages for dynamically generating content using Active Server
Pages.
. Using JavaScript - validations are done for the HTML user interface
controls.
. Implemented customizable web pages based on user preferences using
HTML/JavaScript and calling the procedures through server side pages
and interacting with database in admin module
. Writing test cases for the complete application
. Fixing the Bugs after testing
. Maintaining of Data
. Supporting the customers for the maintenance of the product
. Generating Reports in asp
. Writing FSD for the application
Environment: ASP, JavaScript, HTML, Oracle
Contact this candidate