Resume

Sign in

Data Developer

Location:
Glen Allen, Virginia, United States
Posted:
December 12, 2018

Contact this candidate

Resume:

PRUDHIVI USHA

SUMMARY

PH: 571-***-****) E-mail: ac7x45@r.postjobfree.com

Around 7 years of experience in Information Technology industry with a strong background in Analysis, Design and Development in the field of Data Warehouse, Business Intelligence Data Modeling and Implementation on major components in Hadoop Ecosystem including Hive, HBase, PIG, Sqoop, & knowledge of Map Reduce/HDFS and SparkFramework.

TECHNICAL SKILLS

Operating Systems:: Windows’95, 98,’NT, Solaris, Linux.

Internet technologies: JDBC, ASP Development Tools,Tableau, Toad, SQL Plus, SQL Developer

Client Side Technologies: HTML4.0, DHTML, JavaScript and VBScript

Languages: Python, C++, VC++, Java 1.8 Productivity Software: MS Project, VISIO, MS Office

Configuration Tools: SVN, Team Foundation Server 2008 and Git.

Software Tools: Bugzilla, Service center.

IDE: WSAD 5.1 and Rational Application Developer 7.0 Web/Application Server: IBM WebSphere, IIS

Databases: FoxPro, Oracle,8i, 9i,10g,11g,12c,MS-SQL.

Testing Tools: Mercury Test Director,, Quality Control Center

GUI: Visual Basic6.0

WORK EXPERIENCE

CLIENT Verizon communications

LOCATION: Virginia DURATION: Jun 2016 July2018

POSITION: Hadoop Developer

DESCRIPTION Verizon Wireless Inc. is a leading global broadband and telecommunication companies in the USA. Theproject which aims in fulfilling need for reporting to better understand the market trends, behavior, future opportunities and to improve Decision making process. Data for this Data Mart is captured from different Transactional Databases like: Sales subject area, Sales service request subject area, Product defect subject area, etc. The main aim of this project was to collect and analyze the raw logs from STB to put forth the customer’s field of interests and create reports, dashboards for marketing team.

RESPONSIBILITIES

Managed all Project releases with full software development life cycle and executed this projects using Agile methodology -SCRUM Approach.

Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle12c, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.

Developed mappings, sessions and workflows in Informatica Power Center.

Applied slowly changing dimensions like Type 1, 2, 3 effectively to handle the delta Loads.

Extensively used transformations like Expression, look up, Aggregator, Stored Procedure, Router, and Normalizer, Update and sequence generator, Rank.

Tuned performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

Understood Hadoop main components and Architecture and working with Hadoop Distributed File System.

Hands on experience in Configuring and installing Hadoop and Hadoop ecosystems (Hive/Pig/HBase /Sqoop /Flume).

Involved in loading data from LINUX file system to HDFS.

Experience in managing and reviewing Hadoop log files.

Importing and exporting data into HDFS and Hive using Sqoop.

Involved in creating Hive tables, loading with data and writing hive queries that will run internally in map reduce way.

Hands on with MapReduce Programming Model.

Exported the analyzed data to the relational databases using Sqoop for visualization and to generate reports for the BI team.

Hands on object oriented programming (OOP) concepts using Python.

Experienced in working with various Python Integrated Development Environments like IDLE, PyCharm, Eclipse, and PyDev.

Hands on with Requests, Numpy, Scipy, Matplotlib, and Pandas python libraries.

Knowledge on Flume collector and Oozie workflow scheduler.

ENVIRONMENT: Informatica 9.5, Oracle 12c, Python, Hadoop- Hdfs, MapReduce, Hive, Pig, Hbase,

CLIENT: Medstar HealthCare

LOCATION: Washington D.C.

DURATION: Aug2015– May2016

POSITION: Informatica Developer

DESCRIPTION

Medstar Health an extensive regional health network throughout Maryland and Washington, D.C. metro area. The information technology department is nationally recognized within the HealthCare industry and this project involves working in Decision Support Systems for design and development of new data marts and enhancing the existing data warehouse. The data generated is used for analytical decisions and for report generation.

RESPONSIBILITIES

Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.

Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.

Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

Applied slowly changing dimensions like Type 1, 2, 3 effectively to handle the delta Loads

Extensively used transformations like Expression, look up, Aggregator, Router, and Normalizer, Update and sequence generator, Rank.

performance tuning of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

Written SQL Queries and stored procedures for Data Validation

ENVIRONMENT: Informatica Power Center9.1, Oracle11g, DB2, SQL, UNIX, Windows XP, PL/SQL,

UNIX Shell Scripts,

CLIENT Kausalya Management Services Pvt Ltd,

LOCATION: Hyderabad, INDIA

DURATION: Oct 2005 to Dec 2011

POSITION: Programmer

PROJECTS: Construction Management System, Kapil Financial services, Kapil Chit Website (www.kapilchit.com),www.Esahaya.com, and Chit Fund Management System (Easy CHIT)

DESCRIPTION

Construction System: A comprehensive system designed to manage and maintains the details of Members who have invested an amount in the firm on interest basis. The modules include Member module, Accounting Module, Reports Module. Member Module: It Includes entry of member details, nominee details, amount invested and mode, period of interest. It also includes the Agent set up. Accounting module: It includes day-to-day transaction like receipt entry, payment entry, member entry,

Bank Reconciliation statement etc. Report module: It includes daily collection reports like cashbook, bankbook, Comparison Trail balance, Bond Issue Report, Bondholders Report, Agent Commission Report and Member monthly Interest payment Report Kapil Financial Services: Kapil provides a broad range of investment products and services through an array of investment management affiliates. The project is aimed at processing of these files and loading them into Database. This information is used by other projects for providing services to clients and vendors. It also involves the writing database data to files in various XML formats. These files are transmitted to clients and vendors. The processing of the inbound files and generation of outbound files are scheduled using scheduler.

KapilChit website:

Kapil Chit funds are a 25-year-old private limited company registered in the year 1981. Over the years, they have satisfactorily serviced over 4, 00,000 subscribers. Over 2000 people work every day to at various levels in the organization helping the company grow and nourish; thereby helping them climbs up the value chain.

Kapil attributes its growth to the trust and reliability that the company has been standing for. Over the years Kapil has gained the reputation of being a solid saving and support system that values every rupee its subscribers save. Trust is a word, which is synonymous with Kapil Chit Funds.

www.Esahaya.com : Esahaya is a free classified ad’s website for Advertising. Searching, Browsing and placing your classified is all free on esahaya.com.A very simple and user friendly interface.

No registration and easy to post the classifieds to any location and category.

Chit Fund Management System (Easy CHIT)

It is an ERP for the Para banking Companies. It handles all the functionalities of the Chit Fund industry right from the formation of chit groups, Entry of subscribers, Maintenance of the guarantor details and the functionalities of the legal and recovery cell also. Major Modules comprises of Accounting Module, Administrator module, Search Module, Guarantor Module MIS Reports Module, Payroll Module. Legal Module.

Accounting Module includes accounting activities like passing journal entries, chit receipts, payments, General Receipts, Payments, the Bank Reconciliation statement, maintaining subscriber balances

Administration Module is to enforce certain strict restrictions on the user of the application and give permission for certain modules which include User Rights and User Setup, and some of other major setup like group formation, Securities setup, TR Management Setup.

Guarantor Module includes Prized Subscriber Information, Guarantors Information, and Verification Details of the guarantors.

Search Module is keep track of Subscribers who are subscribed in different branches. At the Central level this module helps in keep tracking of defaulted subscribers.

MIS Reports Module Includes General Daily Collection reports and report, which depict the Monthly Profitability report and Performance of the branch. The reports also include generation of final account statements like Profit & Loss a/c and Balance Sheet. Legal Module includes and also includes the details of Suit filed Court cases. It also keeps record of Postponed cases and stages of case. The reporting system includes generation of Cause List, Next date Case details, Advocate of particular cases, how many cases are there in a particular court etc.

RESPONSIBILITIES

● Managed all Project releases with full software development life cycle Phases.

● Served as Point of Contact between Development Team and the Users to coordinate the requirements and make the team better understand them.

● Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules

● Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.

● Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse

● Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

● Applied slowly changing dimensions like Type 1, 2, 3 effectively to handle the delta Loads

● Extensively used transformations like Expression, look up, Aggregator, Router, and Normalizer, Update and sequence generator, Rank.

● Develop mappings transformations like Filter, Joiner, Sequence Generator and Aggregator and perform query overrides in Lookup ransformation as and when required to improve the performance of the mappings.

● Implemented Incremental Aggregation to improve performance while dealing with sources that changed slowly over a period of time.

● Created workflows, monitored session runs.

● Co-ordinate with team members for effective management for all project requirements and responsible for deliverables and receivables during all project phases.

● Extensively involved in creating database packages, procedures, functions, cursors and triggers using PL/SQL.

● Involved in creating target database for the Data marts.

● Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

● Written SQL Queries and stored procedures for Data Validation

● Involved in Production support activities and root cause analysis of production issues

● Involved in the clarification review meeting with the business and understand more at task level

● Involved in the design of all requirements pertaining to each project release.

● Participation in Database Design discussions.

● Created Several Oracle Procedures to integrate them into application using Java JDBC.

● Maintained strength of 6 developers to execute the tasks for these project releases.

● Involved in Accounting, Search, Guarantor And MIS Reports Module.

● Created forms and bill Receipt and Voucher for Receipt and payment module which is used to store the details of the subscriber receipt and payment details.

● Created Form For Search Engine in which at branch level if name, surname are entered then it is checked if with the given name the person is having any chit or if he has kept pledged to any other person.

● Created forms for Prized Subscriber information entry, verification process entry and Chit Pledge Report.

● Created number of reports for Credit, Sales, Account Receivables, and Account Payables. These reports used Crystal formulas, Parameters, Selection criteria, Sub reports, Graphical Representations etc.

● Extensively used Crystal Reports for major accounting transactions like Ledger, MIS report module

● Responsible for writing Complex Formulae to show derived fields and to format the data based on specific conditions.

● Used Crystal Reports for the Following Module.

● Written database stored procedures, Views.

● Designed and developed web forms using ASP

● Used ADO for accessing data from the SQL Server 2000 database

● Extensively used validation controls to validate input fields.

● Designed the web pages and programmed the web enabled modules using ASP, HTML, DHTML, VBScript, and JavaScript.

● Analyzed the data in FoxPro, and the systems that uses FoxPro. Create stored procedures and Triggers to intercept FoxPro table data into Oracle table.

● Implemented the Deployment process in deploying various artifacts for each cycles to all higher environments DEV and UAT

● Design and implement, working with QA team to review test cases post check-in automated unit and system tests.

● Established and documented workflow.

● Performed Integration, End-to-End, system testing

● Deploy the code into UAT Environment by submitting an E-mail to Infrastructure Teams.

● Prepared the system specification document explaining the user interaction on to system modules.

ENVIRONMENT

Informatica Power Center 8.6/7x, Oracle11g/10g/9i, DB2, UNIX,, PL/SQL,UNIX, WINDOWS 2003/XP, HTML, CSS, JavaScript, JSP, XML,, JDBC, log4j, HTTP, J-Unit, PL-SQL, Shell Scripting, Scheduling (CRON,), WSAD 5.1, Rational Application Developer 6.0, IBM WebSphere,StarTeam 2005,Microsoft Project Plan, Microsoft Visio, Microsoft Office, Excel, Bugzilla, ASP, Visual Basic 6.0,, Seagate Crystal Reports 9.0

EDUCATION

Master of Science – University of Madras Post Graduate Diploma in Computer Application



Contact this candidate