SUMMARY

• Over 8 Years of extensive experience as SQL Server and Microsoft Business Intelligence applications developer, Specialized as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services
• Experienced in extracting, transforming and loading the data using SSIS in SQL Server 2005/2008/R2 and Data Transformation Services in SQL Server 2000
• Expert in data migration from OLEDB/EXCEL/FLAT fileto SQL Server 2000/2005/2008/ R2 and other destinations using SSIS
• Migrated data using SSIS, DTS wizard (Data Transformation Services) tool through data flow tasks, look up transformations and script tasks
• Developed database objects such as tables, views, stored procedures, triggers, row - level audit tables, cursors, indexes, user-defined data-types, functions and constraints
• Diagnosed performance tuning, query optimization, client/server connectivity, and running database consistency checks using DBCC Utilities
• Worked extensively with Data Adapter, Dataset, Datareader as apart of ADO.NET to access and update database.
• Expert in debugging an application using the debugging tools provided by the Visual Studio .Net IDE.
• Extensively worked on DDL/DML techniques, joins, sub queries, passing variables, looping, dynamic SQL, managing indexes and deadlocks (troubleshooting)
• Expert in creating Dashboards, Score Cards and KPIs for SharePoint 2007 and SharePoint 2010.
• Proficient in developing web applications using diversified technologies like ASP.Net and PHP.
• Experience in performance tuning in SSIS, error and event handling, precedence constraints, break points, transactions, check points and logging using SSIS
• Proficient in data migration between homogeneous/heterogeneous systems and SQL Server using DTS import/export utility, integration service (SSIS), BULK INSERT and BCP
• Proficient in OLTP, OLAP and data warehouse design concepts, experienced in relational, multi-dimensional (Star) and snowflake, logical and physical data modeling and data mapping
• Experienced in MS Analysis Services (SSAS) programming for data warehouses (Schemas), proficiency in data warehousing techniques for data cleaning, slowly changing dimension phenomenon
• Proficient in processing OLAP cube, creating KPIs, dimension usage, calculated members, perspectives and hierarchies
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, usage based optimization, besides providing security by providing perspectives
• Extensive experience in reporting tabular forms, matrix (cross tab report) form, conditional, list items, charts and sub reports
• Deploy reports, secure access, and schedule execution of reports and deliver them to the Web using reporting manager, share Point, email recipients, file shares, and more, on a scheduled basis
• High expertise in creating reports using crystal reports and SSRS (ad-hoc, drill-down, drill-through, cross-tab, sub-reports, pivot, tabular and parameterized reports)
• Experience in error and event handling, precedence constraints, break point, check points and logging
• Strong Experience on framework manager modeling (Namespaces, Joins, Loops, and Dimensions) and creating packages and deploying onto server
• Developed prompt pages and cascaded input prompts to display only the selected entries in report studio
• Defined relationships and cardinality between different tables in framework manager
• Worked on administration tasks such as backup & recovery, upgrades, creating databases/file groups/files/transactions logs
• Designed and implemented a dimensional data warehouse (multiple data marts) for Mortgage Loan Origination using the Kimball methodology.
• Performance tuning of SQL Queries using execution plan index scan, index seek and bookmark lookup
• Experience in database architecture, design, coding, implementation and production support
• Knowledge of SDLC Life Cycle (Initiation, Analysis, System Design, Construction, Acceptance, Implementation) and Maintaining triple constraint project scope, on time, on budget for information technology projects
• Possess excellent management skills of outstanding decision making with excellent verbal and written communication skills, Supervised in preparing and assisting formal walkthroughs and presentations of system designs for business analysts, stakeholders and clients

TECHNICAL SKILLS

Programming Languages: C, C++, C#, .NET, SQL, TSQL, PL/SQL

RDBMS: MS-SQL Server 2000/2005/2008/ 2012, Oracle 9i/10g, Microsoft Access, DB2

IDE Tools: Visual Studio.Net 2005/2008/2012

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008/2012, DTS

OLAP Tools: SQL Server Analysis Services (SSAS) 2000/2005/2008/ 2012

Reporting Tools: SQL Server Reporting Services (SSRS) 2000/2005/2008/ 2012, Crystal Reports, Cognos Framework Manager, Report Studio

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Teradata, Query Analyzer

Markup Languages: XML, HTML, DHTML

Data Modeling: ERWIN, MS Visio, Informatica

Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003, Windows NT, Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultim ate, Linux, UnixWORK EXPERIENCE:

PROFESSIONAL EXPERIENCE

Confidential, Solon, OH

Sr. SQL Developer

Responsibilities:

• Interact with business users to gather required information for developing reports and SSIS packages
• Automated ETL Data loads and established efficient ways of Error Handling in SSIS, Implemented Event Handlers, Package Configurations, Logging, System and User-defined Variables, and Expressions for SSIS Packages.
• Created functions and developed procedures to implement application functionality at the database side for performance improvement, involved in Performance tuning of Queries, Indexes and Stored Procedures using SQL Profiler.
• Worked with Exception handling with @@error and with Try/catch.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008R2
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform drill down, drill-through operations in SSRS 2008R2
• Developed reports using global variables, expressions and functions
• Created SSRS projects and datasets, Object visibility and report actions.
• Used SSRS 2008 to publish data to the end user via HTML, PDF, Excel, and CSV formats.
• Created/edited sales job module in SQL Agent in development and participated in production deployment.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc.
• Involved in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Implemented and administered database Replication between SQL Server databases.
• Adhere to change control procedures, version control management and Code Reviews.
• Conducted unit and integration testing to ensure accuracy.

Environment: SQL Server 2008R2, T-SQL, MS Visual Studio 2008R2 (SSIS, SSAS,SSRS), Dashboards, Windows 2003, MS Access 2007, C#, ASP.Net, Oracle Database 11g.

Confidential, Brecksville, OH

SQL Server/ BI Developer

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Installed SQL server2005,2008and2012on a test environment to be the future production environment.
• Upgraded legacy 2005 databases to SQL server2008/2012.
• Migration of Microsoft Dynamics AX 2009 to Microsoft Dynamics AX 2012.
• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked with development teams in the design of physical databases and in modification.
• Develop different kind of reports using Microsoft Reporting Services platform (SSRS), MS Excel, Pivot tables.
• Creating Tabular, Charts and graphs as per customer requirements Using SSRS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Responsible for creating reports using Crystal Reports XI version using Oracle 11g version, SQL server and MS Access databases.
• Conducted weekly Crystal Report and Oracle SQL training sessions for the reports team.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services (SSRS).
• 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.
• Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership
• Designed complex SSRS reports, Excel templates and integrated automation methods as appropriate.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created ETL SSIS packages both design and code to process data to target databases.
• 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.
• Constructed OLTP and OLAP Databases.
• Support the installation and life cycle of Microsoft Dynamics AX application software.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Worked on Crystal Reports.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Windows 2003 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Service Broker, MS Excel 2010 Crystal Reports, Tableau, Business Objects.

Confidential, Plano, TX

SQL Server/ BI Developer

Responsibilities:

• Migrated very complicated Bank Actuate reports into SSRS 2005 and SSRS 2008 which are some not able to migrate but used many work around techniques to migrate this complicated reports
• Created many new reports according to the business user requirement with includes complicated expressions and tables with as many as 36 fields in the reports
• Perform unit testing at various levels of the Reports
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2005
• Written complex Stored procedure according to the business requirements for reporting purpose
• Designed & developed the various SSIS packages for the Weekly & Monthly Loads from business users in different locations in United States
• Managed the ETL processes between various environments through scripts utilizinglinked servers, DTS packages and SSIS
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS)
• CreatedSub Reports, Parameterized and Drill down Reportsbased on the requirements provided
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables
• Converted Non-Unicode data from different databases into Unicode data and move the data to staging databases
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules usingT-SQL
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application
• Modified existing database to fit new business requirement by adding tables and relationships
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions
• Created Views and Indexed Views for the Performance Tuning
• Created automated T-SQL scripts to process summary database transactions that run off-hours
• Involved in creating, maintaining different SQL Server Objects such as Tables, Procedures, Functions, Views, CTE’s, Triggers etc. according to the requirements
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement
• Work with the database modeling manager to identify the requisites of a project
• Authored ETL mapping specifications from source to staging area database, Data Mart, and aggregation tables.
• Communicate with the clients and develop a customized database modeling
• Involved in Query optimization and tuning stored procedures for better performance
• Executed database backup task, check database integrity, rebuild indexes, update statistics task for maintenance
• Carry out creation of SDLC documentation for existing applications
• Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations
• Involved in preparing detailed Design Documents and Approach Documents

Environment: MS SQL Server 2005/2008/R2, Windows XP, UNIX, Visual Studio, Borland Star Team, Compare IT, Performance Point Server, Microsoft Office, Snag IT 10, Actuate Reporting, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, PL/SQL, MDX/DMX, MS Visio, Microsoft Project, Microsoft Outlook, Windows 2003/XP, XML, IIS, Microsoft Access

Confidential, Plymouth, MN

SQL Server/BI Developer

Responsibilities:

• The project is designed in two phase’s data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days data from oracle into SQL Server database to store consistent and durable data
• ETL development of moving SSIS packages from 2005 environment on to 2008 with new transformations
• Built new SSIS Packages incrementally loading data dynamically on to SQL Server destination tables from different OLEDB, Flat File, .TXT and Excel files
• Deployed SSIS packages by creating configuration files making packages dynamic by creating variables
• Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages, extensively worked on mappings, incremental data loading, and SSIS transformations
• Created the dimensional & relational models for various databases for monitoring tools, created database, SSIS standards of development, configuration & deployment of the Packages
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS
• Created SQL server reports using SSRS 2005/2008 for manager, customer support and that can deliver at client’s station
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, execute sql flow task, data flow task to extract data from different databases and flat files
• Designed different type of reports tabular, matrix (cross tab), conditional, list items, charts and sub reports
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance
• On the required reports, identified various data sources and established the connections using SSIS and constructed data source view
• Involved in creating cubes and dimensions for the new data warehouse using SQL server analysis services (SSAS)
• Created OLAP cubes in SQL Server Analysis Services 2005 & 2008 for company wide use. The data being compared in the cubes had never been available together in the same application previously
• Created SSIS packages using different transformations in SSIS toolbox like aggregate, merge, merge join, pivot etc
• Supported in creating KPI, calculation members and measure groups, and MDX queries
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart and OLAP cubes using SSAS
• Defined Relationships Between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, Dimension Granularity within a Measure Group in SSAS
• Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services
• Worked on databases providing security using locks, tuned existing proc, created new indexes for better performance
• Designed Common Table Expressions (CTEs), table variables and temp tables, which makes a reusable expression part of a query
• Experience in code optimization and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
• Used performance monitor/profiler to solve dead locks/long running queries
• Extensively used views for complex joins queries involving multiple tables from different databases
• Deployed and managed reports with the aid of Crystal Management Console.
• Designed numerous triggers to keep track of the changes made in the database for log purpose
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring

Environment: MS SQL Server 2005/2008/2008, DB2, Teradata, Microsoft Access, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, PL/SQL, MDX/DMX, MS Visio, Microsoft Access, Microsoft Project, Microsoft Outlook, Windows 2003/XP, XML, IIS

Confidential, Dallas, TX

SQL Server/ BI Developer

Responsibilities:

• Extracted data from different OLEDB sources, flat file, and excel destinations with major transformations loaded on the SQL Server destination tables
• Created SSIS packages to migrate data from Oracle to SQL Server 2008
• Responsible for coordinating the implementation of the application and conversion for various Confidential retail markets
• Created and scheduled SQL jobs to run SSIS packages on a daily basis using MS SQL Server Integration Services (SSIS) on incremental loading
• Performed data conversions from normalized database structure into flat files by using BCP import/export utility along with global temporary tables
• Published migrated data using SSIS, DTS wizard (Data Transformation Services) tool through data flow tasks, look up transformations and script tasks
• Used SSIS control flow tasks like loop containers, FTP, bulk insert, transfer job task and different data flow tasks like derived column, fuzzy lookup and data conversion
• Involved in creation of star schema and snowflake dimensional schema in MS analysis services (SSAS)
• Involved in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects
• Wrote MDX queries to retrieve the data from data warehouse dimensions and to perform analysis
• Developed sub reports, matrix/tabular reports using MS SQL Server Reporting Services (SSRS)
• Identified various data sources and established the connections using SSIS and constructed data source view based on the required reports
• Responsible for scheduling the subscription reports with the subscription report wizard
• Worked with various SSIS tasks including execute SQL task, for each loop container, file system tasks
• Generated reports with complex expressions to calculate, group, filter, parameterize and format the contents of a report using MS SQL Server Reporting Services (SSRS)
• Created and modified data driven subscriptions using SSRS Report Manager
• Written queries for the drill down reports and deployed the generated reports on to the server using MS SQL Server Reporting Services (SSRS)
• Responsible for setting up comprehensive backup and recovery Strategies for SQL Servers
• Maintained databases with Database Consistency Checks (DBCC) such as rebuilding indexes and integrity checks
• Used execution plan to identify slow running queries to resolve query performance by designing proper indexes and updating statistics
• Worked on writing complex stored procedures using T-SQL as well as analyzing and debugging existing complex stored procedures
• Created complex stored procedures and functions to support efficient data storage, archiving, purging and manipulation
• Conducting root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, hardware bottlenecks or network latency
• Created analytical reports using Proclarity tool
• Utilized performance point server to create scorecards and dashboards to monitor business performance
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system
• Responsible for the creation and maintenance of entity relationship diagrams, meta data repository and comprehensive system documentation including everything from environment configuration information through standards policies and procedures
• Created user defined functions to encapsulate frequently and commonly used business logic
• Worked on new features of SQL 2005 such as RANK, NEWID, PIVOT, APPLY, ROW NUMBER and other row ranking functions

Environment: SQL Server 2008/2005, SSIS, SSRS, SSAS, T-SQL, UNIX, LINUX, SQL Server Profiler, Windows 2003, UNIX, Visual Studio, Performance Point Server, Proclarity, MDX

Confidential, Camarillo, CA

SQL Server BI Developer

Responsibilities:

• Creating SSIS packages to gather data from various sources (mainframe, Informix, Oracle)
• Improving SSIS packages for better performance by reassigning the transformations
• Created DTS packages for loading data from desperate system to porters
• Installed, upgraded and migrated databases from Oracle to MS SQL Server 2005
• Designed ER diagrams and mapped the data into database objects
• Involved in Normalization to 3F for OLTP system and some De-Normalization for OLAP system
• OLAP with the various applications to analyze the data for clients i.e. excel, reporting services
• Experience in developing and extending OLAP Cubes, dimensions and data source views
• SSAS storage and partitions, aggregations, calculation of queries with MDX, data mining models and developing reports using MDX and SQL
• Experienced in using Informatica 7.x for Extraction of data from multiple sources and load on to SQL Server, monitored dataflow using work flow manager
• Built reports for the analysis services using SQL Analysis services 2005 using different reporting tools
• Designed dimensions and using the MDX expressions for the various Optimizations like optimizing cube schema in SSAS
• Developed different types of tabular reports, matrix reports (cross tab or pivot) reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services
• Developed both the drill down and drill through reports
• Designed reports with grouping/sorting and parameters (including multi-value parameters) using SQL server reporting services
• Migration of data from MS Access to SQL 2005/2000 using upsizing wizards
• Involved in the analyzing and solving problems during the client application system’s installing, upgrading and running stages
• Wrote SQL scripts to insert/update and delete data in SQL database
• Converted existing PL/SQL stored procedures, triggers, functions and script to T-SQL
• Created schemas, views, stored procedures, triggers and functions for data migration
• Involved in the complete life cycle of the project, from planning stage to pushing the codes to production
• Responsible for query optimization using SQL tools such as SQL Profiler and Index tuning wizard
• Worked on client/server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server, and Excel and Reporting Services tools

Environment: MS SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS, SSAS, Windows XP, Oracle, T-SQL and ER-WIN, Windows 2000 Server, Informatica PowerCenter7.x (Repository Manager, Designer, Workflow Manager and Workflow Monitor)

Confidential

SQL Serve Developer/Business Analyst

Responsibilities:

• Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server 2000
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults
• Wrote user defined functions and stored procedures, and also defined roles and privileges to control access to database
• Created triggers to enforce data and referential integrity
• Created constraints, defaults, views and indexes
• Created Triggers to enforce data and referential integrity
• Defined check constraints, business rules
• Hands on performance tuning, analyze and optimize SQL Server application using performance monitor
• Tuned the batch programs and online transactions to alleviate performance problems
• Wrote DDL, DML statements for processing of daily activities
• Involved in updating slowly changing dimensions strategies, and defined attribute properties in parent child dimensions
• Responsible for hiding and disabling attributes and attribute hierarchies
• Implementing the calculations to aggregate physical measures

Environment: Windows XP, SQL Server 2005/2000, MS Visual Studio 2005, MS Outlook, Visio, DTS

Confidential

Junior SQL Developer/DBA

Responsibilities:

• Written various stored procedures for the purpose of application development
• Transformed data from various data sources using OLE DB connection by creating various DTS packages
• Administrator tasks like managing users, roles, and profiles
• Performed database backups (operating system, flat file backups & export/import)
• Used snapshot replication for creating multiple instances of a database for distributing the workload
• Tuned SQL statements using indexes and stored procedures combined a few simple, unrelated database accesses to improve performance and done data volume estimation and planning
• Designed the forms & created reports using form builder & report builder in Developer 2000
• Developed standards and guidelines to maintain develop and administer the SQL Server database and handled corrupt databases and diagnosed and repaired them
• Maintained the physical Databases by monitoring Performance, space utilization and physical integrity
• Worked as the DBA to prepare a disaster recovery plan for their database in a scenario wherein the master database file is lost / corrupted

Environment: SQL Server 7.0/2000, Windows NT/2000, IIS Server, Query Analyzer, MS Exchange Server, .NET, Report builder, Access Reports, T-SQL, UML, DTS