SUMMARY

• Around 8 Years of IT experience as a MS SQL Server Developer specializing in database design, development & administration work with SQL Server 2012,2008, 2005 and 2000 for OLTP, OLAP and large - scale data warehouse applications.
• Over 7+ Years of experience in data warehouse development with Integration Services, Analysis services and OLAP report development.
• Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQL, Database Design including ER diagrams, normalization
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Data Validation issues.
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2012/2008/2005 databases and scheduled them according to requirements.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience in converting Crystal Reports to SSRS Reports.
• Experience with ad-hoc reporting, regular reporting, parameterized, Custom Reporting, power view reports, power pivots, and graphical reporting using SSRS for daily/weekly/bi-weekly/monthly reports and from SSAS cubes as well.
• Experience in creating Power Pivot data models to provide the data to Power View dashboards.
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQLServer Reporting Services (SSRS).
• Proficient in creation of Technical Design Specifications (TDS) based on end-user requirements
• Experience in migration of MS SQL Server 2000 to MS SQL Server 2005 (Side by Side).
• Knowledge of Analysis Services and Reporting Services, Strong knowledge in implementing Transactional, Merge and Snapshot replications.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
• Experience in creating User Interfaces on various web services and web applications.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Involved in both Unit Testing and Integration Testing of the T-SQL queries, views, functionsand stored procedures to ensure accuracies in deliverables to end-users.
• Management of schemas, Data modeling, objects & partitioning the tables & indexes.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys
• Experience in automation of various ETL processes and SSRS reports subscription to FTP and email to users per schedule.
• Involved in SSAS cube maintenance activities including troubleshooting and Data Visualizations using SSRS and CrystalReports and Power View.
• Handled production support tasks involving on-call responsibilities both during and after work hours.
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export &Import (DTS), SSAS.

RDBMS: MS SQL Server 2000/2005/2008 , MS Access, Excel

Data Modeling: Erwin, MS VISIO, FileMaker

ETL: DTS, SSIS, Informatica.

Programming Language: T-SQL, VB scripts, C, C++, PL/SQL

Application Development: HTML, XML, CSSIT Processes Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project.

Operating Systems: Windows 2000/NT 4.0, Windows 2003 Advanced Server/

Windows 95/98/200/XP-pro:

Reporting Tools: SSRS, OBIEE, Cognos, Crystal Reports, Report Builder, Power BI

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

BI Developer

Responsibilities:

• Involved in creating several new analytical reports and Dashboards on SSRS 2012.
• Identified various data sources and connection strings to build reports for end-users.
• Created and configured shared datasets and shared data sources.
• Use various transforms in SSIS (SCD, Lookup, and Multicast, For-loop container, Execute SQL) to populate OLAP Data for the reporting needs to target SQL databases.
• Work as a developer in creating complex Stored Procedures, SSIS packages, tables, and views and other SQL joins for building various applications.
• Worked on creating various Test scripts for various modules of universities internal applications.
• Involved in data validation and handled data integrity issues using SQL and Power pivot.
• Created stored complex Stored Procedures, SSIS packages to handle Involved in analyzing and troubleshooting various issues faced during ETL and SQL development and communicating the issues to business peers and Team members.
• Worked with several Business Analysts to design the requirements for various new reports requested.
• Provided Ad-Hoc data extract as needed to end-users and produced data visualizations using Power BI.
• Held weekly status meetings to demonstrate Team the progress on some of my assignments.
• Performance Tuned existing stored procedures to address slow running queries.
• Automated several manual processes, by using stored procedures to enhance the process
• Create efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Work with end-users on UAT pre and post Report Deployment.
• Troubleshot all the issues during all phases of SSRS reports development.
• Converted payroll files from COBAL source to be compatible with SQL DB.
• Created Delimited output files using COBOL source files.
• Used Team Foundation Server (TFS) to manage the team's software development lifecycle.
• Experienced in working on AgileMethodologies for multiple teams.
• Experienced in using Code Collaborator for code reviews.

Environment: MS SQL Server 2008r2, 12, MS Reporting Services 2008, Microsoft Visual Studio 2012, SQL Server Integration Services 2008r2, Code Collaborator, TFS, T-SQL, MS Excel 2010, Microsoft Outlook 2010, Microsoft Power BI,Adobe Reader,UltraEdit.

Confidential, St Louis, MO

BI Developer

Responsibilities:

• Use various transforms in SSIS (SCD, Lookup, and Multicast, For-loop container, Execute SQL) to load data from one database to other SQL databases.
• Work as a developer in creating complex Stored Procedures, SSIS packages, tables, and views and other SQL joins for building various applications.
• Worked on the Inferred members’ concept for early arriving facts for tables in Enterprise Data warehouse (EDW).
• Created stored complex Stored Procedures, SSIS packages to handle early arriving facts and generate surrogate keys for early arriving facts.
• Involved in analyzing and troubleshooting various issues faced during ETL and SQL development and communicating the issues to business peers and Team members.
• Created C# scripts to implement the double-lookup for Inferred members, as a POC to implement the best approach to handle Early Arriving Facts.
• Worked with several Business Analysts to identify several redundant tables to be purged as part of building the new ODS.
• Worked on multiple approaches to better address the Early Arriving Facts compatible with Confidential ’s setup.
• Used ADO.Net (WCF Data services) to use web services in ETL packages in multiple environments.
• Held weekly status meetings to demonstrate Team the progress on some of my assignments.
• Involved in fine tuning existing stored procedures to address slow running queries.
• As part of BPSA Project, involved in adding missing indexes as requested.
• Involved in adding missing constraints on several tables in Acquired Data History (ADH), Acquired Data Staging (ADS)&Enterprise Data warehouse (EDW).
• Worked on the partition switching concept on several large tables in multiple databases like Acquired Data History (ADH), Acquired Data Staging (ADS)&Enterprise Data warehouse (EDW).
• Create efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Work with managers and team members to create and maintain development standards.
• Used Team Foundation Server (TFS) to manage the team's software development lifecycle.
• Worked on several stories on Campaign Management for CRM Team
• Experienced in working on AgileMethodologies for multiple CRM Delivery Teams.
• Experienced in using Code Collaborator for code reviews.

Environment: MS SQL Server 2008r2, Tera data 12, MS Reporting Services 2008, Microsoft Visual Studio 2012, SQL Server Integration Services 2008r2, Code Collaborator, TFS, T-SQL, MS Excel 2010, Microsoft Outlook 2010, C#4.0

Confidential, St, Louis, MO

BI Developer

Responsibilities:

• Interacted with end users and functional architects for mapping the legacy data to the SQL Server tables.
• Used various transforms in SSIS to load data from accounting software Quick Books in the form of flat files to the SQL databases.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Studied the existing OLTP system(s) and interacted with Data Architect regarding facts, dimensions and star schema representation for the data mart.
• Involved in importing data from prod into MS Access Databases using SSIS to enable access for the end users.
• Created views, Indexed Views, Power pivot to support internal Reporting requirements and modified the existing reports based on End User Requirements.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views and User Defined
• Experienced in using Power-Pivot for analyzing the raw data and team meetings and during requirement gathering.
• Extracted data from Oracle, MS SQL databases to create Pivot tables need for the end users.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Involved in Detailed Data Analysis using Power BI stack for Operational Reporting.
• Involved in analyzing and troubleshooting various issues faced during the Development Phase.
• Used Subversion (SVN) to manage the team's software development lifecycle including deriving product backlog items and conducting sprint review meetings.
• Worked on JIRA for issue tracking and JIRA Green hopper for agile planning.
• Used report Builder version 3.0 to create analytical reports.
• Involved actively in multi-tasking on various departmental reporting needs.
• Worked with high level end-users, communicating the progress and developments in a timely manner.

Environment: MS SQL Server 2008r2, MS Reporting Services 2008, MS Access, Report Builder 3.0, Microsoft Visual Studio 2012, SQL Server Integration Services 2008r2, SQL Complete, Ultra Edit, Tortoise SVN, Quick Books T-SQL, Windows XP Professional, MS Excel 2013, Power Pivot

Confidential, St Louis, MO

BI Developer

Responsibilities:

• Interacted with end users and functional architects for mapping the legacy data to the SQL Server tables.
• Developed Queries for generating reports in SSRS 2008 for Complex Executive Dashboards and Customer Performance dashboards to analyze the KPI’s for all global clients.
• Used various transforms in SSIS to load data from accounting software Quick Books in the form of flat files to the SQL databases.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Studied the existing OLTP system(s) and interacted with Data Architect regarding facts, dimensions and star schema representation for the data mart.
• Involved in recreating the analytical reports using the legacy MS Access Databases using SSRS to eliminate any Manual Processing.
• Involved in integrating the SSRS Reports with QR Codes, Micro QR Codes, and Standard barcodes using third party applications to track the Samples at various levels from Receiving to Testing.
• Created Accounting Reports based on Quick Books data for Region wise sales, sales by client, Sales by State, quarterly sales for all the Global clients.
• Experienced in using Power-Pivot for analyzing the raw data and team meetings and during requirement gathering.
• Created SSRS Report to automatically print the labels for the Sample Scheduling for the Analysts, eliminating the manual process and paper based approach.
• Involved in both Unit Testing and Integration Testing to ensure all the software deliverables are in compliance with the end user business and technical requirements
• Involved in embedding the SSRS Reports and Dashboards in the internal web applications.
• Worked on the POC of Creating Monthly Quality Assurance Reports, letters for some of the exclusive clients and set up subscriptions to deliver these Reports based on a schedule.
• Involved in generating several Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Worked on caching the reports to improve the Report Retrieval Time.
• Used Subversion (SVN) to manage the team's software development lifecycle including deriving product backlog items and conducting sprint review meetings.
• Actively involved in User Acceptance Training (UAT) for various end-users across the departments, to explain them the full functionalities of the SSRS Reports and Dashboards.
• Worked with high level end-users, communicating the progress and developments in a timely manner.

Environment: MS SQL Server 2012, MS Reporting Services 2008, MSAccess, Microsoft Visual Studio 2012, SQL Server Integration Services 2012, SQL Complete, JIRA, Tortoise SVN, Quick Books T-SQL, Barcode Reader, Micro QR Readers,Windows XP Professional, MS Excel 2013, Power Pivot

Confidential, Seattle, WA

BI Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Studied the existing OLTP system(s) and interacted with Data Architect regarding facts, dimensions and star schema representation for the data mart.
• Used open queries to fetch data from DB2 source systems.
• Used WCF Data services to fetch data from internal Accounting software
• Used Bulk Binds and Records processing to improve the performance of processing.
• Created views, Indexed Views, Power pivot to support internal Reporting requirements and modified the existing reports based on End User Requirements.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views and User Defined
• Used differentkinds of SQLJoins to join more than 10 tables.
• Designed data modeling using Erwin.
• Extracted data from Oracle, MS SQL databases to create Pivot tables need for the end users.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for DB2 database using Informatica and SSIS
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Participated in the migration of applications to quality assurance and/or the production environment.
• Performed necessary production support tasks involving on-call responsibilities both during and after work hours.
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Involved in User Acceptance Training (UAT) with user to create reports using Report Builder 3.0 Tool
• Generated reports using Global Variables, Expressions, and Functions for the reports.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Used Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle including deriving product backlog items and conducting sprint review meetings

Environment: MS SQL Server 2012, MS Reporting Services 2008, Report Builder 3.0, Microsoft Visual Studio 2012, SQL Server Integration Services 2012, Erwin, SQLComplete, Oracle 11G, TFS 2012, T-SQL, Windows XP Professional, MS Excel 2013

Confidential, Saint Louis, MO

SSRS Developer

Responsibilities:

• Created complex Stored Procedures for Quality Checking on SSMS 2012.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Worked as a developer in creating complex Stored Procedures, cursors, tables, and views and other SQL joins for building various reports.
• Scheduling cubes processing from staging Database Tables using SQL Server Agent.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc. to import data into the data warehouse.
• Identified various data sources and established connections between source and the Destinations Using SSIS based on the business requirements.
• Developed SSIS packages for archiving the files after the FTP Process using Script Task.
• Configured Server for sending automatic mails to the respective Groups when a SSIS process Failure or success.
• Experienced in creating functional reports using Report Builder 3.0
• Created complex Regional Compliance Scorecard (RVP) Report with multiple clickable sub-reports.
• Created Complex Product Sales Variance Analysis Reports for all the Regions.
• Created Custom templates for Report Layouts based on the requirements documents and end-user Interaction.
• Worked on subscriptions (Standard and Data driven) for the Daily Gross ProfitReports.
• Embedded the SSRS reports on to various modules onWeb application (Trimax) Microsoft Dynamics AX.
• Used SSIS to Transform Raw data from Trimax Web Service to build Ad-hoc reports.
• Resolved all the Change Management Requests raised by the various Departments for their Reporting Requirements.
• Resolved my entire Change Management requests assigned to me in a Timely Fashion.
• Ensured project requirement and delivery with active interactions with end users.
• Involved in trouble-shooting of reports in Authoring, managing, and delivery phases on multiple servers.
• Involved in unit testing various executive level reports and Dashboards in DEV and Test Environment.
• Built several customized reports for the Regional Vice Presidents (RVP) for the Monthly Vendor Performances across all the locations and all Processes using Power BI.
• Worked on Goal Oriented Agile Methodologies.

Environment: MS SQL Server 2012, MS Reporting Services 2008, Report Builder, Microsoft Visual Studio 2012, SQL Server Integration Services 2012, SQL Complete, TFS 2012, T-SQL, Windows XP Professional, MS Excel 2013

Confidential, Lake Saint Louis, MO

Senior Reporting Analyst

Responsibilities:

• Interacted with various upstream and downstream customers ininterfacing various systems for data extractions, ETL, Analytics and Reporting needs.
• Involved in Meetings with end users of Interface and layout of reports.
• Designed & developed ETL procedures, Data dictionaries, and ancillary tables, data mappings involving data analysis, data validations and data migrations.
• Involved in writing heavy T-SQL storedprocedures, complexjoins,new SQL2012 T-SQL features like Merge, except commands.
• Worked with MS Access databases to convert legacy crystal reports to SSRS.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Created Package Configurations, Error Handling using Event Handlers for On Error, On Warning, and On Task FailedEvent Types.
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler, and third party tools like Control m.
• Utilized Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle including deriving product backlog items and conducting sprint review meetings.
• Created linked servers to fetch data from Cisco Informix Databases.
• Involved in moving data from Informix server to SQL server using SSIS Import/Export Wizard.
• Implemented different types of constraints like Primary key, foreign keys on tables.
• Responsible for converting the data using CTE’s (Common Table Expressions) and Merge Statement for the Gas Mileage Reimbursement Reports.
• Created ad-hoc reports, and complex Enterprise reports (drill down, and drill through reports, Parameterized reports, cascading report) using SQL Server Reporting Services and report manager.
• Worked with .net programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.
• Responsible for creating reports based on Report Definition Document (RDD) using SSRS 2012.
• Worked on the IBM AS400 System for accessing the Legacy Trip Details.
• Validated the Trip Details from the AS400 System with Crystal and SSRS Report Runs for Data Validation for Care Management Stats.
• Resolved all the Issuetrack Requests raised by the various Departments for their Reporting Requirements.
• Assisted in developing OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting Services (SSRS).
• Defined Schemas, i.e. relationships between Measure groups and Dimensions in SSAS.
• Involved in performance tuning of slow running queries for report generation.
• Resolved my entireIssuetrack requests assigned to me in a Timely Fashion.
• Actively involved in Subscriptions (Standard & Data driven) ofall the reports to ensure timely Delivery of Time sensitive Reports
• Generated reports using Global Variables, Expressions, and Functions for the reports.
• Involved in trouble-shooting of reports in Authoring, managing, and delivery phases on multiple servers.

Environment: MS SQL Server 2012, MS Reporting Services 2012, SQL Server Integration Services 2012,SSAS,Crystal Reports XI,IBM AS400,Automate 8,BOE Scheduler, C#, .Net, TFS 2012, T-SQL, Windows XP Professional, MS Excel 2013,Visual Source Safe 8.0.

Confidential, New Orleans LA

SQL Server BI Developer

Responsibilities:

• Worked withData Modeling and handling OLAP Databasesusing standard Kimball approach.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval and design new tables as needed.
• Involved in gathering Business requirements and responsible for preparing Report Requirement Document (RRD), based on which end reporting is accomplished.
• Developed various star schema models like Policy people, Budget amountsAnnualized premiums, Policy producer bridge, Unsummerized premiums.
• Created several complex stored procedures to define the raw data as per clients requirements for the Policy people, Budget amountsAnnualized premiums, Policy producer bridge, Unsummerized premiumsand created the Master Procedures for each of these.
• Involved in validating the star schema models built using CognosFramework Manager.
• Involved in performing incremental load, Change Data Capture, Data Conversions, configuration and deployment to the production server using SSIS 2012.
• Developed Dimensional hierarchies for the various entry codes for coverage plans and producer performance.
• Defined Star Schema, OLAP Cubes and Dimensions with SSAS.
• Created the Data source views to analyze the metadata based on multiple data sources during development without an open connection to any underlying data source using SSAS.
• Analyzed the Cubes by performing calculations, perspectives, actions and Key Performance Indicators (KPI’s) in SSAS.
• Modified the measures, dimensions, attributes, hierarchies, measure groups and deployed the changes to the deployed cube in SSAS.
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.

Environment: MS SQL Server 2012, MS Reporting Services 2012, SQL Server Integration Services 2012, SSAS, T-SQL, Windows XP Professional, MS Excel 2007, IBM Cognos 10.2, Visual Source Safe 8.0, Informatica

Confidential, Phoenix, AZ

SQL Server BI Developer

Responsibilities:

• Experienced in creating Data Model Source to Target Mapping as per the Business Requirements.
• Active participation in and gathering requirements from workgroup meetings and making changes in Source to Target mapping documents.
• Involved in Embedding SSRS reports into Web Services and accessing web services for Data retrievals for Report generation.
• Wrote and modified stored procedures in a SQL Server environment and also PL/SQL procedures in Oracle.
• Experienced in development of Test Cases in various scenarios around the SQL Code and SSIS Packages in Dev, QA and UAT environment
• Experienced with SSIS in creating, loading, and modifying new packages or existing packages and add or configure components, making changes in object by using Control Flow Tools and Data Flow Tools and then validating them.
• Developed Slowly Changing Dimensions (SCD) Packages using SSIS (ETL) to perform the Incremental / Historical load logic data from Source to Staging Environment and into the Enterprise Data Ware House.
• Performed Data profilingtasks in SSIS Packages using the Data Profiler and standardizing the data appropriately for the database.
• Experience in managing Alerts, Creating Jobs, and Operators through SQL Server Agent.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Performed in-depth Data Analysis to ensure data consistency.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRSand integrated into the front end.
• Developed and deployed various types of Chart, Bar, Pie-Chart Reports in the front end using OBIEE tool.
• Worked in Scrum Methodology to meet goals and deadlines.

Environment: SQL Server 2008 R2/2008/2005, SSIS, SSAS, FileMaker Pro, SSRS, T-SQL, ERWIN, Visual studio 2008/2005, IIS, Visio, Team Foundation Server 2010, C#, .Net, OBIEE.

Confidential

SQL Server BI Developer

Responsibilities:

• Experienced in Preparation of ETL packages with external or third-party data sources.
• Involved in developing E-R diagrams, logical & Dimensional Modeling of the system.
• Wrote and modified stored procedures in a SQL Server environment.
• Experienced in creating database structures as per requirement required in SQL Server environment.
• Actively participated in and gathering requirements from group meetings.
• Wrote the ETL scripts to load the data into database from various source files.Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Performed backup/restore, database objects such as Stored Procedures, Triggers, Constraints, Indexes and Views.
• Implemented the conversion of legacy DTS packages to SSIS 2008 version and enforcing security standards.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Imported Source files from different servers using FTP TASK.
• Experienced in Documentation, testing and implementing solutions using applicable SSIS and SSRS technologies.
• Used PIVOT/UNPIVOT operations to turn rows into column and vice versa to normalize table structure of the database which doesn’t meet the desired reporting format.
• Migrated and recreated existing Dimensions and Cubes using Star/Snowflake schema on 2005 Server to 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).

Environment: SQL Server 2008/2005, SSIS, SSAS, SSRS, T-SQL, Visual studio 2008/2005, Windows Serer 2008 R2 Datacenter, IIS, Visio, Visual Source Safe 2005,C#, VB.Net,Tivoli,Active-X

Confidential

SQL Server Developer

Responsibilities:

• Used BCP utility to publish table output to text files.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database to SQL Server.
• Involved in conversion project for converting legacy DTS packages to SSIS packages.
• Creation/Maintenance of Indexes for fast and efficient reporting process.
• Configured server for sending automatic mails to the respective people when a DTS process failure or success.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Involved in data modelling of various modules like AP, AR, GL as instructed.
• Analyzing Database Growth and Space Requirement.Handling Users/Logins/User Rights.
• Maintained a good client relationship by communicating daily status and weekly status of the project.
• Created linked servers between different SQL Servers and also created linked server with different access files used across various Used Data Departments.
• Performed DBA tasks through Enterprise Manager, Query Analyzer, and Import Export wizard.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Developed SQL Scripts to Insert/Update/Delete data, satisfying the referential integrity constraints.
• Worked on PL/SQL procedures to extract data from legacy Oracle AP, AR, GL databases
• Involved in Data Modeling using Erwin.
• Configured Transactional Replicationbetween the Production server and Reporting Server and to move the data to servers in various locations.

Environment: MS SQL Server 2000/7.0, T-SQL, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS, SQL Server Query Analyzer, SQL Profiler, MS Office, Tivoli, Active- x, Erwin, Informatica