Databases/Tools: Tableau Dashboard, Cross Tab, SSRS, Business Objects, Crystal Report, InfoView, BOXI R2, Cognos, MS SQL Server, Access Report, Actuate, Red Prairie, Teradata SQL Assistant, Oracle, Toad, IBM DB2, Sybase, MySQL, MS Office, Excel, SharePoint, Visio, PowerPoint, UltraEdit, NotePad, InfoView, Qlikview, TextEdit, Frontier, SSIS, Informatica. Data research, validation and Data Cleanup
Client: Verizon, Hilliard, OH//Arctech Consulting Aug – Sept 2019
Data Analyst/Visual Reporting
Designed Crosstab and Tabular reports, Tableau Dashboard for Weekly KPI performance worksheet, Developed and published Mixed and Match Pricing Dashboard. Generated Wi Fi Data Feed extract script for client supported vehicle companies. Meeting with end users to define business, and operations requirements to identify and resolve data issues. Created Access Tables and Reports thru importing Excel files.
Using Terada data SQL Assistant created tables to include segments, amended SQL scripts. To test KPI store data created test tables on Teradata warehouse sand box. Identified and Conformed business users SAP GL Columns. Data Analysis and Data Validation on Tera dada KPI Data Warehouse.
Client: JPMC, Columbus, OH//Tata Consulting Sep 2014 – Sep 2017
Developed Tableau workbooks, visualizations using Tableau Desktop, published Reports utilizing relevant Data sources, Maintained ongoing Report scheduling and converted Crystal to BO reports. Published Teradata and Oracle extract on SharePoint, maintained SharePoint sites to provide daily and monthly tracking Excel reports.
Report Automation, set up Report Scheduler and Test data, gathered business information, and comply with client’s data requirement in designing, building, and implementing BO reports using SQL and report development tools.
Worked with RBAC RSAM conversion team to identify and update External/Internal Roles RSAM Approver Group and Role owners, submit LDAP EURC request. Exported reports in Excel and PDF to users’ sites.
Client: Fiserv, Dublin, OH/Primus Software Apr 2014 – Aug 2014
Report Data Analyst
Developed and Automated SSRS Reports and Sub Reports, Dashboard for Fiserv’s specific 400 client to provide daily, monthly tracking of outage impact on service availability. Ensure accuracy and quality of data through data channels.
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 User reports.
Client: JPMorgan Chase/Collabera Inc. Jun 2013 – Mar 2014
DW Developer/Data Analyst
Designed Tableau, Business Objects and Crystal Reports per business request, Data extraction, data visualization in the form of charts, maps, and other graphical representations enabling business users to better understand data and use it to achieve tactical and strategic objectives. Created Cognos reports, published Tableau reports to user’s sites.
Assisted data governance team in the formation of data governance framework, policy, standards. Worked with Mortgage Banking Escrow Admin team to scheduled Queries using Oracle database and SQL Server, created Excel extract, Data validation, cleanup data, test data results, wrote/modified SQL scripts in database, Imported Table data. Gathered business requirements, contacted users on request clarification. Ran daily Standard Access reports, download files, import Loans files to run Adhoc queries.
Client: Cardinal Health/Centric Consulting Sep 2012 – Jun 2013
Data Process Analyst
Ensured data integrity, gathered business data requirements and information to wrote SQL query on IBM DB2 databases. SQL Scripts to test ETL data from Teradata, Oracle, and Flat Files to IBM DB2 and Teradata Databases using IBM Data Stage Director, Designer. Created ETL Mapping documents, Test Plan.
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). Designed and publish reports, built/ amended Views to build reports, test data, report layout and schedule reports per user request.
Client: Exel, Columbus, OH/ Insight Global Nov 2011 – Aug 2012
Business/ Data Analyst
Developed, updated, modified, and automated reports for packing list, Bill of Lading, Labels, Month end and Year end reports. Created / amended scripts and query using TextEdit and Toad SQL tools. Used FileZilla FTP application to upload or download multiple files. Received business requirements, gathered information, and translated software requirements into workable programming code and maintained and developed reports for use in business.
On completion of a service request, executed testing sample data-sets to ensure the output and submit patch to upload reports/files to testing environment. Duties involved collecting information, comply with client’s requirement, designing, building, testing, implementing and sometimes supporting reports using SQL and report tools.
Client: ECOT, Columbus, OH//Centric Consulting Feb 2011 – Oct 2011
DB Report Developer
Assisted in testing data, data validation during system conversion and upgrade claim application. Developed QlikView DB and SQL 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.
Client: Nationwide/SSI Consulting Apr 2010 – Feb 2011
Crystal BO Developer /Data Analyst
Built and designed BO and Crystal reports through ODBC connection to Oracle database and utilized Crystal as an ETL tool to process and send bank data through Admin scheduler. Updated Recollector Lookup tables, created date time batch files. Worked on Frontier Recon Database to validate data, create and modify reports.
Created Crystal reports based on PeopleSoft queries per user documents. Modified and updated query and reports as requested upon UAT. Completed technical design to meet functional requirements and future references. Trained company employees on Crystal report, PS query, Oracle SQL query, and testing report data.
Updated BO reports to match clients existing records and business rules, scheduling reports using InfoView. Developed Intercompany Detail and Control Files for Treasury Work Stations applications
Client: Citi Group/Norgate Technology Jul 2009 – Mar 2010
Crystal/ SSRS DB Analyst (Consultant)
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.
Client: The Columbus Dispatch Company/BrookSource Mar 2008 – Jul 2009
SSRS/Crystal Report Data Analyst
Modified existing reports and built new SSRS and 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.
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. 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.
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. Created User Acceptance Test plan for reports
Client: Safe Auto/ICC May 2007 – Feb 2008
BI SQL Report Developer/Data Analyst
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, deployed reports on report server, scheduled and delivered reports through Subscriptions, exported 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.
Evaluated and reviewed the effectiveness and efficiency of existing reporting systems and develop strategies for improving or further leveraging these systems.
Client: BMWFS/ICC Jan 2007 - May 2007
Crystal Report Developer/Analyst
Analyzed and gathered information to amend existing Budget Master Reports.
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.
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.
Client: Nationwide Insurance/ICC Jun 2006 – Dec 2006
ETL Data Analyst/Report Developer
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.
APT/Chemical Abstract Society (CAS)/APT May 2005 – Jun 2006
Data Analyst (Consultant)
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.
Coursework in Corporate Finance, The Ohio State University
Coursework in Financial Accounting, Marketing, and Business Communications, Valencia Community College, Orlando, FL. Master’s Degree in Physics, University of Dhaka, Dhaka Bangladesh