SUMMARY:

• Data Warehousing professional with 10+ years experience in SAS Business Intelligence tools, data analysis, business reporting, and project management.
• End - to-end expertise installing, configuring, implementing, and maintaining SAS Enterprise BI, Data Integration, and Visual Analytics reporting solutions.
• Played varied roles (including SAS Architect, Analytics lead, SAS Admin, Technical Delivery Manager, Developer, QA Manager, Production support specialist) for Insurance, Banking, Pharma client using different SDLC methodologies.

TECHNICAL SKILLS:

Skills: Base SAS, Macro SAS, SAS/Connect, SAS/Access, Unix, Business Objects, Teradata, Data Stage MQ Series, LSF Scheduler. I have also worked on Data Integration Studio, SAS Enterprise Guide, Information Map Studio and have also experience in SAS Web Report Studio and SAS Management Console, SAS Visual Analytics, qlikview, Microstrategy, ESRI reporting.Project Planning & Management, Estimation, Configuration & Release Management, Resource Planning, Capacity Planning, Co-ordination, Mentoring Team members, Quality Assurance & testing activities.

PROFESSIONAL EXPERIENCE:

Confidential

Associate Manager

Responsibilities:

• Understand/analyze the requirements of different business users and provide enriched data in the form of reports .
• Resolve complex business queries by analyzing data with help of Teradata queries.
• Generating data driven insights to drive business outcomes in the form of SAS BI reports(through SAS Web Report Studio)
• Data analytics work on marketing, campaign, policy, quotes & billing subject areas on P & C data warehouse.
• Provide solution designing/IT technology consulting to meet business requirements using agile SDLC by using rally tool.
• Interacting and co-ordinating with third party vendor for mail determinants etc.
• Helping Marketing team to automate marketing reports and measure efficiency early so that marketers can spend more time gaining insights. Provides (cleansed) customer and household level view of client’s universe.
• Performing POCs & replaying back to business for upcoming strategic projects/enhancements.
• Schedule and support the different SAS reports(through LSF Scheduler) which are running as part of marketing operations team.
• POC on ESRI (in microstrategy & qliksense) to accurately report risks by marring policy data with hurricane/wildfire and other hazards data.
• Analyzing all media touch points patterns led to quote start/quote complete/Issued policies and identifying winning patterns led to 75 % quote start/quote complete/Issued policies.
• Executing Test scripts and responsible for overall quality of the code.
• Performance Tuning of complex SAS queries

Confidential

Responsibilities:

• Good experience in Architecting/design/developing E2E Data warehousing projects across various SDC phases like requirement gathering, analysis, design, development, testing, UAT, customer review, implementation and maintenance of Data Warehousing/migration using technologies like Datastage/Teradata/SAS/ LINUX/UNIX shell scripting.
• Understanding the source data and datamodel and creating the extract and load strategy for loading the data into the staging table.
• Implementation of CDC logic & loading more than 1000 staging table into FSLDM.
• Co-coordinating between the offshore & onshore team and help the team members as a mentor in overcoming the challenges.
• Monitoring progress of assigned modules to ensure timely deliverable.
• Finalizing the structure of SAS BI reports over the datawarehouse and building the reports in the second phase.
• Project Planning activities, estimation & capacity planning.
• Mentoring team members in resolving technical problems.
• Provided support to all SAS customers in resolving problems through Remedy during post production.
• Involved in troubleshooting infrastructure issues for SAS Enterprise Guide, WRS, Information Map.
• Involved in scheduling jobs through LSF scheduler and also providing role level access and maintaining metadata.
• Implementing Quality Assurance Strategy through test scripts within timelines.
• Develop the test plan for the tasks, dependencies and participants required to mitigate the risks to system quality and obtain stakeholder support for this plan.
• Track and prepare the report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.
• Migration of SAS 9.1.3 to SAS 9.3.

Confidential

Responsibilities:

• Conducting interviews with technical & business people and determining what revenue & tax parameters client wants in these reports.
• Building Individual & Business Data Dictionary by including all the relevant attributes of revenue & tax systems for various countries.
• Responsible for building the structure of reports and then implementing it by using SAS EBI tools.
• Building process flow for jobs by reading data from excel and transforming it to required output datasets by using SAS DI.
• Monitoring, controlling and managing SAS account for different Business Users across the project(Role based Access)
• Scheduling and refreshing the reports for the Business so that the Business can access the critical data on scheduled time thus reducing manual intervention.

Confidential

Responsibilities:

• Understanding the response model concept with respect to Pharma
• Developing of SAS modules
• Involved in development of Sales force optimization Tool.
• Done SAS/MQ interfacing
• Usage of analytic procedure like optmodel etc

Confidential

Responsibilities:

• Understanding the Empty Model 2
• High level Design of the Empty Model 3
• Developing of SAS modules which includes extracting different feeds,cleansing, validating and transforming the data.
• Loading data into Oracle table through which reports need to be built for enduser in BO.
• Involved in development of Test cases for SAS modules
• Done SAS/MQ interfacing
• Performance Tuning at SAS level and automation of manual process to reduce processing time and optimizing it.
• Migration of SAS 9.1 to SAS 9.3.
• Successfully handled the support and maintenance activities of this project which includes defect fixes, change requests within defined SLA's.
• Automated the SAS jobs to improve performance.

Confidential

Responsibilities:

• Requirements gathering
• Designing
• Coding
• Planning and estimation
• Reporting
• Coordinating the 2 projects namely PST, Clinpharm

Confidential

Responsibilities:

• Requirements gathering
• Designing
• Coding
• Planning and estimation
• Reporting

Confidential

Responsibilities:

• Requirements gathering
• Designing
• Coding