Vinit S Email & Phone Number

Los Angeles

Configure and installation of DHCP server and client. Configure DHCP Relay Agent.Creating Group Policy Objects, User Administration, Distribution List Administration.Migrating from Active Directory 2000 to Active Directory 2003 Server. Updating servers with latest service packs and hot fixes.Troubleshooting Active Directory replication problemsCreating GPO. ( Block Inheritance, Override, Filtering)Settings Software installation through AD GPO.Monitoring Active DirectoryDesign, Configure and installation of DNS Update existing DNS server.Installation and Configuration of Active directory.Designing Active Directory.Managing Active Directory Site: (Add New SITE, Add Subnet to Network, Move DC to SITE, Link Site to Replication).Windows 2003 server maintenance. Installation and configuration of Routing and Remote Access Server.Permissions Delegation to Active Directory object Configure secondary DNS server, Stub Zones, Conditional Forwards.Create GPO and provide necessary security right on GPO object.Installation and administration Remote Desktop. Creating user and access right to Windows XP. Conducts basic network maintenance and troubleshooting in LAN and WAN environments

San Diego

Used Informatica Designer to Extract & Transform the data from various source systems by incorporating various business rules. Also used different transformations, sessions and command tasks.Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update StrategyWorked with mapping variable, Mapping parameters and variable functions like Setvariable, Countvariable, Setminvariable and SetmaxvariableTuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.Using InformaticaRepository Manager maintained all the repositories of various applications, created users, user groups, and security access control.Developed shell scripts for job automation, which will generate the log file for every job.Created Stored Procedures for Audit and Error Balancing.Used Crontab for scheduling.Validated Data to Maintain Referential Integrity.Developed UNIX shell scripts to move source files to archive directory.Involved in Unit, Integration, system, and performance testing levels.Worked on back end programming such as PL/SQL procedures, functions and packages.Prepared a production monitoring and support handbook for ETL Process.Coordinated offshore and onsite team with a total of 7 ETL developers

San Diego

Interacted with end-users and functional analysts to identify and develop business requirements and transform them into technical requirements.Involved in the SDLC process beginning with the design of dimensional modeling in buildingthe data warehouseWorked with Data Architects during Design Stages.Created design specification documents and developed functional and technical specification documents.Extracted data from oracle, flat file and xml sources.Installing, Configuring and Managing Microsoft Windows 2000/2003 Servers and Imaging Windows 2000/XP Professional Clients using Ghost. Configuring DNS & DHCP ServicesInstallation, monitoring, administration and troubleshooting of Active DirectoryCreating and Managing Users with Specific Privileges and Policies, Managing User Profiles, Groups, Access Permissions and Group polices.Creating users and user authentications through logon scriptsSecuring Network with Antivirus (Trend Micro Server Protect/Office Scan) and. checking for latest definition filesUsing Group Policies for both user environment restrictions and software deployment on client machines.Testing, Installing and updating patches (SUS) on servers and client machines. Managing Backups (Win Backup).

Noida Area, India

Analysed source systems, business requirements and identified business rules for building the data warehouse.Developed Technical Specifications of the ETL process flowDesigned and developed Informatica mappings, workflows to load data into Oracle ODS.Installed and Configured Informatica Power Center client tools and connected with each database in Data Ware house using repository server.Extensively used Informatica to load data from Oracle, XMLand Flat Files to Oracle.Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign user privileges.Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.Set up Metadata driven utility design for the ETL processes using Informatica.Used debugger to test the mapping and fixed the bugs.Involved in tuning the performance of sessions and mappings.Used the Workflow manager to create workflows and tasks, and also created worklets.Involved in Production Support in resolving issues and bugs.Worked onSQL stored procedures, functions and packages in Oracle.Scheduled and executed batch and session jobs on Autosys.Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.