We provide IT Staff Augmentation Services!

Principal Software Engineer/architect Resume

4.00/5 (Submit Your Rating)

San Mateo, CA

Hire Now

SUMMARY

  • Member of Core Database Architecture Team in charge of design and implementation in our database platforms.
  • Lead business and development team to build a data pool platform for Finance Department. This project involved designing a data collection process and creating a reporting scheduler to generate over 100 reports used for daily financial reconciliation.
  • Redesigned and tuned our Card and Payment processes to improve performance up to three times faster.
  • Implemented a Data Warehouse cloud solution in AWS Redshift for marketing department.
  • Redesigned our core database platform for PCI compliance.
  • Worked in highly agile environment closely with business, product owners and QA for successful completion of projects.
  • Lead our team to design and implement Email and Text message utilities.
  • Implemented scalable NoSQL database with document - oriented storage in MongoDB and DynamoDB.
  • Cloud enthusiast with deep curiosity in Machine Learning and Data Science.

TECHNICAL SKILLS

Proficient in: PL/SQL (Developer/ DBA tasks), SQL, MS Trans SQL, C, C#, Python.

Experience with: Java, Perl, PHP, HTML, RStudio, ASP.Net, Jupyter Notebook, Matplotlib, Numpy, Pandas, MongoDBNoSQL, AWS including S3, RDS, Athena, Glue, QuickSight, Power BI, Kinesis, RDS and Redshift.

Operating Systems: UNIX, Linux, Windows

Database: Oracle 12c, 11g, 10g, SQL Server, MySQL, PostgreSQL, MongoDB, DynamoDB.

Software: Crystal Reports, Informatica, Tableau Public. Oracle Enterprise Manager, SQL Server Enterprise Manager, SQL Developer and TOAD.

PROFESSIONAL EXPERIENCE

Principal Software Engineer/Architect

Confidential, San Mateo, CA

Responsibilities:

  • Engineered an end-to-end database functionalities and infrastructure design for products including HSA, HRA, FSA and Wellness Program.
  • Designed and implemented an end-to-end cloud base architecture in AWS by utilizing services in Kinesis Firehose, S3, RDS, Glue, Athena, Redshift and QuickSight.
  • Optimized legacy application search queries in SQL and PL/SQL and improved performance by 50%.
  • Built a marketing focused Data Warehouse framework in AWS Services S3, Athena and Redshift.
  • Engineered data importing and exporting applications and tuning, stream ling ETL tools in Glue, SQL Loader, Perl and Informatica.
  • Led the design and implementation of Data Financial Pool for daily settlement reconciliation.
  • Architected a customizable Card Process for General Electric.
  • Built database level backend processes for email and text message delivery systems for SendGrid and Twilio.
  • Configured Veracode source code security analyzer and modified security flaws in .Net application.
  • Implemented and modified middle-tier code in C# for new enhancement and logical requirements.
  • Worked with Marketing Department and created analytical tools in Python for their sales campaigns utilizing libraries in Numpy, Pandas and Matplotlib.
  • Development of test framework using Python scripts to automate unit testing to update database contents and file modifications.
  • Cofounded an architecture team to redesign our platform to convert our existing Monolithic platform to a Microservice oriented cloud base solution.
  • Guiding new team members and provide the technical oversight and leadership necessary to accomplish the work which includes development, domain knowledge and following coding standard.

Senior Data Engineer

Confidential, Sacramento, CA

Responsibilities:

  • Implemented multiple RDBMS platforms in Oracle and SQL Server for asset management systems.
  • Developed migration procedures using PL/SQL or Transact-SQL.
  • Implemented database objects such as Stored Procedures, Indexes, Triggers, Functions and Packages in Oracle and SQL Server environments.
  • Designed and implemented a new database, and ETL migration process, to enhance customer service experience for Johannesburg Water Department in South Africa.
  • Developed project plans and timelines when requested to meet critical deliver dates.
  • Performed DBA tasks involving installation, configuration, tuning Oracle and SQL Server databases.
  • Tuning and Optimizing SQL Queries and Stored Procedures.
  • Developed Crystal Report Applications.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship