SUMMARY

• 10 years of experience in IT which includes Database Administration, Database Development, Data Warehousing and Reporting using various databases like SQL Server, Oracle, Netezza, Teradata, including Microsoft BIDS (SSIS, SSRS and SSAS) and Crystal Reports.
• Experience in development of Stored Procedures, Functions and Triggers.
• Experience in designing Star Schema and snowflake schema with Facts and Dimensions.
• Experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Experience in Dimensional Modeling.
• Migrated DTS packages to SSIS and modified using DTS Editor Wizard.
• Worked on Data Warehouse and Data Marts to load the data from different sources for reporting purposes.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services.
• Worked on reports generation using SSRS and Crystal Reports.
• Automating data loading, extraction, reports generation using UNIX Shell Scripting.
• Involved in Database Design, Creation and Maintenance.
• Planning of logical database and physical layout.
• Creating Primary Database Storage Structures (Filegroups/Tablespaces), Primary Objects (Tables, Views and Indexes).
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Experience in installation, configuration and maintenance of SQL Server.
• Backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types and functions.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experience in Database backup and disaster recovery procedures.

TECHNICAL SKILLS

Operating Systems: MS - Dos, Windows NT/2000/XP/7, HP-UNIX and Sun Solaris

Languages: SQL, PL/SQL and Shell Scripting

Tools: SQL, Import/Export, Import/Export Data-Pump, RMAN, SQL*LOADERSQL*PLUS, TOAD, Oracle Enterprise Manager, BIDS, DTS, SSIS, SSRS, SSASCrystal Reports XI/2008

Data Warehousing: Talend Integration Suite 4.2.2, Talend MPX 4.1.1, SSIS

RDBMS: SQL Server 2005/2008/2012 , Oracle 10g/9i/8i, Netezza, Teradata, Sybase

SQL Dev Tools: TOAD for Oracle 9.0, TOAD for Data Analysts 2.5, Teradata SQL Assistant 12.1Aginity Netezza Workbench 2.1, SQL Navigator and Oracle 10g Reports

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Senior SQL Server Database Administrator

Responsibilities:

• Worked closely with Business Users, discussed and gathered the requirements from different user groups to perform gap analysis, Data Modeling and designing the application.
• Responsible for the designing the advanced SQL queries and Procedures.
• Migrated data from different data sources like Excel, Flat files (pipe delimited/fixed width) to SQL Server.
• Created SSIS packages to automatically download the files from sFTP site and load the data to target databases.
• Created users and groups and assigned explicit and individual permissions and privileges to access the data.
• Created and Tested Reports and delivered the reports to the users as email notifications.
• Migrated tested code from Dev to Staging/History/Pre-Prod and Production environments.
• Involved in creating Stored Procedures for data manipulation and movement.
• Involved in creation of database objects like Tables, Views and Indexes.
• Created Databases and Database Objects like Tables, Stored Procedures, Views and functions.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration, Query Performance tuning.
• Created Backup Scripts and schedule the Backups using SQL Server Agent jobs.
• Supported other teams by taking Backups and restoring into different servers as well as setting up Service Broker for their reporting/UAT needs.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Running DBCC consistency checks, fixing data corruption on application databases.
• Scheduled the recurring/adhoc jobs using SQL Server Agent.
• Setting up and Monitored transactional replication on Production servers.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.

Environment: SQL Server 2008, Visual Studio 2008, SSIS 2008 and WINDOWS XP.

Confidential, Jacksonville, FL

SQL Server Database Developer

Responsibilities:

• Worked closely with Project Managers/Business Analysts to identify key data element for CCA Dashboard.
• Conducted GAP analysis and prepared GCW cross reference document to identify which source data that is available/not available in the existing GCW target system.
• Consolidated application data from multiple Systems of Records (SORs) and Systems of Aggregations (SOAs) into Global Credit Warehouse (GCW) data sourced by Global Corporate and Investment Banking (GCIB) and Global Wealth Investment Management (GWIM) from a total of 16 SORs.
• Helped in preparing Technical Design Documents including HLD and LLD.
• Followed SDLC Process and Implemented Best Practices in Data Warehousing.
• Created various jobs that load the data from different systems like ECRIS, ACBS and CTS etc. that are residing on Teradata, Oracle, SQL Server Databases into SQL Server.
• Used SSIS Packages to load the data from the multiple sources to target database.
• Created multiple sets of jobs that load data to different environments like Dev, QA, UAT and Prod.
• Used SQL Server Agent to schedule the jobs that loads the data on timely manner.
• Used multiple transformations based on the user requirements before loading the data into target system.

Environment: Microsoft SQL Server 2012, Microsoft Visual Studio 2012, SQL Server Data Tools for Visual Studio 2012, Team Foundation Server and Windows 7.

Confidential, Jacksonville, FL

SQL Server Database Developer

Responsibilities:

• Worked closely with Business Users within Foreclosure and Bankruptcy areas, discussed and gathered the requirements from different user groups to perform gap analysis and designing and developing the reports.
• Created various store procedures and bundled as SQL Server jobs that load the data into different tables on nightly basis so that the data is available for the reports during the normal business hours.
• Used Crystal Reports to design and develop the reports based on user requirements.
• Scheduled reports in Crystal to generate reports at regular intervals which are used to compare the results at multiple intervals.
• Used TFS as a version control tool to check out and check in the changes to the crystal reports and corresponding stored procedures.
• Worked closely with DBAs and Business Objects Admins to resolve database and crystal related issues.

Environment: SQL Server Management Studio 2005/2008/2012 , Crystal Reports XI/2008, Team Foundation Server 2008, Visual Source Safe and Windows XP/7.

Confidential, Jacksonville, FL

SQL Server Database Administrator

Responsibilities:

• Worked closely with Business Users, discussed and gathered the requirements from different user groups to perform gap analysis, Data Modeling and designing the application.
• Created the conceptual model for the data warehouse and reviewed with the business to make sure that all the requirements are fully covered.
• Created the logical model for the Enterprise Data Warehouse. Data model is divided in number of sub models for the ease of understanding and comprehension.
• Prepared Technical Design Documents.
• Created ER diagram that represent the relation between various dimension and fact tables.
• Created various jobs that load the data from different source systems like BANNER, ATHENA, SALESFORCE, UNISOFT that are residing on Oracle and SQL Server Databases into central Oracle database (IDR).
• Used Talend Integration Suite to load the data from the multiple sources to target database.
• Developed Talend jobs to read/write data to Excel sheets and CSV files to load the data into target tables.
• Developed business models, metadata connections and designed jobs using in Talend Integration Suite.
• Used multiple transformations based on the user requirements before loading the data into target system.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements by using T-SQL.
• Checking Database Health by using DBCC Commands and DMVs.
• Monitored and modified performance using execution plans and index tuning.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.
• Experience in Database security and integrity
• Used log shipping for synchronization of databases.

Environment: Talend Integration Suite Enterprise Edition 4.2.2, SQL Developer 3.0.04, Microsoft SQL Server Management Studio 10.0, Oracle 11g, SQL Server 2008, Tortoise SVN and Windows XP.

Confidential, Charlotte, NC

SQL Server Database Developer

Responsibilities:

• Worked closely with Business Users, discussed and gathered the requirements from different user groups to perform gap analysis, Data Modeling and designing the application.
• Created the conceptual model for the data warehouse and reviewed with the business to make sure that all the requirements are fully covered.
• Created the logical model for the EDW with approximately 50 entities and 1200 attributes. Data model is divided in number of sub models for the ease of understanding and comprehension.
• Created the Requirements Traceability Matrix to trace the business requirements back to logical model.
• Prepared Technical Design Documents including HLD and LLD.
• Followed SDLC Process and Implemented Best Practices in Data Warehousing.
• Created ER diagram that represent the relation between various dimension and fact tables.
• Created various jobs that load the data from different systems like ECRIS, RECRIS, Credit Studio, Ref Data and CTMD that are residing on Teradata, Sybase and SQL Server Databases into Netezza.
• Used Talend MPX to load the data from the multiple sources to target database.
• Developed Talend jobs to read/write data to Excel sheets and CSV files to load the data into target tables.
• Developed business models, metadata connections and designed jobs using in Talend MPX Studio.
• Used context variables in the Talend jobs to load the monthly data based on the value in the context variable.
• Used various components like tMap, tSendMail, tFileDelete, tFleInput, tLogRow etc.
• Scheduled the Talend jobs using Autosys Job Scheduler to load data from source to target systems.
• Created multiple sets of jobs that load data to different environments like Dev, QA, UAT and Prod.
• Used Scheduler that loads the data on timely manner.
• Used multiple transformations based on the user requirements before loading the data into target system.
• Developed code in Netezza that involves various calculations which reduces overhead on the reporting side.
• Created multiple views in Netezza, which are used by Microstrategy team to develop reports.

Environment: Aginity Netezza Workbench 2.1, Teradata SQL Assistant 12.1, Toad for Data Analysts 2.5, Sybase, SQL Server, Talend MPX and Composite Studio 5.2 (Data Virtualization Tool), Tortoise SVN and Windows XP.

Confidential, Jacksonville, FL

Systems Administration

Responsibilities:

• Implemented Rational Quality Manager Tool for Test Management.
• Worked as RQM Tool Administration and mentored users on using the tool.
• Created and maintained SQL Server database as RQM repository.
• Investigating software bugs and reporting to the developers using RQM.
• Performed backend testing using SQL queries.
• Involved in testing Database Stored Procedures and Triggers.
• Created effective test plans to ensure the proper functionality of developed components.
• Involved in conducting User Acceptance Testing.
• Worked closely with cross-functional team members (development, testing, end-users) to understand business and technical requirements to derive the data requirements.
• Conducted Daily Status meeting with Developers and Business Analysts to resolve the issue both technical and business requirements related.
• Worked closely with Business Users, discussed and gathered the requirements from different user groups to perform gap analysis, Data Modeling and designing the application.

Environment: IBM Rational Quality Manager 1.0/2.0, SQL Server 2008, Visual Studio 2008 and WINDOWS XP.

Confidential, Pittsburgh, PA

SQL Server Database Administrator

Responsibilities:

• Responsible for the designing the advanced SQL queries, procedures, cursors, and triggers.
• Created SSIS packages to load data to data warehouse.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Worked as production support specialist and resolved production related issues.
• Created Technical Specs based on functional requirement. Identified the Facts and Dimensions based on the design specification
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys
• Analyzing functional documents and creating Technical Design documents.
• Involved in creating Packages, Procedures, Functions, and Triggers for outbound and inbound interfaces.
• Involved in creation of database objects like Tables, Views, Indexes and Collections.
• Involved in writing of k-shell scripts and setting up the crontab.
• Developed UNIX Shell Scripts to automate the bulk load, update processes and batch processes.
• Generated daily and monthly reports and posted the PDFs to the emails and client sites using Unix Shell Scripts and FTP Voyager.
• Involved in creating complex queries Using joins, sub queries and correlated sub queries.
• Involved in developing DML Scripts for testing purposes.
• Involved in Unit Testing and supported System Testing and UAT.
• Involved in Production Support to support users to resolve production related issues.
• Wrote shell scripts to automate the processes.
• Maintained Integrity and Security, Schema Design, Created & Managed Users, Roles, Permissions, Schema Objects such as Tables, Views, Snapshots and Indexes etc.
• Involved in installation and configuration of SQL server 2000 on Dell Servers. Applied patches and service packs to keep the database at current patch level.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Implemented database standards and naming convention for the database objects.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database.
• Updating with latest service packs and security patches.
• Implementing standby servers and Log shipping.
• Maintain all the SQL documents include installation and data conversion Procedures documents.
• Trouble shooting Problems by using SQL server profiler.

Environment: SQL Server 2005, Visual Studio 2005, SSIS, SSAS, SSRS, SQL* Plus, Oracle 10g, Toad 8.6, AllFusion Harvest Change Manager Workbench 7.1, UltraEdit - 32 v10.10a, FTP Voyager 7.1, Windows XP, Sun Solaris 10 and Shell Scripts.

Confidential, Jacksonville, FL

Data Analyst/Siebel Consultant

Responsibilities:

• Created effective test plans to ensure the proper functionality of developed components.
• Developed Database Scripts, Test Plans, Test Cases based on Use Case Documents to test the functionality of the Application for Quality Assurance.
• Involved in developing the test cases considering both real time positive and negative scenarios that could take place in all the major Smart Scripts involved in the application.
• Participated in discussions with the Administrators to tune the application for desired results to avoid any functional gaps.
• Worked on Various External and Interface Applications like CBPP (Consolidated Billing and Payment Process), Stellent IBPM (Imaging Business Process Management) with WMQI as the middleware adapter tool.
• Monitored the XML message for the Interface Applications using EAS (Enterprise Audit System) Viewer as the monitoring agent tool.
• Creating different types of scenarios to test the CTI functionality.
• Involved in conducting User Acceptance Testing.
• Worked closely with cross-functional team members (development, testing, and end-users) to understand business and technical requirements to derive the data requirements.
• Worked closely with Technical writers and Training Instructors in developing the training material for the Siebel Enhancements. Also involved in coaching and mentoring existing resources.
• Interacting with developers to resolve the technical issues.
• Involved in white box testing.
• Involved in backend testing to ensure data integrity.
• Performed backend testing by writing SQL Queries.
• Involved in developing/testing Database Stored Procedures and Triggers.
• Performed database validation according to the business logic by comparing the source to the target.

Environment: Siebel 7.5.3, Siebel Sales, Siebel Service, IBM DB2 7.0, .Net, ASP, QTP 8.0, QualityCenter 8.2, SQL Navigator, PVCS Version Manager and Rational RequisitePro.