CAREER OBJECTIVE:

A hands - on SQL Data Analyst with a proven track record of data analysis, reporting, leadership and technical skills seeking a challenging role for professional growth.

SUMMARY:

• 9+ years of expertise in executing IT projects in various stages of SDLC including project scoping
• Expert in writing SQL queries and developing Database Objects, Triggers, stored procedures, Functions and Views.
• Created complex data migration and transformation tasks using scripts.
• Trained and mentored new recruits on proprietary datastore, thereby reduced on boarding time by 25%
• Key participant in review of business, functional requirements, impact analysis activities.
• Owned the design, development of metrics, dashboards, that drove key drive key business decisions
• Developed extensive metrics and collaborated with multiple internal teams securing business approvals.
• Experienced in Unix shell scripting.
• Instrumental in migration of customer assets from Tiscali B2C to Confidential (Talk Talk).
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors using SQL and PL SQL.
• Expertise in managing project versions and source code changes using source control tools like visual source safe, team foundation server and TortoiseSVN.
• Expert in Water Fall, Agile
• Expert in Manual and Unit testing
• Expertise in analysis of SQL code, tuning and developing procedures to improve efficiency
• Expert in TOAD

TECHNICAL SKILLS:

Databases: ORACLE, MS SQL Server,My SQL

Platforms: Windows/UNIX

Technologies: HTML, CSS, JavaScript, SQL, PLSQL, XML, Salesforce Knowledge

Tools: Remedy, Accurate ( Confidential internal tool), JIRA, TOAD, MS Word,MS Office,MS Excel,MS Access

Operating System: Windows 9x/NT/XP/Vista/2003/2000, Mac.

BI Tools: Tableau Knowledge

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Sr.SQL Developer

Environment: Oracle, Unix, SQL, PL/SQL, MS-Access, MS-Excel

Responsibilities:

• Monitoring applications to avoid critical issues.
• Independently handled multiple critical modules requiring hands on technical and business understanding.
• Improved agency cash flow substantially by bringing process improvement in billing and collections.
• Reported defects identified during testing in the tracking system and followed them through to closure.
• Provided operational visibility to senior management by building analytics dashboards.
• Used Joins, correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented functions, views, triggers, stored procedures and enforced business rules via checks and constraints
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Analyzing and Resolving incident tickets.
• Involved in Scheduling the Reports to run on daily and weekly basis in Report Manager
• Implemented Pager options to inform corresponding DBA basis on each Job Status.
• Define db scripts versioning system to keep track of database versions for all environments

Confidential, Pittsburgh, PA

Sr.SQL Developer

Environment: Oracle, Unix, SQL, PL/SQL, MS-Access, MS-Excel

Responsibilities:

• Developed reports summarizing business performance to evaluate the effectiveness of our existing products, measure progress toward goals and identified areas of improvement.
• Assisted in the scoping, development, and evaluation of new product features and business initiatives
• Conducting knowledge sharing sessions with team members, and mentored new recruits
• Proactively monitored the database systems to ensure secure services with minimum downtime and responsible to meet the SLA’s.
• Supported and implemented technology projects as the primary database analyst in support of business initiatives
• Performed database installs and upgrades, performance tuning, analyzed performance issues, setup of user access, backup and recovery.
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Superior communication, presentation, analytical and problem-solving skill. Worked well with all levels of business.

Confidential

SQL/Report Developer

Environment: Oracle, Unix, SQL, PL/SQL, MS-Access, MS-Excel

Responsibilities:

• Created groups, roles, users and assigning access privileges to users.
• Created user defined data types and added them to model database for future purpose.
• Created stored procedures, implemented referential integrity by using triggers.
• Demonstrated ability to define business KPIs and drove initiatives to establish measurement frameworks
• Solved and raised relevant fault tickets using Remedy application.
• Generated Reports on a weekly daily that provide valuable insight to Operations.
• Exported and imported data from text files and Excel to Oracle database using bulk copy insert and BCP utility.
• Provided on - call support

Confidential

SQL/Report Developer

Environment: Oracle,SQL,MS Excel

Responsibilities:

• Created ad-hoc reports to support timely business decisions, service evaluation.
• Lead the design and development of actionable metrics and reports across a cross-functional team of stakeholders
• Involved in Scheduling the Reports to run on daily and weekly basis in Report Manager
• Hand on experience in maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.
• Experience in Design and Architecture of an Enterprises Data Warehouse.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources like SQL Server using SSIS.
• Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows for better performance.
• Monitored Oracle Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Created necessary templates for various requirements gathering and documentation.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.

Confidential

SQL/Report Developer

Environment: Unix/Oracle

Responsibilities:

• Resolving different issues raised by clients.
• Monitoring applications to avoid critical issues.
• Monitoring daily jobs and taking necessary actions in case of failures/issues.
• Analyzing and Resolving incident tickets.
• Maintaining SLAs of incident tickets.
• Implementation and co-ordination in releases.

Confidential

SQL Developer

Environment: MySQL, Toad, SQL,PLSQL,HTML,CSS

Responsibilities:

• Worked closely with operations and business team for requirements gathering and implementation
• Validated the system design and participated in the vendor evaluation activity
• Contributed to the development of high-quality, accurate and compelling project reports
• Proposed and prioritized changes to reporting by creating additional metrics & processes based on business needs
• Requested refreshes pre or post restore activities (e.g. data loads).
• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
• Performed day-to-day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
• Scheduled and managed jobs on MS SQL Server and manage database security with respect to User access, roles and privileges.
• Designed database schema structures, procedures, triggers to enhance the revenue critical systems
• Developed integration, system test plans for the entire system encompassing various critical functional modules.
• Played a pivotal role in design of the database lookup tables that encompassed several stringent Industry norms. key member of the team responsible for accounting module involving financially critical billing and invoice data.
• Understood core systems like: CRM, Billing, Point of Sale, Mediation, and Interconnect
• Created stored procedures and triggers for Data consistency.
• Participate in implementation of new releases into production.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Used Stored Procedures developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.