KERLINE JULES

d98jrv@r.postjobfree.com

www.linkedin.com/in/kerlinejules

(954) 600 - 1908

SUMMARY

Quick learner, self-motivated and results-oriented Professional with exposure to the four fundamental actions of data analysis: collection, transformation, analysis and presentation. Experience developing, maintaining and analyzing business intelligence to determine trends and discrepancies for a fast paced, deadline oriented and quality focused environment. Known for ability to be analytical, creative and innovative; building and maintaining databases and reporting systems. Reputation as a self-starter who performs well individually or as part of a team. Furthermore, who carries a strong desire for constant learning. Looking for a career opportunity that will continue my growth in the Information Management – Business Intelligence & Analytics space and allow me to learn new technologies. Strengths include:

• Database Report Development

• Data Extraction, Transformation and Loading

• Data Analysis / Financial Analysis

• Reporting System Efficiency

TECHNICAL TRAINING COURSES

• Windows SharePoint Services Building Collaborative Solutions with Team Web Sites

• Hyperion System 9BI + Web Analysis for Business Users

• Querying MS SQL Server 2000 with Transact-SQL

• MS Excel 2003 – Level 2 and Level 3

• MS Access 2003 – Level 1

PROFESSIONAL EXPERIENCE

ZENSAR TECHNOLOGIES - ASSURANT SOLUTIONS, INC, Miami, FL 2010

Zensar is a global software and services organization providing end-to-end services from information technology (IT) development to business process outsourcing and consulting to implementation services.

Data Analyst Consultant(Feb 2010 – Jun 2010)

Assurant Project – Claims Visions System Implementation: Capitalized expense project to develop and implement a Debt and Insurance claims systems replacing the legacy claims system, total rewrite of the front end claim processing user interfaces and migration of legacy data from Mainframe to Oracle 10g.

Data Analyst Team Function: Data Conversion, Data Rules, Data Mapping, Data Configurations, Data Dictionary, Data Warehouse and non-Data Warehouse reports.

Key Role: Collaborate with various project team members(Data Conversion Architects, Business Analyst, Systems Analyst, Software Engineers and business users) to create, modify and validate data conversion rules. Track conversion rules by maintaining a data mapping document in Excel, which contains data elements from legacy system to new system. Analyze existing system, new system and data to understand the relationships between multiple databases and processes by utilizing Entity Relationship Diagram Models(ERD), Business Design Documents (BRDs), Functional Design Documents and system process flows. Use Mainframe, SQL, MS Access and MS Excel to drill down and analyze large data sets, mining business data to identify trends, patterns and insight among the various data elements. Interpret and present conclusions, results and recommendations gained from researching data to Lead Data Analyst Architect.

• Validated over 250 data element conversion rules leveraging Mainframe, SQL, MS Access, and MS Excel to extract and analyze over 3million records of legacy data and by working closely with Business Analyst, Systems Analyst, Software Engineers, Data Conversion Architects, and business users. The conversion validation was in the critical path of the project’s completion.

• Designed and built a database that was used to assist the Business Analyst team in reconciling BRDs to the ERD Model. The reconciliation ensured that each data element had business requirements and would be used in the new system. Database tracked over 1900 data elements and their meta data and over 70 BRDs. The reconciliation further assisted in the team’s mission of promoting data integrity.

• Successfully trained several team members in using Access for data analysis. Items reviewed: Designing Tables, Queries (Join Queries, Action Queries, Sub Queries, Aggregated Queries, and etc...) and forms, filtering data through table/query view, importing and linking external data.

DEVCON SECURITY, INC., Hollywood, FL 2009

Devcon is a leading provider of installation, monitoring and related electronic security services for more than 140,000 commercial and residential customers in Florida and New York.

Manager of Business Reporting –Report Developer(Apr 2009 – Dec 2009)

Key Role: Maintained, created and administered SQL Queries and Crystal Reports for financial/business reporting. Supported the web base report publishing and delivery tool rePortal. Participated in several business intelligence requirements gathering meetings with senior managers and C-Level executives.

• Successfully developed over 40 plus KPI (Key Business Performance Indicators) Crystal Reports for the executive and operations team.

• Developed an automated senior executive KPI report package that were used for the executive meetings lead by the President of the company. Reports included the following data: sales revenue, sales ranking, sale leads, business operation efficiency, service cancellations, and recur revenue .

• Automated key company reports utilizing SQL to create views, stored procedures, Crystal Reports XI to develop the reports and web base report delivery tool rePortal to publish and schedule reports.

• Delivered several ad-hoc executive reports utilizing SQL and various functions and formulas within Excel(i.e. importing, exporting and manipulating data via pivot tables)

CITRIX SYSTEMS, INC., Fort Lauderdale, FL 2004 -- 2009

Global leader in application delivery infrastructure products and solutions servicing 200,000 organizations worldwide with 4,000+ employees and $1.4B in revenue.

Experienced Internal Operations Coordinator (Apr 2008 – Jan 2009)

Internal Operations Coordinator (Feb 2007 – Mar 2008)

Key Role: Provided financial/KPI reporting and analysis to determine trends, discrepancies and conclusions. Obtained user analysis requirements as well as defined and implemented processes necessary for sourcing and reporting various metrics and financial data. Researched, defined and presented to team options for resolving issues and processes. Assisted with managing internal and external department systems. Participated in several special projects such as the implementation of a new Learning Management System(LMS).

• Increased efficiency and quality of financial reporting systems by coordinating and implementing solutions using knowledge of database design and report design.

• Assisted / influenced management team in making key business decisions by providing essential business intelligence in the format of graphs, charts, data analysis and conclusions for World Wide Quarterly Business Reviews.

• Successfully prepared Business Process Documents for the new LMS system that were reviewed and approved by project stakeholders. Prepared the official new system training material for the business users and facilitated several training sessions.

• Received Education Operations Award for dedication towards department development.

Program Developer – Business Analyst (May 2006 – Jan 2007)

Key Role: Enhanced, maintained and supported the Education Data Warehouse database and environment activities. Enforced standards across department systems. Met with end-users to gather report requirements. Managed data warehouse support tickets using SharePoint. Communicated Crystal Report rollout schedule to appropriate stakeholders. Ensure data warehouse documentation were always accurate (design documents, data model, data dictionary and SOPs).

• Significantly improved efficiency of reporting system by successfully designing and implementing Phase 1B of the Data Warehouse, which included updating database data model, SQL Data Transformation packages (DTS) and Crystal Reports.

• Improved knowledge base of Data Warehouse by developing accurate documentation on database design, data model, data dictionary and by co-facilitating training sessions to bring end users up to speed in utilizing the reporting tool.

• Improved reporting systems efficiency by streamlining several data flow processes and data manipulations utilizing SQL Server DTS packages.

INROADS Corporate Consulting Intern (May 2004 – Apr 2006)

Key Role: Managed Consulting lab’s network infrastructure and security. Built, configured and maintained over 30 enterprise-class servers, network devices and lab access mechanisms. Configured lab’s shared resources such as FTP Site, domain controller, file shares and licenses.

• Reduced time of delivery by over 50% for lab servers, software and licenses by streamlining processes and creating standard Symantec Ghost images.

• Enhanced Consulting Lab’s knowledge base by creating multiple FAQ documents and “How To” guides.

SOFTWARE/TECHNICAL SKILLS

• Experience with Microsoft Office Suite, MS SharePoint, SQL Server Management Studio, Oracle SQL Developer, Daptive PPM(Project Portfolio Management solution), Entity Relationship Diagrams (ERDs), Business Design Documents (BRDs) and data mapping documents.

• Database report development utilizing Crystal Reports XI, MS Access, Excel(charts/graphs, and pivot tables), and rePortal (Crystal Report Publishing Tool)

• Data analysis/Financial analysis utilizing Excel , MS Access and SQL

• Data manipulation utilizing MS Access Queries, SQL, Excel Pivot tables, formulas and filters

• Data extraction from the following systems: Integral 7, Crystal Reports, Hyperion, Metrics that Matter, SAP BW, SAP R3 and Vantive

EDUCATION/CERTIFICATE

Bachelor of Business Administration, Computer Information Systems and Finance

University of Miami, Coral Gables, FL

Certificate in Financial Planning

Florida State University Center for Professional Development

ACTIVITIES/AFFLIATIONS

• Feature Story : Diversity / Careers Magazine: Internship convinces Kerline Jules to join Citrix

• Member: Urban League Young Professional Network

• Member : South Florida INROADS Alumni Association

• Member : Delta Sigma Pi Professional Fraternity

Contact this candidate