SUMMARY

• Capable of forming and maintaining positive and productive working relationships in internal / external and team environments
• Good exposure on requirement gathering, understanding Business user needs and analyzing business pain areas.
• Detail - oriented, results-driven, excellent verbal and written communication skills with interpersonal and conflict resolution skills and possesses strong analytical skills
• Good knowledge in Platform Administration for SAS 9.4, SAS 9.3, SAS 9.2 and SAS 9.1.3.
• Good knowledge and tremendous exposure in building the SAS infrastructure
• Good knowledge in building and implementing SAS Visual analytics on a multi-tier environment.
• Good understanding of SAS tools like SAS Data Integration, Infomap, OLAP Cube studio.
• Good knowledge in Installing SAS EBI, EGRC, IRMS(RMFB,CRMB), AML, ECM, SNA, Marketing Optimization and Marketing Automation on both Windows and Unix platform.
• Good Knowledge in installing SAS Grid over a distributed environment
• Good knowledge on SAS server and Web Server Performance tuning.
• Expertise in implementing SAS Visual Analytics with HPA
• Good working knowledge on databases like Teradata, Oracle, SQLServer
• Expertise in implementing Horizontal and vertical clustering using JBOSS.
• Experience in handling/implementing SAS Grid and understanding the Grid architecture and working on the same
• Expertise in implementing SSL for JBOSS and Apache for reverse proxy for SAS Web Applications.
• Expertise in implementing SAS Web applications over JBOSS, WebSphere and WebLogic
• Good knowledge of Server architecture and Server sizing.
• Good knowledge on SAS BI Dashboard and WRS.
• Good Experienced in SAS Technical Support, debugging Error, and providing timely resolution.
• Good experience in developing DI jobs.
• Interact with Business users and derived KPIs.
• Good experience in Database designing, Data warehouse and BI technology
• Extensive experience in data analysis, field mappings, requirements gathering, data extraction & reporting.
• Proficient in design of logical and physical data modeling using data modeling tool
• Good knowledge of Oracle Pl/SQL programming.
• Good Knowledge of writing complex SQL queries.
• Development knowledge of Oracle database along with Pl/SQL
• Expertise in Informatica development and data warehousing.

TECHNICAL SKILLS

Operating System: Windows Server, Unix

Software Languages: PL/SQL

RDBMS: SQL Server, Oracle

Developments Tools: Nexus, PL/SQL Developer, SQL Plus, SAS Information Map Studio, SAS Data Integration studio

Reporting Tools: SAS WRS, EG, Visual Analytics

Database & BI Tools: Oracle 9i,10g, 11g, DB2,SAS

PROFESSIONAL EXPERIENCE

Confidential

Technologies: SAS DI, WRS, EG and SAS Solutions like VA,EM,CBRM

Implementaion/Maintainence and support

Responsibilities:

• Installing various SAS Solutions on Unix and Windows platform.
• Working on installing SAS Grid with 56 grid nodes and Clustering of metadata for High availability.
• Mid-tier migration from Solaris to AIX.
• Implemented SAS Visual Analytics in Chase with HPA
• Resolving issues faced during installation with SAS TS team
• Trouble Shooting issues in case of SAS breakdown
• Providing resolution to the technical and functional issues faced by the users during their implementation
• Analyzing the logs at the time of technical issue occurrence for the SAS environment on various Unix/Windows for debugging purpose.
• Working on Migration from SAS 9.1.3 to 9.3
• Troubleshooting DI jobs in case of issues and errors
• Assisting users in improving performance of DI jobs
• Assisted Chase with the sizing related to VA
• Working on the SAS Grid implementation for Chase
• Working on LSF and troubleshooting issues for LSF

Confidential

Technologies: SAS DI, WRS, EG and SAS Solutions like VA,EM,CBRM

Implementaion/Maintainence and support

Responsibilities:

• Installing various SAS Solutions on Unix and Windows platform.
• Working on installing SAS Grid with 56 grid nodes and Clustering of metadata for High availability.
• Mid-tier migration from Solaris to AIX.
• Implemented SAS Visual Analytics in Chase with HPA
• Resolving issues faced during installation with SAS TS team
• Trouble Shooting issues in case of SAS breakdown
• Providing resolution to the technical and functional issues faced by the users during their implementation
• Analyzing the logs at the time of technical issue occurrence for the SAS environment on various Unix/Windows for debugging purpose.
• Working on Migration from SAS 9.1.3 to 9.3
• Troubleshooting DI jobs in case of issues and errors
• Assisting users in improving performance of DI jobs
• Assisted Chase with the sizing related to VA
• Working on the SAS Grid implementation for Chase

SAS Technical Support

Technologies: SAS DI, WRS, EG and SAS Solutions like EGRC,SNA, RMFB, CRMB for SAS 9.3 and SAS 9.2

Technical Support

Responsibilities:

• Installing various SAS Solutions on Unix and Windows platform
• Resolving issues faced during installation
• Trouble Shooting issues in case of SAS breakdown
• Implementing SSL, horizontal clustering on web server
• Providing resolution to the technical and functional issues faced by the customers on various solutions
• Analyzing the logs at the time of technical issue occurrence for the various SAS tools on various platforms for debugging purpose.
• Replicating the issues which are faced by the different SAS India customers to analyze and finding the resolution on different SAS tools on the different platforms
• Migration from SAS 9.1.3 to 9.2 and also from SAS 9.2 to 9.3.
• Troubleshooting DI jobs in case of issues and errors.
• Assisting customers in improving performance of DI jobs.
• Developing BI Dashboard for pre-sales.

Confidential

Technologies: Informatica, MS SQL Server, Teradata

ETL Developer

Responsibilities:

• Understanding the flow of data in the sense how the data is flowing from different sites
• Migrating the data from MS SQL server to Teradata
• Developing new mappings to load the data from different tables
• Writing SQL query for sites added to EBI-LITE and also scheduling the jobs using Control-M for those particular changes to be implemented for those sites

Confidential

ATechnologies: Informatica 8.1, Oracle 10g

Developer, Data Analysis, Requirement Gathering

Responsibilities:

• Analyzing PLSQL procedures to find out the root cause of the issue
• Analyzing the mappings whenever there is a data issue in the front end
• Developing and analyzing informatica workflows for interfacing, scheduling and monitoring
• Providing technical and functional support for users
• Preparing Unit Test plans for enhancements and bugs fixed, testing enhancement requests and fixes Data archiving for processing the model for new planning
• Ensure customer satisfaction by providing appropriate solution on time
• SLA Tracking, Maintenance of the project in tune with requirement changes
• Migration of code to production server
• Updating status to clients

Technologies: Informatica 8.1, Oracle 10g

Confidential

Developer, Technical Support

Responsibilities:

• Analyzing PLSQL procedures to find out the root cause of the issue
• Analyzing the mappings whenever there is a data issue in the front end
• Developing and analyzing informatica workflows for interfacing, scheduling and monitoring
• Providing technical and functional support for users
• Preparing Unit Test plans for enhancements and bugs fixed, testing enhancement requests and fixes Data archiving for processing the model for new planning
• Ensure customer satisfaction by providing appropriate solution on time
• SLA Tracking, Maintenance of the project in tune with requirement changes
• Migration of code to production server
• Updating status to clients