Docstoc

Ravi_Certified SQL BI Developer

Document Sample
Ravi_Certified SQL BI Developer Powered By Docstoc
					                                                V RAVI
                                          ravi.vsql@gmail.com
                                           Ph: (214)-218-7853
SQL Server/SSIS, SSAS, SSRS Developer

Summary

    7+ years of IT industry experience with Microsoft SQL Server 2000/2005/2008, SSIS/SSRS/SSAS in
     OLTP and OLAP (Data warehousing) environments.
    Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming
     using DDL, DML, DCL commands for various business applications.
    Hands on experience with Performance Point Server, ProClarity, Business Scorecard Manager (BSM).
    Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various
     business applications.
    Experience in Error handling and debugging coding issues and troubleshoot production problems.
    Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed
     Views, Functions, CTE’s, Table Variables and Stored Procedures.
    Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor,
     DBCC Commands, DMV’s, DMFs and Query Execution Plans.
    Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating
     packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities.
    Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy
     Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
    Experience in conversion of packages from legacy systems (DTSSSIS) and migrating, deploying the
     packages across Dev/UAT/Prod environments.
    Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data
     Mining Models and Deploying and Processing SSAS objects.
    Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP
     and SMTP.
    Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-
     Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
    Integration of SSRS Reports using various web parts into Sharepoint (MOSS 2007) and various delivery
     mechanisms.
    Worked with end users/customers to understand business requirements, recommended technical
     solutions and documented functional requirements.
    Also having good hands-on experience with C#.Net,VB.Net
    Excellent analytical/Communication Skills, Team Play and very much result Oriented.
    Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional
     Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
    Good understanding of Normalization /De-normalization and database design methodology.
    Strong Applications Development experience with back-end databases such as SQL Server, Oracle and
     MS Access using ADO/ADO.NET, OLEDB, ODBC and SQL client.
SKILLS:-

Operating Systems                 Windows NT/95/98/XP/2000/Server 2003, UNIX 4.0
Databases:                        MS SQL Server 2000/2005/2008/2008 R2, Oracle 8i/9i, MS Access
ETL Tools:                        DTS (Data transformation services),SQL Server Integration Services(SSIS)
Database Tools:                   SQL Profiler, SQL Query Analyzer, Management studio Index Analyzer, DTS
                                  Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts,
                                  SQL Jobs, Visual Source Safe.
Skills and Languages              Transact SQL (T-SQL), PL/SQL, C, C#, VB Script, .Net
DB Modeling Tools                 MS Visio, Erwin
Reporting Tools:                  SQL Server Reporting Services (SSRS), Crystal reports 8.0/9.0/10.0,MS
                                  Excel.



PROFESSIONAL EXPERIENCE:

International Game Technology (LasVegas,Nevada)                                (July 2011 – Present 2012)
BI Developer(SSIS,SSRS)

International Game Technology is a Nevada based company specializing in the design, development,
manufacturing, sales and distribution of gaming machines and network system products internationally, as
well as online and mobile gaming solutions for regulated markets.

       Responsibilities:

    Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2000/2005/2008.
    Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best
     execution plan.
    Created User Defined Functions to encapsulate frequently and commonly used business logic making
     the system more modular, secured and extensible.
    Defined Check constraints, Business Rules, Indexes, and Views.
    Worked with Exception handling with @@error and with Try/catch.
    Designed SSIS Package for extracting data from heterogeneous source systems, transform and load
     into the Staging Data base.
    Created projects to transfer data from MS Excel to SQL Server in SSIS.
    Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS.
    Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
    Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into
     SQL server Database.
    Extensively used Derived column transformation for data conversion.
    Created packages using script task, containers to logically execute the SSIS package to improve
     performance and execution time.
    Worked on data cleansing techniques using look ups, conditional split, and fuzzy lookup.
    Handling the errors during data moving and Sequencing the task as per requirements.
    Created SSIS Packages for Incremental Loading and slowly changing dimensions.
    Developed Query for generating drill down and drill through reports in SSRS 05/08.
    Uploaded reports on to the report manager and organized them into folders.
    Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
     Designed and implemented stylish report layouts.
    Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.
    Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored
     procedures and queries to create data sets for reports.
    Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of
     SharePoint with SSRS.
    Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis
     Services (SSAS) for analyzing purpose.
    Created Development and Production support documents.

       ENVIRONMENT: MS SQL Server 2008/2005/2000/7.0, Windows 2003, SSMS, Business Intelligence
       Development Studio(BIDS) 2008/2005, Erwin, MS Visual Source Safe, MS-Visual Studio, Team
       Foundation Server.


Citrix Systems (Fort Lauderdale ,Florida)                                               (Jan 2011 – June 2011)
BI Developer(SSIS,SSRS)

Citrix Systems, Inc. is a multinational corporation that provides server and desktop virtualization, networking,
cloud computing technologies including Xen open source products.

      Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
      Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2.
      Continuously interacted with Business Analysts and end users to gather business requirements.
      Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
      Developed processes to extract the source data and load it into the data warehouse after cleansing,
       transforms and integrating.
      Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
      Created SSIS Packages for Incremental loading and slowly changing dimensions.
      Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using
       multi-dimensional models such as Star Schemas and Snow Flake Schema for developing CUBES using
       MDX.
      Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for
       the data mart.
      Extensively involved in designing the SSIS packages to export data of heterogeneous data (like XML,
       Excel, CSV, PGP, Flat file) source to staging tables in SQL Server Database.
      Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split,
       Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate
       underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS
       Access and CSV files to data warehouse.
      Developed Tablix Reports, Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc
       reports using SQL Server Reporting Services (SSRS).
      Created Tabular, Charts and graphs as per customer requirements Using SSRS.
      Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
      Designed and created Report templates, bar graphs and pie charts based on the financial data.
      Worked on Dashboards using SSRS.
      Deployed reports on Microsoft office SharePoint (Moss).
       Environment: MS SQL Server 2008/2008 R2, MS SQL SSRS 2008, SSIS 2008


Rack Space Hosting(San Antonio,TX)                                                  (Aug 2010 – Dec 2010)
BI Developer(SSIS,SSRS)

Rack Space is a global web host known for their high end managed hosting and dedicated services. The
company delivers enterprise-level managed services to businesses of all sizes and kinds around the world.

Responsibilities:-

    Created DTSX Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
    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.
    Created and scheduled SQL jobs to run SSIS packages on a daily basis.
    Configured the loading of data into Slowly Changing Dimensions using Slowly Changing Dimension
     wizard. Also implemented checksum SCD method to load the data into date warehouse.
    Experience in creating complex SSIS packages using appropriate control and data flow
     elements with SSIS Standards like error handling, logging and working with package config files.
    Hands on experience in using different transformations like data Conversions, lookups, derived
     column transformations etc, for data cleansing to remove unnecessary columns,
     eliminate redundant, inconsistent data and unnecessary Data like removing empty rows using SSIS.
    Created DTS (SSIS) packages to get data from various sources (mainframe, Informix, Oracle).
    Created Tablix reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-
     hoc reports, Drill down reports as well as interactive reports according to business requirements in
     time restricted environment.
    Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter
     driven, formulas, summarized and conditional formatting) using SSRS.
    Created Jobs Performance report that queries sys tables and shows how long each job ran and weekly-
     average duration using SSRS.
    Developed Stored Procedures and Views to be used to supply the Data to the Reports. Complex
     formulas were used to show derived fields and to format the data based on specific conditions.
    Maintenance and provide support to the users for the deployed reports.
    Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
    Created Development and Production support documents.
    Developed Query for generating drill down reports in SSRS 2005/2008.
    Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code
     and SQL joins for applications.
    Generated Reports using Global Variables, Expressions and Functions for the reports.
    Created subscription to reports.
    Used ETL (Extraction, Transformation, Loading) from heterogeneous source systems. Assisted DBA in
     using the repository manager to give permissions to users to create new users and repositories.

Environment: MS SQL Server 2005/2008, MS SQL SSRS, SSIS, Visual SourceSafe, Windows 2003 serve


Progressive Insurance (Mayfield Village, OH)                                        Sep ’09-July2010
SQL Server/BI Developer
Progressive Insurance is an Auto Insurance Company. They have both the development and production
environment, my duties focused on maintaining, and optimizing the existing databases; designing and
implementing new databases for various projects according to the requirements from clients; monitoring
database performance and growth, performance tuning, establishing and administering database security in
development, testing, and production environments
       .
Responsibilities:

    Implemented Complex business logic with User-Defined-Functions, Index, Views and also created
     User Defined Data type, Clustered & Non-clustered Indexes.
    Design/Build Extract Transform Load procedures in SQL Server 2000/2005/2008 using DTS packages to
     import/export data feeds to/from data warehouse and claim systems.
    Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and
     Views using T-SQL in Development and Production environment for SQL Server 2000/2005/2008.
    Participated in migration from SQL Server 2005 to SQL Server 2008.
    Analyze, tuning and optimizing for SQL Server Applications by using performance monitor.
    Excellent technical and analytical skills with clear understanding of design goals of ER modeling for
     OLTP and dimension modeling for OLAP
    Experience in tuning of Stored Procedures and query optimization to improve the performance and
     eliminate the deadlock situations and hang-ups on server.
    Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated
     members and measure groups.
    Expertise includes Data Analysis, Data Modeling, Data Cleansing, Transformation, Integration, Data
     import, Data export.
    Implemented dimensional data warehouse model using Ralph Kimball and Inmon methodologies.
    Created score cards with advanced set of dashboards using MS Office Performance Point Server 2007
     Dashboard Designer.
    Developed Tablix Reports, Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc
     reports using SQL Server Reporting Services (SSRS).
    Created various complex reports and manage them using SQL Server Reporting Services (SSRS
     2008/2005) according to ERLC.
    Designed and developed Reports in SQL Server 2005 Reporting Services (SSRS).
    Involved in migration and Conversion of Reports from SSRS 2005 to 2008.
    Created SSRS Report Model Projects in BI studio and created, modified and managed various report
     models with multiple model objects, source fields and expressions.
    Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
    Creating Tabular, Charts and graphs as per customer requirements Using SSRS.
    Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and
     send the reports via email.
    Designed and created Report templates, bar graphs and pie charts based on the financial data.
    Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the
     Flat files on monthly and weekly basis.
    Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
    Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle
     using SSIS.
    Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split,
     Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate
     underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS
     Access and CSV files to data warehouse.
    Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data
     Transformation Services (DTS), and Data Stage and ETL package design, and RDBM systems like SQL
     Servers, Oracle, and DB2.
    Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
    Implement SDLC development and acceptance test environments. Establish security best practices.
     Implement T-SQL script based SDLC environment promotion automation.
    Involvement in all stages of development process - high-level design, implementation, testing,
     deployment and support of products adhering to company's SDLC
    Database and Log Backups and restoration, backup strategies, scheduling backups.


Environment: SQL Server 2005/2008, ORACLE,MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server
2000/2003, ASP.NET, VB.NET, BIDS 2005/2008,Visual Studio 2005/2008


PNC BANK, Pittsburgh,PA                                                              Sep’08 – Aug’09
SSIS and SSRS Developer

PNC is a highly diversified and growing financial services organization spanning the retail, business and
corporate markets. The system handles online as well as summarized and intensive search oriented users
totaling four hundred and size hovering around 600 Gigabytes. The clients can also view balances, statements
and transactions anytime. The project involves creating complex ETL packages for heterogeneous data in the
Agency group.

Responsibilities:
    Develop ETL Packages and Reports.
    Create tables, stored procedures when required.
    Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams
      that require the file.
    Served as the primary point of contact for most of the Enterprise Business intelligence design and
      development.
    Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
    Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
    Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help
      of SQL Server 2005, 2008 Integration services.
    Involved in relational database modeling (like designing the tables, algorithmic diagrams for the input
      data (entity diagrams), index's etc.)
    Extensively worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly-
      basis, file-transfers from     one location to other.
    Using FTP and SFTP tasks, Encrypting and decrypting the files using Open PGP task etc.,
    Experience in creating complex SSIS packages using appropriate control and data flow
      elements with SSIS Standards like error handling, logging and working with package config files.
    Hands on experience in using different transformations like data Conversions, lookups, derived
      column transformations etc, for data cleansing to remove unnecessary columns,
      eliminate redundant, inconsistent data and unnecessary Data like removing empty rows using SSIS.
    Created DTS (SSIS) packages to get data from various sources (mainframe, Informix, Oracle).
    Exporting the database from Local server to the remote server and importing the current running
      database from remote server to the local DB Server using SSIS.
    Create Tablix reports,Tabular/Matrix reports based on requirements.
    Create Dashboards using SSRS.
    Modified different packages where the issues (like removing the duplicate records or just updating a
     record and disable the previous records that had different IDs for one person,) rose after the user
     interference.
    Worked with Team foundation server (TFS) offering source control, data collection, reporting, and
     project tracking.
    Integrated TFS with Microsoft Excel for the creation and tracking of project items.
    Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and
     external interface teams over the performance issues and provided solutions.
    Create databases, tables, and fields for data entry, performing database capacity planning.
    Enhancing and deploying the SSIS packages from development server to production server
     and scheduled jobs.
    Supported the production team and other groups outside the team when issues rose in the packages.

Environment: SQL Server 2005/2008, ORACLE,MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server
2000/2003, ASP.NET, VB.NET, BIDS 2005/2008,Visual Studio 2005/2008


Active Health Management, Chantilly, VA                                                 Aug ’07– Sep’08
Senior SQL /BI Developer

Active Health Management is a leading provider of health management services, including disease
management, clinical decision support and personal health records.My responsibilities involved in designing,
implementing, managing and troubleshooting databases for mission-critical business applications. Supported
OLAP, data warehouse and data marts by using various tools and methodologies.

Responsibilities:
    Installation, configuration of MS SQL Server 2005/2008.
    Consistency and Integrity.
    SQL server Upgrade from 2005 to SQL 2008.
    Designing and creation of tables and stored procedures with E-R diagrams.
    Merging 2 different versions of databases to one single database and upgrading to SQL 2008.
    Installation of service packs and security patches.
    Designed and architected of OLAP cubes to support business reporting and forecasting processes.
    Designed the Dimensional modeling of the Data warehouse using Erwin.
    Data Warehousing using Data Transformation Services Package (SSIS).
    Developed processes to extract the source data and load it into the data warehouse after cleansing,
      transforms and integrating.
    Designed OLAP cubes with star schema and multiple partitionsusing SSAS
    Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing
      Dimensions, Hierarchiesand adding the Aggregations to the Cube.
    Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to
      Data Warehouse
    Extensively involved in designing (Logical and Physical) of customer database.
    Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-
      hoc reports, Drill down reports as well as interactive reports according to business requirements in
      time restricted environment.
    Created SSRS Report Model Projects in BI studio and created, modified and managed various report
      models with multiple model objects, source fields and expressions.
    Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
    Wrote and integrated stored procedures to generate the special reportsaccording to client’s need.
    Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in
     Performance Point Monitoring Server 2007, Share point.
    Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for
     web based access for multiple end users.
    Worked with OLAP tool ProClarity.
    Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically
     for any tables, triggers and maintained Referential Integrity.
    Database and log backups and restoration, backup scheduling the backups. Backing up master and
     system databases and restoring them.
    Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
    Managing the use of disk space, memory and connections. Running DBCC consistency checks, fixing
     data corruption in application databases.
    Ensured developers coordinated their efforts in managing and maintaining different application
     databases.
    Eased administrative work through automatic script performing daily/weekly backups.
    Reduced systems downtime risk through automatic offsite backup and recovery over network.


Environment: MS SQL Server 2005/2008, Windows 2003 Server, SQL Query Analyzer, SSIS, TSQL, C#, ASP.NET,
MS Outlook.


Alltel Wireless, Little Rock, Arkansas                                                   Oct’06 – Aug ’07
SSIS,SSAS and SSRS Developer

Alltel is owner and operator of the nation's largest wireless network and has more than 11 million wireless
customers a key member of the Marketing Technologies and development team which provides Information
technology support for Countrywide Marketing by designing, coding and maintaining automation processes.


Responsibilities:
    Performing DTS for data transfer from MS Excel and text file to SQL Server 2000.
    Written DTS Packages to get the data from various heterogeneous databases such as Oracle, Teradata
      and Sybase to SQL Server 2000.
    Created SQL scripts to load data to SQL server from text files.
    Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions,
      KPI’s &MDX Queries using SQL Server 2005 Analysis Services
    Usingmulti-dimensional modelssuch as Star Schemas and Snow Flake Schema for developing Cubes
      Using MDX.
    Used SQL Profiler and Query Analyzer to optimize DTS packagequeries and stored procedures.
    Generated server side T-SQL scripts for data manipulation and validation and created various
      snapshots and materialized views for remote instances.
    Involving in creating and maintaining Database Tables, Views and Constraints.
    Created many complex Stored Procedures and Triggers to audit db logins.
    Created many User Defined Functions.
    Understand user requirements and Data Model defined and developed by the business analysts and
      data architects.
    Created logical and physical data modeling for development database using Erwin Tool
    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 provided day-to-day administration
     tasks like space and log management.
    Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based
     on user inputs.
    Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables
    Responsible for fine tuning of the database, troubleshooting, memory management.
    Reporting with SQL Server: Experience in developing User reports and management reports using Sql
     Server Reporting Services SSRS.
    Scheduled DTS Packages and Involved in data extraction and loading using DTS in MS SQL Server 2000
     and SSIS in MS SQL Server 2005. Import Export data, Bulk Insert and BCP.
    In depth knowledge in SSRS for report generation to create various types of reports.
    Experience in basic and advanced report creation with thorough knowledge of report serving
     architecture.
    Highly Capable in Reports Creation using Report Services MS-SSRS.
    Efficient in creating reports with complex formulas and to query the database for Business Intelligence.
    SQL Integration Services: Highly capable in developing and monitoring DTS and SSIS packages for use
     in regularly scheduled jobs to extract modify or transform data for a variety of purposes.
    Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert,BCP and
     DTS Packages.
    Created DTS packages to transfer objects from development server to production.
    Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks).
    Optimized stored procedures and indexed query using Index Tuning Wizard.
    Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy
     for SQL Servers.
    Setup and Maintained Snapshot Replication across multiple server environments
    Setup and maintained Linked Servers.

Environment:MS SQL Server 2000/2005, Windows 2003/2008, Windows NT 4.0,Visual Basic, ASP, VBScript,
JavaScript, Excel, MS Access, Visio, PowerPoint.


DuPont Pharmaceuticals, Wilmington, DE                                                     Oct 05- Oct 06
MS SQL Server Developer

DuPont Pharmaceuticals is a worldwide business that focuses on research, development and delivery of
pharmaceuticals to treat unmet medical needs in the fights against HIV, cardiovascular disease, central
nervous system disorders, cancer and inflammatory diseases. The company also is a leader in medical imaging.
Responsibilities:
       Performed backup/restore, database objects such as tables, procedures, triggers, constraints,
          indexes and views.
       Used SQL profiler to view indexes performance to mostly eliminate table scan.
       Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on
          complex Business rules.
       Extensively used TSQL to manipulate and architect to produce results for users.
       Used multiple join statements to retrieve data from multiple tables.
       Created stored procedures, views, triggers, user defined functions to incorporate the flow of
          business and called various stored procedures from DTS to make the flow of DTS effective.
       Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for
          performance.
        Created various DTS packages for data transfer and migration.
        Involved in analyzing and designing disaster recovery / replication strategies with business
         managers to meet the business requirements.
        Configured replication servers and transactional replication between production and standby
         server for disaster recovery.
        Responsible for testing to optimize the procedures and triggers to be used in production.
        Involved in project planning also schedule for database module with project managers.

       Environment:
       MS SQL Server 2000, MS Excel, Windows 97/2000/XP, Toad.

Asian Paints India Ltd., Bangalore, India                                                Oct ‘03 – June ’05
MS SQL Server Developer

Asian Paints is India's largest paint company and ranks among the top ten decorative coatings companies in
the world today. The company has an enviable reputation in the corporate world for professionalism, fast
track growth, and building shareholder equity. Asian Paints operates in 23 countries and has 29 paint
manufacturing facilities in the world servicing consumers in over 65 countries. Besides Asian Paints, the group
operates around the world through its subsidiaries Berger International Limited, Apco Coatings and SCIB
Chemicals.

     Responsibilities:
    Created ER diagrams [Logical/Physical] using Erwin.
    Assisted in database design, creation of ER diagrams, phasing from development to QA and to
     production environment.
    Creation of user databases and installation of MS SQL SERVER 2000/7.0.
    Worked in Project planning, Designing & Implementation.
    Involved in creating tables, views, stored procedures, triggers, and cursors and other SQL joins and
     statements for applications.
    Worked with various business groups while developing their applications.
    Writing the stored procedures, checking the code for efficiency. Routine backups and restoration. Data
     transfers between various servers using BCP.
    Defining and creating indexes for query optimization and revising scripts for optimal performance.
    Resolving various performance issues and running DBCC commands, SQL trace SQL profiler and NT
     monitoring tools.
    Using data transformation services (DTS) to populate data from various data sources using the concept
     of OLE DB.
    Installing SQL SERVER service packs based on the errors and flaws that are found in the application.
    Testing the stored procedures performance and its path of execution by using SQL profiler.
    Recovering the backups of SQL SERVER production databases in test server environment.

       Environment: MS SQL Server 2000/7.0, Windows 2000 Advanced Server, T- SQL, VB 6.0, and XML.




       EDUCATIONAL QUALIFICATIONS:

       Bachelor of Technology in Computer Science, Jawaharlal Nehru Technological University, INDIA.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:47
posted:4/14/2012
language:English
pages:11