Sql Server Data

Shylet Maredza

Cell # 214-***-****

Email: *********@*****.***

PROFESSIONAL SUMMARY

. About 4 + Years of IT Experience using SQL Server, Integration Services

(SSIS) for ETL and Reporting Services (SSRS) for creating different types

of reports.

. Sound knowledge of SQL server administrative skills including, backups,

disaster recovery, database maintenance, user authorizations and database

creation.

. Worked independently in the development, testing, implementation and

maintenance of systems of moderate size/complexity with a fast turn-

around.

. Experience in Configuring and maintaining Report Manager and Report

Server for SSRS, deployed and scheduled the Reports in Report Manager.

. Well versed with the knowledge of RDBMS, data warehousing i.e. OLTP &

OLAP systems.

. Experience in extraction, transformation and loading (ETL) of data flows

using SSIS with complex integration of SQL Server, Oracle, Access

database, Flat file, XML and Excel sources.

. Expertise in creating indexed views, complex stored procedures, effective

functions, and appropriate triggers to facilitate efficient data

manipulation to maintain data consistency.

. Experience in Query Optimization, Debugging, and Tuning for improving

performance.

. Involved in designing numerous DB Objects like Tables, Constraints

(Primary Key, Foreign Key and Unique) and Indexes.

TECHNICAL SKILLS

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

97/2003/2005/2007,

Oracle

LANGUAGES T-SQL, PL/SQL, Java, C#

TOOLS AND PACKAGES SQL Server Management Studio, SQL Server

Business Intelligence Development Studio

(BIDS), SSIS, Visual Studio .NET, Oracle and

Toad

BI TOOLS SQL Server Reporting Tools (SSRS), SQL Server

Integration Services (SSIS), SQL Server and

Business Intelligence Development Studio

(BIDS)

WEB TECHNOLOGIES HTML, XML

EDUCATION/CERTIFICATION

. Bachelors in Computer Aided Design, Eastern Michigan University, MI.

. MCTS: Microsoft SQL Server 2008 Business Intelligence-Implementation and

Maintenance

(Exam: 70-448)

PROFESSIONAL EXPERIENCE

Chasepaymentech, Dallas, TX

Jun'12 to present

SQL SERVER (SSIS, SSRS) Developer

RESPONSIBILITIES

. Designed reports using table filters, single value parameters, multi

value parameters, dependent parameters and Cascading parameters.

. Involved in performance tuning of the database which includes index

maintenance optimizing SQL statements and monitoring the server.

. Developed reports using complex TSQL queries, User Defined Functions,

Store Procedures and Views.

. Created, supported maintenance of local databases and dashboards for

report sharing.

. Designed and developed SSIS Packages using various Control Flow tasks

and Data Flow components to transform and load the data from various

databases and into Servers using SQL Server Integration Services

(SSIS).

. Designed packages using Lookup Transformations, Merge Joins, Derived

Columns and Conditional Split.

. Worked with various upstream and downstream systems and customers in

interfacing various systems for Data extractions, ETL, Analytics and

reporting needs

. Extracted data from various sources like SQL Server, Oracle, and

Access database, CSV, Excel and XML file from Client servers and

through FTP.

. Involved in source Data Analysis, Design and Creation of Data Mappings

for Extraction of /bulk data from heterogeneous sources like Oracle

and other OLEDB data sources.

. Involved in automating SSIS Packages using SQL Server Agent Jobs and

Windows Scheduler.

. Built Drill Down, Drill through, Charts, Matrix, Linked and Sub

reports using SSRS.

. Designed Enterprise reports using SQL Server Reporting Services and

Excel pivot tables based on OLAP cubes which make use of multiple

value section in parameters pick list, cascading prompts, matrix

dynamics reports and other features of Reporting service.

. Provided guidance and support for the design, development, and

implementation of automated processes.

. Meet with Executive and Department leadership to discuss reporting

needs and provide support as needed.

. Respond quickly to bug fixes and enhancement requests.

Environment: MS SQL Server 2008/2008 R2, Business Intelligence Development

Studio (SSRS/SSIS/SSAS), MS Office Access 2007, Visual Studio 2008, Oracle

and Toad

.

CenseoHealth, Dallas, TX

Mar'10 to Apr'12

Data Analyst

RESPONSIBILITIES

. Created ad-hoc queries using T-SQL to help answer business questions

and fulfill data needs.

. Maintained and modified existing SQL Server Reporting Services (SSRS)

reports as needed.

. Worked effectively within collaborative team to identify, troubleshoot

customer issues and resolve the issues.

. Collaborated with requestors to gather business requirements and

translate them into function / technical requirements

. Troubleshoot and modified existing queries to improve optimization and

be more efficient.

. Defined and documented customer business functions and processes.

. Tracked and fully documented changes for functional and business

specifications; wrote detailed universally understood procedures for

permanent records and for use in training.

. Identified opportunities for improving business processes through

information systems and make recommendations towards innovative data

solutions.

. Read and interpreted case management systems and functional technical

literature and translates in terms understandable to the end-users.

. Performed research and analysis of healthcare data regarding network

Environment: MS SQL Server 2008/2008 R2, Business Intelligence Development

Studio (SSRS/SSIS/SSAS), MS Office Access 2007, Visual Studio 2008

Contact this candidate