We provide IT Staff Augmentation Services!

Software Engineer / Sql Programmer Resume

2.00/5 (Submit Your Rating)

Huntington, BeacH

SUMMARY

  • 17+ years of maintenance and development experience on Database Design and Development in SQL server 2005/2000/2008/2012/2016/2017 system in OLTP and OLAP environment.
  • 17+ years of professional software development and 4+ years of web development.
  • 8+ years’ experience developing server services.
  • 7+ years working wif web services.
  • 10+years of experience in SSIS of MS SQL Server.
  • Excellent command on SQL SERVER 2008/2012/2016/2017.
  • Data modeling using MS Visio.
  • Export in designing data warehouse (star schema)
  • Expert in designing and implementing relational database model as per business needs.
  • In - depth noledge of Transact-SQL.
  • Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
  • 17+ years’ experience in T-SQL programming.
  • Excellent command of writing ad-hoc queries.
  • Experience implementing ETL Packages using SSIS 2005/ 2008/2012/2016/2017.
  • Experience in Importing/Exporting Data from various data sources like Excel and Flat file using DTS utility.
  • Extensive experience in database tuning, server logins and database permissions.
  • Expert in calculating mathematical formulas, and user-defined functions.
  • Experience in XML scripts.
  • Experience working wif XML documents.
  • Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team.
  • Extensive experience in .NET coding.
  • Assisting customer in defining detailed specifications for specific functionality requirements as well as analyzing, designing, and encoding new systems using C# language
  • Support in converting POS system code from VB.NET to C#
  • Worked on visual source safe/TFS for version controls and communication’s well as defining Actions, translations and perspectives.
  • Expert skills wif computer science concepts and programming.
  • Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.
  • Worked on analyzing Hadoop cluster and different big data analytic tools including Pig, Hive, Spark, Scala and Sqoop.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2017/2016/2012/2008/2005/2000

Programming Languages: T-SQL, PL/SQL, ASP.NET, VB6 .NET, JavaScript, HTML, CSS, C#

Software/Databases: MS SQL Server / /, MS SQL Server Reporting Services 2017/2016/2012/2008/2005/2000 (SSRS), MS SQL Server Analysis Services 2005(SSAS), MS SQL Server Integration Services 2005 (SSIS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services

Currently Learning Skills: Core .Net, Python, Swift, Ruby, Azure, Amazon Web Services, Google Cloud, Angular 10

PROFESSIONAL EXPERIENCE

Confidential, Huntington Beach

Software Engineer / SQL Programmer

Responsibilities:

  • Partner wif peer technologists to share learnings and provide hands-on assistance
  • Sharing noledge of tools and techniques wif teh wider team, both developers and non-developers
  • Provide progress reports to management and other effected stakeholders
  • Coding, Compiling, Unit testing, integration, packaging and deployment of developed software
  • Collaborate to form firm view of quality metrics and expectations for teh delivery, and work wif these throughout teh sprint
  • Work on POCs and cutting-edge features before they’re integrated into teh product
  • Lead code development in each story
  • Developed and maintained Web APIs
  • Developed and maintained internal web pages using Angular 10 / Bootstrap / Web API / SQL Server / TypeScript
  • Started teh process of transferring database onto both Azure and AWS platform
  • Started teh processing of converting current applications to microservices
  • Improved efficiency of stored procedures. Some stored procedures up to 95%.
  • Developed and enhanced a wide range of point of sale applications for Windows based terminals. These applications managed sales, employees, forecasting, reporting, and updated databases.
  • Analyzed business needs, wrote functional specifications, wrote and executed unit test plans.
  • Design a database structure (Tables, Queries, and Reports) to organize and house their data to provide teh most efficient and flexible data source for their present and projected needs.
  • Maintained SQL Server database objects involved in posting transactions precipitated by end users of teh applications and reports requested by teh end users. These database objects include stored procedures, triggers, views, and data warehouses
  • Designed and implemented front - end reports that are presented to users worldwide
  • Automated reports to allow users to schedule reports to be run after hours and write teh results to a specific file.
  • Monitored SQL objects running in production to identify performance problems.
  • Develop and Maintain current business applications using .NET, SQL
  • Supervising junior programmers during teh software development life-cycle for different projects, and ensuring their completion in time and wifin budget
  • Working wif teh team to identify and debug issues in existing software, and writing appropriate code to upgrade programs as per teh client's need
  • Assisting junior developers to solve issues related to database connectivity, and establishing proper connection between teh back-end and front-end to ensure proper functioning of teh website or software
  • Support in converting POS system code from VB.NET to C#
  • Providing support to IT personnel in designing, developing, analyzing, testing, debugging, and executing C#, VB.Net programs for windows desktop and web-based applications
  • Assisting project manager in defining detailed specifications for specific functionality requirements as well as analyzing, designing, and encoding new systems using C#, VB.Net language
  • Preparing accurate reports to document design flaws and bugs as well as modifying existing software or system to correct errors and improve performance
  • Collaborating wif other programmers and developers in teh whole development process, and using structured analysis and design to determine steps to develop programs
  • Worked on analyzing Hadoop cluster and different big data analytic tools including Pig, Hive, Spark, Scala and Sqoop.

Confidential

Application Developer / SQL Programmer / Data Analysts

Responsibilities:

  • Design and create over 25 Applications / Services ranging from automated reporting, device monitoring, ATM and Fuel tracking systems in VB.Net, ASP.Net.
  • Design and create FTP program VB.Net, costs reduced, and eliminating vendor’s FTP software.
  • Design and create Fuel Tracking system using ASP.NET, html, and JavaScript
  • Design and create ATM Tracking system using ASP.NET, html, and JavaScript
  • Helped designed and created Payroll application using wifin company using VB.NET.
  • Design and create Hardware monitoring application using ASP.NET, html, JavaScript.
  • Design a database structure (Tables, Queries, and Reports) to organize and house their data to provide teh most efficient and flexible data source for their present and projected needs.
  • Populate teh tables, create queries, reports, and macros.
  • Using Access wif SQL Server, establish connectivity for teh database to download Internet report data.
  • Generate reports using IT / database systems and assist in their analysis.
  • Collect and collate appropriate data for use in databases and conduct related research.
  • In marketing support roles, prepare and make presentations.
  • Assist in development and upgrading of database systems and analytical techniques.
  • Ability to work as part of a team and on own initiative.
  • Monitor and maintain teh quality of database systems and secure access and use.

Confidential

Application Developer / SQL Programmer / Data Analysts

Responsibilities:

  • Design and create program in VB.Net to automatically post Consumer’s Inquiries onto credit report. Time reduced from 20 minutes per job to 45 seconds.
  • Design and create FTP program VB.Net, costs reduced, and eliminating vendor’s FTP software.
  • Design and create over 200 programs ranging from instant report tools, to automating time consuming tasks, enabling employees to focus on other items using several programming languages, 50 were built wif Visual Basic 6 and 100 in Visual Basic.Net.
  • Designed and created Consumer Statement program in VB.NET. Program consists of over 50 forms, and 30 tables. Program saved company 280K a year by transferring employees to other needed departments.
  • Designed and created Client Services Automation program in VB.net. Program consists of 12 services that run 24/7. Replaced Legacy job creation and tracking. Program automated teh work of 12 Analysts, saving teh company over 900K on yearly salaries.
  • Designed and created Inventory program using VB.Net. Program is used by 12 different departments throughout Confidential . Application allows company to track every step of project throughout teh company.
  • Instruct Incoming Programmers in using “Best Practice” methods.
  • Designed and created Department Web site using ASP, HTML, and Java Script.
  • Analyze users’ current system needs based upon their manual A/P process. Discuss end-users’ requirements and create a suggested enhancement and development plan. Discuss potential time to completion and costs.
  • Using diagrams, flowcharts, and a descriptive outline report, present a suggested system design and set of procedures for implementation to senior department members.
  • Regularly meet wif department members and seniors to track progress, identify issues, make enhancements where necessary.
  • Manage workflow wif department members; address new business and system requirements wif senior staff. Integrate approved changes.
  • Responsible for department reporting, over 200 different reports has been automated.
  • Design a database structure (Tables, Queries, and Reports) to organize and house their data to provide teh most efficient and flexible data source for their present and projected needs.
  • Populate teh tables, create queries, reports, and macros.
  • Using Access wif SQL Server, establish connectivity for teh database to download Internet report data.
  • Generate reports using IT / database systems and assist in their analysis.
  • Collect and collate appropriate data for use in databases and conduct related research.
  • In marketing support roles, prepare and make presentations.
  • Assist in development and upgrading of database systems and analytical techniques.
  • Ability to work as part of a team and on own initiative.
  • Monitor and maintain teh quality of database systems and secure access and use.
  • Ability to work to deadlines.
  • Discuss information or business intelligence needs wif internal staff and/or external clients.
  • Design teh database to be migratable to SQL Server.
  • SQL instructor for all new incoming Project Analysts
  • Support and enhance database as needed. Troubleshoot errors.

Confidential

System Analyst / Programmer

Responsibilities:

  • Developed and enhanced a wide range of point of sale applications for Windows based terminals. (Huntington Beach)
  • Entirely hosted and self-updating Inventory solution
  • Deep integration wif Aloha and Aloha family of products
  • Automated sales forecasting to drive product ordering and prep and production
  • Place purchase orders and receive invoices electronically
  • Perform inventory transfers across sites
  • Over 300 standard reports, which can provide consolidated views across multiple sites including P&L reports, food cost analysis, store sales and more
  • Manage teh employee life cycle - hire, promote, borrow, transfer and terminate
  • Perform employee borrows and transfers across sites
  • Create new schedules based on teh restaurant’s forecast
  • Tightly integrated wif Aloha POS - feeds employees and shift edits to Aloha in real-time and enforces scheduled in and out times on Aloha
  • Employee can view and print their schedules directly from teh POS terminal
  • Email and text employee schedules and schedule changes
  • Inventory program for Confidential using Visual Basic 6.0, C++, and MS SQL. (Anaheim, CA.)
  • Program consisted of over 40 forms
  • Program was able to FTP information to and from Mainframe
  • Program was able to alert personal on low merchandise, via email, text, and phone.
  • Program was able to create invoice
  • Program was able to create all needed reports
  • Consumer Statement program for Confidential (Costa Mesa, CA.)
  • Program saved company 280K a year by transferring employees to other needed departments.
  • Automated teh submission and execution of JCL to teh Mainframe
  • Send Consumer Statement to Customer once job completed
  • Confidential Project Scheduler (Costa Mesa, CA.)
  • Program distributed work among over 150 different Analysts around teh world based on their current load and skill
  • Gave Management reporting tools to track monthly and yearly stats.
  • Management is able view information in calendar mode.
  • Daily Department Report Service created in VB.NET for Confidential (Costa Mesa, CA.)
  • Service launches 74 different managerial reports, in Excel, throughout teh company on a daily basis.
  • Paypal Payments program in .NET for Party Blossom (Garden Grove, CA.)
  • A paypal invoicing database system was created.
  • Teh customer is emailed a secure link using which teh user can pay for an item using phpmailer.
  • Seamless integration was done using paypal pro direct payment method and express checkout, so that teh customer does not leave website.
  • Annual Business planner in .NET for Confidential (Costa Mesa, CA.)
  • It incorporated custom controls to provide a uniform look and feel across multiple data views.
  • Teh application integrated wif teh existing SAP system using in teh company.
  • Application was developed on a tight schedule to be deployed prior to teh start of teh current planning cycle.
  • Automated Project application in .NET for Confidential (Costa Mesa, CA.)
  • Application consists of 10 different services that run simultaneously. Each service is responsible for one aspect of teh job.
  • Saved teh company 1.05M in headcount.
  • Program is fully automated wif minimal of no human intervention.
  • Program was able to FTP information to and from Mainframe
  • Automated teh submission and execution of JCL to teh Mainframe
  • Sends Company final mailout list.
  • Hardware Monitoring application and service in ASP.NET and VB.Net for Confidential (Gardena)
  • Service scans over 2000 devices in check on their status.
  • Program gives users a visual interpretation of teh service findings in a variation of ways.
  • Service sends email to Management on a bi-hourly basis on finding.
  • Fuel Tracking application and services in ASP.net and VB.net for Confidential (Gardena)
  • Program tracks current station fuels quantities
  • Using Google maps, trucks locations is displayed on screen
  • Intelligent order assigning is built into application
  • Biometric log in built into application
  • Reporting feature built in using Telerik Reporting
  • ATM Tracking application and services in ASP.net and VB.net for Confidential (Gardena)
  • Program tracks ATM amounts in all stations
  • Generate open code via email to all supervisor using biometric software
  • Reporting feature built in using Telerik Reporting

We'd love your feedback!