Data Analyst Systems
Resume:
PROFESSIONAL SUMMARY
*+ years of Senior Systems Analyst / : Senior Statistical Programmer.Technical Development expertise, in the IT field with Master of Business Administration worked as SAS Analyst, SAS Programmer and Data analyst and Data Consultant, different Data warehousing, ETL technologies as a developer and Tester involving Retail, Clinical trials, Health Care, Banking and Telecom industries. Directed a team size 5, assign work to the team members and responsible for all on time deliverables.
CERTIFICATIONS
Certifications:
SAS Advanced Programming Version SAS (A00-212).
SAS Base Programming Version SAS 9 (A00-211).
AWS Cloud Practitioner (2022).
Achievements:
Won Super learner - by IBM India Pvt Ltd.
Won Best Associate – Client Serving award for the year 2017 at IBM India Pvt Ltd.
Won Employee of the Month – IBM India Pvt Ltd for BT technology at IBM India Pvt Ltd.
REFERENCES
References available upon request.
ADDITIONAL INFORMATION
SAS Analyst/ SAS Programmer.
Data analyst.
Test Specialist (Application, Manual Testing, Automation Testing and ETL testing).
Experience in Up-gradation/Migration projects.
Responsible till project handover to support team and experience in support (Production)activities.
Proven track of learn and adapt to new skills, tools and technologies.
Ready to up skill based on project requirements.
I have worked on various Industries- Banking, Retail, Health Care, Clinical and Telecom Industry.
Languages:
English, Telugu, and Hindi.
S SHAIK
***********@*****.***
North Carolina, US,27526
EXPERIENCE
Roles
Set up administration standards, collaborated with DEV, QA and Production teams for technical activities, Identified solutions, and standards for incidents.
Expert infrastructure support for Application including issue troubleshooting, environments installation and maintenance of application environment.
Quickly understand the applications that are required to be supported as part of knowledge transition.
Provide inputs to estimates for Change Requests
Oversee development teams; internal or contract, both on shore and off, providing oversite to ensure quality, scope, and fit-for-purpose.
Support Infrastructure and Architecture functions in enforcing conformance to architectural guidance, constraints, blueprints, and principles
Provide professional support and consulting to developers and users in environment and infrastructure area.
Building first class products our customer love Goal setting for team members
Held weekly team meetings and involved staff in planning and decision-making and Reported progress goals suggestions and all issues to management.
Project: Takeda(Takeda Pharmaceutical Company Limited)
Technology/Software: SAS,SQL and Unix.
Role: Senior Statistical Programmer.
Project Description:
Takeda is a patient-focused, values-based, R&D-driven global biopharmaceutical company committed to bringing Better Health and a Brighter Future to people worldwide. The company is focused on oncology, rare diseases, neuroscience, gastroenterology, plasma-derived therapies and vaccines.
Project Responsibilities:
Involved in providing analysis support for Phase I and Phase II of clinical trials. Created SAS datasets using CDISC Study Data Tabulation Model SDTM/ADaM Implementation guide for statistical summaries and analysis.
Wrote new specifications and verified already written specifications for both SDTM and ADaM datasets. Annotated Case Report Form with appropriate SDTM variables referring to IG using Adobe Acrobat professional.
Generated and validated Tables, Listings and Graphs that are used in preparing the clinical study report.
Reviewed study docs like protocol, SAP and worked closely with statisticians, data managers and provided comments and once finalized, I used the same to develop analysis reports.
Worked on developing Trial domains data specifications and dataset.
Transformed clinical data to CDISC standard tabulations.
Developed and reviewed specifications along with the revision, maintenance of documents and kept track of changes to communicate with other programmers.
Created RTF and PDF outputs using output delivery system.
Used Proc Sql for creating macro variables, dataset/TLF derivations.
Project: BCBCSMA (Blue Cross Blue Shield of Massachusetts)
Technology/Software: SAS Developer, Netezza, SQL, Unix. Role: SAS Developer.
Project Description:
BCBSMA is a state licensed private health insurance company under the Blue Cross Blue Shield Association with headquarters in Boston. BCBSMA has non-profit status as a health insurer and has 2.8 million policyholders, the largest number of any insurer in Massachusetts, with most policyholders.
Environment: SAS, SQL server, Netezza, IBM tools, WinSCP, WINSQL, Unix and Excel.
Project Responsibilities:
QEDM Application Development and handling the work request related to SAS and reporting. Providing support for multiple applications.
Responsible to complete the user requirement according to AQC contract with providers in the reporting area using SAS application
Responsible for all the code enhancements and new releases. On time delivery and in line with customer expectations.
Responsible for requirement gathering, project meetings, design spec preparation, managing scope, planning, tracking, delivering the End product to user Point of contact for any escalation, issues raised by the client related to QEDM application.
Will be responsible addressing the issue / escalation and taking it to closure.
QEDM Application Development and handling the work request related to analytics and reporting. Providing support for multiple applications.
Responsible for all the code enhancements and new releases. On time delivery and in line with customer expectations.
As a Data Consultant, should be accountable to provide analytical solutions to Quality and Efficiency Data Mart business problems and enhancements as per contract with providers in the financial claim processing using SAS programming and DW changes.
Perform Explorer Data Analysis using program SAS (Statistical Analysis and System) Procedures like Proc SQL, PROC Means, Proc Summary ... etc., which create the summaries at different levels like Provider, Primary care physician, Healthcare products, risk type and diagnosis code.
Responsible for requirement gathering, project meetings, design spec preparation, managing scope, planning, tracking, deliver the End product to user.
Point of contact for any escalation, issues raised by the client related to QEDM application. Will be responsible addressing the issue / escalation and taking it to closure.
Worked with onsite team and communicating with them and understanding implications of various scenarios.
Project: BOA (Bank of America)
Project Name: CARD SERVICES Project.
Technology/Software: Data Stage, DB2, Unix.
Role: ETL developer/Tester.
Project Description:
Bank of America is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. The main aim of the project is to convert the UNIX scripts running in the system into DataStage jobs by analyzing the scripts (UNIX and Perl) and need to create a flow diagram and then to DataStage jobs.
Project Responsibilities:
Creation of Flow charts, HLD's (High Level Document) and LLD's (Low Level Document) documents for the scripts analyzed.
End to end testing of the box, which includes execution of jobs in other servers as well.
Set up and new region for running existing production scripts in the lower region.
Detailed analysis of UNIX, Perl scripts.
Designing DataStage jobs by using flowcharts and HLD's as inputs.
Create AutoSys jobs for running the DS code in the testing region.
Create test cases for DataStage jobs and sequences.
Correct data types, consistent formatting, retrievability, and usability are just a few of the criteria that define data of good quality by using Information Analyzer.
Created generic jobs for UNIX commands for removal of execute command stages in sequence jobs which are running on Head node.
Unit test case preparation and testing.
Defect analysis and fix.
Created documents for every DataStage job (Runbooks, Execution documents and Process Recovery documents).
Involved in testing a framework that performs various checks on data.
Involved in SIT/UAT testing, Review process of DataStage jobs.
Project: TIAA-CREF Up gradation
Technology/Software: Data Stage, SQL, Unix.
Project Description:
TIAA-CREF is a leading financial services organization. The firm is a leader in helping those in the academic, medical, cultural, and governmental and research fields plan for and live in retirement.
TIAA-CREF currently uses Informatica 7.5/ Data stage 8.1 to load data into Enterprise Data Warehouse, this project aims at migrating the existing Informatica mappings to Data stage 11.3.1 Parallel Jobs and Upgrade existing DataStage.
8.1 code to DataStage 11.3.1 to bring in efficiency through increased parallelism and provide more scope for other functionalities provided with in IBM Information Server.
Project Description:
TIAA-CREF is a leading financial services organization. The firm is a leader in helping those in the academic, medical, cultural, and governmental and research fields plan for and live in retirement.
TIAA-CREF currently uses Informatica 7.5/ Data stage 8.1 to load data into Enterprise Data Warehouse, this project aims at migrating the existing Informatica mappings to Data stage 11.3.1 Parallel Jobs and Upgrade existing Datastage.8.1 code to DataStage 11.3.1 to bring in efficiency through increased parallelism and provide more scope for other functionalities provided with in IBM Information Server.
Project Responsibilities:
Upgrade Existing code of DataStage 8.1 to DataStage
11.3.1. Version by improving performance techniques. Create the job sequences based on the requirement and execute without any warnings and errors through Autosys tool.
Creating, Updating, and scheduling the Box jobs to trigger the DataStage jobs in Autosys in different environments like Smoke Test and Side by Side Testing (ST) Successfully Upgrade 5 projects in 4 months' time to client in DataStage 11.3.1.
Providing technical and functional support for team members involved in the project.
Ensure that the project deliverables adhere to the company guidelines and satisfy the client with adherence to timelines and quality of code.
Single point of contact for all 5 projects supports and enhancement and Administrator activates.
Fixing of code and data related bugs in the existing DataStage Jobs.
Developed Test cases based on time stamps and prepared code review checklists.
Magic Hour Events and media
Senior Software Engineer, SAS
Project: Internal Project
Technology/Software: SAS Base/Graph/ODS/Stat/Sql, Unix, windows
Role: Statistical Programmer
Identifying the tools to use in the process.
Implementing the process in intervals and testing the process.
Used SAS ODS to create HTML, RTF and PDF output files in the process of producing reports.
Used SAS PROC SQL for data validation after transformation.
Used SAS DATA NULL and PUT statements to create customized reports.
Extensively using existing macros for report generation using SAS/Macros as per the customer's requirements.
Used Base SAS functions like ROUND, SCAN, TRIM, LENGTH, PUT, INPUT, DATE, MAX, MIN, MEAN and STD etc .
Default Report output is HTML and provided the options of RTF EXCEL formats using SAS/ODS statements.
Maintaining large data sets, i.e Reading in data from various sources in various formats to create SAS data sets Documenting the process, i.e Documenting all the possible information about the application like SAS programs, DATA files and source Creating ad-hoc reports.
Reporting bugs into HP ALM/QC Created basic statistics using PROC MEANS, PROC SUMMARY, PROC UNIVARIATE, PROC FREQ.
Used SAS codes for data extraction and testing the data prior and post transformation using the business logic for transformation.
Used Proc compared to compare the pre and post datasets to identify the data issues between datasets.
Senior Software Engineer, SAS/Statistical Programmer
Senior Software Engineer, Mahindra Satyam
Project: Clinical development - Biometrics
Technology/Software: SAS Base/Graph/ODS/Stat/Sql, Unix
Responsibilities:
Led in the design and implementation of analysis and programming of reports used for analyzing clinical trials data.
Attend Technical Kick-off Meetings with clients to get project requirements and systems involved, and act as main point of contact for ongoing issues.
Provide input into assessments of resource requirements on a regular basis. Provide feedback to management if any action is needed to increase utilization, improve efficiency or amend the resource levels required on a project.
Created Analysis Data Set from raw data sets according to specifications based on mock shells and analysis plan.
/*Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
Maintained and updated existing utilities as per project requirements.
Programming Edit Checks for data cleaning, generating listings of data errors based on the Data Validation specification.
Assisted with development, implementation, maintenance, and user support of programming tools and process methodology within the department.
Active involvement in knowledge sharing via presentations at monthly programming meetings. Mentoring new joiners to help them understand SOP's, Process Manuals and other standards followed within the organization.
EDUCATION
MBA.,
.
Contact this candidate