SUMMARY:

• Around 6 years of experience in data warehousing, business Intelligence and data analytics across the industries.
• Good understanding of end to end implementation of ETL process/concepts in various projects.
• Expertise in SAS/BASE, SAS/ Confidential, SAS/SQL, UNIX SAS, SAS EG.
• Experience in Design, Development and Testing codes using SAS.
• Good knowledge on working with Confidential, procedures in SAS.
• Knowledge on SAS efficiency techniques and experience in handling huge volume of data.
• Good experience in Teradata, DB2 and Oracle.
• Ability to write and tune the SQL quires using any relational database.
• Good understanding on Ab - initio and Informatica
• Good knowledge in writing scripts using UNIX and Python.
• Experience in Control-M scheduling tool
• Good experience in maintaining various versions of code using Sub version and creating TFS builds using visual studio.
• Preliminary understanding on agile methodology.
• Preliminary understanding on Bigdata and Hadoop technologies.
• Preliminary understanding on Business intelligence tool Cognos and Tableau.
• Good knowledge on programming languages like C,C++ and Java
• Experience in various Operating Systems(Windows 2003, Windows XP, UNIX)
• Thorough experience on software development methodology & worked on all the phases of software development life cycle.
• Having good knowledge in Banking and Healthcare domains

TECHNICAL SKILLS:

SKILL: Base SAS, Advance SAS, Confidential, Stored procedures, UNIX SAS, SAS/SQL, Mainframe SAS

ETL/BI Tools: SAS EG, Informatica, Ab-initio, Cognos, Tableau

Databases: Teradata, DB2, Oracle, BizTalk

Programming languages: C,C++, Java

Scripting languages: UNIX scripting, Python scripting

Version control tools: Sub version, Team foundation server (TFS build)

Scheduling tools: Control-M

Operating System: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Environment: BASE SAS, SAS/SQL, SAS/ Confidential, BizTalk, MHS (AS/400)

Responsibilities:

• Analyzed the existing data from state which load in Enrolment834 BizTalk tables.
• Analyzed the data in MHS ( Confidential database)
• Translation of business requirements into project technical specifications
• Developed the code to read the data from both the systems and write the output results into a delimited text file
• Developed and managed Confidential that eliminate redundant coding.
• SAS Procedures like PROC APPEND, PROC SQL, PROC SORT, PROC DATASETS, SAS Macro, SAS Options, Complex data step derivations.
• Involved in various phases of Project - System Study, Impact analysis, Coding and Testing.
• Reports developed with the data from the Confidential source systems are transferred to Confidential .
• Unit test case preparation and execution.
• Created Test plan & production installation documents.

Confidential

Environment: BASE SAS, SAS/SQL, SAS/ Confidential, MHS (AS/400)

Responsibilities:

• Analyzed the existing process to include Company 45 details or to create new jobs
• Translation of business requirements into project technical specifications
• Modified existing codes and developed new codes to include the company 45 details in all the process.
• Worked closely with regression modeling team to understand the data and to create a predictive model using data from an insurance provider, investigated healthcare expenditures and applied variable selection to produce models for predicting the cost that insurers will spend on covered members this based on the data they have provided.
• Developed and managed Confidential that eliminate redundant coding.
• SAS Procedures like PROC APPEND, PROC SQL, PROC SORT, PROC DATASETS, PROC REG, SAS Macro, SAS Options, Complex data step derivations.
• Involved in various phases of Project - System Study, Impact analysis, Coding and Testing.
• Extract transform and load the source data based on the transformation rules into target datasets / tables.
• Created new target tables to maintain exclusively company 45 related data.
• Unit test case preparation and execution.
• Created Test plan & production installation documents.

Confidential

Environment: BASE SAS, SAS/SQL, SAS/ Confidential, MHS (AS/400)

Responsibilities:

• Analyzed existing Claims processes to have a walkthrough of already existed code which generates weekly claims report
• Translation of business requirements into project technical specifications
• Developed and managed Confidential that eliminate redundant coding.
• SAS Procedures like PROC APPEND, PROC SQL, PROC SORT, PROC DATASETS, SAS Macro, SAS Options, Complex data step derivations.
• Involved in coding and testing of all the modules developed using Base SAS and Confidential .
• Involved in various phases of Project - System Study, Impact analysis, Coding and Testing.
• Reports developed with daily changed claims per member by using last changed date in form of delimited text files.
• Unit test case preparation and execution.
• Created Test plan & production installation documents.

Confidential

Environment: BASE SAS, SAS/SQL, SAS/ Confidential, MHS (AS/400)

Responsibilities:

• Need to understand existing SAS codes.
• Analyze the existing codes and modify if required based on Confidential request.
• Work on production tickets or incidents related to Confidential region 15 and 41 jobs.
• Ensure closing the tickets on time with providing accurate solution.
• Development, testing and deployment in production for any enhancement tasks.
• Schedule and monitor the production jobs. Provide on time solutions if any error occurs.

Confidential

Environment: BASE SAS, SAS/SQL, SAS/ Confidential, Teradata, UNIX and Control - M

Responsibilities:

• Understand the business requirement document (BRD) and make sure all the requirements are clear to start the development.
• Ensure the requirement Gathering and Analysis.
• Analyzed and created logics for Basel 3 variables by understand the Ab-intio logics and captured all these into source to target mapping documents
• Developed SAS code to include or assign these variables into the existing system.
• Tested the data with all conceivable conditions in DEV, QA and UAT.
• Documented the process for Business and Functional perspective. - STT, Test Plan, Test Scripts.
• Analysis on user data reported from source systems: Validating the attribute values been reported from the source system.
• Involved in tuning queries and SAS codes.
• Wrote SAS code to capture the timings and count of the each process for auditing purpose.

Confidential

Environment: BASE SAS, SAS/SQL, SAS/ Confidential, Teradata, UNIX and Control - M

Responsibilities:

• Understand the business requirement document (BRD) and make sure all the requirements are clear to start the development.
• Ensure the requirement gathering and analysis by understanding the existing system if anything need to clarify in BRD.
• As a part of data analysis, analyzed the Ab-initio based Basel rules and converted them into STT (source to target) mapping documents
• Re-engineering on the logics present in legacy system and freeze the logic attribute wise.
• Tested the data with all conceivable conditions in DEV, QA and UAT.
• Identify different feeds for the system and prepare source to target mapping document as per the dimensional model.
• Documented the process for Business and Functional perspective. - STT, Test Plan, Test Scripts.
• Analysis on user data reported from source systems: Validating the attribute values been reported from the source system.
• Using the mapping documents which are prepared developed programs using SAS for global exclusion process, and splitting accounts based on LOB.
• Developed SAS programs by applying segmentation business rules for Auto, BB and Mortgage banking using SAS functions and data steps.
• Applied Risk Weight assessment rules on the segmented data by SAS build rule engine.
• Developed Teradata SQL queries and incorporated same in SAS codes.
• Involved in tuning queries and SAS codes.
• Generated SAS Confidential for reusability and minimize data processing. Performed testing on all the attributes and made sure all the values are matching between SAS output and EDW.
• Generated reports and extracts according to FDW requirement.
• Automating SAS jobs using UNIX scripts to run through Control-M. Providing support to the new jobs which were running in production as part of Support

Confidential

Environment: BASE SAS, SAS/SQL, SAS/ Confidential, SAS EG and SAS Stored Process.

Responsibilities:

• Walkthrough of already existing SAS codes for which we need automate the submission process.
• Created Confidential for code reusable and reduce the code redundancy.
• Added some more procedures like PROC SUMMARY, PROC MEANS to existing codes to generate more detailed reports on client request.
• Created stored process for the SAS codes, which are used to execute from the web report studio.
• Created static and dynamic prompts which will provide flexibility to user to enter required values before submitting the SAS jobs on their own.
• Created Web reports by using these store process.
• Involved in testing by running these codes from web report studio.
• Performed code review and end to end testing to make sure everything is working properly
• Involved in testing whether the reports are generating correctly and make sure these reports are mailed to respective mail ids
• Tested these reports whether user/client can able to submit on their own successfully or not

Confidential

Environment: BASE SAS, SAS/SQL, SAS/ Confidential, Teradata, DB2 and Mainframes

Responsibilities:

• Analyzed existing processes to have a walkthrough of already existed code in Mainframes SAS
• Involved in Requirement analysis, Project Plan, Design and Development and System Testing and Project deployment activities
• Responsible for the creation of business requirements document and functional/design specification document after the interaction with end business users
• Understanding the logics involved, which needs to convert into Unix SAS and having Teradata as database.
• Development of process level metric, both operational and performance based, using SAS and Teradata to generate new SQL and SAS codes to process and generate the required report for these two vendors.
• Developed SAS ETL (Extraction, Transformation and Loading) code that would load data to the warehouse for the reporting services using SAS.
• Extracting SQL tables from SAS by using SAS/SQL Pass-Through-facility.
• Generating reports and send it these vendors on their request basis
• Developed and managed Confidential that eliminate redundant coding.
• Part of validation generated reports using old code and newly generated code and compared exactly. Supported in warranty period for two months to ensure everything is working accurately
• Keep track of the entire project by doing periodic review of work done by my team to make sure that the project is completed well before the deadline

Confidential

Environment: BASE SAS, SAS/SQL, SAS/ Confidential SAS EG4.3, Teradata, Informatica

Responsibilities:

• Key Member in ETL designing and coding
• Analyzing the sources and targets, transforming the data according to the business rules mentioned mapping and populating the data into targets.
• Writing SQL queries, building SAS codes as part of transformation process
• Developed and managed Confidential that eliminate redundant coding.
• Developed programs using SAS/Base and SAS/ Confidential to extract clean and validate data Source data.
• Responsible for Code optimization and performance techniques which will help in improving the performance of the SAS codes used by the team.
• Unit test case preparation and execution.
• To load normalized data into IDW created mappings, Sessions, Workflows by using Informatica.
• Actively involved in improving the performance by applying tuning techniques. Performed end to end testing as part of validation and testing.