SUMMARY:

• 12 years of application development and implementation experience as a SQL / Database and Business Intelligence Developer with expertise in ETL, Database Design, Database Management, Modifying / Repairing tables.
• Experience in leading multiple projects, team members and mentoring junior staffs.
• Expertise in Software Development Life Cycle (SDLC), Object Oriented Analysis & Design Methodology.
• Knowledge and experience in data modeling tools & project management methodologies using waterfall or Agile for projects development.
• Strong knowledge / work experience in Relational Database Management System concepts, Schemas, Views, Triggers, Functions, Stored Procedures, Indexes and Constraints.
• Proficient in using SSMS, SSIS, SSAS and SSRS for SQL Server 2005, 2008R2, 2012 and 2014
• Profound knowledge of utilizing tools in data analysis, SQL Server Enterprise Manager and SQL for data retrieval
• Hands on experience with Data manipulation, sanitization, query and performance tuning
• In - depth knowledge of web technologies, relational databases and multi-tier applications.
• Good interpersonal and communication skills with ability to present to managements & teams
• Knowledge of data privacy and compliance.

TECHNICAL SKILLS:

• SQL Server
• SSMS
• SSRS
• SSIS
• SSAS
• SQL Server Report Builder
• Power BI
• Oracle PL SQL
• Python
• Teradata
• Cerner
• Netezza (Aginity)
• Team Foundation
• Subversion
• Toad
• HTML
• XML
• C++
• VB Scripting
• VB.Net
• Agile Project Management
• Erwin Data Modeler
• Word
• Excel
• PowerPoint
• Access
• Visio
• SharePoint and Exchange

PROFESSIONAL EXPERIENCE:

Confidential

Enterprise Data Quality Management - Senior / Lead

Responsibilities:

• Part of the Enterprise Data Management Quality Assurance team, that implement, manages the adoption, alignment, and adherence to internal data management policies and standards and external regulatory requirements (i.e., Basel Risk Data Aggregation Principles) with specific focus on Metadata.
• Responsible for conducting data and controls testing across all the data domains within the Bank.
• Perform Data analysis using SQL Server and Python / Data execution against a defined strategy using Teradata.
• Responsible for extracting and loading data using SSIS into SQL Server.
• Perform Risk mitigation and escalation.
• Governance and oversight to ensure a consistent approach for interpretation, adoption, and sustainment of the Enterprise Data standards
• Evaluate Operational process effectiveness / recommend improvement and implementations.
• Interact with internal Audit and external auditors.
• Develop a close working relationships and consultations with partners to assess current levels of compliance and ensure sustainment.
• Track Defects using HPQC and Perforce for version control.

Confidential

SQL / Database Developer - Senior

Responsibilities:

• Part of the CLRTY Development team, developing, transforming and loading data into the CLRTY data mart for Credit Risk Management business unit for BASEL, CAR, CCAR and FR Y-14M regulatory reporting.
• Meet with Line of Businesses to gather information on requirements and address their concerns.
• Create Functional Specification Document and present to the team.
• Design Data modeling for new incoming data using Microsoft Visio.
• Create new Stored Procedures for new requirements to extract data.
• Maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Update existing Stored Procedures / write complex code to address issues / discrepancies in the data.
• Perform analysis, validation, integrity and conversion of inbound data.
• Perform query and database tuning.
• Prepare Release Artifacts for UAT and Production Deployment.
• Use TFS for source code in development and deployment.
• Use Agile Sprint for project development and JIRA for tracking.

Confidential

SQL / Database / ETL Developer - Senior

Responsibilities:

• Designed and developed ETL packages for migrating data from multiple sources (Flat Files, Oracle, Netezza, Teradata and AS400 (DB2) into the Operational Data Store (ODS)).
• Created Batch files for Tidal Enterprise Scheduler to execute the packages / scheduled Job in Tidal.
• Designed and developed complex and multistage SSIS packages using various tasks such as For-each-loop, Execute Process, Data Flow, Execute SQL, Data conversion, Derived Column, File System and Script Task - writing custom code using VB.net respectively.
• Performed analysis, validation, integrity and conversion of all inbound data.
• Performed Database / Query tuning on Oracle, Netezza and Teradata platforms using T-SQL and PL SQL.
• Automated all manual processes within ETL daily process and created Scripts to automate manual process within the Database.
• Mentored Junior Developers in writing complex queries and development of SSIS packages.
• Developed Data Dictionary from Source to Target Mapping.
• Used InfoSphere Change Data Capture for data load from AS400 (DB2).
• Created complex queries for data load and develop / design database objects. (Stored Procedure, Synonyms, Tables, Table Partitions and Indexes).
• Executed multiple concurrent tasks/projects according to priorities.
• Documented Release Manual for Production Deployment.
• Used HP Application Lifecycle Management for tracking project lifecycle.
• Used Subversion for source code / Agile for project development and RALLY for tracking.

Confidential

SQL / Database / Business Intelligence Developer - Senior / Lead

Responsibilities:

• Led the Database and the UI Application Developers Team in the design and development of MWCDD to support the Middleware Competency Center (MWCC), Enterprise Patching Program (EPP), Enterprise Reporting System (Validation Framework) and Operation Risk Management (ORM).
• Led the planning, designing of data modeling and migration of MWCDD Database from SQL Server 2008 to SQL Server 2014.
• Led the planning / Designing of CDD SSIS Server on SQL Server 2014 / production support of CDD Database.
• Evaluated project, requirements, designed and configured efficient and cost-effective solutions.
• Oversaw configuration / code quality and verified consistency with security policy and standards.
• Participated in meetings with various stakeholders to address / resolve their needs and concerns.
• Created standards, best practices and work flow activities for CDD to ensure availability of MWCDD per SLAs.
• Used agile methodology in consulting with clients and gathering of requirements for backlogs.
• Automated daily processes by designing SSIS using various tasks to create ETL packages to validate, extract, transform and load Remedy, Tibco and MQ data into CDD database and sending data to CDD data users.
• Created / debugged complex Stored Procedures that translated business rules for extracting, transforming and loading data from MCAT (Middleware Compliance Automation) into CDD database.
• Experienced in using PAC2000 problem and change Modules. Scoped / sized work efforts by estimation.

Confidential

SQL / Business Intelligence Developer - Senior

Responsibilities:

• Led the Database Team / Consulted with clients, gathered requirements, provided solutions, and developed key metrics for reporting.
• Migrated SSIS packages, Web Forms and Databases from SQL Server 2005/ 2008 to SQL Server 2012.
• Created Stored Procedures for complex business processes, wrote T-SQL/ Postgress SQL and designed tables in SQL Server and Netezza Database.
• Automated SAS manual report from two weeks processing time to 4 hrs run time using SSIS packages, stored procedures and job agent.
• Scheduled and Monitored SQL Server Agent Jobs to run various SSIS packages in SQL SSMS.
• Extensively used SSIS to design ETL packages to validate, extract data from Oracle / Cerner, transformed and loaded data into SQL Server & data warehouse, data mart in Netezza using best practices set up by the department.
• Collaborated in Deployment and Administration of SSIS packages with Business Intelligence Development.
• Took ownership and customized already existing business practices, workflows, activities and deliverables.

Confidential

SQL / SSIS / SSRS Developer - Senior

Responsibilities:

• Led / Mentored Junior Developer staffs of Bankruptcy and Foreclosure group under Consumer Lending.
• Assisted team in writing complex queries for SSRS report and provided assistance on using different tools within SSRS, SSIS, writing expression and formatting reports.
• Designed SSIS packages for migrating data from Oracle and SQL Server databases to designated databases.
• Designed / developed SSIS packages to automate the process of sending reports to client's directly.
• Designed dashboard reports in different forms using maps, graphs, charts, tabular, area and pie charts.
• Designed, developed and deployed reports using SQL Server Reporting services 2005/2008/2008 R2.
• Coordinated the uploading and organizing the reports in report manager server.
• Designed different types of reports; Parameterized, Linked and Drill-through reports.
• Scheduled / monitored daily, weekly, monthly reports in report manager and worked on subscriptions.

Confidential

SQL / SSIS/ SSRS Developer

Responsibilities:

• Designed ETL solutions with SSIS, Extract data from excel sheets and other resources to load into SQL tables.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Responsible for data validation, data integrity and data conversion.
• Developed management tools: Dashboards to quantify, measure, monitor work process and operational information. (E.g. Key Performance Indicator, Management Report).
• Created weekly, daily and ad-hoc reports, by writing complex SQL queries and using SSRS.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.

Confidential

SQL / SSIS / SSRS Developer

Responsibilities:

• Designed data warehouse from OLTP database.
• Designed ETL SSIS packages, multidimensional data modeling, mining structure and algorithms.
• Created and analyzed data models/specifications within ETL-based data warehouse environment.
• Experienced in designing CUBE for data mart using SQL Server Analysis Services.
• Responsible for managing and coordinating activities and resources in a project life-cycle (initiate, plan, execute and close).