SUMMARY:

• Over 10 years of IT experience and around 4 years of managing and leading multiple teams working on Data Modeling, Warehousing and Analytics.
• Effective skills in planning, coordination, and execution of system applications and engineering projects.
• Manage internal and external contract resources as needed.
• Experience in design, development and implementation of end-to-end software cycles.
• Experienced in writing system specifications, translating user requirements to technical specifications.
• Strong analytical skills, excellent communication skills, can able to work in a group and also as individually.
• Experience in analyzing and developing metrics for the industries like online advertising, Media and social network sites.
• Proficiency with Data Modeling tools like Erwin to design the schema and do a forward/reverse engineer the model onto or from a database.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Extensive experience in developing ETL processes to extract, transform and load data from various sources including J.D.Edwards, Peoplesoft, Oracle EBS using Informatica, Data Stage and PL/SQL. Designing Analytical Data Marts using MicroStrategy, Business Objects, Discoverer and Siebel.
• Experience in extracting data from heterogeneous sources like SQL server, ORACLE, DB2, and Postgres.

Modeling: ERwin, Visio [for Dimensional modeling, Star and Snowflake schemas]
Languages: Java, C and C++
Database: Oracle 9i, SQL Server 2005/8, DB2 UDB EE 7.2, DB2/400, Green Plum
OLTP: J D Edwards [OneWorld, ERP 9], PeopleSoft, YOUcentric
Tools: Informatica 6.1, DataStage, SSIS,Oracle Warehouse Builder, Siebel OBIEE, Discoverer, Business Objects, MicroStrategy 8, TOAD, Caliber RM, Data Stage 7.x, Together Soft
Operating Systems: Windows 2000, UNIX, and Solaris
Version Control: Visual Source Safe, Star Team, CASE tools (Clear Case)
Requirement Analysis: Caliber RM
Others: UML, Rational Rose.

• Project Management Professional
• Informatica 6.1
• MicroStrategy 8.1
• J.D.Edwards Business Intelligence 4.0 / PeopleSoft EPM 8.8
• OCP Developer 7i

EXPERIENCE:

Confidential, Los Angeles, CA April 2009 – Present Sr. Database Developer

• Co-Ordinate the design and architecture efforts for the data warehouse and ETL process.
• Create and develop the stored procedures, triggers to handle complex business rules, history data and audit analysis using SSIS.
• Tune SQL Objects and debug complex stored procedures
• Code detailed data aggregation procedures which combined various sources; used SSIS\'s fuzzy grouping functionality for data migration and transformations.
• Migrate of packages from Dev-QA-PROD Environments .
• Track the project efficiently with constants updates on the progress and hurdles, focusing on the overall deliverable.
• Provide technical and functional documentation for the project.

Team Lead, Confidential, Los Angeles, CA July 2007 – April 2009 Business Intelligence Lead

• Lead the team to design and develop an analytical solution for a very large data warehouse using the MicroStrategy tool set.
• Effectively managed various stakeholders and business units to understand, integrate, gather the requirements for the reports and dashboards and outline the requirements of various teams.
• Review reporting requirements and existing data, as currently modeled and design of the base reports for the dashboard.
• Schedule reports based on data load and load availability.
• Work along with DBA, Data Architect, ETL and BI team on accomplishing the requirements of the dashboards and accomplishing robust data architecture.
• Migration of objects\\Projects from Dev-QA-PROD Environments .
• Track the project efficiently with constants updates on the progress and hurdles, focusing on the overall deliverable.
• Seamlessly coordinate various programs with in different business unit, with conflicting requirements.
• Document the standards and recommendations for the further customizations.

Advertiser Analytics

• Architect the Business Intelligence layer to be able to provide insights on the Advertisers related to the business and giving them more insight on the advertisements that were served.
• Designed various metrics to analyze the user base of the business, which primarily is the ‘My Space’ user population.
• Implement MicroStrategy schema design, security architecture and develop dashboards, reports and documents.
• Design and develop the reports, to provide the details of the Users who got served by various ads of each of the Advertisers. This helped Advertisers gain more knowledge about their user base that in turn helped target the right audience, thus bringing more revenue to the company.
• Created a technical design document that is a technical translation for the product requirements document.
• Lead the team of in house employees and consultants to customize the dashboard / UI, to provide transparency into the BI tool that was used.
• Use and promote established application development standards, QA and change control procedures.
• Train first and second level support personnel and providing third level support as needed.
• Functional experience gained in the Ad Serving Business, My Space User Metrics and technical experience gained in MicroStrategy.

Data Requests

• Develop various SQL queries to fetch the data from the Enterprise Data warehouse.
• Analyse the data to understand the business, further developing various metrics that are useful for the monetization. The data was sourced out of various Fox properties, like My Space, IGN, Fox Sports.
• Document the SQL code written, with the findings and facts about the related data and come up with suggestions on better targeting and analysis.
• Functional experience gained in the Interactive Media, advertising and technical experience in SQL on Postgres database.

Data Architect / Team Lead, Confidential, Los Angeles, CA May 2001 – July 2007 Siebel CRM

• Designed and delivered a solution for the Enterprise customers using the Siebel Analytics tool set.
• Used the Siebel administrative tool for the design of the metadata in the Multi User Development Environment.
• Documented the standards and recommendations for the further customizations.
• Created Answers per the requirements given by the Product Strategy.
• Functional experience and knowledge gained in the OLTP areas of CRM and Siebel Analytics tool, now called as OBIEE

Fusion – MDW and EDW

• Worked on providing a migration path for the existing customers on to Oracle Business Intelligence.
• Focusing on attaining unified architecture to fit both Oracle and Enterprise worlds.
• Performed and documented a high level analysis to assess the gaps between the EDW [Oracle - BI] and the MDW [PeopleSoft - EPM] at the granularity of the business processes.
• Functional experience and knowledge gained in the OLTP areas of Supply chain and Procurement from the Oracle and PeopleSoft solutions.

EPM 9.0 - PeopleSoft Campus Solutions

• Designing a data mart to provide the warehouse and analytics around recruiting information seeking to provide information about prospects and recruits for an institution, the institution\'s success in converting them to applicants and enrollees.
• Analyzed and documented the Functional Design from the Business Requirements provided by the Product Development.
• Performing a deep dive to check and see the extent of re usability of the existing features and the attributes, built as a part of the previous release.
• Functional experience and knowledge utilized are in Campus Solutions module on the Enterprise transaction system, SQL Server 2000, Oracle 9i, Oracle Warehouse Builder, Discoverer, Microsoft Visio and ERwin.

JDE/PSFT Integration

• Designed and developed the Warehouse that handles both PSFT and JDE sources for General Ledger, Supply Chain Management and the Sales Order Management.
• Reviewed the current MicroStrategy Architecture Setup and recommended the best practices for migration
• Drafted the Project plan for the implementation and Contingency plan.
• Migrated the environment to integrate both JDE and PSFT related metadata. This included activating and clustering I-servers, tuning Memory Parameters on the Web, I-server and Narrowcast Server after migration, resolving Timeout issues due to the Firewall timeout settings.
• Designed Analytical reports supplementing the Warehouse using Discoverer, Business Objects and MicroStrategy.
• Documented change data capture design for a smooth upgrade form the JDE source to a combined source.
• Functional experience and knowledge gained in OLTP, SQL Server 2000, Oracle 9i, UDB DB2 EEE 7.2, AS/400, Informatica 6.1, DataStage, Oracle Warehouse Builder, Discoverer, MicroStrategy 7.x and Business Objects.

BI – ERP9

• Lead discussions and decision-analysis groups in determining needs for subject areas. Designed and implemented the source changes in the ETL logic including data quality functionality. Data Mining and 3NF modeling performed. Developed an analytical solution using MicroStrategy.
• Objective was to architect and design the Warehouse from strategic enterprise data warehouse and enterprise operational data store [ERP 9] for use in a corporate wide business intelligence strategy using OLAP and ROLAP. Responsible for leading developers, defining technical specifications, designing and architecting the ETL processes.
• Developed the ETL process using Informatica 6.1. This included the design and development of various Mappings, using the relational and flat file sources.
• Applied the functionality facilitated by Informatica to implement the folder structure and the security to various folders depending on the users.
• Created Mapplets in Informatica for various conversion processes like Currency, UOM, to be shared across the folders.
• Defined and created facts, metrics, attributes, filters, prompts and consolidation objects in MicroStrategy
• Defined and created reports in MicroStrategy 7i including troubleshooting and validation of the reports
• Attended various Customer Calls, by troubleshooting the after customized implementation problems.
• Functional experience and knowledge gained in J.D.Edwards OLTP, MicroStrategy 7i.

Unicode Compliance

• Designed and developed the Database that will be able to handle database format in both Unicode and non-Unicode (Western European) as sources it is pulling from, but all the data once loaded into the warehouse will be in Unicode.
• Designed Meta Data repository and implemented including data quality functionality. Documented change data capture design against Unicode and non-Unicode
• Project lead activities performed include managing the project plan using Microsoft Project Server 2000.
• Functional experience and knowledge gained in UDB DB2 EEE 7.2, SQL Server 2000, Oracle 9i, AS/400, and Informatica 6.1.

Business Intelligence

• Acted as business intelligence strategist helping define uses for realty based application data for business intelligence. Lead discussions with various members of company to gather information about application. Completed necessary research to formulate a comparative analysis on competitors and clients existing products.
• Developed the ETL process using Informatica 5.x
• Functional experience and knowledge gained in Informatica 5.x, requirements gathering and documenting in Caliber RM.

Data Warehouse Architect

• Performed activities including defining technical requirements, architecting ETL processes, ETL development, data modeling (dimensional and 3NF) and performance tuning of Informatica, DB2 UDB, SQL Server and Oracle.
• Assisted in defining long-term project objective and goals with project manager. Estimated new projects and new phases to existing projects. Member of core architecture group in decision making spanning multiple development groups working on enterprise data warehouse.
• Worked directly with the business client to analyze their needs and priorities for this very large-scale and highly visible project. Managed integrated test system ultimately providing successful client acceptance testing and being a key component in making this project successful.
• Functional experience and knowledge gained in Hospital Management , Real Estate product and HR management subject areas of E1 [J.D. Edwards] transaction system.

ETL Developer

• Manually hand coded scripts to perform the Extract, Transform and the Load process on various platforms including MS SQL [7/2000], Oracle 8i/9i, DB2/400.
• Performed activities including execution of test plans, design of exception handling strategy and performance tuning. Completed documentation in relation to Data Flow Diagrams [DFD], mapping documents and high-level data models.
• Managed detailed work plans and mentored peers and junior staff in both design and development of ETL Architecture. Key member in defining standards for Informatica implementation. Lead discussions and decision-making groups in determining needs for subject areas.
• Functional experience and knowledge gained in General Ledger, Sales Order Processing, Supply Chain Management, Advanced Cost Accounting, Health Care Management subject areas of E1 [J.D. Edwards] transaction system.

DBA/Internet Developer, Confidential, Columbia, SC August 1999 – May 2001 Intranet Application

• Developed a student details intranet to bring existing student details to the intranet, provide the ability to search within the documents, and display dynamic reports reporting off a database.
• Developed project scope and defined products used by working directly with client. Acted as technical liaison and presented demonstrations to user review groups.
• Functional experience and knowledge gained in SQL Server 7.0, Site Server 3.0, and IIS 4.0.

Oracle Developer/ETL Developer, Confidential August 1998 – June 1999 Customer Information System

• Developed and implemented an application with the ability to track distribution of sample products and then generate reports on the data obtained from the sample distribution. System allows for the ability to add/delete/update members, print and distribute surveys in real-time.
• Developed ETL to port existing data from Oracle data stores to Oracle database.
• Functional experience and knowledge gained in Oracle 8, Oracle Developer 2000.

EDUCATION:

Master of Science (Computer Engineering), Confidential University 
MBA (Information Systems), Confidential University 
PMP (Project Management Professional), Confidential Institute