Professional Summary

Senior Data Analyst/ Report Developer with an emphasis on db solutions for Business Intelligence, Crystal Reports, Business Objects XI, SSIS, SSRS, TOAD, and ETL. Analyze and Validate Data. Interpret customer business needs and translate into operational requirements. Worked on various client projects using SQL skills to verify data, create and publish reports as well as analyze problems. Build SQL queries and Stored Procedures, Database Reports.

Databases: Oracle, SQL Server Enterprise, DB2, Teradata, Data Stage, Sybase, Access, MYSQL

Tools/Packages: Crystal Report, Info View, Business Objects, BOXI R2, SSRS, COGNOS, Toad, Red Prairie reporting tool, LextEdit SQL tool, People Soft, Frontier, SSIS, Actuate, FileZilla,Informatica, MS Office, SharePoint, Visio.

Operating Systems: Windows 2007//NT/2000/XP, UNIX.

Experience

Confidential

• Worked at Mortgage Banking Escrow Admin department to create reports and scheduled Queries in Business Objects using Oracle data base. Write/modify SQL scripts in Access database, Import Tables, Validate data and Test report Data results.
• Gather business requirements, contact users for request clarification. Run Daily Standard Access reports, download files, import Loans to run Adhoc queries in BO and Access.
• Completed COGNOS 10 Report Studio beginners and advance online and in lass training.

Confidential

• Worked on Generic Costing Project to automate the manual Generic Sourcing team's process from Cost Analysis to Manufacturer Engagement utilizing Business Process Management BPM . Organizing, Analyzing and maintaining the data collected from diverse sources.
• Created Test Plan, SQL Scripts to test ETL data, ETL Mapping documents to move Data from Teradata, Oracle, and Flat Files to IBM DB2 and Tearadata Databases using IBM DataStage Director, Designer. Run jobs/Sequences in Director and monitor job run and verify job logs.
• QC testing of BOBJ Reports , Xcelcius Dashboard , Nightly Jobs and Adhoc Coaches

Confidential

• Designed Crystal reports and publish reports on Info View, build/ amend SQL scripts and query using in MS SQL Server 2008 R2. Create Views to build reports.
• Gathered business requirements and information to write sql query and reports, test data, report layout and schedule reports per user request.

Confidential

• Develop, update, modify, and repair Reports for packing list, Bill of Lading, Labels, Month end and Year end reports. Create / amend scripts and query using LextEdit and Toad sql tools. Use FileZilla FTP application to upload or download multiple files. Receive business requirements, gather information, and translate software requirements into workable programming code and maintain and develop reports for use in business.
• On completion of a service request execute testing sample data-sets to ensure the output and submit patch to upload reports/files to testing environment. Duties involve collecting information, comply with client's requirement, designing, building, testing, implementing and sometimes supporting reports using sql and report development tools.

Confidential

• Developed Reports and Stored Procedures on MS Reporting Services SSRS per user requirements. Update and modify query and reports as requested upon UAT. Upload reports on report server pages.Built

• ETL packages for the Data warehouse project using MS SSIS Designer. Modify/add/customize items per individual package requirements. Perform Unit Testing and complete Migration checklist. Test planning and execution, write test scripts, sp specs, verify queries and Validate data.

Confidential

• Built and designed Crystal reports through ODBC connection to Oracle database and utilized Crystal as an ETL tool to process and send bank data through Admin scheduler. Update Recollector Lookup tables, Create date time batch files. Work on Frontier Recon Database to validate data, create and modify reports.
• Developed Intercompany Detail and Control Files for Treasury Work Stations applications.
• Created Crystal reports based on People soft queries per user documents. Modify and update query and reports as requested upon UAT. Complete technical design to meet functional requirements and future references. Train Company employees on Crystal report, PS query, Oracle SQL qry, and testing report data.

Confidential

• Updated BO reports and queries to match clients existing records and business rules.
• Worked on adhoc queries, reports, scheduling and deliver reports using Infoview .
• Assisted in testing data, data validation during system conversion and upgrade claim application.

Confidential

• Developed Crystal reports and published in Frontier Recon Report site following User Acceptance Testing. Gathered report requirements and validated data with business units.
• Using Frontier Recon application created new client accounts, organized formatters, loaded large data volumes of incoming files with high-performance ETL product Ab Initio. Checked data quality in test and production environment. Created stored procedures and reports in SQL 2008 and SSRS. Converted existing legacy Access reports to SQL Server Reporting Services. Uploaded reports to reporting server and set up subscriptions. Worked on Actuate e- Reporting to re-create stored procedures to produce reports on MS Reporting Services.

Confidential

.Modified existing reports and built new Crystal reports per user requirements. Provided training to employees to create Crystal reports through ODBC connection to their SQL server database. Analyzed SQL query script and researched report data.

Confidential

• Created views and table synonym on BI database. Run ad hoc queries and reports Developed and published reports on Crystal Viewer, set up Business Object Management console per user requirement to schedule parameters, run and export report in PDF, Excel, CSV or XML. Created Statements in XML format, read XML files to test data and export to users. Report amendments and validate report data on BI database and Production database during conversion to Mactive application 8.0.
• Developed SQL-queries/procedures for database and backend testing. Worked with business teams to prepare, prioritize and deliver reports for all functional areas across the organization.
• Created User Acceptance Test plan for reports. Ran BI-Populator to test data in Production database and BI database. Testing Statements Run, Ad Base E, System Admin - Email Configuration. Updated Confirmation Ticket reports and logos.
• Gathered business requirements, designed and developed and modified financial and operational reports and programs for all businesses. Meeting with end users to define business, financial, and operations requirements and identify and resolve database issues.