SUMMARY

• Over 10 years of experience working as an Information Technology Professional with the past 7 years focused on ETL/SQL/BI Development.
• Areas of expertise include: MS SQL Server and Oracle databases, ETL tools, Informatica, Oracle SQL*Loader, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio, Cognos, and Business Objects.

TECHNICAL SKILLS

Oracle Database: (PL*SQL, SQL*PLUS), MS SQL 2005, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Reports: SQL Server Reporting Services (SSRS), COGNOS, Business Object

ETL: Informatics 9.0, SQL Server 2005 - SSIS, Oracle - SQL*Loader

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential, Tx

SQL Developer

Responsibilities:

• Creating and managing ETL processes from EPIC from CLARITY
• Consolidated the SSIS process and tuned the Extract packages, also performance tuning on Stored procedures
• Back up and restored the database and validating the metadata after restored the database.
• Migrated SSIS packages from and
• Installed Reporting service on DEV environment
• Involved in upgrading Epic version from, currently involving in upgrading Epic 2015
• Created and maintained documents, Mentoring extract process to users

Confidential, Plano, TX

BI Analyst/SQL Developer

Responsibilities:

• Created Job process dashboard and SSRS Report Inventory Dashboard reports using Visual Studio 2010
• Created Job process and SSRS execution log history tables using MS SQL Server 2012
• Set up Subscription to deliver report to distribution list/External and Internal business unit
• Consolidated process to make code more cleaner and efficient
• Performance tuning on Stored procedures and on few SSIS packages
• Created documents for Stored procedures, consolidated process, SSRS Report Inventory, and SQL Agent Job process

Confidential - Addison, TX

ETL/SQL Developer

Responsibilities:

• Migrated data from different sources such as iSeries library file(AS/400), SQL Server tables, Excel and flat file;
• Created Dynamic ETL process to load data from excel file (up to 100 columns) into table to enhance processing time from 45 minutes to 2 minutes. On average received 45-50 files per month.
• Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Loaded Data from SOR(Source of Record) to ODS (Operational Data Store) using AutoETL using SQL Server 2008
• Created stored procedure to identify missing or changing Metadata between Staging Database and Data Dictionary table
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Part of JAD session and worked with System Analyst to deign HLD (High Level Diagram) documents

Confidential, Dallas, TX

ETL/SQL Developer

Responsibilities:

• Created data driven ETL process using TSQL and SSIS to avoid metadata changes from source side; Deployed packages and set up schedule to run deployed package using SQL Server Agent; also enhanced/maintained existing package
• Created database objects and created index for better performance; backup and restored the database; created users and set up the permission; created demographic (merged) tables for analyst
• Created various Chart’s reports for department and saved report results into PowerPoint using Aspose
• Learned to create SAS data set

Confidential, TX

ETL Developer

Responsibilities:

• Created database using SQL Server and created and modified tables, triggers and Indexes.
• Refreshed production data to development environment using scripts; backed-up and restored the database.
• Created and updated the stored procedures for testing and implementing new releases of SQL Server and Oracle applications. Also, assisted with resolving database and application issues affecting Oracle/SQL Server environments.
• Wrote ETL packages to import data from various source data using SQL Server Integration Services (SSIS), Developed new SSIS packages to import from Legacy data into Data warehouse (Star Schema).
• Created and Maintained bulk data load and extract processes that run on demand and on an automated schedule using UNIX script which reduced overall loading process cycle time by 70% and eliminated the need for manual intervention (saving $87,000 per year).
• Generated and maintained the various department reports SQL Server Reporting Services (SSRS).
• Created and Updated documentation and manuals on Data Dictionaries and Data Flow.
• Made Bug fixes and enhancements to existing Unix Shell Scripts and Provide Mentoring and Training to Customer Care.

Confidential - Cincinnati, OH

Data Analyst

Responsibilities:

• Loaded all Purchases to SBO2000 to ensure data accuracy, interacted with Trade Support when needed, and processed all loan sales. Implemented sales process changes, reducing time from 2 weeks to 2 days.
• Developed front-end tools in MS Access as automated solutions for various areas of the division.
• Generated daily reports for management and other members of various business units using Business Objects, OCIE, and COGNOS. These reports were designed to ensure data integrity and to reconcile the other systems that interfaced with SBO2000.
• Created and implemented mass updates to SBO2000 for additions and modifications using Oracle SQL*PLUS. Researched and reconciled issues from multiple systems and Maintained Request Project Tracking database for department, Developed and maintained procedures for all repetitive processes.

Confidential - UTAH

Data Analyst

Responsibilities:

• MIS reports for department. Produced daily, weekly and monthly production report using Informaker, Access and Excel.
• Analysis and maintenance of mortgage loans to ensure proper liquidation of the account per the legal documents. Worked with various business units on account modifications and corrections while providing timely resolution of escalated customer complaints.
• Trained employees on account correction procedures, analysis and product knowledge.
• Reported to management via weekly status reports that included project status, completed requests and exception reporting.

Confidential - Philadelphia, PA

Programmer Analyst

Responsibilities:

• Edited raw data and created SAS (Statistical Analysis Software) data sets to be used in SAS program for statistical analysis.
• Involved in routine analysis using SAS program for statistical report, data tabulations and graphs.
• Ran SAS programs such as analysis of Variance and Co-Variance, multiple comparisons and fitting Linear model for statistical analysis. Also wrote a SAS program for plotting statistical results.
• Validated all programs as mandated by the regulatory agency. Managed database including archiving.
• Analyzed the system requirements for a new database, designed various databases in Oracle.
• Coding and Optimization Store Procedures and functions.
• Prepared documents and procedures used in the developing the system.
• Trained employees on the new system such as Payroll, Billing, the Operation and Maintain system and the Trading system.