PROFESSIONAL SUMMARY:

• Senior Report Developer/Data Base Analyst with an emphasis on db solutions for Business Intelligence, Teradata Report, Tableau, SSRS, Crystal Report, Business Objects XI, COGNOS, TOAD, and ETL. Build SQL queries and Stored Procedures, Database Reports, 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.

TECHNICAL SKILLS:

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

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

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

WORK EXPERIENCE:

Data/Business Analyst

Confidential

Responsibilities:

• Working with RBAC RSAM conversion team to identify and update External/Internal Roles RSAM Approver Group and Role owners, submit LDAP EURC request.
• Analyze and validate data by comparing multiple object data mapping reports.

Report Developer

Confidential

Responsibilities:

• Create and publish Tera data and Tableau Reports on Share Point, Maintain Share point sites to provide daily and monthly tracking reports. Pull data from Oracle DB and export to Excel.
• Test data, gather business information, comply with client’s requirement in designing, building, testing, and implementing report data using sql and report development tools. Meeting with end users to define business, and operations requirements to identify and resolve data issues.

Senior SSRS Developer

Confidential

Responsibilities:

• Developed multiple parameters based Reports and Sub Reports for Confidential ’s specific client to provide daily and monthly tracking of outage impact on service availability. Extracted data from SQL Server 2012, created data driven subscriptions to schedule report run date/time and to export and save in PDF to the assigned network drive location.
• Created user acceptance test scripts, validate Report Data, Collected business requirements and analyzed previous Access report data to convert to SSRS reports.

Senior BI Developer (Consultant)

Confidential

Responsibilities:

• Worked with Mortgage Banking Escrow Admin team to create reports and scheduled Queries in Business Objects using Oracle data base. Write/modify SQL scripts in Access database, Import Tables, Validate data, Test report 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 class .

ETL Load/Report Tester

Confidential

Responsibilities:

• 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). Create ETL Mapping documents, Test Plan, SQL Scripts to test ETL 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

Senior BI/Report Developer (Consultant)

Confidential

Responsibilities:

• 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.

Report Developer

Confidential

Responsibilities:

• 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 toensure 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.

DW Report Developer (Consultant)

Confidential

Responsibilities:

• 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.

Crystal Developer

Confidential

Responsibilities:

• 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 s. Train Company employees on Crystal report, PS query, Oracle SQL qry, and testing report data.

Business Object Report Consultant

Confidential

Responsibilities:

• 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.

SQL DB Analyst

Confidential

Responsibilities:

• 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.

Crystal Report Analyst

Confidential

Responsibilities:

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

Crystal Report

Confidential

Responsibilities:

• 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, and CSV. Report amendments and validate data on BI database and Production database during conversion to 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.

BI Developer/Data Analyst

Confidential

Responsibilities:

• Designed and Created SSIS packages to provide information to the user thru flat files, CSV, Excel and Access. Created views and SQL queries to Import tables from DB2 database to SQL server to generate reports. Evaluated information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, and distinguish user requests from the underlying needs.
• Generated feature-rich Reports on SQL Server Reporting services, Deploy reports on report server, Schedule and Deliver Reports through Subscriptions, Export results in Excel, XML, CSV, and TXT or in Access table. Created SQL Scripts, Stored procedure and ad hoc request queries on MS SQL Server and IBM DB2 database.
• Developed, executed, and maintained database test scripts and test plans. Was responsible for data validation, data integrity and research queries and report data. QA testing of codes and report output. Data Search and data analysis. Communicated and collaborated with users to analyze information needs and functional requirements. Evaluate and review the effectiveness and efficiency of existing reporting systems and develop strategies for improving or further leveraging these systems.

Crystal Report Developer/Analyst

Confidential

Responsibilities:

• Modified Crystal Queries and Reports to meet production requirements, Data Validation and Report Testing.
• Created script to change/update Data Source Location of Main Report and Sub reports.

Crystal Report Writer/

Confidential

Responsibilities:

• Created standard and advanced reports, cross tab reports, chart reports, and summary drill down reports.
• Published Reports on Crystal Web server. Mentored 2CO employees on Crystal Reports. Provided input to 2CO employee in designing and generating reports, Designed additional report format / layout for 2CO future use.

ETL Data Analyst/Developer

Confidential

Responsibilities:

• Extracted, transformed, and loaded data from Teradata (data warehouse) to Oracle target.
• Summarized, aggregated, transformed and loaded data required for the data warehouse/operational data store.
• Developed ETL standards and templates. Validated data and created program design specification. Used pre - defined transformation rules. The goal of the ETL process was to move data from Nationwide Data Warehouse Staging area to the clean Policies-in-Force staging area based on State, Coverage and Driver dimensions.

Data Analyst

Confidential

Responsibilities:

• Data search and data analysis of Scientific, Medical, Bio medical and chemical data files using STN Messenger, Anavist tool and UNIX. Data mapping with XML Schema using file design for standard file format and DataBase producer files.
• QA Testing of transformation code, mini files and master load files with Load Trace Tool. Design standard collections specification for the input files. Maintain ongoing collections support for update and changes.

Report/Data Analyst (Consultant)

JPMC Bank One

Responsibilities:

• Designed flexible reports from almost any data source. Used extensive formatting and interactivity options to empower end users with business information. Created custom Crystal Reports that use data in relational database. Developed design specifications for reports, validated and tested data for reports.
• Gathered report requirement information through Excel spread sheet, Intranet Websites, Flat files, Power Point Visio, Access linked tables as well as via conference call and meeting with data source group along with the Requestor and End Users. Responsible for researching multiple mapping questions that arise during the various JPMC data matchi processes with Bank One data and provided expertise in what to look for to ensure accurate data.

Data Warehouse Analyst / (Consultant)

Confidential

Responsibilities:

• Utilized Informatica (maps and workflows) to validate data and execute test plans while moving data from development to test to production. Created Informatica scripts to monitor the successes or failures sessions. Check Informatica source definitions, expression transformations and target definitions. Searched database, built query, scheduled processes and script execution to manage development environment. Provided data warehouse pipeline support, research and data analysis. Developed SQL Queries on SYBASE, MS SQL Server, and IBM DB2 to pull data from Vantive production database.
• Created Crystal Reports with parameters and charts, customize reports per user request. Used Cognos ReportNet Web applications to create, modify, and distribute ad hoc and managed reports.

SQL Developer (Consultant)

Confidential

Responsibilities:

• Designed Crystal reports to generate PDF files into the output directories. Created interface to the database in Access tool to allow the end user to change the text or images that are displayed in the Crystal report letter.
• Created customer portfolio database in MS SQL Server 7.0. Designed automated DTS packages to populate data, and email notification to the System administrator mentioning the status of the job.

Programmer / Report Analyst (Consultant)

Confidential

Responsibilities:

• Developed customer Web Reports, FTP Reports, Network Reports, NT Event Log Reports, Data Queries and Stored Procedures. Verified data integrity and created alerts and scheduled auto email for the support group.
• Responsible for examining and evaluating the information requirements of outsourcing team.
• Responsible for developing, evaluating, formatting and distributing SQL queries, reports or other ad hoc tools to meet information requirements of outsourcing team.

Database Analyst

Confidential

Responsibilities:

• Created Stored Procedures through SQL Queries in MS SQL Server 6.5 to retrieved data from production database with ODBC and connect the stored procedures to Crystal Report Writer.
• Assigned parameters and formula to allow user input ps in selecting variable data Range. Created programs to extract member information from SQL Server through Stored Procedures by providing output data in flat file and distributed the executable application using WISE.
• Conducted introductory and advance Crystal Report class for end user and support group.