Professional Summary:

• Over 8+ years of professional experience with increasing responsibilities and successful record of achievements in application design/development, database management, warehousing and statistical analysis & report generation.
• Experience in SAS Programming, Data Analysis using SAS v8.2, 9.1.3, 9.2 in Credit Cards , Financial and Pharmaceutical Industry.
• Proficient in various SAS Business Intelligence tools and manipulating large-scale data sources to fulfill business needs.
• Advance SAS Certified.
• Base SAS Certified.
• OCA (IZ0-007) Certified.
• Experience working with SAS under platforms such as Windows 2000, XP , UNIX,MVS(OS/390).
• Expertise in SAS/BASE, SAS GRID Manager , SAS DDE, SAS/ACCESS,SAS/GRAPH, SAS/SQL, SAS/MACROS,SAS/ODS, SAS/REPORT,SAS/CONNECT , SAS Web Portal, SAS Information map ,SAS Stored Process, SAS Web Report Studio and SAS EG areas and proficient in data manipulations, report/graph generations using the data steps with varies SAS functions, procedures, macros and ODS facilities on PC SAS, Mainframe and UNIX platform.
• Strong analytical and computational skills
• Able to work independently on multiple projects simultaneously with minimal supervision with little to no formal specifications
• Work often leads directly to operational efficiencies and effectiveness reducing expenses. Works closely and effectively with all levels of internal business clients and senior management.
• Experience working with MS Office tools like Excel, PowerPoint and ODS HTML formatted files to produce ad hoc reports to the Users and Business Partners for Presentation and further Analysis.
• Experience in SAS with Oracle, MS SQL Server, DB2 using SAS/Access interface connectivity
• Export / extract data from databases and perform migration of data using Upload, Download.
• Strong exposure to Business and Data analysis, design and training of users. Ability to work independently / in a team environment and ability to absorb technical knowledge quickly.
• Extensive SAS Program development experience. Recent assignments involved data analysis, design, development, enhancement and support of various SAS data marts.
• Highly self-motivated and goal-oriented professional with rational problem solving and sound decision making capabilities, recognized by peers for providing complete, accurate, alternative and timely solutions to complex problems.
• Outstanding skills in documenting and streamlining business process and procedures and proven ability to translate business requirements into Analytical solutions.
• Liaison between business unit and systems organization to provide leadership in defining process improvement, cost saving and revenue-generating opportunities.
• Seasoned professional with knowledge of Project Life Cycle (SDLC) Management with extensive knowledge in coordinating complex analytical projects for various levels of an organization.
• Ability to build productive relationships with colleagues across all functional and technical disciplines, providing focused Business and Project Management, handling multiple projects at the same time.
• Experienced in analyzing and assessing business and financial processes, identifying risks and identify business.
• Development and management of detailed project plans to include, resources, tasks, requirements, milestones, and review points.
• Flexible, self-motivated, detail oriented, fast learner and eager to continually learn
• Works well under pressure and in complex, changing environments
• Believe in continual improvement of processes and change management.
• Worked on Onsite Offshore modal for more than 6 years.

Technical Skills:

• Statistical Software: SAS (Base SAS, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS , SAS/ODS,SAS/CONNECT,SAS/Grid Manager ,SAS DDE).
• SAS BI Tools: SAS EG, SAS Portal, SAS Information map ,SAS Stored Process, SAS Web Studio
• Programming Languages: SAS (UNIX, Windows , Mainframe), PL/SQL, Procedures, SQL, Sql*Loader, Shell Scripting ,VBA,JCL
• Office Tools: MS Office, MS PowerPoint, MS Visio.
• Database: Oracle (8.1.7, 8i, 9i), DB2,SQL Server
• Operating Systems: Windows 96/98/2000, XP, NT,VISTA, UNIX,MVS(OS/390)
• Internet Technologies: HTML, XML
• Special Software: TOAD 8.0 (Tool for Oracle Application Development),Dream Viewer, Documentum , Test
  Director, Remedy 5.01.02, AIX 3

Professional Experience:

Confidential, Nashville TN Oct'08 - Till Date
Senior SAS Developer/Tech Lead/Architect.

• JEDAR -Journal Entry Data Analysis Routines is a methodology that uses exploratory data analysis procedures to test journal entry populations with the objective of profiling journals, identifying unusual items, and selecting items for testing

Responsibilities:

• Senior SAS Developer/Architect.
• Lead the SAS team in gathering requirements, coordinating weekly meeting with the users to discuss issues and provide solutions.
• Responsible for proper coding, documentation and validation of SAS programs/macros/procedures to produce the standardized data display.
• Develop and Validate SAS reports.
• Production Support.
• Used extensively Base SAS, SAS/Macro, SAS/Graph, SAS/SQL,SAS DDE, SAS/Connect Batch UNIX jobs and Excel to develop codes generate various analytical reports to be shared with Business user's
• Successfully designed and developed application to capture performance/usage statistics which is further used for Capacity Planning for JEDAR.
• Work with various teams to enhance performance of JEDAR Application.
• Mentoring other team member.

Environment: - SAS v9, BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/Connect, SAS GRID Manager , SAS DDE,AIX 3, Excel, Windows XP ,VBA, MS EXCEL ,SQL Server ,SAS/ACCESS/SAS Enterprise Guide 4.1.

Confidential, Appleton WI Nov'07 - Oct'08
Senior SAS BI Developer/Tech Lead/Analyst.

• Compliance R4B - . The Compliance Information Program began in 2007 with the inception of the Data Warehouse (Oasis) and the sourcing of compliance information into Oasis along with employee and customer data. Release 1 sourced compliance information into Web Portal for active financial representatives. This information was then use to form the basis of the Compliance Dashboard which is a supervision tool to be used by each Divisional Vice President to supervise their assigned RFOs and for each RFO's management group to supervise their individual Frs. The project began sourcing product systems in order to develop information to supervise money movement.

Responsibilities:

• Technical Lead.
• Successfully designed and developed Compliance web Portal application using SAS BI tools like SAS stored Process, Info map ,SAS Web Studio .
• Implemented Security Features for Compliance Dashboard.
• Extracting data from existing internal or external operational data bases .
• Migrated code from MVS environment to UNIX environment.
• Modified existing SAS programs and created new programs using SAS macro to improve ease and speed of modifications as well as consistency results.
• Cleaning, transforming, and auditing the data, organizing it in an optimized format to allow fast, easy access and to do analysis on it.
• Interacting with client in terms of project requirement, enhancements & debugging on production issues.
• Production Support & resolving production issues.
• Delivery of custom data to answer specific business questions.
• Interact with business users and gather requirements for SAS Web Portal.
• Capturing User Requirement using technical specs.
• Ensure the validation and quality assurance of output.
• Developed and Validated SAS reports.
• Data Extraction from the DB2/SQL Server database thru SAS/Access interface connectivity and Data Manipulation and generates the reports for further analysis.
• Used extensively Base SAS, SAS/Macro, SAS/Graph, SAS/SQL, Batch UNIX jobs and Excel to develop codes generate various analytical reports to be shared with Business user's

Environment: - SAS v9, BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ACCESS, SAS Portal, SAS Information map ,SAS Stored Process, SAS Web Studio, UNIX,MVS(OS/390) , DB2,SQL Server, Excel, Windows XP ,VBA, SAS Enterprise Guide 4.1.

Confidential, Elk Grove Village IL USA March'06 - Nov'07.
SAS Programmer/Analyst.

Confidential, is an information gathering, analysis, data retrieval, and modeling system that evaluates and reports on the profitability of the Citi-Sears Credit Cards portfolio. The GRMAS analytic repository is used by various organizations across Citigroup. Business users / analysts and technology personnel use this repository for various activities ranging from model building to reporting.

Responsibilities:

• Interact with business users and gather requirements for various Data marts.
• Developed code for migrating various portfolio from TSYS to GRMAS.
• Manipulation of large (Terabytes), multi-component data sets encompassing Transaction, Authorization, Rewards, Balance and financial information from FDR SAS data marts.
• Extract Data from flat file send by FDR.
• Created shell scripts to automate batch processing of several jobs.
• Involved on investigate and resolve disputes, discrepancies, issues and concerns from internal and external customers in areas such as credit evaluation, account maintenance, collections, credit reporting and customer service
• Developed SAS Module for various risk scores using different business rules.
• Developed code to generate various analytic reports to be shared with Finance/Risk/ Sales/ Management teams
• Used SAS Macros extensively to eliminate code redundancy and improve SAS program performance.
• Generated a lots of Ad hocReports on daily basis that requested by business users.
• Developed a SAS module that sends all the reports via e-mail after the successful completion of batch jobs.
• Preparation of test cases & execution of Unit Testing and System Testing.
• Implementation of changes in production environment.
• In-charge for production support on bug fixing & given immediate solution to users.
• Quality assurance activities (reviews, walkthroughs)
• Coordinated with other SAS programmers, technical assistance and trouble shooting and interacting with QA team and business users.
• Use primary and secondary research sources to extract, organize, summarize and analyze quality and outcome data. Prepare analysis reports based on data summaries and develop recommendation and alternative for management review.
• Participated in designing, coding, testing, debugging and documenting SAS Programs and Macros. Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Optimized various codes which earlier use to take long hour's to run.
• Supervising offshore and onsite development team.
• Resolving Trouble Ticket/Change request logged by business user via Virtual Change Global Change Management.

Environment: - SAS v9, BASE SAS, SAS/ MACRO, SAS/ SQL, UNIX, Oracle9i, Microsoft Word ,Excel, Windows XP, SAS Enterprise Guide 4.1 .

Confidential, Indianapolis, USA Mar'03 to Feb'06
SAS Programmer/Analyst

Eli Lilly and Company is leading; innovation-driven corporations committed to developing a growing portfolio of best-in-class and first-in-class pharmaceutical products that help people live longer, healthier and more active lives. Lilly is a leader in the pharmaceutical industry with head quarters in Indianapolis, USA. Some of the key drugs manufactured by Lilly include: Cialis®, Evista®, Gemzar®, Humalog®, Humatrope®, Humulin®, Prozac®, Zyprexa®.

Responsibilities:

• Trouble Ticket/Change request logged by business user via remedy.
• Used SAS/ACCESS to extract data from Oracle and other relational databases for analysis.
• Prepared SAS datasets, Tables, Listings, Graphs, Reports and Summaries according to Standard Operating Procedures (SOPs),
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, Formats, and Functions.
• Maintenance and Development of Eli Lilly internal Web sites like GDMS(Global Demand Management System),DDS,DMI(Demand Management Inventory)
• Interact with business users and gather requirements of module for enhancement
• Creating Test cases in Test Director.
• Documentation for Requirements, Design documents, Design Elements, Support of Data Changes, System Changes and new object requests in Documentum.
• Participation in multiple projects and responsibility for certain deliverables
• Resolving Supervising offshore and onsite development team.

Environment: BASE SAS V8, SAS/ACCESS, and SAS/CONNECT SAS/GRAPH, Excel, Microsoft Word, Access, Oracle9, Window NT / 2000 and UNIX, Test Director, Documentum, PERL, VBA.

Confidential, Mumbai, India.June'01 - Feb'03
Team Member

Confidential, is the largest mutual fund in India managing assets worth $12 billion (as on 31-Jan-2002) and an Investor base of 40 million. The aim of the project is to provide investor services using a centralized database for servicing Investors across any location. The Generic Software system for UTI is build using three-tier client/server architecture. It involves a thin JAVA (GUI/WEB) Presentation layer, Application Process layer (Consisting of Web server, LDAP and Tuxedo) and Database (Oracle 8.1.7). Responsibilities:

• Analysis of requirements
• Development, Enhancement & Management of the GSW system.
• Providing technical Support
• Preparation of programs in accordance with Technical & Program Specifications
• Documentation for Requirements, Design documents, Support of Data Changes, System Changes and new object requests.
• Resolving Trouble Ticket/Change request logged by business user via remedy.

Environment: Q++, Java, PL/SQL, UNIX, and Oracle9.i, Pro C, Excel, Windows XP, Master Craft.

Education:

• Masters In Computer Application from Madan Mohan Malviya Engineering college (M.M.M.E.C)
• Bachelor of Science (Mathematics) from Lucknow University