SUMMARY:

• Around 8 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-communication sectors.
• Excellent experience with major relational databases SQL Server 2005/2008/2012/2014 , Oracle 11g/10g/9i, DB2, MySQL.
• 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.
• Solid Expertise inOracle Stored Procedures, Triggers, Index, Table Partitions and experienced in Loading data likeFlatFiles, XML Files, Oracle, DB2, SQL Serverinto Data Warehouse/Data Marts using Informatica.
• 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, Change data capture(CDC), Reports and Data Validation.
• Experience in creating and managing Clustered and Non-Clustered Indexes to improve database performance.
• Efficient in migrating 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.
• Experienced in connections like OLE DB, ODBC which tracks source data from different sources.
• 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).
• Proficiency in using various Oracle utility tools,SQLPlus, TOAD,SQL Navigator,SQL Loader.
• 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.
• Proficient in creating reports usingBusiness Objects XI R2 functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
• 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.
• Experience in designing and building analytics data warehouse solutions using Microsoft SSAS Tabular Model.
• Assisted Architect with building data platform on Microsoft Azure Data Warehouse environment, creating databases on AZURE platform, including connection strings setup and maintenance.
• Experienced in performance optimization of SSAS cubes using Partitions, Hierarchies and Attribute Relationships.
• Employed many Slowly Changing Dimension methodologies to maintain and update historical data in data warehouse.
• High ability to work on SOW and Agile projects, implementing scrum process
• Work shop experience on Sybase, Mongo DB, Cassandra, Qlikview.
• Working experience on Cognos BI tools using Report studio and Query studio for advanced reporting, model designing.
• Knowledge in creating web applications using ASP.Net, AJAX, XML, HTML, DHTML, JavaScript and CSS (Cascading Style Sheets).

TECHNICAL SKILLS:

DBMS: MS SQL Server 2005/2008/2008 R2/2012, Oracle 11g IBM AS 400

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(Desktop/Server)

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#, Shell Scripting

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

Web Technologies: HTML, XML, JAVA SCRIPT, CSS

WORK EXPERIENCE:

Confidential, ADDISON, TX

Environment: SQL Server 2012, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL server Profiler, Microsoft Visual Studio 2010, Oracle11g, Power BI, Teradata, Team Foundation Server(TFS).

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.
• Migrated data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• 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.
• Interacted with Business user for requirement gathering and write traceability mapping documents.
• Involved in loading of data into Teradata from legacy systems and flat files using complex.
• Created Teradata External loader connections such as MLoad, Upsert and
• Update, Fastload while loading data into the target tables in Teradata Database
• Running DBCC consistency checks and fixing data corruption in databases.
• 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.
• Played Key role in team of ETL developers for re-writing DTS packages and updating them to SSIS packages.
• 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 Data Mart 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.
• Development and maintenance of complex client facing reports by using various data manipulation techniques in SSRS and Visual Studio
• 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.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector
• Developed web pages for embedding deployed SSRS reports using ASP.NET
• Deployed and maintainedASP.NETapplications running atIIS 6.0.
• Data Access layer is implemented usingADO.NETto Communicate with theSQL Server Databaseand to access, update the data in the database.
• 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.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

Confidential, BRENHAM, TX

SQL BI Developer

Environment: Windows Server 2008/2012, MS SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, TFS, Erwin 7.2, SQL Azure, 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 ad-hoc 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.
• Managing SQL Azure databases and addressing firewall issues.
• Implementation of Kimball Methodology for Data Warehousing.
• Created the storage type (ROLAP),Created cubes for Business Intelligence
• Involved in writing MDX Scripts for the OLAP CUBES.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• 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.
• Migrating 2005 SQL database environment to SQL 2008R2 by converting and re-writing DTS packages and updating them to SSIS packages.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.
• Experience in creating ad-hoc 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.
• Assisted in designing CRM technologies for marketing of organization products allowing effective communication with customers
• Maintained relationships with clients customers and management coordinating the efficiency of their interactions
• Identified deviations in CRM plans and corrected them accordingly

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.
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Worked within a lean agile environment and continuous delivery, did pair programming with co- developers, regularly involved in estimation and planning.

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.