SUMMARY

• Experienced developer with emphasis on Microsoft Business Intelligence stack including MS SQL Server development, administration, data analysis, database design, Report writing (SSRS), ETL (SSIS), and coding of T - SQL stored procedure, views, triggers, and user defined functions.
• I specialize in providing services to Upstream Oil and Gas, HealthCare and Financial industries.
• Very good T-SQL Programming skills.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Designed Databases for enterprise applications on MS SQL Server (7.0, 2000 and 2005,2008,2012)
• Experience coupled with good understanding of the concepts of GUI development, Relational Database Management systems (RDBMS), primarily MS SQL Server.
• Strong experience in developing SSIS Packages
• Expert in integrating the data from different data sources and mapping with the destination columns.
• Experience in developing reports using SSRS.
• Involved in building Enterprise wide Data warehouse and Multi-dimensional cubes using SSAS 2005/2008/2012.
• Good experience in converting the Business Requirements into Technical Specifications, Design & Development.
• Highly motivated with the ability to work effectively in teams as well as independently.
• Excellent communication skills coupled with experience in interacting with clients.
• Committed to highest levels of professional and personal excellence.
• Excellent analytical and problem-solving skills.
• Highly motivated and a fast-learner.
• Ability to work in challenging and versatile environments and strive for excellence.

TECHNICAL SKILLS

RDBMS: MS-SQL Server 7/2000/2005/2008/2012 , 2014, Oracle, MS-Access,DB2

Reporting Tools: SSRS, Crystal Reports, Cognos 8(Framework Manager, Query Studio, Report Studio),Excel, PDF

Oracle Support Utilities: TOAD, and SQL Navigator

Database Tools: SSMS,BIDS,DTS,SSIS,SSAS,Microsoft SQL server replication services

Data Modeling Tools: Erwin, MS Visio

Operating Systems: Windows 7/XP/2000/NT/9x and 2003 server, UNIX

Programming Languages: C, C#, C++, T-SQL,PL/SQL

Scripting Languages: VB6 Script

Other: MS Office, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Lead SSIS Developer

Responsibilities:

• Created permanent tables, temporary tables, table variables, indexes, procedures, views and triggers for automating tasks in TSQL using SQL Server 2008/2012/2014 .
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in Converting the legacy database to SQL Server 2014.
• Maintained the database objects including the stored procedures, user defined functions, tables related to PODS (Pipeline Open Data Source) data model.
• Extensively involved in database support (creating stored procedures, functions etc.) for the user interface called Asset Information Manager (AIM) from which users can access different pipeline assets, reports etc.
• Created a new data warehouse using SQL Server 2005, extracting data from the OLTP to DB2 Reporting database by using SSIS (T-SQL)
• Analyzed the existing DB2 database (Reporting database) for different stores
• Created several tables, views and stored procedures using SQL Server 2008/2005 and Toad for DB2 3.0
• Created SSIS packages to extract data from DB2 to the SQL Server and scheduled jobs to call the packages
• Worked closely with GIS analysts and involved in writing the SQL scripts using SQL Geo spatial functions.
• Involved in creating the derived tables/processes using PODS tables as a source.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Participated in ETL Architecture sessions including mappings, process flows and scheduling the packages to run on frequent basis.
• Designed the Templates to develop the SSIS packages with fixed variables and for Auditing package execution details.
• Created custom data flow items for different SSIS packages using the VB.Net script.
• Involved in Data mapping between the source and destination components.
• Created the package configurations using XML configuration file and Parent Package Variables.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Managed the production deployments and maintained different versions of the scripts and SSIS packages through Team foundation server source control.
• Designed and developed various SSIS packages to import data from Excel and Flat files to SQL Server using SSIS 2008, 2012 and 2014.
• Involved in unit testing the SSIS packages and checking in the updated versions of the packages in TFS.
• Created individual Data marts for NPMS, PHMSA, and RISK deliverables.
• Consolidated the data from all the data marts to build Enterprise Data warehouse.
• Strongly involved in technical design for implementing data warehouse.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Analyzed reports and fixed bugs in stored procedures.
• Involved in writing scripts and transactions to manipulate data in the database.
• Involved the technical review of SQL code with peers and design review with end-user audience.
• Involved in documentation of SSIS Packages, Tables, Stored Procedures, and User Defined Functions etc.
• Worked on various major projects such as Facility Management, UPMR, HCA, ILI, AGM Loader, etc. in the Asset Integrity Management Department.

Environment: MS SQL Server 2008/2012/2014 , SSIS 2008/2012/2014 , DB2 SSRS, SSAS 2008/2012, TFS, MS Excel, Windows 2008

Confidential, Houston TX

SQL/SSIS Developer

Responsibilities:

• Designed and analyzed the SQL Server database and involved in gathering the user requirements
• Logical and Physical design of database for project on basis of user requirements.
• Created new tables, stored procedures for Application Developers and some user define functions.
• Created SQL scripts for tuning and scheduling.
• Gathered requirements, analyzed the CRD (DB2) and CVO (Historical MS Access Databases) and documented the findings
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, AS400, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities.
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
• Involved in pulling the data from ERCOT website and loading into the database
• Involved in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used custom .NET assemblies for Script Task in SSIS.
• Designed and developed SSIS package for loading data from OLTP to ODS and finally to Data Warehouse.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Implemented replication in SQL Server for managing and scaling databases in an enterprise environment.
• Loading data in Dimension Tables in SQL Server using SSIS Packages.
• Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
• Deployed and Configured SSIS Packages using BI xpress.
• Involved in using BI xpress for error handling by adding auditing feature to SSIS Packages and monitoring the same.
• Unit testing and Integration testing for various modules.
• Responsible in creating a SQL Agent job to automate the execution of SSIS Package and executing in different environments.
• Involved in Data Cleansing, Data Scrubbing, Error and Event handling, setting up the precedence constraints, Breakpoints, Checkpoints, and Logging.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, MS Excel, Windows 2008 Server

Confidential, Austin TX

SQL/SSIS Developer Analyst

Responsibilities:

• Collaborated with business experts and application development teams to understand output requirements and ensure application data and master data support those requirements.
• Understand complex business models and the data that supports those models, including inter-relationships between applications.
• Provided solution options, including phased delivery, in order to deliver value to the business.
• Translated business requirements documentation, as well as input from business users, into functional and technical specifications.
• Prepared Diagrams using Microsoft Visio and Erwin for better understanding the Database Models.
• Importing/Exporting data from/to different databases using utilities like Import/Export, Bulk Insert.
• Participated in migration of data from Microsoft Visual FoxPro to SQL SERVER databases and responsible in creating complex SSIS packages to transfer data between them.
• Involved in Authoring reports in SSRS according to the business requirements.
• Involved in Data Conversion from Microsoft Visual FoxPro to SQL Server Database.
• Designed and developed a fully functional database by creating the logical database design and implementing the physical database design using SQL server 2005.
• Written complex t-sql Queries using joins, aggregate functions, sub queries.
• Participated in Performance tuning SQL statements to improve performance of the system.
• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other DDL and DML statements for various applications, maintained referential integrity and implemented complex business logic using t-sql and pl sql.
• Wrote stored procedures using Dynamic SQL, Cursor to handle special case which can't be handled using static T-SQL or set based operations.
• Created views to develop new user-friendly web pages and restrict data access to users.
• Performed full, transactional, and differential backup.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Used tools like SQL Profiler, Performance Monitor to find out performance issues with queries or Application (i.e. Opening/Closing Connections by application, Read/Write etc.)
• Involved in Error handling for different applications.
• Involved in documenting the scripts for better understanding.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, MS Excel, Windows 2003 Server

Confidential, WA

BI Developer

Responsibilities:

• Worked with business experts and application development teams to understand output requirements and ensure application data and master data support those requirements.
• Understand complex business models and the data that supports those models, including inter-relationships between applications.
• Provided solution options, including phased delivery, in order to deliver value to the business.
• Translated business requirements documentation, as well as input from business users, into functional and technical specifications.
• Responsible for analyzing the data, ensuring the data quality and organizing the data.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Created Dimensions with the cube wizard and also individually.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• 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.
• Created Reports from Web Services and used MDX on Cubes in SSAS to create reports in SSRS.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects
• Participated in tuning MDX to improve performance of the system.
• Created complex reports against Cube.
• Involved in converting Excel reports to SSRS Reports.
• Experience with excel reporting.
• Involved in creating Complex Parameterized reports.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.

Environment: MS SQL Server 2005/2008, SSIS, SSAS, SSRS, MS Excel, Windows 2003 Server

Confidential, MD

ETL/Report Developer

Responsibilities:

• Actively participated in interacting with business users, gather and analyze requirements.
• Actively participated in defining defaults, constraints.
• Importing/Exporting data from/to different databases using utilities like Import/Export, Bulk Insert.
• Written complex t-sql Queries using joins, aggregate functions, sub queries.
• Participated in tuning SQL statements to improve performance of the system.
• Involved in designing, developing and converting the data from legacy source systems to SQL Server database.
• Participated in migration of data from EXCEL to SQL SERVER databases and responsible in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL server using DTS/SSIS.
• Designed and developed a fully functional database by creating the logical database design and implementing the physical database design using SQL server 2000. Successfully tested and validated with end users the database design.
• Wrote queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS)
• Created Drill through reports by creating complex views.
• Developed reports using table control, matrix control for cross tab reports and designed and created Report templates, bar graphs and pie charts
• Generated new ad-hoc reports, Static reports using SSRS with variety of Data sources and published using Report Manager.
• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other DDL and DML statements for various applications, maintained referential integrity and implemented complex business logic.
• Designed multi-dimensional SQL database structures for numerous projects using common dimensions within a singular data warehouse environment.
• Developed analytical and reporting solutions using SSRS 2005/2008 (Reporting Services), SSAS 2005/2008 (Analysis Services).
• Worked with SQL delta tools for comparisons between databases.

Environment: MS SQL Server 2005, SSIS, SSAS, SSRS, VB6, SQL Delta tool, Microsoft IIS, Windows 2003 Server

Confidential

SSIS Developer

Responsibilities:

• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for applications.
• Wrote Store Procedures using Transact SQL to populate the fact tables and dimension tables.
• The Stored Procedures support both daily and historical data loading to the fact tables.
• Created scripts to perform validations and run jobs on different instances (Development, Testing, and Production Environments)
• Worked on Linked and Remote Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB drivers.
• Created PL/SQL stored procedures, Functions for moving the data from staging area to Data mart.
• Created PL/SQL scripts to extract the data from operational database into simple flat text files using UTL FILE package.
• Responsible for scheduling the jobs.
• Gathered Requirements from the end user and checked the structure of the schema and data.
• Involved in Performance tuning the SSIS Packages.
• Developed SSIS package from source to staging and/or staging to DW data mappings.
• Developed data warehouse and reporting systems using SSIS and SSRS including Report Builder and Report Models.
• Created new SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated data that is extracted from ORACLE.
• Created SSIS packages to clean and load data to data warehouse.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Deploy SSIS packages.
• Maintain and Optimize SSIS package, and troubleshooting issues.
• Use SQL Profiler and Execution Plan for troubleshooting, monitoring SQL Server, T-SQL statement, Index, configure jobs and SQL profiler trace.
• Created reports by extracting data from cube.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Created report models and deployed on report server.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Worked extensively on enterprise report (dashboards, scorecards, sub report, matrix and drill through) and ad-hoc reports.

Environment: MS SQL Server 2005, SSIS, SSRS, SSMS, ORACLE, Windows 2003 Server T-SQL.

Confidential

SQL Server Developer

Responsibilities:

• Served as developer for the solutions designed by other team members.
• Checked the coding standards followed by peers of the team.
• Prepared test reports and bug logs for the testing done.
• Involved in data migration and data integration.
• Developed stored procedures, triggers and functions and added/changed tables for data Extraction, Transformation and loading.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stores procedures, checked deadlocks and created scheduled jobs.
• Extraction, Transformation and Loading of the data using DTS packages.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
• Responsible for designing Schema and finalization of naming and coding standards throughout project life cycle.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL and PL SQL in Development and Production environment for SQL Server.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: Windows Server 2000, SQL Server 2000, Oracle, HTML, T-SQL.