Over 8+ years of experience in I.T industry with extensive subject matter expertise in IT Services Management (ITSM) and ITIL, methods, processes, strategic technology infrastructure planning, IT Customer Communications and developing cost effective solutions to meet customer business requirements. Experienced in ITIL Service Support areas of Incident, Problem, Change, Release, and Configuration Management. ITIL V3 foundation certified As a Business Analyst helped the team in Business process improvement, data analysis and warehouse management, Design Forms employs root cause analysis to identify issues and develop process improvements that lead to cost savings with exceptional planning and implementation capabilities. Researches, evaluates, and recommends enterprise forms tools, processes, workflows. Developed the business strategies to bridge the gap between business problems and technology solutions. Competency Areas: Defines and documents customer business functions and processes. Consults with functional unit management and personnel to identify, define and document business needs and objectives, current operational procedures, problems, input and output requirements, and levels of systems access. Develops and maintains working relationships with other business areas to assist with strategic Enterprise goals. Researches, evaluates, and recommends enterprise forms tools, processes, workflows. Acts as a liaison between end-users, technical analysts, information technology analysts, consultants and other organizations in the analysis, architectural, design, configuration, testing and maintenance of systems to ensure optimal operational performance. Analyzes the feasibility and develops requirements for new systems and enhancements to existing systems and ensures the system design fits the needs of the users. Provides business partners with direction and communication as needed. Design new and revised form layouts utilizing a dedicated form development software package. Tracks and fully documents the changes for functional and business specifications; writes detailed universally understood procedures for permanent records and for use in training. Identifies opportunities for improving business processes through information systems and/or non-system driver changes, assists in the preparation of proposals to develop new systems and/or operational changes. Consults with business partners to provide technical advice on forms/communications. Research and drafts recommendations regarding current issues and potential trends. Participates in studies of new and existing programs and special projects to determine feasibility, resolve problems including organizational, procedural, technical and fiscal research and analysis; develops policy and procedures to improve efficiency, cost-effectiveness, and/or improve internal and external customer service Senior Business, Data and Statistical Analyst with experience in SAS development and testing in financial, Banking, Manufacturing and Healthcare industries. Executed Enterprise Data and Analytics data quality tests/assessments and data cleansing activities. Knowledge of frequency and duplicate analysis, redundancy analysis, data extraction techniques and applications. Enthusiastic to develop new skills in a dynamic environment. Prepared and published customized reports/dashboards. Converted MicroStrategy reports into Tableau. Extensive experience to use MS Office products like Excel, power point, word and Visio Experience with Excel functionality including pivot tables Extensive experience on Documenting process steps to support future process development and product offering Extensive experience on reviewing existing application, design and suggest ways to increase efficiency, functionality, and performance. Extensive experience on all phases of project lifecycle (design, build, test, and implementation), including business process change and enhancements Extensively involved in the creation of SAS data sets, reports, listings, and graphs according to the Standard Operating Procedures (SOPS). Experience on gap analysis on business requirements and technical design, recommend adjustments if necessary Experience in using various MS office tools for analyzing, arranging and presenting data. Working knowledge of SQL. Result oriented, committed and hard working with a quest to learn modern technologies and undertake challenging tasks. Ensured accuracy, completeness, integrity, consistency, uniqueness, and timeliness of data. Good analytic skills pertaining understanding a business domain coupled with excellent teamwork and effective communication skills.
|
- Project: CDE Data Quality and Validation.
- As a SAS Business Analyst implemented data quality rules for data across the NAM businesses for UB Consumer (e.g.
- Branded Cards, Retail bank Loans and Mortgages) and Citi retail services lines of businesses.
- Created data profiling reports, insights and analytics in support of the critical data office, critical data elements and credit card divisions.
- Created functional and Technical specifications documents as per the business requirements.
- Analyzed complex business problems and production issues using data from internal and external sources to provide insights to decision makers.
- Prepared best coding standards and performance tuning techniques to improve the quality and performance in warehousing process and in the generation of reports.
- Assisting the stakeholders in finalizing the requirements for new system to be developed.
- Creating the mock ups of the expected system functionality for the customers.
- Generated data sets and reports for analysis using Proc SQL, Proc Report, Excel etc.
- Validated the data and reports and provided the insights to the business team.
- Responsibilities:.
- Created functional and Technical specifications documents as per the business requirements.
- Created Requirement Traceability Matrix for project requirements and processed change requests as required.
- Data transmission and integrity check of the SAS datasets.
- Executed Enterprise Data and Analytics data quality tests/assessments and data cleansing activities.
- Knowledge of frequency and duplicate analysis, redundancy analysis, data extraction techniques and applications.
- Trained new team members on project requirements and job responsibilities.
- Teamed up with support team and lead/project managers to meet the time lines, deadlines and created Work Plans, Managing risks and Resource allocation, Skills/Abilities.
- Creating, updating, testing editing and maintained system configuration tables and files.
- Analyzed, interpreted, loaded and tested configuration tables.
- Participated in story writing sessions and BRD/FRD review sessions.
- Involved in Defining test data requirements and following up with QA team to fill in gaps in Defects.
- Assisted in development and execution of testing conditions.
- Involved in requirements gathering, Consulting BAs and updating Descriptions/Acceptance Criteria.
- Good to be enthusiastic to learn and avail oneself to contribute other abilities for team’s/self-growth.
- Environment: Appian Framework Low code Enterprise Application, Atlassian JIRA, SharePoint, SnagIt, MS Outlook, MS OneNote, HP ALM, MS Office 365, Agile Scrum, SAS, Tableau.
- CLSS (Cat Logistics Systems Support) supports Inventory Management or Material Management and Warehouse Management.
- Warehouse management has the features of In-Bound, outbound, Supersession, Returns, Alternate processing, Cycle counting, Kitting.
- Inventory Management or Material Management has features of Supersession, Forecast, Output Array, Deployment, Min/Max, DRP, MOA, POA, Kitting, and CSM etc.
- Responsibilities:.
- Developing SAS codes as per the requirement.
- Used SAS Data Integration Studio to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into Data marts and Data warehouse database.
- Executed SAS programs in UNIX environment.
- Used SQL to implement table joins.
- Extracted data sets from server using PROC IMPORT and created datasets in SAS libraries.
- Coding SAS programs with the use of SAS/BASE and SAS/Macros for Ad-hoc reports.
- Created charts showing performance using SAS/GRAPH.
- Environment: SAS/BASE, SAS/Macros, SAS/Access, SAS/Stat, SAS/Graph, JIRA, SharePoint, Tableau.
- State Farm Insurance is one of the biggest Insurance companies in US.
- The Object of the work is that ETL process, report generation as per user requirements.
- The data is available in Excel, flat file formats.
- Extract the data into SAS environment from Excel or Flat file and validating the data according to user requirement by using Base SAS, Macros.
- Preparing functional specifications, Meta data and developing code, test plan, supporting report document.
- Generating reports in PDF excel formats.
- Responsibilities:.
- Defined the Data Implementation Plan and Strategy.
- Created data service transition strategy and plan.
- Reviewed and participated in Service Transition Agreements.
- Trained and educated the various Transition groups about the Release processes.
- Defined the RACI matrix for activities throughout the Release Process.
- Created Job-Aids for different tools used within the data Process.
- Define the tooling requirements in support of the data Change/Release process.
- Helped in creating data change and release policy.
- Consult with client to gather requirements.
- Design SAS Macros which can be generalized for Organizational Use.
- Documented Project Charter, BRD and FSD.
- Involve in all phases of SDLC.
- Data transmission and integrity check of the SAS datasets.
- Wrote code using SAS/BASE and SAS/MACROS to extract data from ORACLE and MS ACCESS databases.
- Produced quality customized reports using PROC REPORT, PROC TABULATE and SAS/ODS.
- Provided descriptive analysis using PROC MEANS, PROC FREQ, PROC SORT and PROC UNIVARIATE.
- Developed Macros to create tables, graphs and listings for routine reports.
- Experience with SAS procedures like PROC REPORT, PROC FREQ, PROC TABULATE, PROC MEANS, PROC SUMMARY, PROC PRINT, and PROC SQL. Used SQL to write queries Extensive experience responsible for programming in SAS using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports. Executed SAS programs in UNIX environment Particularly adopt in identifying in extracting data from oracle using SAS. Capable of utilizing data management techniques like Merging, concatenating, interleaving of SAS & tableau datasets using MERGE and SET statements in DATA step. Extensive programming experience with SAS datasets and procedures such as PROC FORMAT, PROC TABULATE, PROC REPORT, PROC TRANSPOSE, PROC PRINT, and SAS/STAT procedures such as PROC FREQ, PROC MEANS, and PROC UNIVARIATE. Expertise in designing and creating various analytical reports and Dashboards. Expertise in creating Table Calculations, Aggregates, Hierarchies, Filters, Quick filters, Parameters, Calculated measures, Sets, Groups, Formatting, Actions. Performed PROC SQL joins and worked with PROC SQL set operators to combine tables. Responsible for accessing and managing data and for performing queries and analysis. Producing data in various output formats including HTML, RTF, PDF, MS-EXCEL using ODS (output Delivery System). Working experience in coding using SQL Procedures/Functions. Rewrite SAS codes to fine-tune and automate various SAS processes. Worked on data quality rules and ensured the proper implementation of data quality during the creation and modification of data, according to Enterprise Data and Analytics data quality standards, guidelines, metrics and quality-expectations.
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy
Disclaimer
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score
could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
resume Strength
- Formatting
- Personalization
- Target Job
Resume Overview
School Attended
- Andhra University
Job Titles Held:
- SAS Analyst
- SAS Analyst
- SAS Analyst
- SAS Business Analyst
Degrees
- Bachelors of Commerce
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy
