SUMMARY

• Highly motivated SQL Server/BI Developer with 7+ Years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server 2008/2008R2/2012/2014, SSRS, SSIS, SAP Business Objects, Tableau and Power BI.
• Proficiency in Database design, Coding, unit testing and Implementation. Hands on Experience in optimizing the queries by creating various clustered, non - clustered indexes and indexed views.
• Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2014/2012/2008 R2/2008.
• Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2014/2012/2008, DTS, SSIS and SSRS 2005/2008/2012.
• Integrated Asp.Net with SSRS reports and also integrating them with SQL server Database. Possessed excellent skills in Data Modeling to create Star and Snowflake Schemas using Erwin.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column. Extensive knowledge in Tuning T-SQL queries to improve the database performance Wrote VB.Net code for various SSIS Packages.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Performed data migration using tools like Data import/export, BULK INSERT and BCP between different heterogeneous systems and SQL Server. Involved in creating Jobs, SQL Mail Agent, Alerts and Scheduled DTS/SSIS Packages.
• Good knowledge of Defining, Developing and Deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server 2012/2008 Analysis Services (SSAS) on EDW.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications forBusiness Objects Universesand Reports.
• Excellent experience in designingBusiness Objects universes, complex BO reports bothfull clientandWeb Intelligence Reports.
• Excellent knowledge of all the phases of Software Development Life Cycle (SDLC). Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.
• Proficient in Transact SQL development and Experience and knowledge on SSIS and SSRS. Proficient in scripting T-SQL queries, ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Proficient in the use of majority of the SSIS transformations, Containers, Tasks, migration of data from various source DB’s like Sybase, MSSQL, Access, Excel, Flat File to SQL Server 2005/2008, package configurations, logging, checkpoints, master and child packages, package deployment, variables and expressions, error handling and troubleshooting.
• Experience in Installation, Configuration of SQL Server/BI Suite ( ), Creation and Management of Logins, Users, Schemas and Permissions, Automation of SSIS package execution using SQL Server Agent Jobs, Database Backups and Restoration.
• Strong analytical knowledge coupled with excellent communication and interpersonal skills. Proficient in developing clear and concise documentation of all work performed.

TECHNICAL SKILLS

Database: MS SQL Server 2005/2008/2008 R2/2012/2014, DTS2000, MS SQL Server Integration Services (SSIS 2005/2008R2) (SSIS), T-SQL, MS SQL Server Reporting Services (2005/2008/2012 ) (SSRS), Micro strategy, Analysis Services (SSAS 2008), Oracle 10g/11g/12c-PL/SQL, Reports, D2k Reports and Forms, Work Flow builder, TOAD, HP open view, XML Publisher Reports, MS-Access

Software Applications & Tools: Microsoft SQL Server Management Studio, Microsoft Visual Studio, BIDS, Clear Case, Oracle SQL Developer, Oracle applications, Microsoft Visual Source Safe, HP Project Portfolio Management, HP Quality Centre, Eclipse, MS OfficeProgramming Languages: SQL, TSQL, PLSQL, VB, Core Java, C, C#

Web Technologies: HTML5, CSS, XML, JavaScript, ASP.Net, AJAX.

Modeling & Reporting: Tableau, SAP BusinessObjects, Power BI, Erwin, Microsoft Visio, R2M Case tool.

Operating Systems: WINDOWS, UNIX, Linux.

Testing Tools: Win Runner, Load Runner, Quality Center, and QTP.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr.SQL Developer/ETL/BI Analyst

Responsibilities:

• Loaded legacy source data from MSSQL, MySQL, Oracle, Access, and SQL Server DB’s into SQL Server 2008 R2 staging DB’s using SSIS Import &Export Wizard and VB scripts, SQL Server Migration Assistant (SSMA) and SSIS packages.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on Maintaining, Generating Reports and Data Migration for various Database systems using SQL Server 2012, SSRS, SSIS, and vb.
• Created TSQL stored procedures, functions, etc. and tuned them using query analyzer and explain plans. Performed data profiling, data analysis to identify legacy data that needs to cleanse prior to the migrations using SSIS Data Profiling Task, Data Profile viewer and T-SQL queries.
• Participate in creating data conversion and migration strategy, conversion design and conversion development documents. Participate in Data Modeling Sessions. Hosted SSIS, SSRS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development.
• T-SQL development included queries using joins, subqueries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Experience in creating master and child packages, using package configurations (XML, SQL Server) and SSIS logging.
• Worked with Managers to prepare requirements gathering documents and quality documents.
• Analyze the client requirements and functional areas of the existing system, client interactions, coordinating with the team members on critical problems and solving.
• Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs.
• Wrote complex SQL queries using joins, stored procedures, used defined functions to verify the data from the database to generate reports based on the business requirement
• Formulated and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Responsible for design, create and tune database objects (tables, views, indexes) to support Logical and dimensional models. Maintain the referential integrity of the database.
• Ability to analyze and resolve performance issue with database code involving SSIS and MS SQL Server 2012.
• Created stored procedures and functions to support efficient data storage and manipulation
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed various analytical reports from multiple data sources by blending data from different sources on a single worksheet in Tableau Desktop
• Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.

Environment: SQL Server 2012, T-SQL, SSIS 2008/2012,BIDS, Visual Basic .Net, Vb6, XML, eManager, eBO reporting, Microsoft Project, SVN, Core Java, Microsoft Access, SSRS, Microsoft Excel, QAS.

Confidential, Chicago IL

Sr.SQL Developer/ETL/BI

Responsibilities:

• Gathered business requirements by interacting with the Business Analysts. Installed and Configured SQL Server 2012. Configured the Window Server for required Service Packs.
• Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio (SSMS) and T-SQL statements to implement complex business logic.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Created Indexes and performed Index Tuning using Index Tuning Wizard for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Integrated ASP.Net pages with SQL server Database. Designing and building data load procedures using MS SQL Server.
• Wrote standard & complex T-SQLQueries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Developed User Defined Functions and created Views.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQLstatements using SQLprofiler.
• Created Triggers to maintain the Referential Integrity.
• Reviewed existing business procedures and recommended and implemented changes.
• Trouble shoot problems with the various teams including network related issues.
• Rebuilding Indexes and Tables as part of Performance Tuning.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Used Tableau to visually analyze data and create concise and actionable dashboards.
• Optimized the performance of queries with modification in T-SQLqueries, normalized tables, established joins and created indexes.
• Wrote T- SQLqueries, Stored Procedures and used them to build SSIS packages.
• Created views to restrict access to data in a table for security.
• Supported Application Development team with any database issues, updates or new releases. And deadlock issues, best practices in structuringSQLQueries, debugging unexpectedSQLresults etc.

Environment: MS SQL Server 2008R2/2012, SSRS 2005, SSIS 2005, Windows Server 2003, PVCS, Citrix, Windows XP, Erwin 7.1, MSMS, MS Visual Studio 2012, ASP.Net, Xml.

Confidential

SQL Developer

Responsibilities:

• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Configured and installed SQL Server 2008 on Windows 2003 Server. Migrated databases from Oracle database to MS SQL Server 2008. Involved in normalization of the Database in OLTP.
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Created database diagrams in SQL Server Management Studio (SSMS). Created Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created Stored Procedures which generated the necessary fact and dimension tables and functions that allowed performing necessary calculations depending upon the requirement.
• Performed time calculations and date functions using calculated measures and MDX queries.
• Design and created different ETL packages using SSIS from Oracle source to SQL server as destination. Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Analyzed, designed, and provided AD-HOC, standard, and executive summary reporting services (SSRS) for internal use and client presentation.
• Experience with Analysis services 2005 and made various cubes based on the reporting requirement.
• Integrated ASP.Net WebPages to the SQL server 2000 Back end. Integrated Asp.Net pages with SSRS reports.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs. Created Subscriptions for the users to deliver the reports in a timely manner.
• Streamlined increased efficiency and productivity, to keep pace with ever increasing client reporting needs.

Environment: MS SQL 2008, Oracle 10g, SSRS 2008, SSIS 2008, SSAS 2008, SQL Server Migration Assistant, SQL Server Query Analyzer, Windows Server 2003, Windows XP, VSS, Erwin 7.0, Asp.Net.

Confidential

Programmer Intern

Responsibilities:

• Involved in Creation of database, tables, stored procedures, triggers, and user defined functions for dealing with student data.
• Involved in Installation and configuration of SQL Server 2008 for reporting purposes on Windows 7, Vista Systems.
• Installed and configured SQL Server 2008, SQL Server Integration Services and SQL Server Reporting Services.
• Involved in requirements analysis, development, deployment and unit testing of components.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008.
• Created Complex SQL queries, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF).
• Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler, Indexes and Execution plans in MS SQL Server 2008.
• Used stored procedures, wrote new stored procedures, modified existing ones and tuned them such that they perform well.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Tested and analyzed relational and OLAP data. Enforced different business constrains and rules using triggers and check constraint.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient manner and created stored procedures for the business logic using T-SQL
• Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server agent.
• Designed, deployed and tested stored procedures, views and complex queries for report distribution.
• Effectively used views to prevent unauthorized access.
• Tuned SQL queries using execution plans for better performance.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2008, VISIO, T-SQL,SSIS 2008.