Summary

• 10 years of architecture , implementation experience in data mining, business intelligence including analytics Overall 12 years of strong experience in BI/Analytics with SAS as focus area
• In-depth expertise with SAS family of tools BI, Data Integration Studio, OLAP Studio, Information Map studio, Web Report Studio, Enterprise Miner, Data Flux etc., , SAS Profitability Management cost Management.
• Experience in SAS Management Console, SAS Foundation Base SAS MACROS
• Experience in advanced programming in SAS including SAS/Macros, knowledge of Data Extraction, Transformation, and Loading ETL from disparate Data sources like Multiple Relational Databases Oracle, Teradata, Sybase, Netezza, SQL Server, and MS Access.
• Experience in SAS/EG, SAS/BI, SAS/ETL, SAS/OLAP, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/Connect, SAS/Share, SAS/EIS, SAS/Stat, SAS/QC, SAS/STAT, SAS/AF, SAS/PC.
• Experience in SAS predictive modeling, SAS Stat/Miner Advanced analytics.
• Defining infrastructure requirements such as storage Network storage as large as 150 TB , computing, LDAP, network needs and work with Infrastructure Engineering t design and implement solution.
• Designed, Developed and maintained applications using SAS Anti-Money Laundering AML , Visual Analytics while working for Aithent.
• Experience in working within an enterprise data warehouse environment or Big Data architecture, advanced data mining and predictive modeling skills like regression, segmentation.
• Experience in Campaign marketing research, Customer facing applications with experimental test design i.e., prototype using A-B split, full factorial fractional factorial , while working for Apple Inc., EBay, Wells Fargo, USAA.
• Extensively used SAS Marketing Automation tool 5.0/5.1/5.2/5.4 t create manage single/Multichannel campaigns t check marketing activities and effectiveness, Return on Marketing Investments ROI t help campaign management team t target segments and execute campaigns and t create Models.
• Implemented SAS Marketing Automation using SAS Campaign Web Studi for outbound inbound management, Digital marketing campaign management.
• Experience in visualizing the data through graphing charting i.e., web-based information using MS-Excel, Power Point MS-Visio.
• Created Multivariate Relationship Models like Correlation Cluster Analysis for table Analysis and reporting tasks using Enterprise Miner with SEMMA methodology, sampling Methodology, exploratory Data Analysis, and SAS Business Intelligence in a design role having handled end t end cycle.
• Performed full Software Development Life Cycle SDLC responsibilities including gathering and analyzing requirements, designing and developing Business Intelligence application software.
• Supported large user base More than 1200 SAS users and More than 600 SAS BI users and provided support on access, security, Role Management, Performance and Auditing activity on the Production servers.
• Experience in creating metadata for source data, target data and jobs and working in SAS Grid environment.
• Strong understanding and experience of reporting and analysis including data models, OLAP cubes MDX , ROLAP, Information maps web reporting like Stored process and web report studi , plug-ins, SAS BI dashboards, SAS Portal, metadata queries and SAS procedures.
• Experience in development of SAS 9.3/9.4 platform, ETL, Databases, reporting concepts expertise of in-database techniques.
• Data extraction, scheduling / automation, Dimensional Data Loading , Report Generation , transformations, tables and table loader transformation, as well as slowly changing dimensions.
• Expertise in development and programming support for the SAS Platform including marketing initiatives including Direct Marketing Telemarketing campaigns.
• Expertise with SAS server Backup/Restore, with provision of the daily maintenance and disaster recovery technique on the Production OLAP/OLTP servers
• Experience in various statistical skills such as with Cluster Analysis, Decision Tree Analysis, Linear Regression, Logistic Regression, and Monte Carl Simulation in financial applications.
• Hands-on SAS, SQL, PL-SQL, Oracle, DB2, SQL-SERVER, Teradata, SYBASE, Netezza, Hadoop, Java, J2EE, UML, Perl, UNIX, NET, LINUX C.
• Maintained supported operational performance and ensured that all Base-SAS SAS BI Services, tools and components are available and meet the SLA's.
• Documentation along with understanding of regulatory requirements and maintaining/updating SAS best practices manual regularly with enterprise service management ITIL processes.
• Proven success in building scalable cloud and mission-critical applications for Insurance, banking, financial, Retail B2B.
• Extensively worked on CDISC SDTM Designing reports using the TIBC Brio.
• Ability t interact with clients and product managers t translate requirements int technical solutions subject matter expertise on the platform and its tools.
• Renewing Enterprise Licenses periodically and applying Hot-Fixes with the help of SAS Tech Support, if required.
• Good Communication, Self-Motivated, Client Focused, Technical Troubleshooting, mentoring and training skills ability t transition smoothly between original BI design, engineering and maintenance and testing functions

Experience

Confidential

Responsibilities:

• Maintenance of various SAS software platforms
• Maintaining and troubleshooting infrastructure: operating system, application software, and other related items. Installs new software, and applies software patches, updates, and new releases.
• Researches and recommends new and emerging technologies for increased performance, improved reliability, and reduced costs. Introduced and integrated new technologies int the environment.
• Experience in SAS Migration Up gradation t the Grid environment.
• Worked with the user community 1500 SAS Users t troubleshoot and resolve technical and performance problems.
• Installed maintained SAS profitability Management 2.3 including using it for importing models later using it for in-depth analysis.
• Created Campaigns using the business context using Customer Intelligence Plug-In for SMC.
• Executed Custom Nodes along with the communication on statistically significant sample sizes splitting them by quartiles, deciles decimal percentages.
• Extensively used Customer Intelligence Reporting Data Model for reporting publishing Dashboards.
• Coordination with internal and external teams t stay abreast of technical and business requirements and ensure that systems meet those requirements.
• Employed 'best practices' t reduce risk and improve efficiency.

Confidential

Responsibilities

• Extract data from raw SAS datasets and convert them int project standards.
• Extracting and analyzing data, providing insights, constructing presentations and communicating complex analytical findings in a clear, concise, and decision-impacting manner.
• Analytical support by structuring problems int solutions while getting the data using Hadoop.
• Support the analytic needs of the business by using data from various sources Used SAS AML t prevent Fraud.
• SAS Profitability Management 2.1 tool used for cost analysis, budgeting, data exploration comparing cost by Business Units.
• Provide analysis for line of business owners, metrics owners, operations leadership, and standard and ad-hoc data quality checks across all studies.
• Present analysis strategies t senior management in verbal written forms
• Expertise in CDISC SDTM Designing reports using the TIBCO.

Confidential

• Managed, tracked, supported, developed maintained the SAS 9.2 Analytical products for the whole enterprise including Design, planning and Implementation SAS Grid platform.
• Worked with Enterprise Miner for SEMMA methodology, Sampling Methodology and Exploratory Data Analysis provided guidance and assistance t Statistical developers on operational and technical issues for Statisticians and end users for Analysis and Model Development.
• Involved in coordination with Business Stakeholders, Directors and Lead Architects in getting approval for the list of SAS products licensed in the enterprise framework.
• Experience in statistical visualization techniques, SAS/STAT, SAS/GRAPH for traditional analysis of variance and predictive modeling.
• Resolving any SAS 9.2 related installation issues and further troubleshooting faced by end users.
• Responsible for doing Statistical Models for Customer Management System, forecasting, fraud management, overlooking the SAS Administration and helping client for critical Business decisions etc.
• Expertise in campaign management system with the scoring engine s that the scores are generated.
• Developed the campaign management system, where a user can build marketing campaigns using the predictive models.

Confidential

• Responsible for revamping reporting architecture, migration strategy, and implementation of SAS9 applications based on Oracle and SQL-Server backend. Designed and developed additional customer-facing SAS Reports worked closely with Data managers DBA's t gather information on data sources t properly document Enterprise Relationship Diagrams ERD .
• Experience in architecting the platform configuration by creating SAS Software subsets for the installation of SAS 9.2 thin clients based on role based groups.
• Building and maintaining roadmap for the future of the SAS BI platform and providing IT and business with the latest SAS Enterprise products.
• Created and managed definitions and connections for servers using SAS Management Console creating an environment which provided transparency t back-end operations.
• Used SAS Management Console t manage the creation, replication and promotion of metadata repositories.
• Implemented DataMart Framework UNIX/SAS/SQL processes t support campaign marketing production and new Development Initiatives.
• Coordinated with peer developers in the implementation of new platform for SAS Grid with the help of customer support base in the migration of the projects from the current environment SAS 9.1 t SAS 9.2