SUMMARY

• Over eight years of experience as a Sr. SAS Programmer/Analyst involved in Market/Risk Analysis, Financial Analysis and Data Analysis.
• Expert in using PROC SQL, PROC Report, PROC Freq, PROC Summary, PROC Access, PROC Means, PROC TRANSPOSE, PROC Tabulate, PROC GPLOT, PROC Chart, PROC Datasets, PROC Format, PROC Import and PROC Export.
• Experience in Base SAS, SAS/Macros, SAS/SQL, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ETS and SAS/ODS.
• Extensive experience in SAS Business Intelligence, SAS Financial Management (FM),Campaign Management (CM), SAS OLAP Cube studio, SAS Web Report Studio, SAS Management Console, SAS Enterprise Guide, SAS Enterprise Miner, SAS DI Studio, SAS/FSP and SAS/AF.
• Expertise in Marketing Strategy development, financial models, projections, Basel II Compliance, DSS Decision Support Systems and documentation, Risk Analysis, Correlation and Regression including Multiple regression, Logistic Regression, Multivariate Analysis, Projections, Time series Analysis, Factor Analysis and Forecasting.
• Extensively worked on SAS views and SAS Indexes to reduce I/O bottlenecks and processing time for large volumes of data.
• Strong understanding in various Economic/Econometric and statistical concepts such as ANOVA, Correlation, Regression Analysis and Multivariate Analysis.
• Proven skills in Data Mining techniques, Statistical (Regression), mathematical and econometric models using SAS, STATA, etc.
• Experience in design and developing of SAS programs to analyze and generate Files, Tables, Listings, Graphs, Validations and Documentation.
• Extensive knowledge in data integration and working wif SAS development using GCF (Government Risk and Compliance) and LSF (Load Sharing Facility) wif different clients.
• Used SAS/ETL to create reports from relational database or multi - dimensional cubes.
• Knowledge in data warehousing and business intelligence concepts, design principals Experience in RDBMS development including SQL, PL/SQL languages.
• Proficient in using Import and Export procedures to handle data in raw data files from ORACLE, DB2, TERADATA and SYBASE database management systems.
• Quick learner wif ability to understand job requirements, employs new ideas, concepts, methods, and technologies.
• Strong analytical, diagnostic skills and ability to work in a fast-paced and team-oriented environment.

TECHNICAL SKILLS

Statistical Software & Tools: SAS Enterprise Guide, SAS Enterprise Miner, SAS Base, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ETS, SAS/IML, DataFlux, Web Report Studio and SAS BI Server.

Databases: MS Access, My SQL, Teradata.

Programming Languages: SAS Base, SAS Macros, SAS/SQL, Matlab.

OS Software: Windows 7/Vista/XP and Windows Server 2000/2003/2008.

Software Packages: MS Office 2010/2007, Advanced Excel, MS Exchange, MS Project and MS Visio.

PROFESSIONAL EXPERIENCE

Sr. SAS Consultant

Confidential, NC

Responsibilities:

• Develop and maintain risk area information infrastructure (Datamart)
• Involve in setting up the system requirements and creating the technical specifications for best application performance.
• Install, migrate, configure, maintain and provide technical support including troubleshooting of SAS BI implementations in a shared environment.
• Contribute to architecture and capacity planning activities.
• Provide support to the business community in leveraging the new SAS platform.
• Managing the SAS Projects in order to get the best rate in the SLA, delivery and closing of the projects.
• Develop SAS Programs in order to generate reporting about infrastructure, increase and optimization of resources through dashboards.
• Programming the reports through SAS Data steps, SAS Macro Language and SAS SQL Processing.
• Tune and optimize of the SAS codes through SAS best practices.
• Use SAS Management Console to administrate and configure SAS/Access.
• Generate the reporting for the business areas according to their requirements about infrastructure utilization and optimization through SAS ODS and SAS BI Reporting tools.
• Construction of minable views and data mining analysis.
• Work on creating SAS Data sets from flat files and merging data.
• Client segmentation using decision trees, wif SAS Enterprise Miner.
• Develop of acquisition model to maximize profit wif a sustainable risk level.
• Create BAU reports on general development of the credit card bank.
• Train users in using SAS Enterprise Guide, SAS Enterprise Miner.

Environment: SAS 9.2, SAS Enterprise Guide, SAS Base, SAS Enterprise Miner, SAS BI, SAS Web Report Studio, SAS OLAP, SAS Management Console, SAS/BASE, SAS/MACRO, SAS /STAT, SAS/SQL, Access, Excel, DB2, AIX Server.

Sr. SAS Analyst

Confidential, DOVER, NH

Responsibilities:

• Involved in Business Analysis and Systems Planning.
• Migration of data from text files and DB2 to SAS data sets.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Played a major role in quick generation of Ad-hoc Business Analysis Reports and resolving data issues upon request.
• For data analysis, and BI Reporting application development used SAS DI-Studio, SAS Web Report Studio, SAS OLAP Studio as well as Base SAS and Macro programming.
• Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS for statistical analysis and data display
• Developed custom reports using Data Null and Dynamic Data Exchange (DDE) technique.
• Performed validation testing on newly created datamart using SQL DB2 queries and SAS procedures like proc freq and proc contents.
• Connected to the different systems using SAS NODE through FTP.
• Developed an Automated Quality Control System for Data Validation and data integrity.
• Used ODS statements and PROC TEMPLATE to create reports in style format.
• Involved in various Testing phases (Unit, System and Integration).
• Used SAS extensively to create ad hoc reports, match merge and created graphs by using SAS/GRAPH base.
• Used SAS Macros, PROC SQL to extract, sort; match test accounts and ODS to HTML, PDF and RTF.

Environment: SAS v9.2, SAS/BASE, SAS/SQL, SAS Enterprise Miner, SAS BI, SAS DI Studio, OLAP Studio, Web Report Studio, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, HTML, DB2, MS-Excel, UNIX.

SAS Consultant

Confidential, Seattle, WA

Responsibilities:

• Work closely wif marketing, planning and business development managers to understand business issues and recommend approaches to ensure business questions are properly answered.
• Write high quality code to retrieve and analyze data in SAS using DATA step, PROC's and Macros.
• Identify, develop, manage, and execute analyses to uncover areas of opportunity and present modeled recommendations.
• Maintain quality metrics and perform reviews wif customer and upper management.
• Transform, cleanse and profile data in preparation for Multivariate Analysis.
• Analyze and model statistical relationships. Methods used include: Regression (Multiple, Logistic), Clustering, Segmentation and Decision Trees.
• Perform and automate routine analytical tasks such as Model Validation and Pilot Assessment.
• Ensure data accuracy by validating data for new and existing tools.
• Reporting of key insight trends, using statistical rigor to simplify and inform the larger team of noteworthy story lines.
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for secondary datasets.
• Develop an end-to-end analytical architecture based on customer use case.

Environment: SAS Enterprise Guide, SAS BI, SAS Enterprise Miner, SAS Web Report Studio, SAS/BASE, SAS/MACROS, SAS /STAT, Access, Excel, My SQL.

SAS Developer

Confidential, Atlanta, GA

Responsibilities:

• Developed and scheduled SAS jobs using Shell Scripts / UNIX.
• Created intricate set of SQL tables to hold user login and user access information wif constraints and access errors were logged in to error tables.
• Involved in SAS Administration.
• Acquired financial raw data from Oracle and DB2 tables and loaded the data into SAS datasets. Used Macro routines to convert different types of source file (Excel, Word, and Text) to produce SAS reports and graphs.
• Designed and built Enterprise data model by integrating datamart conceptual logical models.
• Provided enterprise data model access given to application developers, database designers and end users through Modelmart.
• Used Proc Dbload, Proc SQL, Proc import, Proc export statements to load SAS data sets from and to DB2and Oracle 9i.
• Provide statistical programming expertise in the production of datasets, analyses, tabulations, graphics, and listings from client’s data.
• Created edit check programs to find discrepancies in a raw dataset provided by Data Management Group.
• Responsible for the development of a Budget Data Mart for the Finance Department.
• Used SAS Access to ORACLE feature for large data extractions (SQL-Pass thru), PROC DBLOAD.
• Involved in various phases for segmentation and response analysis used for direct marketing campaigns.
• Forecasted impact of direct market campaigns for acquiring, developing and retaining customers using SAS.
• Developed and maintained SAS Web Reports for sales data based on the requirement.
• Implemented data management plans designed to meet project deadlines.

Environment: SAS 8.2 (SAS/Access, SAS/Connect, SAS/Stat, SAS Enterprise Guide, SAS/Graph, SAS/SQL, SAS/ODS, Information Map Studio, SAS Web Report Studio, Oracle 9i, DB2, MS Excel.

SAS Programmer

Confidential

Responsibilities:

• Created database conversion programs for clinical studies according to the Data Management Plan (DMP), tracked each receipt of non-CRF data, assisted in the process of locking & freezing databases, sent interim, frozen and final databases to client.
• Responsible for data collection, management and manipulation of clinical trials database for Phase 1 clinical trials.
• Performed statistical analysis, wrote SAS code for data management and reporting, and performed validation, including testing SAS code for Phase 1 clinical trials.
• Created standardized datasets from the existing datasets.
• Created and modified SAS macros.
• Involved in CRF review and quality check.
• Compared consistency of SAS variables, formats, and format codes across multiple studies.
• Performed Validation checks for accuracy and integrity of clinical data.
• Created Summary Reports and Tabular Reports using Proc Report and Proc Tabulate.

Environment: BASE SAS, SAS Macros, SAS/Access, Oracle, Windows, MS-Access.

Manager

Confidential

Responsibilities:

• Resolved Microsoft desktop applications (Word, Excel, Power Point and Outlook) issues under level 2 support for over 500 users.
• Led network and halpdesk team to manage and troubleshot 500 plus-user enterprise network and information security systems for 24/7 availability.
• Provided technical assistance to 500 staff, assisting wif network access, printing, and application software operation.
• Provided technical support for specialized hardware and software systems used in the pharmaceutical industry.
• Set up local area networks for Confidential, Dhaka Head Office and 13 Sales Locations.
• Administered primary and back-up domain controllers, file servers, print servers, proxy server, and e-mail server.
• Create Database for “Hardware Replacement Program” across the company’s national network.
• Established and administered IT security policies.
• Maintained accurate documentation of all corporate hardware and software assets to facilitate customer support and problem resolution.
• Monitored and supported MS Exchange servers proactively in two sites.
• Maintained Print Server and print devices and Configured local and network printers.
• Provided support and planning for critical requirements including: Network Administration, Computer Builds, Software Loads, Product Testing, Telephony, End-User Support & Training, Vendor Relations, Project Management.
• Directed a team of PC Technicians, a Network Administrator / Analyst, and five Help Desk personnel in the management of all facets of information technology.
• Coordinated the SAP migration to Confidential from BPCS Sales ordering system.
• Ensured Microsoft Server operating systems update including patching, backups and maintenance
• Configured network servers and trained local administrators on standard network server procedures, including virus protection and other security measures