Data Sql

Anjali

SUMMARY:

* ***** ** ***** ** experience in SAS Reporting & Data warehousing & designing and

•

developing ETL processes using Informatica Power Mart / Power Center, System Analysis,

Application Design, Dimensional Data Modeling, Implementation and Testing of Data

Warehousing and Database systems for Pharmaceutical, Publications and lawyers domain

projects with Oracle, SQL Server, XML and FLAT files.

Worked on SAS Enterprise Edition 4.1, developed various case studies, datasets, validation of

•

datasets, generated reports, performed testing.

Base SAS@9 certified.

•

Strong ETL data integration & Data Warehousing experience using Informatica Power Center

•

(8.x, 7.x,6.2/5.1) (Repository Manager, Mapplet Designer, Mapping Designer & Workflow

manager).

Highly experienced in Extraction, Transformation, and Loading data to data warehouse using ETL

•

tool Informatica.

Specialized in data warehousing and database business application systems analysis, design,

•

development, and implementation.

Sound knowledge in Dimensional Database modeling, Star Schema modeling, Snowflake

•

modeling, FACT tables, Dimension tables, OLAP, Query Intensive database designs,

Performance tuning.

W orked with SQL*Loader, Star Schema, Snow Flake Schema, PL/SQL, Toad, UNIX, Pmcmd.

•

Extensive experience in Oracle 10g,9i,8i,8.0, PL/SQL, UNIX & NT operating system.

Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and

•

Triggers. Proficient in Toad.

Experienced in MS VISIO, File Maker Pro 7 and Crystal Reports.

•

Oracle Certified Associate (OCA).

•

Strong in Writing the SQL Queries and Optimizing SQL Queries.

•

Sound knowledge in UNIX shell scripting and automation of ETL process.

•

Experience in INFORMATICA mapping specification documentation preparation.

•

Experience in Writing Post-Session and Pre-Sessions shell scripts.

•

Experience in Scheduling the INFORMATICA batch sessions through CRON jobs.

•

W orked as Support Analyst and Defect Prevention Analyst for teams.

•

TECHNICAL SKILLS:

PC SAS – 8, SAS Enterprise Edition 4.1,Informatica Power Center

ETL Tools

8.x, 7.x,6.2/5.1, Informatica Power Mart 6.2.2

Oracle 10g,9i,8, SDD(SAS Drug Development),SQL SERVER 2000

Database

Reporting Tools FileMaker Pro 7, Crystal Reports

Operating Systems UNIX(KORN), AIX, Windows NT/2000/XP

W eb Technologies HTML, Java Script

SQL, PL/SQL, SAS, Visual Basic 6.0, C, Unix Shell Scripting

Languages

Tools Microsoft Visio 2000, Visual Source Safe, SQL Navigator, TOAD,

PMSMART

Certifications OCP first certification “Introduction to SQL” Scored 86.5%,

OCP second level certification “Program with PL/SQL” Scored 95.5%,

Base SAS certification Scored 100%.

Eli Lilly – Indianapolis, IN Jun 05 – Till Date

Position: FMR Statistical Analysis - SAS Programmer

Eli Lilly is one of the Leading Pharmaceutical Companies in the world. The Company is linked to various

offices all around the world and also to its Clinics and other Business Partners.

This team consolidates the data specific to Clinical Trials studies being held by the Eli Lilly at various

locations for various drugs and generates reports and figures that are more comprehensible and makes

sense to the client. I worked as SAS Programmer and worked on various Case Studies, requirement

specific reports.

Responsibilities:

Gathered user specific report requirements and prepared specification documents for various

•

case studies.

W orked on various SOPs, studied previous SOPs.

•

W orked on CTMS (Clinical trials management systems).

•

W orked in ADS team for gathering requirements and data sets generation.

•

Involved in BOM objects creation.

•

W orked according to FDA regulations and guidelines.

•

Attended various trainings on musculoskeletal, FDA guidelines and related to Clinical trials

•

modules.

Learn Programming standards.

•

Developed various case studies in SAS programming language and datasets.

•

Developed unix scripts using korn shell.

•

W orked on SDD (SAS Drug Development) tool.

•

Developed SAS reports according to the USER requirement specifications.

•

Performed testing of developed case studies.

•

Delivered all the reports on time.

•

Did BASE SAS certification.

•

Environment: PC SAS – 8, SAS Enterprise Edition 4.1, Internet Explorer, SDD (SAS Drug

Development), Citrix. Visual SourceSafe Explorer (VSS), MS ACCESS, UNIX(korn).

Management Information Control System – Eli Lilly

I worked in a distributed domain data warehousing project of Eli Lilly. This data warehouse is a global

system encompassing the data from multiple manufacturing locations. Data was getting populated into

datamart through 4 different sources. From these sources reports were getting generated.

Responsibilities:

Gathered business requirements from business users and prepared functional specifications for

•

various enhancements, modifications and Data Migrations.

Developed ETL jobs to load data from XML files into Oracle database.

•

Extensively worked on developing and modification of ETL Mappings using various

•

Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Rank, Aggregator,

Stored Procedure, Sorter, and Router transformations in Informatica Designer.

Performed system testing of developed mappings. Prepared and tested system testing scripts.

•

Extensively worked on creating Workflows for various Interfaces and Data Migration mappings.

•

Scheduled and unscheduled workflows to automate the entire process of fetching the source file

•

from a different path and ftp it onto the server.

Involved in creation of target tables in Oracle and Informatica mappings and workflows and

•

executing them.

Developed FTP scripts to move files across different servers.

•

Environment: Informatica Power Center 7, Oracle 9i, TOAD, Citrix. Visual SourceSafe Explorer (VSS).

Fonterra Hamilton, New Zealand Feb ’05 – may’05

Position : Oracle Developer

Fonterra is the biggest co operative firm of dairy products in New Zealand. I joined the project at the

engagement beginning. I worked in the knowledge transfer phase as Support Analyst for supporting the

Finance applications stand alone. Also I represented the finance applications as the understanding of the

company.

Responsibilities:

Gathered information from onsite to support 5 Finance applications.

•

Prepared support Documents for all the Finance applications (Citibank, HSBC, Local Bank etc)

•

for the stand alone support.

• W orked on ClearQuest tool to gather user requests to support person and recorded all possible

solutions for the application.

• Verified support and technical documents before sending to client as company understanding of

the system.

• W orked on application database and worked on enhancements in coding work. Created stored

procedures.

Environment: Oracle 9i, PL/SQL, Windows XP 2000, UNIX.

PEARSON Publications Group - NJ, US Jan’04 – Feb ’05

Position: Informatica Developer

Pearson Technology Group (PTG) is the IT arm of Pearson Education, which takes care of US School,

US Higher Education and Professional Publishing. Business Intelligence Group (BIG), part of PTG, is the

nerve center of critical and sensitive business data from various publishing groups within Pearson

Education (PE).

In this data warehousing project, the higher educational publications data were coming from different

regions and countries on a daily basis. There were 150 around scheduled cron jobs for data loading into

the data warehouse after applying the business logic. Those cron jobs were automated into the

scheduled “Autosys” jobs based on the time and region so that the data in data warehouse is updated

with the recent sales data. Also there were scheduled weekly, monthly and yearly jobs. There jobs were

also automated into the “Autosys” jobs.

Responsibilities:

W orked as Developer in two projects for Pearson.

•

W orked as single billable resource. Worked on complete life cycle of the project and prepared

•

documents for all phases.

W orked on automation of cron jobs into Scheduled Autosys jobs in UNIX.

•

For converting cron jobs into scheduled Autosys jobs, prepared functional specifications, created

•

supporting database objects such as tables, views, stored procedures, triggers, indexes,

functions, packages, UNIX scripts and some utilities.

After converting UNIX scripts of cron jobs into utility based Autosys jobs, categorize the Autosys

•

jobs in terms of regions and time. Prepared Visio documents for the same.

Developed new scheduled jobs as Informatica mappings. Extensively developed and modified

•

ETL Mappings and used various Transformations like Source Qualifier, Expression, Lookup,

Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Router transformations in

Informatica Designer.

Developed UNIX shell scripts for ftp of data files into the system and for other required features.

•

Before putting the jobs into production, performed regress testing of all the jobs.

•

Prepared test cases and delivery documents.

•

Successfully delivered the jobs into production.

•

W orked as a DPA (Defect Prevention Analyst) for the team.

•

Environment: ORACLE 9i, PL/SQL, Informatica 6.2.2, Toad, PMSMART, Microsoft Visio 2000, Windows

XP 2000, UNIX.

LEXIS NEXIS - New Providence, NJ Feb’02–Dec’03

Position : PL/SQL Programmer

Lexis & Nexis is one of the biggest firms of legal business solutions. LexisNexis is a leading global

provider of business information solutions to professionals in law firms, corporations, government, law

enforcement, tax, accounting, academic institutions and risk and compliance assessment. I worked on

three lawyer’s site of this firm.

1. Parker: Parker is a database of Firms and their lawyers and attorneys information, located in

California. This information is used to produce the California Directory of firms and their attorneys.

Responsibilities:

• W orked as single billable resource on this project. Prepared documents for whole life cycle of project.

• W orked on maintenance issues, and new requests of reports. Created stored procedures, UNIX

scripts. Generated reports in crystal reports.

• Extensively worked in Oracle 9i and PL/SQL and UNIX. Created stored procedures, functions,

indexes, tables, views, triggers and Unix scripts.

• Performed the testing of developed modules. Prepared test cases and required documents.

Environment: ORACLE 9i, PL/SQL., Crystal Reports, Windows XP 2000, UNIX.

2. CorpInsight - Corporate Insight database is to help collect legal related information on the fortune 500

firms. This information will be used strategically in the redesign of client site. CorpInsight system

maintains the Corporate Insight database and generates the reports based on requirements to generate

the statistics for the fortune 500 companies.

Responsibilities:

• W orked as single billable resource. Prepared documents for whole life cycle of projects.

• Developed reports on FILEMAKER PRO 7 according to the requirements after applying

required business logic.

• Developed template reports and unique reports and generated those in crystal reports.

• Created database objects such as stored procedures, views, triggers, tables, prepared Unix

scripts required to fetch reports data from database.

• Gave presentation of FILEMAKER PRO 7, for the knowledge building of the team.

Environment: FILEMAKER PRO 7, ORACLE 9i, PL/SQL., Crystal Reports, Windows XP 2000, UNIX.

3. WebStats - W ebStats uses a dataware house which stores information of data related to user visits,

searches made on different websites of the client, to generate reports for users. WebStats uses Crystal

Report reporting tool to generate different reports to be used by the sales, marketing team and managers.

Responsibilities:

• W orked on various applications in WebStats. Worked on various enhancements in

WebStats in development modules.

• Developed one stand alone utility using PL/SQL and UNIX Scripts.

• Developed all the components of that application such as stored procedures, views,

triggers, indexes, functions, packages, SQL Loader, Unix scripts and ran procedures

through Unix scripts.

• Prepared test cases and performed testing of all the components.

• Successfully delivered all the modules of the applications into production.

Environment: ORACLE 9i, PL/SQL, Crystal Reports, Windows XP 2000, UNIX.

Contact this candidate