SUMMARY:

• 10 + years of Information Technology experience working for variety of clients in various industries including, Retail, Finance, Government Insurance, and education
• Experience in analysis, design, development, testing and implementation of application software as SQL Server (T - SQL) and Oracle ( PL/SQL) Developer .
• Involved in Analysis, Design, Development, Testing of Decision support systems with major focus on Database and Data Warehousing Applications.
• Participated in full Software Development Life Cycle (SDLC) of the business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users
• Expertise in T-SQL and PL/SQL programming and strong knowledge on SQL Server, Oracle architecture and database design.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL, Oracle, Stored Procedures, Functions, Packages, Triggers, and scripting languages.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
• Experience in Designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema in implementing decision Support Systems. Ability to quickly stage & shape data from data warehouses into reporting and analytics solutions.
• Created custom specific and efficient SQL server Reports using SSRS.
• Hands on experience in reporting tools like SQL Server Reporting Services (SSRS), Crystal Reports.
• Strong knowledge of Data modeling, data warehousing concepts, methodologies and architecture
• Proactively worked in diagnosing, researching, monitoring of SQL and database-related faults and performance problems
• Talk with clients and discuss ideas, to obtain a clear perception of their business and functional requirements
• Requirements gathering & analysis, Problem solving skills, Ability to handle large projects
• Self-motivation, result orientated attitude, Innovative thinking Ability to work to deadlines
• Worked on advanced PL/SQL constructs like Oracle supplied packages , Dynamic SQL, Analytical functions, PL/SQL Collections
• Strong experience in designing and developing Oracle objects Tables, Views, Indexes, PL/SQL Stored Procedures, Functions, Packages, Triggers and fine tuning them.
• Good Knowledge of various data design models, Entity-Relationship (ER), Multi-Dimensional/ Star Schema and Extended Star Schema Models
• Strong experience in Microsoft office tools, Excel, Project and Word
• Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
• Exceptional problem solving, Analytical and team skills Experience in Working with business users to optimize information usage
• Good working experience on OLAP and CUBES building and maintenance.
• Good experience in utilizing version control systems like SVN and Git for project development.
• Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes and materialized views and managing database.
• Extensive knowledge in designing Oracle forms and reports using Oracle Developer .
• Strong knowledge in Oracle Cursor Management, Exceptional Handling
• Good Understanding of Oracle Data Dictionary, RDBMS, Normalization Techniques.
• Proficient and Designed numerous Oracle Forms and SSRS Reports by interaction directly with End Users and Business Analyst.
• Expertise in using tools such as TOAD, SQL* Plus, SQL* Loader, PL/SQL Developer .
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Expertise in creating and optimizing T-SQL store procedures using indexes, UDFs, joins, error handling Views as well as with use of execution plan, SQL profiler and DTA.
• Good knowledge in Performance tuning, SQL Tuning, Data optimization, query optimization, job scheduling.

TECHNICAL SKILLS:

Database: Oracle 11g/10g, SQL Server 2016 & 2014 (design, development & Testing), DB2, Teradata

Programming: SQL, PL/SQL, T-SQL, ASP.Net, VB.Net, HTML, XML Web Services, Java, SOA (Service Oriented Architecture)

Other Tools: BIDS, Visual Source Safe, TFS, Sub version, Project, OLTP, OLAP

Business Intelligence Tools: SQL Server Integration Services (SSIS), Reporting Service (SSRS) and Analytical services(SSAS) 2008, 2012, 2014 & 2016 and Teradata

OS: Windows 2000, XP, 2003, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr Database Developer(T-SQL/SSIS/SSRS/SSAS/PL&SQL)

• Extensively worked to build Logical views on ICBS Reporting schema (Oracle Database) to access data from both current and archived ICBS Database.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
• Developed various reports in SSRS like drill down Reports, Canned Reports, parameterized reports based on the business requirement.
• Designed and developed logical views in Oracle Database to get access in SSRS reports based on business requirements
• Utilized SCRUM methodology for all Projects development and enhancements.
• Developed OLAP Cube’s for Datawarehouse project and written several MDX queries and expressions for report requirements
• Involved in design, development and testing of numerous SSRS reports based on the business demands and experienced in deploying the reports securely in SharePoint environment for secure access.
• Design and development of PL/SQL programs (stored procedures, cursors etc.) for migration of historical ICBS Data into a single ORACLE Database.
• Interacting with Business Users, SME’s, IT Lead and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specification
• Responsible for the detail design documentation, development, unit testing and maintenance of internally developed applications.
• Created and maintained different constraints on database and developed triggers to maintain database integrity.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Performed T-SQL query optimization and tuning tasks to enhance performance in daily data processes of large external and internal data files and data tables.
• Developed and tuned Stored Procedures for optimum performance that are used in the daily data processing.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.
• Experienced in tracking Project Status, Publishing Status Reports, Managing Scope, Time and Cost.

Environment: Oracle 11g, SQL Server2016,2012,2008, MS SQL Server Integration services, MS SQL Server Reporting Services, MS Access 2007, MS SQL Query analyzer, Oracle PL/SQL, Visual Studio 2012, OLAP,CUBE,MDX

Confidential, IN

Sr Report Developer(SSIS/SSRS)

• Extensively worked in developing implementing ETL Packages and SSRS reports using SSIS & SSRS 2014/2012.
• Used Cursors both implicit and explicit to capture many rows within a PL/SQL block and applied business rules on them.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Analyze and resolve data load (ETL) issues from different data sources
• Maintain and support SQL Server database server and hosting - monitor SQL Server connectivity and performance, user session timeouts, load time.
• Created Teradata Store procedures and functions to conform the data and load it on the table.
• Involved Performance tuning, bug fixing and error handling. Used SQL Assistant to querying Teradata tables.
• Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.
• Daily or frequent editing, formatting, calculations, functions, sorting, filtering, VBA, & other misc. within Excel.
• Extensively worked on PL/SQL features like Forms, Triggers, Data blocks, Report Layout, Parameter Forms, and Report Triggers.
• Daily or frequent use of Microsoft Office programs including Excel, Word, PowerPoint, Outlook, SharePoint, & Access

Environment: Oracle 11g, SQL Server2014,2012, 2008, MS SQL Server Integration services, MS SQL Server Reporting Services, MS Access 2007, MS SQL Query analyzer, OLAP,CUBE,MDX, PeopleSoft Financials, Oracle PL/SQL, Visual Studio 2008

Confidential, IN

Sr Data Analyst /Report Developer

• created backend database processes and scheduled those using tidal software scheduler in UNIX environment developed Fast load and multi load scripts to upload data from various data sources to Teradata database for reporting needs
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS service
• Maintained strong customer focus by responding quickly and considered their needs when resolving problems.
• Understanding the business requirement and providing the appropriate reporting technical solution on Teradata data and Access databases
• Experience in writing complex SQL and PL/SQL programs to bring business logic close to data.
• Always went above and beyond job requirements in order to achieve objectives.
• Created stored procedure and required database objects for generating reports for data analysis purpose

Environment: Oracle 11g, SQL Server2005, 2008, MS SQL Server Integration services, MS SQL Server Reporting Services, MS Access 2007, MS SQL Query analyzer, PeopleSoft Financials, Oracle PL/SQL, Visual Studio 2008

Confidential, IN

BI Developer (T-SQL, SSRS and SSIS)

• Experienced in development of VB.Net and ASP.net for enhancement and development of SWIMSS web applications
• Identifying and managing data quality issues
• Development of new SSRS printable reports for TB-Applications users.
• Build SSIS Master and child packages using SSIS configurations and SQL &T-Sql Scripts and VB.net for initial load of data for reporting needs.
• Fixed issues in the existing PL/SQL programs.
• Written and deployed web services using java and.Net technologies in web applications.
• Run/edit/troubleshoot/design VBA Macros daily/weekly/monthly/quarterly/ and on-demand as needed. Most Macros were within Microsoft Access and Excel.
• Worked as a technical expert and reporting analyst in the design, development, and modification and debugging of SSRS Reports and creating new reports based on new requirements as a Teradata data source

Environment: Oracle 11g, SQL Server2005, 2008, MS SQL Server Integration services, MS SQL Server Reporting Services, MS Access 2007, MS SQL Query Analyzer, Visual Studio 2008, Java, SQL Profiler

Confidential, IN

Sr Datawarehouse Developer

• Developed T-SQL scripts, stored procedures, SSRS reports, user defined functions, views and triggers for business logic implementation
• Experience in administrating the developed packages, created reports and assigning permission to the valid users for executing the reports.
• Experience in writing VB scripts for user defined functions in SSRS.
• Worked with Business Analysts and Users to understand the requirement then providing the appropriate technical solutions
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2012 database and performed tuning and audit analysis on it.Migrated database from SQL server 2008 R2 to SQL server 2012 using utilities i.e. exporting/importing and attach/detach for SQL servers 2012 features.

Environment: Oracle 11g, SQL Server2005, 2008, MS SQL Server Integration services, MS SQL Server Reporting Services, MS Access 2007, MS SQL Query analyzer, PeopleSoft Financials, Oracle, Visual Studio 2008

Confidential, TX

Datawarehouse Developer (T-SQL/SSIS/SSRS)

• Developed T-SQL scripts, stored procedures, SSRS reports, user defined functions, views and triggers for business logic implementation
• Experience in administrating the developed packages, created reports and assigning permission to the valid users for executing the reports.
• Experience in writing VB scripts for user defined functions in SSRS.
• Worked with Business Analysts and Users to understand the requirement then providing the appropriate technical solutions
• Worked on normalization/de-normalization techniques for optimum performance in relational and dimensional database environments
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints

Environment: Oracle 10g SQL Server 2008,2012, MS SQL Server Integration services, MS SQL Server Analysis Services, MS SQL Server Reporting Services, MS Access 2003, MS SQL Query Analyzer, SQL Profiler

Confidential, IN

Database Developer

• Experienced in development of PL/SQL programs, stored procedures, user defined functions, views and triggers for business logic implementation
• Converted Business Systems Document (BSD) into to appropriate Technical Design documents
• ETL implementation using SQL Server 2008 Integration Services (SSIS)
• Experienced in development of T-SQL scripts, SSIS Packages, stored procedures, user defined functions, views and triggers for business logic implementation
• Successfully migrated from SQL Server including numerous DTS packages to SSIS.
• Implementing reconciliation processes, and identifying and resolving inconsistencies
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS service

Environment: Oracle 10g, SQL Server 2005, 2008, MS SQL Server Integration services, MS SQL Server Analysis Services, MS SQL Server Reporting Services, MS Access 2003, MS SQL Query Analyzer, SQL Profiler