SUMMARY: Having 7+ years of design and development of analytical solutions and data analysis with profound expertise in banking/finance, retail and energy related industries. Strong expertise in analytical and quantitative techniques including predictive modeling and multivariate analysis. High-level experience in Base SAS, SAS/Macros, SAS/SQL, SAS/STAT, SAS/Connect, SAS/Access, SAS/GRAPH, SAS/ETS, SAS/ODS, SAS EG. Strong expertise in SAS Base procedures, reporting and Summary procedures. Experience with PROC SQL, SAS DDE and SAS arrays. Expertise in using SAS Indexes to reduce processing time for large volumes of data. Expertise in using SAS views to reduce I/O bottlenecks and in-turn minimizing operational time of the tasks. Extensive experience in using RDBMS Oracle, MySQL. High-level expertise in SAS 9.1.3, SAS BI and SAS Data Integration server and studio and reporting tools Web-Report studio. Expertise in using SAS MP-Connect (Multi Processing) to reduce 40%-50% time in generating reports/Application execution time. Proven skills in SAS EBI suite for creating and managing reports and models and OLAP cubes and OLAP tools and others report tools like Web Report Studio. Expertise in Time series and forecasting techniques using SAS/ETS and Enterprise Miner. Monitoring model performance, assessing quality and making recommendations. Strong Knowledge in advanced analytics and Text and Data mining Techniques. TECHNICAL SKILLS: Statistical Software : SAS V8.2, SAS V9.1.3, Base SAS, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ETS, SAS/IML, SAS BI Server and SAS Data Integration Platform, SAS Forecast Studio, SAS Enterprise Guide, SAS OLAP Cube Studio, WRS. Programming Languages : SQL, MATLAB, VBA, C, C++, JAVA, PERL Databases : Oracle, MySQL, MS-Access. Operating Systems : Windows 9x/NT/2K/XP, DOS, UNIX, Linux, IBM OS/390 Internet Technologies : J2EE, JSP, Servlets, HTML/DHTML, XML. EDUCATION: Masters in Mathematics and Computing from University Of Hyderabad, India. PROFFESSIONAL EXPERIENCE: TXU/Luminant Energy – Dallas, TX Dec ‘07 – July ‘08 Role: Senior SAS Consultant TXU Energy is the #1 Choice in Texas, providing electricity and related services to more than 2 million Texas customers. We are responsible for designing and development of different processes for publishing the gas, power, NGE positions and PnL reports on daily, weekly and monthly reports as well as ad-hoc reports. The source of data includes Zainet and Off-System files and flat files. And automation of Excel/manual processes to SAS and VBA. Responsibilities: Designing the new processes in SAS and VBA for new business units. Analysis and building Risk-Metrics using SAS/IML and SAS/ETS and Base SAS. Building Monte-Carlo simulation techniques for Risk-Metrics using SAS/IML. Development and automation of daily Position and P & L Reporting processes for different commodities of TXU Energy Market using Base SAS procedures and VBA. Integration / synchronization of daily P&L reports with financial forecasts. Providing and reporting the performance of existing processes which are Excel and converting into SAS processes. Review existing reporting outputs to validate current deliverables prior to publication. Ensuring the accuracy and timeliness of daily PnL and position reporting using SAS reporting procedures and VBA tools. Automation of Data Extraction, Transformation and Loading the results to final datasets using Oracle, SAS and SQL. Used advanced techniques to reduce the execution of processes times in SAS and MP-Connect, SAS/Access. Summarizing the results and data with PROCs FREQ and MEANS. Doing Statistical Analysis with statistical procedures and univariate procedures from Base SAS, SAS/STAT and SAS/IML. Creating Reports and reporting results with PROC REPORT and ODS. Scheduling day-to-day and weekly processes of reports using Windows Scheduler. Communicating the day-to-day results to senior managers. Technical Environment and Tools Used: Base SAS, SAS Macros, SAS/Access, SAS/STAT, SAS DDE, SAS ODS, VBA for Excel, SAS/GRAPH, SAS/IML, ORACLE, SAS V9.1.3, SAS Indexes, SAS Views, SAS MP- Connect, SAS Enterprise Guide, Excel, Windows XP, UNIX. JDA Software Inc. – London, UK Oct ‘06 – Sep ‘07 Role: SAS Programmer Analyst A Network Promotions is one of the product developed by JDA Software Inc. helps companies to develop, evaluate, and monitor optimal promotional strategies to meet desired business objectives and also helps businesses to maximize their marketing ROI by supporting analysis, development and optimization of promotional offers using advanced statistical and mathematical techniques. Responsibilities: Plan and execute implementations with JDA applications including Demand and Promotions. Develop Statistical and Mathematical models to support of software and business process implementations with SAS and SAS/STAT, SAS/ETS. Assist clients and partner integrators in data mining very large databases Provide implementation guidance for data modeling using SAS tools and techniques. Create functional batch specifications for Promotions. Scheduling the promotions process on UNIX server using cronjob scripts and batch scripts. Build Market Response Model (MRM) and Forecasting Model using regression methods and Time series methods for retail industry. Recommend and implement data process improvement using advanced techniques. Extracting the data-patterns and Trends from Sales data using SAS V9, Oracle DBMS. Mine internal and external customer data to uncover sales opportunities. Analyze and report promotional results. Statistical validation of the forecast results using error estimation techniques. Analyze and report promotional forecasts and results. Interpreting the results then report and present findings based on the trends in the data. Respond appropriately and promptly to quality-assurance issues and concerns. Technical Environment and Tools Used: Base SAS, SAS Macros, SAS/Access, SAS/STAT, SAS/ETS, SAS DDE, SAS ODS, VBA for Excel, SAS/GRAPH, ORACLE, TOAD, PL/SQL, SAS V9.1.3, SAS Indexes, SAS Views, SAS Enterprise Guide, SAS MP-Connect, Excel. GE Capital International Services – India Nov ‘05 – Oct ‘06 Role: SAS Analyst Design and Delivering analytical marketing solutions and statistical models for GE Americas Dual Card business which includes acquisition models, cross-sell and up-sell marketing models, segmentation and targeting, activation and Lifetime Value Models for different portfolios WALMART, JCP, BROOKS, SAMS using Linear Regression, Logistic Regression, classification trees and other advanced statistical techniques. Responsibilities: Conducting analysis on client consumer databases looking at profitability, transaction behavior, and demographic characteristics. Providing segmentation for database marketing efforts, such as CHAID, cluster analysis, and customer profiling. Responsible for statistical applications support and programming primarily in SAS, supporting Marketing team in ACOE. Generating Regular, Ad-Hoc Reports using SAS Tools and Oracle. Write macros to organize data files to business specifications within standard office applications such as Excel, Access, Word, and PowerPoint. Building Statistical Models, predictive models and Regression Models using SAS Tools. Automation of MIS Reporting systems. Work collaboratively with Data Processing to define data structures and content (i.e., file layout) and validate data integrity using UNIX, PERL. Developing Acquisition Models based on demographics data, sales data and internal and external data sources. Giving Internal Training for business users and Analysts in SAS and VBA programming and other software tools. Create and maintain predictive and multivariate models in SAS BI suite. Setting up and scheduling processes using cronjobs in UNIX and Solaris. Setting up and scheduling Stored Procedures in SAS BI server and SAS Data Integration Server. Technical Environment and Tools Used: SAS V 8.2, SAS V 9.1.3, Base SAS, SAS Macros, SAS/Access, SAS/STAT, SAS/ETS, SAS DDE, SAS ODS, VBA for Excel, SAS/GRAPH, ORACLE, TOAD, PL/SQL, SAS V9.1.3, SAS Indexes, SAS Views, SAS MP-Connect, Excel, SAS web reporting tools from SAS EBI. Global Analytics Inc. – India July ‘04 – Nov ‘05 Role: SAS Programmer Global Analytics is a leading provider of innovative predictive analytics and risk management solutions. The Global Analytics has developed and deployed cutting edge solutions to address a wide range of business needs including: minimizing risk, enhancing human resources management, improving lending decisions and automating decisions by Internet sites. Global Analytics provides predictive models, real-time decision software and consulting services. Global Analytics adopts diverse business models suited to the technical and economic needs of specific solutions Responsibilities: Gather data from various sources and conduct data manipulation in order to analyze the effectiveness of business strategies. Design, develop and deploying the statistical Models using SAS and JAVA and MySQL and PERL. Building Response, Activation and Cross-Sell statistical models. Segmentation and Targeting Analysis using Decision Trees. Design and Development of score models using JAVA and MySQL and VBA for MS- Tools. Conducting analysis on client consumer databases looking at profitability, transaction behavior, and demographic characteristics using SAS/Base, SAS/STAT, SAS/SQL, SAS/Macros, MySQL Database. Designing, implementing, and testing project-wide programs in SAS and high-level programming languages for data management and basic statistical analysis. Training in programming for statisticians in statistical packages and other software. Design and Development of score modules using JAVA and MySQL. Developing a software tool that enables users to flexibly define and score new portfolios. Support and Tracking the model performance time-to-time and report the findings to senior management. Technical Environment and Tools Used: SAS V 8.2, Base SAS, SAS Macros, SAS/Access, SAS/STAT, SAS/ETS, SAS DDE, SAS ODS, VBA for Excel, SAS/GRAPH, ORACLE, TOAD, PL/SQL, SAS V9.1.3, SAS Indexes, SAS Views, SAS MP-Connect, Excel, Core JAVA, MySQL DBMS. CAS (P) Ltd., - 1st credit of America – India June ‘02 – July ‘04 Role: Software Programmer This is an “agent” type 3rd party collection agency who is interested in prioritizing their customers based on their demographics and behavioral information at any snapshot date. This will enhance the efficiency of their calling procedure and hence generate a better optimization of the resources. A logistic regression model was built for these customers. The resulting score of this procedure was further incorporated into a "performance metric" to further validate the robustness of the model. Estimating expected collection revenues at the account and portfolio level. Responsibilities: Rank accounts according to likelihood of successful collection based on demographic and payment history using SAS/Base, SAS/STAT, SAS/Macros, SAS/ODS, SAS/SQL, VBA, MySQL DBMS. Determine the value of the accounts in a given portfolio (both before and after purchase). Determine when it is cost-effective to purchase external data (at the account level) so that the ROI at account level will be profitable. Determine best collections actions and resources to apply to each account Detect high-risk accounts early on, before they fall into collections processes Development of programming specifications through interaction with business unit subject matter experts Deploy changes to production and non-production environments. Determine best collections actions and resources to apply to each account. Design and Development of score models using JAVA and MySQL and VBA for MS- Tools and UNIX scripting and PERL scripting. Provide full application support / analysis for third-party software applications and monitor the performance of the production models. Technical Environment and Tools Used: SAS V 8.2, Base SAS, SAS Macros, SAS/Connect, SAS/STAT, SAS DDE, Windows, Linux, Sun Server, MS-Office, Excel, VBA for Excel and PPT, Shell Scripting, Crontab for Unix, SAS ODS, JAVA, Core JAVA, PERL. Cobra Analytic Solutions – India May ‘01 – June ‘02 Role: Analyst and Programmer DP BUREAU provides financial institutions, consumer finance companies and retail merchants with innovative products and services which effectively assess risk and reward in offering consumers delayed debit transactions and other financial services. DP BUREAU’S solutions make it profitable for a merchant or underwriter to instantly extend “debit item float” to a consumer at the point-of-application or point-of-sale. Responsibilities: Conducting analysis on client consumer databases looking at profitability, transaction behavior, and demographic characteristics using SAS/Base, SAS/STAT, SAS/SQL, SAS/Macros, MySQL Database. Designing, implementing, and testing project-wide programs in SAS and high-level programming languages for data management and basic statistical analysis. Designing and developing Scoring modules to fit into vendor specific applications and Web based applications Training in programming for statisticians in statistical packages and other software. Design and Development of score modules using JAVA and MySQL. Developing a software tool that enables users to flexibly define and score new portfolios. Support and monitoring the performance of models and re-assess the results and report to Take-holders. Perform insightful analysis of campaign results, draw conclusions, and make recommendations for future marketing strategies. Technical Environment and Tools Used: SAS V 8.2, Base SAS, SAS Macros, SAS/Connect, SAS/STAT, UNIX, Windows, Linux, Sun Server, MS-Office, Excel, VBA for Excel and PPT, Shell Scripting, Crontab for UNIX, SAS ODS, JAVA, Core JAVA, PERL.