Marcia is available for hire
Hire MarciaMarcia Searwar
Verified Expert in Engineering
Data Analyst and SQL Developer
Georgetown, Demerara-Mahaica, Guyana
Toptal member since November 30, 2021
Bio
Marcia is an accomplished software developer transitioning to data analyst to pursue her passion for solving problems through data. She is a dedicated, well-educated professional with years and breadth of experience, bringing together the technical and business worlds to understand and provide data-driven solutions. Marcia is a persistent and quick learner with a keen eye for detail.
Portfolio
Guyana Revenue Authority (GRA)
IT Management, IT Project Management, SQL, Business Intelligence (BI)...
intuivi Inc.
GitHub, Business Analysis, Business Intelligence (BI), JasperReports...
Latina S.A.M.
SQL, Excel 2016, OpenRefine, Business Analysis
Experience
Availability
Part-time
Preferred Environment
Oracle SQL Developer, OpenRefine, Microsoft Excel, Tableau, SQL
The most amazing...
...feeling comes from cleaning, organizing, analyzing, and presenting data to a client that highlights a crucial insight or that allows them to solve a problem.
Work Experience
Software Development Manager
2012 - PRESENT
Guyana Revenue Authority (GRA)
- Collaborated with the development team, the vendor, and other stakeholders to replace the Tax Revenue Management System, a core business system, including an e-services site for taxpayers.
- Prepared taxpayers' registration and financial data for migration to the new system using SQL scripts.
- Guided a team in analyzing, designing, and developing SQL views, reports, and Jaspersoft dashboards for operational and strategic use by the authority and external stakeholders.
- Supervised and cultivated the applications department within the IT division. The team comprised 14 senior analyst programmers, analyst programmers, and database administrators.
- Guided the team that developed, customized, and implemented several bespoke software solutions and off-the-shelf solutions to meet the needs of the GRA, covering mainly taxes, customs and license revenue, and support services like HR and Finance.
- Collaborated and supported the team that provided support for all software applications.
Technologies: IT Management, IT Project Management, SQL, Business Intelligence (BI), Requirements Analysis, Quality Assurance (QA), Business Process Re-engineering, Relational Database Design, Oracle PL/SQL, Oracle, Microsoft Excel, Business Analysis, Data Migration, Software Testing, Data Visualization, JasperReports, Data Cleansing, Oracle SQL Developer, Microsoft SQL Server, GitLab, Visual Paradigm, Balsamiq Mockups, Data Analysis, Database Design, Software Development, Customer Support, App Maintenance, System Design, Technical Documentation, GitHub, Oracle Database, Data Modeling
IT Consultant
2005 - PRESENT
intuivi Inc.
- Cleaned data for migration to new systems, prepared reports and dashboards, compiled data for analysis, and developed and maintained database objects using Excel, SQL, JasperReports, OpenRefine, and Tableau.
- Collaborated with the team to provide a software solution to the Guyana Post Office Corp. to manage clients and provide services, such as payment of bills, money transfers, and social disbursements.
- Participated in providing an ICT solution to the Ministry of Social Protection to manage and pay social benefits.
- Contributed to providing a software solution for the management of trainees and programs for the Board of Industrial Training, a government agency that provides vocational training.
Technologies: GitHub, Business Analysis, Business Intelligence (BI), JasperReports, OpenRefine, Python, Oracle JDeveloper 12c, PostgreSQL, MySQL, Oracle Database, Microsoft Excel, SQL, Java, Oracle PL/SQL, R, Oracle, Tableau, Relational Database Design, Data Migration, Software Testing, Business Process Re-engineering, Data Visualization, Data Cleansing, Oracle SQL Developer, GitLab, Visual Studio Code (VS Code), Visual Paradigm, Balsamiq Mockups, Flutter, Data Analysis, Crystal Reports, Requirements Analysis, Database Design, Software Development, Customer Support, App Maintenance, System Design, Technical Documentation, IT Project Management, IT Management, Quality Assurance (QA), Data Modeling
Data Analyst Consultant
2021 - 2021
Latina S.A.M.
- Performed data cleansing on lists of organizations and suppliers' product inventory using OpenRefine and SQL.
- Developed SQL procedures to match the organization's products with suppliers' products and produce a ranked match quality score.
- Analyzed the alcoholic beverage product space and discussed opportunities for long-term maintenance of product lists with the client.
Technologies: SQL, Excel 2016, OpenRefine, Business Analysis
Senior Analyst Programmer
2009 - 2010
Guyana Revenue Authority (GRA)
- Supervised the team in analyzing, developing, implementing, and maintaining several bespoke software solutions.
- Taught the team SQL, PL/SQL, and Crystal Reports and supported their daily use.
- Implemented standard operating procedures, naming standards, development methodologies, and other systems required for a fledgling software development unit.
- Worked with the team to prepare several requirements-specification documents for solutions to be provided by external entities. Conducted technical and usability evaluation of proposed solutions and presented findings to the management.
Technologies: Requirements Analysis, System Design, Software Development, Technical Documentation, IT Project Management, IT Management, Oracle PL/SQL, SQL, Oracle, Microsoft Excel, Business Analysis, Relational Database Design, Software Testing, Business Process Re-engineering, Oracle SQL Developer, Visual Paradigm, Database Design, Customer Support, App Maintenance, Quality Assurance (QA), Oracle Database, Data Modeling
Analyst Programmer
2001 - 2009
Guyana Sugar Corporation Inc. (GuySuCo)
- Supported the evolution of GuySuCo’s payroll and human resource management information system, SugarPay, which was developed in-house to manage over 15,000 employees—employment history and weekly payment and attendance across five sugar estates.
- Wrote simple and complex SQL procedures, functions, packages, scripts, and queries to support SugarPay.
- Designed and created a full suite of reports used by senior management, payroll, and the human resources staff, utilizing Crystal Reports and SQL.
- Participated in each phase of the development lifecycle of SugarPay, from analysis to testing. Created project lifecycle documentation, including technical documentation and other administrative documents.
- Participated in the business reengineering process that optimized the procedures for processing wages and human resource management matters.
- Implemented and supported SugarPay’s maintenance and upgrades. Addressed queries and changes in business rules and created new features, functionalities, and reports.
Technologies: Crystal Reports, SQL, Oracle PL/SQL, Visual Basic, Requirements Analysis, Database Design, Software Development, Software Testing, Business Intelligence (BI), Customer Support, Business Process Re-engineering, App Maintenance, Oracle, Microsoft Excel, Business Analysis, Relational Database Design, Technical Documentation, Quality Assurance (QA), Oracle Database, Data Modeling
Experience
Analysis of How Annual Members and Casual Riders Use Cyclist Bikes
https://github.com/marciasearwar/cyclistic-divvy-bikesThis case study was completed as part of my Google Data Analytics professional certificate. The objective was to analyze how annual members and casual riders use cyclist bikes differently to determine the best marketing strategy to convert casual riders into yearly members.
I analyzed, cleaned, and organized data from the Divvy Bikes website and used Tableau to create data visualizations.
I analyzed, cleaned, and organized data from the Divvy Bikes website and used Tableau to create data visualizations.
Education
2010 - 2012
International MBA in Entrepreneurship and Innovation
Arthur Lok Jack Global School of Business, University of the West Indies, St. Augustine Campus - Mount Hope, Trinidad and Tobago
1998 - 2001
Bachelor's Degree in Computer Science
Queen Mary University of London - London, UK
Certifications
APRIL 2022 - PRESENT
Tableau Desktop Specialist
Tableau
SEPTEMBER 2021 - PRESENT
Google Data Analytics Certificate
Coursera
Skills
Libraries/APIs
JasperReports
Tools
Microsoft Excel, OpenRefine, Tableau, Oracle JDeveloper 12c, GitLab, Visual Paradigm, Balsamiq Mockups, Crystal Reports, GitHub, Excel 2016, Tableau Desktop Pro
Languages
SQL, Java, Python, R, Visual Basic
Paradigms
Business Intelligence (BI), Software Testing, Requirements Analysis, Database Design
Platforms
Oracle, Visual Studio Code (VS Code), Windows, Oracle Database
Storage
Oracle PL/SQL, Oracle SQL Developer, MySQL, PostgreSQL, Microsoft SQL Server
Frameworks
Flutter
Other
Business Analysis, Relational Database Design, Data Migration, Data Visualization, Data Cleansing, Data Modeling, Business Process Re-engineering, Data Analysis, Software Development, Customer Support, App Maintenance, System Design, Technical Documentation, IT Project Management, IT Management, Quality Assurance (QA), Visualization, Data, Data Analytics
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring