Arequipa, Perú +51 965666732 andre.ramos.provincia@gmail.com

GRUPO T.X

Grupo T.X

My Role: Data Analyst

A leading Latin American company specializing in creating innovative solutions for both public and private institutions. We specialize in developing customized solutions, aligning our objectives with those of our clients to enhance the governance, institutional integrity, and transparency of both public and private organizations.

TECHNOLOGY
GOVERNMENT CONSULTING
PUBLIC-PRIVATE PARTNERSHIPS (PPP) CONSULTING
Web page

www.grupotx.com

Functions


Proficient in crafting robust reports leveraging SQL Server technologies including SSRS, SSIS, and SSMS.
Optimized the performance of queries significantly reducing their execution times, all this prior to deep analytics.
Utilization of AWS services for seamless data migrations, incorporating DMS, Step Functions, Lambda, S3, Athena, EMR, and Python.
Analysis and Prediction: Leveraged Python and SQL for exploratory analysis and building predictive models, utilizing libraries such as NumPy, Pandas, Seaborn, and others. Applied these tools to infer behaviors within Tax Management and contribution systems, including projects focused on risk analysis.
Utilized Visual Studio Code and Amazon SageMaker as coding environments for analysis and prediction tasks
Developed intricate SQL queries and Python scripts to compute metrics, facilitating the design of interactive dashboards using Power BI or Amazon QuickSight.
Utilized SVN (Tortoise) as a version control system.
Utilized Jira as a comprehensive work management tool
FUNCTIONS

Cloud - AWS

Acces Portal

To securely access AWS resources

Athena

Athena for querying and analyzing data

EMR

EMR on AWS for managing jobs or processes in large volumes of data

Workspace - SQLServer

Workspace

AWS
TO ACCESS MY WORKSPACE IN AWS

SSMS

SQLServer
  • For query and process creation
  • Enhancement of query performance
  • Delivery of stored procedures for use by the development team
  • Processes responsible for data migrations

    • SSRS

    SQLServer
  • Service for creating reports for various projects
  • Reporting also integrated with the AWS environment, using the Sabana tool.

    • André Ramos
    Provincia

    "Passionate about unraveling hidden stories in data and transforming them into pragmatic solutions that drive strategic decision-making and business growth."

    Get In Touch

    Arequipa, Perú

    andre.ramos.provincia@gmail.com

    +51 965 666 732

    Quick Links

    Home CV/About Projects Certificates Contact

    Repositories Links

    Github Kaggle

    © andreramosprovincia.site. All Rights Reserved. Designed by Droidex