Certified SAS programmer with over Thirteen years of IT experience in Analysis, design, develop, test and implementation of Analytical and reporting solutions utilizing Business intelligence tools
Operating System: MVS,
Z/OS, Windows XP, Windows 7, Windows 2008 & UNIX
DB2, Oracle 8i/9i, VSAM, IMS DB
SAS 8.x/9.x, SAS Enterprise Guide 4.x, SAS Studio, Business Objects XI R2/R3 (Designer,Webintelligne,
Infoview, Desktop Intelligence and CMC), IBM Cognos 8.x/10.x (Framework
Manager, Report Studio, Query Studio, Business Insight and Cognos Connection)
SAS Programmer Analyst, 10/2012 － CurrentAnira Solutions Inc State Farm － IL
Engage with users to fully understand their reporting needs.
Develop high level technical specification documents from business requirements.
Design and develop the complex reports as per the requirements using SAS Enterprise Guide 4.3/5.1, SAS MACROS, PROC REPORT, PROC SQL, PROC TRANSPOSE Schedule SAS reports utilizing enterprise scheduling tool Control-M Write SAS reports to various output systems Excel, Access, HTML and PDF using SAS ODS Explain and tune the report SQL's to maximize the performance of the reports Work closely with DBA's in tuning the performance report SQL's Identify and implement process improvements by automation Modify existing reports as per the user requests and provide overall support for end user queries.
Work with test delivery team for the accuracy of the reporting data
Business Intelligence Analyst, 10/2003 － 06/2012IGATE Corporation State Farm － IL
Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Reports accordingly.
Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and reports.
Worked on the SQL tuning and optimization of the Business Objects reports.
Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
Exported the ad-hoc ready universes to the for making semantic layer available to the users.
Troubleshoot errors in reports, dashboards, and universes.
Fixed them to work as per the business needs.
Created complex reports by linking data from multiple data providers, stored procedures and functionalities Union Queries, Drill Down, Master Detail, Custom Sorts etc.
Extensively worked with Ranks, Alerters, filters, prompts, variables and calculation contexts in designing reports.
Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
Extensive testing and migrating the reports or objects from development to Production system.
Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
Worked closely with BI Tool support in creating BI resources and migration of the BI content from one environment to other Identified data quality standards required to support analytic and reporting needs Assisted in analysis of quality and consistency of data derived from transaction and business intelligence systems.
Trained business customers on data warehouse contents, access tools and techniques.
Scheduled and monitor the reports using Enterprise Scheduling tool BMC Control-M and Business objects built in scheduler Performed quality assurance functions, worked with key business representatives to ensure that processes, systems and reports are properly tested.
Designed test cases and test plans, performed integration testing, end to end business process testing and test case execution
SAS Programmer Analyst
Engaged with users to fully understand their reporting needs.
Developed high level technical specification documents from business requirements.
Designed and developed the complex reports as per the requirements using SAS Enterprise Guide.
Wrote SAS reports to various output systems Excel, Access, HTML and PDF Explained and tuned the report SQL's to maximize the performance of the reports Worked closely with DBA's in Performance tuning of the report SQL's Identified and implemented process improvement and automation initiatives Modified existing reports as per the user requests and provided overall support for end user queries.
Worked with test delivery team for the accuracy of the reporting data.
Environment: SAS Enterprise Guide 3.1, SAS 8.2, BASE SAS, SAS /ACCESS, SAS/CONNECT, SAS/STAT, SAS/GRAPH, MS EXCEL, MS ACCESS, Windows 7/2008 , DB2.
Client: State Farm Insurance, IL Project: Enterprise Loss Reporting(ELR).
Worked as single point of contact and provided the support to other interfaces that (Mid-Tier, MQ) interact with Loss reporting system Worked on resolving the High priority Incidents and service tickets within the service management guidelines Co-ordinated with off-shore team for enhancements of the application and resolving other low priority service calls Provided 24*7 on call support in handling any production related service calls Provided Testing & Debugging support for WEB and MQ interfaces that are interacting with ELR application for any production related issues.