SUMMARY

• More than 6 years of IT experience in SQL, Oracle, Business Intelligence Studio, Informatica, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Extensive experience in conceptual design, logical design and physical design of data models, Star - Schema Modeling, Snowflake Schema Modeling.
• Excellent experience in Installation and configuration of SQL, Oracle in UNIX/LINUX and Windows environment. .
• Proficient in writing complex SQL queries, stored procedures, normalization, database design, creating indexes, functions, triggers, and sub-queries.
• Experience with SSIS packages, UNIX Shell Scripting, Partitioning, Logical and Physical database design.
• Performed routine maintenance on databases; monitored and tuned databases using Performance Monitor, SQL Server Profiler and Dynamic Management Views.
• Implemented and maintained security rules and security audits.
• Experience in analyzing the database performance and performed database performance tuning.
• Upgrade/Migration of Databases from SQL/Oracle older version to new version.
• Proficient in Database Administration activities such as Upgrades, Performance Tuning, capacity planning, script development, and documentation.
• Management of schemas, objects & partitioning the tables & indexes.
• Good Knowledge on developing ETL programs for supporting Data Extraction, Transformation and loading data using Informatica.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation..
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources, and scheduling.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.

TECHNICAL SKILLS:

Database Tools: Microsoft SQL Server, Oracle, PL/SQL, MS Access, Teradata.

Data Modeling Tools: Erwin, MS Visio, ER Studio, Oracle Designer.

Reporting & Other Tools: SQL Server Reporting Services (SSRS), OLAP/OLTP, Business Intelligence & Development Studio, SQL BI

ETL Tools: SSRS, SSIS (SQL Server Integration Services),, Informatica.

Languages: SQL, PL SQL, T SQL, XML

Packages: Microsoft Office, Microsoft Project, Microsoft Visio, Share point Portal Server

ETL/Datawarehouse Tools: Tableau, Pivot Tables, Erwin, HP ALM

Operating System: Windows, UNIX, Linux

Tools: & Software: TOAD, MS Office

Others: MSOffice (Word, Excel, PowerPoint, Access), MS Project, Rational Rose, UML

PROFESSIONAL EXPERIENCE:

Confidential

SQL Data Analyst

Responsibilities:

• SQL Production Database administration including SQL 2012/2016.
• Responsible for continues database monitoring and reorganization for ensuring performance.
• Installation, configuration and maintaining SQL and DB2 databases.
• Constructed SSIS packages tested and implemented to import-export OLEDB sources.
• Coordinate SSRS, SSIS packages, maintenance plans, store procedures, transactional/merge replication and latency.
• Evaluate and monitor execution plans, query plans, key lookup operators for all troubled code.
• Evaluate transaction isolation levels.
• Analyze clustered/non-clustered index allocation and included columns, and optimization of query plans.
• Monitoring, optimize and requested allocation physical data storage for database systems Planned and coordinated data migration between systems.
• Responsible for establishing standards, policies and procedures for replication administration’s-ordination has been extended to Application developers for coding to improve the performance of the database.
• Responsible for creating users and set permissions.
• Managing database security using groups, roles and handled number of databases in different locations.
• Analyzing the database performance and performed database performance tuning
• Discussions regarding the business processes with business owners, gathering of requirements and blue printing
• Creation of Design Documents i.e. Functional Design Document, Technical Design Documents, Testing Design Documents
• Initiating and arranging different testings i.e. Unit testing, Integration Testing, UAT, Regression Testing, Quality testing
• Writing SQL queries, stored procedures, normalization, database design, creating indexes, functions, triggers, and sub-queries.

Confidential, Westfield Center, OH

SQL/Oracle DBA

Responsibilities:

• 24x7 SQL Production Database Administration including SQL 2012/2010.
• Responsible for installation, configuration and maintaining SQL and Oracle Databases.
• Installed and configured OEM Grid Control.
• Involved in Upgrade/Migration of the SQL databases from SQL 2008 to SQL 2010/2012.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Constructed SSIS packages, tested and implemented to import-export OLEDB sources.
• Coordinate SSRS, SSIS packages, maintenance plans, stored procedures, transactional/merge replication and latency
• Evaluate and monitor execution plans, query plans, key lookup operators for all troubled code; Evaluate transaction isolation levels.
• Analyze clustered/non-clustered index allocation and included columns, and optimization of query plans.
• Monitored, optimize and requested allocation physical data storage for database systems
• Planned and coordinated data migration between systems.
• Responsible for establishing standards, policies and procedures for replication administration.
• Co-ordination has been extended to Application developers for coding to improve the performance of the database.
• Created users and set permissions.
• Managed database security using groups, roles and handled number of databases in different places.
• Created database objects and managed the permission access on the objects with necessary security.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine tuned further.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Planned the Complete backing up of Database and Restored the Database from Disaster Recovery.

Confidential, Jersey City, NJ

Oracle DBA/Data Analyst

Responsibilities:

• SQL and PL/SQL Programming.
• Installation and configuration of Oracle Client software and Tools.
• Analyzed the user requirements and designed partitioned tables for improving performance of Data marts.
• Worked with data source systems and Client systems to identify data issues, data gaps, identified and recommended solutions.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Involved in data mining, transformation & loading from the source systems to target system.
• Provided input into database systems optimization for performance efficiency and worked on full lifecycle of data modeling (logical - physical - deployment)
• Created Column Store indexes on dimension and fact tables in the OLTP database to enhance read operation.
• Analyzed the user requirements and Designed views using STAR schema for improving performance of Data marts.
• Performed partition maintenance and automated the process of creating new partitions as and when required.
• Automated the process of analyzing tablespaces every night.
• Working alongside programmers and contributing to the development process; Enabling and analyzing trace files
• Responsible for continuous database monitoring and reorganization for ensuring performance
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Developed back-end logic for business applications, e.g. views, procedures/functions, triggers.
• Performing monitoring and performance tuning.
• Performing daily Archive log file backup and checking Alert Log files.

Confidential, Philadelphia, PA

Data Analyst

Responsibilities:

• Gathered various reporting requirement from the clients and Solution Architects.
• Assessed and developed strategic Data Governance goals, Data Quality Assurance processes, Master Data Management administration.
• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Did data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Developed and Tuned sources to targets mappings and sessions to improve the performance of data load.
• Provided the preliminary set of metrics for report generation and Report Delivery mechanism through MS Reporting Analytics.
• Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
• Reverse Engineering the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schema for the detailed data marts and Plan data marts involving Confirmed dimensions.
• Created Test Cases and Helped ETL team in performing Smoke and Regression Testing.
• Created Source to Target mappings for Billing, Customer and Product Related Dimensions and Facts.
• Created and maintained the Data Model repository as per company standards.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to Support the further aggregated level of detailed reports.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.

Confidential, Portsmouth, NH

Data Analyst

Responsibilities:

• Analysis of functional and non-functional categorized data elements for Data Migration, data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worke d with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Experience developing data transformation & cleansing rules for migration using ETL tools.
• Analyzed multiple source system to identify the data for migration.
• Coordinated data migration from old to new system during Teradata system capacity expansion.
• Performed data mining on data using very complex SQL queries and discovered pattern.
• Created DML code and statements for underlying & impacting databases.
• Extensively developed PL/SQL Stored Procedures, Functions, Triggers and Packages.
• Documented the existing mappings as per the design standards followed in the project.
• Worked with ETL developers with data mapping specifications.
• Developed complex mappings to load the data from source systems (Oracle) and Mappings.
• Wrote PL/SQL statement & stored procedures in Oracle for extracting and writing data.
• Carry out Defect Analysis and fixing of bugs raised by the Users.
• Involved in creating Enterprise data dictionary & data standards to ensure data quality & consistency.
• Implemented Data Archiving strategies to handle the problems with large volumes of data by moving inactive data to another storage location that can be accessed easily.
• Created DDL for documenting and replicating the database’s build procedures and handed it over to the DBA team.
• Created Source to Target mapping document which contains the transformation logic and handed it over to ETL Team.
• Supported the testing department to create Test data and Unit test cases to ensure successful data loading process.