We provide IT Staff Augmentation Services!

Senior Associate Consultant Resume

4.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • Over 9+ Years of working experience in IT as Data Analyst, Reporting and Business Intelligence Analyst.
  • Efficient in developing data management Reports using Reporting Tools Tableau, Qlik sense/Qlikview, SAS, Argos, Oracle - SQL & PL/SQL 
  • Extensive Experience of Interaction with Client & Business Users for gathering the Business Requirements and Functional Specifications.
  • Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile
  • Provided as-is and to-be workflow analysis using Alteryx and identified opportunities to modify, automate and streamline process to improve.
  • Experience in developing Metric dashboard using calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.
  • Extensively worked on setting up of Sites, Projects, groups, Users, Schedule refreshes & subscriptions.
  • Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
  • Experience in dashboards designing with large data volumes from various data sources.
  • Experience in Actimize solution for AML/BSA including RCM/RFM.
  • Experience in AML(CIP/CDD/EDD) and FRAUD reporting including transactions level for internal fraud detection.
  • Experience in creating and scheduling Alteryx Work flows.
  • Involved inrequirements gathering/analysis,Design, Development, TestingandProduction rollover of Reporting and Analysis projects.
  • Strong understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products.
  • Deploying and scheduling Reports to generate all daily, weekly, monthly & quarterly Reports.
  • Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Served as a primary point of contact for workbook and custom Tableau reporting solutions related issues.
  • Possess strong architectural background of software components.
  • Ability to handle multiple tasks concurrently and meet the deadlines.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, Tableau Server, Qlik sense, Qlikview, Argos

Language: SAS, SQL, C, C++, Java, Python basics, VHDL, Verilog, Embedded C

ETL TOOLS: Alteryx

DATABASES: SQL Server, Oracle, Postgres SQL, MySQL, MongoDB, DB2

Query Tools: SQL server management studio, Toad, PL/SQL, Win SQL, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior Associate Consultant

Responsibilities:

  • Gathering business requirements from different business units, analyze then translate them to technical solution.
  • Actively involved in data extraction, data cleaning and setup/prepare workspace, create/modify SAS codes and performed calibrations and generated outputs.
  • Governance interactive Tableau Dashboard for daily activity of CIP Analyst which provides daily alerts that’s needs to be worked based on aging, alert status. It also provides reporting capabilities for alerts closed based on analyst for selected closed dates.
  • Implementation of Enterprise Fraud Monitoring Tableau Dashboard for Card, Check, Debit and Credit internal losses for Executive leadership.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Hands on building Groups, hierarchies, Sets to create detail level summary reports.
  • Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
  • Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
  • Created authorization transactions data modal where daily transactions from vendor are loaded in SAS data set which is used by card fraud detection team for fraud detection.
  • Created and Scheduled Alteryx work flows for fraud and non fraud alerts monitoring for new accounts Business unit.
  • Created SAS procedures to create large volume data sets for ACH transactions from PSO team and Zelle transactions from vendor. Same data sets are used for internal fraud detection from employees.
  • Created Mysql based data model for annual risk assessment with reporting capabilities.
  • Implemented CIP and daily transaction monitoring reports to analyze suspicious activities of clients and employees for ACH, Wire and Zelle.
  • Process implementation of secure transmission of OFAC client's information from one system to another as a part to merger integration program.
  • Process automation of hotlist clients for banks.
  • Part of internal reports for fraud detection where developed daily, weekly, monthly reports for employee fraud using SAS enterprise guide.
  • Process documentation for existing alerts procedures.
  • Involved in client’s information data pull from internal databases for bank audit requests from federal agencies and data validation for internal data validation process.
  • Worked with data science teams of cards, new accounts, payments for their data needs and data validation.

Confidential, Atlanta, GA

Actimize Visual Analytics Developer

Responsibilities:

  • Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server based AVA (Actimize Visual Analytics) dashboards with automatic updates.
  • Created reports mapping from Actimize application (Currency Transaction Reporting System) to create views required for AVA report generation.
  • Created materialized views from mapping documents required for CTR (Currency Transaction Reporting System) reporting.
  • Integration of dashboard with Actimize application.
  • Coordination with DBA teams to specify on data requirements to create views and connect them to AVA Servers.
  • Involved in Full Life Cycle Development ofReportingProjects, includes analysis, Design, Development, Testing.
  • Created KRI and KPI management reports for stack holder with automatic scheduling and alerts.
  • Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
  • Worked in AVA environment to create weekly, monthly, daily reports.
  • Involved in Trouble Shooting, Performance tuning of reports, resolving issues within AVA Server.
  • Worked in Agile methodology.

Confidential, Atlanta, GA

Tableau Developer / Data Analyst

Responsibilities:

  • Gathering business requirements from different Departments, analyze then translate them to technical specifications.
  • Mastered the ability to design and deploy rich Graphic visualizations with drilled down option and parameters using tableau.
  • Coordination with DBA & DWH teams to specify on data requirements to create Schemas & Tables as per required and connect them to Servers.
  • Involved in Trouble Shooting, Performance tuning of reports, resolving issues within Tableau Server and Tableau Dashboards.
  • Created multiple tableau dashboards with custom SQL queries to enhance the processing of complex visualization.
  • Executed and tested required queries and reports before publishing.
  • Identify opportunities to automate manual data pulls.
  • Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
  • Designed and developed various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement. Involved in creating a dual-axis bar charts with multiple measures.
  • Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
  • Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Implemented data blending to blend related data from different data source.
  • Involved in unit testing of the report to match with Banner data.
  • Involved in creating prototype dashboards and reports in Argos.
  • Identifying client issues within their business, crafting solutions and implementing changes.
  • Updated codes and reports with business process changes.
  • Leveraging different data architectures and data blending technologies to provide data to Tableau.
  • Developed interactive visualizations in Tableau for student success and enrollment projection dashboards utilizing various reporting components from multiple data sources.
  • Involved in converting current Argos reports to tableau dashboards.
  • Communicate analysis effectively to internal team and clients.

Confidential

BI Developer/Tableau Developer

Responsibilities:

  • Gathering business requirements from various users of different Departments.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Gathered data from different data sources like MySQL, Excel, Oracle, My Access and MSSQL.
  • Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
  • Validate and analysis of various source data formats like XML, JSON, CSV.
  • Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Effectively used data blending feature in tableau.
  • Defined best practices for Tableau report development.
  • Provided Production support to Tableau users and wrote custom SQL to support business requirements.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Trend lines, Statistics and table calculations.
  • Created parameters and quick filters. Created sets to display top products based on their sale.
  • Designing and Optimizing Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
  • Created Custom Hierarchies to meet the Business requirement in Tableau.

Confidential

Assistant Professor

  • Evaluate, monitor and mentor student’s academic records.
  • Preparing and delivering lectures to undergraduate and graduate students on subject such as Microprocessor and Interfacing, Microcontroller and Interfacing, Image processing, Power Electronics, Applied Electronics.
  • Guide, lead and mentor students in research projects.
  • To participate in departmental and faculty seminars aimed at sharing research outcomes and building interdisciplinary collaboration within and outside the department.
  • Keeping abreast of developments in the field by reading current literature and participating in professional conferences.
  • Serve on academic or administrative committees to deal with institutional policies.
  • Write grant proposal to procure external research funding.
  • To participate in the development, administration and making of exams and other assessments.
  • Develop and implement innovative instructional methods.

We'd love your feedback!