We provide IT Staff Augmentation Services!

Business Analyst Resume

SUMMARY

  • Good Knowledge in SAS Enterprise Guide and SAS BI Dashboard.
  • Experience in creating test scenarios to find errors and confirm programs meet specifications.
  • Working knowledge in creating reports using reporting tools like Crystal Reports, WebI and Tableau.
  • Good expertise in extracting data sources from excel spreadsheets and Oracle tables.
  • Strong knowledge of SQL and worked on Oracle, Teradata and SQL Server.
  • Created complex SQL using analytical, aggregate and custom functions.
  • Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, MS Excel, Notes, Microsoft Outlook.
  • Experience using SQL for simple to complex data manipulation or report generation.
  • Experience in using different relational database management systems like Teradata and Oracle.
  • Documented, summarized and recorded data as per Standard Operating Procedures (SOPs) and FDA regulations.
  • Strong knowledge of SQL and SQL tuning methods on various RDBMS.
  • Excellent interpersonal, communication, Strong leadership, Multi - tasking, Strong analytical, logical, programming and diagnostic skills with ability to work in a fast-paced environment.
  • Quick learner, self-starter, effective troubleshooter, Highly motivated, Enthusiastic, result-oriented and good at resolving data issues, committed to continuous learning, take complete responsibility of projects, Very particular about in-time submissions, good quality work and ability to work independently while being a good team player, Excellent ability in problem solving, complex reports generation.

TECHNICAL SKILLS

  • Aggregate function, Scalar function, Joints, AND, OR Operator, Date function, Having clause, Where clause, Operator in Where Clause.
  • SAS V9.1.1X,2/V8/V6.12, SAS/Base, SAS Procedures: Print, Printo, Frequency, Means, Summary, Tabulate, Chart, Gchart, Plot, Gplot, Univariate, Contents, Compare, Append, Copy, Datasets, Format, Options, Sort, Transpose, Report, SQL, Import, Export .
  • SAS Data integration studio, SAS ETL, SAS Dataflux, Data Quality, SAS BI,SAS data warehouse.
  • Oracle RDBMS, SQL Server, PL/SQL, Teradata.
  • Word, Excel, PowerPoint, Access and Outlook.
  • Crystal Reports, Tableau

PROFESSIONAL EXPERIENCE

Confidential

Business ANALYST

Responsibilities:

  • Gather and document requirements for reporting, project initiatives for new vendor, or business development opportunities.
  • Researches, analyzes, identifies, and evaluates data from assigned problems to evaluate existing and potential trends and issues.
  • Wrote test cases based on business requirements documents.
  • Monitor, test and support system changes for applications.
  • Worked with software vendor to test and deploy application enhancements and fixes.
  • Involved in End- to-end specification, development, testing for software development projects.
  • Wrote complex SQL queries for data validation.
  • Perform complex data analysis and report writing to identify trends.
  • Document applications for use in training, maintenance, and department procedures.
  • Trained co-workers on enrollment file processing.
  • Used Python programming and language to develop a working and efficient network within the company.
  • Ensure programs and business processes meet necessary requirements and are accurately captured in Process Maps and SOPs.
  • Attend meetings, compiles and publishes meeting minutes along with deliverables and other requirements.
  • Confidently works with all levels within the organization to accomplish project goals.
  • Performs other duties as assigned.

Confidential

BUSINESS System ANALYST

Responsibilities:

  • Working collaboratively with customers, as well as internal and external stakeholders.
  • Work with change management teams on creating/modifying business requirements document.
  • Update the Configuration files for Better Performance.
  • Developing and executing test cases (developer, unit and regression), evaluating test results, and resolving defects.
  • Created or modified queries to download data from multiple source systems to create reports according to customer specifications.
  • Work as POC with multiple IT and business groups in identifying issues, deploy fixes and enhancements etc.
  • Performed automate data validations manually across the division to ensure that there are automated controls in place designed to meet Confidential standards and audit requirements using SAS DataFlux.
  • Troubleshoot and work with customers to resolve their EUC related issues and close the loop on delegated tasks.
  • Perform unit testing and integration testing and document test results.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Provide support for alternative and innovative solutions that meet business requirements.
  • Work with UNIX to check difference between two large datasets, run reports in different environment.
  • Used SQL, Oracle and MS Office analysis tools to complete analysis requirements.

Confidential

Data Analyst

Responsibilities:

  • Extracted data from the database using SAS/SQL, SAS/Macros from different databases such as Teradata, Oracle.
  • Wrote complex SQL queries using complex joins, grouping, aggregation, nested subqueries.
  • Performed analysis and presented results using SQL, MS Access and Excel.
  • Compile and validate data; reinforce and maintain compliance with corporate standards.
  • Develop and initiate more efficient data collection procedures.
  • Ensures consistent template design to enhance navigation, usability and comprehension of data displays.
  • Created reports using analysis output and exported them to the web to enable the customers to have access through Internet.
  • Worked on credit risk analysis to figure out the customers to offer new Credit Cards. Helped the analytics and data services for the development of the new business logic.
  • Used SAS, SQL, Oracle, Teradata and MS Office analysis tools to complete analysis requirements.

Hire Now