MYTHILI MALLEPALLY

Frisco, TX 302-***-**** ac4eed@r.postjobfree.com

SUMMARY

Highly skilled senior data analyst offering 8+ years of experience in data analysis, data profiling, data migration, data masking, performance tuning and application development.

Worked with disparate data sources – Oracle, Tera data, SQL Server and Flat Files

Develop a thorough understanding of the data environment - data collection, data sources, data accessibility and tools

Develop automated weekly and monthly reports

TECHNICAL SKILLS

Databases

Oracle 9i/10g/11g/12c, Microsoft SQL Server, Microsoft Access

Languages

PL/SQL (Procedures, Functions, Triggers, Cursors, Packages), SQL, Shell Scripting, C, VB script, XML, HTML

Oracle package & utilities

SQL* Loader, import/export, REF cursors, External tables, BULK collect, Materialized Views, Explain Plan, Packages – UTL File, DBMS Scheduler

Packages

IBM Infosphere Optim, Oracle AOL, Informatica, SAP BO – Desktop/Web Intelligence, Crystal reports & Xcelsius

Version control Tools

Kintana, PVCS, Git

Tools

SQL* Plus, Toad, SQL developer, Eclipse, Ignite, BitKinex, Informatica 9.6.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor, Teradata, Tableau

OS

Sun Solaris(Unix), Windows.

Process Tools

Jira, Wiki, Mercury Quality Center

PROFESSIONAL EXPERIENCE

BI WORLDWIDE – PLANO, TX

SENIOR DATA ANALYST OCT 2014 – TILL DATE

Employee Recognition and Rewards Platform helps organizations to builds a global employee recognition strategy that motivates, rewards, and inspires outstanding employee performance.

Build program modules to read multiple data sources and store in denormalized rolled up data sets for reporting purposes.

Data Modeling for storing denormalized data sets.

Data profiling for understanding the data sets/feeds.

Manage data pulls of varying size and complexity

Ensure accuracy of data reporting

Develop a thorough understanding of the data environment - data collection, data sources, data accessibility and tools

Develop automated weekly and monthly reports

Participate in client calls as technical point of contact.

Build, maintain and enhance Oracle applications in PL/SQL including unit test preparation & execution for customizing the platform to tailor individual client needs.

Performance Tuning- SQL, Packages/Functions

Responsible for timely documentation of design and implementation, including assumptions, analysis, options considered and performance

Collaborate with analysts and other technical partners for implementation and design decisions

Load data from Flat files into Oracle database.

Technical Environment – Oracle 12c, SQL, PL/SQL, Toad, SQL Developer, Unix, Putty, Git, Ignite, Excel

BARCLAYS BANK – WILMINGTON, DE

SENIOR ANALYST, MARKETING ANALYTICS (AS A CONSULTANT) JAN 2012 – MAY 2014

Developed Excel reports to analyze profitability trends by making extensive use of SQL/SAS for data analysis to manage budget effectively

Analyzed online/direct mail marketing campaign performance by investigating variances against forecast and budget for partner portfolios; performed root cause analysis when required

Enhanced existing MIS to drive easier partner payment tracking

Compiled senior management presentations on a weekly/monthly/ad-hoc basis

Extensive knowledge of SAS, SQL, UNIX and Excel (Pivot tables, VLOOKUPS, Macros, Essbase)

Technical Environment – Windows 7, SQL Developer, EXCEL, SAS, TERADATA, SAS/MACROS

WELLS FARGO – MINNEAPOLIS, MN

SENIOR DATABASE ANALYST (AS A CONSULTANT) MAY

2014 – OCT 2014

Masking data with IBM Infosphere Optim on distributed platforms for MODE applications

Gather requirements to mask sensitive data using Optim.

Build VB script procedures & modify C exit routines to accommodate the customized masking needs.

Extract, Cleanse and Mask high volumes of data - 80 million records.

Build SQL queries/procedures to do regressive testing.

Automate the data masking procedure using Optim command line utility.

Load csv files to lookup tables in SQL Server

Data profiling and build transformations for source to target mappings

Data validation

Technical Environment – Windows 7, Oracle 11g, SQL, C, VB Script, IBM Infosphere Optim, SQL Server(2008), SQL Developer, Teradata, SAS, SAS/MACROS, EXCEL, WORD

TECH MAHINDRA – HYDERABAD, INDIA

SENIOR ANALYST MAY 2006 – FEB 2010

Develop CPAM (Customer- Partner Account Management) to create Customer Accounts, Sites & Site uses and link to Parties/ Partners available within Customer Hub(used TCA model).

Involved in multiple projects to Design, develop and test software components including Integration Testing, QA and UAT

Performance Tuning

Responsible for timely documentation of design and implementation, including assumptions, analysis, and performance

Collaborate with other technical teams for implementation

Responsible for providing fast and timely Development support for production issues.

Responsible for production release scripts creation, validation & deployment using Kintana.

Unix Shell scripting

Code migration from Teradata to Oracle

Data Modeling

Responsible for porting scripts (procedure and views) from Teradata to Oracle.

Technical Environment – Windows 7, UNIX, Oracle 10g, SQL, PL/SQL, PVCS, Kintana, Mercury Quality Center, Teradata

EDUCATION AND CREDENTIAL

Bachelor of Engineering from Osmania University, MVSR College of Engineering, Hyderabad, India

Oracle Certified Professional.

5467 Imperial Meadow Dr, Frisco, TX

Cell: +302-***-**** Email: ac4eed@r.postjobfree.com

Contact this candidate