Data Manager

Lakshmi Atmakuri

Email Id – **********@*******.*** Cell No - 361-***-****

TECHNICAL SKILLS

Business/Data Modeling Tools:

Rational Rose, Requisite Pro, XDE Visio, MS Office Suite

Methodologies:

XP, RUP, SIX SIGMA, PMI, SDLC, SWOT, Cost/Benefit, OOA/OOD

Operating Systems:

Windows 2000/98/95, UNIX, MSDOS

GUI:

Visual Basic 6.0/5.0/4.0, Dream weaver.

Languages:

PL/SQL, JSP, JavaScript, VB Script, HTML/DHTML, Power Builder

Databases

Sybase, MS Access, Oracle, SQL, Crystal Report

Networking

TCP/IP, SDN, IP routing protocols, L2/L3 Switching, IP Protocols: ARP, IP, NAT, ICMP, UDP, GRE, Ipv4 and Ipv6 Forwarding.

Web programming

REST, SOAP.

Testing Tools

Test Director, Winrunner, Quick Test Pro, Gemini

Statistical/ Financial Package

SPSS, Solver, PERT/CPM, @risk

WORK EXPERIENCE

CLIENT: MVP Health Care, Albany, NY. Sep2016 –Aug 2017.

ROLE: Business Analyst

Role & Responsibilities:

Gathered User and Business level Requirements from SME’s in Loan Managers, Insurance Managers, Policy Managers, Car Finance Managers, Home Plan Managers and Leasing Managers pertaining Multi Vehicle Owners, through prototyping and competitor’s websites and User Interface and designed the Business Requirement Documentation and Collection Approach based on the Project Scope and SLC Methodology using RUP (Rational Unified Process).

Interviewing Subject Matter experts and carefully recording the requirements in a format that can be reviewed and understood by both business people and technical people.

Worked on development of FSCD (Financial Services Compensation Development) System based on SFIS system as right from TSD Phase.

Created Mock-up forms in for better visualization and understanding of the software solution and regularly worked with the CMA (Change Management Application) and CDA (Content Display Management) teams.

Created Use Case Models, Analysis Models, Design Models, Implementation Models and authored Use Cases, Use Case Diagrams, Behavior Diagrams (sequence diagrams, collaboration diagrams, activity diagrams) based on UML methodology using MS Visio and Functional Requirement Specification (FRS) and Technical Requirement Specification for application development.

Understand and articulate business requirements from story cards and then convert requirements into technical specifications.

Linked business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement

Facilitated JRP sessions, JAD sessions and Walkthroughs between the Business, Technical and Regulatory teams for meeting requirements as well as solving problems on a daily basis such as, but not limited to, classifying and documenting new change requirements, dealing with multiple product teams, documenting errors and incorporating software enhancements into design documents.

Prepared Business Process Models that includes modelling of all the activities of the business from the conceptual to procedural level.

Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the system Life Cycle.

Authored progress and completion reports, which were then submitted to project manager on a weekly basis.

Developed the Test Scenarios, Test Plan, Test Conditions and Test Cases to be used in testing based on business requirements, technical specifications and/or product knowledge. Tested the application and reported the bugs to the development team.

Analyzed the system requirements and developed detailed User Acceptance Test (UAT), Test Plans, Test Cases, Test Input Data and Test Procedures using Test Manager.

Environment: Windows XP/2000, MS Office suite, MS Visio, MS Project, PL/SQL, MS SQL Server, Java Script, C, C++, ASP, Test Director, Load Runner, WinRunner, HTML, DHTML, XML, VB.NET

Client: Tata Motors Ltd, Pune, India May 2014 – Jun2015

Role: Business Analyst

Tata Motors is a leading manufacturer in Vehicles in Asia. Data Stage was used to transform a variety of files from different product platforms into standardized data marts and data warehouse. The data marts have been designed using Erwin adopting Star Schema methodology. Models were created based on the dimensions, levels and measures required for analysis. Executive Information System (EIS) was developed using Business Objects to give highly detailed or summarized reports.

Role &Responsibilities:

Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, Support and Documentation.

Gathering and documenting requirements, requirements analysis, converting requirements into High Level Design Documents.

Responsible for data analysis, transforming and loading data into the EDW.

Assisted in Creating Test Data studying the Business requirements and directly interacted with the customers for any changes in the requirement specs.

Tracked and managed documents using Documentum.

Created Test Cases using Mercury Test Director 9.0, generated all of the design steps for my modules and ran them in the test lab and logged any defects.

Checked in code, ETL specs, Test cases into PVCS on a daily basis.

Conducted various before and after code reviews.

Data Analysis of source data to meet the EDW requirements

Finalize source data layouts and needs

Created Activity based process models and map as well as roll based models.

Generated Reports using Pivot Tables and Pivot Charts to show the attributes that are currently being solved through an IT build.

Wrote VLOOKUP’s to identify whether or not systems and processes are in place that capture, System of record, and report the data described by the attribute operational definition.

Finalize Compensation and Contracting business team’s needs-data requirements

Design of data structures for housing integrated data in the IA/Data warehouse

Extracted from and loaded data into databases such as Oracle, Teradata, DB2,

Mainframe flat files.

Extensively used SQL & MS Access for backend data analysis and testing.

Validation & Exception reporting on data

Defined business rules, aggregations and lookups

Created process to generate data extracts, validation and QA process

Environment: Datastage 7.5/7.1(Manager, Administrator, Designer, Director, AIX),

Data Warehousing, ETL, Version control, Main Frames, JCL, Oracle 10g/9i, SQL, SQL*Loader, TOAD 7.4, Erwin 4.5, Visio 6, Hummingbird Exceed, OS/390, Sun Fire, W XP Professional.

PROJECTS IN COLLAGE

Brute force attack detection using wireshark. (C/C++, Wireshark).

- Brute force attacks are used for detecting login credentials using random combinations of username and passwords. The project demonstrates a technique by which brute force attacks on FTP servers can be detected using Wireshark Analysis.

Simple C++ Key Logger Project : A project that records the key strokes of PC and store it in intelligent way. Again, that can be easily done with Microsoft visual C++ SetWindowsHookEx API. The premiere challenge is you have to be smart enough to outplay Anti-Virus in detecting your key-logger.

Zip Password Crackers(C,C

-Any File can be unzipped through the command line, providing password as an argument. So, we write a simple brute force program to generate permutations (possible passwords) and send it to command line, creating and running shell script. Run until you receive a success return call.

EDUCATIONAL BACKGROUND

University/Institution Name

Education/ Degree Acquired

Campbell’s Ville University

Masters in Information Technology Management

Silicon Valley University

Master’s In Computer Science

Jawaharlal Nehru Technological

University

Bachelor’s In Electronics and Communication

Contact this candidate