SUMMARY:

• Software professional with 15+ years of experience in different areas such as database administration, analysis, design, development, performance tuning and testing, implementation, and maintenance of application systems including 10+ Years of experience as MS SQL Server DBA, Data and Database Architect.
• Additionally having 7+ Years of experience in Mainframe as System Analyst.
• Experienced in working in Agile and Waterfall SDLC
• Experience in providing and support to both users and developers
• Experience in working with different versions of MS SQL Server including 2014, 2012, 2008
• Experience in complete ETL life cycle including analysis, design, mapping, and data load
• Extensive experience in OLTP & OLAP environments requiring 24x7 production support
• Strong background in software development life cycle (SDLC) process
• Excellent analytical, programming and problem solving skills
• Excellent interpersonal and communication and documentation skills.
• Team player with ability to work independently

TECHNICAL SKILLS:

OS: MS Windows 2012/10/8.1, M

Tools: Red gate, Jira, Idera, Confluence

Software: T - SQL, SSMS, SSIS, SSRS, SSAS, ERWIN, MS Access, MS Visio, MS Office, ODBC, Visual Basic, Visual Source Safe, MS TFS, ASP, VB.NET, ASP.NET, Java script, XML, MS Project, Crystal Reports, MQ Series, IMS DB/DC, Winrunner, Loadrunner, MS Project, UML, Rational rose, Use case diagrams, MS IIS, Visio, Power Point, DB2, CICS, TSO, ISPF/PDF, JCL, QMF, VSAM, MS Office Suite

Hardware: PC, Confidential, UNYSYS, IRIS, DELL, HP

Internet: Web page designing using HTML

PROFESSIONAL EXPERIENCE:

Confidential, Plantation, FL

SQL DBA / System Test Engineer

Responsibilities:

• Worked as a DBA and system test engineer for day to day customer trading information stored in the databases (Daily and History) for different asset types such as Equities, Options, Futures and Forex. Involved on Futures Self Clearing and Global Risk projects
• SQL Server Performance Monitoring, Stored Procedure Tuning, Creating Index for improving performance, Monitoring and analyzing deadlock and blocking situations in databases, promoting SQL server objects to staging, simulation and production environment from QA servers
• Using SQL tools SSMS, Activity Monitor, SQL Profiler and Query Execution plans, creating, testing, implementing and scheduling SSIS packages, Working knowledge of ETL, SSRS and SSAS
• Creating and scheduling SQL server Agent jobs in QA and production servers, analyzing data and log file spaces and resolve space issues, data transfer using SSIS packages from production to QA server for heavy data testing, creating ad hoc reports using T-SQL scripts

Confidential, Ft Lauderdale, FL

SQL server data Architect / Administrator

Responsibilities:

• Worked on the car buyers lead information system to identify the customers who is looking to buy a car, involved in the user meetings for system analysis and design, promoting SQL server objects to production environment from staging servers, creating and scheduling complex DTS packages and scheduling SQL server Agent jobs in development and production servers
• Analyzing database file spaces, transaction file spaces and resolve space issues, SQL Server Performance Monitoring, Stored Procedure Tuning, Creating Index for improving performance, Monitoring and analyzing deadlock situations in databases

Confidential, Jacksonville, FL

Senior SQL DBA

Responsibilities:

• Worked on the direct marketing system projects to distribute advertisements and coupons to customers, Database administration includes database creation, capacity planning, backup and restoring, performance monitoring using various tools, user maintenance and SQL server security monitoring, participates in data modeling and database logical and physical design
• Analyzing database file spaces, transaction file spaces and resolve space issues, SQL Server Performance Monitoring, Stored Procedure Tuning, Creating Index for improving performance, Monitoring and analyzing deadlock situations in databases

Confidential, Little Rock, AR

Senior SQL server DBA

Responsibilities:

• Worked on the Confidential Child care project and participates in application development processes and code reviews of database objects and day to day DBA activities
• Manages logins and user accounts, including assigning database object permissions, ancillary privileges, SQL Server Performance Monitoring, Stored Procedure Tuning, Creating Index for improving performance, Monitoring and analyzing deadlock situations in databases

Confidential, New York, NY

SQL server and mainframe consultant

Responsibilities:

• Involved in the system analysis for performance monitoring and capacity planning for distributed application environments and e-commerce applications in Confidential infrastructure in the process of retrieving information from the Mainframe Data Center using COBOL, DB2, JCL, TSO, ISPF, MQ series into SQL server environment,
• Endevor maintenance projects Supported application production environment for writing all the JCL utilities for LOAD & Unload process. Prepared JCLs for Sequential files, VSAM files, GDG bases, GDG versions, IMS database, UDB, DB2 Tables Unload and Load processes

Confidential, Oakland, CA

System Analyst

Responsibilities:

• Involved in analysis of all I/O modules in scope to determine which modules had to be reconstructed.
• Analyzed and created translation rules for mapping the Legacy fields to Foundation System attributes.
• Designed pseudo-code for translator programs. Involved in coding and unit testing of translators and wrappers

Confidential, Los Angeles, CA

Senior Developer

Responsibilities:

• Involved in the Analysis, Design and Development of the project in various modules like Periodic Reporting (PR), Interfaces, Benefit Issuance, Clear Individual and Management Reporting.
• Developed Power Builder Screens for Periodic Reporting and Interfaces

Confidential, Florida, FL

Programmer Analyst

Responsibilities:

• Developed PL/1 programs with DB2 and VSAM dataset monitors. Wrote SQL queries to prepare QMF reports.
• Exported reports into the datasets using QMF.
• Wrote DDL to setup DB2 objects. Prepared Load control Cards to load VSAM and Filtered files into DB2 table structure