SUMMARY

• 7 years of professional experience IT Industry as Microsoft SQL Server Developer. Expertise in database design, Well - versed in structuring, developing and implementing interactive database techniques. Solutions-driven development with commended performance in MS SQL Server and Microsoft Business Intelligence.
• Expertise in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Domain Expertise in Banking, Financial, Insurance, Tele-communicaion sectors.
• Experienced in designing high-level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensive experience in SQL Server Integration Services (SSIS) and providing Enterprise reporting solutions using SQL Server Reporting Services (SSRS), Data Transform Services (DTS).
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
• Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experienced in TSQL (DDL, DML), documenting, coding, programming, modifying and Implementing Business Intelligence solutions using SQL Server /2005.
• Experience in Importing/Exporting Data from various Heterogeneous source like MS Access, Excel, Oracle, DB2 and Flat file using SSIS.
• Experienced in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, and Transformation services.
• Well-versed in using database objects like Batch Scripts, Stored Procedures, Triggers, Views, Cursors, Indexes and User Defined Functions consumed at various stages of Migration/Cleansing process, Reports or Data Validation.
• Experience in creating and managing Clustered and Non-Clustered Indexes to improve database performance.
• Efficient in migrating the MS SQL Server 2005 to MS SQL Server 2008/2012.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSRS, SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Excellent knowledge and experience of creating Jobs, Alerts, SQL Mail Agent, using various Control flow items (such as Execute package task, Execute Process Task, Script Task, FTP Task, Send Email Task, For Loop Container, For each Loop Container etc) and various Data Flow Transformations (such as Derived columns, Conditional split, Lookup, Merge Join, Data Conversion, Fuzzy Lookup, Fuzzy Grouping, Pivot etc).
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2012/2008R2/2005.
• Involved with Performance Tuning of SSIS packages.
• Worked with different types of transformations like Blocking, Semi-Blocking and Non-Blocking Transformations.
• Hands on experience in production/staging/test/development database administrative, Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008R 2/2008/2005.
• Configuring and maintaining Report Manager, Report Server and Report Builder for SQL Server Reporting Services (SSRS).
• Expert in developing Drill through/Drill down reports, Cascading parameterized reports, Linked, Charts and Sub-reports and Log Reports using MS SQL Server Reporting Services (SSRS) and deploying onto Dashboards, SharePoint server, web applications and web servers.
• Scheduling the reports to refresh and run on daily, weekly and monthly basis and also deployment of the reports using Direct deployment and Uploading files using the Report Manger.
• Expertise in data mining concepts like Building Cubes and Dimension Modeling, creating Data Marts, Kimball / Inman Methodologies, Star / Snowflakes Schemas with different architectures and data sources using SSAS.
• Good knowledge of MDX Scripting to perform various tasks.
• Experienced in performance optimization of SSAS cubes using Partitions, Hierarchies and Attribute Relationships.

TECHNICAL SKILLS

DBMS: MS SQL Server 2005/2008/2008 R2/2012, Access 2000/2003

Developer Tools: SQL Server Management Studio, SQL server Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Visual Studio 2005/2008, Team Foundation Server (TFS)

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Reporting Tools: SQL Server Reporting Services (SSRS), Tableau

Data Modeling: MS Visio 2000/2007/2010 , ERWIN 7.1, ERWIN 4.1

Operating Systems: Windows NT/ 98/2000/2003 Server XP/Vista, UNIX, Linux

Programming: T-SQL, MDX,C, C++, JAVA, C#

Business Intelligence: Business Intelligence Development Studio(Bids), Power BI(Power Query, Power Pivot, Power View, Power Map)

Web Technologies: HTML, XML, JAVA SCRIPT, CSS

PROFESSIONAL EXPERIENCE

Confidential, ADDISON, TX

Responsibilities:

• Modified the existing stored procedures to get the new functionality depending on the client requirement.
• Created many tables with the cluster and non-clustered indexes on columns.
• Created various database objects such as tables, indexes and views based on the requirement.
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs usingSSRS.
• Created many SSRS reports with lots of metrics on it using row grouping and column grouping.
• Worked on various types Chart Reports such Lines, Columns, Bars with both 2D and 2D views in order to display cumulative totals based on day to day requirement.
• Created table valued functions and used in the report stored procedures on the fly.
• Proposed and Developed Power PivotandPower Query based reporting for forecasting major initiatives and building ad hoc reports to assess per business needs.
• Worked on Power BI and prepared dashboard reports for internal team progress tracking.
• Developed PowerPivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Developed Charts and other visualization using Power View.
• Filter and Sorting Data using Power Viewin Excel 2013, Also developed Power Maps using Excel2013 for Reporting.
• Attended functional testing meetings,user acceptance sessions and worked on the feedbacks.
• Created deployment documents for the reports and worked with database administrator in the deployment of the report objects to the production server.
• Created SSIS packages to get the data from different sources to BI environment using different transformations on hourly basis, daily basis and monthly basis.
• Involved with ETL team and created packages using SQL Server Integration Services (SSIS) to extract data from various feeder systems, apply required transformation and finally load the data to the destination data warehouse.
• Used multiple transformations including Fuzzy lookups, Merge, Merge Joins, Conditional Splits, Fuzzy Grouping, Derived Columns, Data Conversion, Union All etc. in order to get the desired output before loading it to destination.
• Scheduled jobs that would run on the less traffic hour using SQL Server Agent.
• Employed many Slowly Changing Dimension methodologies to maintain and update historical data in data warehouse.
• Aggregated the data in tables of DataMart for reporting purposes
• Created SSIS packages which sends the customers and sales data from BI servers to marketing department on hourly basis.
• Created the report which gives the status of the production server jobs, which gives the status of the each production server jobs.
• Used SQL Profiler to estimate the Slow Running queries.
• Used Team foundation server for sprint plan and database objects (ETL, Reports) check-in.

Confidential, IRVING, TX

Database Developer(MS SQL/Business Intelligence)

Environment: Windows Server 2008/2012, MS SQL Server 2012/2014, SQL Server Management Studio, SSIS, SSRS, HPQC,FILE ZILLA, MS OFFICE, Shell Scripting, Share Point,HTML

Responsibilities:

• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Developed numerous reports in SQL Server Reporting Services which is of high priority considering the project goal. Parameterized, graph reports and dashboard Reports.
• Worked extensively on SSRS report with loads on integrated calculations with best on fly performance.
• Built and Monitored Executive reports using SSRS for executive team to track progress and other Audit KPI.
• Done many ad-hoc reports for one time purpose according to the Business requirement.
• Created sub reports in some reports like to get the summary from the detail report data.
• Involved in Performance Improvement of thus created reports and deployed reports onto Report Server and Report Manager and to SharePoint Server making those reports available for the end users.
• Created Log Report which retrieves the access log of all reports deployed on Reporting server.
• Created packages in SQL Server Integration services which import the data from share point to reporting server database using connection strings.
• Created mappings to load data extracted from flat files, XML files to staging area using SQL Server SSIS.
• Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into other database.
• Scheduled jobs using SQL Agent to run on regular intervals for updating the data in the server.
• Involved in end to end migration from Source to destination and resolved any of the issues generated in the process of migration. The issues included data type mismatch, missing data type or missing delimiters.
• Handled Audit process for validating the data which includes round the clock monitoring and interacting with several teams over bridge.
• Hands on experience on share point front end by creating views based on requirement with selective fields.
• Created Entity Relationship (ER) diagrams based on requirements.

Confidential, BRENHAM, TX

SQL BI Developer

Environment: Windows Server 2008/2012, MS SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, TFS,, Erwin 7.2, Microsoft .NET framework 3.5, Power BI

Responsibilities:

• Participated in various phases of Software Development Life Cycle (SDLC) of the application.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012.
• Analyzed data after the reports were created for accuracy of data generated by the reports using Business Objects 3.1
• Created Crystal Reports using Business Objects.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Experience in developing Database Schemas / Stored Procedures / Data Dictionary.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Production.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services 2008 (SSRS).
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated tableau dashboards with combination charts for clear understanding.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Experience and advanced knowledge of Kimball Methodology for Data Warehousing.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Build database queries and test cases for the testing team to test the reports.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Used Linq2sql .Net language in order to manage the relational data.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Created SSIS Packages from various data sources.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX and SQL.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.

Confidential

SQL Server/MSBI Developer

Environment: Windows Server 2008, Windows XP, MS SQL Server 2008 & 2012, T-SQL, SSRS, SSIS, Oracle, ERWIN, Flat Files.

Responsibilities:

• Involved in upgrading the instance of development environment of SQL Server 2005 to SQL Server 2008.
• Migration of DTS to SQL Server Integration Service (SSIS).
• Designed data models and generated Entity-Relationship diagram (ERD) using Erwin
• Generated DDL scripts for database schema and created all other database objects
• Developed stored procedures, functions, views and triggers in T-SQL
• Designed, developed and maintained the reports
• Maintained database performance by normalization, indexing, collecting statistics, etc
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Retrieved data from cubes and generated OLAP reports using SSRS.
• Collected requirement and generated stylish reports using SSRS.
• Managed SQL database user accounts, user logins, permissions, database and server roles
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.

Confidential 

SQL Server Developer

Environment: Server 2005, T-SQL, Query Analyzer, Windows NT/2000

Responsibilities:

• Worked on the design of the database to fasten certain daily jobs, stored procedures.
• Active participation and interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Altered tables and fields as per requirements and recreation of indexes.
• Development of SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Creation of views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Creation of complex stored procedures and functions to support efficient data storage and manipulation.
• Usage of DDL and DML for writing triggers, stored procedures, and data manipulation.
• Scheduling of database backup and performing full, incremental and differential backups of database and transaction logs.
• Documentation of all processes involved in maintaining the database for future reference.
• Providing support to development staff about database related issues.