SUMMARY

• Over 7+ years of demonstrated experience as a Business Intelligence Analyst and developer in multiple roles in like Data Analyst, Power BI, Congo’s Developer and Tableau Report Analyst.
• Experience in programming, analyzing and reporting in various Banking, Healthcare, Insurance and retail using SAS on Windows and UNIX environments.
• BI and Data Analytics with multiple years of experience in SDLC and possess experience in Database technologies like MS SQL Server (SSIS/SSRS/SSAS), Tableau Report, Advanced Excel, MS Office within a progressive organization.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Design the start schema/snowflake schema model in SSAS for the best performance and friendly user interfaces
• Assist end users with problems installing the Power BI desktop, installing and configuring the Personal and On - Premises gateway, connecting to data sources and adding the different users.
• Experience in developing, maintaining, and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, T-SQL, MDX, Excel pivot tables, Power Pivots, Power BI, DAX)
• Experience in Data warehouse including Star Schema design. Created Stage based DW supported by that’s completely implemented in Pentaho Kettle.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Hands on Experience working with Azure Data Lake Analytics to analyze the structured, non-structured data from various sources.
• Developed and Maintained SSAS Tabular Model Cubes for RISK Analysis and Team Member Services.
• Hands on experience on the whole ETL (Extract Transformation & Load) process.
• Experience in creating aggregates, hierarchies, charts filters, quick filters, table calculations, trend lines calculated measures.
• Experience across various technology risk domains and a multitude of industries delivering on global SOX audits, SOX readiness assessments, SOC 1/2/3 reporting engagements, system implementation/cloud conversion technical reviews, regulatory compliance assessments, and control optimization/automation projects.
• Experience in Tableau report developing, testing and deploying reporting solutions using Tableau Server. Skilled in analytical and business reporting using SAS, MS Office, VBA and RDBMS technologies.
• Knowledge of different types of Data Warehouse, EPM and Business Intelligence solutions such as those from IBM/Cognos, SAP/BO, OracleHyperion,SAS, TERADATA and others.
• Automate current manual reporting processes usingpython.
• Experience in report data validations and cosmetic data validations which are developed in cogon's /MicroStrategyand Business Objects.
• Generate summary reports using OracleHyperion, Oracle Business Intelligence Enterprise Edition (OBIEE)
• Have worked on StateAuditsand FederalAuditsunder strict deadlines and short notices with utmost quality.
• Expertise in data base programming (SQL, PLSQL, TSQL) MS Access Oracle 10g/9i, SQL server 2005/2008, DB2, Data base tuning and Query optimization.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Created/Enhanced TERADATA Stored Procedures to generate automated testing SQLs.
• Good experience on in dashboards designing with large data volumes from various data sources ( Sql server, TERADATA etc).
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts etc.
• Extracted data from Oracle database transformed and loaded into TERADATA database according to the specifications

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Sr Data Analyst / Business Intelligence Analyst

Responsibilities:

• DevelopedPowerBImodel used for financial reporting of P & L and Headcount.Designed and documented the entire Architecture of Power bi Poc.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Developing, analyzing, and produce asset quality reports for the consumer, commercial portfolios as well as specialty line of businesses.
• Developed and Maintained SSAS Tabular Model Cubes for RISK Analysis and Team Member Services.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Analyzed the source data coming from various heterogeneous data sources to be consumed in the ETL procedures to load data into data warehouse.
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Working extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Developing reports in Tableau by connecting to various data sources like MS SQL Server, Statistical file, MS Excel.
• Acquiring data from primary or secondary data sources and maintaining databases and/or scheduled ETL jobs
• Developing and implementing data models using machine-learning tools for analysis as well as scoring distribution to multiple channels.
• Worked very closely with Project Manager to understand the requirement of ETL and reporting solutions to be built.
• Examples include next best product, response models, marketing attribution, profit models, and attrition models
• Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality
• Critical Thinking: Data analysts must look at the numbers, trends, and data and come to new conclusions based on the findings.

Environment: IBM DB2, My SQL,Snowflake, MS Access, SAS, PowerBI, Tableau, SSAS, Cognos 8,10.2, 11, SSRS, JavaScript, CSS, HTML, Financial Services, Risk Analysis, SAS EG.

Confidential, Memphis, TN

Data Analyst / Business Intelligence Analyst

Responsibilities:

• To perform the pre-installation validation across the different environment and to identify the gaps.
• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.
• Knowledge of Warehouse Management System Manhattan WMOS. Exposure to key areas like receivingput away, Inventory Management, Waving and Shipping in the Distribution Center.
• Create a tabular model cube and modified the Relationship between a Measure group and dimension using SSAS.
• Well versed in Manhattan WMOS. Has in depth knowledge and understanding of Inbound, Inventory Control and Outbound Processes.
• Implemented appropriate filters, calculations, prompts, conditional formats, drill-through, Master-Detail, standard formats and created various complex List Reports, Crosstab Reports and Chart Reports using Cognos Report Studio.
• Installed and configured Cognos 11.0.7 & 10.2 version in DEV, UAT & PROD environment and optimized server setting to have better performance with SQL server & Oracle data sources.
• Worked on Tableau Dashboards using different data source connections for Analysis purposes for Business Teams.
• Working in gather external data totableaufrom various sources like Oracle, MySQL, SQL Server & flat flies etc., for data visualization.
• Design and Developed Worksheets/views that involve different charts bar graph, scatter plot, Map reports and Detail reports usingTableauDesktop
• Implemented appropriate filters, calculations, prompts, conditional formats, drill-through, Master-Detail, standard formats and created various complex List Reports, Crosstab Reports and Chart Reports using Cognos Report Studio.
• Maintained and InstalledTableauServer in all the environments on Oracle.
• Involved inTableauserver upgraded from single node to distributed environment, makingTableau services more scalable and stable
• Validate the BI design and ensure that technical specifications are complete, consistent, concise, and achievable
• Strong ability in defining a query for generating drill-down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Scheduled and Distributed Reports through Schedule Management inCognosConnections.
• Migrate all the data from Teradata DB to Snowflake DB.
• Work with Analysts, Data Scientists, and Product Engineers to build APIs and pipelines that serve up real-time analytics and predictive models to the Snowflake service.
• Helping troubleshoot problematic queries and optimize how we use Snowflake internally.

Environment: TERADATA, Oracle, IBM DB2, My SQL,Snowflake, MS Access, Tableau, Cognos8,10.2, 11, SSRS, JavaScript, CSS, HTML, Financial Services, Risk Analysis, SAS EG.

Confidential, Memphis, TN

Sr Data Analyst / BI Consultant

Responsibilities:

• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• BI Developer with expertise in design and development of Extract, Transform and Load processes for data integration projects to build data marts.
• Create a tabular model cube and modified the Relationship between a Measure group and dimension using SSAS.
• Manual data inclusions, data exclusions, data corrections in EDW, pipe-delaminated the data and support tracker for the different metrics.
• Created intermediary and final MIS reports to explain the data trends and conversion patterns using tools like excel and SAS.
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements.
• Query built in SAS to connect with TERADATA to retrieve the customer information in EDW (Enterprise Data Warehouse).
• Developing SAS codes using SAS Enterprise Guide and SQL queries in SAS for creating stored processes using the dynamic prompts containing both packaging and streaming output, and prepared reports using ODS.
• Successfully designed and developed Compliance Web Portal application using SAS BI tools like SAS stored Process, Info map, SAS Web Studio and SAS Dashboard.
• Provide support and maintenance to existing management information systems (MIS).
• Manipulated existing Oracle database by accessing the data using SQL pass through facility.
• Produced ad hoc and monthly MIS reports using SQL and base SAS, Enterprise Guide and SYBASE on UNIX, SQL Server and SAS on Windows.
• Worked on the External reports using Hyperion Financial Reports for the controller groups.
• Advanced Querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Integrated data using SAS Data Integration Studio (SAS ETL Tool) for an end-to-end SAS data-mart solution for analytics and reporting.
• Register stored processes and SAS jobs in the metadata and set up new flows for scheduled run times on batch server
• Manual data inclusions, data exclusions, data corrections in EDW, pipe-delaminated the data and support tracker for the different metrics.
• Created Dashboards to present critical company data in a single report.

Environment: SAS, Base SAS, SAS/ODS, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS EG, Cognosv 10.2.1& 10.1.1,11 (Report Studio, Metric Studio, Framework Manager), TERADATA, Python, Oracle, IBM DB2, MS Access, SAS on UNIX, LINUX, PC SAS, SAS on Mainframe z/OS, Korn Shell Scripting, Tableau, JavaScript, CSS, HTML, Financial Services, Risk Analysis.

Confidential, Scottsdale, AZ

Data Analyst / BI Consultant

Responsibilities:

• Created dashboards usingTableauand prepared user stories to create compelling dashboards to deliver actionable insights.Involved in trouble shooting, performance tuning of reports and resolving issues within Tableau Server and Tableau desktop reports.
• Analyze data from various sources and creating reports weekly, monthly and quarterly reports using Excel, SQL,Tableauand IBMCognos.
• Developed business logic for complex, field Actions, sets and parameters to include several filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Help marketing automation developer to govern and validate the database, assist in ETL process and prepare documentations.
• Implemented ETL to Extract and Transform data from text files, SQL Server 2005 instances and to load into Staging Database. The main purpose to load into staging database was to change all string values to integer and load to Data Warehouse for further Data Analysis by using multiple transformations provided by Pentaho such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension.
• Segmentation Analysis was performed on the target market to identify the existing trend and to create a profile of the same.
• Writing Korn-shell scripts & Cron Jobs for executing SAS batch files on UNIX.
• Experience with other BI tools likeCognos, Business Objects, Micro-strategy and Netezza.
• Elicit all business and functional requirements and documented them.
• Created artifacts such as Use Cases, Activity, and Sequence Diagrams using MS Visio.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Environment: Tableau (Desktop/Server) 9.x/8.x, Cognosv 10.2.1& 10.1.1,11 (Report Studio, Metric Studio, Framework Manager) TERADATA, Oracle, Java API, Alteryx, SQL Developer, SQL, XML, Flat files, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint), Agile (Scrum), MS Project, Visio, MS SQL Server, SharePoint, Java, .Net, SOA.

Confidential

DataAnalyst

Responsibilities:

• Worked on a team of four that covered the credit ratings of bulge-bracket investment banks, exchanges, retail brokers, and other firms within the Securities and Banking industry.
• To statistically analyze thedataregarding the various process parameters in the process of manufacturing tiles using Excel by Control Charts, ANOVA Tests, Cost Benefit & Feasibility Analysis and Incoming Raw Material Acceptance/Rejection Tests.
• To carry out suitable analysis regarding plant machinery efficiency which involved Identifying the major causes by Pareto Analysis and carry out the before and after analysis to judge for improvement.
• Reporting Scripts and SAS jobs will be modified to connect to DB2.
• Used SQL Pass through Facility to create and update TERADATA and Oracle tables
• Technical support as an application developer supporting primarily SAS and UNIX shell script applications
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and developed ad-hoc reports using SAS Enterprise Guide.
• TERADATA tables and created Logical and Physical Data Models using Erwin design tool.
• Used various Tag sets options in SAS ODS Markup engine (Excel XP, MS office, MSoffice2k) to deliver the Formatted EG reports as XML /HTML sheets that could be opened with Excel directly.
• Integrate data from various system sources (flat files, CSV, text form, and other formats) using SAS
• To extractdatafrom ERP (version Navision) by formulating SQL queries.
• Worked as an active member of the team preparing monthly MIS (Management Information Source).
• Created various transformation procedures by using SAS ETL and SAS Enterprise guide
• Worked with business users to design and develop several ad-hoc reports and information maps usingProc Report and Proc Tabulate

Environment: SAS9.3/9.2,SAS/Base, Macros,SASAccess,SASDI,SASAF/SCL,SASEnterprise Guide, Windows, Enterprise Miner,SAS/BI,SAS/ETL,SAS/Connect, TERADATA, DB2, MS excel, HTML, Linux, SQL and JavaScript, Agile (Scrum), MS Project, Visio, MS SQL Server, SharePoint, Java, .Net, SOA