Ramya G

acu0r8@r.postjobfree.com

404-***-****

SUMMARY

•3 years of experience in analysis, design, and re-engineering of system applications and business processes, using structured system analysis methodologies, placement of business controls, diagramming data and process mapping, applying Unified Modeling Language (UML) diagrams.

•Strong knowledge of SQL, data analysis and data validation using SQL.

•Extensive experience in creating and maintaining source to target Data mapping documents

•Strong documentation and analytical skills, strong problem-solving skills.

•Assisted with the development and execution of detailed system and user acceptance test plans, test cases and test scripts for manual and automated testing.

•Extensive exposure to End-to-End testing, System testing, Regression testing and User Acceptance testing (UAT).

EDUCATION

Master of Science in Information Technology from Kennesaw State University, May 2016 with 3.92 GPA.

Bachelors of Science in Information Technology from JNT University, India. April 2012.

SKILLSET

DBMS

Oracle 11g,12c,MS SQL

Presentation

HTML, XML, CSS, Javascript, AJAX

Operating Systems

Windows XP,7,8,10

Miscellaneous

Software Testing, Java

ETL Tools

Informatica Power center 9.5 (PowerCenter Designer, workflow manager, workflow monitor), IDQ

Packages

MS Office, MS Outlook, MS Access

Methodologies

Waterfall, Agile-SCRUM

EXPERIENCE

Grand Infotech, Atlanta, GA

Duration: November’ 15 – May’16

Designation: ETL Business Analyst Intern

•Reviewed the business requirement document (BRD) with the management and the technical teams.

•Gather business Requirements and create Use Cases by extensive requirement gathering sessions and JAD sessions.

•Participated in the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every report of Information Technology Department.

•Work extensively with the QA team for designing Test Plan, Test Cases and coordinated with the IT team in configuration of Test Environment and performed the User Acceptance testing (UAT).

•Work in SQL and Oracle environment dealing with extraction, analysis and processing of SQL Queries.

•Facilitate in the overall management of the projects including risk analysis and mitigation, status reports, client presentations, defining milestone deliverables and establishing critical success factors.

•Monitoring the day to day activities and ensuring that the tasks assigned to the team are completed on time

Environment: MS Office, Visio, Oracle 11g/12c, Data warehouse, Informatica Powercenter 9.5, Sql server

NexWave Talent Management Solutions, Hyderabad, India

Duration: April’ 12 – April’ 14

Designation: Business Analyst

•Gathered existing system information in order to understand the existing functionality of the system.

•Analyzed the impact of new functionality on the existing system in order to make changes to the system.

•Facilitated Joint Application Development (JAD) sessions and Interviews to create business rules, validation rules and data enrichment rules.

•Assisted in creating wireframes for the functionality being developed.

•Communicated effectively with Business Teams, Information Architects, Development Team, Testing Team and Content Writer Team by conducting story board sessions and walkthroughs.

•Acted as a liaison between Business Team and Development Team as well as assisted Testing Team in understanding the functionality by conducting walkthroughs and clearing issues and defects.

•Answered associate's general HR questions

•Processed associate hires, transfers, and departures.

•Maintained standard reports weekly, monthly and quarterly.

•Produced ad-hoc analysis and reports for internal and external clients.

COURSE PROJECTS:

Database Administration and Auditing.

•Designed a database for acme.inc by creating tables, users and assigning permissions based on their job role.

•Created ER diagrams for 20 tables.

•Created schema and gave permission to users to access the tables according to their roles.

•Generated trigger for the billing generation which automatically stores the data in a specific table.

•Used the virtual database concept and Fine grain auditing model to audit the tables.

Web Designing.

Designed a website for a bookstore by maintaining consistent style and layout.

Used bootstrap as the foundation of the design. Created static and dynamic pages and maintained the navigation between pages.

Created database at backend and used XML, JSON formats to parse data. Also used external search resource like open book library URLs to retrieve data from other sites.

Used advanced search methods for sorting based on price, reviews, rating etc.

Used JavaScript Libraries like AJAX, JSON to get the results and display them in browser.

Service Level Agreement(SLA).

This project is about writing SLA on Mobile Banking. Analysed the requirements and documented a contract between service provider and end user(Bank). The document includes, when the service is available (percentage uptime) and the limits outages can be expected to stay within based on the requirements provided by end user.

IT System Acquisition and Integration.

Analyzed the present situation of a company and proposed a new system in order to upgrade legacy systems with in proposed budget. Documented current and proposed system and look for a number of approaches for modeling the present system. Within a dynamic rapidly changing business environment, producers are constantly entering and leaving market. At the same time changing customer preferences provide signals for businesses to develop new strategies with different products and services. Some business will succeed by responding to and meet market needs, while others may not perform quite so well.

Contact this candidate