SUMMARY

• Over 8 years of total IT experience in software analysis, design and development for various software applications in client - server environment with expertise in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems.
• Expertise in SAS / Base, SAS / Graphs, SAS / Macros, SAS / ODS, SAS / SQL.
• Familiar with SAS Access, SAS/STAT, SAS/Connect, SAS/ETL
• Extensive experience in preparation of reports, tables, listings and graphs
• Excellent command in producing reports employing various SAS Procedures and handling Large Databases to perform complex data manipulation using files in SAS data steps.
• Excellent experience in ETL processing using Informatica Power Center 8.x/ 7.x, Power Connect, Power Exchange
• Expertise in using Informatica client tools - Designer, Repository Manager,,Workflow Manager and Workflow Monitor
• In-depth understanding of Data warehousing concepts such asBill Inman, Kimball methodology’s
• Extensive experience in Data warehouses with strong understanding of Logical, Physical, and Dimensional Data Modeling to Design Star and Snow flake Schema’s.
• Used SCD (type1,type2 and type3) to Load present and Historical Data to ODS,EDW
• Proficient in using Workflow Manager Tools like Task Developer, Workflow Designer and Worklet Designer.
• Over 8 plus Years of experience in Information Technology as Business Analyst/Data Analyst using Teradata, Oracle,SQL,DB2 and MS Access RDBMS.
• Experience as Data Analyst, Business Analyst, Access/Excel Developer, Metrics/Reporting Analyst, Financial Systems Analyst.
• In depth knowledge of Access including tables, queries, forms, reports, Access SQL, and VBA.
• Extensive experience on various Mainframe Application Development and Testing Tools including FILE-AID for MVS/DB2, XPEDITOR, QMF, IBM DEBUGER, SPUFI.
• In depth expert level knowledge of Excel including defined data ranges, data validation, functions, pivot tables, MS Query, V-Lookups, SumIfs, arrays, macros, graphing, VBA, backwards compatibility and Excel/Access integration.
• Teradata: SQL scripting, uploading data, creating tables/views, development of presentation layer.
• Knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau
• ETL/Monarch skills for transforming data into Access and utilizing Access integrated with Excel.
• Proven ability to create/develop ad hoc tools through full applications consistent with EUC.
• Extensive prior experience analyzing data utilizing Excel and Access for data analysis.
• Experience: SQL Server Reporting Services, Cognos, SAS, Crystal, Business Objects, Discoverer.
• Familiar with different computing environments including mainframes, oracle databases, and UNIX.
• Oracle Developer including SQL, PL/SQL, SQL*Plus Editor.
• Database analysis tools Teradata SQL Assistant, TOAD and ERwin. Data cleansing tool WinPure.
• Responsible for creating ETL design specification document to load data from operational data store to data warehouse.
• Experience in MS Excel, PowerPoint and Other MS Office Suite
• Extensively used Teradata SQL, BTEQ for the backend process to build the business rules
• Created numerous Volatile, Global, Set, MultiSet tables
• Performing Adhoc reports by using Oracle, Teradata, BTEQ, and UNIX.
• Experience in Banking and Credit Card industry business processes.
• Extracting data from existing data sources, Developing and executing Business reports for Performance Monitoring
• Experience in preparing Business reports using Teradata SQL and BTEQ
• Experience in Data Validation and Verification and documenting the results.
• Developed weekly, biweekly, monthly reports by using Ms Excel, Ms Access, and Teradata SQL.
• Good Experience in scripts conversion from Oracle to Teradata
• Experience in Automating and Scheduling SQL Scripts in UNIX using Korn Shell Scripting.
• Experience in Writing BASE SAS Programs for converting Teradata table into Flat files (CSV, Fixed Format etc)
• Quick learner and excellent team player with good communication and presentation skills

TECHNICAL SKILLS

Web Development: ASP.NET, HTML, CSS, Javascript, XML/SOAP Web Services, IIS, ASP

SAS: SAS Base, SAS/Macro, SAS /Connect, SAS-SQl, SAS/ STAT, SAS/Graph, SAS/Acess, SAS Enterprise Guide, Enterprise Miner, SAS, Information Map, Web Report Studio.

Windows Development: Winforms

Databases: Teradata, SQL Server 2000/2005, Oracle (8i/9i/10g), MS-Access 97/2000, PL/SQL, T - SQL, ADO.NET, SQL

Query tools: Teradata SQL Assistant, SQL Server Management Studio, SQL Query analyzer, SQL Enterprise Manager, ETL Tools Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), TOAD

Scripting: UNIX Shell Scripting (Bourne,Korn,Cshell), VB script, VBA, JSP

Languages: VB.NET, C#.NET, C, C++, Pro*c

Development Tools: Visual Studio.NET 2002/2003/2005/2008 , Visual Studio 6.0, Team Foundation Server

Web Servers: IIS 5.0/6.0, Java Web Server 2.0, Tomcat, and JSWDK1.0.1.

Reporting tools: Crystal reports 9.0/10.0, XtraReports

Design Tools: UNICA(AC), UML, Rational Rose, Ms Visio, AutoCAD, PRO - E

Versioning tools: Visual SourceSafe 6.0d

Operating Systems: Windows NT/2000/2003/XP, UNIX, DOS

Other: Team Suite and agile development, SharePoint Portal Server, Windows SharePoint Services, Microsoft Enterprise Library, web client software factory, Active Directory

PROFESSIONAL EXPERIENCE

Confidential, NY

SAS Developer

Responsibilities:

• Worked closely with Engineering to implement any software required for accessing and handling data appropriately
• Created SAS data mining and scoring data sets form source tables by programming in BASE SAS.
• Report Generation and Documentation with respect to evaluation of model performance and effectively communicating the results to higher management
• Responsibilities include writing SAS MACRO CODE, SCL to read and create METADATA files on Unix.
• OLAP Cubes and ETL skills to provide for all types of programs.
• Pulled DB2 fields for marketing campaigns and used SAS for reporting campaigns.
• Created complex and reusable Macros and extensively used existing macros and developed SAS
• Developed an Automated Quality Control System for Data Validation and data integrity.
• Documentation, Preparing statistical reports using SAS.
• Wrote Design documents, Program specs and SAS code.
• Involved in various Testing phases (Unit, System and Integration)
• Understand the business processes and help select the most appropriate functional requirements specification and business processes.
• Conducted various Data requirement sessions with various business SMEs to gather the data required for the downstream systems.
• Assisted in modeling and documenting the end-user's AS-IS and TO-BE business processes.
• Loading tables and building queries as well as MS Excel functions such as vlookups and pivot tables
• Drafted and produced professional and high impact business plan using prerequisite information about the venture.
• Used MS Visio to create business process flowcharts and workflow diagrams and followed UML based methods for Business Modeling using Rational Rose.
• Requirements Traceability using Rational RequisitePro.
• Responsible for creating ETL design specification document to load data from operational data store to data warehouse.
• Develop FASTLOAD and MLOAD scripts to load data from legacy system and flat files through Informatica to Teradata data warehouse.
• Involved with Business analysts to Provide Business Performance Data using Teradata, Oracle, SQL, BTEQ, and UNIX.
• Building up VBA Macro for Processes which are recurring jobs to pull data for specific requirement.
• Developed Access databases, crystal reports and VB/VBA code for Sales Tracking and Reporting
• Perform product level modeling/analytics to assist new product and pricing strategies for various lending products.
• Analyze product, measure risk, perform financial modeling and valuations. Build targeted insights to inform the design and development of new customer experiences.
• Worked on Basel II program at the bank with outside specialist consultants to improve and implement changes to bank’s Credit Risk Management Policy
• Developed Business Objects universes and reports with Teradata
• Analyzed large datasets in Teradata data warehouse
• Developed Access databases, crystal reports and VB/VBA code for Sales Tracking and Reporting
• Developing management Reports and Dashboards in Hyperion 9
• Created Daily, Weekly, monthly reports related by using Teradata, Ms Excel, and UNIX.
• Wrote BTEQ, SQL scripts for large data pulls and ad hoc reports for analysis.
• As per Ad-hoc request created tables, views on the top of the Finance Data mart/ production databases by using Teradata, BTEQ, and UNIX.
• Created tables, indexes, views, snap shots, database links to see the information extracted from SQL files.
• Created and implementeda new enterprise-wide Data Quality standard to further address emerging data quality risks- including Basel compliance
• Worked with Hyperion Essbase
• Created different set of tables (Like Set, Multiset, Derived, Volatile), Macros, views, procedures using SQL scripts.
• Worked on Testing Primary Indexes and SKEW ratio before populating a table, used sampling techniques.
• Extensively worked on Unix Shell Scripts for automating the SQL scripts, checking daily logs, sending e-mails, purging the data, extracting the data from legacy systems, archiving data in flat files to Tapes, setting user access level, automating backup procedures, Scheduling the Jobs, checking Space usage and validating the data loads.

Environment: SAS Enterprise Guide, BOBJ, Putty, MS Excel, MS Word, Teradata 13.0, Oracle Teradata SQL Assistant, VB, Tableau,BTEQ, Erwin, Oracle 9i, PC SAS, MVS, UNIX Shell scripts, DB2, SQL, PowerPoint, Excel.

Confidential, Mclean, VA

SAS Developer

Responsibilities:

• Worked with Business analysts to Provide Business Performance Data and other data using Teradata, Oracle, SQL, BTEQ, and UNIX.
• Worked on SAS 9.1/9.2 (SAS Unix): SAS/Base, SAS/SQL, SAS/Macro, SAS/Access to Extract, process/calculate and Load data from Central Teradata DWH (Teradata 06.02.0256 V2R) onto SAS platform.
• Created Macros, in order to generate reports daily, monthly basis.
• Created SAS Views from tables in DB2 using SAS/Access.
• Moving files from Test to Production.
• Designed Test system with SAS, SAS Macros, Meta Data, Oracle SQL, Oracle, AIX/Unix and Unix Shell Scripts.
• Used Microsoft SQL Server 2000 for SQL.
• Produced SAS Graphs for Engineers.
• Responsible for analyzing business requirements and developing Reports using PowerPoint, Excel to provide data analysis solutions to business clients.
• Created Daily, Weekly, monthly reports related by using Teradata, Ms Excel, and UNIX.
• Wrote BTEQ, SQL scripts for large data pulls and ad hoc reports for analysis.
• As per Ad-hoc request created History tables, views on the top of the Finance Data mart/ production databases by using Teradata, BTEQ, and UNIX.
• Created tables, indexes, views, snap shots, database links to see the information extracted from SQL files.
• Run reporting programs and download the results into EXCEL and build pivot tables
• Installed Hyperion/Brio and developed reporting queries for users
• Worked on tables (Like Set, Multiset, Derived, Volatile, Global Temporary), Macros, views, procedures using SQL scripts.
• Utilize previously-written campaigns in UNICA Campaign as well as custom SQL programming to generate lists of customers according to project specifications.
• Developed front end applications to oracle in Access as well as stand alone applications with VB code
• Managed the capturing of metadata definitions and mappings
• Developed SQL scripts for data loading and table creation in Teradata
• Did analysis on Oracle databases
• Worked on Testing Primary Indexes and SKEW ratio before populating a table, used sampling techniques, Explain Plan in Teradata before Query Large tables with billons of records and with several joins.
• Worked closely with Analytics department reporting team and deployed Tableau reports and publishing them on the Tableau server.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from multiple sources.
• Basel II preparedness and implementation to manage and assess credit portfolios
• Extensively worked on Unix Shell Scripts for automating the SQL scripts, checking daily logs, sending e-mails, purging the data, extracting the data from legacy systems, archiving data in flat files to Tapes, setting user access level, automating backup procedures, Scheduling the Jobs, checking Space usage and validating the data loads.

Environment: SAS Enterprise guide, Putty, MS Excel, MS Word Teradata SQL Assistant,BTEQ, Oracle 9i, Process Manager, Mainframes, SAS Management console, Teradata, Windows NT, UNIX Shell scripts, PC SAS, SQL,DB2, Tableau, PowerPoint, Excel.

Confidential, Charlotte NC

Data Analyst

Responsibilities:

• Analyzed the Business Concept as were introduced by the Marketing Department. Worked with various functional groups to understand the underlying concepts.
• Developed and documented the business requirements for migrating user accounts, group policy objects, OU structure from source to target domain.
• Involved in Application discovery process to identify the applications affected and needs to be remediated when user ids are moved to target domain and applications are in source domain.
• Converted Business Requirements to the Functional Specification.
• Gathered and documented Application remediation requirements after talking with Application owners on how their application uses directory services.
• Created a proto type to this automated home loan processing system which simplifies manual processingand avoid mistakes.
• Generated business views of the home loan processing application using Cognos.
• Involved in designing optimal mapping with Development team using Ab Initio.
• Designed and developed weekly, monthly reports related to the marketing and financial departments by using SQL, MS Excel, MS Access, Teradata
• Programming in UNICA Affinium, extracting lists of cardmembers for various marketing campaigns, utilizing PC and MVS platforms for additional programming.
• Developed SQL, BTEQ (Teradata) queries for Extracting data from production database and built data structures, reports.
• Provided data to financial business analyst in graphical format by using Ms Office, Power Point.
• Utilized SAS to develop Confidential Home Mortgage proprietary tools which allowed systematic approaches to analyze the relative risk of two production populations based on mix adjusted attributes
• Working on Auto Insurance and State Rollouts Project of Legacy Countrywide
• Extract latest accounts data from Oracle, Teradata database by using SQL, BTEQ
• Developed the Interfaces in SQL for data calculations and data manipulations.
• Experience in Power Point presentation (Financial data, charts).
• Used the MS Excel, MS Access for data pulls and ad hoc reports for analysis.
• Performance tuning and Optimization of large database for fast accessing data and reports MS Excel, Unix, Oracle, Teradata being used for data transformation
• Reports generated for various departments like Tele Marketing, Mailing, New Accounts by using SQL, BTEQ, MS Access, Unix
• Created adhoc/scheduled reports for different Business groups using Tableau
• Basel II and Financial Reform compliance
• Developed front end applications to oracle in Access as well as standalone applications with VB code
• Design and development of DB2 stored procedures on mainframe using COBO
• Familiar with different computing environments including mainframes, oracle databases, and UNIX.
• Worked on Database design and reporting. Experience working with Tableau, development of dashboards and publishing the reports. Working on Data warehousing and reporting
• Oracle Developer including SQL, PL/SQL, SQL*Plus Editor.
• Managed the development of Hyperion/Brio reporting and drill down applications
• Ad-hoc reports developed using Oracle, SQL, and UNIX.
• Designed, Developed Ad-hoc reports as per business analyst, operation analyst, project manager data request.
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Access, MS Excel.
• Extracted data from existing data stores and performed ad-hoc queries.
• Developed and maintained the MSACCESS database and applications.
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, SAS, Ms Excel, Ms Access, UNIX.
• Worked with business analysts, senior project managers, and programmers to gather business requirements and specifications.
• Designed, developed various Ad hoc reports for the finance (Oracle SQL, MS Access).
• Assisted in preparation and prepared documents and technical specifications using Microsoft Word and Visio.

Environment: Informatica Power Center, Oracle 9i, Teradata, SQL, Autosys, Toad, Windows, UNIX shell scripting, BTEQ, FLOAD, Tableau, Mainframes,MLOAD, MVS, PC SAS,MS-Access, MS-Excel, MS-Office, Microsoft Visio

Confidential, Wilmington, DE

SAS Programmer

Responsibilities:

• Extracted data from existing data source and performed ad-hoc queries by using SQL, Ms Access and UNIX.
• Designed & developed various departmental reports by using SAS, SQL, and Ms Excel
• Migrated data from Flat Files to Oracle database
• Created Unix Scripts that uses Bteq to access Teradata Database.
• Converted Scripts from Oracle to Teradata.
• Created tables, indexes, views, snap shots, database links to see the information
• Extracted from SQL, SAS files.
• Moved SAS jobs from Mainframe to UNIX server and modified and enhanced the Codes to execute in UNIX platform.
• Did prepare XML/XSLT files for data transfer between mainframe and NT
• Performed user acceptance testing for new modules to UNICA system,
• Verifying performance and documenting errors.
• Developed Datamart and setup Informatica for data migration
• Wrote access, SQL and PLSQL queries to work with Oracle databases and Financial applications
• Designed & developed various ad hoc reports using (Oracle SQL, and MS Access).
• Involved in writing stored procedures and packages using.
• Extensively developed Unix Shell scripts to run batch Jobs and communicate the messages to the users
• Tuned the queries to improve the Performance of the existing reports for various functional areas.

Environment: UNIX, Teradata, SQL, SAS, Oracle, MS-Access, MS-Excel, MS-Office, Microsoft Visio

Confidential

SAS Developer

Responsibilities:

• Reading raw data, Validating, Manipulating from Flat Files and Creating Tables in Oracle Database Analytical Environment.
• Creating Monthly Business Reports by writing Oracle SQL.
• Documentation the Process and Steps for creating reports.
• Developed data maps for retrieval of information from existing account systems.
• Outlined security measures for accessibility and transmission of information.
• Wrote SQL queries to verify the system functionality and provided the users with the needed data and information during operational phase.
• Worked on creating shell scripts efficiently.
• Physical database design and tuning.
• Adhoc reporting.
• Developed and implemented new ways for determining which diagnoses were pre-existing conditions and the environmental factors affecting individuals participating in the program.
• Created and maintained data management and statistical report programs.
• Created data sets from raw data sets for the analysis of safety and efficacy data using SAS to access remote clients.
• Generated interpretive summaries, charts, tables and listing reports in accordance with regulations.
• Drew conclusions based on analysis. Prepared manuscripts upon study completion, as well as various management reports.
• Worked extensively with business users on requirements gathering, analysis and documentation.
• Interacted with clients, modelers and analysts to define targeted populations and control groups.

Environment: Oracle 8i, Word, Excel, Power Point, UNIX, Mainframes,Windows NT.

Confidential

Data Analyst

Responsibilities:

• Worked directly with end users to gather Business requirements,
• Design and develop a front application in VB 5.0.
• Designed and developed Search and View screens and did field level validations for all the fields used in the application using VB6.0.
• Perform data manipulations and scrubbing. Unix, BTEQ and KSH scripting
• Designed the database in MS Access (Creation of Database, tables, views and Procedures).
• Performed validation testing and UAT to produce clean and consolidated results.
• Manipulated and updated the tables as per specifications and extensively used stored procedures.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.
• Came up with methods to improve functionality and effectiveness of the code by brainstorming with other team members during team meetings and discussions.
• Assisted the DBA with scheduling jobs, running various scripts related to space management
• Assisted in documenting User Manual and facilitate UAT and provide follow up to resolve the issues
• Automating reports using MS Excel with ODBC Connection.
• Scheduling SQL Job to run at night times.
• Designed and developed a metadata driven automated reporting system

Environment: Visual Basics 6.0 MS Access, Word, Excel, Windows