SUMMARY:

• Over 8 years of total IT experience in software analysis, design and development for various software applications in client - server environment with expertise in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems.
• Expertise in SAS / Base, SAS / Graphs, SAS / Macros, SAS / ODS, SAS / SQL.
• Familiar with SAS Access, SAS/STAT, SAS/Connect, SAS/ETL
• Extensive experience in preparation of reports, tables, listings and graphs
• Excellent command in producing reports employing various SAS Procedures and handling Large Databases to perform complex data manipulation using files in SAS data steps.
• Excellent experience in ETL processing using Informatica Power Center 8.x/ 7.x, Power Connect, Power Exchange
• Expertise in using Informatica client tools Designer, Repository Manager,, Workflow Manager and Workflow Monitor
• In-depth understanding of Data warehousing concepts such as Bill Inman, Kimball methodology's
• Extensive experience in Data warehouses with strong understanding of Logical, Physical, and Dimensional Data Modeling to Design Star and Snow flake Schema's.
• Used SCD type1,type2 and type3 to Load present and Historical Data to ODS,EDW
• Proficient in using Workflow Manager Tools like Task Developer, Workflow Designer and Worklet Designer.
• Experienced in developing applications in Oracle and writing Stored Procedures, Triggers.
• Expertise In data analysis
• Involved in all the stages of the software development cycle, namely design, specification, coding, debugging, testing test plan and test execution, integration and system testing, documentation and maintenance of the programs.

OVER VIEW OF THE SOFTWARES:

• ETL Tools
• Informatica Power Center 8.x, 7.x
• SAS
• SAS Base, SAS/Macro, SAS /Connect, SAS-SQl, SAS/ STAT, SAS/Graph, SAS/Acess, SAS Enterprise Guide, Enterprise Miner, SAS, Information Map, Web Report Studio.
• Databases
• Oracle 11g/10g, SQL Server 2000/2005, DB2, My SQL,
• Oracle EBS
• Database Tools
• Oracle SQL Plus, SQL Navigator, Toad 7.4
• Languages
• C, C, SQL, PL/ SQL, UNIX Shell Script Bash, ksh, JSP,
• ASP, HTML.
• Case Tools
• Erwin, Rational Rose Clear Case, Quest, Microsoft Visio, UML
• Office Suite
• MS Word, MS Power Point, MS Excel, MS Access
• Operating Systems
• Windows XP/2000/NT/95/98, UNIX Solaris 7/8/9, HP-UX, AIX

PROFESSIONAL EXPERIENCE

Confidential

SAS Developer

Responsibilities:

• Worked closely with Database Engineers to design, build, and modify data processes
• Worked closely with Engineering to implement any software required for accessing and handling data appropriately
• Created SAS data mining and scoring data sets form source tables by programming in BASE SAS. Report Generation and Documentation with respect to evaluation of model performance and effectively communicating the results to higher management
• Responsibilities include writing SAS MACRO CODE, SCL to read and create METADATA files on Unix.
• OLAP Cubes and ETL skills to provide for all types of programs.
• Pulled DB2 fields for marketing campaigns and used SAS for reporting campaigns.
• Created complex and reusable Macros and extensively used existing macros and developed SAS
• Developed an Automated Quality Control System for Data Validation and data integrity.
• Documentation, Preparing statistical reports using SAS.
• Wrote Design documents, Program specs and SAS code.
• Involved in various Testing phases Unit, System and Integration

Environment: SAS V9.2, SAS/Base, SAS/Graph, SAS/Macros, SAS-AF, SAS-ODS,, Enterprise Guide, Enterprise Miner, OLAP Cube Studio, SAS Information Map.

Confidential

SAS / Informatica Developer

Responsibilities:

• Worked on SAS 9.1/9.2 SAS Unix: SAS/Base, SAS/SQL, SAS/Macro, SAS/Access to Extract, process/calculate and Load data from Central Teradata DWH Teradata V2R onto SAS platform.
• Created Macros, in order to generate reports daily, monthly basis.
• Created SAS Views from tables in DB2 using SAS/Access.
• Moving files from Test to Production.
• Designed Test system with SAS, SAS Macros, Meta Data, Oracle SQL, Oracle, AIX/Unix and Unix Shell Scripts.
• Used Microsoft SQL Server 2000 for SQL.
• Produced SAS Graphs for Engineers.
• Documented the Processes of the System.
• Downloaded SAS files to Microsoft Excel.
• Worked on Enterprise Guide 4.1/4.2 for development, data stats and QC.
• Worked with source teams to resolve data quality issues raised by end users.
• Worked with SQL Loader to load the data into the warehouse and flat files respectively.
• Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Used different Data Warehouse techniques like Star-Schema, Snowflake Schema.
• Prepared project documentation.

Environment : Base SAS 9.1/9.2 SAS/Unix, AIX 5.3, SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/Graph, SAS/MACRO Oracle 9i, ERWIN, Informatica Power Center 8.1.3 Designer, Repository Manager, Workflow Manager and Workflow Monitor, Oracle EBS, SQL Server, PL/SQL, DB2, Solaris 9.

Confidential

Informatica Developer

Responsibilities:

• Coordinated with the Analysts and team lead to work on the business requirements.
• Worked on compiling the Business Requirements document, Mapping Documents, Unit test cases.
• Created many ETLs as part of development and worked on various transformations like Source Qualifier, Expression, Aggregator, Lookups, Router, Filter, Update Strategy and many others.
• Used Task developer in the Workflow manager to define sessions
• Written design documentation for the ETL maps.
• Unit tested the maps by running SQL queries on source and target.
• Developed korn shell scripts for various Informatica pre and post session operations.
• Used heterogeneous files, flat files, Spreadsheets, Oracle stored procedures as sources
• Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
• Developed Interfaces using UNIX Shell Script to automate the bulk load update Processes.
• Used different Data Warehouse techniques like Star-Schema.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Created and Scheduled Sessions based on demand, run on time, run only once using Informatica work flow Manager.

Environment: Oracle 9i, ERWIN4.0, PowerCenter 7.1.1, PL/SQL, SQL Loader, DB2, Cognos, Oracle DBA Studio, AIX/HPUX 10.20 and 11.0, Windows NT 4.0

Confidential

SAS Developer

Responsibilities

• Developed SAS programs using Proc Tabulate, SAS Base and SAS/Stat that enabled users to generate reports on Daily/Weekly/Monthly/Quarterly/Annual reports.
• Generated adhoc reports for company's audit and inspection requirements.
• Data was extracted from databases and also flat files.
• Preprocessed training data and performed advanced modeling on testing dataset.
• Evaluated the model performance using decision trees and confusion matrices. Performed model enhancement techniques viz. adboost, stacking and bagging
• Created SAS data mining and scoring data sets form source tables by programming in BASE SAS.
• Report Generation and Documentation with respect to evaluation of model performance and effectively communicating the results to higher management
• Developed and maintained multivariate statistical models used to predict customer behavior and to profile customer potential.
• Synthesized coefficients using PROCS MI and MIANALYZE and performed survival data analysis using PROC PHREG
• Calculating possible risk and premiums for individual organizations.
• Customized existing SAS programs and created new programs using SAS/Macros to improve the consistency of the results.
• Compile statistics and create detailed reports and graphs for management and customer review using SAS/Graph, SAS/Macro and SAS/Report.
• Correlating and presenting weekly or monthly data to senior management.
• Environment: SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, Oracle, PL/SQL, MS-Excel and HTML