Sql Server Supply Chain

Padma Muskula

**** ************ **

Crystal Lake, IL 60014

Email: ********@*****.***

Contact: 815-***-****

Immigration Status: Green Card Holder

Summary

I have 13 years experience and expertise working in areas of Business Intelligence, business analysis, data

architecture, data warehousing, data integration, and data analytics.

Roles played within various organizations have included data architect, team lead, BI Architect, Universe

Designer, Solution Architect, Senior data integrator and database administrator.

Extensive depth of experience, knowledge and understanding of data warehouse architecture, capacity

planning, business intelligence architecture, implementation, and maintenance of enterprise reporting

systems. An analytical thinker with proven ability to develop and implement BI solutions that support

business and financial objectives.

Skills

Analytic Tools: Business Objects 5.x-XIR2,R3, Crystal Reports, Micro Strategy, Epiphany, SSRS,

Xcelsius

DBMS : Oracle(8.x,9.x,10g), Teradata, SQL Server2005,2008, Informix, DB2, Netezza

ETL : Abintio, Datastage, SSIS, SQL Loader, Terdata Utilities

Architecture: OLTP, Star schema, OLAP, SOA

OLAP: SSAS

Programming: c#, Perl, Shell Scripting, PL/SQL, Erwin

Operating Systems: Linux, Unix, Windows

Methodology: Agile, RUP, SDLC

Web server/Appservers: Apache, Tomcat, IIS, Websphere

Certified Oracle DBA

Sears Holding Company

May 2001- Sep 2009

Business Objects Architect /Project Lead(5.x – XIR2,R3)

Worked as center of excellence in enterprise team.

Project lead for consolidating and migrating to XIR2 from multiple repositories in different environments

across Sears and Kmart to one server farm (12 servers).

Installed, configured, administered and architected new XIR2 environment.

Contribute to publish best practices for the enterprise.

Senior universe designer for several businesses using multiple databases (Informix, DB2, Teradata, SQL

Server, Oracle).

Trained users to self serve to build reports and perform adhoc analysis.

Mentor other developers gather requirements, development and performance tuning.

Businesses – Finance, Merchandising, Ecommerce, Logistics, Home Services

Team Lead Solution Architect/ Senior Data Integration

Worked as a solution architect/ETL team lead for Enterprise Toys business Analytics project. This was a

CIO project which drove 50% (5TB) of the warehouse to be built to provide data for analytics. Lead a

team of 6 people as developers (3 offshore). Solution architecture and high level design for the project is

provided to developers.

Oracle 9.i, Teradata, Netezza, Datastage, SQL Server, Microstrategy

SQL Server 2005 Solution Architect/Database Architect/Senior Data Integration designer

Built a SQL Server 2005 server cluster. Data architecture to build multiple fact tables by function for

effective enterprise reporting (Dashboards, Adhoc Reporting, Canned Reports). Databases built efficiently

with best storage and access plans. Developer’s code reviewed to use efficient queries/Stored procedures.

Built proof of concept and initial code base for developers for SQL Server 2005 BI suite (SSIS, SSAS,

Performance Point, Proclarity, SSRS).

Businesses – Finance, Merchandising, Competitive Intelligence, Operations

Ecommerce Analytics/ CRM

Designed and developed end to end Epiphany datamart for online analytics. Maintained and managed

environment to provide analytics and Campaign Management. Developed Unix, Perl scripts to parse web

logs for site analytics.

Oracle 9i, Epiphany, Unix, Perl, Teradata, Informix

Consultant Allstate Insurance

2000 – 2001

Data migration from EDW (mainframe) to policy data mart (Oracle 8i). Perl scripts are used to create

SqlLoader control scripts and schedule scripts for intial loading. Oracle partition manipulation is heavily

used in these scripts.

Complex Pro*C is used to create ongoing update at a logical unit (Policy) to the mart. PL/SQL procedures

are used to maintain runtime schedule of jobs.

Perl, Oracle 8I, PL/SQL, Unix shell scripting, Pro*C

Procter & Gamble Nov. ’98 – Oct. ’2000

Application DBA in Oracle 8.1.6

Worked on data warehouse (Oracle 8.1.6) using star schema, designed and developed dimension models

for adhoc reporting . Created views for multiple dimensions, hierarchies and levels for multiple business

requirements.

Create, maintain, tune all the source code required to create RAA/RAM cubes for all business modules.

Designed tables required for performance boost.

Design, develop formulas for adhoc reporting tools (Oracle sales analyzer) in oracle 8 using stored

functions, packages and views for financial and supply chain data.

Created adhoc reports, custom measures, custom aggregates and scopes in Oracle sales analyzer.

Developed shell and sql scripts to generate required objects for hundreds of cubes development and to

deploy finished application.

Used Harvest tool for migration.

Businesses: Finance, Supply Chain, Market measurement

Cerner Corp., Kansas City, MO Mar. ’97 – Mar. ’98

Oracle Programmer/DBA

Designed and developed Alertlog Monitoring System using Oracle 7.3.

Designed and developed Space Summary Report. This report is a primary tool for monitoring space

utilization, statistics including segment extents/used & free space/rows and tablespace allocated and free

space. This tool is used extensively by clients and in-house.

Designed and developed Space Trend Report. This is a trend of two space summary reports, generated at

two different points. This tool helps DBAs to project and view how big the database is going to be and

to take appropriate decisions.

Designed and developed Performance Summary Report. This tool reports the current performance of the

database and gives suggestions to the DBA to tune it. Calculations like db_hit_ratio, and gives hints to

verify whether shared_pool_size, sort_area_size, rollback segments are enough and many others. Data is

stored for future references.

Developed a Create Database Tool. A team of three developed this tool. This tool provides different base

versions of databases for the user to select and customize, and then creates the database based on the

selection. It works on VMS and Unix platforms.

Contact this candidate