Home

Pavan - Data Analyst

[email protected]

Location: Irving, Texas, USA

Relocation: yes

Visa: EAD

Pavan Email: [email protected] Phone: +1 947 228 6768 Ext 12 PROFESSIONAL SUMMARY: ________________________________________ 9+ years of work experience as a Data Analyst with expertise in data collection, analysis, cleaning, testing, visualization, business requirements gathering, business process flow, business process modeling, data analysis, and data mapping and interactive report generation. Working experience in extraction of data from various database sources like MySQL, MSSQL Server, Oracle and other database systems. Expertise in complex PL/SQL code development using Stored Procedures, Triggers, Cursors, Tables, Views, and User Defined Functions. Experience using SQL Server Integration Services to extract, transform, and load (ETL) data from spreadsheets, database tables, and other sources (SSIS). Working experience in Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems. Experience in Relational Modeling, Dimensional Modeling, Conceptual Modeling, Creating Logical Modeling, Physical Modeling, Data Warehousing, Fact Tables, Dimension Tables, Star Schema, and Snowflakes Schema. Good experience in using Tableau's capabilities, such as calculated fields, parameters, table calculations, joins, data blending, and dashboard actions. Worked on developing several Tableau visualizations using maps, scatter plot charts, heat maps, bar charts, line charts, and pie charts. Experience with Tableau reports and dashboards for analytics and reporting applications, including analysis, modeling, design, and development. Skilled in defining project scope based on gathered business requirements, including documentation of restrictions, assumptions, business consequences, and project risks. Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Erwin Diagram Publishing, analyzing data sources, and creating interface documents. Expertise of data extraction into the Data Stage from many database sources such as Oracle, MS SQL Server, DB2, and flat files. Proficient at utilizing Rational Rose to create Use Case Models, Analysis Models, Implementation Models, Use Case Diagrams, Behavior Diagrams, and Class Diagrams based on UML. Experience in Microsoft Office products, including MS Project, MS Access, MS Excel, MS Word, MS PowerPoint, and MS SharePoint. Experience with creating database schemas based on logical data models, dimensional modeling for data warehouses, and both logical and physical database modeling. Experience in GAP analysis, current state documentation (AS-IS), future state preparation (TO-BE), and transition strategy preparation. Proficient in using SQL and PL/SQL to apply business approaches, including writing SQL queries, and constructing database objects such stored procedures, triggers, packages, functions, and complex SQL queries to produce bespoke reports based on client/business requirements. Prepare reports using various visualization and data modeling techniques. Actively manage Tableau s performance and usability to achieve the desired outcome. Have solid experience working in an onsite or offshore environment, with the ability to comprehend and/or develop functional requirements while collaborating with clients. Worked with many support clients and RFP teams in analyzing and interpreting data using advanced analytical methods to address difficult analysis problems, providing opportunities for improvements. Experience in importing and exporting data between different sources like Excel and others using the SSIS Utility. Experience in creating configuration files to deploy SSIS packages across all environments. Designed and built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data using Tableau. TECHNICAL SKILLS: Primary Tools: Informatica Power Center 9.0.1/8.6/8.1, Ab Initio (Co>Op 3.0.3.9/2.15/2.14, GDE 3.0.4/1.15/1.14), Teradata SQL, Teradata Tools and Utilities, Oracle 10g/9i, MS SQL Server 6.5/7.0/2000 Languages: Teradata SQL, SQL, PLSQL, C/C++, Python, R, Bash Databases: Teradata 14/13/12/V2R6.2, Oracle 10g/9i, DB2/UDB, SQL Server, MS Access 2010/2007/2003, MySQL, PostgreSQL, MS SQL Server, MongoDB, Hive, Presto, AWS RDS, AWS Redshift, AWS Redis, Big Query Operating Systems: Windows 95/98/NT/2000/XP, UNIX, Linux, NCR MP-RAS UNIX Data Modeling: Erwin, ER Studio Tools: Tableau, Hadoop, Hive, Apache Airflow, Apache Spark, Flask, Apache Kafka, Jupyter Notebook, Excel, Jira, Git, Docker, Kubernetes Data Warehousing Informatica 9.1/8.6/7.1.2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS, Data Stage 8.x Scheduling tools: Control M, Autosys Tableau: Tableau Desktop 6/7/8/9, Tableau Server 5/6/7/8/9, Tableau Online, Tableau Public, Tableau Reader. Servers: Windows 2003, 2008, 2012R, Microsoft SQL Server 2012/2008-R 2/2008/2005. PROFESSIONAL EXPERIENCE: Boston Scientific, Coventry, RI Nov 2022 - present Senior Data Analyst Responsibilities: Gathered business needs through multiple talks and meetings with users and business analysts. Responsible for delivering BI support and ensuring high levels of availability in the Business Intelligence environment. Worked closely with Product Credit Risk Teams, provided in-depth insight and analysis to evaluate portfolio to maintain acceptable overall risk levels. Created triggers and stored procedures to updated daily market data into respective back-end SQL Server databases. Created Tableau views with complex calculations and hierarchies making it possible to analyze and obtain insights into large data sets. Managed, updated, and altered report orientation and structures using advanced Excel tools such as Pivot Tables and V-Lookups. Responsible for database design, coding, and unit testing. Using JIRA, I tracked, reviewed, and analyzed defects. Extracted data from various data sources such as SQL Server, MySQL, and Tableau Server and built queries to deliver data visually. Performed SQL optimization improving query performance, discovered error patterns, SQL errors and transaction errors and made correct inferences and recommendation for corrective actions Worked with the ETL team to understand data load/data mapping difficulties to ensure that data warehouse tables are generated in accordance with business needs. Developed complex database objects utilizing SQL and T-SQL, such as stored procedures, functions, packages, and triggers. Performed Data profiling, early data analysis, and handling of anomalies such missing data, duplicate records, extreme cases, and imputed irrelevant data. Performed Data Manipulation using MS Excel Pivot Sheets and produced various charts for creating the mock reports. Using methods like data filtering, adding interactivity, and publishing reports to the server using SSRS, monthly reports were generated as bar charts for the management. Complicated business logic was implemented by creating complex triggers, tables, views, SQL joins, and other statements to maintain referential integrity. Strong hands-on experience with Tableau desktop and Server, implementing dashboards, data visualizations, and analytics. Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. By modifying the PL/SQL scripts by 20% and shortening the on-migration time, a platform for all project modifications within the existing application was built. Developed a variety of chart formats, such as Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts, Bullet Graphs, Area Charts, and Scatter Plots, to create solution-driven views and dashboards. Worked on designing STAR schema for the detailed data marts and plan data marts consisting of confirmed dimensions. Create and execute ad hoc data queries from a variety of database formats to detect system of records, data discrepancies, and data quality concerns. Performed root cause analysis on more compact, independent data analysis assignments that are connected to given data processes. Created and executed ad hoc data queries from different types of databases to find system of records, data discrepancies, and data quality problems. Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages. Prepared high-level qualitative analysis to identify patterns and relationships in data and generate reports using Tableau visualization Review normalized schemas for effective and optimum performance tuning queries and data validations in OLTP and OLAP environments. DELL, NY May 2020 Oct 2022 Senior Data Analyst Responsibilities: Involved in performing extensive Back-End Testing by writing T-SQL queries and stored procedures to extract the data from SQL Database. Designed and built after update triggers on SQL server to manage the archive logging process. Query performance was tracked using a query analyzer, and queries and procedures were adjusted to improve database speed. Created sophisticated SQL scripts for data analysis and reports using joins, aggregate functions, and analytical functions. Create appealing, concise, and innovative advertisements to capture the attention of consumers. Conduct basic statistical analysis, create and present high-quality dashboards. Effectively communicate analysis to internal teams and clients via graphs, reports, and presentations. Create and maintain databases required for projects and department functions. Support ad hoc data analysis requests from business owners and the support management team. Worked on project coordination, testing, and requirements collecting while collaborating with the business analyst and DBA. Conducted research pertaining to customer data demands for information and tested the veracity of Ads made using SQL and Microsoft Excel. Involved in SQL query performance optimization. Information gathered from BRDs (Business Requirement Documents), supporting documents providing the crucial business components, and High-Level Logical Data Models. Contributed to the development of programmed automation for DBA operations to reduce manual labor and standardize procedures. Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concepts. Downloaded data from various sources and integrated data to a database and extract data for analysis. Improved performance by adding indexes, removing unnecessary columns in the inner views, and adding conditions to get only required data. Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems. Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models. Involved with data profiling for multiple sources and answered complex business questions by providing data to business users. Worked with data investigation, discovery, and mapping tools to scan every single datarecord from many sources. Involved in data mining, transformation, loading from source systems to target system. Created configuration packages in SSIS to move the packages from development serverto production server. Neiman Marcus, Paramus, NJ Feb 2018 Apr 2020 Data Analyst Responsibilities: Query performance was tracked using a query analyzer, and queries and procedures were adjusted to improve database speed. Created sophisticated SQL scripts for data analysis and reports using joins, aggregate functions, and analytical functions. Create appealing, concise, and innovative advertisements to capture the attention of consumers. Designing targeted ads for specific demographic audiences across multiple networks and social media platforms. Developed several automated solutions for the smooth operation of operational processes in workflows using Google Spreadsheets and Google Dashboards. Identifying complex problems, breaking them down into smaller parts, and implementing creative, data-driven solutions. Conduct basic statistical analysis, create, and present high-quality dashboards. Create and maintain databases required for projects and department functions. Support ad hoc data analysis requests from business owners and the support management team. Worked on project coordination, testing, and requirements collecting while collaborating with the business analyst and DBA. Conducted research pertaining to customer data demands for information and tested the veracity of Ads made using SQL and Microsoft Excel. Involved in SQL query performance optimization. Information gathered from BRDs (Business Requirement Documents), supporting documents providing the crucial business components, and High-Level Logical Data Models. Contributed to the development of programmed automation for DBA operations to reduce manual labor and standardize procedures. Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concepts. Downloaded data from various sources and integrated data to a database and extract data for analysis. Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data. Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format. Worked on data modeling and produced data mapping and data definition specification documentation. Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables Teradata database as part of data analysis responsibilities. Performed complex data analysis in support of ad-hoc and standing customer requests. Broadridge Financial Services, India June 2015 Oct 2017 Data Analyst Responsibilities: Developed several automated solutions for the smooth operation of operational processes in workflows using Google Spreadsheets and Google Dashboards. Designed a one-of-a-kind dashboard for the PLX scoreboard to keep track of the historical bell curve performance information for the teams. Conducted research pertaining to customer data demands for information and tested the veracity of Ads made using SQL and Microsoft Excel. Created sophisticated SQL scripts for data analysis and reports using joins, aggregate functions, and analytical functions. Effectively communicated analysis to internal teams and clients via graphs, reports, and presentations with basic statistical analysis and presented high-quality dashboards. Excellent familiarity with Google Search Ads in addition to the concepts that underpin advertising on third-party websites. Developed Google ads that are unique, eye - catching, and brief to seize the attention of potential customers. Customized ads specifically aimed at certain demographic groups and distributed them across several social media and network sites. Utilizing Google Spreadsheets and Google Dashboards, several automated solutions were developed to ensure the seamless running of various operational operations inside workflows. Identifying complex problems, breaking them down into smaller parts, and implementing creative, data-driven solutions. Perform some fundamental analysis of statistics. Produce and show off some impressive dashboards. Effectively communicate analysis to internal teams and clients via graphs, reports, and presentations. Develop and manage databases, which are essential to the completion of projects and the operation of the department. Aid with data analysis requests that have been made ad hoc by business owners and the support management team. Helped in the development and presentation of management-focused informational reports using SQL data. Designing targeted ads for specific demographic audiences across multiple networks and social media platforms. Combining data from Excel spreadsheets into an Access database for processing into state SQL databases. TA DIGITAL, India Sept 2013 May 2015 Data Analyst Responsibilities: Creating and maintain data model/architecture standards, including master data management (MDM). Extensively tested teh ETL mappings which were developed to load data from Oracle and SQL Server sources into teh Oracle Staging/Target Area. Perform GAP Analysis between existing and TO-BE Business process Models to understand teh additional functionalities required meeting HER standards. Electronic Data Interchange (EDI), EMR, EHR, HL7. Involved in (Master Data Management) MDM to help teh organization wif strategic decision making and process improvements. (streamline data sharing among personnel and departments) Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements. Created SQL tables wif referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL. Understand teh As Is system and develop teh To Be system concept and also prepare teh System Process Maps. Involved in conducting presentations of teh Q/A test results wif analysis to teh stakeholders and users and documented modifications and requirements. Worked on multiple FHIR implementations in Provider and Payer domain using FHIR STU3 and R4. Designing test scripts for testing of Claims in Development, Integration and production environment. Tested teh HL7 File formats received from different Vendors validated teh parsing and Data Loader (BizTalk, SSIS Process) functioning using SQL Statements in teh backend. Participated in all phases of teh Facets Extended Enterprise (TM) administrative system implementation including teh planning, designing/building/validation (DBV), and Go-live support phases. Assigned tasks among development team, monitored and tracked progress of project following agile methodology. Helped design data warehouse solutions and business intelligence dashboards and scorecards. Identified teh impacts teh HIPPA 5010 project had on enrollment Claims, FEP (Medicare and Medicaid program). Maintained proper communication wif teh developers ensuring that teh modifications and requirements were addressed and also monitored these revisions. Involved in compatibility testing wif other software programs, hardware, Operating systems and network environments. Keywords: cprogramm cplusplus business intelligence active directory rlang information technology golang microsoft procedural language Colorado New Jersey New York Rhode Island