SUMMARY:

• Experience in writing complex SQL queries, procedures, functions, packages, cursors, exception handling, triggers, collections and performance tuning.
• Expertise in Data Base Design, Data ware house, Application Development and Production Support in Client/Server Environment using Oracle 12c, SQL, Data Analyst, Oracle Data Integration, Ab Initio and Cognos.
• Expertise for Attending project meetings and interact with teams, Project managers, team members /associates, business users and internal customer's/ end users, working with multiple tasks.
• Expertise in all stages of Software Development Life Cycle (SDLC) including requirements, Analysis and Design, implementation, integration and testing, deployment and post development maintenance in Agile Methodology.
• Developed MDX queries and Data Mining Expression (DMX) queries for SSAS 2008 and SSRS 2008.
• Expertise in SQL Server 2008 Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS - Data Mining Models and Deploying and processing SSAS objects.
• Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries and DAX expressions, OLAP Cubes and SSAS Tabular Models, and deployment and processing SSAS objects.
• Developed BI data mapping and BI objects (dashboards, reports, analyses, visualizations, metrics, security) design documents using Power BI.
• Experience in understanding different business context, functionality requirements, and data requirements in relation to process and come up with scenarios to validate the flow.
• Prepared ad-hoc business reports and, conducted comprehensive analysis with written summaries providing recommendations to senior executives.
• Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL for Batch Processing using DDL, DML, DCL commands for various business applications and Data warehousing Systems (SSRS, SSIS, SSAS)
• Experience in database programming in writing T-SQL Stored procedures, Triggers, Contraints (Primary Key, Foreign Key, Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Experience in developing SSIS packages to bring data from different databases to data warehouse tables.
• Knowledge of SSIS Including Data flow component, control flow component, SSIS Logging, SSIS Configuration, SSIS Security. SSIS Error handling
• Knowledge in SQL Server database including SQL Queries, joins, functions, trigger, store procedure.
• Worked closely with the analytical team to understand the data integration with the visualization tool Tableau and R programming to create a marketing strategy for targeting the focused customers.
• Performed activities such as Data Collection, Data Cleansing and Transformation, Data Profiling, verifying Data Quality & GAP Analysis.
• Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning.
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL server 2008R2 and 2012.
• Involved in Huge Data Migrations and Data Transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert
• Good knowledge in Tuning SQL queries & improving the performance of the Database.
• Experience in writing expressions in SSRS and Expert in fine-tuning the reports. Created many Drill through and Drill down reports using SSRS.
• Experience in deploying Reports to Report Server. Creating user interface on Report Server for the users to access reports on Report Manager.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in Creating number of cubes, dimensions and critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

PROFESSIONAL EXPERIENCE:

SQL Developer

Confidential, New York,NY

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Used Sub queries, joins, CTE's and Analytical functions for data retrieval.
• Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012/2008.
• Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Creating Reports as per user requirements using MS Reporting Services 2005/2008/2012.
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS 2005/2008
• Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
• Created data driven subscriptions for different users using Report Manager.

SQL developer

Confidential, Washington, DC

Responsibilities:

• Created stored procedures, scripts, views in SQL Server database and SQL server tables, indexes, and views.
• Migrated data from different sources (text based files, Excel spreadsheets, legacy systems and Access) to SQL Server databases using SQL Server Integration Services (SSIS)
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Worked in Agile Methodology to efficiently deliver the project on time
• Maintained the Version, Labeled Versions and Backups of the source using Team Foundation server (TFS)
• Created ad-hoc queries and reports as requested and provided an ongoing analytical support for these requests
• Extensively worked on Deployment, Performance tuning of SSIS packages, data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column, Lookup etc.
• Knowledge in provider module environment in QNXT
• Involved in designing and development of tables, views, user defined functions and complex stored procedures using T-SQL and CTE
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Worked extensively with T-SQL queries, created complex Stored Procedures using T-SQL and called them in SSIS packages
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Responsible for performing SQL tuning, multi-tasking and optimizing long running queries.
• Performed data analysis on daily, weekly, and monthly scheduled data refreshes based on the business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

SQL Developer

Confidential, Oaks, PA

Responsibilities:

• Currently working as a database developer to bridge the gap between the product architecture and detailed designing.
• Analyze the features that are loaded and split them into user stories and work with the product owner to prioritize them.
• Identification of risks, dependencies, cross track impacts and managing them within the agile teams.
• Design, Review and performance test the code to make sure it scales appropriately.
• Working with the Product Owner to identify the opportunities for improvement and add them to the technical debt of the agile team.
• Preparing the High-Level and Low-Level Design documents based on the understanding of the requirements.
• Create test plans for Volume testing of code that is developed in a sprint.
• Creating PL/SQL triggers, sequences, and stored procedures using Toad and SQL Developer.
• Continuous review of Business critical Database to proactively identify space issues, performance tuning issues
• Generated server side PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
• Handled errors using System defined exceptions and User defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Developed Row level and Statement level Triggers for auditing tables in PL/SQL.
• Developed Views and Materialized Views for specific data retrieval for the reports.
• Involved in the continuous enhancements and fixing of production problems.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Developing Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.
• Developed SQL *Loader scripts to load data in the Staging tables.Developed PL/SQL stored procedures, user defined functions for complex calculations and bundle them into a stored package that could be invoked from the Forms triggers.
• Making sure that the new code is written as per the coding conventions.
• Perform unit testing to ensure that the developed or modified code is as per the client requirements.
• Analyzing the RCA and ensuring that preventive measures are takes so as to avoid the bugs coming up in the future releases.
• Attending and co-ordinate with offshore and onshore meetings to discuss the progress of the task assigned and the issue faced.