SUMMARY

• Over 10 years of IT experience in design, analysis, development, and implementation of various ETL, reporting and visualization tools like Alteryx, Tableau, Power BI, SSIS, SQL, and SAS.
• 4+ years of Alteryx Designer experience in extracting, transforming, and loading data using tools such as In/Out, Preparation, Join, Parse, Transform, In - Database, Reporting, Spatial, Interface tools, creating analytical apps and macros to automate processes.
• Developed workflows, analytical apps, and macros to automate processes from Microsoft Excel and documented teh process flow along with Alteryx workflow user guide.
• Provided Alteryx workflow development training sessions to 20+ users.
• 5+ years of experience in Tableau Desktop as an analyst in creating highly interactive data visualization reports and dashboards using features such as Joins, Data Blending, Calculations, Filters, Actions, Parameters, Sets, Aggregate Measures, etc.
• 3 years of experience in developing graphical and visualization solutions in Microsoft Power BI utilizing complex DAX expressions, bookmarks, and selections.
• 3+ years of experience in Microsoft SharePoint like creating sites, pages, libraries, lists, forms, workflows, managing teh data, transformations of data in SharePoint list.
• Experience in Alteryx, Tableau, and Power BI server configuring, administering, and license management.
• Practical understanding and experience in Data modeling.
• Extensive knowledge in Spatial Analysis - Buffer, Distance, Generalize, Heat Map, Spatial Info, Spatial Match, Spatial Process, Trade Area - using Alteryx Designer.
• Sound knowledge and experience in statistics, data wrangling, descriptive, and predictive analytics like linear regression, A/B Testing, Segmentation, clustering, ETS and ARIMA time series forecasting.
• StrongDashboarddesignexperienceandpassionatepractitioner ofeffectivedataand visualization.
• Support production Incidents and Request for line of businesses within teh SLA.
• Extensively involved in Demos, Presentations, Meetings, Trainings with Senior Management.
• Outstanding analytical, interpersonal, organizational, communication, and problem-solving skills.

TECHNICAL SKILLS

Programming: HTML, CSS, JavaScript

Tools: Alteryx Designer, Tableau Desktop, Tableau Prep, Power BI, SSIS, KNIME, SAS, SQL, Excel

Database: SQL, Oracle, Teradata

Other Tools: Visio, HP AGM, JIRA, SharePoint, InfoPath Designer, QuickBase, Vertex

Methodology: Waterfall, Agile, Scaled Agile (SAFe), Kanban

PROFESSIONAL EXPERIENCE

Sr. Alteryx Developer

Confidential

Responsibilities:

• Develop Alteryx designer workflows and analytical apps to automate teh process of Fannie Mae mortgage balance verification.
• Support Alteryx users in teh team to build workflow by guiding them on teh best practices.
• Support and simplify existing Alteryx workflows to test and deploy in production.
• Run workflows to identify and rectify teh errors in mortgages based on Audit reference catalog.
• Work on ad-hoc request from different constituents of teh business and provide a quick solution.

Sr. Alteryx Developer

Confidential

Responsibilities:

• Extracted data from flat files, SQL server, Oracle, APIs using Alteryx Designer to transform teh data using Preparation, Join, Parse, Transform, In-Database, Reporting, Spatial, Interface tools
• Used Alteryx Designer to create workflows, analytical apps, standard macros, batch macros, and iterative macros to reconcile previous tax data and automated tax filings
• Converted complex Microsoft Excel reports to Alteryx analytical apps.
• Gatheird requirements for tax processes and converted into automated solutions and deployed it on teh Alteryx server.
• Developed workflows to transform teh data using KNIME Report Designer
• Created interactive dashboards using Tableau Desktop by creating advanced analysis actions, calculations, parameters, LoD expressions, sets, maps, trend lines, and table calculations
• Used Power BI Desktop to model and transform teh data, created DAX measures and columns, developed reports, assigned bookmarks and selections to hide and show visuals based on teh actions
• Managed workspaces and access request and created deployment pipelines to deploy teh reports to teh stage and prod environment
• Provided reporting, analysis, insights about tax and key revenue performance metrics to support various line of businesses
• Restricted data for users using Row level security and user roles in Tableau and Power BI
• Performed Performance unit testing, stress testing, security testing, and functional testing using BI Validator

Enterprise Technology Analyst II

Confidential

Responsibilities:

• Worked as a partner with different line of businesses to gather requirements, prepare a process flow, create requirement documents, and prepare Alteryx and Tableau workflow guide
• Automated Loan Operations and Treasury Management processes using Alteryx Designer reducing teh manual effort and thus saving time
• Designed and developed workflows, analytical apps, and macros using flat files, database, API, SharePoint connections in Alteryx Designer and scheduled it on Alteryx Server and Desktop scheduler
• Conducted training sessions with Alteryx power users to get them to speed on Alteryx Designer
• Utilized Tableau to develop interactive dashboards which uses complex calculated columns, calculated measures, prompts, conditions, and filters (Local, Global), and LoD Expressions
• Migrated MicroStrategy reports to interactive Tableau dashboards with Row Level Security (RLS)
• Created SSIS packages to extract, transform, and load data to teh DataMart. Wrote complex SQL queries to verify data for line of business
• Deployed workflows and dashboards to stage and production environment
• Designed processes for teh business and created SharePoint 2010/2013/2016 sites, pages, web parts, Forms, and Workflows
• Gained experience in dimensional modeling using star schema and snowflake schema and data analysis to provide Business Intelligence solutions
• Supported different line of businesses to handle new request and incidents within teh SLA allotted

Programmer Analyst

Confidential

Responsibilities:

• Translated business user concepts and ideas into comprehensive business requirements and design documents
• Used Alteryx to extract teh data from API's, databases to transform teh data according to teh requirements and load teh data to teh destination
• Used Tableau for data blending, groups, combine fields, calculated fields, aggregated fields and spotlighting to compute and analyze data in different perspective
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand teh data on teh fly
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications

Analyst

Confidential

Responsibilities:

• Gatheird requirements from line of businesses to create business requirement documents, process flow documents to produce required reporting, analytics, and visualization deliverables
• Designed and developed various analytical reports from multiple data sources by blending data on single worksheet in Tableau Desktop
• Created Tableau interactive dashboards and user stories based on business requirements
• Designed and developed SSIS packages and mappings to load teh data from flat files to SQL server tables for reporting purposes
• Created SSIS packages to extract teh data from flat files, Excel, XML files into SQL Server
• Wrote complex SQL queries to pull teh data needed and used SSRS for reporting
• Performed data analysis, statistical analysis, generated reports, listings, and graphs using SAS

Associate Analyst

Confidential

Responsibilities:

• Used VectorVest Analytical software for technical analysis to forecast
• Created advanced chart types, visualizations, filters, reports, and dashboards of teh data.
• Processed data load requests to enter data manually, reconciled data conflicts, and created data extracts and reports.
• Created Excel Spreadsheets for reconciliation of quarterly budget using Sum If, Count If, VLOOKUP, Pivot Tables, If Error etc. functions.
• Created Pivot tables and modified spreadsheets to achieve analytical goals.