JOJO PAUL

*** ********* **

Collierville *****

901-***-****

zndgg5@r.postjobfree.com

_____________________________________________________________________________________

SUMMARY:

Database Developer/Analyst with 4 years of experience.

Strong Experience in designing and generating reports using SQL Server reporting services. (SSRS)

Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)

Strong Experience in Designing, creating and executing SSIS.

Experience in developing reporting solutions that are integrated with MS desktop tools (e.g., MS Access, Excel)

Knowledge in Designing and Building OLAP cubes and MDX queries using Microsoft Analysis Services. (SSAS)

Extensive experience in SQL Server Development in utilizing stored procedures, functions, views and in writing codes in T- SQL.

Experience in creating and executing DTS packages.

Thorough knowledge of Data flow transformations and control flow items in BIDS 2005 and 2008

Self-motivated, creative team player with effective communication Leadership qualities.

Good Knowledge in Sql Server Administration.

Knowledge in Data Modeling.

Experience in developing Macros and formatting excel sheets.

Extensive experience in exporting of data from different sources to Database using SSIS.

Strong experience in converting excels sheets to different formats using Sql Server.

Possess strong communication and problem solving skills.

Offer proven abilities in team leadership and proactive systems support.

Familiar with Sql Server 2008.

Presently attending an advance online training in SSAS.

TECHNICAL SKILLS:

Operating Systems Windows 98/2000/XP

Databases SQL Server 2000/2005/2008,M.S. Access

Languages T-SQL

DB Utilities Query Analyzer

Utilities & Packages MS Office XP, 2000 & 97

ETL DTS,SSIS

Reporting MS Reporting service (SSRS), M.S. Excel

PROFESSIONAL EXPERIENCE:

Feb 2010 – Mar 2010

Health Spring Information Technology, Nashville

Data Analyst/SSRS Reporting

Health Spring is one of the largest Medicare Advantage coordinated care plans offering extensive, affordable healthcare coverage for people on Medicare. They provide coordination of members care through relationships with a network of doctors and hospitals.

Responsibilities:

• Design, develop, modify, and implement reports using SQL Server Reporting Services

• Deliver ad-hoc extracts that support the business requirements

• Analyzing and generating reports related to the details of members, Member coverage history, Member Interview, Providers, assessments, responses etc.

• Perform testing to ensure accuracy of reports

• Ensuring standards and best practices used in development are followed and maintained

Extensive experience in Drill down reports, Interactive Sort, Grouping, Subtotals, passing Query parameters, highlighting required data with Color formats, Navigation etc.

Service Master Information Technology, Memphis

Database Developer Mar 08 – Oct 09

Service Master provides services to residential and commercial customers in the United States, where they serve 10.5 million homes and business each year. They have leading brands like TruGreen, Terminix, AHS, Merry Maids and more. The telecom billing department was outsourced to Anchor point who managed the invoice management. They maintained a record of the invoices, implemented a validation and approval process, allocated charges to the appropriate cost centers, and produced monthly bills. The file exports allow communicating electronically with accounts payable systems and authorizing invoice payment with automated control.

Responsibilities:

• Creation of Data Source, Data Source view, Named queries, Calculated fields etc.

• Worked on different data transformations like Data Conversion, Copy Column, Derived column, Sort, Aggregate, Merge Join, Union all etc and control flow items like file system task, xml task, Bulk insert task etc.

• Assisted in transformation like lookups, Fuzzy lookups and Fuzzy grouping and also in various management tasks using BIDS

• Exporting of data from Excel sheet and other sources to Database using SSIS with data flow transformation and creating new tables.

• Writing queries in T-Sql joining different tables.

• Formatting excel sheets using Sql Server.

• Creating Stored Procedures.

• Adding/Changing Tables, columns etc in Sql Database

• Create dataset using query designer and stored procedures in SSRS

• Create reports using SSRS with parameters, Grouping, Sub grouping, Subtotals, Sorting, Drilldown reports, Conditional formatting etc

• Limiting SSRS reports using filters

• Managing permissions to individual branch managers for viewing reports

• Creating adhoc reports from Business Objects

• Creating macros and reports in Excel

• Generating reports from Access

Environment:

MS SQL 2005, Windows NT/2000/XP, M.S. Excel, Business Objects, M.S.Access

Interthinx Inc, Agoura Hills, CA Feb 07 – Feb 08

Database Developer

Interthinx is the nation’s leading provider of automated fraud protection, compliance and decision support tools for the mortgage industry. Customers rely on Interthinx, an ISO business for scientifically based automated solutions, historical analysis and consistent data collection to improve loan quality.

Involved in a project called Clear value integration where the users can know the property values, once they log in to their website.

Responsibilities:

• Worked on different data transformations like Data Conversion, Copy Column, Derived column, Sort, Aggregate, Merge Join, Union all etc and control flow items like file system task, xml task, Bulk insert task etc. in Sql Server 2005.

• Scheduling jobs for the execution of packages.

• Adding mail task for notification

• Exporting of data from Excel sheet and other sources to Database using SSIS with data flow transformation and creating new tables.

• Writing queries in T-Sql joining different tables.

• Writing T- SQL codes for the project

• Creating Stored Procedures for Batch Processing.

• Adding/Changing Tables, columns, triggers

• Creating cursors and User Defined functions.

• Creating indexes to improve the performance of the queries

• Using data conversions to convert different data types

• Creating Views for Extracting Data.

• Creating reports in SSRS

• Extensive use of Joins and sub-Queries to simplify complex queries involving multiple tables.

Environment:

MS SQL 2000, Windows NT/2000/XP, SQL Query Analyzer, Enterprise Manager

Techgene Solutions, Dallas TX Nov 05 – Nov 06

Database Developer

A new age company that provides quality IT services and Integrated Solutions to the Industry, Techgene offers a wide range of expertise in the Information Technology areas of software development services, system integration, ERP solutions, product development.

Involved in the SQL server development activities for the project designed for their HR department which includes the payroll and all other benefits provided by the company.

Had extensive training in advanced M.S. SQL Server functionalities and in BI tools.

Responsibilities:

• Created T –SQL for generating Tables, Views, and Functions etc.

• Helped the front end application developers with their queries.

• Created Indexes to speed up the queries.

• Generated SQL reports.

• Supported production environment.

• Reporting on a weekly basis to the project manager.

Environment:

Windows NT/2000/XP, MS SQL Server 2000, MS Access, MS Excel, SQL Query Analyzer

Educational Qualification:-

Bachelors in Engineering (B-Tech)

SKILLS

Database: MS SQL Server 2000/2005/2008, ETL Tools

Operating Systems: Windows 2000 / NT / XP

Desktops Tools & Applications: Microsoft Word, Excel, Access, and Power Point.

Contact this candidate