SUMMARY:

• A team player with broad technical knowledge and creative problem solving.
• Implement and manage projects in the legal, financial and clinical industries.
• Streamline and automate processes and functionalities between users and technologies.
• Conceptualize and design projects using technologies to leverage company profit and growth.
• Lead company to cope with change in technology and strategic problem solver.
• Optimize, preserve, protect, retain, and secure company data from breach and security threats
• Experience in RDBMS,Database scriptings,Data migration, Data integration, physical design, database integrity, data warehousing, normalization, maintenance, performance and tuning,

TECHNICAL SKILLS:

• Business Intelligence SSIS
• SSRS
• SSAS
• MSSQL Server (6.5
• 7.0
• 2000
• 2005
• 2008
• 2012
• 2014)
• Sybase
• Crystal Reports
• Windows 2003
• 2008
• 2012
• Citrix
• IIS
• Office
• Transact SQL
• PL/SQL
• DBArtisan
• ODBC
• OLEDB
• MSDE
• MAS 500
• Sales logix
• Vineyard Knowledge Sync
• Kronos
• Impromptu
• MP2
• Maximo
• BCP
• SFTP
• EDI
• Peregrine(TLW)
• TrueCommerce
• VB.NET
• C#
• DTS
• XML
• RAVE Medidata INFORM
• SAS
• DBMSCOPY
• ERP
• CMMS
• SOX
• HIPPA iManage
• Elite
• Lexis Nexis InterAction CRM
• Ultipro
• Intapp eDiscovery
• Record Management (IRM)
• OpenText
• DMS
• Cloud Technology.

PROFESSIONAL EXPERIENCE:

Confidential

Data warehouse Management, Development and Administration

Responsibilities:

• Support multiple Teradata systems including independent marts, development/uat, disaster recovery, and the enterprise warehouse.
• Manage/Monitor Teradata system performance, including workload management and throttling in Application, query performance and tuning, physical node behavior, and distribution.
• Install and maintain terabyte databases using Microsoft SQL Server, and 2014.
• Implement data mining and cleansing on large historical databases and a dminister database servers of the SDLC, including development, QA and production.
• Support software developers in designing and developing efficient methods of working with databases
• Perform control database security and encryption for auditing
• Develop support highly available database systems, using techniques such as Always on, and log shipping.
• Develop developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Create partitioning for very large database tables and SDLC for retention and retirement.
• Responsible for checking new data for accuracy and removing inaccurate or corrupted data.
• Automate regular analytic reports for executives based on complex data extraction projects.
• Present and train database virtualization new technology for data mining and data warehousing to management and technical team.
• Articulate project goals and scope, translated business needs into technical terms and documents, prepared detailed work breakdown structures (WBS) and instilled shared accountability for achieving project milestones.

Senior Consultant

Responsibilities:

• Provide planning, solution and development to consolidate and integrate customer Tera data for cloud technology.
• Develop planning for data cleansing and remove duplication and incompatible data to achieve clean and accurate data.
• Create design documents and collaborate with customers and internal team members to develop analytical solutions.
• Plan and configure to help customer data servers for better performance, processes, and secure environment. Identify customer’s business objectives, processes, technology stacks, and important data assets.
• Work with customers to provide workflow in their industry for efficiency and better rates and revenues.

Database Management in Administrating, Developing, Integration, and Planning

Responsibilities:

• Manage and resolve design issues during development stage.
• Automate & Integrate Ultipro data into Elite and ChromeRiver financial systems.
• Maintains organization's effectiveness and efficiency by defining, delivering, and supporting strategic plans for implementing information technologies.
• Completes projects by coordinating resources and timetables with user departments and data center.
• Verifies application results by conducting system audits of technologies implemented.
• Preserves assets by implementing disaster recovery and back - up procedures and information security and control structures.
• Recommends information technology strategies, policies, and procedures by evaluating organization outcomes; identifying problems; evaluating trends; anticipating requirements.
• Implement information technology strategies, procedures, and policies and identify business needs for marketing and accounting departments.
• Plan and Create automate job for data integration and for analytic reporting.
• Plan and Create company SQL 2012 Always On Available for Disaster Recovery.
• Plan and Create Performance tuning by running SQL profiler, tracert and reorg, reindex, and update statistics.
• Administration and development for MSSQL 2005, 2008, 2012 servers.
• Plan and Create Monitor server disk space, monitoring logs, ensuring jobs have run successfully, checking for errors in consolidated report format.

Sr. Data Conversion Consultant / Data Warehouse Development

Responsibilities:

• Provide tereadata database and table design, implementation and integration for data warehouse and using SSIS ETL.
• Implement Reporting Analysis by integrating with vendors and clients using ETL architecture.
• Develop entire software development life cycle across numerous software and hardware platforms in a various industries.
• Create Planning, design, development, Implementation, and Analysis of data warehouse, ETL, client/server, and mainframe transactional applications.
• Apply development lifecycle methodologies for Structured and iterative data warehouse.
• Configure production and development for MSSQL 2005, 2008, 2012 database administration disaster recovery.

Database Administration, Management, Planning, Development, and Integration

Responsibilities:

• Manage integration team both on site and off site spread across the globe. Categorized of DB Administration, Application, Operation, Production, Change Management, NOC, On-call support and performance optimization.
• Plan and implement Disaster recovery for SQL servers including Database Mirroring and Log shipping.
• Implement SQL security NT and SQL mixed mode for internal users and plan and test upgrade for MSSQL 2000, 2005, and 2008 Servers.
• Reviewing time of the projects and identified risks related to the project.
• Create and applied training programs for internal employees.
• Process, review, and query clinical trial data integrate into Oracle Clinical database or an Electronic Data Capture (EDC) System
• Planning, constructing, testing and maintenance of databases with GCP and GDP.
• Developed SDLC for Clinical Data and the process is compliance to SOX.
• Configure ETL Clinical Data for Phase Forward INFORM, RAVE Medidata, CTMS, Fisher Medrio, and OCRDC system.
• Transform Clinical Data using ANSI-SQL, XML, Active X and VB Script, C#, SAS.
• DBCC, Performance and Tuning MSSQL 2000 and 2005, and 2008 servers using SQL profiler, showplan, and index wizard.
• Use DTS and SSIS Local packages for exporting and importing data to EDC.
• Create store procedures, views, and triggers for Data migrations and reporting’s.
• Plan and create batch scripts to automate jobs.
• Working on testing of Clinical database, queries optimization and performance.

Database Administration and Report Development

Responsibilities:

• Created Stored procedures, views, triggers for replication.
• Created Financial & Inventory & EMR Reporting using Crystal Report and Reporting services.
• Performed and tuned Sybase SQL Anywhere servers.
• Troubleshot errors, deadlocks, and queries.
• Created Financial & Inventory & EMR Reporting using Crystal Report and Reporting services.
• Proven experience of Planning, Design, Implementation, Performance tuning, and Maintenance.
• Proven experience of DBA Activities (Backup & Recovery planning, Mirroring, Replication, SQL Agent Jobs etc.)

DBA /Data Center Manager

Responsibilities:

• Hired, trained and supervised a 4 member team providing Data Center operations and Development support.
• Planned and managed to team members of 3 to perform upgrades from SQL 2000 to SQL 2005.
• Planned and managed to team members Installed SQL 2005 on a Win 2003 platform.
• Managed Data flow from remote sites and used Management Studio for Admin.
• Direct team members to perform and tune MSSQL 2000 and 2005 servers.
• Managed a team to monitor database growth by automating the process.
• Planned and outlined the team of maintenance Plans for Reorg, Reindex, and DBCC options.
• Ensured the database was compliant to SOX.
• Planned with the team to create Integration Services and Local packages for exporting and importing data.

DBA /Network Manager

Responsibilities:

• Managed a group of team members to perform migration on SQL 2000 from Win 2000 to Win2003 server.
• Managed a group of team members to perform Installed and Configure MSSQL 7.0, SQL 2000 on Win 2000 & Win2003.
• Report to CFO to layout Financial & Inventory Reporting using Crystal Report.
• Directed team members develop standard for created Stored procedures, views, and triggers to customize report and MAS 500 application.
• Managed a team for Database configured Memory, locks, cache Management, and Parallel Processing.
• Managed a team for performed and tuned by binding the large tables, indexes and tempdb to the memory.
• Report to CIO of the day to day hardware and software conditions for proactive decision making.

DBA/Network Administrator

Responsibilities:

• Configuration and implementation of MSSQL 6.5, MSSQL 7.0, MSSQL 2000, Sybase and Oracle on both LAN and WAN.
• Administered Kronos application and extracted employee payroll and timesheet data for reporting purposes.
• Performed database disaster recovery on MSSQL 6.5 & 7.0, 2000 by restoring the master and msdb database backups and reconfigure the server for the appropriate network libraries and security mode.
• Troubleshot SQL client connectivity, TCP/IP packet transfer, communication failure, and slow queries over WAN by using NETIQ, HP OPENVIEW, and WINDOWS NETWORK MONITOR.
• Database migration from Mainframe database & Text file to MSSQL 7.0 on Windows NT & 2000 platform including using TS\SQL, DTS, local packages, FTP, bcp, and DBartisan.
• Implement security SQLDMOSecurity Mixed mode to authenticate Windows NT, Windows 2000, and MSSQL users and groups.
• Completed MSSQL 6.5 & MSSQL 7.0 Administration, Performance and Tuning courses
• Performance and Tuning including filegroups, cache management, DBCC, reindexing, APF, parallel processing.
• Implemented physical design by Creating, Normalizing the tables by enforcing rules, defaults, indexes, and locking scheme.
• Used showplan to optimize stored procedures and triggers for performance purposes.
• Scheduled DBCC, reinidexing, and Backup Maintenance plan to monitor daily database backup and database performance.
• Upgraded MSSQL 6.5 & MSSQL 7.0 to SQL 2000 by using upgrade wizard.
• Resource allocation planning, DSS and implement OLAP, logical process manager, Database Change Control and create security.
• Troubleshot long queries, deadlocks, rollback transactions, and connectivity problems using SQLProfiler.

Senior Research Analysts (DBA)

Responsibilities:

• Integrated Windows2000, NT, Win98, Win95, and with MSSQL (6.5 & 7.0) and Access.
• Wrote TS\SQL scripts for MSSQL 6.5 and 7.0 servers.
• Troubleshot and MSSQL7.0 server performances and scheduled Maintenance backup.
• Data Conversion and import queries in Paradox, Microsoft Access, MSSQL.
• Trained and consulted CMMS and EAM (MP2) software for customers in an Enterprise environment.
• Implemented Web link, Data procedures that integrates with IIS 4.0.
• Troubleshot installation failures and repair ODBC in Windows 2000, Windows NT, Windows98, MSSQL, Oracle and IIS.