We provide IT Staff Augmentation Services!

Sr. Database Programmer Resume

0/5 (Submit Your Rating)

NY

Hire Now

SUMMARY

  • Confidential Sr. Database Programmer with over 10 - year experience in the Financial Services and Software Delivery industries with specialization in the MS SQL Server programming, ETL and reporting layers.
  • Proven expertise in quickly analyzing requirements, designing solutions, leading development and supporting QA and UAT in the Agile/SCRUM and Waterfall SDLC.
  • Financial Services Industry, Commercial Loans and Credit, Credit Risk Management
  • Customer Relationship Management Systems (CRM), Sales Cycle
  • Business Intelligence, Executive Dashboards

TECHNICAL SKILLS

Database Tools: SAS, MS SQL Server (SSAS, SSRS, SSIS/DTS), Oracle, PL/SQL, TOAD, SQL Plus, SQL Navigator, MS Access, T-SQL, Hadoop

Programming: VB.NET, VBA, C#, VB6, LINQ, MDX (ADOMD), ASP.NET, WIN32, P/Invoke, DevExpress Controls, Component One

Reporting Tools: DMX, DAX, Crystal Reports, Active Reports, SSRS, Excel

Data Transfer Tools: UNIX Shell Scripting, EDI, XML

Other tools: Attachmate "Extra ", Imaging Pro, ImageWare EPI Builder, WiX Toolset, PDFBox/IKVM, SharpZipLib, WinFax PRO

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Database Programmer

Responsibilities:

  • Led a team of 3 SQL Server developers on the Early Credit Warning System project to migrate reporting platform from BlueLight to Tableau
  • Worked closely with PM and BA to review complex business requirements
  • Researched and evaluated alternative solutions and made recommendations
  • Designed Future State in close collaboration with a software development team
  • Provided high-level effort and duration estimates for the SQL Server team
  • Reported status of technical tasks to PM and the project Steering Committee
  • Chaired regular team meetings to assess results and set clear development goals
  • Analyzed and documented SAS/Kshell ETL services from Teradata to Hadoop
  • Developed Transact-SQL scripts and stored procedures according to specifications
  • Programmed and deployed SSIS packages, Excel and Tableau reports
  • Modified SAS/Kshell scripts to move data from Teradata to Hadoop
  • Performed Unit Testing of Stored Procedures, SQL and ETL scripts
  • Supported QA phase and fixed bugs from the SQL Server and ETL perspectives
  • Executed Parallel Testing between old and new reports to identify and fix breaks
  • Supported QA Automation team by developing custom programs for QAs
  • Designed front-end in VBA, VB.NET and C# WinForms to organize QA execution
  • Developed QA Automation VBA programs to test data quality and completeness

Confidential, New York, NY

Database Programmer

Responsibilities:

  • As a Database Programmer developed MS Access and VB6 application to manage black limo service including: scheduling, car and driver availability and CRM
  • Developed data-entry forms, relational database and dynamic reports
  • As a Database Programmer developed Sales Analysis System that included sales prediction models to manage new and existing products
  • Constructed 3D data cubes using MDX and ADOMD to obtain metadata (dimensions, hierarchies, levels, members, measures) from multiple sources.
  • Utilized common object-oriented architecture built on MS ADO.NET to integrate data sources like SSAS, MS Access files, and Oracle or MS SQL databases.
  • Created SSAS cubes. Persisted data in XML format using LINQ to XML conversion. Used LINQ to work with collections.

Confidential, New York, NY

Database Programmer

Responsibilities:

  • Capital Markets / Syndicated Loans Origination, Tracking, Transactions
  • Developed Transact-SQL scripts and stored procedures
  • Provided database optimization, archiving, table partitioning and index strategy

Confidential, New York, NY

Database Programmer

Responsibilities:

  • Modelled, developed and tested Employee Biometrics Security Database

Confidential, New York, NY

Database Programmer

Responsibilities:

  • Lead developer on the AMA system designed to manage client accounts, trade history, portfolio KPIs, Broker/Trader and sales representatives information
  • Automated nightly batches monitoring, developed VB6 and MS SQL SP
  • Implemented intelligent EDI files importing system
  • Recursively searched for folders and EDI files, repaired corrupted ones using kernel32 APIs (memory mapped files), parsed the files and stored the content in the database

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship