SUMMARY

• Certified Data Analyst/SAS developer with around 8 years’ experience in Systems & Technical Analysis
• Handled SAS procedures, macros, merges, data steps for data cleaning, formatting and ad hoc reporting
• Proficient in SAS programming procedures like with SQL, REPORT, ACCESS, GPLOT, GCHART, FORMAT, TABULATE, APPEND, TRANSPOSE
• Experience with SAS/BASE, SAS/MACROS, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/SQL and SAS/ODS in Windows, Mainframes and UNIX environments
• Ability to produce HTML, RTF, CSV and PDF formatted files using SAS/ODS
• Widely used SAS to read, write, import and export to other data file formats, including delimited files, Microsoft Excel, PDF and access tables
• Created ETL design specification document to load data from operational data store to data warehouse
• Strong skills in SQL, Data Warehouse, Data Extraction, Data Validation, Reporting and Excel
• Expertise in MS Office Suite
• Extensively worked in creatingMicroStrategyReports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups)
• Expert UI designer specialized in developing visually stunning Micro Strategy Dashboard using Report Service
• Expertise in Business Intelligence Applications using Oracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.x/11.1.1.x)
• Goodworking knowledge of ETL ToolInformaticaandIBM Datastage,good in handling data loading from various sources to target
• Experience with QlikView sheet objects - Pivot, List, Multi box, multiple charts types, KPIs, custom requests for Excel Export and Fast Change, and objects for Management Dashboard reporting
• Utilized Teradata SQL, BTEQ for the backend process to build the business rules
• Generated numerous Volatile, Global, Set, Multi Set tables
• Familiar with aTeradataDatabase environment (Large Database, Thousands of Tables and Views)
• Experience with IBM Teradata SQL Assistant, Oracle, and IBM Mainframe QMF & SAS applications in development, reviewed SQL Queries & conditioning of accounts for each releases
• Worked with Targeted Marketing Campaigns, Online Banking, Global Investment, AML/Regulatory Compliance, Performance Analytics, Reporting, Capital Markets, Debit Card, Credit Card, Deposits, Funds Transfer and Client Information Systems
• Good statistical knowledge of descriptive models including various sorts of mixed models and predictive solution models including linear, multiple regression models

TECHNICAL SKILLS

Platforms: Windows, UNIX, IBM Mainframe

Software: SQL, SAS, Base SAS, SAS/Macro, SAS Enterprise Guide, Stored Procedures/DLL, Stored Procedures/DLL, TOAD for Oracle, HTML, XML, VBA, Java script, VSS (Visual SourceSafe), Teradata SQL Assistant, SQL Analyzer, Ultra-Edit, SAS Information Delivery Portal, SAS Web Report Studio, SAS XML Mapper

Database: SQL Server, MS Access, Oracle, Teradata

Desktop: Excel, Word, Outlook, Powerpoint, Visio, Publisher, Lotus Notes, SharePoint, Info path, TortoiseSVN

Testing Tools: HP Quality Center/ Mercury Test Director

Methodologies: SixSigma DMAIC

SAS Procedures: Datasets, Append, Compare, Print, Means, Univariate, Correlation, Regression, SQL, Report, Freq, Sort, Tabulate, Format, Import, Export, Transpose, Compare, Gplot and Gchart

Scripting: UNIX Shell Scripting, Perl, VB script, VBA, JSP, JCL

Languages: SQL, JCL, XML, C, C++

SAS Expertise: SAS v9.0, 9.1, 9.2, 9.3 SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/REPORTS, SAS/CONNECT

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

Business Intelligence Tools: QlikView, Tableau, Hyperion Brio, Cognos, OLAP Cubes, Micro Strategy, OBIEE

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

Data Analyst

Responsibilities:

• Involved in payment integrity service analytics workflow system for overpayment of health claims
• Primary responsibility is to develop and manage ETL processes on a daily basis
• Performed code review and data validation for items and entire version history regularly and update the results with the help of SAS Enterprise Guide
• Actively helped in data migration to a new environment for faster performance due to more frequent refreshes and less disk usage utilizing several SAS procedures and Macros
• Generated standard reports using Stored Processes and SAS programs and delivered using SAS Information Delivery Portal
• Generated Adhoc reports using SAS Add-In for Excel and SAS Enterprise Guide
• Monitored the workflows of several requirements through evaluation, analysis, design, build, test, approval and deployment stages
• Managed the nightly update of data tables and views in the backend
• Created various SAS codes in the form of templates for specific tasks in required datasets
• Handled complex SQL queries and table joins using PROC SQL in SAS
• Supported standard and adhoc reporting changes, break-fixed and developed enhancements based on requirements in each quarter
• Coordinated with different teams for data cleanup across various tables and databases for better performance and management
• Gathered information for all the workflows and non-workflow tables and generated spreadsheets for further analysis of its contents and maintenance
• Checked for duplicate items and worked with regular expressions by mapping it in accordance to the frontend i.e. SharePoint
• Efficiently managed and coordinated the Subversion repository with other business and SAS teams to update for daily ETL runs
• Dealt with running SAS programs on UNIX platform and SAS Enterprise Guide on Production, Development and Stage servers
• Created documentation for various process flow and protocols to aid the testers and users to perform their tasks in a homogeneous and efficient manner

Environment: ETL, SAS Enterprise Guide, UNIX, UltraEdit, Reflections SSH console, SharePoint, SAS Add-In for Excel, MS Office Suite, SAS Information Delivery Portal, Stored Processes, TortoiseSVN

Confidential, Columbus, OH

Data Analyst

Responsibilities:

• Actively involved in list production for various customer campaigns of products and marketing
• Efficiently coordinated with marketing department to finalize launch of targeted campaigns
• Developed Macro programs to clean, validate and update data for data analysis generation of reports
• Altered existing datasets using set, merge, sort, formats, functions and conditional statements
• Debugged and documented ad hoc reports on demands
• Worked with options like DROP, KEEP and RENAME for functionality of some variables
• Extended database support to the modeling and production team
• Performed QA audits to ensure the validation of delivered files with respect to the business requirements
• Generated HTML codes using VBA
• Imported/exported large amounts of data to and from Teradata
• Utilized ODBC for establishment of connectivity to Teradata & MS Excel for automating reports and graphical representation of data to Business and Operational Analysis teams
• Built various types of Grouped reports, List Reports, Cross Tab Reports, Chart Reports using Cognos
• Analyzed business requirement document LLDs and HLDs of both clients from technical and business perspectives
• BackeduptheCognosmodel and reportsperiodically
• Designed, developed and implemented multiple mobile applications for MicroStrategyusing various visualizations
• Designed the ETL process for loading the denormalized tables usingInformatica Powercenter 8.1 and made use of PL/SQL stored procedures
• Worked in development of Mappings, Sessions, workflows, Pre and Post session scripts inInformaticaPowercenter 9.5
• Workedin performance tuning ofInformatica(sources, mappings, targets and sessions) and tuning the SQL queries
• Created and delivered recurring as well as ad hoc marketing campaign programming within stipulated timelines under dynamic requirements using SAS, SAS SQL and Teradata SQL in UNIX environment with Oracle, Informix and Teradata relational databases.
• Queried QMF in IBM Mainframe Environment for data analysis purposes
• Used FTP (File Transfer Protocol) to exchange files across several platforms
• Analyzed the web-based product offering engine financial applications for the generation of credit card campaigns and mobile payment applications
• Extracted data with the help of SQL queries for metrics reporting from Loss mitigation, Recovery and Business Banking systems
• Developed analytical processes, statistical models and quantitative approaches for automated reporting capabilities

Environment: SAS Enterprise Guide, Teradata, Tableau, Oracle, UNIX, QMF, QlikView, Hyperion Brio, Business Objects

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Performed end-to-end marketing campaigns in design & coding and analyzed post campaign results
• Developed campaign populations for multiple channels - Email, OST, Splash pages and Secure Messages
• Provided campaign population insights and coordinated with marketing analysts
• Dealt with the specifics to develop the reports by writing SQL Queries and using MS Excel, Power Point and UNIX
• Involved in Requirement gathering & designing QlikView applications.
• Gathered data sources likeQVD files, Excel,MS Access,Oracle & Teradata DWs, binary QVW, Inline & txt filesin developing the QlikView Data Models.
• Created client specific training documentforcognosreport studio, query studio
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Generated Pivot tables in MS Excel and charts/tables in MS PowerPoint using the OLAP cubes for the business users with the help of SAS for MS Office plug-ins
• Wrote several SQL Queries for ad hoc data pull request
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB properties
• Gathered requirements forOBIEEDashboards
• Installed and upgraded of Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Built several Teradata objects such as Tables and Views
• Maintained campaign analysis reports for end-users with the help of SAS and MS Excel
• DevelopedSAS PROC SQL code to transform the original to target datasets for complex applications using ETL process
• Performed data analysis for global consumer and small business AML/Regulatory Compliance
• Demonstrated the understanding of business rules to identify high risk factor for customers
• Queried and researched the Teradata Data Warehouse (the W) and Bacardi (Card) databases using SQL Assistant and MS Access.

Environment: Teradata, Oracle, UNIX, ETL, Tableau, Business Objects, Qlikview, MVS, VBA, Mainframes

Confidential, Hartford, CT

Data Analyst

Responsibilities:

• Supported RDB, an MS Access database which extracts, transforms and loads (ETL) Deals data from Oracle data sourcing systems and the Deals Data Mart
• Extracted data from an existing data source and performed ad hoc queries using SQL, MS Access and UNIX
• Designed & developed several departmental reports with the help of SQL and MS Excel
• Migrated data from Flat Files to Oracle database by designing scripts in SASfor compatibility withOracle
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the Qlikview Publisher.
• Implemented distributedcognosenvironment Maintenance ofcognosserver
• Created dashboard style of layouts using different components of Qlikview Enterprise such as List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Involved in optimizing existing QlikView dashboards with primary focus on usability, performance, long-term, flexibility, and standardization
• UsedMicroStrategyDesktop to develop publicobjects such as reports, metrics, filters, prompts, customgroups etc.
• Incorporated the business process in different layers ofOBIEEi.e. Physical Layer, Business Layer and Presentation Layer anddeveloped customized dashboards inOBIEE
• Experienced in working with Qlikview extensions such as Word Cloud, Word Map.
• Implemented Performance tuning by analyzing the turnaround times between SQL and Qlikview
• Connected to Mainframe andOraclefrom SASusing Macros
• Queried on the Teradata database to provide ad-hoc reports using SAS/SQL
• Conversion of existing data models into new data models using VBA Macros
• Created tables, indexes, views, snap shots, database links to access the required information
• Worked on Pivot tables and VBA to write macros in Excel
• Developed SQL queries for data retrieval from relational databases for quality control reviews against the original source data
• Coordinated with the market research and analysis team for customer segmentation and targeting of various products
• Assisted in developing regression models for better decision-making on the consumer purchasing pattern
• Validated and updated data to perform statistical data analysis and reporting
• Created SAS MACROS for applications to customize SAS software programs and used the existing ones for standard reporting
• Combined and maintained large data sets from several sources in varying formats using set and merge
• Developed queries using PROC/SQL for specific data retrieval
• Performed data mapping, transformation, validation and documentation
• Facilitated, researched, tested and deployed systems requests for Client Metrics' customized reporting used in upper level management decision-making
• Created and executed SQL data extraction queries against production Oracle databases using TOAD

Environment: SAS Enterprise Guide, Teradata, Oracle, Business Objects, MVS, UNIX, VBA, QMF, SQL, HTML, MS Excel, MS Access, Qlikview, Tableau, Lotus Notes

Confidential

SAS Programmer

Responsibilities:

• Developed data analysis systems, processes and measurements for Business Unit operations and supported strategic reporting requirements using SAS, JCL and Teradata SQL in a mainframe environment
• Interacted with data sets across different platforms
• Coordinated with the end-users to gather Business requirements
• Dealt with data profiling and developed meaningful extracts by recognizing inconsistencies in data and processes
• Performance tuning by analyzing and comparing the turnaround times between SQL andQlikView.
• Gathered data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing theQlikViewData Models.
• Developed and Maintained ofcognosFramework model for various client
• Maintained ofcognosserveron distributed environment
• DevelopedQlikViewDashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Developed KPIs and set analysis applications. Experience in UsingQlikViewFunctions (Date and Time, Keep, Join, Mapping, String & input Fields etc.)
• Developed User Interactive Sheets & Reports as business needs and wrote SQL Scripts to load the relevant data inQlikViewApplications
• Examined the existing SAS procedures and SQL queries/scripts for improvisation
• Generated SAS scripts and SQL queries based on inputs from analytics/development team
• Researched existing Consumer and Small Business Card to facilitate the automation of defect and dashboard reporting
• Actively involved in effort estimations, project planning, coding, unit test, delivery & support for MS Excel, MS Access based VBA applications being an initiative of Technology with Operations
• Performed data manipulations in various environments
• Designed the database in MS Access (creation of database, tables, views and procedures)
• Performed validation testing and to produce consolidated results
• Manipulated and updated the tables as per specifications and extensively used stored procedures
• Documented scripts, specifications, other processes and prepared Technical Design Documents
• Worked on the mainframe - SAS environment & PC SAS (Windows Environment)
• Introduced methods to improve code efficiency along with other teams
• Assisted the DBA with scheduling jobs, running various scripts related to space management
• Automated reports using MS Excel with ODBC Connection
• Designed and developed a metadata driven automated reporting system

Environment: SAS Enterprise Guide, Qlikview, OBIEE, Teradata, MS Access, MS Word, MS Excel, Windows, Mainframes

Confidential

Data Analyst

Responsibilities:

• Utilized BASESAS,Macros,SASEnterprise Guide andSASSQL for programming
• Modified macros for report generation usingSASMacros based on the requirements
• Programmed withSASEnterprise Guide query builder for constructing complex queries analysis
• Used Data Null andSASprocedures extensively such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad hoc and customized reports and external files
• Worked with complex datasets to extract customized reports using PROC SQL, PROC SORT and PROC REPORT, PROC TABULATE for creating a preferred list of customers
• Comprehended production codes, undertook diagnosis, resolution of complex issues and improve the efficiency of processes
• Maintained theCognosserver and provide the support for users.
• Developed business domain expertise and independently delivered end to end on complex projects and assist in the design of new information infrastructure
• Managed end-user expectation in the delivery of projects within agreed timelines and quality standards
• Created SQL views for retrieving and updating data dynamically
• Maintained and documented large data sets in various formats to create SAS data sets and/or ASCII files
• Ensured adherence and constant improvement in QA/QC framework
• Used SAS system macros for error handling, code validation, date stamping of log files, collected files to a given directory and scheduling
• Developed business and technical knowledge of team members and identified opportunities of improvement

Environment: SAS, Mainframe, BASE/SAS, Cognos, OBIEE, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle, Windows