We provide IT Staff Augmentation Services!

Business Insight Analyst Resume

Des Moines, IA

SUMMARY

  • Over 9 years of extensive experience in Business Analytics Data Exploration/ Mining, Preparation, Visualization, Analytics and SAS programming having worked in data extraction, transformation and loading data to data warehouse, data analysis, updating, testing, trending, mapping analysis and business driven data validation.
  • Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process.
  • Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.
  • Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio.
  • Strong ability to write SQL queries using PROC SQL.
  • Expertise in the data analysis, DB creation, applying database constraints and make ready to load onto database.
  • Thorough grounding in all phases of analytical application development, including definition and analysis of questions with respect to available data and resources, overview of data and assessment of data quality, selection of appropriate models and statistical tests and presentation of results.
  • Experience in Data analysis and Reporting in finance and insurance sectors. SAS experience includes detailed knowledge of statistical analysis of financial and insurance data and in the production of reports, tables, graphs and listing.
  • Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
  • Significant experience in requirement gathering, building, designing and testing the application to meet the functional Design and Business Process Design.
  • Strong experience with databases like Oracle, MS SQL Server 2000, DB2 and MS Access.
  • Customize the variables to user - defined formats using PROC FORMAT in printing reports.
  • Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks
  • Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
  • Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE, SQL Server) tables using LIBNAME and SQL PASSTHRU facility.
  • Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis.
  • Hands on experience working with SAS Enterprise Guide, Information Map Studio, Data Integration Studio and Web Report Studio.
  • Pursuing International Certificate in Banking Risk and Regulation (ICBRR) from Global Association of Risk Professional (GARP).
  • Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
  • Effective team player with strong communication & interpersonal skills.

TECHNICAL SKILLS

Statistical Software: SAS 9.x (SAS/BASE, SAS/MACROS, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/REPORT, SAS/ACCESS, SAS/Connect, SAS/SQL), R, MATLABSAS BI Studio Enterprise Guide 4.3/5.1, Stored Processes, Web Report Studio, BI Dashboard, and MS Add-Ins

Languages: C, C#, Java, SQL, XML, HTML, Java Script, Ruby, Python, VBA, JSON, NOSQL

Database: MS SQL Server, Oracle, My SQL, MS ACCESS, MongoDB

Analytics: Descriptive, Predictive and Prescriptive Analytics

Big Data: Hadoop, PIG, HIVE, FLUME, Sqoop, Map Reduce programming and Oozie

Tools: MS Office 97/2000 Suite, Excel 97/2000, Visio, Ipswitch, putty

Operating Systems: Windows 2000/XP/7, Linux, UNIX

Application Server: Tomcat, JBoss, IIS

PROFESSIONAL EXPERIENCE

Confidential

Business Insight Analyst

Responsibilities:

  • Worked as Business Insight Analyst with Confidential Bank responsible for the design, development, maintenance and support of organization wide customer & operational insight applications.
  • Developed application using SAS to extract data from MS SQL Server, DB2, Oracle, flat files and excel sheets and load the data to central data warehouse.
  • Performed data analysis, generated reports, listings and graphs using SAS tools.
  • Used SAS character, Numeric and date functions like SUBSTR, INDEX, SCAN, COMPRESS, COMPBL, STRIP, INTNX, INTCK, CAT,SUM, MAX, SUM,MEAN etc. extensively to manipulate, clean and transform data.
  • Developed, implemented and maintained daily, weekly and monthly reports to optimize the organization’s operational activities.
  • Created customer and financial mortgage data sets using Data steps and DATA NULL .
  • Performed advanced querying using SAS Enterprise Guide, calculated computed columns, manipulated and prepared data for Reporting, Graphing, and Summarization, statistical analysis and generating SAS datasets.
  • Provided support with data definition, data quality, data manipulation and data validation.
  • Maintained large data sets, combined data from various sources in varying formats using Set and Merge.
  • Created SAS MACROS for applications to extend and customize SAS software programs and used existing SAS MACROS for standard reporting.
  • Extensively created summary statistics reports using SAS PROCEDURES like PROC FREQ, PROC SUMMARY, PROC REPORT, PROC MEANS, and PROC TABULATE.
  • Produced RTF, CSV, PDF and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
  • Developed auto call libraries to ensure data consistency across the application infrastructure.
  • Responsible for defining the key identifiers for each mapping/interface.
  • Responsible for defining the functional requirement documents for each source to target interface.
  • Used data analysis techniques to validate business rules and identify low quality missing data in the enterprise data warehouse (EDW). Prepared test plan, test data and test environment.
  • Tested and debugged the programs and participated in peer code review.
  • Actively participated in strategy meetings to gather and document business requirements.
  • Debugged, Created maintained and documented adhoc reports on demands.
  • Participated actively in training programs to better understand the processes and responsibilities associated with assignment.

Environment: SAS Enterprise Guide 4.3, SAS Base, SAS/MACRO, SAS /STAT, SAS/SQL, Oracle, DB2, Excel, Windows XP Professional, Unix, Oracle, MS SQL Server, HTML, Agile, Scrum

Confidential

Sr. SAS Data Analyst

Responsibilities:

  • Worked as Sr. SAS Analyst with the co-operators responsible for the design, development, maintenance and support of reports for sales department.
  • Created a data collection engine that polled various data sources and stored the resulting data in order to automate monthly strategic reporting and analysis for key accounts.
  • Designed and delivered on-going and back-end reporting for analysis.
  • Developed, modified, and generated Monthly Business Review (MBR) reports summarizing business activity.
  • Extensively created summary reports using SAS PROCEDURES like PROC FREQ, PROC SUMMARY, PROC REPORT, PROC MEANS, and PROC TABULATE.
  • Developed and created SAS Macros to access and analyze sales data.
  • Analyzed the sales data and summarized results to support meaningful recommendations for management.
  • Used extensively macro programming to optimize the code and to replace repetitive codes.
  • Performed data analysis, statistical analysis, generated reports, listing and graphs using SAS tools: SAS/BASE, SAS/GRAPH, SAS/SQL and SAS/ACCESS.
  • Created and maintained SAS datasets that are extracted from an Oracle Database using SAS/ACCESS for Oracle and extensively used Proc SQL to manipulate the data.
  • Used Proc SQL (Pass-Through) method and Proc Append methods to write statistical analysis results to the ORACLE database.
  • Extensively used Base SAS- ETL to load data from DB2, SQL server, oracle, Flat files and XML as sources to Oracle Data warehouse as target
  • Extensively used various SAS Data Step functions, SAS procedures, and SQL to write reports logics for SAS Stored Processes.
  • Extracted Data from DB2, Flat Files and converted to Analytic SAS Datasets
  • Extensively used the SET, Update and Merge statements for creating, updating and merging various SAS datasets.
  • Prepared test plan, test data and test environment.
  • Used SAS indexes to improve the efficiency of the programs.
  • Exported SAS Reports to the Excel Sheet by using ODS/Tagsets/ExcelXP to get the output in multisheets.
  • Tested and debugged the programs and participated in peer code review.
  • Supported the Manager in development of SDLC project documents.
  • Participated in user requirement discussions and data quality assessment.
  • Effectively worked with users to define business processes and information systems for supporting those processes.

Environment: SAS/BASE, SAS/MACROS, SAS Enterprise Guide, Web Report Studio, SAS/STAT, SAS/SQL, DB2, Microsoft Add-Ins, Windows/XP, UNIX, SQL Server, Oracle, Flat Files

Confidential, Des Moines, IA

Analytic Consultant

Responsibilities:

  • Working as Analytics Consultant with WFF’s Servicing Data & Analytics SDA team, responsible for design, development, maintenance and optimization of bankruptcy, WFF conversion, Foreclosure and operational support reports.
  • Interacted with business user to discuss and finalize the business requirement and report format.
  • Performed dataset creation, including data extraction, data transformation and data quality assessment.
  • Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
  • Produced RTF, CSV, PDF and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
  • Improved the business process to send letter to customers and update dataset through reverse batch process when the letter sent to customer is confirmed by EUS team.
  • Used SAS Hash tables to decrease the processing time by 60% for long running programs.
  • Developed auto call libraries to support repetitive business processes which helped to standardize the report output, promote code reusability and modular programming across the SDA department.
  • Performed analysis of the reporting infrastructure and make recommendations to make it responsive, efficient through code base reusability, exceptional handling and multilevel dependency architecture.
  • Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge.
  • Developed SAS Macros to clean, validate and process data to perform data analysis and develop reports.
  • Developed, modified and generated daily, Monthly and Quarterly reports summarizing business activity.
  • Developed recursive program in Base SAS to dynamically delete the archived reports periodically from the server.
  • Use SAS indexes to improve the efficiency of the programs.
  • Performed root cause analysis for failed processes and introduced exception handling in development of reports.
  • Created, maintained and documented adhoc reports on demand.
  • Extensively used SAS character, numeric and date functions like SUBSTR, INDEX, SCAN, COMPRESS, COMPBL, STRIP, INTNX, INTCK, CAT,SUM, MAX, SUM,MEAN etc. to clean, validate and standardize the data and to create the reports.
  • Used SAS formats extensively to make the reports user friendly.
  • Analyzed output, perform data validations and wrote reports.
  • Participated actively in weekly and monthly department meetings.
  • Participated in training programs to better understand the processes and responsibilities associated with assignment.

Environment: SAS Enterprise Guide 4.3/5.1, SAS Grid, SAS/Base, SAS/ETL, SAS/MACRO, SAS/SQL, Oracle, DB2, Excel, Windows XP Professional/7.0, AIX/UNIX, Ipswitch, Agile, Scrum

Confidential

SAS Data Analyst / Developer

Responsibilities:

  • Worked as SAS Data Analyst/ Developer with Confidential bank responsible for the design, development, maintenance and support of logical data models for the product lines.
  • Extracted data from Oracle, created into datasets. Performing data validation, transforming data from RDBMS oracle to SAS datasets
  • Done Enhancements for the existing business reports like incorporating new business variables.
  • Developed, modified, and generated Monthly Business Review (MBR) reports summarizing business activity.
  • Worked closely with data modeling team and management like Marketing managers, Campaign managers, financial managers etc., to analyze customer related data, generate custom reports, tables and listings.
  • Worked extensively in sorting, merging, concatenating and Dynamic Formatting as optimized technique for SAS data sets.
  • Summarizing of data using SAS Procedures like PROC FREQ /PROC UNIVARIATE.
  • Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes.
  • Used SAS procedures for Importing and Exporting data to MS-Excel.
  • Transformed data using Base SAS Procedures & Functions.
  • Extensively used Base SAS- ETL to load data from DB2, SQL server, oracle, Flat files and XML as sources to Oracle Data warehouse as target.
  • Worked on Source and Target Metadata creation & developed many jobs to load data from source into target.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ETL, Sybase, Oracle, flat files.

Hire Now