Post Job Free
Sign in

Sr SAS Developer & Analyst

Location:
Ashburn, VA, 20147
Posted:
December 15, 2010

Contact this candidate

Resume:

Ratan Mohanty,PMP

240-***-**** (cell)

703-***-****(home)

sai959@r.postjobfree.com

Professional Highlights

• A total of 15 yrs of experience in Application Software Development.

• Acted as Datawarehousing Architect/DBA/ETL Tech Lead/Project Manager

• Expertise in ORACLE Database Administration and PL/SQL development.

• Experienced in all phases of the Project Life Cycle.

• Extensive experience in enterprise Datawarehouse Design using different datawarehouse design methodologies

• Extensive experience Scope Management,providing the estimation,Prepared estimation templates for DW/BI. Data Quality Management, Data Profiling, Data Assessment, Data Cleansing, Data Repository.

EDUCATION

• Master of Computer Applications (M.C.A) from Govt Engineering College, Raipur (M.P)

• Master of Science (Physics) from Ravenshaw College

TECHNICAL SKILLS

Datawarehousing Informatica PowerCenter 5.1/6.0 /8.1, Ab initio Co>os 2.12 ,2.13,2.11, GDE 1.12,1.13, SAS 6.0, Business Objects XI/R2

Scheduling Tools Autosys, CTRL M

Code Management CVS, PVCS, Visual Source Safe, CM Synergy, Clear Case

WEB tools Perl, COLD FUSION 4.0

RDBMS Oracle 9i, Oracle 10g, Oracle 8i( 8.1.6 / 8.1.7), Oracle 8.0.5/ 8.0.4, ORACLE 7.3 / 7.2, Sybase 12.5, Teradata 2.0, SQL Server 2000/2005,Netezza

Oracle Applications/ERP Oracle Application 10.7,11.0.3,11I, SAP CRM 5.0, SAP BW 7.0

Designer Tools Designer/2000, Erwin, VISIO, UML

Development Tools Developer / 2000 (Forms 4.5, Reports 2.5,Graphics 2.5), Forms 3.0

DBA Tools Server manager, DBArtisan, TOAD, SQLDBA, Oracle Enterprise Manager

Languages C, C++, COBOL, SQL, PL/SQL, Pro *C, HTML, JAVA, Unix Shell Programming, Java 1.2, C++, XML, T-SQL

Other Tools Kintana, Truecomp, Documentum, MS Project, TOAD, Clear Case, Visio, Remedy, WinRunner, LoadRunner, Test Director, QTP

WORK EXPERIENCE

FannieMae October 10 – Present

Datawarehousing Architect

This project is called Total Return Infrastructure(TRI).It was developed to meet the corporation’s need for timely portfolio evaluation and risk measurement

Responsibilities:

• Designed and developed an interface between Capital Markets Data Store and Capital Markets BI

• Designed,implemented,automated,and managed configuration management processes and associated documentation.

• Provided guidance on quality issue resolutions and production issues

Environment: Ab initio Co>os 2.12 and 2.11, GDE 1.12, IBM AIX 5.0, Sybase 12.5,Oracle 9i/10g, Windows NT/2000, Sun Solaris, Toad, Netezza,Unix Shell Scripts, Autosys, MS Project, Visio,Microstrategy, Test Director, QTP, OEM

Department Of Labor(DOL) April 10 – September 10

Data Architect

This project is called OIS.OSHA(Occupational Safety and Health Administration) Information System consists of suite of applications for OSHA’s business processes including enforcement,compliance,consultation.

Responsibilities:

• Created logical data models and translate into physical database structures that integrate with existing or proposed database structures for OLTP

• Cleaned and maintained the database by removing and deleting old data.

• Worked independently to examine processes, data, and the environment to suggest solutions.

• Worked with IT Analysts to reflect complete set of data entities.

• Created and maintained database schemas for different environments

• Involved in the Data Migration from Legacy to OIS

• Created and maintained Data Dictionary

• Addressed data problems using conceptual, logical, and physical data models.

• Offered supervision on data management, migration

• Created Dimensional Model for Reporting

• Created OLAP Cubes

Environment:Oracle 10g, Windows NT/2000, Sun Solaris, Toad, Unix Shell Scripts, MS Project, Visio, Erwin, Test Director, QTP, OEM, SQL Developer, PL/SQL Developer, SQL, JAVA JDK 1.5.0

Housing & Urban Development(HUD)

Datawarehousing Architect April 09 – March 10

This project is called EIV. EIV provides a portal to tenant income information in the form of household income data, as well as several income-based reports. EIV is a Web-based system, allowing secure access to information via the Internet using standard browsers. EIV project was migrated from SQL Server to Oracle.

Responsibilities:

• Created and modified batch jobs for Debt Termination,SSA Verification ,NDNH.

• Planned , developed and implemented SQL Server to Oracle migration.

• Developed Oracle stored procedures for various modules.

• Designed , developed, and implemented Data migration to different environments.

• Analyzed source and target systems and designed and developed the to ETL process.

• Tuned the performance of the system using various tuning techniques.

• Setup database environment for migration from SQL Server to Oracle.

• Created Dimensional Model for Reporting Application

• Analyzed data element mapping between source and target systems and translated it to ETL mappings.

Environment:Informatica Power Center 8.1, IBM AIX 5.0, Sybase 12.5, Oracle 9i/10g, Windows NT/2000, Sun Solaris, Toad, Unix Shell Scripts, Autosys, MS Project, Visio, Erwin, Test Director, QTP, OEM, SQL Developer, PL/SQL Developer, SQL Server 2000/2005, JAVA JDK 1.5.0

Fanniemae Aug ’04- Feb 09

Datawarehousing Architect

This project is called HCD Core.The architecture is designed to collect data from approximately thirty different sources varying from MS Access, Sybase, Oracle, Excel Spreadsheet.This project is designed for Multi Family business side of FannieMae.Debt, Equity,Bond are the three main areas for which data is collected and is used by Management for various financial analysis.

Responsibilities:

• Collected the business requirement for integrating different new sources for Equity,Bond and designed the process flow depending on business logic.

• Did the deployment of Abinitio and non abinitio components from the lower environments to Production and prepared the task list for the Production Deployment by coordinating with different teams involved in the release.

• Overseeing the Entire engagement which includes Business Development & Requirement Gathering.

• Established processes for governing the identification,collection,and use of corporate metadata; take steps to assure metadata accuracy and validity.

• Designed and developed ETL process for IDB project by integrating new sources and enhancing the existing transformation as per the requirement .

• Oversaw the mapping of data sources, data movement,interfaces,and analytics,with the goal of ensuring data quality.

• Created logical data models and translate into physical database structures that integrate with existing or proposed database structures.

• Addressed a variety of database integration issues including migration between disparate databases, integration,maintenance.

• Maintained development, test and production RDBMS environments.

• Leading the development of Data Warehouse Project and tracking of Project Plans.

• Monitored and maintained database security.

• Monitored and managed database backups, logs.

• Installed, maintained, and upgraded database software.

• Reviewed overall physical database structures for data integrity,performance quality, recoverability,maintenance, and space requirement considerations.

• Wrote Unix Scripts for Job Scheduling/Monitoring,Data Massaging and Developed Oracle Stored Procedures & packages using PL/SQL depending on the business requirement.

• Developed and implemented key components as needed to create testing criteriain order to guarantee the the accuracy and performance of data architecture.

• Developed Abinitio graphs as per the business specifications.

• Establishment and maintaining the Project/Program communications.

• Provided guidance on quality issue resolutions.

• Managed the configuration,compilation of the IDB project.

• Used IBM Rational ClearCase,CVS tools to perform regular version and configuration management duties such as checking out, labeling,branching large codebases.

• Designed,implemented,automated,and managed configuration management processes and associated documentation.

• Worked on the migration of one acquisition/servicing system to another acquisition/servicing system.

• Tracked and managed release management process through bug tracking system.

• Determined the criteria and methods needed to ensure that both operation and control of processes are effective.

• Provided technical leadership and guidance to developers and QA working on development project teams.

• Managed the SOX- related issues to make sure the application is SOX compliant.

• Coordinated and managed the infrastructure changes by recommending alternatives and planning the implementation steps to minimize the application impact.

• Coordinated the deployment of new changes into production by ensuring the deliverables are delivered in time.

• Designed data models from business requirements .

• Created Business Objects Repository while building Business Objects solution.

• Published and scheduled Business Objects Reports to users using Scheduler.

• Designed/developed/audited the Universe/Reports and documenting the entire life cycle.

• Worked with different teams to understand the process and suggested improvements to operating policies and procedure.

• Created reports using Desktop Intelligence and Web Intelligence in BO XI r2 environment.

• Created Dimensional Model for Reporting

• Managed different environments like Development,Test,Acceptance for parallel development and multiple releases.

• Did the design for Enhancement projects and new source integration projects and acted as a lead by doing the code reviews and monitoring and mentoring the Developers and creating the Design documents.

Environment: Ab initio Co>os 2.12 and 2.11, GDE 1.12, IBM AIX 5.0, Sybase 12.5, Oracle 9i/10g, Windows NT/2000, Sun Solaris, Toad, Unix Shell Scripts, Autosys, MS Project, Visio, Business Objects XI-R1/R2,6.5,5x, Web Intelligence 6.5/XI,Erwin, Test Director, QTP, OEM

Sprint April ’04- July 04

Technical Lead

The proposed solution is to implement the new PM reporting system architecture ( Option 4-Sprint ISSD implements new system, but transfers maintenance of business rules and Crystal Reporting to SPAR). All business rules currently in the various source systems will be consolidated into a tool that will facilitate easy manipulation and management of the business rules by the SPAR organization.

Responsibilities:

• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs.

• Analyzed the current process and recommended steps leading to Performance enhancement and streamlining of the processes and created the Design documents,Production readiness douments.

• Evaluated number of Ab Initio Graphs and suggested performance tuning tips based on business requirements.

Environment: Ab initio Co>os 2.12 and 2.11, GDE 1.12, IBM AIX 5.0, UDB DB2, Oracle 9i, Windows NT/2000, OS/390, IBM ES-3090, Sun Solaris, Toad, Unix Shell Scripts

AllState Jan 04 – March 04

Datawarehousing Architect

Responsibilities:

• Went through various data integration scripts and did performance tuning to achieve the best results In stress testing environment.

• Worked on the migration of the existing commissions system to Truecomp.

• Formalised a general plan of action for performance tuning of Data Integration module.

• Worked on changing the code for error handling and status check , execution time tracking for each script in a batch environment.

• Created the architecture for purging process

• Designed a process for performance monitoring

• Involved in running and monitoring the pipeline run process in TrueComp

Environment:Oracle 9 i, Unix, Windows 2000/NT, TrueComp, Sun Solaris, Toad, Unix Shell Scripts, Visual Source Safe, Ab initio Co>os 2.12 and 2.11, GDE 1.12, MS Project

Sprint Jun 03 – Dec 03

Datawarehousing Architect

This venture was undertaken to convert the nineteen call server complexes for Midwest region from CIRAS to their equivalent OMS , OBJECTEL model. This is a part of very large C2P ( Circuit to Packet ) based initiative for the Local division of Sprint.

Responsibilities:

• Did the deployment of Abinitio and non abinitio components from the lower environments to Production and prepared the task list for the Production Deployment by coordinating with different teams involved in the release.

• Developed and implemented key components as needed to create testing criteriain order to guarantee the the accuracy and performance of data architecture.

• Wrote Unix Scripts for Job Scheduling/Monitoring,Data Massaging and developed Oracle Stored Procedures & packages using PL/SQL depending on the business requirement.

• Developed Abinitio graphs as per the business specifications.

• Acted as a lead by doing the code reviews and monitoring and mentoring the Developers and was a part of production support for ZNP,ZNL,ZLP applications.

• Developed batch jobs for Topology, Order Data Mart, Order Upper Mart.

• Created scripts to create mock data in system test, development test environments.

Environment: Environment: Ab initio Co>os 2.12 and 2.11, GDE 1.12, IBM AIX 5.0, UDB DB2, Oracle 8.1.6, Windows NT/2000,OS/390, IBM ES-3090, Teradata 2.0, Sun Solaris, Toad, Unix Shell Scripts, MS Project, Visio, WinRunner, LoadRunner, Test Director

Sprint PCS Jun 02 – May 03 Aug 02 - Present

Datawarehousing Architect

This project was initiated to implement Truecomp for Sprint PCS for their existing Commissions System.

Responsibilities:

• Generated various scripts to migrate the data from CPS system to TrueComp system.

• Involved in loading different feeds to TrueComp system through Informatica routines.

• Involved in defining ETL process for Commissions system.

• Developed mapping using Informatica .

• Did performance tuning in Informatica.

• Worked on the migration of the existing commissions system to Truecomp.

• Extensive scripting (Unix shell / PLSQL / SQL) for Preprocesor module.

• Involved in running and monitoring the pipeline process in TrueComp.

• Migrated the current commisions system to Truecomp system.

• Defined the compensation rules in Truecomp .

• Analyzed the Business and System Requirements of the application.

• Involved in the schema design for Commissions system.

• Designed and developed a inflation tool for Sprint Billing System.

• Responsible for the planning and administration of Oracle databases.

including: Database definition, documentation, protection and resolvingOracle errors and failures.

• Responsible for Oracle DBA performance monitoring, tuning and administration, physical database design, providing production support,developing plans to test system, and hot/cold backups.

Environment: Oracle 8I, Java, JavaScript, Unix, Windows 2000/NT, TrueComp, Informatica PowerCenter 5.1.2/6.0, Sun Solaris, Benthic, Unix Shell Scripts, PVCS

Cisco Systems Aug 00 to April 02

Project Name: Config Express

Role: Sr ETL Developer

Responsibilities:

• Created, tuned and tested stored procedures, functions and packages for implementing major functions of the system.

• Developed Extract, Transform, Load (ETL) processes of data warehouse.

• Wrote PL/SQL stored package for data cleansing and reporting the errors.

• Creation and organization of database schema & storage structures.

• Worked on Informatica tool- Source Analyzer,Warehouse Designer,Mapping.

Designer,Transformations, Informatica Repository Manager and Informatica Server Manager.

• Worked as a build manager,managing source code by making tags,branches for various development teams in different environments using CVS.

• Used various components of Informatica, Repository Manager for creation of repositories, user management and lock resolution, Server Manager for scheduling sessions , batches.

Environment: Oracle 8.0.5, Oracle 8.1.7, OEM, ETL, TOAD, Designer 2000, Exp/Imp, Server Manager, SQL *Loader, TKPROF, Solaris 2.6, WIN NT, SQL NAVIGATOR, Informatica PowerCenter 5.1

Accenture June99 – July 00

Project Name: Profit Map

Role: DBA

Responsibilities:

• Performance tuning of the system and designed a plan to prepare the environments for stress testing.

• Analyzed the sources and targets and the existing mapping

• Wrote Unix Scripts for Job Scheduling/Monitoring, Data Massaging and Developed Oracle Stored Procedures & packages depending on the business requirement

• Creating Data structure like table spaces, adding data files, creating table segments, index segments and their maintenance

• Responsible for Security on Production database like create roles, application wise and access to application Schemas to Users and maintain separate tablespaces for Data, indexes .

Environment: Oracle 8.1.6, Windows NT/2000,OS/390, IBM ES-3090, Teradata 2.0, Sun Solaris, Toad, Unix Shell Scripts, Recovery Manager, DBverify, Exp/Imp, Server Manager, SQL*Loader, TKPROF, Shell Scripts and Cron Scripts, Cognos, SQL Server 2000

Perot Systems Jan 98 to May 99

Project Name: Odyssey

Role: DBA

Responsibilities:

• Created Users and their Roles, grant the appropriate Roles.

• Creation of the Database, Creation of user accounts and Privilege Management,Tablespace management,Role Management.

• Monitored and Tuned the Database and Application Performance.

• Setup jobs using Autosys by analyzing the dependencies of jobs and wrote the wrapper for autosys jobs.

• Extensive scripting (Unix shell / PLSQL / SQL) for automating database maintenance.

• Creating, tuning and testing stored procedures function and packages.

Environment:Oracle 8.0, WIN NT, HP UNIX, SQLDBA, SVRMGRL, UNIX shell Scripts

Perot Systems Sept 97 to Dec 97

Project Name: Odyssey Developer

Brief Project Profile

Odyssey is a car Rental System being developed for National Car Rental one of the leading car renting companies in U.S having offices/branches all over the country.

Responsibilities:

• Analysis of User Requirements and Preparation of the detailed Design Document.

• Written several stored procedures to implement Business Logic.

• Application Tuning. Maintenance Support Activities like Functional Enhancement, Bug Fixing, Implementation of Business Requirement Changes

• I was assigned the job of creating the forms for Transit time by dropship/model, create and maintain TPW (Target ProductionWeek), Vehicle Specification, Vehicle Location Specification.

Environment:Designer 2000, Developer 2000, Oracle 7.3/8.0, Forms 4.5, Reports 2.5, PL/SQL, Pro *C, HP UNIX/Windows NT, Exceed, True Change, Pentium Workstations, HP 9000 Server, Sequent Server

Birla Consultancy & Software Services Aug 96 to Aug 97

Project Name: Management Information System

Programmer Analyst

Responsibilities:

• Analysis, design and preparation of User Requirement Specifications (URS), Functional Specification Document FSD), Program Specifications

• Written several stored procedures and database triggers at the backend to implement Business

• Designed data input screens using Developer 2000 features like List of values, Record Groups, Property classes, Visual Attributes and Program units.

Environment:Oracle 7.1, Developer 2000, PL/SQL, Windows NT/HP UNIX, IBM Pentium

Softdeal Computers Aug 95 to July 96

Project Name: Integrated Materials Management System Programmer Analyst

Responsibilities:

• Did development, testing and implementation of the system.

• Actively participated in developing indent, Purchase Receipts, Inventory, Control modules.

• All the features of Oracle like database All the features of Oracle like database triggers, procedures were used.

Environment: Oracle 7.1, Developer 2000, PL/SQL, HP UNIX/Windows NT, IBM Pentium

Siemens Information Systems Ltd. Feb 95 to Aug 95

Project Name: Bug Maintenance System

Programmer

Responsibilities:

• Did design, development, testing and implementation.

Environment: Oracle 7.0, Forms 3.0, PL/SQL, SOLARIS, SUN

Work Authorization

Permanent U.S. resident (Green Card Holder)

PROFESSIONAL TRAINING/Certification

PMP Certified Dec 2007

Course Conducted By

ORACLE7 DBA SQL Star

ORACLE 11i Apps DBA Patternsoft Inc, USA

Developer / 2000 Advanced Micro Technology

Designer / 2000 Advanced Micro Technology

JAVA Birla Consultancy & Software Services

Software Quality Assurance Birla Consultancy & Software Services

Business Objects FannieMae

SAS FannieMae

Project Management FannieMae

SAP CRM Wizards Training Inc

SAP BW Wizards Training Inc



Contact this candidate