Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ahmadi Sultana

Lowell,MA

Summary

Over 7+ years of diverse experience as a certified software professional in the field of Data Analysis, Data Profiling, Data Integration, Data governance and Metadata Management, Master Data Management and Database Testing Expertise in Data Validation, Source to Target mappings, SQL Joins, Data Cleansing Hands on experience with analytical programming languages SAS, R, Python and SQL Good Experience with Django, a high - level Python Web framework. Experience object-oriented programming (OOP) concepts using Python, Django, and Linux. Creating dashboards and applications with Data visualization/analytics tools like Tableau Desktop, Python Matplotlib Documenting new data additions to help source to target mapping. Also updating the documentation for existing data assisting with data profiling to maintain data sanitation, validation, and quality. Experienced in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design. Experienced in developing Web Services with Python programming language. Experienced in Project management tools like JIRA (Agile and SDLC), MS project, MS excel and maintain version control in GitHub. Familiar with JSON based REST Web services and Amazon Web Services (AWS). Demonstrated abilities in executing projects related to Healthcare and Banking domains. Knowledge of Software Development Life Cycle (SDLC), Software Testing Life cycle (STLC) and Agile methodologies. Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man Assist in providing time estimates for project related tasks. Develop the methods and procedures required to identify whether current business goals and objectives meet organizational needs and work with BA and IT management to identify, record, track & report data issues. Successfully executing the role of Data Analyst by managing, analyzing, and defining, recommending, and improving prevailing process. Ability to identify root causes and derive corrective actions to meet short and long-term business requirements using resourceful approaches. Good Knowledge in Analysis of Problem Severity, Defect tracking system and Defect reporting system. Ability to set and achieve goals, work well independently or in team, skills in identifying problems and meeting goals. Ability to work under strict deadlines and solid troubleshooting skills. Excellent communication and logical skills, leadership qualities, systematic approach and can work effectively in a fast-paced environment. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills. Proactive Business Data Analyst with 7+ years product management experience in small start-up business environments. Effective driver of product development lifecycle from concept to delivery. Communicative and collaborative with proven history of improving business operations to support corporate growth and revenue. Proactive Business Analyst with 4+ years product management experience in small start-up business environments. Effective driver of product development lifecycle from concept to delivery. Communicative and collaborative with proven history of improving business operations to support corporate growth and revenue. Personable business professional bringing successful 4 year career in financial roles within large and fast-paced corporations. Release-planning specialist trained in advanced Excel modeling. Creative solutions architect with real-time problem-solving flexibility. Proactive Financial Data Analyst with 4+ years product management experience in small start-up business environments. Effective driver of product development lifecycle from concept to delivery. Communicative and collaborative with proven history of improving business operations to support corporate growth and revenue. Personable business professional bringing successful 4 year career in financial roles within large and fast-paced corporations. Release-planning specialist trained in advanced Excel modeling. Creative solutions architect with real-time problem-solving flexibility. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level Business Data Analyst position. Ready to help team achieve company goals. Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level Business Data Analyst position. Ready to help team achieve company goals. Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level Business Analyst position. Ready to help team achieve company goals. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills. Thorough quality assurance professional highly skilled in manual and automated application testing. Partners successfully with project management and development team members to put out high-quality software for customers. Decisive in identifying problems at any stage of production. Demonstrated success in gray, white and black box testing. Write and understand test cases, create test plans and identifying use cases. Comprehensive understanding of full software development lifecycle.

Overview

9
9
years of professional experience

Work History

Data Analyst

MUFG Bank
New York
01.2022 - 06.2023
  • Communicated with business users, data architects and developers to identify needs, define project scope and detailed functional and non-functional requirements
  • Extraction of the reports, making necessary changes and visualization with the help of power-bi and pivot table
  • Prepared Data Mapping documents, Use Cases, Requirements Traceability Matrix and worked with the User experience team
  • Client Onboarding, KYC, AML, Risk Management, Compliance, Compliance testing, Sanctions screening
  • Accessed and analyzed Identity Access management data, created reports, identified Missing Feeds
  • Regulatory reporting, Operations, Projects in banking and financial services industry
  • Created Python scripts on Databricks which extracts data from Snowflake server and upload the files to s3 buckets using python
  • Created requirement documentation, reviewed with user representatives, recommended priorities, gave presentations and walkthroughs, and obtained user signoff
  • Driven daily stand-up meetings offshore, iteration planning meetings and requirement gathering meetings
  • Extracted data from different public data repositories and from different databases and creating datasets for statistical analysis
  • Prepared Scripts in Python and Shell for Automation of administration tasks
  • Used advanced data modeling concepts of degenerated dimension, sub-dimension, Fact-less fact table, Aggregate fact tables in the multidimensional model
  • Hands-on development in creating and modifying worksheets and data visualization dashboards
  • Designed & developed various analytical reports from multiple data sources by blending data on a single worksheet in Power Bl dashboard
  • Developed dashboards (Python, SQL) on safety-tagged documents of incidents and cost tables by time series
  • 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
  • Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards
  • Developed self-service models, data analytics using power BI service
  • Developed customer view Reports (Ad Hoc Reports, Frequency Reports, Summary Reports) using python
  • Created and modified Interactive Dashboards and Created guided navigation links within Interactive Dashboards
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle 12g and MS Excel
  • Developed rule-based analytic using python; provided filter recommendation for statues, bottleneck tasks
  • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
  • Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc
  • Effectively schedule, assign, and prioritize tasks to ensure proper incidents handling
  • SQL, MS Excel, Oracle 12g, Tableau, Power BI Desktop and Power BI Service Pro.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.
  • Utilized data visualization tools to effectively communicate business insights.
  • Tested data prediction algorithms based on historical data.
  • Participated in requirements meetings to understand business needs.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements.
  • Collaborated with business-unit leaders to identify and prioritize problems.
  • Documented effective and replicable methods for extracting data and organizing data sources.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Upheld security and confidentiality of documents and data within area of responsibility.
  • Used statistical methods to analyze data and generate useful business reports.
  • Implemented code solutions to answer analytic questions and test and assess new methods.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Designed and implemented tools to support strategic value chain optimization initiatives.
  • Developed data mining algorithms to identify and classify patterns in data.
  • Designed and developed data pipelines to acquire, clean and process data.
  • Deployed predictive analytics models to forecast future trends.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Developed and implemented data governance policies and procedures.
  • Created data models to support decision-making processes.
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.
  • Optimized data access and storage to improve performance of analytics systems.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Created dashboards to monitor and track key performance indicators.
  • Created and optimized automated testing tools for repetitive tasks.
  • Produced test scripts for new automated software testing rounds.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Identified patterns and trends in large data sets and provided actionable insights.
  • Utilized data visualization techniques to present and explain complex data sets.
  • Generated standard and custom reports to provide insights into business performance.
  • Met project scope and delivery dates by planning optimal testing schedules.
  • Completed unit and regression tests on software and individual modules.
  • Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Assisted with creating data cubes and OLAP models to improve data analysis.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Created and maintained database of common and known testing defects.

Data Analyst

San Soft ServicesNov
Ohio City, OH
01.2019 - 09.2021
  • Gathered Business Requirements from stake holders, interacted with the Users, Project Manager, and IT teams to get a better understanding of the project goals
  • Performed gap analysis of the data and reviewing the requirements
  • Involved in defining the whole project life cycle, following agile methodology
  • Analyzed business requirements and segregated them into high level and low-level priorities
  • Worked with Data Management team to analyze sales Data using tools like Python, Access, Excel (Lookups, Pivot tables) and predicting any future impacts on business
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau and power BI Desktop

  • Created and maintained database of common and known testing defects.
  • Building Analysis Services reporting models
  • Developing visual reports, dashboards and Risk indicators scorecards using Power BI desktop
  • Connecting to data sources, importing data and transforming data for Business Intelligence
  • Requirements for various reports, dashboards, scorecards and created the same using Tableau and power BI desktop server
  • Performed data mapping for extraction and loading
  • Designed and configured partitioning of tables and indexes to improve query performance in SQL especially considering memory limitations
  • 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
  • Cleaned and processed third-party spending Data into maneuverable deliverables within a specific format with Excel and python libraries such as NumPy and Pandas
  • Responsible for the interactive experience of the site
  • Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests
  • Utilizing Pandas, NumPy, SciPy, Matplotlib, and Scikit-learn, and in Python for developing various machine-learning algorithms
  • Designed and developed various SQL scripts as part of automation of manual monthly reporting to third party consumer
  • Automate web-scraping tool to produce marketing content using Python
  • Worked with Agile and Scrum methodologies to accomplish project milestones and meet demanding timelines.
  • Proficient in importing/exporting large amounts of data from files to Teradata and vice versa
  • Proficient working in loading data into staging tables via views
  • Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL
  • SQL, MS Excel, and Tableau.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Tested data prediction algorithms based on historical data.
  • Utilized data visualization tools to effectively communicate business insights.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Upheld security and confidentiality of documents and data within area of responsibility.
  • Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements.

  • Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
  • Produced test scripts for new automated software testing rounds.
  • Tested functionality, performance and compliance of each product against design specifications to maintain strong development standards and high customer satisfaction.
  • Collaborated with business-unit leaders to identify and prioritize problems.
  • Documented effective and replicable methods for extracting data and organizing data sources.
  • Used statistical methods to analyze data and generate useful business reports.
  • Implemented code solutions to answer analytic questions and test and assess new methods.
  • Analyzed transactions to build logical business intelligence model for real-time reporting needs.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Designed and implemented tools to support strategic value chain optimization initiatives.
  • Developed data mining algorithms to identify and classify patterns in data.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Deployed predictive analytics models to forecast future trends.
  • Designed and developed data pipelines to acquire, clean and process data.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Assisted with creating data cubes and OLAP models to improve data analysis.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Implemented business intelligence solutions to increase operational efficiency.
  • Generated standard and custom reports to provide insights into business performance.
  • Developed customized reports, summarizing and presenting data in visually appealing format.
  • Developed and implemented data governance policies and procedures.
  • Utilized data visualization techniques to present and explain complex data sets.
  • Identified patterns and trends in large data sets and provided actionable insights.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Created dashboards to monitor and track key performance indicators.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Optimized data access and storage to improve performance of analytics systems.
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.
  • Created data models to support decision-making processes.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.

Data Analyst

Advance Financial 247
Tennessee Ridge, TN
02.2017 - 08.2019
  • Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
  • Data analysis and reporting using MS Power Point, MS Access, and SQL assistant
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services
  • Used advanced Microsoft Excel to create pivot tables, used VLOOKUP and other Excel functions
  • Worked on CSV files while trying to get input from the MySQL database
  • Implement code in Python to retrieve and manipulate data
  • Created functions, triggers, views and stored procedures using MySQL
  • Worked on database testing, wrote complex SQL queries to verify the transactions and business logic
  • Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems
  • Developed SQL scripts for creating tables, Sequences, Triggers, views and materialized views
  • Compiled data from various sources public and private databases to perform complex analysis and data manipulation for actionable results
  • Provided production support for python ETL application
  • Used and maintained database in MS SQL Server to extract the data inputs from internal systems
  • Interacted with the Client and documented the Business Reporting needs to analyze the data
  • Automate web-scraping tool to produce marketing content using Python
  • Used SAS for pre-processing data, SQL queries, data analysis, generating reports, graphics, and statistical analyses
  • Developed data mapping documentation to establish relationships between source and target tables including transformation processes using SQL
  • Used the Waterfall methodology to build the different phases of Software development life cycle
  • Participated in all phases of data mining, data collection, data cleaning, developing models, validation, and visualization and performed Gap analysis
  • Demonstrated experience in design and implementation of Statistical models, Predictive models, enterprise data model, metadata solution and data life cycle management
  • Extensive data cleansing and analysis, using pivot tables, formulas (V-lookup and others), data validation, conditional formatting, and graph and chart manipulation using excel
  • Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Tested data prediction algorithms based on historical data.
  • Utilized data visualization tools to effectively communicate business insights.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.
  • Participated in requirements meetings to understand business needs.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Upheld security and confidentiality of documents and data within area of responsibility.
  • Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements.
  • Documented effective and replicable methods for extracting data and organizing data sources.
  • Used statistical methods to analyze data and generate useful business reports.
  • Implemented code solutions to answer analytic questions and test and assess new methods.
  • Analyzed transactions to build logical business intelligence model for real-time reporting needs.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Designed and implemented tools to support strategic value chain optimization initiatives.
  • Developed data mining algorithms to identify and classify patterns in data.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Deployed predictive analytics models to forecast future trends.
  • Designed and developed data pipelines to acquire, clean and process data.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Assisted with creating data cubes and OLAP models to improve data analysis.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Implemented business intelligence solutions to increase operational efficiency.
  • Developed and implemented data governance policies and procedures.
  • Developed customized reports, summarizing and presenting data in visually appealing format.
  • Generated standard and custom reports to provide insights into business performance.
  • Utilized data visualization techniques to present and explain complex data sets.
  • Identified patterns and trends in large data sets and provided actionable insights.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Created dashboards to monitor and track key performance indicators.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Optimized data access and storage to improve performance of analytics systems.
  • Created data models to support decision-making processes.
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.

Quality Analyst

IKS Healthcare
Hyderabad, Telangana(India)
09.2014 - 11.2016
  • Collaborated with business leaders, IT groups and vendors to ensure issues communicated clearly and accurately
  • Perform data analysis to evaluate the data quality and resolve the data related issues
  • Responsible for improving data quality and for designing or presenting conclusions gained from analyzing data using Microsoft Excel as statistical tool
  • Performed Data reconciliation of source, Referential Integrity, Null and Default value checks and Business Rules applied
  • Debugged data issues between source systems and EDW
  • Profiled data in the sources prior to defining the data cleaning rules
  • Verified the data loads as well as the reports
  • Involved in identifying reporting needs and helping the business in creating specification and worked closely with report development team to achieve the reporting goal
  • Assisted the project manager in setting up the direction for business analysis team
  • Developed custom routines for generating test cases
  • Created the Test Specifications, Test Scripts and Test Categories for the testing of data in the EDW
  • Attended defect triage meetings with the end users and developers.
  • Defined and implemented quality initiatives to reduce risk.
  • Collaborated with management to provide training on improved processes and assisted with creation and maintenance of quality training.
  • Developed and maintained quality assurance procedure documentation.
  • Consulted manuals and process documents to investigate malfunctions.
  • Provided regular updates to team leadership on quality metrics by communicating consistency problems or production deficiencies.
  • Addressed non-conformance issues, pausing production to correct errors.
  • Created and revised procedures, checklists and job aids to reduce errors.
  • Performed standard first article inspections and random sampling inspections to verify adherence to customer standards.
  • Developed training materials, SOPs and work instructions to supplement new team member onboarding.
  • Recorded findings of inspection process, collaborating with quality team to implement corrective actions.
  • Participated in departmental meetings to establish short- and long-term strategy.
  • Administered [Number] internal quality audits and assessed results to inform corrective action measures.
  • Analyzed quality and performance data to support operational decision-making.
  • Used [Software] to create presentations, flowcharts and graphs detailing data analysis results.
  • Led process improvement projects to help operations meet and exceed quality standards and reduce costs.
  • Compiled and distributed weekly feedback to team leaders and managers to improve service time and quality while increasing productivity.
  • Monitored KPIs to proactively address bottlenecks and quality issues.
  • Liaised with vendors and end-users to uncover system optimization opportunities.
  • Created and collaborated in implementation and maintenance of customer complaint log.
  • Edited, proofed and critiqued internal documents to improve clarity.
  • Verified development and maintenance of regression test suites, analyzing compliance with prescribed standards and alignment with outcome tolerances.
  • Managed resource allocation and networked to manage planning and operations in testing cycle.
  • Coordinated routine activities for various test teams, scheduled drive tests and cluster assignments.
  • Monitored virtual server environment targeting testing and backend servers.
  • Completed unit and regression tests on software and individual modules.
  • Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
  • Created and maintained database of common and known testing defects.
  • Produced test scripts for new automated software testing rounds.

Education

MBA - Information Technology

Potomac University
D.C, Washington

Skills

  • Technical Skills
  • Data Analytics
  • Data Extraction, Data Cleaning, Data Mapping, Data Mining, Machine Learning
  • Machine Learning: R, Python, Tableau, SQL, MS-Excel, SPSS
  • Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK, SED
  • ETL Tools / Tracking tool: SSIS, SSAS, SSRS / JIRA
  • Operating System: Windows 10/8, Unix, Sun Solaris
  • ETL/Data warehouse Tools: Informatica 101, SAP Business Objects XIR31/XIR2, Talend, Tableau
  • Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Agile, Waterfall Model
  • P>Data profiling
  • P>Data validation
  • P>Data quality assurance processes
  • P>Activity diagrams
  • P>Enterprise application integration
  • P>Data formatting
  • P>Defect tracking
  • P>Use Cases
  • P>Oracle Business Intelligence
  • P>Data Science
  • P>Hyper Space software
  • P>SAP Netweaver BW
  • P>UNIX platform
  • P>Software Testing Life Cycle (STLC)
  • P>IBM Rational PurifyPlus
  • P>BM WebSphere
  • P>Project Management
  • P>Microsoft Visio
  • P>Process Mapping
  • P>Technical Analysis
  • P>Data analysis
  • P>Wise Solutions software
  • P>Search Engine Optimization
  • P>Technical Writing
  • P>Business needs analysis
  • P>Product development
  • P>Teradata BTEQ
  • Performance Testing
  • Software Development Tools: JIRA, Confluence
  • White Box Testing
  • Automated Testing Frameworks
  • Software Documentation Reviews
  • Testing Analytics
  • Automation Scripting
  • Compliance Testing
  • Security Testing
  • Test Plans and Test Methodologies
  • Defect Tracking and Reporting
  • Bug Tracking and Resolution
  • Engineering Team Support
  • Team Mentoring

Timeline

Data Analyst

MUFG Bank
01.2022 - 06.2023

Data Analyst

San Soft ServicesNov
01.2019 - 09.2021

Data Analyst

Advance Financial 247
02.2017 - 08.2019

Quality Analyst

IKS Healthcare
09.2014 - 11.2016

MBA - Information Technology

Potomac University

Similar Profiles

CREATE PROFILE
Ahmadi Sultana