Sql Server Data

REHANA HUSSAIN *** LAFAYETTE LANE, HOFFMAN ESTATES, IL 60169

[pic]

*********@*****.*** . Home 847-***-**** . Cell 847-***-****

To take a challenging role in the field of Computer Programming and

Implement the expertise and experience gained within the field.

Summary

. 19 years experience with computer operations, analytical and

application programming

. MS SQL Server Reporting Services 2008/2005/2010 (SSRS)

. ETL Tools SQL Server Integration Services 2008,2000(SSIS),DTS

. Version Control: Visual SourceSafe (VSS), Team Foundation Server (TFS)

2008.

. Toad for oracle-Version 10g/11g.

. Familiar with Share Point Server 2010/2012

. Vast experience in direct marketing, data processing and database

management, Olap and Cube development (SQL 2000).

. Extract and loading data to data warehouse.

. Experience writing documentation for software applications, processes

and procedures

. Familiar with numerous systems and applications including, but not

limited to, IBM Mainframe, MVS/JCL, Microfocus Cobol, MS SQL Server

2000,MS SQL Server 2005,MS SQL 2008,MS SQL 2012, Oracle8i, Microsoft

Olap cube, Windows 95, NT, Windows 2000,Windows XP and Windows 7, MS

Access database.

Group1 Software, Pitney Bowes, Melissa Data,TSO/ISPF, DB3, IQuest, MS

Visual Studio 2008/2005/2010

Visio, TCP/IP, PC anywhere, VNC, VPN, FTP, VMware, Active

Directory, Exchange

. Familiarity with MS SQL 2008 Database mirroring, Server Clustering,Log Shipping,Replication and Snapshots, Schemas, SQL profiler and

Event notification

. Familiarity with SQL Server 2008 policy management feature and

Automating Administrative tasks

. Familiarity with partitioning table, tuning indexes, creating XML

indexes.

. Strong client service background.

. Team player with strong communication, troubleshooting and technical

skills.

. The ability and desire to do what it takes to get the job done.

. Experience in handling large databases.

. All Microsoft Office products from 2000-2010 version

. Familiarity with all clinical data.

Experience

Rush Health, Chicago.IL

2013-Present

BI Developer

. Worked with ICD-9 codes. Created documentations on all reports that

uses ICD-9 codes.

. Worked with CPT codes and used these codes in various reports

. Created tabular, matrix, chart, drilldown reports, cascaded reports,

dashboards and scorecards reports according to business requirement.

. Created parameterized reports passing parameter through report screen

. Converted Dundas reports to SSRS reports. Troubles hooted and fixed

all Dundas reports.

. Use Dundas Charting API to develop and maintain analytical tools.

. Develop web-based business dashboards as required, working with web

development team.

. Troubleshoot implementation issues, test security of roll-out.

. Develop and assist in managing project plans to achieve projects.

. Identify project risks and impediments, notify management, and

proactively work with other members of the team to complete assigned

tasks as defined by project scope, timelines.

. Support technical development of BI reports, applications and other

tools.

. Ensure a high level of availability for all critical reports and

applications.

. Ensure overall security of reports. This includes developing an

understanding of Rush Health's security standards and testing to

ensure they are integrated in all reporting.

. Worked on Blue cross Blue shield project which runs on monthly basis.

Owner of the projects. Modify and created new documentation and

checklist for that project.

. Created high volume Maps using SSRS reports

. Assist project sponsors in the interpretation and use of the results;

ensure that the data is understood by users.

. Prepare supporting documentation, reports and presentation materials.

. Create ad-hoc queries and reports as requested and provide on-going

analytical support for these requests. Convert existing reporting

tools to a standardized reporting infrastructure using SQL and

Microsoft products.

Madden, Wooddale.IL

2011 to 2012

Data Warehouse Analyst

. Successfully Extracted transformed and load data into Data Warehouse.

. Experience in generating on-demand and scheduled reports for business

analysis or management decision using SQL Server Reporting Services

. Created tabular, matrix, chart, drilldown reports, cascaded reports,

dashboards and scorecards reports according to business requirement.

. Created parameterized reports passing parameter through report screen

. Deployed reports on Share Point Server.

. Used Team Foundation Server (2008) for version control, source

control and reporting.

. Rendered reports in different formats like PDF, Excel etc to be

executed automatically on daily or monthly basis and managed

subscriptions.

. Scheduled packages tasks using MS jobs

. Prepared the Layouts by placing the fields to the appropriate place

according to the requirement of the final Report

. Good command of writing ad-hoc queries utilizing SQLCMD command line

utility.

. Experience in creating master and child packages, package

configurations and logging.

. Created alerts, notifications, and e-mails for system errors.

. Responsible for managing, prioritizing and solving data and reporting

issues/problems as they arise.

. Develops and maintains reports and analyzes data for department staff,Madden staff and clients

East Bank Club, Chicago.IL

2010 to 2011

Database Analyst

. Responsible for securing, designing, implementation, and maintaining

all

Company databases and daily batch jobs.

. Provided data flow diagrams, and documents processes.

. Modified and constructed all stored procedures.

. Responsible for programming and maintenance of all SQL database.

. Provided level 1-2 technical support to helpdesk on various general

computer issues.

. Created routine maintenance and backup procedures.

. Automated daily Job processes.

. Wrote SQL scripts to extract data from various databases.

. Developed and troubleshooted various database system interface.

. Installed various software applications.

. Created jobs using SQL scripts and stored procedures for various

complex in-house projects.

. Corrected and troubleshooted various membership issues on daily basis.

. Created pivot tables, Ad hoc and SSRS reports.

. Managed all Women's Locker Room IT related issues.

. Worked after hours for support.

. Maintained a good Vendor relationship.

. Helped in designing a web based link for online store.

The Services Group, Lombard.IL

2002 to 2009

Senior Programmer Analyst

. Responsible for administrating, monitoring, performance tuning,

installs and upgrades and backups of SQL 2000 database.

. MS Analysis Services experience.

. Design and Develop SQL Server Analysis Services (SSAS) cubes using the

Unified Dimensional Model (UDM).

. Responsible for updating cubes on monthly basis that provides

instantaneous access to live counts and on-line selection of actual

record.

. Responsible for building DTS, SSIS packages.

. Responsible for writing queries, stored procedures, and triggers.

. Perform various day to day tasks using SQL*Loader..

. Managed database security, logins, users, roles and object

permissions.

. Performed analysis, tuning and optimization on large databases

. Act as an assistance and backup DBA for Oracle Database.

. Assisted team members with various duties and tasks.

. Helped Company in achieving prospect projects for quick turnaround.

. Monitor production system and took proactive measures to ensure we

have secure, high-performing system.

Metromail/Experian, Schaumburg.IL

1998 to 2002

Programmer Analyst

. Standardized Production processes in an effort to minimize reruns.

. Implemented Company wide paperless billing system.

. Creatively utilized in house programs to reduce client mailing cost.

. Successfully identified and resolved production problems.

. Received a Corporate award for going extra miles and doing what it

takes to get the job done.

. Worked on these in-house processes: Postal Qual (First & Third Class),

Merge Purge, HouseFile Refresh Address Hygiene, Sorts Splits,

Insource, Reverse Phone Append, NCOA, DSF, Address Capture,

Matchbacks,Complex Backend processing.

. Worked on special modeling projects using Insource bundles.

. Served as a point person in the team for housefile refresh processing.

. Member of Q.C committee. Created standard checklists and custom

checklist for clients.

. Trained co-workers on in-house processes and mentored others in jobs

tasks and procedures.

. Trained five new hired.

. Provided quick turn around on time sensitive projects that either met

or exceeded client timelines.

Mc Clean Enterprise, Palatine.IL

1998 to 1998

Consultant

. Installed various accounting software on Windows 95, Dos and NT

workstations.

. Provided on line /onsite support to clients.

. Expert on Real World accounting Software packages.

. Worked with Crystal Reports and Data Junctions.

Dearborn Group, Arlington Heights.IL

1996 to 1998

Accounts Payable/Receivable Coordinator

. Matching Purchase orders, invoicing, researching any customer issues.

. Data Entry-Accounting software.

. Responsible for receiving, coding, batching, inputting and processing

of all invoices.

. Perform various general office works.

Education

Harper College, Palatine, IL

Microsoft SQL Server 2008 Data Base Administrator.

2010

Certificate in Writing Queries using MS SQL Server 2008

Certificate in Maintaing a Microsoft SQL Server 2008 Database

Certificate in Implementing a Microsoft SQL Server 2008 Database

Certificate in Implementing Data Models and Reports with Microsoft SQL

Server 2012

Harper College, Palatine.IL

1993

Associates in Arts and computer Programming.

Programming Languages

. Q-basic, Visual Basic, C programming, COBOL, UNIX, Lotus 123, Oracle,

MS SQL 2000 Server, MS Access.

References

. Available on request.

Contact this candidate