TECHNICAL SKILLS:

Software: SSMS, SSIS, SSAS, SSRS, MICROSOFT SQL SERVER DATA TOOLS/BUSINESS INTELLEGENCE DATA STUDIO(BIDS), MICROSOFT OFFICE (2016), POWER PIVOT (2016), POWER BI (2013), REPORT BUILDER 3.0, TEAM FOUNDATION SERVER (2013), IDASHBOARDING, MASTER DATA SERVISES.

MQ SERIES, DB2, DYNAMICS SQL, QMF, BMC/PLATINUM, SDF II/BMS, OS/MVS, CICS COMMAND LEVEL, CEDF, INTERTEST, DATAEXPERT, IMS/DB, VSAM, EXPEDITOR, TSO/ISPF, PANVALET, LIBRARIAN, ENDEVOR, CHANGEMAN, OS/JCL, EASYTRIEVE, FILE - AID

Databases: SQL Server 2012, 2014; T-SQL; MYSQL; DB2/SQL; UDB; MS ACCESS; ORACLE 11G, TERADATA

Languages: DAX/MDX, COBOL, COBOL II

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

• ETL professional who created ETL solutions and data transformations for 750 beds hospital.
• Created code for database modification, construct and access using stored procedures, triggers and functions. Developed ccomplex queries using SQL Server, T-SQL.
• Designed and developed ETL/SSIS programs to extract data from transactional database systems and load to the Data Warehouse using SSIS (SQL Server Integration System).
• Troubleshoot and analyze ETL process failures, data anomalies and other ETL or data warehouse issues identified by automated monitoring, other developers and end users
• Developed AD-HOC reports for clients using SSRS (SQL server reporting services)
• Worked with customers to define and document the scope and functional requirements for data and reporting needs
• Designed and developed POWER BI DASHBOARDS, reports for senior executives.
• Provide training for clients in the BI and data warehousing space.
• RAS (Report Automation System) Administrator. Responsibilities included: system maintenance, user’s accounts creation/maintenance, report capture, data extraction, e-mail notification, custom splitting (into different departments)
• Created Monarch data models to extract appropriate data from RAS reports and load data using ETL/SSIS into Data Warehouse.
• Created data dictionary using MDS (Master Data Services).
• Created OLAP cubes using SSAS (SQL server analytical services).

Confidential

BI Developer

• Designed and developed ETL processes using SSIS and T-SQL for downstream data feeds into Data Warehouse.
• Design, develop and implement a Benefit Statistics Data mart and Dashboards, integrated with SharePoint, using SSIS and T-SQL.
• Designed, developed, and implemented various Benefits, Sales reports using SSRS.
• Created OLAP Cubes using SSAS.
• Created T-SQL queries, Cursors, Store Procedures and Functions.
• Created Indexes, views and triggers.
• Performed tuning on the T-SQL queries and indexes.

Confidential, NY

Database Developer

• Created triggers, indexes, views and functions using SQL SERVER 2008/2012 R2 databases.
• Performance optimization to the T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Created T - SQL queries, Store Procedures for the purpose of insert/modify/delete SQL server DB.

Confidential

Consultant/Senior Programmer/Analyst

• HIPAA Project: Using SMART TS performed module inventory of all programs impacted by various requirements. Analyzed all programs impacted and identified
• Prepared Technical Specifications Document (TSD) related to the HIPAA project. Supported the software changes required. Analysis of DB2 tables, copybooks, control cards, and Teradata were performed to complete the analysis needed for TSD creation.
• Supported an offshore team by resolving issues and providing solutions to enhance processes and procedures.
• Responsible for setting up the development environment, including identification of job scheduling (CA7).
• Enhanced the Integration Tape Processing System (ITP) in support of on-boarding additional clients. Developed code, created test data using DB2/SPUFI to extract required data from various DB2 tables, performed unit and integration testing using COBOL II/ JCL / VSAM / DB2 / SQL / CICS / MQ SERIES.
• Creating dynamic SQL in mainframe to be executed in SQL Server environment. In-depth knowledge of Transact- SQL. Expert in creating indexes, complex store procedures, Triggers to facilitate efficient data communication and data consistency.

Confidential, Wane, NJ

Consultant/Senior Programmer/Analyst

• Designed, coded and implemented Voluntary Corporate Action System (offer was mailed to shareholders)
• Software utilized: SQL Server 2008 R2, Created T- SQL queries, Store Procedures, functions
• Coded and implemented batch programs to process data extracted from SunGard’s Invest ONE platform
• Utilized SunGard’s proprietary FOMI tool to extract Account and Position data for processing
• Generated custom reports for viewing and download by Citi’s clients from its website
• Prepared testing files using DB2/SPUFI from various DB2 tables for testing purposes

Confidential, Tampa, FL

Consultant/Senior Programmer/Analyst

• Developed multiple background and foreground Cobol/CICS/DB2/SQL transactions to create queries and logged in errors; Created input data (JCL to NDM) to Tandem Operating System
• Used Get main command with a hold option in CICS to hold accounts for faster access in main storage
• Wrote JCL to backup DB2/SQL tables and execute queries

Confidential, Franklin Lakes, NJ

Consultant/Senior Programmer/Analyst

• Converted mainframe screens from BMS to Html/JavaScript. Was involved in coding of JavaScript functions, tables, CSS, Events, Buttons, Input validation
• Designed and coded a Recovery process for Customer Service Common Functions Doctor/Patient application to save records into Siebel data base; MQ/CICS/DB2 program to listen for persistent messages and save them to DB2 real-time

Confidential, Paramus, NJ

Consultant/Senior Programmer/Analyst

• Performed the design, coding, and implementation of the Damage/Hazmat Input system to produce various forms for the client to fill out, as well Search and Update functionality; Performance tuning of VSAM files
• Utilized CICS, DB2, and MQ to create a Validation Routine (CICS), Processes (CICS), Engines (CICS/DB2), File Service (CICS), Managers (CICS/MQ) and Submit Service (CICS/MQ)
• Enhanced a Recovery process for Customer Service Common Functions system (CICS, DB2, and MQ) to handle situations when Damages, Damage Call Tags and Delivery Change Requests are entered on a HTML/JavaScript screen and cannot be processed

Confidential, Jersey City, NJ

Consultant/Senior Programmer/Analyst

• Participated in design coding and documentation of Securities Trading System that accepts trades via MQ Series. After validation, the system selected curtain trades to produce confirmations via CICS DB2
• Developed DB2/batch & CICS I/O modules so each batch or online program can dynamically link to extract and update Db2 Information. Improved communication with large institutional clients by developing a Trading System to handle transmissions to various financial institutions.
• Performance tuning of VSAM files also DB2/SQL statements.

Confidential, Stamford, CT

Employee/Senior Programmer/Analyst

• Participated in design coding and documentation of Foreign Exchange Trading System that accepts trades via MQ Series. Other functions include validation, new trades, cancellation and re-booking via DB2/IMS
• Designed, coded, documented and implemented programs in COBOL II, COBOL III, CICS, Command Level and DB2/SQL that recorded customer and trade activity. Implemented on-line program that insured all trades were processed in a timely manner
• Tuned SQL in SIX DB2 payment batch modules.; Used Explain Plan and Expeditor facility to test SQL and identified problems; Curtailed cursor SQL to read specific records and created indexes on key fields. Reduced company expenses in MIPS (CPU time)

Confidential, New York, NY

Consultant/Senior Programmer/Analyst

• Participated in design, coding of a 3 tier Cigarettes Ordering System. System facilitated customer orders process as well as providing notification on inventory levels.
• Developed server-side procedures to facilitate data collection and presentation (ASP).
• Developed a client-side algorithm providing the necessary validation and interactive function.
• Database planning and implementation according to business requirements and development of stored procedures using PL/SQL

Confidential, New York, NY

Consultant/Programmer/Analyst

• Performed requirement analysis, program design, coding and implementation of an on-line Equity Account Opening System, utilizing COBOL, CICS and DB2/SQL under OS/MVS on an IBM 3090
• Designed and coded CICS screens for updates and on-line inquiry; Input to an Equity Account System with WEB front-end and mainframe back-end, using ASP, ADO, VBSCRIPT, JAVASCRIPT, HTML, DHTML
• Participated in design, enhancements, documentation, implementation of various systems to insure Y2K compliance; converted OASIS system from DB2/SQL mainframe platform to ORACLE/NT platform.