SUMMARY:

• Experienced, versatile professional with experience in sales, marketing, and customer support services, custom reporting, within diverse industries and corporations.
• Operations Management
• Strong Business Analytical Skills
• Cost Analysis
• Financial Reporting
• Project Management
• Team Management, Supervision, and Motivation
• Customer Support
• Computer Proficiency: Microsoft Word, Excel, PowerPoint, various accounting systems
• Experienced in custom reporting and analytics (Crystal Reports, Web Intelligence, Universes, Desktop Intelligence, Xcelsius)
• Experienced in managing and migrating metadata from legacy systems and using staging area for planning and performance optimization for Data Services (BODI) projects

TECHNICAL SKILLS:

Languages: C++, SQL, PL/SQL, TSQL, Python

Web Technologies: HTML, JavaScript

Operating Systems: Windows

ETL and BI: Informatica Power Center, Microsoft DTS, SSIS, Datastage, Sagient,Data Services

RDBMS: Oracle, SQL Server, Sybase, Teradata

Other: Microsoft Office, Visio, Erwin, TOAD, Oracle SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Manvel TX

BI Database/SAP Crystal Report Developer

Responsibilities:

• Gathered and communicate business requirements to members of technical team bridging the gap between business users and IT development.
• Collaborate with team database architects and other business intelligence experts in developing cutting edge solutions for client’s internal products and solutions.
• Support production development by creating documentation and completing tasks per schedule while staying within target cost.
• Interacting with functional personnel on technical masters and supporting user technical testing
• Evaluating and delivering enterprise - wide tool sets for varying user aptitudes
• Active participation in Data Warehouse design, development, and support activities
• Development of batch jobs through compiling workflows and dataflows, using kornshell scripts for job execution on UNIX boxes, developing Data Models using star, snowflake and complex snowflake schemas design.
• Development of Business Objects Universes and Web intelligence Documents with updated data using the metadata manager from BODI.
• Used the administrator of the management console for immediate and scheduled job execution in order for to avoid conflict with in other applications that may be resourcing data from BODI datastores.
• Constructed strategies for migration from the design through production phases while configuring multi-user environments and implementing version control with use of central repositories.
• (Data Quality)- employed statistical analysis while submitting profiling tasks to benchmark data before the cleansing process using the data profiler tool. Configuration of transforms with business rules, directories, rule files and dictionaries for parsing and cleansing data before loading into target system.

Confidential

Crystal Report Developer

Responsibilities:

• Provided documented custom crystal reports
• Developed dashboard like reports for doctors and billing companies
• Delivered 20 custom crystal reports in short time frame as well as provide mentoring and knowledge

Confidential

Crystal Reports/BO Developer

Responsibilities:

• Assisted with Development of Business Objects Universes and Web Intelligence (Business Objects 4.0).
• Used Data Services to migrate Data from SAP into SQL Server (ODS) and then into the Finance Mart.

Confidential

Reports Developer

Responsibilities:

• Advised Scana to used Fast load process to load tables in to warehouse.
• Provided guidance on best practice approach to development.
• Developed standard loading templates and templates for CDC

Confidential

Reports Developer

Responsibilities:

• Supported in resolving issues with Data Services and Data Quality for development team
• Provided guidance on best practice approach to development

Confidential

Crystal Reports Developer

Responsibilities:

• Used Data Services (BODI/Q) in a data migration from VSAM using mainframe interface and Attunity Connector for file access of various sizes.
• Created BI Roadmap that included upgraded strategy to BOE 4.0.
• Delivered Data Services (BODI/Q) jobs that processed flat files from VSAM in parallel with use of COBOL Copybooks for smaller files.
• Assisted in delivery of a project called 4R - which utilized Web Intelligence and Crystal Reports for analytics using data that was pulled from the above mentioned designed warehouse.
• Upgraded and migrated universe and reports from 4R project to BOE 4.0.
• Upgraded Data Services Jobs to version 4.0
• Provided end user and knowledge transfer and intellectual collateral.:
• Worked in Universe and Web Intelligence /Crystal Reports from ODS
• Upgrade DS and Metadata Manager from BOE 3.2 to IPS 4.0/DS 4.0/IS 4.0
• Upgrade BOE 3.2 to BOE 4.0
• Project migrated universes and reports from BOE 3.2 to 4.0

Confidential

Data Migration Assitstant

Responsibilities:

• Used Data Services (BODI/Q) in a data migration from SAP FICO to datamarts on SQL Server
• Delivered Data Services (BODI/Q) jobs that processed FICO data and loaded into DB2
• Configured the data profiler in BODI by registering the repository with the administrator and designer to profile staged data, and benchmark the quality of data.
• Used Data Services (BODI/Q) to implement and configure Universal Data Cleanse transforms to cleanse operational data before loading into SQL Server based datamarts
• Creating and managing data dictionaries which included cloning, merging and backing up to be used with data cleansing transforms
• Delivered data from staging area to datamarts for finance and hr.

Confidential

ETL/Data Migration Architect Assistant

Responsibilities:

• Delivered Data Services (BODI/Q) jobs that processed flat files from VSAM through use of COBOL Copybooks for smaller files and larger files to use the mainframe interface.
• Used Data Services (BODI/Q) to implement and configure Universal Data Cleanse transforms to cleanse operational data before loading into SQL Server based datamarts
• Creating and managing data dictionaries which included cloning, merging and backing up to be used with data cleansing transforms
• Enhanced the quality of operational data through deployment of data quality job
• Migrated data from mainframe to datamarts in SQL Server.

Confidential, Millington, TN

Business Analyst

Responsibilities:

• Migration Consisted of 30 - 40 Crystal Reports
• Migration Consisted of 5 Scorecards/Dashboard
• Resolved Performance issues with Webi Docs

Confidential, Chicago, IL

Report Developer

Responsibilities:

• Translated requirements into designing and development of Business Objects Universes for end user reporting from Financial and HR DataMarts
• Experienced building and deploying complex reports involving formulas, dynamic parameters, crosstabs and sub-reports
• Developed dashboards using Xcelsius

Confidential

ETL/Data Migration Assistant

Responsibilities:

• Used Data Services (BODI/Q) in a data migration from IBM AS400 to datamarts on SQL Server
• Delivered Data Services (BODI/Q) jobs that processed flat files from AS400 against validation transforms that contained business and standardization rules to begin profiling the data while it’s being staged.
• Configured the data profiler in BODI by registering the repository with the administrator and designer to profile staged data, and benchmark the quality of data.
• Used Data Services (BODI/Q) to implement and configure Universal Data Cleanse transforms to cleanse operational data before loading into SQL Server based datamarts
• Creating and managing data dictionaries which included cloning, merging and backing up to be used with data cleansing transforms
• Delivered data from staging area to datamarts for finance and hr.

Confidential, Las Vegas, NV

OWNER/OPERATOR

Responsibilities:

• Developed and facilitated company RFP process
• Provided client project cost-based solutions using combined data structures
• Established healthy relationships with clients and vendors; emphasized maintaining timely receivables and payables.
• Analyzed and audited project data files in an effort to maximize profit and cash flow.
• Facilitated all human resources aspects of running an independent business.

Confidential, Las Vegas, NV

CUSTOMER SERVICE SUPERVISOR

Responsibilities:

• Coordinated with the billing department to ensure accuracy with customer invoices; provided support to management to aid in billing disputes.
• Responsible for dormant account recapture as well as obtaining and servicing new accounts through competitive research.
• Resolved security issues for the entire service area (OH, IN, IL, TX, CA, and HI).