Lead Software ENgineer Resume

SUMMARY

Lead Software Engineer with 10+ years of experience with product development lifecycle of merchandising and asset protection applications using SSIS and RDBs: SQL Server, Teradata, Oracle, DB2, and MYSQL Determined to deliver mission - critical business solutions that reduce operating cost and lower down time.
10+ years of experience in SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions with Extract, Transform and Load (ETL) solutions from enterprise data warehouse (EDW) to Merchandising and Asset Protection applications.
10+ years of experience working with Microsoft SQL Server
10+ years of experience in creating Tables, Stored Procedures, Views, Indexes, User Defined Functions in SQL Server, Oracle, Teradata, DB2.
10+ years of experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle.
10+ years of experience managing offshore contractors for application enhancements.
6+ years of experience using SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
6+ years of experience in creating batch jobs, SQL Mail, Alerts and schedule SSIS Packages

TECHNICAL SKILLS

Databases: SQL Server, Teradata, MYSQL, Oracle, DB2

Database Tools: SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), SQL Server PowerShell, Toad, Oracle SQL Developer, MYSQL Browser, Teradata SQL Assistant

ETL Tools: SQL Server Integration Services (SSIS), DataStage

Languages: T-SQL, PL/SQL, C#, HTML, XML, VB, ASP.NET

Middleware: Tibco MFT, FTP

IDE & BI Tools: SQL Server BI Development Studio, MS Visual Studio 2017/2013/2010/2008

Reporting Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Methodologies: Agile, Lean Lab, Waterfall

Status Tracking Tools: Jira, Confluence

PROFESSIONAL EXPERIENCE

Lead Software ENgineer

Confidential

Responsibilities:

Created new SQL Server database with efficient structures for point of sale events used by the Macys enterprise
Created SQL Server Scripts to scan 7 servers with 36 databases with over 30,000 tables for Highly Sensitive Data and replaced Highly Sensitive Data with generic message for PCI compliance by using INFORMATION SCHEMA views, CLR, and RegEx.
Created new process with ThinkLP third party vendor to install a process to send and receive Civil cases using SSIS, SQL Server, SQL Stored Procedures and Tibco MFT.
Converted a 5-day lag Mainframe process to real time process for a Civil Recovery Payment application using SSIS, SQL Server, SQL Stored Procedures and Tibco MFT.
Managed 2 offshore developers for ISN conversion project for Asset Protection Application which interfaced with Zellman a third-party vendor.
Designed solutions using SSIS to extract data from SQL Server, DB2, Oracle, and Teradata that loads up to 800 million records into Teradata tables in under 6 hours for DCM Replenishment application.
Mentored co-workers in 5 other work groups with SSIS, SSRS, and T-SQL.
Converted ETL SSIS packages from SQL Server 2008 to SQL Server 2014 for 3 applications.
Performance tuned Oracle, DB2, SQL Server, MySQL and Teradata SQLs for ETL SSIS packages.
Created SSRS reports for Teradata Replenishment application.
Managed 6 offshore developers on creating SSIS packages for Teradata Replenishment application.
Worked closely with Size Profiling application team to interface new webserver and category and fabrication attributes to JDA Allocation.
Designed and developed input/output feeds from JDA Allocation to Purchasing and Size Profiling application using COBOL and Oracle stored procedures.
Performance tuned Oracle SQLs for JDA Allocation feeds.

Software ENgineer

Confidential

Responsibilities:

Researched 8 Merchandising Systems and identified top ten costing batch jobs, online transactions, and SQLs, unused reports, jobs, programs, and obsolete processes that could save over $250,000 in annual savings.
Designed and Developed the batch processing of Buying Application using DB2.
Designed and Modified the Replenishment Application using DB2, Oracle, MQ Series, CICS and Datacom for better Inventory Forecasting.
Supported Buying systems using mainframe batch COBOL with DB2, Oracle, Datacom databases.

System Analyst

Confidential

Responsibilities:

Designed and developed console application for Benefits Calculation System.
Maintained reporting application using VB and DB2 database.
Supported Pensions Payment System using mainframe batch COBOL and DB2 databases.
Converted and Tested Y2K changes for Pensions Payment System.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship