Data Analyst Software Development
Resume:
Prerna N Patel
Burke, Virginia 22015
Mobile: 703-***-****
Email: ******.*.*****@*****.***
Professional Experience:
Data Analyst
Gunnison Consulting Group
July 2018 – Present
Cloud Infrastructure Deployment: Successfully deployed and managed virtual machines within Microsoft Azure and Amazon AWS environments. Configured instances to meet operational demands and tailored configurations to specific project requirements, ensuring optimal performance and resource utilization. Implemented secure deployment practices following DevSecOps principles.
Web Application Development: Designed and deployed web applications using server-side scripting with Python and client-side scripting with jQuery, seamlessly integrating with relational databases. Ensured adherence to CI/CD pipelines using Git for version control, enabling streamlined application updates and team collaboration.
Software Problem Resolution: Utilized JIRA to track, manage, and resolve software-related issues. Proactively identified bottlenecks and implemented solutions while leading meetings to discuss system performance and incorporating stakeholder feedback to improve software functionality.
Data Visualization and Reporting: Generated high-quality, parameterized reports using SAS Visual Analytics, incorporating graphs, charts, and dashboards derived from validated datasets. Ensured data quality through rigorous validation checks, enabling accurate reporting and actionable insights for stakeholders.
Agile Project Leadership: Directed team members through the Agile development lifecycle, including backlog creation, user story development, and grooming. Defined user acceptance criteria and conducted thorough testing in both development and test environments to validate user stories and ensure deliverables were met efficiently.
End-to-End Software Development: Led complete software development processes, from inception to deployment and maintenance, for critical projects supporting Post Enumeration Survey (PES) and Island Areas (IA) initiatives at the U.S. Census Bureau. Used Visual Studio Code and GitLab for CI/CD pipelines, ensuring proper versioning and collaborative development.
SAS Programming Expertise: Provided advanced SAS programming and analytical support, including designing, debugging, and documenting SAS programs to deliver accurate demographic and cross-tabulation products. Implemented comprehensive quality control checks, developed robust data specifications, and ensured accuracy and compliance with statistical reporting standards.
Process Automation: Spearheaded automation efforts for PES code development, incorporating newly implemented tables and updated data sources to produce consistent and reliable results. Enhanced legacy systems with modern methodologies to address defects and inefficiencies, improving overall system performance.
Metadata and Cross-Tabulation Integration: Designed and implemented software applications for metadata ingestion, streamlining the tabulation of final tables for IA and PES data. Validated outputs against established standards such as American Factfinder.
Stakeholder Collaboration: Worked closely with contracting and government stakeholders to refine technical requirements, incorporating their feedback into project development. Led the implementation of technical specifications for the Automated Census Survey (ACS) data setup.
Process Improvement and Optimization: Reengineered business and technical processes, utilizing configuration files to optimize data setup and integration. Focused on enhancing database architecture, component interfaces, and data sourcing workflows to eliminate redundancies and improve system performance.
Proactive Issue Resolution: Conducted proactive reviews during design and implementation phases, identifying and resolving inconsistencies in critical areas such as PES, IA DHC/Cross Tabulations, and flag handling. Used system logs and stakeholder feedback to ensure operational efficiency and user satisfaction.
Quality Assurance: Maintained stringent quality control standards across all project phases, adhering to Software Development Life Cycle (SDLC) best practices to ensure accuracy, consistency, and reliability in data analysis and reporting.
Systems Engineer/Developer – III
Harmonia Holdings Group
June 2017 – July 2018
Developed SAS scripts for the Census Bureau's PEARSIS project, focusing on Census Military Data with adherence to Title 13 and Title 26 data privacy standards.
Authored and debugged SAS programs for Non-Responsive Follow-Up (NRFU) operations.
Automated data pipelines with shell scripting, reducing processing time and increasing output accuracy.
Systems Engineer/Developer – III
Ankura Consulting LLC
June 2015 – April 2017
Delivered SAS programming solutions for financial institutions, generating accurate, on-demand litigation reports.
Streamlined complex data analysis tasks through SQL programming and custom SAS procedures.
Systems Engineer/Developer – II
Jay Consultants LLC
March 2011 – May 2015
Designed SAS programs for clinical data analysis, delivering high-quality reports tailored to research and stakeholder needs.
Applied advanced statistical techniques to analyze and interpret large datasets for actionable insights.
Education:
Bachelor’s Degree – Sikkim Manipal University, Mumbai, India
May 2008
Certifications and Training
AWS Partner Accreditation
SAS Certified Base Programmer
Python Programming Certification
GITLAB and JIRA Training
Cloud Computing and DevSecOps Practices
Technical Skills
Proficient in SAS, SQL, Python, and shell scripting for statistical and system development tasks.
Advanced data visualization skills using SAS Visual Analytics.
Experience with cloud platforms: AWS and Microsoft Azure.
Expertise in Agile methodologies for software development and project management.
Contact this candidate