| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Irving, TX Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLESummaryData Analyst with over 5 years of experience in leveraging data to drive business insights and decision-making. Proficient in designing and implementing data collection procedures, conducting rigorous analysis, and developing actionable reports and visualizations. Skilled in advanced SQL querying, BI platform architecture, AWS, and Azure resource management, with a proven track record of optimizing processes and delivering value to stakeholders. Strong communicator adept at collaborating with cross-functional teams and engaging with business users to gather requirements and provide training on self-service BI tools. Seeking to utilize my expertise and passion for data-driven solutions to contribute to the success of a dynamic organization. SkillsBigdata Technologies: HDFS, Spark, Cloudera.Scripting and Query Languages: Python, Oracle, MySQL, T- SQL, R, Machine Learning. Technical Tools: Workday Tool, Eclipse, PyCharm, IntelliJ, Subversion [SVN], ClearCase, Share, JIRA, Advanced Excel, Hadoop, Tableau, PowerBI, Kusto, KQL, Syslog. Data Analytics Skills: Data Governance and Compliance, Advanced Data Visualization Techniques, Predictive Analytics and Modelling, Written Communication, Data Engineering. Cloud Platforms: AWS (EC2, S3, RDS), Azure (Azure SQL Database, Azure Data Factory, Azure Blob Storage, Azure Machine Learning)Healthcare Domain: EHR data, clinical data, claims data, healthcare algorithms. Data Science: Causal inference, econometrics, statistical methodologies, predictive modeling. Additional Skills: Technical writing, Process Mapping, Database maintenance, Report writing, Business intelligence, Business Process Improvement, Meeting Business Requirements and Industry standards, Documentation, Loan administration, Manufacturing process improvement, Treasury management, Banking and financial services, Payment types such as (ACH, Wires, SWIFT, RTP, Digital Assets) and file transfer protocol (FTP/SFTP) and API banking, Pega BPM Platform, Pega design and development, Agile methodologies (Scrum, Kanban), Business Process Management(BPM) and case management.Soft Skills: Problem-solving, Critical Thinking, Attention to Detail, Adaptability. Work ExperienceSr. Data Analyst 05/2022 to CurrentTech Span LLC Dallas, TX At Tech Span LLC, I engineered data pipelines using Python and Hive, demonstrating my ability to manage data extraction, transformation, and loading processes. Developed Python scripts for data retrieval and consolidation from multiple databases, indicating my familiarity with ETL processes. Collaborated with software engineering teams on app development projects, ensuring alignment of business requirements with technical solutions. Performed source to target mapping for data migration projects, ensuring accurate data transformation and integration. Defined and managed API contracts to facilitate data exchange between systems, ensuring clear communication and data integrity. Managed and optimized databases at Tech Span LLC, ensuring data quality and accuracy, which is fundamental to designing robust enterprise database systems. Streamlined complex queries, which likely involved optimizing database performance through indexing and normalization techniques.Collaborated with Product and Data Science teams to establish campaign measurement KPIs and designed logging specifications for data capture, coordinating with Software Engineering to implement logging and validate data integrity.Utilized advanced statistical techniques such as regression analysis and hypothesis testing to derive insights from healthcare claims data, assessing the impact of our products on key performance metrics. Developed predictive models using machine learning algorithms to forecast patient risk scores and healthcare utilization trends based on historical data.Collaborated closely with clinical experts to ensure data interpretation aligned with medical domain knowledge and healthcare industry best practices.Managed and optimized databases, employing SQL, joins, and sub-queries to streamline complex queries and ensure data quality and accuracy.Developed Python scripts for data retrieval and consolidation from multiple databases, including MySQL, SQL Server Management Studio, and Oracle, facilitating monthly data analysis for Corporate Planning.Engineered data pipelines using Python and Hive for loading and processing campaign data, performing data analysis, and executing data mapping for various sources. Ensured database integrity and consistency through manual testing and created optimized hive DDLs for partitioned and bucketed tables.Handled fast-paced ad-hoc business data requests with efficiency and accuracy. Environmental Skills: Database development, Querying and Scripting, Data Processing and Cleaning, Ad-hoc Data Requests, Partitioning, and Bucketing.Business Data Analyst 02/2021 to 12/2021Zensar Technologies Pune, Maharashtra Conducted thorough testing of new data functionalities using predefined test cases, collaborating closely with development teams to address any identified issues promptly. My role involved employing SQL joins and sub-queries to optimize database queries, directly relating to performance tuning. SQL querying skills, including the use of joins and sub-queries, which are essential for creating stored procedures, views, and triggers. Performed source to target mapping for data migration projects, ensuring accurate data transformation and integration. Conducted source to target mapping for data integration projects, ensuring accurate transformation and load processes. Developing comprehensive reports and conducting data analysis indicate my experience with advanced SQL functionalities, likely including stored procedures and views. Played a pivotal role in ensuring the quality of data-related releases, including testing release processes and validating data integrity using SQL queries. Implemented automated testing procedures to streamline database testing processes and enhancing efficiency. and accuracy in data validation. Conducted rigorous data testing and validation on healthcare databases containing electronic medical records(EMR) and clinical trial data to ensure data integrity. Designed and executed test cases specifically focused on evaluating statistical methodologies and predictive models applied to healthcare datasets. Leveraged knowledge of HIPAA regulations and data governance practices to maintain compliance while handling sensitive patient information. Leveraged Azure Blob Storage for handling large datasets and maintaining compliance with data governance practices. Worked closely with healthcare data scientists to understand and document the assumptions and limitations of analytical models used for clinical decision support. Collaborated closely with database development teams to test and implement data-related solutions, adapting test cases based on evolving project requirements and user feedback. Generated comprehensive reports for automated tests, providing clear insights into data quality and system functionality, while also ensuring timely project delivery and providing end-user support as needed. Environmental Skills: Data Testing, Advanced SQL Proficiency, Automation Skills, Collaboration and Communication, Analytical Skills, Documentation and Reporting, Time Management and Prioritization, Adaptability and Continuous Improvement.Data Analyst 08/2019 to 12/2020Cybage Software Private Pune, Maharashtra Enhanced data collection procedures for analytics, maintaining complex SQL queries and reports on Snowflake. Conducted analysis, testing, and documentation for BI platform architecture and data migration. Managed AWS resources, including EC2 instances and S3 buckets, and utilized open-source technologies for data solutions. My work on database development and maintenance involves using both DDL and DML commands to define, manage, and manipulate data structures. Played a key role in the development of a BI reporting application. Gathered and documented requirements, worked with developers to design the application, and ensured seamless integration with existing data sources. Creating optimized Hive DDLs for partitioned and bucketed tables showcases my experience with DDL, while my SQL querying and data retrieval tasks demonstrate my use of DML. Engaged with stakeholders to gather requirements, design visualizations, and provide training on BI tools. Developed intuitive visualizations in Tableau and Power BI, monitored process efficiency, and ensured compliance with system life cycle procedures. Designed and developed Pega-based solutions, including data models and process flows. Gathered requirements, designed visualizations, and trained users on Pega BI tools. Managed AWS resources and utilized Pega for data solutions. Environmental Skills: SQL Proficiency, Business Intelligence (BI) Platform Architecture Understanding, Stakeholder Engagement, Visualization Design and Development (Tableau, Power BI), Process Optimization and Monitoring, Documentation and Compliance.Education and TrainingMasters in Business Analytics 01/2022 - 12/2023University of North Texas Denton, TXBachelors in Business Administration 06/2017 - 05/2020 Siva Sivani Degree College. Hyderabad, IndiaProjects During my third year of bachelor's studies, I conducted an in-depth project titled "A Comparative Study on Non-Banking Financial Companies (NBFCs) and the Banking Sector." This study aimed to analyze and contrast the operational dynamics, financial performance, and market impact of NBFCs and traditional banking institutions in India, providing valuable insights into their respective roles in the financial ecosystem. Diamond Price Prediction Project: Leveraged machine learning algorithms and data analysis techniques to build predictive models for forecasting diamond prices based on various attributes. Healthcare Data Analysis: Conducted research using complex EHR and claims datasets to derive insights into patient outcomes and healthcare costs. Utilized causal inference methods to assess the impact of treatment protocols. Azure Source to Target Mapping Project: Developed and implemented source to target mapping for data migration to Azure SQL Database, ensuring data consistency and integrity. Certifications Data Analytics Certification: Utilized advanced analytics skills to interpret complex datasets, derive actionable insights, and drive strategic decision-making, collaborating with cross-functional teams to establish campaign measurement KPIs and design logging specifications for data capture. Digital Marketing Certification: Applied digital marketing strategies to optimize campaign performance, developing Python scripts for data retrieval and consolidation from multiple databases to facilitate monthly data analysis for corporate planning, ensuring data integrity and accuracy through manual testing and validation. Google Data Analytics Professional Certificate: Leveraged data analytics techniques and tools, such as SQL querying and database optimization, to streamline data processing and cleaning procedures, enhancing efficiency and accuracy in ad-hoc data requests and automated testing processes. Pega Business Analyst Certification: Validated proficiency in using the Pega Platform to design and implement business solutions, focusing on requirement gathering, process mapping, data modeling, and user interface design. Demonstrated ability to translate business needs into functional Pega applications, ensuring efficient and effective solution delivery. Machine Learning Certification: Completed training covering supervised and unsupervised learning techniques, model evaluation, and deployment for predictive modeling applications. |
