SUMMARY:

• Possess over 17 years of Professional US work experience in the IT industry in analysis design, development and maintenance of various software applications mainly in Tableau 9/10/2018, Power BI, Alteryx 11.7, SAS Enterprise Guide 7.1, SAP Business Objects, Webi, Crystal Reports, Big Data ecosystem, Python, Oracle, Teradata, SQL Server.
• Has good rapport with client communication, work allocation & tracking and mentored.
• Has extensive experience in analyzing and translating end - user requirements into robust, reliable systems that streamline workflows with dynamic graphical user interfaces and stored procedures.
• Has an intense drive to plan and execute large-scale technical projects individually, and while leading a team. Has worked in close association with the clients in course of, supporting and accomplishing organizational objectives in turn.
• Worked extensively with Advance analysis like Actions, Calculations, Parameters, and Background images, Maps, Trend Lines and Statistics.
• Built, published and customized interactive reports and dashboards using Tableau server.
• In depth work exposure on SAS Enterprise Guide 7.1, SAS/Base, SAS/Access, SAS/Graphs and SAS/macros, SAS/SQL
• Usage of SAS/Macro for creating macro variables, macro programs and Auto call macro Library to modify existing SAS Program for ease of modification while maintaining consistency of results
• Interfaced with data miners and analysts to extract, transform and load data from a wide variety of data sources using SAS and SQL.
• Good knowledge in predictive modeling technique, Logistic regression, decision tree, Random Forest.
• Wide knowledge in Python in building models.
• Experience in Latest BI Tools like Power BI, Tableau.
• Good working knowledge in Extract API, Rest API and connectors.
• Experience with complex Set Analysis and Aggr equations as well as synthetic dimensions.
• Hands-on experience building a snowflake and star schema data model, within the Qlikview load script.
• Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop.
• Analyzed data requirements, application and processing architectures, data dictionaries and database schemas while designing, developing, amending, optimizing and certifying database designs to satisfy client needs.
• Integrated Tableau with SAS Data source; Deployed Dashboard after importing Data from SAS files
• Designed and Implemented rich interactive graphics and data visualizations of large structured data in tableau and Qlikview.
• Data Management skills like Merging, Handling missing values, Reading Raw data files, creating data structures, Handling programming errors, Accessing and Managing data, appending concatenating and Interleaving of SAS datasets.
• Data Visualization Expertise in the Tableau 10.x/2018.
• Worked closely with visual design team to select the appropriate visualizations for BI deliverables
• Data Visualization, Visual Analytics, BI Architecture and Management
• Hands on Experience in Business Objects Crystal reports and SQL Commands.
• Expertise in Business Objects Universe designer, Webi and Crystal Reports.
• Experience in the maintenance of BI Warehouse and good acumen in troubleshooting & performance tuning.
• Has the potential caliber to work in a team as well as independently with excellent communication, interpersonal and analytical skills, ability to work under pressure in fast-paced environments.

AREA OF EXPERTISE:

Database: Oracle, SQL Server, MS Access, MySQL

Big Data Ecosystem: Apache Hadoop, Hive, Hbase, Pig

Web Servers: MS IIS, Tomcat4.1.24

Languages: SQL, Python, XML, VBScript, HTML

ETL Tools: Alteryx, SSIS

SAS Tools: SAS, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/Stat, SAS/Report

Data Visualization: Tableau 9/10/2018, Power BI, SSRS

Business Objects: Universe Designer, Webi, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

SAS/Tableau Consultant

Responsibilities:

• Developed Scatter charts, Whisker Box Plot, Correlation Matrix, Tree Map, Pie charts, Dual axis charts, Bump chart, Bubble chart, Water Fall, Blended chart using Tableau.
• Worked on data blending and analyze data from multiple data source.
• Created dashboards for analyzing data using Tableau
• Created users, groups and authentication and maintained in tableau server.
• Analyzed UT and Fraud Losses, ATM Access code, Mobile Wallet, Zelle and Online wires, New device, No Phone change, No pwd change or TAC
• Created OTP Social Engineering report based on the analysis.
• Analyzed and tracked temporary allowed customers fraud with ccm and enterprise claims
• Created Temp allowed customers with fraud rate percentage and claim report
• Analyze and validate the data and provide insight to business
• Coded SAS programs to performed ad-hoc analysis and data manipulation
• Interacted in all meetings, cleared all possible queries and discussed the requirements.
• Created and maintained all the scheduled cronjob in UNIX.

Environment: Teradata, Tableau, Alteryx, SQL, SAS EG 7.1

Confidential

Tableau /SAS Consultant

Responsibilities:

• Implemented Ford Edge, Expedition Scoring model in CKS-X application.
• Support activities like fixing the job failure and monitoring the daily and monthly jobs.
• Extensively used the complex queries to fetch data from Teradata using Alteryx.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering.
• Good experience in implementing the predictive modeling, Logistic regression, Decision tree models.
• Worked on SAFE (Scaled Agile Frame Work) by following Epic, Sub Epic, Feature, user Stories and Task.
• Support CKS-VOC application jobs using Hadoop, Hive
• Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.
• Installation and configuration of Tableau Products Tableau Desktop and Tableau Server in different environments Dev and Prod.
• Acts as a Tableau Administrator, Using Tableau Server publishing the developed dashboards to the Tableau server with the user management, security, content restriction, authentication, authorization, Tableau Extracts scheduling and refreshment, and Users access

Environment: Tableau 10.2/2018, Alteryx, SAS EG 7.1, Teradata, Oracle, Hadoop Hive

Confidential, Little Rock, AR

Data Visualization/SAS Consultant

Responsibilities:

• Cleansing and analyze Instantis Financial data by creating SAS/macros.
• Built, published and customized interactive reports and dashboards using Tableau.
• Developed Qlikview dashboard to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Design, analyze and validate clarity system in SAS Enterprise guide.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created and edit check programs to find data discrepancies in raw datasets
• Developed dashboards pertaining to KPI monitoring using Tableau.
• Worked with Qlikview, SQL Server, Oracle, Teradata, SAP, Excel, flat files.
• Worked on administration tasks like adding workbook Permissions, Ownerships.
• Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets.
• Comprehensive prepared reports using SAS report procedures like proc print, proc report, proc tabulate, proc freq, proc means and proc transpose
• Importing and exporting excel and access files using Libname, proc import, proc sql, proc export
• Involved in integrating the Instantis, Jira and Clarity with business users.
• Developed code using data step programming and macros to extract, clean and validate date from external source.
• Analyze the data in tableau by connecting to Hive by Hortonworks Hive ODBC driver.
• Developed various forms of outputs like RTF, HTML, PDF files using SAS/ODS.
• Created Bar charts, donut Charts, trend charts, Control charts in Qlikview/tableau.
• Created donut chart for high/medium/low task in clarity portfolio management.
• Worked on data blending and analyze data from multiple data source.
• Developed and published Instantis and clarity data visualization charts in tableau server.

Environment: Qlikview 10/11, Tableau 9.3/10.2, SAS/BASE, SAS Enterprise Guide 7.1, Teradata, Oracle, Hadoop Hive

Confidential, Ashburn, VA

Data Visualization /SAS Consultant

Responsibilities:

• Build HON (Health of Network) system performance KPIs of all product using tableau and sport fire and published in server.
• Develop, build and deployed executive dashboard using Qlikview/tableau.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Created Bar charts, funnel charts; waterfall charts, Control charts in tableau.
• Created Rich dashboards using Qlikview Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Connected Qlikview with Oracle database to extract multiple tables and views.
• Data Merging, Data Subsetting with use of proc sql, merge and set statments.
• Generated tables, listings, and graphs using PROC REPORT and PROC GPLOT.
• Produced SAS outputs in RTF, PDF, CSV and HTML formats using Output Delivery System (ODS) facility
• Interacted with Business Users, Business Analyst and Source system owners to gather requirements and Business logics.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Building, publishing customized interactive reports and dashboards, report scheduling using Qlikview server.
• Strong Excel skills, including pivots, Vlookup, conditional formatting, large record sets including data manipulation and cleaning.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Qlikview.
• Developed Qlikview dashboard from multiple data sources using Data Blending.
• Developed Qlikview dashboard to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Developed POCs by building reports and dashboards using Qlikview
• Scheduled all visualization reports in Qlikview/Tableau server.

Environment: Qlikview 10/11, Tableau 9.3, SAS EG, Oracle, PL SQL Developer, Teradata, Hadoop Hive, Pig, Hbase

Confidential, German Town, MD

Data Visualization/Data Analyst (

Responsibilities:

• Collected business requirements from different sources and wrote the technical specifications for building the Data model.
• Strong leadership, problem-solving and multi-tasking abilities.
• Experience in Business Objects 4, IDT, Webi, CMC and Import wizard.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Developed various Charts, Graphs and drill down reports in Webi.
• Creating reports using Web Intelligence, schedule the reports as per the business needs and supporting.
• Developed workbooks and dashboards using Qlikview Visualizations like Heat maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographic maps using local and global filters.
• Involved in creating calculated fields, mapping and hierarchies.
• Worked in creating Aggregations, calculated fields, mapping, hierarchies, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Develop, build and deploy complex reports involving formulas, dynamic parameters, cross-tabs.
• Created Daily, Weekly and monthly reports in Qlikview.
• Scheduled automatic generated reports in Qlikview Server.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports in Tableau desktop.
• Played an active role during the requirement gathering, analyzing and designing of the system.
• Responsible of monthly reconciliation Q13 - Revenue Reconciliation reports which need to be submitted before every month first seven business days to the agencies.
• Analyzing PDR Details and Summary report every month for the Q13 Reconciliation.
• Analyzing Account Details, Toll summary, GL Summary every month for the Q13 Reconciliation.
• Analyzing 16A Truck Volume discount report with Q13 for monthly reconciliation.
• Analyzing F3M with PDR for the monthly reconciliation.
• Analyze Q8M. Q4P and F3M report with Q13 for Monthly reconciliation.
• Analyze Q13 direct revenue with F3M for monthly reconciliation.
• Analyze 61 and 62 report with Q13 for monthly reconciliation.
• Analyze PDR Payment summary by Payment Type (57) with Summary by Transaction (58) for Q13 reconciliation.

Environment: Tableau, Qlikview, Spot fire, Crystal Reports XI, CMC, Business Objects, Webi, Oracle, Hadoop, Hbase, Hive

Confidential, Memphis, TN

Qlikview/Tableau Consultant

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document.
• Develop, build and deploy complex reports involving formulas, dynamic parameters, cross-tabs and subreports.
• Analyze the requirement and prepared the specification document.
• Developed various operational Drill-through and Drill down reports using Qlikview.
• Worked on conversion project from access database reports and oracle reports to Qlikview
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using Qlikview.
• Played an active role during the requirement gathering, analyzing and designing of the system.
• Created sql queries to fetch data for reporting.
• Followed HL7 standards and Message Validation.
• Migrated existing application from MS-Access to Oracle and Qlikview.
• Created DTS packages for Data migration and transformation from oracle/access/Excel to SQLServer.
• Created stored procedures, packages, function and cursor management and exception handling.

Environment: Windows Scripts/log, Qlikview, Tableau, Webi, Universe, SQL Server 2008, Oracle 10g

Confidential, Alpharetta, GA

Sr. Analyst/Tech Lead

Responsibilities:

• Prepared detailed workflow charts and diagrams using Visio to illustrate sequence of steps the program must follow and describes, input, output and logical operations involved.
• Reviewed developed code with respect to coding standards and designed and created.
• Several reports were generated using Reports and user can customize at run time and spool to printer by not waiting for the printer to complete printing.
• Extensively wrote several PL/SQL procedures, functions and packages in Oracle during the course of development.
• Created several dynamic SQL queries to fetch data for reporting purposes.
• Took the responsibility to write test Scripts and testing them.
• Involved in writing SQL Scripts for Adhoc queries and providing the reports to the management.
• Support to development team to optimize SQL Performance. Creating hints for optimal query performance and analyzing execution plans.
• Created Reports using Formulae, Grouping, Parameters, selection Criteria.
• Worked with QA team to resolve bugs with a very less turnaround time.
• Set filters, suppression formulae and used highlighting expert to show the data the user would like to see in a more concise and presentable format.
• Designed and developed reports cross tab reports, reports with sub reports (linked and unlinked) reports. Wrote several sql queries to accomplish this task.
• Developed drill down reports using SSRS and developed various chart reports.
• Provided user/system documentation, user and testing of reports for final deployment.
• Worked along with the business users and provided report analysis and design.

Environment: VB.Net, SAP BO, Crystal Reports, Webi, Oracle 9i/10g, SQLServer 2008