Sql Server Data
Resume:
[pic]
Girish
312-***-****(Cell)
******.*****@*****.***
SQL SERVER BI DEVELOPER
* Above 8 years of SQL experience with over 4 years of extensive
experience in SQL Server Suite of products (SSRS/SSIS/SSAS) and
involved in all phases of Software Development Life Cycle from
gathering requirement, development, implementation, testing and
support.
* Experience in MS-SSRS, SSIS, SSAS, OLTP, OLAP, Slowly Changing
Dimensions, Data Cleansing and Data Migration.
* Good Knowledge of data warehousing techniques and standards.
* Extensively worked on Erwin Data Model Tool and good knowledge of
Relational Database Modeling/Loading and Dimensional database modeling
concepts.
* Analyzed, designed, created, implemented and supported various
business application with WebFOCUS and worked in migration
* Experience in High Level Design of ETL Packages for integrating data
using OLE DB connection from heterogeneous sources (Excel, CSV,
Oracle, flat file, Text Format Data) by using multiple
transformations.
* Created user interface using Resource Layout and publish reports with
Report Caster.
* Proficient in Data migration between homogeneous/heterogeneous systems
and SQL Server using Integration Service (SSIS), BULK INSERT, DTS
Import/Export utility, and Bulk Copy Program (BCP).
* Used Lookups Transformation to get the data from reference data
sets.
* Scheduling the SSIS packages and Jobs.
* Specialized in creating several reports such as drill down reports,
parameterized reports, linked reports, sub reports, Matrix Reports,
Charts using SQL Server Reporting Services.
* Created email subscriptions for data driven reports by using Report
Manager.
* Used Report Manager to assign roles, permissions and to create report
schedules.
* Experience with Ad-Hoc reporting using Report Builder in SSRS for
daily reports.
* Expertise in designing/creating several reporting services reports
that have been formatted specifically for dashboard displays, i.e.
with charts, KPIS, tables, etc
* Used Performance Monitor/Profiler to solve dead locks/long running
queries.
* Worked on analyzing and performance tuning queries by looking at Query
Statistics and Execution plans.
* Experienced in managing Alerts, Operators and Jobs through SQL Server
Agent.
* Experience in writing complex SQL queries involving multiple table
inner and outer joins, temporary tables, table variables.
* Experience in Designing, Developing and Maintaining Web Applications
using Visual Studio .NET, ASP.NET, C#, VB.NET, ADO.NET.
* Defined Indexes to implement business rules.
* Experienced in Visual SourceSafe version, TFS, control system product
that delivers restore point and parallel collaboration capabilities,
thus allowing application development organizations to work on several
versions of software simultaneously
* Strong technical knowledge in Troubleshooting and Performance tuning.
* Created views to facilitate easy viewing implementation.
* Experience in creating indexed views, complex stored procedures,
effective triggers, and useful functions to facilitate efficient data
manipulation and consistent data storage.
* Experience of working with huge databases (size>5 M rows).
* Hands-on experience in debugging stored procedures to optimize
performance
* Assisted in restoring and updating the production database into
development and QA environment for testing various stages of
monitoring the queries.
* Experienced in creating front end application bridge to ASP.NET based
applications
* Experience in using variables, expressions and functions for the
reports.
* Dealt with huge amount of data and used SSAS in order to retrieve the
data.
EDUCATION
Bachelor of Technology in Computer Science and Engineering, JNTU,
Hyderabad, India
CERTIFICATIONS
. Microsoft Certified Technology Specialist in SQL Server 2008.
. Microsoft SQL Server 2008, Business Intelligence Development and
Maintenance.
TECHNICAL SKILLS
Hardware: Dell Servers, HP Servers
Database: SQL Server 2000/2005/ 2008, MS Access, Oracle
9i, 10g
Operating Systems: Windows XP/2000/2003, UNIX
Programming Languages: T-SQL, HTML, C#, ASP.Net
BI Suite: SSRS, SSAS, MOSS 2007 Dashboard
ETL TOOLS: SSIS, Data Stage, DTS, Informatica Power Center 7.0
Database Tools: Toad for SQL Server 4.6
Modeling Tools: Erwin (4x, 7x)
Professional Experience
Protective Life Insurance, Birmingham, AL
April'12 - Till Date
SQL Server & SSIS / SSRS Developer
Responsibilities:
. Performed Server installation and configuration using SQL Server
2005/2008
. Written SSIS packages in 2005 and did conversion of DTS packages from
2005 to 2008
. Resolved complex issues and Error Handling in SSIS.
. Created and scheduled SSIS packages to pull data from SQL Server and
exported to various data sources like Excel Spreadsheets, Flat File etc
and vice versa.
. Created and scheduled SQL jobs to run SSIS packages on a daily basis
using MS SQL Server Integration Services (SSIS).
. Used various control flow tasks like FTP, Bulk insert task, Transfer job
task etc and different data flow tasks.
. Created complex stored procedures, Triggers and user defined functions
using joins and cursors as required for SSIS packages.
. Completed left over tasks in other projects which includes sending
invoice emails, modified excel files before loading them to database.
. Deployed SSIS packages and tested them on Model Office.
. Worked on SSIS script task, look up transformations and data flow tasks
using T- SQL and Visual Basic (VB) scripts.
. Worked on SSIS performance tuning using counters, error handling, event
handling, re-running of failed SSIS packages using checkpoints
. Developed cubes using Partitions, KPI's, and Perspectives, slow moving
dimensions etc and created various user roles.
. Expertise in ETL techniques using Informatica Power Center 7.x, 8.x,
Stored Procedures to Extract and Transform data from various data
sources and Load to the Transactional/Dimensional Databases
. Generated Report Models using Model Designer, to enable the business
users to build ad-hoc reports using Report Builder.
. Involved in designing reports and delivering them by any of the delivery
methods like standard subscriptions, data-driven subscription, URL access
etc.
. Analyze user requirements, functional and technical specifications,
preparing test plans.
Environment: SQL Server 2005/ 2008, Visual Studio
2005/2008,SSRS,SSIS,SSAS,/DTS, Visual SourceSafe, Enterprise Manager, Query
Analyzer, SQL Profiler,Active Directory and Windows 2003, .NET Framework
2.0, VB Script
Vertrax, Connecticut, CT
Oct'11 - March'12
SQL Server / SSRS Developer
Responsibilities:
. Good knowledge of Relational Database Modeling/Loading and Dimensional
database modeling concepts.
. Worked with excel reporting and writing VBA script for automation.
. Individually designed MS SQL Server 2008 database, coded stored
procedures (T-SQL).
. Utilized T-SQL on a daily basis in creating customs view for data and
business analysis.
. Worked with various XML data and worked on creating ETL packages with
loading all package in loop and loading them in SQL server
. Created parameterized reports, Drill down and Drill through reports
using SSRS.
. Worked on formatting SSRS reports using the Global variables and
expressions.
. Created report snapshots to improve the performance of SSRS.
. Created Parameterized reports, Cross-Tab reports, Drill down reports &
Summary reports by
using SSRS and designed reports using Crystal Reports.
. Worked with creating mapping document with business requirements,
source to destination schema mapping along with the ETL logic and
created design documents.
. Created temporary tables and table variables while creating complex
queries in SQL Server 2005/2008.
. Defined Indexes, Views, Constraints and Triggers to implement business
rules.
. Writing complex SQL queries using table joins (inner and outer),
temporary tables, and table variables.
. Interacted with Business user for requirement gathering and write
traceability mapping documents.
. Involved in loading of data into Teradata from legacy systems and flat
files using complex.
. Created Teradata External loader connections such as MLoad, Upsert and
Update, Fastload while loading data into the target tables in Teradata
Database
. Running DBCC consistency checks, and fixing data corruption in
databases.
. Monitoring execution plans to enhance the performance of the queries.
. Ensuring database integrity, indexing, segmentation and recovery and
update database design over time.
. Troubleshooting and Performance tuning using Quest Performance
Analyzer to diagnose historic data as well as current ones.
. Developed indexed views, complex stored procedures, effective
triggers, and useful functions to facilitate efficient data
manipulation and consistent data storage.
. Designing, developing, implementing, and maintaining reporting
frameworks..
. Created SQL Server Profiler traces & used with Database Tuning Advisor
(DTA) for optimum performance of queries.
. Performance Monitoring with SQL Profiler and Windows System Monitor.
. Adept at rebuilding indexes on various tables.
. Optimized the SQLs and Informatica mappings which handled millions of
records
. Adept at debugging stored procedures using SQL Server Profiler.
. Developed various Reports, Customized existing reports according to
the functional
specifications using PowerBuilder Reports 8.0
. Restored QA server from development periodically to test the queries
on the QA server.
. Built SSRS reports from various heterogeneous sources like SQL Server,
Oracle.
. Creating Parameterized Reports, Drill down, Sub-reports using SQL
Server Reporting Services 2008.
. Created reports from various migrated data sources into simple
dashboards for easy reviewing.
. Creating Ad hoc reports using Report Builder.
. Done front end ASP.Net application bridging to the back-end Database
systems.
Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, T-SQL, SSRS,
Dashboards, SSAS, Windows Server 2003, Teradata, PowerBuilder 8.0, C#,
ASP.Net, Oracle 9i, Erwin 7x,Visual Basic 6
State Of Ohio, Columbus, OH
Nov'10 - Sep'11
SQL Server & SSRS/SSIS Developer
Responsibilities:
. Extensively worked on MS-SSRS, SSIS and Slowly Changing Dimensions.
. Adept at rebuilding indexes on various tables.
. Database size exceeded 4 million rows.
. Created SQL Server Profiler traces & used with Database Tuning Advisor
(DTA) for optimum performance of queries.
. Created temporary tables and table variables while creating complex
queries in SQL Server 2005/2008.
. Developed indexed views, complex stored procedures, effective
triggers, and useful functions to facilitate efficient data
manipulation and consistent data storage.
. Running DBCC consistency checks, and fixing data corruption in
databases.
. Monitoring execution plans to enhance the performance of the queries.
. Ensuring database integrity, indexing, segmentation and recovery and
update database design over time.
. Troubleshooting and Performance tuning using Quest Performance
Analyzer to diagnose historic data as well as current ones.
. Writing complex SQL queries using table joins (inner and outer),
temporary tables, and table variables.
. Designing, developing, implementing, and maintaining reporting
frameworks.
. Developed/Monitored ETL packages with different data sources (SQL
Server, Flat Files, Excel files, etc) and loaded the data into target
tables by performing different kinds of transformations using SQL
Server Integration Services (SSIS).
. Successfully deployed SSIS Package into Production environment and
used Package configuration to export various package properties to
make package environment independent.
. Developed Scheduled Jobs to automate the packages.
. Implemented Event Handlers and Error Handling in SSIS packages and
notified process results to various user communities.
. Involved in creation of dimensions using Star, Snow Flake schemas.
. Involved in strategic, planning and budgetary responsibilities.
. Created several MDX queries according to Business requirements.
. Wrote MDX queries and expressions for use in Front End BI Applications
. Built SSRS reports from various heterogeneous sources like SQL Server,
Oracle.
. Creating Parameterized Reports, Drill down, Sub-reports using SQL
Server Reporting Services 2008.
. Created reports from various migrated data sources into simple
dashboards for easy reviewing.
. Creating Ad hoc reports using Report Builder.
. Done front end ASP.Net application bridging to the back-end Database
systems.
Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, T-SQL, SSRS,
Dashboards, SSAS, Windows Server 2003, C#, ASP.Net, Oracle 9i, Erwin
7x,Visual Basic 6
Ameriprise Financial, Minneapolis, MN Jan'09
- Oct'10
SQL Server / Report Developer
Responsibilities:
. Extensive knowledge of loading data from various sources like CSV, flat
files, to SQL Server database using SSIS Package.
. Involved in the creation and enhancements of the reports in WebFOCUS.
. Created indexes, optimized SQL PASSTHRU queries and alter joins to
improve the performance Scheduled the SSIS packages and Jobs.
. Developed, designing and deploying of various complex reports such as
Drill down, Tabular reports, Parameterized, Pie charts using
Expressions, Global variables and Functions in MS Reporting Services.
. Generated of Ad-Hoc reports as per the client requirements using Report
Builder.
. Successfully created Snapshots Report, Report Subscription, Data Driven
Subscription and Report caching using Report Manager
. Developed complex SQL queries involving stored procedures, cursors,
triggers, table inner and outer joins, temporary tables, table
variables.
. Developed effective triggers, and useful functions to facilitate
consistent data storage.
. Done Performance tuning for stored procedures and optimizing SQL Server
performance using SQL Server Profiler
. Involved in monitoring the execution plans of the queries to pre access
the resources being used by the queries.
. Created indexes to pull up patient contact information and get the
related insurance information for the patient.
. Billing patients insurance and other third party carriers for charges
per company/division usual and customary charge or special approved
contract or Letter of Agreement pricing.
. Monitoring/tracking/correcting billing errors and ensures corrected
invoices are processed to ensure correct billing and collections.
. Maintaining and monitoring follow-up on accounts receivable status and
identifies/pursues collection of past due accounts. Provided management
with information on the status of accounts on a monthly and/or as needed
basis. Responded to billing\invoice inquiries from branch offices,
insurance companies and patients. This is Oracle based financial data.
. Processed requests when insurance carriers request additional
information.
. Analyzed each patient and/or client's outstanding accounts receivable
and processes claims to obtain maximum reimbursement.
. Clearing payment variances, resolving differences, and initiating
corrective action.
. Identified and communicate system updates to ensure accurate processing
and timely collections.
. Identified denial trends and present issue and solutions to management.
Environment: WebFOCUS 7.x,5.3.4, Developer Studio, Reports Caster, SQL
Server 2005/2008 Enterprise Edition, T-SQL, SSRS, SSIS, SSAS, Windows
Server 2003, Oracle 9i, Erwin 7.1
CHMACK, Cincinnati, OH
Sep'07 - Dec'08
SQL Server Developer/ BI Developer
Responsibilities:
. Created complex SQL codes using Views, temporary tables, triggers and
stored Procedures.
. Expertise in tuning T-SQL procedures, triggers and other database
objects.
. Expertise in designing DTS packages to transfer data from
heterogeneous database & different files format (Text File, Spread
Sheet) to SQL Server.
. Designed and developed DTS packages for transferring data from flat
files and Access files.
. Experienced in various stages of SDLC, which includes requirement
gathering, analysis, design, development, Implementation.
. Upgrade enhancements, maintenance, support and bug fixing for the
product.
. Involved in converting SQL Server 2000 DTS packages to SQL Server 2005
SSIS packages.
. Created various packages for performing ETL process using SSIS.
. Programmed SQL Server 2000 Reporting Services using Microsoft Visual
Studio 2003.
. Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server
2005.
. Created database objects for improving the performance.
. Fine-tuned Procedures, Functions and Triggers for optimum performance.
. Involved in creating SQL reports.
. Created cubes and dimensions using SSAS.
. Maintained all SQL documents including installation and data
conversion Procedures, standard security documents, etc.
. Developed SQL Queries to fetch complex data from different tables in
remote databases using joins, database links and formatted the results
into reports and kept logs.
. Conducted database management, performance measurement and performance
tuning for new databases and existing databases by using SQL Profiler,
SQL Analyzer, and SQL Enterprise Manager.
Environment: T-SQL, SQL Server 2000, Windows 2000 Server, Query Analyzer,
MS Access 2000, Oracle, DTS, OLAP Services, Erwin Data Modeler.
Metavante Inc, Ann Arbor, MI
June'06 - Aug'07
SQL Developer
Metavante is the world's top-ranked technology provider to the banking
industry. With more than 24,000 experts in 100 countries, Metavante
delivers the most comprehensive range of solutions for the broadest range
of financial markets, all with a singular focus: helping you succeed. Every
Metavante solution has the strength you need for profitability today, and
the power to help you manage whatever comes next.
Responsibilities:
. Actively participated in interactions between users, team lead, DBAs
and technical manager to fully understand the requirements of the
system.
. Worked on Erwin Data Model Tool and good knowledge of Relational
Database Modeling/Loading and Dimensional database modeling concepts.
. Worked on SSIS for transferring data from Heterogeneous Database
(Access database and flat file data) to SQL Server.
. Worked on different kinds of transformations in SSIS as per the
client's Requirement
. Created report modules to provide interactive reports to the users (MS
SQL Server 2005/2008).
. Generated Monthly and quarterly Reports in the form of bar chart
reports for the management using different techniques like Drill down,
Tabular reports, Matrix reports, List reports, Parameterized, Pie
charts, Graphs,Linked Reports, Drill Through using Expressions,
Global variables and Functions.
. Successfully deployed reports to report server using SSRS 2005/2008.
. Designed and architected of OLAP cubes to support business reporting
and forecasting processes.
. Enhancing and deploying the SSIS Packages from development server to
production server.
. Designed high level ETL architecture for overall data transfer from
the source server to the Enterprise Services Warehouse which
encompasses server name, database name, accounts, tables and direction
of data flow, Column Mapping, Data dictionary and Metadata.
. Advanced extensible reporting skills using SQL Server 2005 Reporting
Services (SSRS).
. Played a major role in the production support of SSAS cubes and SSIS
jobs
. Performance tuning of SQL queries and stored procedures using SQL
Profiler and Index Tuning Wizard.
. Extensive knowledge in SQL Server optimization using SQL tools such as
SQL Profiler, Index Tuning Wizard, DBCC commands, Statistics.
Environment: MS SQL Server 2005/2000, SSIS, SSRS, SSAS, T-SQL, Windows 2003
Server
Suzikem Drugs, Hyderabad, India
June'04 - Apr'06
SQL Programmer
Responsibilities:
. Created new views, wrote stored procedures for Application Developers
and some user defined functions.
. Created SQL scripts for tuning and scheduling.
. Performed data conversions from flat files into a normalized database
structure.
. Created Triggers to enforce data and referential integrity.
. Defined Check constraints, Business Rules, Indexes, and Views.
. Configured Server for sending automatic mails to the respective people
when a DTS process failure or success.
. Worked on DTS Package, DTS Import/Export for transferring data from
Heterogeneous Database (Oracle and Text format data) to SQL Server.
. Data migration (import & export - BCP) from Text to SQL Server.
. Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and
Networking).
. Performance tuning of SQL queries and stored procedures using SQL
Profiler and Index Tuning Wizard.
. Performed development support, document reviews, test plan,
integration of the system.
. Creation/ Maintenance of Indexes for fast and efficient reporting
process.
. Managing historical data from various heterogeneous data sources (i.e.
Excel, Access).
. Programmed SQL Server 2000 Reporting Services using Microsoft Visual
Studio 2003.
. Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server
2005.
. Created database objects for improving the performance.
. Fine-tuned Procedures, Functions and Triggers for optimum performance.
. Involved in creating SQL reports.
Environment: SQL Server 2000, T-SQL, Erwin, TOAD.
Contact this candidate