Data Sql
Resume:
Asha
(*********@*****.***)
Professional Summary
. Over 7 years of experience in SAS Programming with Financial, Banking,
Insurance and Brokerage industries.
. Thorough understanding of Database and Data warehousing concepts.
. Good expertise in business/system analysis as well as reengineering of
legacy applications
. Extensive programming experience using COBOL and PL/I
. Extensive conversion/migration experience of SAS programs from Host to
Unix and Windows
. Extensive coding experience using Shell and JCL
. Expert hand on knowledge of SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH,
SAS/ACCESS, SAS/ETS, SAS/ODS and SAS/SQL
. Experience of writing test plan for Unit, System, Integration and
Regression testing.
. Experience of participating in peer reviews and Quality Assurance (QA)
activities.
. Experience in developing process flows and data flows.
. Good understanding of Data warehousing models, dimensional, Star Schema
and Snowflakes Schema methodologies.
. Code with structured logic to be understood and easily maintained by
others.
. Experience in developing SAS Macros and application for data updates,
data cleansing and reporting.
. Successfully increased portability of existing SAS programs and created
new programs using SAS macro variables to improve efficiency and
consistency of result.
. Successfully analyzed business logic and system needs to prepare dataflow
diagrams and documentation.
. Particularly adapt in identifying technology solutions for business
problems and implementing them.
. Through experience in data extraction and sorting from various databases
like Oracle, Teradata, DB2, COBOL, JCL and MS Access using PL/SQL and
SQL.
. Experience in Teradata V2R4/V2R5/V2R5.1 with Creating indexes, tables,
views, macros and stored procedures.
. Experienced using database query tools for Oracle, SQL and UNIX such as
TOAD, Teradata SQL Assistant, WinSQL and SQL Plus
. Strong command over Structured Query Language (SQL). Expertise in Windows
operating Result oriented, committed and hard working with a quest to
learn new technologies and undertake challenging tasks.
. Excellent leadership, analytical and problem solving skills and excellent
communication and presentation skills.
. Enthusiastic to develop new skills in a dynamic environment. Go-getter
attitude and a good team player.
Technical Skills:
SAS Skills SAS/BASE, SAS MACROS, SAS/AF, SAS/STAT, SAS/GRAPH, SAS/ACCESS
and PC SAS
Languages COBOL, JCL, PL/I, CLIST and C++, PERL, Shell Scripting
Operating Systems MVS/ESA (OS 390), WINDOWS, UNIX
GUI Front Ends Visual Basic 6.0
OLTP CICS, IMS DC
Databases DB2, IMS DB, Teradata V2R6, MS-ACCESS, SYBASE and ORACLE
Utilities BMC LOAD/UNLOAD, REORG, RUNSTATS & SYNCSORT
Mainframe Tools EXPEDITOR, FILEAID, SDF, SPUFI, STAR TOOL, INTERTEST,
ENDEAVOR, CONTROL-M, NDM, CHANGEMAN and ISPF
Other Tools FTP, Rational ClearCase, Rational
ClearQuest,
MS-Visio and MS-office
Education: B. Tech in Bio-Technology (JNTU, Hyderabad, Andhra Pradesh,
INDIA)
Professional Experience
Bank of America, Jersey City, New Jersey
Feb 2009 to Present
BI Team (EDWH) - Anti-Money Laundering - Suspicious Activity Reports
SAS BI Developer
Responsibilities:
. Reengineered the existing system and developed process flows and data
flows
. Assisted the business users in analyzing the data and developed proto-
types whenever required
. Did impact analysis and identified impacted components
. Prepared detailed technical specifications
. Extensively used Teradata load utilities Fast load, Multiload and
FastExport.
. the Teradata data warehouse
. Developed number of SAS programs and macros using various SAS procedures
to generate Ad hoc reports
. Extract analyze data using various SAS procedures
. Loaded the data into the Teradata database using Load utilities like
(Fast Export, Fastload and Multiload).
. Did transfer of data using FTP between different platforms
. Queried Teradata Database and validated the data using Sql Assistant
. Provided 24X7 on call production support
. Prepared Implementation plan and Pre-implementation check-list
. Did conversion of SAS programs from MVS to Unix
. Developed number of reconciliation and roll-forward reports for annual
tax filing
. Developed Shell scripts to execute SAS programs under UNIX
. Did performance tuning of SQLs of peers to meet the implementation window
. Developed Panels using CLIST to invoke SAS online interface
. Did walk-thru re-engineered jobs and programs for better performance
. Coded and modified new JCLs and Procs
. Did bug-fixing of the defects found during System integrated test/UAT
. Prepared Runbooks and new Autosys/Jobtrac requests
. Used SAS/ODS Facility to create style report in HTML, RTF or PDF as per
the requirement.
Environment: SAS 9.1, SAS/AF, MACROS, PC SAS, TSO/ISPF, CLIST, COBOL, FILE-
AID, FTP, VSAM, DB2, IMS, SYBASE, MS-ACCESS, JCL, ZOS, JOBTRAC, LOTUS
NOTES, NDM, MS-EXCEL, UNIX, AUTOSYS, MS-VISIO, MS-WORD, Oracle 10g, SQL,
Teradata V2R6, Rational ClearCase and Rational ClearQuest.
American Express, Phoenix, AZ
Jun 2007 to Feb 2009
BI Team (EDWH) - Credit Card Processing Data Group
SAS BI Developer
Responsibilities:
. Extracted raw data from an Oracle database and used SAS/ACCESS to read it
and ran statistical analysis using SAS/STAT.
. Extracted data using Proc SQL and Pass-Thru SQL to Create SAS Analysis
Data Sets. PL/SQL and Oracle Stored Procedures were extensively used.
Proc Compare, Proc Summary, Proc Contents and Proc Report were used for
analyzing and verifying data.
. Created SAS datasets by extracting data from various sources and used
complicated data step logic
. Executed the SAS jobs in batch mode through UNIX shell scripts
. Created remote SAS sessions to run the jobs in parallel mode to cut off
the extraction time as the datasets were generated simultaneously
. Involved in code changes for SAS programs and UNIX shell scripts
. Reviewed and modified SAS Programs, to create customized ad-hoc reports,
processed data for publishing business reports.
. Created flow charts to exhibit the flow of data from source datasets to
the final reports
. Automated SAS jobs running on a daily, weekly and monthly basis using
SAS/BI & Unix Shell Scripting
. Developed Test Plan and Test Cases using Mercury Quality Center to test
the application for the new code.
. Building of generic utility processes for large volume sort,
sort/summation, and UNIX batch SAS execution
. Conversion of QMF queries to SAS SQL processing.
. Developed integrated menu/panel driven tool set of 12 user augmentation
tools to facilitate running of non-SQL SAS programs and conversion QMF
SQL/FORMS to SAS SQL.
. Migrated MainFrame JCL jobs into Unix Shell Scripting for running SAS
nightly jobs.
. Worked on extracting data from VSAM databases and creating feeds to a SAS
System.
. Write and maintain documentation to describe program development, logic,
coding, testing, changes, and corrections.
. Built a batch application that recreates business procedures using SAS
Base, SAS macro and SAS Access, basic SAS Stat and JCL/MVS/TSO/ISPF
. Supported Mainframe application which used SAS to extract and format
credit card billing records.
. Validation included structured test plans, test databases, reengineering
documentation of legacy processes
. Usage in JCL, SAS Macro, CLIST/REXX/DMS, and ACF2
. Created final reports in Excel sheets which is then accessed by the
business users.
. Integrated the changes in Common Development Area.
. Created MDDBs for monitoring various parameters like CTQ (Critical to
Quality) and SLA (service Level Agreement).
. Developed standard reports on CTQ, SLA and six sigma using Base SAS and
Macro Language.
. Provided up-to-date industry and company specific reports.
. Worked with more than hundred million rows of data sets.
. Extensively used PROC SQL and indexing for highly advanced matching and
merging between large datasets.
Environment: SAS 9.1, SAS/BASE, SAS/MACROS, SAS/SQL, SAS Warehouse
Administrator, MVS, ISPF, OS/390, JCL, COBOL II, VSAM, Copy Books, DB2,
Oracle 9i, PL/SQL, IBM AIX 5.X, UNIX Shell Scripting, MS Excel and Windows
2000/XP
Citigroup, Warren, New Jersey
Oct 2005 - May 2007
SAS Programmer/Analyst - Global Consumer Data Group
Responsibilities:
. Using proc SQL extracted marketing demographics from DB2 data warehouse
for model testing, segmentation, scoring, and list management purposes.
. Following project specifications, wrote, tested, debugged, documented,
and implemented complex SAS programs to produce mailing, telemarketing,
and email lists for specific business and retail marketing efforts.
. Interacted with clients, modelers and analysts to refine targeted
populations and control groups.
. Used extensive macro programming to optimize the code and to replace
repetitive codes.
. Converted SAS catalogs to PDF reports and modified pre existing macros to
latest requirements.
. Statistical analysis (Descriptive statistics, Factorial ANOVA, Regression
analysis, creating graphs and charts (2D/3D) etc.) for the data in
different departments.
. Performed data analysis, statistical analysis, generated reports, listing
and graphs using SAS tools-SAS/BASE, SAS/GRAPH, SAS/SQL and SAS/ACCESS.
. Imported data from mainframe flat files and relational database (Oracle)
files into SAS files per detailed specifications.
. Extracted Data from DB2,COBOL Files and converted to Analytic SAS
Datasets
. Involved in development and enhancement of SAS programs for user
acceptance and generating report, tables and listing.
. Successfully used SAS/STAT to perform analysis of variance, multivariate
analysis of variance and repeated analysis of variance.
. Created survival graphs in Excel by transporting SAS data sets into Excel
spreadsheets.
. Effectively prepared and published various performance reports and
presentations.
. Generated graphs using SAS/Graph and the SAS Graphic Editor.
. Developed routine SAS macros to crate tables, graphs and listings.
. Extensively used the SET, Update and Merge statements for creating,
updating and merging various SAS datasets.
. Participated in user requirement discussions and data quality assessment.
. Effectively worked with users to define business processes and
information systems for supporting those processes.
Environment: SAS 9.1, SAS/BASE, SAS/MACROS, SAS Enterprise Guide, SAS/STAT,
SAS/SQL, SAS BI, DB2, PL/SQL, IBM Z9/ZOS, Windows/XP, OS/390, COBOL, JCL,
VSAM.
IBM Global Services, Bangalore, INDIA
Apr 2003 - Sep 2005
Client: JPMCHASE, Jersey City, New Jersey
Financial Analyst - Equity Sales System - Middle Office Data Recon Group
Responsibilities:
. Actively involved in design and implementation of application software
using primarily SAS system and analyzed existing application software and
recommended improvements.
. Designed flowcharts indicating the input data sets and the techniques
that would be used (sorting, merging, etc.) to get the desired output.
. Processed data collection to ensure proper quality of data
. Maintained data collection to ensure proper quality of data.
. Developed SAS macros for data cleaning, reporting and to support routing
processing.
. Present numerical information in various formats. Created SAS Customized
report using the Data_null_ technique.
. Merging, Indexing, appending and sorting the data sets using various SAS
procedures and other SAS tools.
. Did performance tuning of SQLs of peers to meet the implementation window
. Modified/developed JCLs and Scripts using Shell
. Did walk-thru and re-engineered jobs and programs for better performance
. Did bug-fixing of the defects found during System test/UAT
. Developed and executed SAS SQL queries for merging, concatenating and
updating large volumes of data.
. Worked with the specified marketing teams to clearly identify the
selection criteria needed for each list.
. Involved in validation of analysis datasets, tables and listings using
Proc compare and code walk-through.
. Generated graphs using SAS/GRAPH and the SAS Graphics Editor. Used Proc
Report to generate reports.
. Developed macros to generate customized report using DATA_NULL_ and PROC
REPORT, TABULATE AND SUMMARY.
. Created SAS/Views from Oracle database tables.
. Analyzed and interpreted numerical data from various sources organized
and summarized data for analysis.
Environment: SAS 8/8.2, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/Graph, Oracle 8,
PL/SQL, and Windows NT/2000
Contact this candidate