We provide IT Staff Augmentation Services!

Sr. Bi Analyst Resume

Mossville, IL

SUMMARY:

  • Extensive experience of 7 years in Business Intelligence Applications using Business Objects, Microstrategy, Cognos/ Oracle Business Intelligence (OBIEE/OBIA).
  • Experience in Installation and configuring the Cognos 10/8 and CRN environment and implementing third party security tools Tivoli directory Server and Sun One with Single Sign on.
  • Vast experience in presentation using SAS, Excel, Pivot Tables, Confidential for presenting the end results.
  • Proven skills in SAS Base (data step and Confidential ) and SAS Macro fulfilling on demand business needs.
  • Advanced SQL skills with ability to code complex queries to load, clean, format & store data.
  • Experience with several ETL jobs using SAS DI Studio to port the Confidential data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data.
  • Skillful in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
  • Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
  • Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
  • Expert in developing and modifying multi-dimensional cubes using MS SQL Server … Analysis Services (SSAS).
  • Experience in SQL server administrative skills including, backups, disaster recovery, database maintenance, user roles, authentication and authorizations and database creation.
  • Involved in database design & administration experience on SQL Azure, MS-SQL Server … 2008 R2/ 2012.
  • Evaluated structured and unstructured datasets utilizing data mining, and predictive analytics to gain additional business insights.
  • Hands on experience in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS.
  • Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
  • Experience with the code complex MDX code for OLAP cubes to have a tradeoff between storage space and performance.
  • Experience in SAS/STAT with linear and logistic regression, ANOVA, DOE, Clustering etc to gain insight into the data.
  • Skilled in analytical and business reporting using SAS, MS Office, VBA and RDBMS technologies.
  • Conceptual knowledge of marketing mix, segmentation and association rules, market basket analysis, test and control groups, sample size criteria, hypothesis testing etc in marketing domain.
  • Experience in loading SAS Metadata Server with metadata from external packages for ETL development.
  • Extensive experience in preparing and reviewing Confidential, Confidential documents to serve development and reporting.
  • Experience in coding mathematical expressions in SAS as per the requirement using legacy and new functions.
  • Expertise in Unica Campaign module, Teradata Aprimo (CIM), campaign flowcharts as well as hands on experience in IBM Unica, Teradata Aprimo (CIM), Teradata SQL and SAS.
  • Strong knowledge of functional aspects of Unica campaign and advanced concepts like custom macros.
  • Good experience with big data sets and manipulating them to drive meaningful insights.
  • Familiar with Cognos EP software where you can develop budgets and forecasts.
  • Strong understanding in OLTP/OLAP system study, analysis, E-R modeling and different DW design paradigms.
  • Strong proficiency in different SDLC methodologies including Agile and linear models as well as solid experience in Oracle SQL and PL/SQL and query optimization techniques.
  • Skilled at training users to use Query Studio and Analysis Studio and Cognos Workspace.
  • Experience in Storage Domain and Product Testing of HP- Virtual Storage Appliance (VSA) and VMware - Virtualization and DP/Net Backup Tool.

WORK EXPERIENCE:

Confidential, Mossville, IL

Sr. BI Analyst

Responsibilities:

  • Imported data from SQL Server and Excel to SAS datasets. Performed data manipulation by merging several datasets and extracted relevant information.
  • Implemented research forecasting models into production by usingBase SAS, SAS Macros, Confidential SQL and many other SAS tools.
  • Assisted architecture team in moving layers of the EDW fromOracle to Teradata for using SAS In Database technology.
  • In depth technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
  • Extensive ETL testing experience using MS SSIS
  • Experience in creating Test Data, Analyzing Defects and interacting with development team to resolve issues.
  • Experience in testing requirements that were developed in ETL and BI tools and reviewed scripts for positive and negative test scenarios, and prepared test summary reports.
  • Interacted with the business users to understand the impacts of replacing the existing Epiphany with UNICA.
  • Developed a Compatibility layer to replace the existing flow of data into the Operational Data Store from UNICA.
  • Wrote complex SQL queries for querying data against different data bases for data verification process.
  • Wrote Teradata code / SQL to enable the ETL processes to meet demanding business requirements, including BTEQs, Fast Loads, Multi Loads, and Fast Exports.
  • Used SAS datasets to create reports using Confidential Print and Reports and also used Confidential Transpose, Confidential Tabulate, Confidential Import, Confidential Freq and Confidential SQL.
  • Wrote complex SQL queries using TOAD/PLSQL DEVELOPER against the ORACLE database (to perform Data Analysis and Data validation).
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
  • Presented complex analytics and KPIs using BI reporting tools and query languages such as IBM ShowCase, Microstrategy, SQL, Access, and Excel and provide insight into retail trends to all levels of the organization.
  • Worked with date engineering to design OLAP data models and reporting structures to create operational reporting to support products.
  • Involved in Reverse engineering of current campaign reporting across LoB’s with consolidation of campaign met-rics and reporting dimensions for expansion of the new reporting data mart to support future reporting.
  • Involved in the generation of Flow thru's for the incoming Purchase orders from Hub to spokes and importing the data to the SQL Server 2008 Database for the Buyers team.
  • Constructed campaigns using a combination of Unica campaign, Teradata Aprimo (CIM), SQL based on inputs from the campaign owners.
  • Evaluated the existing triggered campaigns and optimize them for better performance.
  • Worked on website traffic analysis and drive special promotional campaigns for them.
  • Designed a cart abandonment campaign in collaboration with business team, web-analytics team and Unica/Aprimo technical team.
  • Used business applications; decision support systems, query and reporting, online analytical processing, statistical analysis and data mining.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.
  • Microsoft SQL Server management and performance tuning. Focuses on index tuning, query modifications, partitioning and hardware optimization.
  • Worked along with Microstrategy Knowledge Base to troubleshoot some Report related issues.
  • Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
  • Reviewed and reverse engineer business and technical requirements in existing SSRS report suite, facilitate meetings with Accounting, Finance and Risk department stakeholders for requirement validation, enhancement and prioritization
  • Liaison between functional business teams and coordinate with data architects, DBAs, ETL and BI developers to formulate enterprise solutions and drive Microstrategy report adoption within the business
  • Ensured tables and dependencies for high priority reports are prioritized for conformation across systems prior to QA testing
  • Collected end-user feedback from review sessions of converted reports and provide detailed updates at stand up meetings
  • Tested the Application Objects (Metrics, Reports, Documents, filters, prompts) using Microstrategy Desktop and Microstrategy web interfaces.
  • Designed and populated reporting tables, views and stored procedures.
  • Designed and executed various SSIS packages by using various data flows to load the data from source to destination as a part of validation.
  • Created the SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate and Lookups Functions.
  • Created Charts, Tabular, Matrix, Drill Down, Drill Through, Cross Tab reports using SSRS 2012.
  • Developed, extracted, transformed and loaded (ETL), maintained and supported the enterprise data warehouse system and corresponding marts.
  • Generated Risk reports every week to find the Items which are on hold by using SSIS packages and used SSMS 2008 to pull the data from different databases.
  • Experience in setting up of new vendor, Schedule changes, moving buy dates etc using SQL server 2008
  • Experience in design, development, and implementation of SQL Server Analysis Services (SSAS) reports/cubes.
  • Created business intelligence tools or systems, including design of related databases, spreadsheets, or outputs. May determine the costs and benefits of strategic initiatives, using incumbent business, technology, and project life cycle experience
  • Responsible for creating database objects like Views, Store Procedure, Triggers, and Functions etc.

Confidential, Charlotte, NC

BI Analyst

Responsibilities:

  • Analyzed credit card, residential mortgage and overdrafts data and generating analytical reports using SAS & SQL in PC and Unix environment.
  • Extracted data from different sources like Oracle database, Excel, Access, and text/CSV files using SAS/Access, SAS/SQL in SAS environment and creating SAS files.
  • Used SAS Confidential SQL pass through facility to connect to Oracle tables.
  • Design campaigns in Unica as per the business requirement as well as built and maintained recurring campaigns.
  • Performed the role of Unica business analyst by interfacing with the business users to document campaign requirements.
  • Worked on extracting the data using SSIS from OLTP to OLAP as well as involved in identifying and defining Data Source and Data Source views.
  • Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
  • Implemented SSIS (ETL) to extract and transform data from Teradata, Oracle, Flat files/CSV and Excel Files.
  • Performed data validation, data cleansing, and transposing data using different procedures ( Confidential means, Confidential freq, Confidential sort etc.) and statements (keep, rename, obs, first. put, format etc.).
  • Upgraded Framework Manager Models, Transformer Cubes from Cognos 8.4 to 10.2.1.
  • Proficient in deploying Reports and Packages from one environment to other environments.
  • Developed Pharma Dash board reports to display all the information related to environment using Summary reports.
  • Involved in Reports Development using SQL queries, Spreadsheets, Charts, Link Node, and Data Visualization using Tableau and Excel Charts. Reports and query design using Pentaho report designer.
  • Creating complex logic in Unica Campaign.
  • Installed and Configured Cognos TM1 Architect and Cognos Insight 10.2 and Cognos TM1 Application in Development Environment.
  • Created Visio process flows for the modification of the ETL process for OLAP and Confidential .
  • Modelled the application's relational database using SSMS.
  • Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server.
  • Created and distributed routine metrics dashboards and spreadsheets for each product, regions, and segments.
  • Strong understanding of RDBMS, OLTP, OLAP, Star Schema/Snowflake Schema.
  • Created tables and stored procedures in SSMS for the modification of the OLAP.
  • Developed some Reports using Cognos Insight and published into Cognos TM1 Application and Cognos Connection.
  • Implemented Cognos SDK code to retrieve all the report schedules from the content store.
  • Trained end users on Query Studio for Ad-hoc reporting as well as involved in the Documentation.
  • Developed Business Requirement Specs as a Business Analyst as well as acted as lead in troubleshooting Report performance problems.
  • Worked extensively on Data Quality (running Data Profiling, Examine Profile outcome); Metadata management (loading metadata, mapping metadata, or perform data linkage).
  • Merged SAS datasets using various SQL joins such as left join, right join, inner join and full join as well as using SAS procedures such as set, merge and Confidential append etc.
  • Performed advanced analytics and analyzing data using different SAS and SQL procedures such as Confidential univariate, Confidential summary, Confidential freq, Confidential corr, Confidential rank, Confidential transpose etc.
  • Created analytical reports (periodic and ad-hoc) for different credit card portfolios reports using Confidential report, Confidential tabulate, Confidential summary, Confidential statements and generating outputs in HTML, Excel and RTF formats.
  • Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
  • Imported all Reports from Web Report Studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
  • Developed SAS Macro programs and using macro functions (%let, call symput, %str, symget etc.) to automate business as usual (BAUs) reporting process to improve process efficiency and provide more meaningful information vital to the overall strategies.
  • Created dynamic Macro arrays by SQL and with SAS data step programs.
  • Extensive usage of MS office and the functionality of excel such as lookups, macros, statements etc.

Confidential, Salt Lake City, UT

Data analyst

Responsibilities:

  • Responsible for gathering information to create clear, concise and complete business and functional requirements for assigned tasks.
  • Actively participated in project phases and report status to Project Manager, including Feasibility, Requirements, Development, Quality Assurance, Implementation and Maintenance.
  • Business Process Analyst in assessment/analysis of existing processes to support changing business needs.
  • Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
  • Developed SAS MACROS for Data cleaning, Data mining and Reporting.
  • Used Tableau Desktop for blending databases and create interactive views and dashboards as well as Created multiple scorecards and dashboards.
  • Extract data from Oracle database using SAS/Access, SAS/SQL in SAS environment and create SAS files.
  • Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production.
  • Actively involved in new KPI generation for tableau Scorecards.
  • Migrated data from different sources (text based files, Excel spreadsheets and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
  • Data collection and leveraging on data manipulation teams for required data.
  • Identified new metrics and enhance the existing KPI's.
  • Worked extensively using Excel to validate the data and use as the source data files.
  • Converted existing Excel reports in to Tableau reports.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
  • Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
  • Effectively used data blending, filters, actions, Hierarchies feature in tableau.
  • Defined best practices for Tableau report development.
  • Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
  • Understood the business requirements and then converted requirements into technical specification.
  • Worked with Data Architecture team to provide input on appropriate design alternatives and normalize the metadata.
  • Used an in-house data-mining tool to perform data audits for accuracy, completeness, and other considered values.
  • Performed data quality assurance checks on datasets using a variety of calculations; including index-matching.
  • Executed and tested required queries and reports before publishing as well as converted metric insight reports to tableau reports.
  • Developed corporate enterprise data management strategies for data access, metadata management, data extraction and movement, enterprise data warehousing, data administration, and enterprise data architecture.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Worked with Teradata database and pull data to work on BI requirement.
  • Provided Ongoing support to BI application running in production & troubleshoot.

Confidential, Cincinnati, OH

Business Analyst/Data Warehouse Analyst

Responsibilities:

  • Worked on Data-warehouse to conduct data requirements so as to provide guidance to Informatica developers to load the data in Target tables in Data-warehouse environment and to product BI ( Business Intelligence reporting).
  • Conducted analysis on OLAP facts and Dimension tables.
  • Good Experience with data analysis of Sales Order Data load from CRM system to our Data Warehouse Environment then for Business Intelligence reporting.
  • Performed business analysis, which included orchestrating JAD sessions, arranging meeting with stakeholders to gather requirements, and writing use cases and test cases/scripts.
  • Conducting meeting with Off-shore ETL Development team to provide them Knowledge transfer sessions on Data Requirements and Source to Target Data Mappings.
  • Analyzing the Gathered functional requirement to write the Confidential and Confidential .
  • Writing the defect log and conducting the audit for all the phase of SDLC life cycle.
  • Writing the audit documents such as SER audit template, Technical audit template, verification log etc.
  • Making the high-level work flow diagram.
  • Making the process map using the MS Visio 2010.
  • Helping the Project manager in making Project Plans.
  • Assigning the task in MS project to various projects.
  • Coordinating with QA, .Net Developer, UI team and Business owner for the fulfillment of the requirement.
  • Facilitated the gathering of functional & Data-warehouse requirements from system users and prepared business requirement documents that provided appropriate scope of work for technical team to develop and test prototype and overall system.
  • Identifying the user need by following the user centered design approach in secondary project called blade logic, which was lite project and had some experience in analyzing the User Centered Design.

Hire Now