PROFESSIONAL SUMMARY:

• 7+years of IT Experience in Database Design, Implementation, Development and support in Information Technology field.
• Excellent experience in Designing, Maintaining & Tuning various RDBMS like T - SQL Server 2005/2008/2008 R2/2012,MS Access databases and strong knowledge of SDLC principles.
• Proficient in Cognos Business Intelligence tools with Query studio & Report studio for creating Reports.
• Comfortable in Cognos Framework Manager, Creating Packages and Filters.
• Involved in all phases of software development life cycle: design, implementation and testing.
• Experience on development the Microsoft Analysis services cubes andMDXqueries.
• Experience in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Performance Tuning, and Query Optimization.
• Effectively manages time spent on multiple projects to meet deadlines.
• Proficient in creatingIndex, Views, Stored Proceduresand appropriateUser defined functions.
• Experience and advanced knowledge ofKimballMethodology for Data Warehousing.
• Experience in designing and creating SSRS reports on TFS environment.
• Designed and implemented various Materialized Views to use in Cognos Reporting and SQL Environment.
• Experience in database activities likeDevelopment, Database creation and Maintenance and Tuning, Troubleshooting and Normalization
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Strong experience in MS SQLServer with Business Intelligence in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Experience in writing efficient SQL queries involving multiple tables inner and outer joins.
• Experience in creating Jobs, Sending Mail on Cognos and SQL environments.
• Experience in Data Extraction, Transforming and Loading (ETL) using various tools such asSQLServer Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience in writing T-SQL working on SSIS, SSRS Data Cleansing and Data Scrubbing.
• Experienced in using global variables, expressions and functions for the reports.
• Highly Proficient in the use of T-SQLfor developing complex Stored Procedures, Triggers, Functions.
• Experience in designing reports like reports using Cascading parameters, Charts, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
• Team player and self-starter with excellent communication skills, ability to work independently or as a part of team and capable of picking up new skills quickly.

TECHNICAL SKILLS:

RDBMS/DBMS: SQL Server 2005/2008/2008 R2/2012

BI Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Studio, Visual studio 2008/10,IBM Cognos Business Intelligence,TFS-2013,DTS.

Operating Systems: Windows 2008/2003/Window XP/VISTA/7

Languages: T-SQL

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

SQL BI Developer (SSIS/SSAS)

Responsibilities:

• Develop technical design documents and mapping specifications to build ETL Mapping to load data into target tables.
• Developed ETL packages with different data sources, SQL Server, Flat files, Excel source files, XML files and loading the data into the target tables by performing different kind of transforming using SSIS.
• Used Microsoft TFS in order to share the code with other programmers and as a source control Document, design, develop, optimize and maintain reliable, repeatable and scalable ETL packages and solutions by implementing ETL standards, conventions and best practices in SSIS.
• DevelopedMDXScripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball's dimensional modeling standards usingSQLServer Analysis Services SSAS.
• Deployed SSIS Package into Production and use package configuration to export various package properties to make package environment independent.
• Extensively used SSIS transformations in order to perform data cleansing and data mapping before loading the data into data marts.
• Provided technical expertise in data analysis, collection and documentation of metadata components and information delivery.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball's dimensional modeling standards usingSQLServer Analysis Services SSAS
• Utilized T-SQL extensively in order to replace SSIS transformations in order to improve the performance of the packages.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies, actions, partitions, aggregations based on the OLAP reporting needs.
• Defined relationship between facts and dimensions with star schema and Snowflake Schema in SSAS.
• Created weekly Daptive reports based on Portfolio and 4boxer like:-Champion, Claims, Corporate, customer facing, Data servicing etc.
• Created calculated members, named sets for custom measures using MDX for OLAP reporting as per end user requirements.
• Deployment and Processing SSAS cubes, monitor full and incremental loads and support any issues.
• Created SSAS Tabular semantic model in Direct Query mode with multiple partitions, KPI's, hierarchies and calculated measures using DAX as per business requirements.
• Involved in the creation and deployment of the reports using SSRS and configure the SQL Server Reporting Server in SharePoint integration mode.
• Migration of Database and creating specific tables for Reporting.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, and Multi-Valued Parameters as required.
• Applied Reverse Engineering on the packages on performance issues and made changes to enhance the performance
• Wrote complex SQL queries using joins and Sub queries and functions to retrieve data from multiple tables.
• Compiled source to target mapping documents to design the ETL jobs.
• Prepared detail design documents which contain job designs and functionality of each job.

Environment: SQL Server2012/2014, SharePoint 2010/2013, TFS, MDX, SSIS, SSAS, multi dimensional and Tabular, Power BI

Confidential, Norfolk, VA

SQL /SSRS /SSIS/ BI Developer

Responsibilities:

• Involved in database development using stored procedures, triggers and views.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Involved in creating Indexes for faster retrieval of data.
• Maintained data integrity by performing validation checks.
• Involved in running the SQL Profiler for better execution Plans.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Created report links to refer other reports in a particular report.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Adept at defining d relationships and calculated members in SSAS and used MDX/DMX andDAXqueries.
• Imported data from various sources into a staging area merges the data into the OLTP data model.
• Utilized Microsoft Technologies such as T-SQL, Stored Procedures, SSIS, SSRS,KIMBALL methodology andSQLServer …
• Monitored the performance and optimized SQL queries for maximum efficiency.
• Developed SSIS solution for developing a full-fledged data warehouse solution.
• Monitored and deployed SSIS packages and involved in notification services, error handling.
• Responsible for creating the reports basing on the requirements using SSRS 2012.
• Deployed the generated reports on to the server.
• Identified the database tables for defining the queries for the reports.

Environment: MS SQL server 2012, BIDS, T-SQL, Oracle, .NET, Visual Studio, MS Server Integration services (SSIS), MDX/DMX andDAX, MS Server Reporting services (SSRS).

Confidential, Waco TX

BI Developer / SSIS / SSRS/ETL

Responsibilities:

• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Scheduling the ETL packages as job inSQLServer Agent.
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters
• Planed, defined and designed data flow processes for data migration to the Data Warehouse.
• Implemented different types of Constraints on tables designed in the data staging area for the migration.
• Debugging Parameter Issues Matrix Reports and Charts.
• Created User defined Function and complex stored Procedure to retrieve the search results and to get the well formatted output for the report.
• Developed and configured the reports using the data in data marts to be sent at regular intervals to the vendor either through email or in shared folders.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split,and Send Mail task etc.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, Oracle10g, Visual Studio 2005, VSS 2005, Erwin 7.3, Windows NT/2003,Microsoft .NET framework 3.5, C#, Teradata, TFS, ASP.NET, XML

Confidential, Temple TX

SSRS/SSIS Developer

Responsibilities:

• Developed SSRS Reports for package failures, error log report and package log report.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split,SQLtask, Script task and Send Mail task etc.
• Created staging Database and other stage database for data verification and cleaning.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into final database.
• Created SSISpackages for Finance application that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed various packages using various task e.g. For Each Loop, File System Task, Fuzzy Lookups, Multicasting various others for data cleansing.
• Used Execution Plan,SQLServer Profiler and Database Engine Tuning Advisor towards performance tuning of databases.

Environment: SQL Server 2012 Enterprise Edition, Hyperian, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, DTS, T-SQL, VB Script, Windows Server 2003,Erwin 7.1

Confidential

SQL/SSRS/SSIS Server Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Performed Backup and restore of databases.
• Provided back-end support for functional testing and performance testing.
• Designed various packages using various task e.g. For Each Loop, File System Task, Fuzzy Lookups, Multicasting various others for data cleansing.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.

Environment: MS SQL Server 2000/7.0, Windows Server, Windows NT, Erwin, Facets, TFS, Crystal Reports

Confidential

SQL Server Developer

Responsibilities:

• Created numerous simple to complex queries, views and store procedures involving Multi-table joins and self joins and correlated sub queries.
• Creating the new tables, indexes required for the new features and altering the tables for change request features and views.
• Worked as a developer on databases like MS SQL Server 2005, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Maintained the consistency of the client’s Database using DBCC

Confidential

SQL/ Data Analyst

Responsibilities:

• Creating the new tables, indexes required for the new features and altering the tables for change request features and views.
• Worked with internal and external clients for import and normalization of third-party data.
• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL
• Created triggers to keep track of changes to the fields of tables when changes are made.
• Planned, design, and implement application database code objects, such as stored procedures and views.
• Extensively used Views for complex joins queries involving multiple tables from different databases.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost of the existing product databases.
• Monitored and provided front-line support of daily processes.
• Analyzing the requirements and discuss with managers at clients location on the functionality, Worked for job scheduling and batch queries.

Environment: MS SQL Server 2008, SSIS 2008, SSRS 2008, SSAS 2008, T-SQL, COBOL, SSMS