SUMMARY

• Total 10+ years of Experience in Information Technology.
• SAS administrator / Consultant for Confidential SAS and business users. Responsible for managing and support the SAS analytics with Big Data platform Integration includes capacity planning, New products Integration, SAS 9.4(Grid) Upgrade from Single node to Multi Node, Evaluation and installation and training business users on the new SAS BI tools.
• Get Onsite training from SAS on SAS 9.4 Grid Administration, Base SAS 9.4 Administration and SAS Enterprise/Text Miner Administration.
• Previously Involved in Data Warehousing Projects (Includes Development, Migration Projects and Production Support).
• Experienced in SAS administrator and Consultant, Technical Lead (Development, Release Management & Production Support) Projects & Informatica /Netezza Administrator.
• Certified From Informatica Corporation as Informatica Certified Developer and Informatica Certified Administrator.
• Excellent hands on experience with Data warehousing tool Informatica with Push Down Optimization, SAS,Netezza, DB2, Unix Shell & Perl Scripting and Scheduling Tool Autosys.
• Executed Onsite/Offshore Team with proper Planning and Responsibilities.
• Hands - on experience with all aspects of Architecture, Designing, developing, testing and implementing ETL solutions.
• Work comfortably with both business and technologists.
• Experience with designing and implementing data staging, including staging database design and staging logic.
• Take responsibility for performance tuning & Ability to troubleshoot issues in a multi-tier environment.
• Ability to provide hands-on leadership to other developers.
• Involved 2 Years’ experience in analysis, design, documentation and development of software product for Demand and Supply Chain Management.
• Experience in designing Analytical comparison reports and Trend Analysis.
• Have quickly acquired the additional application skills to complete the job.
• Interested to explore my self with new Technologies.

TECHNICAL SKILLS

Operating System: Dos, Windows 98, Windows NT,AIX 7.1, Red Hat Linux 6.7

Database: Netezza, DB2,Oracle, SQL Server 2000,Visual FoxPro, FoxPro

Languages: Visual Basic, C,C++ & Perl Script, Hadoop(Hive & HDFS)

Data warehouse: Informatica, Abinitio

BI: Base SAS 9.4, SAS Grid Management, SAS Management Console, SAS Enterprise/Text Miner, SAS Enterprise Guide, SAS PC File Server.

Tools: MS Office, Query Tool

Scheduling Tool: Autosys, Maestro

PROFESSIONAL EXPERIENCE

Confidential

SAS Administrator/Consultant

Responsibilities:

• As a SAS Administrator/consultant responsible for managing and administration the SAS analytics with Big Data platform Integration includes capacity planning, New products (i.e.) SAS 9.4 Grid Upgrade from Single node to Multi Node, Big Data Hadoop Integration through SAS etc. evaluation and installation and training business users on the new SAS BI tools.
• Involved in SAS Grid Upgrade from Single node to Multi Node with Hadoop Integration. Working Closely with SAS and IT on gathering requirements to prepare Road Map and Pre-installation document and Active directory integration from Unix standalone login.
• Involved in SAS upgrade End to End from SAS 9.3 to SAS 9.4 with Hadoop Integration. Engaging collaboratively with the customer to demonstrate the new SAS product capabilities to SAS user’s community within ZNA, which enable business users to derive more value out of the historical data.
• Experience with SAS Management Console (including Metadata Management plug-in, Scheduling plug-in, and Folders tab)
• Involving in Performance Tuning, predictive analytics initiative within ZNA, to understand the how new SAS BI statistical tools can be used to build efficient predictive models.
• Single point of contact to the customer for all production related issues and changes for the SAS BI platform.
• Production Activities:
• SAS compute environment and SAS Metadata.
• SAS Web - Tier (Applications only, not JBoss config, etc) but should understand and be able to work with corporate web support team
• Restart of SAS services as required to manage environment
• Analyze log files for SAS and web environment to identify problems when they occur
• Manage Unix permissions on directories and files
• Monitor storage utilization on mounted volumes
• Monitor performance of the SAS environment
• Unix scripting limited to support environment ex: cleanup log files, unused work data sets
• Support and troubleshoot SAS environment related issues for ALL SAS applications.
• Responsible for setting up programs that make it easier to understand past and current figures and predict future successes/Loss.
• Provide expertise in design, development and implementation of Business Intelligence (BI) and analytics systems using tool SAS Enterprise Guide,SAS Enterprise Miner and SAS Text Miner.
• Responsible for setup a demo to show the client how new hardware and software makes data easier to manage.
• Subject Matter Expert for the BI Applications hosted in the SAS platform, Project management and status reporting to customer for the SAS related applications.

Environment: BASE SAS 9.4, SAS Management Console, Big Data Hadoop(Hive & HDFS), SAS Enterprise Guide 7.1SAS/STAT, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS EnterPrise/Text Miner,SAS PC File Server,UNIX & Linux .

Confidential

Technical Lead

Responsibilities:

• Coordinated with the client and gathering the requirements for Change Request & DMR’s.
• During ZNAW Push Down Optimization in onsite played Vital role which Confidential Critical Month End Jobs used to run 32 hours before, after implementation now run time came down to 6 hours and now month end load used to complete with in 24 hours previously which used to run 72 hours and it gave more Value added to customer.
• Executed the Team (Offshore) with proper planning and Responsibilities.
• Improved data integrity, data load performance With Major Improvement.
• Executed the Responsibilities assigned with proper planning to Team with Daily Handshake between Onsite & Offshore to Get/Update status.
• Clarifying questions from Business Analyst on priority basis.
• Designed and developed ETL process using Informatica tool.
• Creation and maintenance of technical documentation, deployment diagrams and check-lists.
• Responsible for the Code Review of the team and also for the migration of the code
• Excellent Hands of Informatica, SQL,Perl and Unix Shell Scripting.
• During a development effort, responsible for coordinating migrations, maintaining database connections, establishing and promoting naming conventions and development standards.
• Worked closely with other project personnel during the design and development phases to plan, configure, support and maintain desired repository configurations Solved Problems of Complex Scope through extensive usage of standard concept and principle in the project.

Environment: Informatica, Netezza, DB2, AQT Query Tool, Perl and Scheduling Through

Confidential

Technical Lead

Responsibilities:

• Executed the Team with proper planning and Responsibilities.
• Executed the Responsibilities assigned with proper planning to Team with Daily Handshake between Onsite & Offshore to Get/Update status.
• Responsible for Informatica Admin activities like migrating Informatica code between Dev/QA/production environments, Repository Backup / Restore, Privileges to Users, Setting up environment for Development Team (e.t.c).
• Responsible for Netezza DBA Activities in offshore after get Trained as DBA from Netezza Experts from US.
• Monitoring Daily/Monthly Production Loads & Activities and Solve the fixes/issues in production with in SLA.
• Worked Closely with Netezza migration team to migrating data from Db2 to netezza DB.
• Excellent Hands of Perl and Unix Shell Scripting.
• During a development effort, responsible for coordinating migrations, maintaining database connections, establishing and promoting naming conventions and development standards.
• Worked closely with other project personnel during the design and development phases to plan, configure, support and maintain desired repository configurations Solved Problems of Complex Scope through extensive usage of standard concept and principle in the project.
• Responsible for submit Service Delivery Report (SDR) to management regarding Production Ticketing Status/Daily & Monthly Load SLA status on monthly basis.
• Contributed to team members with broad guidance and independent planning.
• Travelled to onsite (US) for Knowledge Gathering and production implementation.

Environment: Informatica, Netezza, DB2, AQT Query Tool, Perl and Scheduling Through Autosys on Windows 2000 Professional

Confidential

Technical Lead

Responsibilities:

• Executed the Team with proper planning and Responsibilities.
• Contributed to team with broad guidance and independent planning.
• Preparing Design High and Low level documents.
• Solved Problems of Complex Scope through extensive usage of standard concept and principle in the project.
• Adapted Standard principle to new or changed condition in day to day work of the project.
• Coached, guided and mentoring junior members in the team to help them scale up faster in initial stage.
• Involved in preparing Test cases, Test Data Preparation and Test Case execution guiding the junior members.
• Developed and Amended Complex Perl Script to Build Autosys frame work
• Scheduling Continuous Jobs using Autosys.
• Travelled to Onsite (US) for Knowledge Gathering and UAT Phase.

Environment: DB2,Unix & perl Script, AQT Query Tool, Schedulling Through Autosys on Windows 2000 Professional

Confidential

Project Engineer

Responsibilities:

• Worked in onsite, Directly interacting with customers and involved in analyzing Reason and solution for problems which creating major problem in Operational Customer Database view and also provided solution approach document to customer which will give clear picture about the problem and No of Man Days needed to solve the problem and also components affected during the amendments. so based on the severity management will proceed with changes
• Amended New as well as existing Mapping to solve existing problems in OCDB.
• Created Stored procedure as well as PL/SQl Program, after amendments in code need to correct problem data in ocdb
• Also worked in ocdb Support calls, in which they used to raise calls through RMS Service Desk, in which Major Severity calls need to be closed with in 30 Days.
• Trained new members while entering to ocdb support team, on handling RMS Calls and given Knowledge transfer on both High level and low level design of Ocdb, based on Maximum severity calls need to be closed with in 30 Days.
• Involved in preparing Proof of concept to overcome future problems, before proceeding with changes.
• Involved in preparing Test cases, Test Data Preparation and Test Case execution and capturing Test Results
• Travelled to Onsite (UK) closely working with client for enhancements projects.

Environment: Informatica, Oracle, TOAD & Test Director on Windows 2000

Confidential

ETL Sr.Developer

Responsibilities:

• Involved in Development of mappings, Test Case Preparation as well as execution of test cases, Done Code Reviews, Code and Development of Complex Stored Procedures.
• Deliverables completed on time, did status update regularly. Worked independently in solving complex problem which assigned to me. Informatica Code review and sent comments to concern code developer, and follow-up, until Update of comments in code using standard code review template for reviewing the code.
• Fully aware of the process and Compliance. Reviewed codes and documents prepared by other team members and followed the quality process with respect to code in Project OCDB-2007.
• Communicated effectively with the team members also shared the workload whenever required in team. Shared ideas with in team for more effective design in project OCDB-2007
• Involved in preparation of Low Level Design Document.

Environment: Informatica, Oracle, TOAD, Test Director & RMS Service Desk on