Senior Programmer Analyst Resume
SUMMARY:
An accomplished Senior SQL Developer with more than 20 years of experience in computer programming, coding, system design, and application development, with in - depth relational database knowledge . A resourceful and strategic planner who implements process improvements to increase efficiency and availability, mitigate security risks, and optimize system performance. Highly skilled at collaborating with stakeholders and cross-functional team members to translate business requirements into technical solutions in order to achieve short-term business goals and long-term organizational objectives.
AREAS OF EXPERTISE:
- Computer Programming
- Data Mining & Analysis
- Troubleshooting/Debugging
- System Migration
- Requirements Gathering
- Project Management
- Database Administration
- Risk Management
- Process Improvements
- SQL Performance and Tuning
- Database Design
- SDLC
- Effective Issue Resolution
- Strategic Planning
- Compliances
SKILLS:
Relational Database (RDBMS), Unix, DOS and Windows OS, MS Office, SSIS, SSRS, C, C++, C#, ASP.NET, Perl, T-SQL, PL/SQL, Visual Basic, Shell Scripting, Batch Scripting, TFS, SQL Server, Oracle, Crystal Reports.
PROFESSIONAL EXPERIENCE:
Confidential
Senior Programmer Analyst
Responsibilities:
- Developed solutions to improve medical payment processes of the membership database and accounting systems required to produce related financial, health care cost and membership revenue reports.
- Responsible for the quality control protocols related to the database system to ensure accurate processing and appropriate use of the data.
- Created capitation reports for providers and internal business users, analyzed data in relational databases based on financial analyst requests, and created ad hoc reports for financial analysis.
- Increased operational efficiencies by creating an SSIS package to automate monthly capitation processes.
- Resolved data integrity discrepancies between vendors and the membership database and supported senior financial analysts during production time for any data and programming issues.
- Improved member eligibility verification and payment processing by working with financial analysts to create SQL stored procedure.
Confidential
AVP, Consumer Product Strategy Analyst
Responsibilities:
- Increased availability and optimized performance by assisting with database/SQL server migration, end-to-end file mapping, and SQL script/stored procedure performance and tuning.
- Created dashboard report that evaluate 30+ metrics.
- Resolved data integrity discrepancies between various systems across multiple divisions within the bank to mitigate potential security risks and improve accuracy and reliability.
- Maximized team productivity by mentoring and coaching junior programmers with coding and process performance issues.
AVP, Business And Systems Analyst
Confidential
Responsibilities:
- Integral to the design, development, and implementations of complex systems and applications.
- Collaborated with business partners to define strategies for technical solutions, determine requirements, and develop functional designs based on defined business needs.
- Successfully delivered special projects, including a transition process between Countrywide Financial and Confidential, end-to-end field mapping, and reverse mortgage migration.
- Streamlined processes and increased efficiencies and reliability by providing technical system and software support for modifications, implementation, and conversion of business systems.
Senior Software Engineer
Confidential
Responsibilities:
- Automated business processes and created pivot reports used to make decisions by various departments, including trading, pooling, pricing, correspondent deficiency, and loan delivery.
- Developed scripts, stored procedures, and triggers, and created batch files to extract, transfer, and load data between servers.
- Optimized end-user support by interfacing with clients to define and create reporting business solutions and assist users in gathering and processing required data.