SUMMARY

• I am a highly skilled IT professional trained in a multitude of computer languages, software packages and environments
• Database Teradata, SSIS, SSMS, Oracle 11i, Visual Studio, DB2, Supra, IMS DB
• Proficient in all Teradata utilities (Fastload, Multiload,Tpump, FastXport)
• Advanced SQL, table management, stored procedures, Macro and view skills.
• Managing Large Databases and working with large datasets.
• Ability to troubleshoot common to complex Database Issues.
• Advanced MS Office (Word, Excel, Outlook, Access) Skills
• Experience on UNIX environment in coding and maintaining scripts, UNIX commands and VI Editor.
• Working in IBM MVS mainframe environment using JCL, TSO, ISPF, IBM utilities, and Sync sort. Additional skills in FTP, FILEAID, LIBRARIAN, and SPUFI.
• Tableau, SAS, SAS Enterprise, CICS, Cobol II, and PL/I, Visual Basic,Advanced Alteryx skills
• Agile Development, SDLC (Software Development Life Cycle)
• Effective organizational, written, verbal and interpersonal communication skills with the ability to lead large scale projects and/or initiatives that are complex in nature and high - risk.
• Strong analytical and problem solving skills with attention to detail and accuracy while being able to multi-task, and prioritize assignments.
• Resourceful and quickly can adaptive to changes with a great desire to develop new skills to add immediate value to projects for which I am assigned.
• Ability to work within a team environment or stand-alone. Always open and willing to assist other team members in general development issues, knowledge transfer and tracking down roadblocks.

PROFESSIONAL EXPERIENCE

Confidential

Software Engineer

Responsibilities:

• Transitioned from a contract resource stepping into a full-time role within the Operational Health Reporting Team continuing to assist in reporting and analysis activities as it pertains to all middleware assets for patching, configuration and End of Life.

Confidential

Database Developer/Analyst

Responsibilities:

• Supported Confidential as a Database Analyst within the Operational Health Reporting Team. This team is responsible development and creation of reports pertaining to the health of all middleware assets within Confidential related to version and patching compliance, configuration and End of Life.
• Instrumental in the design and development in standing up a SQLServer Reporting Database for use compliance reporting.
• Report development utilizing Alterxy,SQL and SSIS
• Analysis activities in researching new data sources,trouble-shooting reporting and inquiry requests.
• Supporting SSIS/SSRS developers in managing Data Loads, processes, understanding data sources and managing roadblocks.

Confidential

Sr.Programmer/Analyst

Responsibilities:

• Support the Marketing Analyst at the Confidential Crown Center office assigned to the Confidential Cards account in addition to supporting Data Scientists and Managers within the Insights & Analytics Department at Confidential Cards
• Maintain and Support the Retail Estimate and Purchase Diary System.
• Alteryx processes for loading and cleaning Purchase Diary Data and loading to Teradata.
• Heavy Interaction with 3rd Party data provider to ensure accuracy of data provided for the Purchase Dairy.
• Maintaining SAS based processes, Teradata tables and views and responsible for all table management
• Processing Purchase Diary Survey data using Alteryx workflows and creating Tableau files to load into Tableau Server.
• Pulling data out of the Confidential System and executing Analytical Models
• Developing, maintaining Teradata tables & views, SAS, and Alteryx processes and creating simple Data-marts.
• Support the Marketing Analyst at Confidential assigned to the Beauty Brands Account in loading and report development of Beauty Brand Data from SqlServer tables residing on a Cloud Server using SSMS/SSIS. This also involved development of store procedures.
• Developing and processing reporting requests against the Consumer Marketing Database for Analysis and creating Pivot tables and Data Marts when necessary.

Confidential

Sr.Programmer/Analyst

Responsibilities:

• Supported the Marketing Analyst at Confidential that was assigned to the Confidential Cards Account.
• Pulling data out of the Confidential System Consumer Marketing Database and creating ad-hoc reports, pivot tables using Microsoft Excel, data marts and reusable data stored processes to aid in Marketing Analysis.
• Managing large and working with large data sets and database tables
• Developed standardize reusable processes for pulling and gathering various consumer level, demographic, purchase transaction history and other key consumer data and creating data files to be sent off for statistical modeling. In charge of running the developed model analytic SAS code and loading the results to a consumer modeling score table for Analysis.
• Re-engineered Confidential ’s Consumer Purchase Diary and Industry Estimate system to utilize Teradata. The current system was all SAS programs and files. The new process is now much more manageable,the data is more visible and available for analysis.
• Creating various Alteryx processes and workflows to read, cleanse and load various data files in varying formats to Teradata for Analysis.
• Lead initiatives with high-levels of risk and complexity to deliver what the client needed on-time and within budget.

Confidential

Sr.Programmer/Analyst

Responsibilities:

• Worked with a team of Teradata developers working on sustainment releases for Confidential system. The sustainment releases addressed fixing production issues, adding more functionality and process improvements.
• Assisted in the effort to redesign all the ETL code templates and processes to reclaim database space in addition to giving them the ability to restart based where the failures occurred, thus shortening the process down-time.
• Provided support in trouble-shooting common database issues.
• Required obtaining DOD Full Secrete Clearance and Passing of CompTia Security Exam.

Confidential

Sr.Programmer/Analyst

Responsibilities:

• Projects Contributions
• Teradata Relationship Manager Upgrade to release 6. Due to my extensive Confidential experience in the DatabaseMarketing Group, I assisted in the upfront Analysis on processes affected, and did a majority of the design, coding and testing to convert key processes and necessary table conversions.
• Retailer Customized Marketing initiative. This project provided Confidential Retailers a web based tool to market to their consumers. I performed all the backend Teradata database work such as writing all the necessary database queries for the online interfaces.
• Gold Crown Card Loyalty program. A redesign effort tasked with making Confidential program a tier based program. I was responsible for table design and ETL processes to populate new the Teradata Data marts.

Confidential

Sr.Programmer/Analyst

Responsibilities:

• I played a key role in the development, design and prototyping of the ETL SQL templates for processing and loading data to the data warehouse.
• Developed various Teradata stored procedures to: execute ETL procedure code, automatic build out of database views and a process for backing up/restoring military exercise/simulation data and databases.
• Required obtaining DOD Full Secrete Clearance

Confidential

Sr.Programmer/Analyst

Responsibilities:

• Provided support of both the Consumer Marketing & Corporate Consumer Database systems comprised of 69 million+ consumers. The consumer database is an enterprise repository storing information from multiple channels (POS, Internet, and Phone) and from multiple businesses (Gold Crown, Flowers, and dotcom) that is readily available to support campaign management, direct mail, consumer analysis, and research initiatives.
• Participated in large/medium project development roles, utilizing the following skill:
• Following formalized IT SDLC methodology.
• Performed impact analysis by researching existing and down-stream processes, database structures, and other cross-functional systems to assist in system design.
• Writing system specification, design, and unit/system test case documents.
• Working with external vendors.
• Coding, manual testing, and implementing designed solutions on time and within budget.
• Creating one-time conversion processes of legacy data.
• Provided warranty in supporting implemented solutions and in troubleshooting issues.
• Responsible for database tuning, table, and query design in support of customer relationship management (CRM).
• Assigned small business requests.
• Responsible for all phases from analysis, design, programming, implementation, manual testing, and warranty.
• Worked independently and directly with business users to understand the requirements to drive the analysis and design of quality technical solutions.
• Developed solutions that reduced manual intervention.