SUMMARY:

• Seventeen Plus years (17+) of experience in IT and SDLC with Data Integration and Data Warehousing.
• Experience in Software Development Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Enhancement of Data Warehouse and Data Integration Applications.
• Experience in Data Warehousing, Ralph Kimball Methodology, Dimensional Modeling, OLTP, OLAP, Star Schema, Snow Flake Schema, Fact Table, Dimensional Table, Slowly Changing Dimensions, Incremental Extraction, and Change Data Capture.
• Expertise in ETL (Extract Transform Load) using Informatica Power Center 9.5/9.1/8.6/7.1.1, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gantt Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re - usable Transformations, Shortcuts, Informatica Power Connect, Performance Tuning, Error Handling, and Informatica Best Practices
• Experience in Relational Databases like MS SQL Server2000-2008r2, Oracle 11i/10g/9i, Sybase10-12.5, MS Access 2000/2003, DB2, SQL, PL/SQL, Stored Procedures, Functions, Packages, Indexes, Sub Queries, and Performance Tuning.
• Experience in working with legacy source systems, Mainframe COBOL Files, Fixed Width and De Limited Flat files.
• Experience in Database Administration, System Analysis, Design, and Development & Support of MS SQL Servers 6.5, 7.0, 2000, 2005 and 2008 in Production and Development environments.
• Possessing experience in Designing, Testing, and implementing various projects on Web based and Client/Server applications.
• Expertise in Relational Database Management Systems. Extensive experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC, Data Modeling using ERWIN and Stored Procedures, Database Triggers and DTS package creation.
• Conceptual knowledge of Teradata, SAP, SalesForce ETL data loading
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file using BCP, Bulk Insert & DTS utility. Involved in transformation of OLTP data to the Data Warehouse using DTS and SQL commands.
• Very good knowledge in various logical diagrams like ERD, DFD, Conceptual diagram, Context diagram various levels.
• Excellent in analytical and team-working skill. Exceptional Interpersonal Skills with the ability to work independently.

TECHNICAL SKILLS:

Data Warehousing/Data Integration: Ralph Kimball, Bill Inmon, Bottom Up/Top Down, Dimensional Modeling, Relational Modeling, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Slowly Changing Dimensions

ETL: Informatica PowerCenter 9.5, 9.1, 8.6, 8.5, 8.1, 7x(Designer, Workflow Manager, Workflow Monitor, Repository Manager, Workflows, Mappings, Mapplets, and Tasks), SSIS, PowerConnect/Power Exchange, IDQ

Databases: MS SQL 6.5/7/2000/2005/2008, MS Access, Sybase ASE 12.0/11.9.2/11.5.1 & 10.0, Oracle 11i/10g/9i/8, Paradox

Tools: & Utilities: Visio, Erwin, Crystal Reports, WinCVS, TOAD, SQL Loader, DAC, HPSD, SSMS, SSIS, SSRS,Informatica ETL, HPSD, Bridge clarify, MiniTAB, sFn

Environment: Win 9x/2000/NT, HP-UX, AIX, Novell

Languages: C++, C, Cobol

GUI: Visual Basic, ASP

Domain Knowledge: Retail, Health, Telecom, Accounting, Finance, Sales and Energy

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Senior Lead consultant

• Responsible for gathering the requirements both functional and technical and documentation of the same and creating the mapping documentation for CASH stream.
• Very closely worked in EAGLE and EagleAccess PACE components/modules and scheduling.
• Worked with the business analysts in requirement analysis to implement the ETL process
• Used loading techniques like Slowly Changing Dimensions and Incremental Loading using parameter files and mapping variables.
• Used various data cleansing functions in Informatica and data conversion functions.
• Created re-runnable SQL scripts to create tables, triggers, indexes, views, packages and procedures.
• Responsible for data conversion from SQL Server to Oracle 10g.
• Responsible for working with DBAs for DDL Changes in Oracle 10g and 11g (Tables/Views/Stored Procs/Packages/Functions/Triggers)
• Wrote pipeline function in Oracle for Source query
• Planned/participated in DR exercises, application risk management planning and effective backup and recovery planning for applications.
• Extensively participated in various testing like, Development Unit Testing, Integration testing, User Acceptance testing and regression & performance testing.
• Responsible for Eagle GUI events/packages/scheduling creation and execution.

Environment: EAGLE, Informatica PowerCenter 9.5 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), Oracle 11g, MSSQL Server 2008 R2, T-SQL, SQL Server, PL/SQL Developer, Windows XP

Confidential, Minneapolis, MN

Senior Lead consultant

• Responsible for gathering the requirements both functional and technical and documentation of the same and creating the mapping documentation.
• Loaded data into various star schema data warehouse dimension and fact tables.
• Responsible for Development environments in Informatica for creating users from admin console, creating folders from Informatica Repositories, scheduling jobs.
• Created re-runnable SQL scripts to create tables, triggers, indexes, views, packages and procedures.
• Responsible for data conversion from SQL Server to Oracle 10g.
• Responsible for working with DBAs for DDL Changes in Oracle 10g and 11g (Tables/Views/Stored Procs/Packages/Functions/Triggers)
• Planned/participated in DR exercises, application risk management planning and effective backup and recovery planning for applications.
• Extensively participated in various testing like, Development Unit Testing, Integration testing, User Acceptance testing and regression & performance testing.
• Full time production environment support and maintenance, proactive monitoring for the retail operations.
• The environment includes SQL server, SSIS, OPALIS, EDI, Oracle, Oracle Apps, Informatica which are updated and maintained using Master Data Management(MDM)

Environment: Informatica PowerCenter 8.6/9.1 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), DAC, IDQ, Oracle 10g, MSSQL Server 2008 R2, T-SQL, ERWin, SQL Server, TOAD, PL/SQL Developer, Windows XP

Confidential, Baltimore, MD

Senior Developer

• Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table id's, and translation rules. Evaluation of data groups and data critically and developed automated conversion process.
• Stored Procedures for parsing data required for mapping in Sale Force. Tweaked low performance functions.
• Preformed QA Testing for all the Store Procedures to validate the sales results.
• Developed Packages not only for particular table's fields and required data types for lookup tables in Staging but also for data Warehouse requirements.
• Responsible for gathering the requirements both functional and technical and documentation of the same
• Worked with the business analysts in requirement analysis to implement the ETL process
• Used loading techniques like Slowly Changing Dimensions and Incremental Loading using parameter files and mapping variables
• Extensively used the PowerCenter client tools Designer, Workflow Manager, and Workflow Monitor
• Performed all QA testing and match results for different environments.
• Experience in working with Access management, Sales, Order management and fulfilling system of publishing company.
• Different kind of Pivot table reports generation for easy access for the users for their immediate requirement.
• Managing all Development, staging, upgrade and Production environment SQL Servers and keeping data in Sync which is managing data quality.
• Handling Database backup schedule and, proactive monitoring for all apps.

Environment: Informatica PowerCenter 8.6.1 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager, Data Quality, Oracle 10g, MSSQL Server 2008 R2, T-SQL, ERWin, SQL Server, TOAD, PL/SQL Developer, Windows XP, Visual Basic 6, .Net, SQL Server 2005&2008, SSIS, SSMS, Windows 2000

Confidential, Phoenix, AZ

Lead Developer

• Loading data from other environment (Access, excel, SQL Server) to oracle using SSIS packages and SQL Loader and Informatica for Oracle Global repository.
• Uploaded data for maintaining Master Data Management(MDM)
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Handled Performance tuning by increasing buffer block size, error handling.
• Responsible for gathering functional specifications and converting it into mapping documents.
• Performed all QA testing and match results for different environments.
• Experience in working with Access management, Sales, Order management and fulfilling system of publishing company.
• Documented all old and migrated Store Procedures and scripts for future references.
• Different kind of Pivot table reports generation for easy access for the users for their immediate requirement.
• Managing all Development, staging, upgrade and Production environment SQL Servers and keeping data in Sync which is managing data quality.
• Handling Database backup schedule.

Environment: Informatica PowerCenter 8.6.1 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager, Data Quality, Oracle 10g, MSSQL Server 2008 R2, T-SQL, ERWin, SQL Server, TOAD, PL/SQL Developer, Windows XP, Visual Basic 6, .Net, SQL Server 2005&2008, SSIS, SSMS, Windows 2000

Confidential

Senior Lead Database Developer

• sFn, Minitab tools were used for data quality analysis.
• Loading data from other environment (Access, excel, SQL Server) to oracle using SSIS packages and SQL Loader and Informatica for Oracle Global repository.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using T-SQL.
• Perform quality assurance and testing of SQL server environment.
• SQL consulting for all (around 40) SQL server based applications.
• Application, Database, Database Server maintenance, Data Archival, Purge and Retention
• SQL jobs on Database servers, Stored procedures and User Defined Function
• Tables and Indexes, Disaster Recovery (Availability and Scalability)
• Delivery process (Change request implementation)
• Audit the databases and servers and suggest the solutions based on the Observations, non-conformance and best practices. Done audit for databases on 3 SQL servers at Pleasantville.
• Worked in MSR-US audit, 2 Oracle servers. Involved in audit for databases on 3 SQL servers at Milwaukee.

Environment: Informatica PowerCenter 7.1/8.6.1 (Designer, Work Flow Manager, Work Flow Monitor, Repository Manager), Data Quality, Oracle 10g, MSSQL Server 2008 R2, T-SQL, ERWin, SQL Server, TOAD, PL/SQL Developer, Windows XP, Visual Basic 6, .Net, SQL Server 2005&2008, SSIS, SSMS, Windows 2000, Visio, sFn, Minitab.

Confidential, Atlanta, GA

Database Consultant

• Scripts for Creation of Schema and business required stored procedure and functions for SCADA Starlite application.
• Scripts for Creation of Schema and business required SPs and functions for Java, JSP, servlet.
• Visual mining tool for graphical inter faces.
• Creating database and schema design for SCADA system.
• Set up Schema design, Stored Procedures, Functions and DTS packages in multiple SCADA locations.
• Create and maintain Stored Procedures, Functions and DTS packages implementation.
• Creating user Databases, Logins, Users, Rolls for application user at development and system test environments.
• Taking care of all system and user databases backups.
• Loading data from other environment (Access, Paradox and SQL Server) to oracle using DTS packages and SQL Loader and Informatica for Oracle Global repository.
• Schedule the Transaction log backups.
• Applying Service packs for SQL Database Server. String the databases if based on requirements.
• Responsible for database performance and tuning.
• Database Schema designing using third party tools like ERwin.
• Windows administration for setting up users and file system.
• Working with SCADA analyst team, fixing the database level problems on time.
• Managing security tasks like granting and revoke permission for users.
• Maintaining deferent versions of Stored Procedures, functions, and triggers using VSS.
• Taking care of Production issues and Production Database support on weekends.

Environment: Informatica 7.1, Oracle 8, Visual Basic 6, .Net, T-SQL, SQL Server 2000, SQL Server Management Studio, Windows 2000, Visio, ERwin

Confidential, Dallas, TX

Lead Database DBA/Developer

• Setup the database environment for the Test, Development Applications
• Perform database backups in conjunction with server backups
• Provided assistance and make recommendations for database monitoring and tuning
• Created and administered Database, login accounts and database user accounts.
• Managed database security using groups and roles
• Created database objects and managed the permission access on the objects with necessary security
• Windows administration for setting up users and file system.
• Extensively worked in Erwin for Data modeling.

Environment: Visual Basic 6, .Net, T-SQL, SQL Server 2000, SQL Server Management Studio, Windows 2000, Visio, ERwin

Confidential, Atlanta, GA

Lead Database DBA/Developer

• Implemented Logical and Physical modeling of the system
• Created and administered Database, login accounts and database user accounts. Managed database security using groups and roles
• Created database objects and managed the permission access on the objects with necessary security
• Created the necessary indexes to improve the query performance
• Assisted developers in DB activities
• Windows administration for setting up users and file system.

Environment: Visual Basic, T-SQL, SQL Server 2000, SQL Server Management Studio, Windows 2000, Visio, Erwin

Confidential

Lead Database DBA/Developer

• Have done Requirement Analysis
• Implemented Logical and Physical modeling of the system
• Created and administered Database, login accounts and database user accounts. Managed database security using groups and roles
• Created database objects and managed the permission access on the objects with necessary security
• Created the necessary indexes to improve the query performance
• Extensively used BCP utility to populate test/setup database Tables from text files received from different applications
• Assisted developers in DB activities
• Windows administration for setting up users and file system.
• Server database backup using DTS Package

Environment: Visual Basic, T-SQL, SQL Server 2000, SQL Server Management Studio, Windows 2000, Crystal Reports, Visio, Erwin

Confidential, Atlanta, GA

Application support DBA

• Provided 24 x 7 support
• Processing (OLTP) databases that consist of Sybase and other custom Developed applications on SQL Server, VB 6
• Monitoring servers and providing out-of-hours production support on a rotation basis.
• Automated database consistency checks and database growth monitoring.
• Performance and tuning, building database schema and creating and maintaining database objects
• Stored procedure development, loading and unloading data, building and supporting a Sybase QA environment, backup and recovery management
• Participate in cross-area support for problem diagnosis and resolution, capacity planning, and performance requirements

Environment: Visual Basic 6, T-SQL, SQL Server 2000, Sybase ASE, Visio, Erwin, Crystal Reports, Cognos BI, Windows 2000

Confidential

DBA/Developer

• Created database storage devices and databases. Created and administered server login accounts and database user accounts. Managed database security using groups and roles
• Created database objects and managed the permission access on the objects with necessary security
• Created Stored procedures, Query optimization and triggers
• Created SQL server login accounts and database user accounts
• Upgraded the system from Sybase 10 to Sybase 11.9.2.
• Automated SYBASE server database backup using Shell scripts
• Automated consistency check of the databases (DBCC) using Shell scripts and scheduled to run as nightly CRON job
• Analyzed & Fine-tuned the Sybase SQL Server performance at regular intervals
• Created the necessary indexes to improve the query performance
• Extensively used stored procedures to perform complex operation.
• Debugged and Tested stored procedure from developers and improved the performance

Environment: Visual Basic, T-SQL, Sybase 10, 11.5 & SQL Server 2000, Visio, ERwin, Windows 2000

Confidential

DBA/Developer

• Installed and configured Sybase server under HP-UX
• Created database storage devices and databases. Created and administered server login accounts and database user accounts. Managed database security using groups and roles
• Created database objects and managed the permission access on the objects with necessary security
• Created Stored procedures, Query optimization and triggers
• Created SQL server login accounts and database user accounts
• Upgraded the system from Sybase 10 to Sybase 11.9.2.
• Automated SYBASE server database backup using Shell scripts
• Automated consistency check of the databases (DBCC) using Shell scripts and scheduled to run as nightly CRON job
• Analyzed & Fine tuned the Sybase SQL Server performance at regular intervals
• Created the necessary indexes to improve the query performance
• Extensively used stored procedures to perform complex operation.
• Debugged and tested stored procedure from developers and improved the performance

Environment: APT, DWB, T-SQL, Sybase 10, Visio, ERwin, HP-Unix