SUMMARY

• Over 8 years of experience in Database Development, Data Extraction, Data Analysis, Data Validation, Data Governance, Data Marts, Data Transformation, Credit Card, Banking and Data Processing Industries.
• Experience in creating financial data structures, data sets, and financial reports, business data marts in Teradata and Oracle databases.
• Supported Basel II implementation project in conducting UAT’s, developing data quality rules and data governance rules, mapping documents and sole documents.
• Experience on data quality tools like Informatica Data Quality Tool (IDQ) creating data profiles, running the data quality checks on each column of a table.
• In - depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases such as Requirements gathering, Analysis/Design, Development and Testing.
• Experience in writing USER TEST CASES and in conducting User Acceptance Testing (UAT).
• Highly proficient in creating Use Case diagrams, Sequence diagrams and Activity Diagrams based on UML methodology using CASE tools like MS Visio.
• Experience with various defect tracking tools like HP Application Life Cycle (ALM) and Quality Center.
• Strong ability to write SQL queries using PROC SQL.
• Involved in coding and pulling data from various Teradata tables using Unions and Joins.
• Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (Teradata, Oracle) tables using LIBNAME and SQL PASSTHRU facility.
• Performed data extraction, analysis and published results using SAS ENTERPRISE GUIDE.
• Extensive knowledge of advanced SAS/STAT procedures including UNIVARIATE ANALYSIS, REGRESSION, ANOVA, GRAPH AND PLOT.
• Knowledge on Moody’s Economic data and acted as a data steward in performing the data validations, trained users on the data, developed data quality rules and generated macroeconomic graphs on Monthly and quarterly bases.
• Very good experience in Building Adhoc reports.
• Experience in Teradata, Teradata Utilities, BTEQ, Teradata SQL Assistant, Oracle, SAS, SQL, PL/SQL, MS Access, MS Excel, Visio, and UNIX.
• Collaborated with Business Analysts in identifying requirements for the new Card Data Warehouse data model.
• Served as a liaison between Business Analysts, Operation Analysts, Project Managers and IT Team.
• Developed SQL scripts to verify the database updates, inserts and deletion of the records.
• Performed data extraction, data transformation and data manipulation by using Oracle, Teradata, SAS and MS Access from production sources.
• Worked very closely with Business Analysts and Operation analysts to perform Segmentations.
• Good written and oral communication skills and proved to be an excellent team player in previous projects.

TECHNICAL SKILLS

Operating Systems: Windows NT, Windows 2000, Windows XP, Windows 2007, HP-UX, Solaris, MVS, MS-DOS.

Languages: C, SQL, PL/SQL, BTEQ, SAS, JCL, PASCAL, COBOL.

Database Management systems: Oracle 10g/8i/8/7.3, SQL Server, Teradata V2R5,12&13,MS Access MS Access, MS Excel, SQLServer2000 7.0, 6.5, Transact-SQL, Sybase.

GUI: Visual Basic4.0/5.0/6.0,NET, ASP, Developer 2000, Forms, reports, Sql*Net, Base SAS.

Tools: Toad, Teradata SQL Assistant, Test Director, Rational Clear case explorer, Clear Quest, Rational Requisite Pro, HP quality center, Informatica Data Quality tool.

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Data Analyst / Data Steward

Responsibilities:

• Developed and maintained segmentation scripts to send the data to the external vendors via FTP servers based on the criteria provided by business managers and analyst’s team.
• Extracted the data files from FTP server sent by the external vendors and then loaded them into tables and processed the data to develop the weekly and Monthly reports.
• Developed monitoring reports for several tests to make sure they perform accurately.
• Interacted with the liaisons in bringing the new vendors onboard and in exchanging the data via FTP servers based on the criteria provided by the business managers and analyst’s team.
• Performed data cleaning by analysing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and macros in SAS
• Executed Business Object reports and prepared the final reports as per the business needs.
• Developed and maintained the summarized data tables and created the Pivot tables using Excel.
• Executed Quarterly, monthly and daily financial reports in interactive mode, batch process for various business groups.
• Developed complex Data Quality rules for data governance purposes.
• Performed user acceptance testing on the data that is used for Basel models.
• Imported Data from relational database into SAS files per detailed specifications.
• Involved in complete SDLC life cycle implementation of Basel II accord project.
• Created various reports, graphs, Data Quality rules and worked closely with Economic data SME in loading the internal Economic forecasts data and Moody’s data into warehouse.
• Trained the users on Economic data
• Performed data manipulation, data extraction, data validation by using Teradata SQL assistance.
• Designed and Developed monthly business review reports for high level management.
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time.
• Extracted data from Excel and flat files and populated the data into Teradata tables using SAS.
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analysing the raw data and writing SAS Program and creating complex reusable Macros.
• Provided data to operation/business analysts in graphical format by using MS Office.
• Performed data validation as per the business analyst’s requirements before the data goes into production environment.
• Automated weekly and monthly financial reports in Excel as per the requests.
• As a part of the Recoveries group maintained all the group level reports on a single dashboard and acted as a point of contact in executing, enhancing and delivering the reports according to the business needs.
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements.
• Created test cases, test defects and logged them into HP ALM quality canter for the developers to work on the defects.
• Modified Korn-shell scripts on UNIX to schedule the program to run at different time intervals.
• Involved in Korn-shell scripts for executing SAS batch files on UNIX to save the execution time and for automation.
• Developed SAS Macros to simplify SAS code and effectively reduce coding time.
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE

Environment: TeradataV12 &13, SQL, SAS, MS Excel, HP UNIX, Windows XP, VBA, Informatica Data Quality . Tool, HP Application Life cycle.

Confidential, OH

Database Developer/Data Analyst

Responsibilities:

• Developed several reusable SQL, UNIX scripts for different lines of business groups which helped to cut down scripting time for Adhoc requests.
• Created financial activation report to identify the number of accounts activated in single day by using Oracle, SQL and UNIX.
• Developed financial data mart, Adhoc reports based on business analyst, operation analysts requirements by using Oracle, SQL, PL/SQL and UNIX.
• Provided data to business analyst, risk analysts, project manager in various formats like MS Excel, MS Word and MS Access.
• Developing Adhoc-reports as per business requirements and create various reports like summary reports, tabular reports etc.
• Developed new or modify macros for report generation using SAS / Macros as per the statistician’s requirements.
• Developed SAS programs for statistical analyses and data displays.
• Analyzed data from different perspectives and summarized it into purpose of mapping it to the general ledger.
• Communicated with financial analyst, project manager to gather financial data to perform data analysis and built financial data mart by using Oracle, SQL and UNIX.
• Assisted business analysts, operation analysts and project managers on different financial models.
• Developed data validation process for business groups to eliminate duplicated accounts.
• Created SQL QA scripts to eliminate errors in segmentation process and later automated the process using UNIX scripts.
• Performed data validation as per the business analyst’s requirements before data goes into production environment.
• Performed SQL and PL/SQL queries on the Oracle financial data warehouse.
• Provided data to project managers, business analyst in various formats with help of MS Excel, MS Access, and SQL.
• Provided data to operation/business analyst in graphical format by using MS Office.
• Analyzed data by data extracting, data manipulating the files using awk and shell scripts.
• Created access databases, wrote queries and performed control totals to provide the management a high level overview of the data.

Environment: Oracle8i,SQL,PL/SQL,SAS, MVS, MS Excel, MS Access, Unix, WinNT/2K,Toad,Visual Basic.

Confidential

Database Analyst/Database Developer

Responsibilities:

• SQL scripts were developed for accessing data from the Oracle tables.
• Account base Impact analysis reports were generated using SQL as required by the client.
• Designed, Developed Adhoc reports for the finance department by using Oracle, MS Access and MS Excel.
• Performed Account base Impact analysis on existing data stores, generated Adhoc reports by using SQL and Unix
• Extracted data from various data sources according to business specifications.
• Created reports using SQL, PL/SQL and Unix.
• Developed Adhoc, weekly, daily, monthly payment reports to various departments using SQL, MS Excel and Unix.
• Reports were created for various lines of business like Marketing, Financial, and New Accounts group by using SQL, Bteq, MS Access and Unix.
• Spooled data into excel sheets from Oracle, Unix as per business analysts request.
• Performed data validation before deliver data to business groups and operations groups.
• Delivered quarterly, monthly, daily financial reports data to financial analyst, business analyst in graphical format by using MS Office.
• Analyzed and tuned complex SQL Queries, Stored Procedures for faster execution.
• Performed data manipulation, data validation and data extraction by using SQL.
• Developed quarterly, daily, monthly, bi weekly reports in oracle database with help of interactive mode and batch Process.
• Worked very closely with business analysts, operations analyst to develop business data mart based on accounts criteria by using Oracle, SQL and Unix.
• Developed data extraction and data manipulation process in various databases with help windows and Unix operating systems.
• Performed two kinds of data loading processes (daily and weekly) depending on the need.
• Experience in designing the procedures for getting the data from all systems to Data Warehousing system.
• Developed and customized financial reports and queried from different database tables as per the requirement.

Environment: Oracle8i,SQL,PL/SQL,SAS,MVS,MsExcel,MSAccess,Unix,WinNT/2K,Toad,Visual Basic,.