PROFESSIONAL SUMMARY:

• Having 7+ years of IT Experience in Microsoft SQL Server 2005/2008/2008 R2/2012/2014, T - SQL,SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS), MS-Access, Excel and VBA in database and applications development and report design and development.
• Experience as an Oracle PL/SQL Developer with Proficiency in Oracle 10g/9i/8i, SQL, Oracle PL/SQL, Oracle Form Builder 10g/9i/6i, Report Builder 10g/9i/6i, C, Java, UNIX Shell Scripting.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Experience asAnalysis Services Cube Developer (OLAP)andReport Developer (SSRS).
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R 2/2012/2014.
• Experience in Managing Security of SQL Server 2008/2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Good experience and understanding of database design, relational integrity constraints.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Experience designing and implementing fast and efficient data acquisition using Big Data processing techniques and tools
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Experience in conversion of packages from legacy systems (DTSàSSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Created various INetsoft reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS:

Operating systems: Windows 98/NT/2000/XP/Vista/Windows7/8

Databases: MS SQL Server 2000/ 2005/2008/2012, MS Access, Big Data.

Database Tools: SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), OLAP cubes.

ETL Tools: DTS, SQL Server Integration Services, SQL Server Analysis

Reporting Tools: INetsoft Reporting services

Development Skills: Transact SQL (T-SQL), PL/SQL, Stored Procedures, Triggers

Application Packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, Lubbock, TX

Sr. SQL BI Developer

Responsibilities:

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2012.
• Served as SME for designing, developing, and delivering high performing Microsoft SQL Server Analysis Services (2008) OLAP cubes using industry best practices.
• Designed and developed Big Data analytics platform for processing customer viewing ps andsocial media comments using Java, Hadoop, Hive and Pig.
• Provided backend support for Time-Forge hospitality clients. Generated reports using Javascript & INetsoft reporting BI tool to provide support forecast for clients monthly sales.
• Published reports to the online databases from Linux CentOS environment & Caspio tool.
• Performance monitored & optimized most expensive PostgresSQL queries using SQL coding best practices.
• SQL ServerMigration and upgradefrom SQL Server R2,SQLserver 2008R2 toSQL Server 2012,SQL server 2012toSQL Server 2014.
• Created SQL injections for facilitating GUI parameters and generate sales reports
• Provided user and production support.
• Developed SSIS packages for migrating data from staging area of SQL Server 2005 to SQL Server 2008R2 and SQL Server 2008 R2 toSSIS2012.
• Installed and administered Microsoft SQL Server Integration Services, SQL Server Reporting Services, and TFS.
• Creation, maintenance of PL/SQL packages and procedures including the user of:CURSORS, Loops, IF-THEN, Error Handling, DBMS OUTPUT, BULK COLLECT
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.

Environment: Windows 2008, IIS, SQL Server 2014, MS SQL Server 2005/2008/2012, T-SQL, Office, Visual Studio, Database Engine Tuning Advisor, Big Data, OLAP cubes, SQL Server Management Studio, SSIS, SSRS, SSAS.

Confidential, Bothell, WA

Sr. SQL BI Developer

Responsibilities:

• Created tables with Cluster/Non-Cluster Index, Stored Procedures, and Triggers; programmed and designed reports off transactional databases
• Monitored performance and optimized SQL queries; and created and modified T-SQL stored procedures.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions
• Scheduled batch jobs; ran daily SSRS reports
• Designed Reports that had complex SQL, PL/SQL code and stored procedures using Reports 10g.
• Tracked and resolved issues of JIRA Issue Tracking System application with multiple features and capability like data upload, work flow, various reports, dashboards and filters that enable to get data for required criteria.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Designed Forms that had complex stored procedures and PL/SQL code using Forms 10g and did some personalizations.
• Tuned PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Exporting and Importing the data into the database as and when user provided the data and do analysis.
• Configuring SSIS packages using package configuration wizard to allow packages run on different environments.
• Developed and Maintained MS Access Database.
• Created views, SQL joins DTS packages and statements for applications
• Develop SSIS packages to load the data into data marts.
• Extensively using SSIS for Transformations, Aggregations and Lookups.

Environment: SQL Server 2005/2008/2012, T-SQL, Windows XP, Visual Studio, Report Builder, SQL Profiler, SSIS, SSRS, SSAS.

Confidential, Canton, Michigan

SQL BI Developer

Responsibilities:

• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Created OLAP Cube from Staging Database Tables using SQL Server Agent.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
• Extensively involved in data migration.
• Used UTL FILE built-in package to generate files as per the requirement.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

Environment: SQL Server 2008R2/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), XML, MS Visual Source Safe and Windows Server 2003

Confidential, Tampa, FL

SQL BI Developer

Responsibilities:

• Importing Source/Target tables from the respective databases by using Execute Package Task using Control Tasks in SQL Server 2005 Integration services
• Created Event Handlers for the Packages Using Event Handler Tab.
• Used various Control flow items for each loop, for loop and Data Flow transformations data conversion, conditional split, multicast, derived column, lookup, sort, union all, Merge, Merge join etc.
• Implemented check point configuration, package configuration in packages for better reusability.
• Involved in creation of the package and was responsible for moving the package from development server to production server.
• Implemented Performance Tuning at various levels.
• Experience in Deploying and scheduling the Packages.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• As per the requirements develop the reports in the form of Table, Matrix, and Chart using Sql Server 2008 reporting services.
• Adding parameters and filters while building advanced reports.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• As per the requirements, rendering the reports in the form of PDF, XML and CSV formats.
• Primarily responsible for developing applications in SSIS as per Business Rules and features of the tool.
• Implemented check point configuration, package configuration in packages for better reusability.
• Scheduled the ETL Package (Monthly) Using SQL Server 2005 Management Studio.

Environment: T-SQL, SSIS, SSRS, SQL Server and Microsoft Visual Studio, OLTP, ETL, XML, Windows XP.

Confidential

SQL Android Programmer

Responsibilities:

• Provided backend support for customer complaints municipality database.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Developed SSIS packages with various tasks like - FTP, file system, for-each-loop, execute package, data flow task, executeSQLtask, custom script task, analysis services task, data mining task.
• Database Maintenance, Replication, Tuning, System Database Migrations and Maintenance
• Perform database administration tasks including; Installation, Configuration, Upgrades, Capacity Planning, Performance Tuning, Backup and Recovery.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Identified and worked with Parameters (e.g. cascading parameters) for parameterized reports in SSRS.
• Create Stored Procedures, Triggers, Tables and Indexes for MSSQL 2005
• Perform database maintenance tasks which includes Rebuilding and Reorganizing Indexes, Updating Statistics as well as running Integrity Checks (DBCC)
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Developed various T-SQL stored procedures, triggers based on the requirement.
• Defined Check constraints, Business Rules, Indexes and Views.
• Involved in tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: T-SQL, SSIS, SSRS, SSAS, ODS, SQL Server and Microsoft Visual Studio, Data Marts, XML, EDW, Windows XP.