Professional Summary
Jessica Claire Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments on various business domains like Financial, Insurance and manufacturing. Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2. Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS). Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports. Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert. Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all. Developing reports on SSRS on SQL Server (2000/2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture. Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL. Great ability to create and manage various database objects like tables, views. Worked Extensively on ETL process using SSIS package. Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files. Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms. Experience in Performance Tuning and Query Optimization. Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts and SSRS Reports with PPS. Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages. Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS. Expert in creating Parameterized Reports. Hands on experience in Creating Star Schema and Snow Flake Schemas. Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player. Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.