SUMMARY:

• 20 years IT experience in database design, development, implementation of various client/server, transactional and business analysis, data modeling, data cleansing, data migration, technical and business requirements analysis, business and data warehousing.
• 12 years of experience as SQL Server DBA
• Deep knowledge of AWS RDS and EC2 databases
• 12 years of experience as Data Migration, Data Cleaning, Data Modeler creating enterprise level logical and physical data models, T - SQL, data flow using Erwin, ER/Studio, PowerDesigner, Designer 2000 and Visio.
• Physical database design, star schema, and snow flake schemas to support transactional and analytical needs.
• 15 years of experience working on various databases including Oracle, UDB, SQL Server, AWS, DB2, and Sybase
• Experience in OLTP, OLAP database, ER design and reverse engineering.
• Experience in Informatica and Tableau
• Experience managing data center operations, including database backup, auditing, data assurance, monitoring, alerting and notifications
• Experience in AlwaysOn, Replication and Database Mirroring
• Created QA scripts to check the process
• Expert in upgrading SQL Server and SQL Server Migration
• Expert analytical, functional and business process re-engineering skills. Established and followed data base design standards and procedures.
• Expert in migration, development and support project.
• Used Team Foundation Server TFS for source control
• Expertise in software full life cycle (SDLC) projects from conceptualization to implementation and maintenance.

TECHNICAL SKILLS:

Data Modeling: ER/Studio Data Architect 2016, ERWIN, Oracle Designer, Visio, ER/Studio, Sybase Power Designer, Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Databases: Oracle 12c/11g/10g/9i/8i/8.0/7.x, SQL Server 2005-2016, IBM DB2 UDB 8.0/7.0, Sybase 12.x/11.x, VSAM file. Data Warehousing SSMA, SSIS, Informatica Power Center 9.x/8.x/7.x, Power Mart 6.x/5.x, Informatica Power Analyzer, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, ETI, Datamart, OLAP, OLTP, Mapplet, Transformations, Autosys, IMS Data, SQL*Plus, SQL*Loader. Toad, Amanda Enterprise software

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration, and team building.

BI Tools: Developer 2000 (Forms 6i, Reports 6i), SSRS, SSAS, SSIS

Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Unix Shell Scripting, PERL Programming, functions, packages, triggers, PowerShell Scripting, SQL Loader, DBA activities, SQA Basic, Developer/2000.

Environment: Sun Solaris 2.6/2.7/2.8/8.0, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, SCO Unix, AWS, Azure, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos, Windows 95/98/NT/2000/XP.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA\Architect

Responsibilities:

• Worked on Installation, administration and maintenance of SQL Server (standalone and clustered)
• Troubleshoot various database problems that arise in day - to-day work and performance tuning of database, Data Profiler and SQL query
• Monitor backups and database alerts. Used DBArtisan and other tools to monitor the databases.
• Recovered database to specific point of time and worked on database security
• Worked on multiple projects to migrate data from Access and FoxPro to SQL Server and Oracle
• Worked on TxEVER system to migration data from Oracle, Sybase, network files to SQL Server
• Created data flow diagram and data dictionary of old systems
• Created ER Diagram and data mapping
• Worked as ETL expert to migrate data to Oracle and SQL Server data center
• Provide continued support and development of bug fixes and patch sets for existing application
• Work on SSMA (SQL Server Migration Assistant), Informatica and SSIS (SQL Server Integration Service) to migrate data from Access and FoxPro to SQL Server and Oracle
• Develop, test and deploy various ETL jobs
• Design and develop stored procedures, functions and scripts
• Monitoring the log files, backups, database space usage and the use of system resources
• Involve in all DBA activities
• Worked on AlwaysOn, Replication and Database Mirroring
• Document the entire process and steps
• Monitor long running jobs, troubleshoot and resolve issues
• Recommend and implement indexes for performance enhancements
• Scheduling PowerShell scripts
• Monitoring the log files, backups, database space usage and the use of system resources

Environment: AWS RDS, AWS EC2, SQL Server 2014\2016, Oracle 11g, Access, FoxPro, DB Artisan, SSMA, SSIS, Azure

Confidential

Responsibilities:

• Worked as AWS SQL Server DBA
• Worked on SSIS (SQL Server Integration Service) to migrate data from Oracle, Access and FoxPro to AWS RDS SQL Server
• Understood Business requirements and design the technical specs.
• Designed and developed Procedures
• Optimized database and query
• Involved in all DBA activities
• Documented the entire process
• Knowledge Transfer

Environment: AWS SQL Server 2014, Oracle 11g, Access, FoxPro, DB Artisan, SSIS

Confidential

Responsibilities:

• Worked as SQL Server DBA
• Worked on SSIS (SQL Server Integration Service) to migrate data from Access and FoxPro to SQL Server
• Understood Business requirements and design the technical specs.
• Design Logical and Physical model for Oracle database.
• Extract the data from Sybase and SQL Server (BCP utility, Razor SQL)
• Design and develop Oracle & shell Scripts for update parameter file, Data Import/Export, Data conversion and Data cleansing.
• Create schema objects like Indexes, Views and Sequences.
• Worked on Installation, administration and maintenance of SQL Server (standalone and clustered)
• Troubleshoot various database problems that arise in day - to-day work and performance tuning of database, Data Profiler and SQL query
• Monitor backups and database alerts.
• Recovered database to specific point of time and worked on database security
• Develop test cases and traceability matrix
• Created Unix scripts for comparing the Oracle, SQL Server and Sybase data
• Design and developed stored procedures, functions and scripts
• Optimize SQL queries
• Involve in SQL Server DBA activities like backup schedule, agent jobs and alerts.
• Optimized database and query
• Experience with SSRS troubleshooting
• Involved in all DBA activities
• Worked on Replication and Database Mirroring
• Knowledge Transfer

Environment: SQL Server, Oracle 11g\9i, FoxPro, MySQL, DB Artisan, SSIS, FoxPro, SQL Server 2008, SQL Server 2005, DB Artisan, Toad, SSIS, ER Studio, Oracle Sql Developer, Razor Sql 4x, Toad, Unix, Visio, DB Solo, Sql Advantage, Sql Central

Confidential, Pittsburgh

Responsibilities:

• Was involved in data modeling and performance tuning
• Understood Business requirements and design the technical specs.
• Designed Logical and Physical model for MySQL database.

Environment: Erwin 7.2.1, MySql, Toad, Visio

Confidential, New York

Sr. Data Modeler

Responsibilities:

• Expertise in data migration, data cleansing, design and modeling, system study.
• Understand Business requirements and design technical specs.
• Performed source data analysis. Primary data sources were from Mainframe, DB2 & Flat files.
• Designed Logical and Physical model for OLAP database using Erwin.
• Translated Business requirements in to technical specifications.
• Optimized query, session performance.
• Designed and developed Oracle & shell Scripts for update parameter file, Data Import/Export, Data conversion and Data cleansing.
• Created schema objects like Indexes, Views and Sequences.
• Created QA scripts to check the process of ETL.
• Designed and developed Procedures.
• Documenting the entire process. The documents include interface document, mapping document and unit testing document.

Environment: Erwin 7.2.1, Oracle 11g, Data Analysis, IBM DB2, Mainframes, VSAM files, Informatica PowerCenter 8.0/7.1.2, Flat files, Rapid Sql, ER/Studio, DBArtisan, PL/SQL, Perl, Unix scripting, Windows NT, Autosys, Linux, Edit Plus.

Confidential, New York

Sr. Data Modeler\ Migration

Responsibilities:

• Expertise in data migration, design and modeling, system study, data cleansing.
• Was involved in data modeling, extraction of data from mainframe
• Designed Logical and Physical model for database using Erwin
• Worked on loading of data from several flat files sources.
• Experienced in the use of agile approaches (Agile methodology), including Extreme Programming and Test-Driven Development.
• Used Autosys scheduler to schedule jobs.
• Designed and developed Procedure & shell Scripts for Data Import/Export, Data conversion, parameter file and Data cleansing.
• Extensively used complex SQL queries for querying and analysis of data
• Documenting the entire process. The documents include interface document, mapping document and unit testing document.
• Designed and developed procedure, sql & shell Scripts for update parameter file, Data Import/Export, Data conversion and Data cleansing.
• Optimized query, session performance.

Environment: ER/Studio, Oracle 10g, Data Analysis, Erwin 7.2.1, Flat files, COBOL Files, IBM DB2 8.0, Mainframes, VSAM files, SMP environment, Rapid Sql, DBArtisan, Toad, Perl, Unix scripting, QA scripts, Windows NT, Autosys, Microsoft Project Plan, Linux, Edit Plus.

Confidential

Senior Data Modeler

Responsibilities:

• Design, development and maintenance of Insurance policies and claims transactions Data Mart using Informatica Power Center.
• Developed and designed Datamart extensively using Star Schema.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements.
• Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load the data into Oracle. Tuning Informatica Mappings and Sessions for optimum performance.
• Extract data from the flat files.
• Went in as an Informatica Expert to fix Production & Performance issues within Insurance and Banking departments.
• Fine-tuned complex mappings for External sources
• Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing purposes.
• Solely responsible for the daily loads and handling the reject data.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.
• Executing test scripts to verify actual results against expected results by using PowerConnect for source validation and Oracle for target validations.
• Prepared documentation for business data flow from source to mart and for the changes made to the mappings/sessions existing to eliminate the errors.
• Responsible for building model for Audit, Balance and Control, which suits for multiple projects
• Defined file provisioning process (DW Pre processing Steps)
• Extensively worked in SQL, PL/SQL, SQL*Plus, Query performance tuning, Created DDL scripts, created database objects like Tables, Indexes, Synonyms and Sequences.
• Worked on Informatica Power Center tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Development of Informatica mappings and in tuning of mappings for better performance.
• Implemented UNIX shell scripts to load Audit (simple, series) data into Data base.
• Defined and Implemented audit rules and Events to match the audit points.
• Build scripts for loading exceptions into Database. (UNIX and SQL loader utilities).

Environment: ER/Studio, Informatica PowerCenter 7.2, Erwin 4.5, Autosys, PL/SQL, Oracle 9i\10g, SQL Server 2000, SQL*Loader, Oracle Warehouse Builder, UNIX, Windows 2000.

Confidential

Data Modeler/Analyst

Responsibilities:

• Extensively design Logical/Physical Data Models, relational database design using Erwin
• Reverse engineering existing systems through Erwin and convert them according to company standard architecture.
• Analyzed Business requirements; Conducted Scope out of the Project, Feasibility study.
• Modularized and Prioritized tasks based on Business prioritizations.
• Delegated and following up with the team on the deliverables.
• Interfaced with Customers and Stakeholders for Requirements Analysis and Business rules.
• Design & Develop ETL process for multiple businesses.
• Mentored, motivated and guided the team to achieve business objectives in a timely manner.
• Defined ETL Jobs with Data Integrator for loading data from Source to Target.
• Extensively used ETL tool Data Integrator to cleansing and populate target datasets.
• Design, write and tune transformations through database triggers
• Developed Informatica Mappings, Mapplets, Sessions, Workflows using transformations like Joiner, Lookup, Source Qualifier, Router, Expression and Procedure Editor etc
• Revised the DW data aggregation process; delivered a simple, reusable and robust process that decreased the process time by 50%.
• Invented a Dynamic reporting tool to prepare Data mart reporting on the fly to Digital cockpit, Data Warehouse even during data refresh; attaining 100% data availability.
• Implemented quality using Six Sigma and Maintained documentation according to SDLC.
• Mentored team on Oracle and Informatica.
• Resolved data loading, query, presentation performance issues and optimized user experience.

Environment: Oracle 9i, PL/SQL, SQL* Loader, Informatica Power center7.2, Erwin, HP UNIX

Confidential

Data Modeler\Consultant

Responsibilities:

• Extensively design Logical/Physical Data Models, relational database design using Erwin
• Extensively worked in SQL, PL/SQL, SQL*Plus, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
• Customer/User interface for Requirement Analysis & documentation of Business rules
• Setup DW best practice and standards to be used throughout the business.
• Modeled the Data warehousing Datamarts using star Join schema.
• Provided production support by monitoring the processes running daily. Preparation of Unit Test Plans and verification of functional specifications and review of deliverables. Identified the bottlenecks and improved overall performance of the sessions.
• Used Cognos for report generation.
• Develop Logical and Physical data model for Data Warehouse supporting data from multiple sources on real time.
• Extensively worked with Informatica to Load data from flat files, DB2 to target database.
• Mentored junior programmers in Oracle database design and development.
• Responsible for performance tuning ETL process to optimize load and query Performance. Created complex transformations using connected / unconnected lookups / procedures.
• Wrote SQL overrides in source qualifiers with appropriate schema names for extracting only the required rows for optimal performance. Implemented complex expressions in expression transformations. Tested the queries thoroughly in SQL navigator for integrity and identifying data errors.
• Worked in Supply Chain Service
• Integrated existing error handling system with new modules.
• Performed analysis of the data transformations and data types for transforming business rules into transformation logic to be used in the ETL process.
• Created Reports in both full client and web - I facilitating drilling down.

Environment: Oracle8i\9i, Toad, Informatica, SQL, PL/SQL, Erwin 4.0, Windows NT 4.0,Windows 2000, HP - UX, Sun Solaris 2.6, IMS, Mainframe,Db2, Developer 2000, Cognos, UNIX Shell Scripts.

Confidential, Indiana

Oracle Developer

Responsibilities:

• Analysis of Source, Requirement, existing OLTP system and Identification of required dimensions and facts from the Database.
• Extracting the data from various sources of input & loading into Oracle Data Warehouse.
• Writing batch programs and database triggers at staging area for population of warehouse. Creating sessions and batches.
• Developed Oracle PL/SQL Stored procedures & Performance tuning of Oracle PL/SQL queries.
• Setting of Error Logic for streamlining and automating the data loads for cleansing and trapping incorrect data on staging servers and then loading it to the data warehouse and Populating the warehouse.
• Creating Sessions and batch management and Performance Tuning and initial testing followed by the volume testing Resolve technical issues with consultants and vendors.

Environment: Oracle 8, Developer 2000 (Forms 4.5 & Reports 2.5), SQL PLUS, PL/SQL, Windows NT.

Confidential, INDIANA

Programmer Analyst

Responsibilities:

• Analyzed and understood the System requirement document.
• Produced and Designed High-level and low-level requirement documents.
• Driven team towards implementing design and coding standards.
• Developed user interface / input screens and reports.
• Implemented business rules using procedures and triggers.
• Produced Test cases documents and tested screen inputs and business rules.
• Conducted Peer-Review and unit testing of user input screens.
• Integration testing of input screens and reports.
• Published project unique features across teams.
• Participated in organization technical discussions to share best practices.
• Implemented of software at customer site.

Environment: Oracle 8, PL/SQL, Developer 2000, Sun Solaris 5.8, Unix Shell scripting

Confidential

Programmer/Sr. Programmer

Responsibilities:

• Coding as per the code defect analysis and specifications design
• Developed user interface / input screens and reports.
• Produced Test cases documents and tested screen inputs and business rules.
• Developed user interface / input screens and reports.
• Conducted Peer-Review and unit testing of user input screens.
• Integration testing of input screens and reports.
• Published project unique features across teams.
• Participated in organization technical discussions to share best practices.
• Implemented of software at customer site.

Environment: Mainframe-COBOL II, DB2, CICS