SUMMARY:

• Over 19+ years of experience in delivering cost effective, high performance data - driven solutions to meet challenging business demands.
• Application on call and production support for various backend Reports/Modules and functionalities.
• Accomplished Business Intelligence / Enterprise Datawarehouse Professional with strong design, development and architecture skills.
• Expert in Writing SQL Working with SSIS, Data Cleansing, Data Scrubbing and Data Migration.
• Experienced in Analysis, Design, Development, Implementation, Testing and maintenance of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP, OLTP client /server applications.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8.x/9.x/10.3x.
• Extensive qualifications in all areas of information systems from design through documentation, implementation, user training, quality review, and enhancement.
• Key areas of expertise include Business Intelligence, Billing, Marketing, Sales applications.
• A motivated BI specialist with strong inter-personal, organizational, writing and communication skills.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

TECHNICAL SKILLS:

BI Tools: Tableau, Informatica, BO, MicroStrategy, SSRS, Data StageTools Toad, Visual Studio, Teradata SQL Assistant, Query Analyzer.

Data Modeling: Erwin, Rational Rose, Microsoft Visio

Languages: SQL, PL/SQL, C, C++, Java, J2EE, VB.Net, VB 6.0, ASP Net

Databases: Hive, Oracle, SQL Server, HP Vertica, Teradata, MS Access

WORK EXPERIENCE:

Confidential, Dallas, TX

Sr Developer

Responsibilities:

• Worked with SQL (Packages, functions, procedures, triggers, Materialized Views) and other related objects.
• Performed functions including SQL tuning, Database Application Design and Developer Support.
• Worked with Analytical Functions and complex queries for business requirements.
• Built and enhanced all objects packages/functions in SQL to support application process.
• Implementing Best Practices in SQL such as usage of Table hints, Index approach, Joins Vs Sub Query
• Performance Tuning of SQL queries to keep data loads within SLA (Execution plans, tuning Advisor, Index Usage, SQL coding standards, I/O Usage Bottlenecks, CP Time, Memory usage, Performance counters etc.).
• Created Stored Procedures to build Fact tables in data mart for Multi-Dimensional Analysis
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Analyzed requirements for various reports, dashboards and created the same using Tableau10.1.
• Created Tableau Dashboards using Stack bars, Bar graphs, scattered plots, Geographical maps Gantt charts using show me functionality.

Environment: SQL, PL/SQL, SSRS, Tableau10.1, Teradata, Business Objects XI, Toad, SQL Assistant, UNIX

Confidential, Dallas, TX

Lead Developer

Responsibilities:

• Applying Constraints and Writing Triggers to apply the business Rules
• Participated in creating or updating tables, Columns, Triggers and Writing SQL
• Responsible for optimization & Tuning Complex SQL queries.
• Optimized performance of queries with modification in SQL queries, Removes, Unnecessary columns, eliminated, redundant and inconsistent data, Normalized tables, established joins and created indexes to assimilate client information from multiple developers
• Determined critical customer needs, performed technical designing, code reviews and documented process Confidential every step; delivered code base and provided KT to the Support Team
• Re-design Informatica and Teradata applications for Vertica.
• Perform data validation, monitoring performance tuning activities using customized projections and partitioning techniques
• Prepared conceptual/logical, physical data models and performed reverse and forward engineering.

Environment: SQL, Toad, SQL Assistant, UNIX, Composite, Teradata, Business Objects XI

Confidential, Dallas, TX

Sr Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications
• Involved in designing, testing disaster recovery model & implementation
• Enhanced database structures as per the business requirement which is applicable for Contract Accounting Maintenance in an efficient way.
• Developed and maintained data, procedures and performed Data Impact Analysis
• Wrote optimized SQL queries to access source data from RDBMS and provided reports according to the requirements.
• Wrote and modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
• Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Coordinated and assisted with the Front-End Developers in handling & solving bugs.

Environment: SQL, Enterprise manager, Windows NT, XML, DTS

Confidential, Dallas, TX

Developer/Analyst

Responsibilities:

• Wrote stored PL/SQL Procedures for reports.
• Constructing private and public PL/SQL packages.
• Developed PL/SQL scripts for data processing.
• Developed Pl/SQL stored procedures for ad-hoc reports.
• To estimate the performance of Oracle Database During SQL Design
• Created the PL/SQL scripts for production database, estimating the space requirements.
• Tuning of the SQL statements for application developers.

Environment: Oracle, Pl/SQL, UNIX sun Solaris, TOAD

Confidential

Developer/Analyst

Responsibilities:

• Involved in major re-write of the existing codes for the project, creating new procedures.
• Developed Oracle Stored Procedures, Triggers and Packages.
• Tuning of databases, applications & Tuning of the SQL statements for application developers.
• Developed PL/SQL scripts for data processing.
• Prepared unit test scripts and conducting unit tests and debugging using the PL/SQL debugger Wrote PL/SQL scripts for loading tables and debugging PL/SQL programs
• Wrote stored PL/SQL Procedures for reports.

Environment: Oracle, Oracle developer, Pl/SQL, UNIX sun Solaris, TOAD