SAS CONSULTANT

SUMMARY:

• Certified SAS Programmer with six years of experience in Analysis, design, development, testing and validating the applications.
• Possess extensive knowledge of developing, modifying and maintaining BASE SAS program suites
• 6 years of programming/experience in SAS on the Windows and UNIX platforms.
• Used the procedures SQL, TABULATE, FREQ, FORMAT, REPORT and SUMMARY to generate reports.
• Optimized performance using Data Validation and Data cleaning on data using Statistical procedures like PROC FREQ, PROC MEANS, and PROC UNIVARIATE.
• In-depth knowledge of SAS programming, data processing, data collection, quantitative and qualitative data analysis and Data ware housing.
• Coding Programs using SAS Macros.
• Possess excellent knowledge in Base SAS, Advanced SAS and Macros.
• Trained in SAS Data integration Studio, Web Report studio, Information Map Studio 3.1, SAS Management Console by SAS institute.
• Excellent working knowledge on SAS GRAPH/SAS STAT, SAS enterprise guide and SAS DI studio
• Expertise in SDP Architecture.
• Excellent knowledge on SDP domain on various functional components like CSM, SOA, XQUERY, XML.
• Good knowledge of Oracle Service Bus (OSB).
• Strong SAS programming background.
• Excellent Knowledge on Telecom Domain. Completed Telecom foundation certification (level 1 & level 2 ) from Accenture.
• Completed DWH/BI beginner level & intermediate level certification from Accenture.
• Excellent knowledge on healthcare domain. Attended Pharmaceutical trainings which helped in building health care domain knowledge.
• Possess excellent communication and coding skills.
• Consistent high performer and received various awards .
• Active involvement in demos showcased to various communication clients
• Excellent organizational and time management skills.
• Excellent team player with high level of personal initiatives.
• Ability to handle multiple tasks simultaneously.

CERTIFICATIONS:

• Base SAS certification SAS Institute
• BI-SAS BI Tools for BEGINNER Level Internal certification Accenture
• DW/BI Concepts for BEGINNER Level Accenture
• DW/BI Concepts for intermediate Level Accenture
• CommsP1 professional certification test (Telecom) Accenture
• CommsP2professional certification test Accenture

TECHNICAL SKILLS:

• SAS BI: Base SAS, Advanced SAS, Macros, PROC SQL, SAS/STAT, SAS/Graph, SAS ODS, SAS Enterprise guide, SQL, SAS DI Studio, Web Report studio, Information Map studio, SAS management console
• DATA WAREHOUSING: Strong data warehousing concepts, creation of schemas and schema objects like table, view indexes, data models, the expansion of a single dimensional data model (star schema) into multiple star schemas, source to target mapping, ER diagrams using Erwin
• DATABASES: Oracle Database, My SQL 2008
• Project Management: Creation of Project management plan, Organization charts, Issue Tracking, Utilisation reporting, QMS, RRT, Utilisation reports, IO forecast, status reporting,audit related activities, managing the team, preparing detail specification documentation
• Others: SDP, CSM, SOA, XQUERY, XML, OSB, Microsoft Visio
• Operating Systems: MS Windows XP, Windows Vista/7 and UNIX.

PROFESSIONAL EXPERIENCE

Confidential is the largest mobile phone operator in Russia and the CIS. Together with its subsidiaries, the Company services over 81.97 million subscribers. The regions of Russia, as well as Armenia, Belarus, Turkmenistan, Ukraine, and Uzbekistan, in which MTS and its associates and subsidiaries are licensed to provide GSM services, have a total population of more than 230 million.

Responsibilities:

• Involved in MTS Reverse-Engineering.
• Completed physical data validation.
• Reviewed large macro codes for running the programs.
• Involved in Corporate Dashboard Data Mapping
• Involved in MTS Corporate Dashboard - ETL Mock data creation
• Harvesting MTS Corporate Dashboard
• Sanitization of MTS docs and SAS scripts
• Mapping subject areas from Erwin data model to MS Visio
• creation of Star Schemas in MS Visio for the fact tables
• Data model update
• Assigned the Logical tasks of designing and developing project-specific SAS programs like producing analysis datasets and reports .
• Handled the responsibilities of programming SAS for retrieving data
• Responsible for manipulating , transferring and managing data in SAS
• Assigned the tasks of developing and implementing innovative SAS strategies of the organization .
• Assigned the tasks of planning and directing the work of SAS developers
• Handled the tasks of writing reports and manipulating data by using WINDOWS platforms
• Attended client and team meetings as required .
• Ability to write some common macros that are useful across multiple studies.
• Perform validation on derived datasets and following the standard operating procedures during the validation process.
• Generate reports either in HTML,PDF or Listing formats according to the client specifications
• Extensive use of PROC SQL to perform queries, join tables.
• Used data _null_ and PROC REPORT to generate the outputs.
• Extensive use of Optimized performance using Data Validation and Data cleaning on data using Statistical procedures like PROC FREQ, PROC MEANS, and PROC UNIVARIATE.
• Coding SAS programs with the use of Base SAS and Macros
• Creating SAS dataset from tables in Database

Environment: Base SAS, Advanced SAS, Macros, PROC SQL, SAS/STAT, SAS/SQL, SAS/Graph, SAS ODS, SAS Enterprise guide, SAS DI studio SQL, MS-Excel

Confidential Jan 2009- July 2011
Programmer Analyst

Confidential is a leading cable, entertainment, communication products and communication services provider in US.SDP powered Offerings included Outlook email, Share point, Domain Registration & Web hosting for small and medium business customers.SDP Functionalities includes Service Orchestration (SO), Converged Subscription Management (CSM) and Microsoft Enabler.

Responsibilities:

• Handling the core module CSM
• Expertise in SDP Architecture
• Completed the Design activities in the development of SDP Admin tool which included the following activities -

Coordination with the onsite team to understand requirements.
Preparation of project plan
Preparation of detailed technical design
Preparation of sequence diagram
Preparation of class diagrams
Involved in the Proof of concept

• Involved in the developmental activities of SDP Admin Tool which included the development of GUI layer for the Admin tool and database queries for the tool.
• Production Support including the resolution of tickets, Platform administration, providing support for third party vendors/client during maintenance.
• Deployed offer update and SDP timeout synch CR in Prod
• Attended OSB training and built a sample application.
• Status reporting and creation of weekly reports,MOM,Tdoc IOforecast,org charts & updating QMS,RRT,MCT,Utilization reports and activities related to Comcast audit
• Enrich knowledge on SDP domain on various functional components like CSM,SOA,OSB,XQUERY,XML etc
• Followed ADM standards in all the deliverables.
• On time completion of work in adherence to schedule.
• Delivered KT sessions to the team and mentoring new members.
• Worked on the AMOS demo activities showcased for client visits .Attended People’s panel and presented the products in front of various other international telecom companies.
• Communication with third party vendors and clients for SDP maintenance.
• Contributed to capability in the organization by preparing database for intermediate SAS certification and initiated exam in Accenture
• Participated in GFT material creation in SAS for fresher trainings.
• Ability to work on multiple projects simultaneously and meet the deadlines as and when required
• Extensive experience in working with clients across the globe.

Environment: Base SAS, Advanced SAS, Macros, PROC SQL, SAS/STAT, SAS/SQL, SAS ODS, SAS Enterprise guide, SQL, MS-Excel, SDP, CSM, SOA, OSB, XQUERY,XML

Confidential Sep 2008-Jan 2009
Senior Programmer

The organization has a solution that allows communications providers to optimize the profitability of their convergent offerings and improve share of wallet from their customers. Confidential allows companies to collect and analyze both internal and external data to get a more comprehensive picture of customers and their decision-making processes.

Responsibilities:

• Creation of Data Sets
• Coding SAS programs with the use of SAS/BASE and SAS/Macros.
• Prepared new Datasets from raw data files and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• ETL Mock data creation
• Maintained and enhanced existing SAS reporting programs
• Extensive Use of PROC REPORTS to generate report.

Environment: Base SAS, Advanced SAS, Macros, PROC SQL, SAS/STAT, SAS/SQL, SAS/Graph, SAS ODS, SAS Enterprise guide, SAS DI studio SQL, MS-Excel, Web Report studio, Information Map studio, SAS management console

Confidential, Romania Sep 2007-Aug 2008
Senior Programmer

Confidential is a Romanian mobile phone network operator. It launched in April 1997 as the first GSM network in Romania (although not the first mobile phone network). Until October 2005 (shortly after acquisition by Vodafone), it was known as Connex, after which it was rebranded Connex-Vodafone and in April 2006, the Connex name was dropped, the operator being simply known as Vodafone Romania, aligning itself with the global Vodafone brand.

Responsibilities:

• Provided support by preparing .dat files and doing peer review.
• Attended online SQL trainings there by developing skills and helped the team in completion of SQL work.
• Attended the Telecom Fundamental trainings which helped in building domain knowledge.
• On time completion of work in adherence to schedule.
• Created and maintained the issue tracker, defect tracker, minutes of meeting for maintaining the quality work of the team.
• Contributed towards the DWH knowledge byte series.
• Contributed in the creation of database of questions for SAS capability there by initiating BI-SAS BI Tools for BEGINNER Level Internal certification.
• Delivered KT sessions on Base SAS programming and basic DWH concepts
• Reviewed other team mates work to ensure defect free delivery

Environment: BASE SAS, SQL, SAS/MACROS,

Confidential Feb 2007-Sep 2007
Programmer

Confidential is an internal project which aims in providing services to multiple clients working with the organization.

Responsibilities:

• Completed Base and advanced SAS training.
• As a part of my role I have attended pharmaceutical trainings which helped in building the pharma domain knowledge.
• Involved in generation of reports using proc report.
• Enhanced technical skills.
• Successfully completed the continuous assessments.

Environment: BASE SAS, SQL, SAS/MACROS,

Confidential Nov 2006-Feb 2007
Programmer

Confidential is the UK government agency which is responsible for ensuring that medicines and medical devices work and are acceptably safe.
Responsibilities:

• Part of developing a completely new module in existing KPA (Knowledge Portal) Web Application which contain 7 reports and 2 code sections.
• Completed Technology Module Section where Technology Names was given as input and the details of people working under the corresponding technology was obtained in the next page. (multiple selection was enabled).
• CascadedStyleSheet was used to match the new JSP pages to existing pages in Application.
• The Final Module was submitted for integration on to the existing Application on January 14th.
• Developed pharmaceutical domain knowledge.
• Servers used : OC4j,Tomcat

Environment: BASE SAS, SQL, SAS/MACROS, JSP, JAVA

EDUCATION:

• Bachelors of technology in EEE.