Sr SAS Developer & Analyst
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