SYNOPSIS:

• An IT professional with 18+ years’ experience seeking a mentally stimulating and challenging position which will enable me to utilize my expertise and work experience.
• Adept change agent with well - honed analytical and quantitative abilities, coupled with years of business experience in conceptualizing, developing, and implementing comprehensive solutions and having experience in Onsite and offshore model. An IT Specialist expertise in high dependable systems, with a proven track record of implementing highly successful and dependable data management solutions involving business understanding, requirement gathering,
• Data Analysis, Design data warehouse, Design Logical and Physical Data model, ETL Application Development, Testing and Production support experience as architect end to end Data Warehouse Architect, ETL Architect, data warehouse and business intelligence applications for large enterprises. A Quick Lerner and an ability to rapidly achieve organizational integration assimilate job requirements and employ new concepts, methodologies and technologies. Also having Onsite and Offshore model and experience in interacting with clients and having Valid US H1B Visa.
• Designing Logical Data Model and Physical Data model.
• Handling the design, development, unit testing and deployment of data warehouse systems.
• Defining data requirements and designing databases to satisfy client business objectives.
• Participating in design reviews, and assisting with allocation of functionality to specific system components.
• Developing data models, implementing databases, and tuning Databases for performances.
• Designing ETL Architecture and Designing with auditing, and exception handling.
• Designed ODS as Data Store and as per OLTP Archive policy, where data is reverse shared between ODS and OLTP.
• Designing Analytical reports using SSIS, SSAS.
• Designing Reports, analyzing data and profiling data to present issues and working closely with Business Team on requirements and resolving issues.
• Working closely with the team on Releases and managing and maintaining Release on multiple environments.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, MS Visio.

ETL Tools: Informatica Power Center 8x,7x, 6x, SSIS.

LANGUAGES: C, SQL, TSQL, PL/SQL.

PROTOCOLS: NetBEUI, TCP/IP, PPP, HTTP, FTP.

Databases: Teradata, dB2, Oracle8i/9i/10g/11g, SQL Server 7.0/2k/2005/2008, MySQL and MS Access.

Data Modelling Tool: Erwin 7.x, Microsoft Visio

Methodologies: Star Schema, Snow Flake Schema.

Business Intelligence Tools: MSTR, Cognos, SSAS,SSRS, OBIEE.

OPERATING SYSTEMS: UNIX, Linux, Fedora, Solaris, Windows NT 4.0, Win2k8,Win2K, WinXP, Win95, Win98, MS-DOS.

Version Control Tool: TFS, SVN, MS Visual SourceSafe

PROFESSIONAL EXPERIENCE

Oracle Certified Associate

Confidential

Roles and Responsibilities:

• Responsible for Data Warehouse Architecture, generating Logical and Physical model using Erwin data modeling tool.
• Responsible for designing ETL Architecture and performance monitoring.
• Responsible for signing off the design of Database & ETL before pushing it for development.
• Responsible for designing Database Architecture and responsible for team using from source control in onsite and offshore model.
• Designing a BI Solution for Vendor Management Reporting Solution
• Coordinating with the Production Support team to roll the ETL and Database Changes to production.
• Data get populated from Siebel CRM, for customer Relation Ship data into dimensional data marts.
• Analyzing requirements and profiling data before design requirements and signing of the requirements.
• Mortgage Management BI Solution

Confidential

Data Architect

Responsibilities:

• Designing Data Warehouse Architecture using bottom up approach and created Logical and Physical data model.
• Designed Dimensional model, to support Type 1, Type 2 and Type 3.
• Created the auditing as primary driver for the project and which will be used for analysis the previous load for any issues if required using the audit roll back a particular load.
• Created the ETL Design Document where including the process logic how the data TEMPhas to move forward and getting the approvals for the ETL Documentation phase.
• Driving the ETL Team for understanding ETL Design Document for ETL coding phase.
• Closely involved with ETL team on coding phase for the project schedules and resolving the issues and taking forward.
• Created the test data for Reports for generating the test reports and finding the issues on it and closely involved in resolving the issues.
• Planned ahead of the schedule for the issues and discussing with the Project Manager and Client and coming with solutions.

Confidential

Sr Data Warehousing

Responsibilities:

• Created data marts based on subject areas and implemented confirmed dimensions.
• Designed Data Warehouse Data Model to support Type 2 for dimensions and created logical and physical Data model.
• Designed ERD - Entity Relational Data Models using Erwin Tool and maintained, get delta DDL changes to Development and releases.
• Analyzing the OLTP Database for the Business Logic and flow of the Collection of data into OLTP System.
• Analyzing the Clinical EMR Application and for business requirements in reporting needs.
• Principal Architect in Designing the Clinical Warehouse Schema representing the data for the Business requirements.
• Segmented the data as Medical Groups into Data Marts as each data Mart represents each medical group.
• Identifying the Static and Dynamic Data and segregating the static Data and finding the relation to identified Dimensions and De-normalizing the data.
• As per the business requirement proposing a baseline schema for the reporting requirements by using facts as Dynamic Data and joining identified Dimensions for the required reports.
• Identified the data flow bugs in the OLTP and proposed the solutions and which will also dependent on the proposed warehouse design.
• Proposed a prototype for the Clinical Repository and which reflecting the current reporting requirements, and closely interacting with the US clients for the approvals.
• Identified the Dimensions and Changing Dimensions and proposed the same for the schema, and closely working the team for the ETL process.

Environment: Informatica Power Center 8.1.1, Erwin 4.1, Teradata, Oracle 9i, MSSQL Server 2005, Flat files, PL/SQL, SSIS and SSRS.

Confidential

IS Manager

Responsibilities:

• Analyzing the existing system and study the business requirements for customer analytics system.
• Designed and implemented a Metadata Repository providing a centralized information source for the data models.
• Recommended Information Strategy and Business Area Analysis plans. Provided Current Process Workflow analysis, Business Function/System Matrix, Data Inventory and Data/System Matrix.
• Designed a Data Warehouse to replace seven legacy databases.
• Preparation of Technical Specification.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager. The objective is to extract data stored in different sources such as Flat Files, Relational target system like Oracle, SQL Server and to load finally into a single Data Warehouse Oracle.
• Involved in performance tuning of mappings, transformations and sessions to optimize session performance.
• Involved in Migration of the mappings and workflows from Development to Test and Production Environments.
• Involved in Designing the Data Loading Sequence into Staging Area and Warehouse with Business Rules.
• Worked with pre and post sessions and extracted data from Transaction System into Staging Area.
• Experience in implementing the complex business rules by creating re-usable transformations, developing complex Mapplets and Mappings, PL/SQL Stored Procedures.
• Designed ETL mapping documents to map source data elements to the target Star-Schema based DW database.
• Proficient in using Workflow Manager Tools like Task Developer, Worklet Designer.
• Performed Informatica Administrator functions like Creating Users, Folders, and assigning permissions on the folders to the Users.
• Analyzed performance measures to fit the reporting needs of the company.
• Creation of output files as per specification and FTP transfer of these files to the destination folder.
• Identify/debug, troubleshoot, modify, document, test and fix production issues.
• Experience in Customer relationship Management and addressing all customer issues.
• Fine tuned stored procedures, transformation, mapping, sessions and SQL queries.
• Experience in using the Informatica command line utility pmcmd to schedule and control workflows and worklets.
• Experienced in Testing, Debugging, Validation and Tuning of mappings, workflows.
• Provided solutions for Production Trouble Reports and Source change requests.
• Experience in Customer relationship Management and addressing customer issues.
• Strong Team working spirit, communication and relationship management skills.

Environment: Informatica Power Center 7.1.2, Erwin 3.5, Visio, Oracle 9i,SQL Server 7, Flat files, PL/SQL.

Confidential

DWH Developer.

Responsibilities:

• Development of data models and reverse engineering of production systems.
• Created Repository using Informatica Power Center Repository Manager.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Studied current state and designed future state in Informatica and derived ETL strategy.
• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle.
• Qualitative experience in understanding client requirements for suggesting appropriate technology solutions.
• Worked Extensively with Lookup, Joiner, Sorter, Aggregator, Update Strategy, Stored Procedure, Router transformations.
• Constructed data extraction and transformation procedures to obtain operational data from RDBMS data stores.
• Installation and configuration of Informatica.
• Worked with Lookup, Joiner, Sorter and Aggregator transformations
• Created reusable mapplets, transformations and mappings using Informatica Designer.
• Worked with the complex mappings using SCD type 2.
• In Workflow Manager created connections, sessions, tasks, workflows etc.
• Work with Functional users to understand business process.
• Tuned mappings to achieve faster data loads to the data warehouse.
• Created mapplets to reuse the transformation in several mappings.
• Extracted, transformed data from various sources such as Flat files, and transferred data to the target data warehouse Oracle Database
• Involved in versioning the whole process and retiring the old records using the built-in's DD UPDATE, DD DELETE, and DD INSERT.
• Created mappings using Reusable Transformations and Mapplets
• Installing and configuring the Informatica Client Tools.
• Creation of output files as per specification and FTP transfer of these files to the destination folder.
• Taking backups of Informatica, production and Lookup databases.
• Designed and developed complex mappings using various transformations in Designer to load data from flat files, Sybase.
• Logical and physical database design for the COMMERCIAL MORTGAGE LOAN SYSTEM.

Confidential

Sr System Administrator

Database Architect/Database Analyst

Responsibilities:

• Performed Oracle database administration, including the creation and structuring of required database tables, and performance tuning.
• Responsible for the Corporate Data Model, development of data models and reverse engineering of production systems.
• Extensive exposure to OLTP (Oracle & MSSQL) applications with skills in client-server programming, application & database design.
• Database Applications with strong experience in process re-engineering, database design, client-server applications, web applications, imaging applications, data warehousing, database performance & tuning and application migration.
• Created data architecture by clustering the entity-relationship model into subject databases. Used the Corporate Information Model to plan and develop the Logical Database Designs for many new systems
• Installing, Configuring, Fine Tuning and Recovery Management of SQL Server & Oracle Server.
• Increased the Server Availability time with optimum level of Database Recoverability by incorporating the Differential backup and LOG Backup.
• Configured Oracle 7.1 Server and maintained on Solaris Sun Sparc.
• Developed the testing infrastructure to meet the Operational Continuity requirements including delivering the test plan, test procedures and test cases.
• Table and Index Partitioning for 200 Gigabyte tables in Oracle Database.
• Design and Development of the logical / physical structure of the database, Designed and developed PL/SQL Procedures, Triggers and Packages for implementing business logic.
• Oracle database administrator with 24/7 responsibilities for Data Backup, Data Recovery, performance tuning, and planning.
• Designed and implemented automated Database failover server setup, Responsible for daily network Oracle and MSSQL database backups.
• Determine and implement Backup, Recovery Plan for each Project/Database.
• Monitoring available resources to assure reliability, accessibility and recoverability.
• Monitoring the resources of the database Disk space utilization, system memory resources.
• Planning logical and physical layout of database Estimating space requirements, choosing the proper space allocation for database objects and Determining the correct setting of storage parameters.
• Involved in installation, maintenance and customization of Oracle databases. Involved with database and SQL tuning. Involved as a team member in design and application development and provided training on Oracle database maintenance to the clients.
• Performance tuning, query optimization, defining and designing backup strategies, managing the backup & export operations, capacity planning.
• Replication sites management, patch application and space management so as to provide the fault - tolerant 24/7 functionality.
• Use various utilities to transfer data to other platforms and build tables/indexes.

Network Architect/Designer/Support

Confidential

Responsibilities:

• Procured Routers, Layer2/3/4 switches, Systems, Servers, installed the network and maintained, Configured DNS, WINS, and DHCP.
• Managed all operations of installation and service provider for infrastructure systems: LAN, WAN, fiber optics, voice and data networks.
• Built, setup, and maintained multiple rack mounted servers and installed them at Co-Location facility (Linux and Windows).
• Upgrading and Trouble shooting Server Hardware.
• Identified hardware and configuration issues based on benchmark results.
• Technical issues also need to perform, such as hardware repair, software installation and BIOS reconfiguration, Devised a plan to standardize all software and hardware to decrease service calls, and halp desk support.
• Technical issues also need to perform, such as hardware repair, software installation and BIOS reconfiguration, Devised a plan to standardize all software and hardware to decrease service calls, and halp desk support.
• Upgrading Operating Systems to optimal standards and removing debilitating programs.
• Configuring Switches Cisco up to 6500 & Cabletron SSR2200, SMC6824M
• Configured Layer3 Switches with multiple routing using OSPF on Cabletron SSR2000, SSR8600 SSR8000 series over a load up to 80mbps and trouble shooting and maintaining the same.
• Configured Layer 2 Switches Cisco Catalyst Switches and Cabletron Smart Switches 2200, 6000 and SMC Switches for implementing MAN with VLAN’s.
• Monitoring network activities and traffic routing analysis in order to optimize the performance of the network.
• Designed the Network using Visio with Asset management, and keep on improving the network on continuation basis and updating on the main design.
• Performed site surveys, using Visio, to determine needed equipment and facilities to support the upcoming Conversion
• Installed and Configured Cisco ATA, Avaya 4620, 4612 IP phones.
• Monitoring the effective functioning of the routers based on branches connecting OLTP Server & Exchange server.
• Maintaining and trouble-shooting Server remotely connecting through IP or RAS.
• Configured H/W & S/W RAS Server for dial in connections.
• Prioritizing user requests and resolving complex issues without requiring escalation to a higher tier and providing technical phone support for Users.
• Managed large-scale PC using Seagate Disk Manager, Norton Ghost Imaging software.
• IBM Netfinity 7000 M10 Server, IBM PC Server 330, PC Server 704, and IBM Storage Media: DLT (Digital Linear Tape) Maintenance.

Confidential

Network Support Executive

Responsibilities:

• Set up new servers (development, product test, multi-unit test, and web servers) and create, and maintain new environment (development, product test, multi-unit test) workstations with Microsoft NT, Windows 2000, Windows 95 and Windows 98. This includes installing the OS, creating the appropriate file systems, adding third party software, installing OS patches, and setting up and maintaining users & Server Environments.
• Designed and instituted a proactive process for system administration to monitor network, security, user activity, system failures and other issues.
• Configured Windows 2000 Domain Server having roaming profiles and applying group policies and only autanticated users can access the documents and configured centralized backup store to backup, where users are using their respective systems.
• Actively Surpassed Microsoft network & Internet security met with advised Configuration and Security Patching for the Virus Threats and Potential Hacking Threats by following the advices of the internet monitoring & certifying authority.
• Manage the Information Systems Security Program in compliance with Information Assurance Vulnerability Alerts (IAVA) and the US Computer Emergency Response Team (CERT) for security vulnerabilities against the network.
• Analytical thinker with exceptional skills in project management, budget preparation and management, strong oral and written communication, presentation and negotiation abilities.
• Designed Monitoring System for all SNMP polling on Layer 2 and Layer 3 Switches for line outage and Bandwidth usage on each port for quickly trouble shooting on Broad Casts.
• Configured MRTG server for all SNMP monitoring on Linux for 6000 ports and creating alerts for any outage.
• Configured Exchange Server with IMAP and created document store for paper less office for respective department and also created network news protocol and published from all clients, where the posted news is on the server and will be refreshed from clients.
• Configured firewall on Linux using IPCHAINS and regularly following security alerts by certifying authority recommendations and following the same to apply patches, fixes and Service Packs.
• Configuring and Trouble shooting of MS Exchange Server configured POP3, IMAP, HTTP-Outlook-web Access and NNTP.
• Managed the use of the workgroup paperless document system along with the Electronic Filing System, only autanticated users can log into the Document store and can post as per their rights
• Configured Linux DNS Server & Send Mail Server with Squid Proxy.
• Implemented Web Caching Engine on Windows & Linux.
• Designing and Procuring Hardware and Software as per the requirement for Servers Hardware-vide Raid Controller, SAN box, Cluster Hardware and configuring the same.
• Configured, Maintained NATTING Server on Red hat Linux 7.2 with IPTABLES only registered systems will communicate with server and forwarded.
• Configured Send mail Server on Red hat Linux 7.2 with backup procedure.
• Configured backups and automated schedule for Oracle, Mail Server on Legato Auto Tape Loader.
• Demonstrated ability to easily grasp new ideas, concepts, methods and technologies.
• Implemented Stripe Set with Parity RAID 5 to maximize me/O performance and Disk Duplex with RAID 1 and other fault tolerance methods for zero downtime and protecting data.
• Bench Marking Systems for problem using different tools, methods and technologies.
• Reconfiguring the network as per the capacity planning. Deploying patches remotely using different methods and tools.