PROFESSIONAL SUMMARY:

• Over 8 years of Information Technology industry experience with Confidential SQL Server 2005/2008/2008 R2/2012, SSIS/SSRS/SSAS and OLAP as SQL Developer.
• Extensive experience with SQL Server and T - SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools, ETL Process (Data Extraction, Transformation and Load) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS).
• Expertise in creating, developing and designing SSIS package to Extract, Transform and load (ETL) data into Data warehouse from data source such as Flat files, XML file, OLE DB Source, ADO NET Source, Raw File, ODBC, Excel files.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Expertise in OLTP/OLAP system study, analysis and developing database schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modelling.
• Expertise in firing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures and cursors.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Created views as per design needs.
• Experience with Backup and Recovery of MS SQL 2 Server Databases.
• Heavy experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Well experienced in performance tuning in SSIS packages by using row transformations, block and unblock transformations.
• Skilled at building and deploying multi-valued parameterized reports using PowerBI, Tableau.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, COSMOS etc. to SQL Server using SSIS /DTS using various features like data conversion etc.
• Worked with Scope Queries to get the data from COSMOS.
• Experienced in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Experience in designing enterprise reports using SQL Server Reporting Services, generated drill down reports, drill through reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008/2012.
• Wrote parameterized queries for generating reports in SSRS 2008/2012.
• Well experienced in developing the SSAS 2008 Multidimensional and Tabular model reports from Data warehouse using SSDT.
• Hands on experience on creating PowerShell scripts that will extract data from SQL or loading flat files into SQL tables.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Good communication skills, quick learner and good performer both in team and independent job environments with strong logical and analytical skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows NT, Windows 95/98/2000 XP/Unix

Databases: MYSQL Server 2000/ 2005/2008/2008 R2/2012, MS Excel/MSWord/MS Access

Modelling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling, ER Diagrams

ETL Tools: Experienced working with SSDT/BIDS DTS, SQL Server Integration Services (SSIS), SQL Server Reporting (SSRS).

Reporting Tools: SQL Server Reporting Services (SSRS)

Development skills: Transact SQL (T-SQL)

Languages: C, C++, Visual C++ 6.0, VB6.0, C#.Net, VB.Net, PL/SQLTSQL, PowerShell.

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. SQL Server Developer, BI Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Designed SSISpackages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012.
• Written stored procedures and used them in packages.
• Created complex stored procedures using SQL server management Studio. Further, these stored procedures are used for generating reports using SQL Server Reporting Services (SSRS).
• Designing reports using SQL Server Reporting Services (SSRS 2012) which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
• Created Subscriptions for the SSRS reports, which involved file share on network drive and E-mailing the reports to users.
• Completed unfinished former developer projects and resolved related issues ETL, SSRS.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Involved in creating SQLreports, data extraction and data loading scripts for different databases and schemas.
• Creating SSIS package to import data from SQL tables to different sheets in Excel.
• Testing and fixing packages using SQL 2012 Business Intelligence Development Studio.
• Scheduling and executing SSIS Packages, using SQL Server Agent. Implemented and maintained data/reporting requests and roll out process.
• Using SQL server 2012 Always on feature setup High Availability for TFS /SharePoint.
• Installation, configuration and upgrade of TFS 2010/2012/2013 Instances.
• Created a tabular model cube and modified the Relationship between a Measure group and a dimension using SSAS.
• Bulk data migration using SSIS from flat files.
• Developed PowerShell scripts that used to import and export data between tables.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations on the Power BI reports and Dashboards on client requests.
• Connecting Power BI to different data sources - SQL databases, Cubes, Web services, Web trends, Excel, Azure.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Import and export billions of data from Excel, Flat files to MS SQL Server databases by using BCP, DTS, and SSIS utilities.
• Experience in data manipulation using SQL, COSMOS and Scope.
• Created Ad-Hoc reports, Summary reports, Sub Reports and Drill-down Reports using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2008 R2/2012, BIDS, Management Studio (SSMS), ETL, Integration Services (SSIS) 2008 R2/ 2012, Reporting Services (SSRS) 2008 R2/2012, PowerBI, TFS, SQL Profiler, SQL Server Query Analyzer.

Confidential, Indianapolis, IN

Sr. SQL Server Developer, SSRS/ SSIS/ SSAS Developer

Responsibilities:

• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Identified the data source and defining them to build the data source views.
• Looked at the reports and fixed bugs in stored procedures.
• Extensively worked onviews, cursors, CTE’s, schemas,permissions and performance issues with client/server database design.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Involved in dimensional modeling to design data warehouse.
• Monitored scheduled jobs and alerts.
• Installed Visual Studio 2013 to connect to the TFS 2013 Server.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Identified and worked with parameters for parameterized reports in SSRS 2008.
• Created SQL Server Reports and developed query for generating drill down reports using SSRS 2008.
• Migrating existing SSRS report to PowerBI platform.
• Built Data Analytics or visualization using Power BI (Power View integrated with Share Point)
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Responsible for transferring the data using SSIS packages.
• UsedSSISto createETLpackages to validate, extract, transform and load data toData Warehousedatabases.
• Customized TFS Build Scripts to automate build and deployment.
• Improved Report Performance and performed unit testing.
• Created a cube using multiple dimensions and modified the Relationship between a Measure group and a dimension using SSAS.
• CreatedSSIS packages to export data from text file to SQL Server Database.
• Working with PowerBI Gateway to schedule daily job to refresh data.
• Designed and implemented stylish report layouts.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Implemented and enhanced existing reportslike group by, drilldown, drill through, sub-reports, list, tabular, matrix, navigation reports, standard parameter, cascading parameter and multivalve parameters.

Environment: MS SQL Server 2008/2008R2/2012, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Windows 2010, PowerBI, TFS, MS EXCEL, SQL Server Profiler, C#.

Confidential, Des Moines, IA

Sr. SQL Server Developer, SSRS/ SSIS Developer

Responsibilities:

• Designed and tested (unit, integration and regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Transferred data from various OLTP data sources, such as MS Access, MS Excel, Flat files, and CSV files into SQL Server 2008.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures.
• Developed error handling routines for packages using both script tasks as well as in the error handling environment.
• Implemented various notifications based upon the scheduling jobs, database monitoring, disaster recovery plans and wrote windows scripting scripts for automation of the tasks.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed processes, automation of maintenance jobs, tuning SQL server, data validations, locks and indexes configurations.
• Worked on performance tuning of ETL transformations, data validations and stored procedures.
• Tuned several slow running queries in production. Implemented Indexes and re-indexed to achieve time performance.
• Responsible for creating parameterized, cascading, configuration, drill down, rollup reports using SSRS and deploying them into server using report builder.
• Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Extensive experience in migrating database from SQL Server and
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Using reporting services (SSRS) generated various reports.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 databases.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL Enterprise manager, Crystal Reports, MS PowerPoint, MS Access 2000 & Windows 2003/2000 platform, DTS, SSIS, SSRS.

SQL BI/SSIS/SSRS Application Developer

Responsibilities:

• Identified the data source and defined them to build the data source views.
• Created SQL Server Reports using SSRS 2005.
• Generated reports using global variables, expressions and functions for the reports.
• Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts.
• Identified and worked with parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Responsible for transferring the data using SSIS packages.
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using control flow tools and data flow tools and then verify it.
• Developed, monitored and deployed SSIS packages.
• Developed SSIS packages using various transformations such as conditional splits, fuzzy look ups, aggregations and multicasting.
• Analyzed reports and fixed bugs in stored procedures.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Created complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Monitored scheduled jobs and alerts.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Environment: MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005, Erwin 4.1, Windows Server 2003.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Involved in gathering business requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2005.
• Created SQL server reports using SSRS 2000 while identifying the data source and defining them to build the DSV’s.
• Analyzed the existing data and performed the migration steps to SQL Server 2005.
• Used different tasks, transformations, containers and source/destination components to create SSIS packages.
• Performance testing on Store procedures, Indexes.
• Created queries for generating drill down, critical drill- through reports in SSRS 2000.
• Designed and implemented stylish report layouts.
• Generated reports using global variables, expressions and functions for the reports.
• Identified and worked with parameters for parameterized reports in SSRS 2000.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Developed complex stored procedures, triggers, cursors, tables, indexes, constraints, views and other SQL joins for applications.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Responsible for deploying the generated reports.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Environment: SQL Server 2000, Windows 2000/XP SQL Server 2005, SQL Server, Business Objects 5.x/6.x, Informatica 6.x/7.x SQL Query Analyzer, SQL Developer edition.

Confidential

SQL Server Developer

Responsibilities:

• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Written stored procedures and SQL scripts in SQL server implement business rules for various clients.
• Written T-SQL queries for the retrieval of the data.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and debugging T-SQL, stored procedures, views and user defined functions.
• Data migration (import & export - BCP) from text to SQL Server
• Developed administrative tasks of SQL server of performing daily backups and recovery procedures.
• Error handling using Try-Catch Block.
• Performed extensive data extraction from web and other sources and handled data preparation missing values, formatting, transformations using SSIS.
• Normalization and De-Normalization of tables.
• Developed backup and restore scripts for SQL Server 2005.
• Installed and configured SQL Server 2005 with latest service packs.
• Customized the stored procedures and database triggers to meet the changing business rules.
• Implemented indexes for performance tuning.
• Data loaded into the database using SSIS 2005 from flat files.
• Worked with the developing team in the writing functions in Visual Basic 6.0 for upload download functionality, data transfer and migration.
• Prepared daily and weekly status reports and collaborated with other team members.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, triggers and maintained referential integrity.

Environment: SQL Server 2005, SQL Server 2000, XML, MS Excel, MS Access, DTS Designer.