Home

Anil Kumar - Data Analyst - Open for W2-C2C-1099 - Data Analyst

[email protected]

Location: Dallas, Texas, USA

Relocation: No Relocation Only Hybrid or Remote in Texas

Visa: USC

Anil Kumar [email protected] (469) 305-7118 US Citizen Dallas, TX(Hybrid) Available Immediately Professional Summary: Around 6 + years of professional experience working as a Data Engineer, Analyst, business system analyst with diverse industry verticals. Data/Business Analyst track record in requirements gathering, performing gap analysis, data analysis and document between 'As - is' and 'To-be' processes. Extensive experience in developing logical and physical data models for both transaction as well as analytical systems. Experience in working on Tableau projects from conception to implementation, translating intricate business requirements into efficient and visually appealing Tableau solutions. Experience in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop. Designed and developed interactive Tableau dashboards and reports to visualize complex data sets, providing actionable insights for business stakeholders. Developed Tableau data visualization using Pareto&, Combo charts, Heat maps, Box and Whisker Plot, Scatter Plots, Geographic Map, Cross tabs, Histogram, Pie charts etc. Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools. 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. Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server, Netezza and Teradata Experience in creating SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleansed data. Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch. Experience in Automating ETL processes for dynamic, automated data migration and validation by using Informatica, SSIS and Alteryx. Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata. Experience with Business Process Modeling, Process Flow Modeling, Data flow modeling. Experience in analyzing the business requirements and creating Business Requirement Document (BRD). Expertise in interacting with stakeholders, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools. Hands-on experience with modeling using Erwin in developing Entity-Relationship, modeling Transactional Databases and Data Warehousing, Dimensional Data Modeling for Data Marts and Fact & Dimensional Tables. Hands-on knowledge of enterprise repository tools, data modeling tools, data mapping and data profiling tools. Extensive Experience working on SQL Queries along with good experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation. Good Understanding and Knowledge with Agile and Waterfall Environments. Having excellent communication, organizational and presentation skills, interpersonal relationship and ability to be part of a team. Liaison between the cross-functional teams, top management clients, users and any stakeholder involved in the project. Involved in performance optimization of DWH solutions, both on ETL as well as Database side. Experience in preparing project cutover plan, test plan with test cases for unit test, regression test and User Acceptance Testing (UAT). Excellent in verbal and written communication, organizational skills combined with the ability to work in a fast-paced environment as an individual and/or as a team member. Work Experience: US Bank, Dallas, TX Jan 2021 - Present Data Analyst/ Tableau Developer Responsibilities: Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks. Demonstrated experience of Column / Advanced Data Profiling and its best practices as a part of Data Quality Assessments. Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database. Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD. Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop. Worked on SSIS Control Flow items (for each Loop, execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all). Developed Tableau visualizations and dashboards using Tableau Desktop. Also developed Tableau workbooks from multiple data sources using Data Blending. Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users. Design complex Dashboards like Executive, KPI and Strategic by using Tableau. Effectively used data blending, filters, actions, Hierarchies feature in tableau. Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users. Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately. Designed and implemented ETL processes based in SQL, T-SQL, stored procedures, triggers, views, tables, user defined functions and security using SQL SERVER 2012, SQL Server Integration Service (SSIS). Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems. Involved in extensive DATA validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues. Worked with end users to gain an understanding of information and core data concepts behind their business. Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding. Utilized Alteryx analytics software to process sophisticated cost models and SQL data conversions. Performed Data Profiling, Data Cleansing, Data Quality by importing Data from both Relational and NO Relational databases using Alteryx. Identify & record defects with required information for issue to be reproduced by development team. Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization. Environment: Tableau Desktop 2020.1/2019/1, Alteryx 11.0 & 11.3, SQL Server, Informatica, Oracle, SQL developer, Teradata, SQL Server 2012, Oracle 11g. Highmark Insurance, Pittsburgh, PA Aug 2018 Dec 2020 Role: Data Modeler/Analyst Responsibilities: Working with the Business Analyst and DBA, conducting team meetings and JAD Sessions for technical requirements gathering, business analysis, testing and project coordination. Analyze and evaluate existing system for assessing how it supported functions from the Use Case diagrams and UML diagrams. Developed Logical data model using ERwin 7.2 and created physical data models using forward engineering. Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access, Oracle and Teradata, to connect to existing database and create graphical representation (E-R diagram) using Erwin 7.2. Used Teradata utilities such as Fast Export, MLOAD for handling various tasks. Participate in updating the dimensional model and identify the Facts and Dimensions. Employed process and data analysis to model a Customer Information Business System. Involved in design and development of standard and ad-hoc reporting using SQL. Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to incorporate the new calculations. Involved in overall data mart testing and different team review meetings. Environment: DB2, Teradata16, SQL, Cognos 8, Cognos Impromptu, ERwin 7.2, XML, Microsoft Access, Microsoft Excel. Geisinger Health, Danville, PA Oct 2016 Jul 2018 Data Analyst Responsibilities: Worked as a liaison among business client and development team for the implementation of 4010 to 5010 transition in compliance with HIPAA standards. Identified the business functions and processes and prepare system scope and objectives based on user needs and industry regulations. Defined terms, conducted stakeholder analysis, elicited business needs, conducted business process modeling work, facilitated work sessions (JAD), elicited requirements, wrote requirements and use cases, analyzed requirements, validate & prioritize requirements, trace requirements to related project documentation (process models, designs, test scenarios & scripts). Gathered requirements by using interviews, observation, JAD, brainstorming sessions, and documents analysis. Responsible for the analysis, design, development, testing, and support of data extract, transform, and load processes within the enterprise data warehouse. Created Data Dictionary, Data Governance and privacy policies specifying contract implementation. Involved in installation and configuration of SQL server 2005 on Database Servers. Created Database Objects like Tables, Indexes, Views, Stored Procedures, triggers and User defined functions according to the requirements of the project.. Data conversions and data loads from various databases and file structures. Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance. Environments: MS SQL Server 2005 SSRS/SSAS/SSIS, T-SQL, Windows XP. Education: Bachelors in Information Systems from Tribhuvan University. Keywords: active directory rlang information technology microsoft procedural language Pennsylvania Texas