Statistical Sample Developer Resume Dallas, TX - Hire IT People

SUMMARY

Statistical Test Developer with Automation experience that specializes in Trifacta, SQL, Excel, JIRA, Python, Data Visualization (Tableau), Report Design, Auditing/Calculations, Advanced Analytic techniques, Algorithm Development for Automated Testing, Risk Analysis, Regression Modeling and Analysis.

TECHNICAL SKILLS

TSQL, DB2/Toad and Hive SQL experience
Experience in Financial Law Compliance
Trifacta Wrangler and Knight Certification
GBAM/GWIM Risk Mitigation
Automated Report Development
Experience with Big Data Environment
Excel, Python and SQL Programming
Auditing/Calculations for LRR/Compliance
BBA Finance
MS Advance Analytics

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Statistical Sample Developer

Responsibilities:

Collaborate between Test Owner, Test Owner Representatives, Front Line Unit, Test Developers and Data Owners or System point of contact to develop/tune SQL script and automated procedures using Trifacta for Data Gathering, Sample Generation and Testing Logic.
Migrate sampling and testing inventory to an automated environment using Trifacta, HDFS and JIRA.
Serve as a consultant to test designers and Test Owners to ensure appropriate data filters are applied based on business/product needs using MSSQL/DB2/Hadoop/Hive servers and Excel.

Confidential, Dallas, TX

SQL Developer

Responsibilities:

Uncover and resolve issues associated with finding data that can be used by compliance testers to monitor operational compliance.
Serve as a consultant to test designers to ensure appropriate data filters are applied based on business/product needs using MSSQL, and Oracle servers.
Gather and organize data in order to track report and monitor effectiveness of controls and tracking, monitoring and escalation of risk related issues to the management.

Confidential, Dallas, TX

Benefits Specialist

Responsibilities:

Audit performance and accounting reports for consistency with plan design and maintained internal databases and spreadsheets for 29 clients to ensure data integrity and accuracy with SSAE 16 Controls and the 409a tax code.
Using SQL, VLOOKUPs, SumIFs and IF statements, captured and analyzed data from multiple sources and assisted in development of financial reporting.
Documented and mapped reporting processes with the intent to standardize and pass the developed procedure to offsite associates.

Confidential, Dallas, TX

Data Analyst

Responsibilities:

Streamlined and created paperless processing tools using Visual Basic and migrated daily duties to offshore consultants increasing output/efficiency and reducing production costs.
1Using VB c reated and tested a QPSA Charge Logic tool to correctly input the QPSA charge into the database to run batch calculations.
This process allowed paperless tracking of disbursements and saved 70 minutes a day of wait time per analyst and also allowed for proper benefit commencement tracking for data extract to the trust.
2Using VB c reated a paperless reporting system to process and track deceased annuitants.
This process allowed for proper tracking of overpayments to deceased annuitants and also prevented any further overpayments.
3Proposed and initiated a process to query all reported deceased annuitants and ensure that their annuity payments ceased in a batch update to the database.
This semi - monthly procedure prevented an average of and additional $30,000 per month from being paid to deceased participants.

Confidential, Dallas, TX

Benefits Analyst

Responsibilities:

Generated performance and accounting reports for consistency with plan design and maintained the Access database and spreadsheets for 120 accounts to ensure data integrity and accuracy.
In the 2011 reporting season, increased department efficiency by effectively managing client book by exceeding reporting deadline by 2 months.
Maintained productive client relations through the migration of 150 clients from service by facilitating seamless shift to new service providers.

Confidential, Lewisville, TX

Investment Consultant

Responsibilities:

Increased return and reduced risk of client’s accounts by identifying portfolio risks and discussing options to meet short term and long term cash flow needs.
Effectively collaborated with back-office resources to solve client issues and enhance customer experience.
Personally contact clients with resolution.
Trained and mentored new-brokers, as well as, seasoned brokers in portfolio management and sales techniques to increase client relationship effectiveness.
Consistently ranked in top 3 of 900 consultants in new sales for the years 2009 and 2010.

We provide IT Staff Augmentation Services!

Statistical Sample Developer Resume

Dallas, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship