SUMMARY:

• Having 7 years of experience in MSBI tools, SSRS, SSIS and SSAS and Database design, development and administration using MS SQL Server 2012 and 2008 in Production, Test, Development environment.
• Experience in Information Technology with a strong background in Database development and Data warehousing using MS SSIS/SSAS/SSRS.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions (SCD) and Dimensional Modeling (Kimball/Inmon methodologies, Star Schema and Snow Flake Schema).
• Proficient in designing Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Good understanding of software development process like Waterfall, Agile within the SDLC (Software Development Life Cycle).
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
• Experience in database design & development, database programming, data modeling, business process analysis, and application development.
• Experienced in TSQL (DDL,DML), documenting, coding, programming, modifying and implementing Business Intelligence solutions using SQL Server.
• Expert in Migrating SQL 2000 databases to SQL 2005 and SQL 2008 and SQL 2012 using migrating services.
• Expertise in creating Complex Stored Procedures, Queries for the application team and for the end users based on the business requirement.
• Performed data profiling and analysis of structured and unstructured data.
• Expert level skills in Replication, Data Modeling (Physical and Logical), Star Schema, Snowflake schema, Data Mapping, Installation and Configuration, up gradation from previous versions, Table Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, Database Objects authorization, DTS, Objects creation such as Tables, Views, User created Data Types, Stored Procedures, Triggers.
• Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats and Power View Reports with multiple views featuring tiles, and a number of visualizations, using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Extensive experience in design techniques, ETL (SSIS) processes, relational database theory, N-Tier development.
• Experienced in creating DTS Packages and data designer usage and Migration of DTS packages to SQL Server integration services (SSIS).
• Experienced in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS packages with T-SQL Stored Procedures.
• Development skills in stored procedures, Ad-Hoc SQL Queries, triggers, UDF, custom DTS packages.
• Created a report model on SSAS cubes.
• Experience Connecting SSAS with either SSRS or Excel tables.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).
• Expertise in SQL Server 2005 Analysis Services (SSAS) delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Understanding of various source transformations, including flat files, XML and relational systems.
• Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS) Power Pivot BI Semantic Tabular model.
• Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.
• Experience in working on OLAP/OLTP data warehouse and data mining.
• Very good experience in using data modeling tools like ER-win, MS Visio etc.
• Extensive Knowledge in HTML, XML, IIS software development life cycle
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Created SSIS packages to perform Extract, Transform and Load data from various different sources and destinations like Excel, Access, CSV, SharePoint, Oracle, Teradata, Xml files, X12files and flat files using tasks and transformations provided by SSIS.
• Experience in MS SQL Server installation, configuration, performance tuning, error handling, SQL Profiler, query optimization, client/server connectivity, back-up/recovery, running Database Consistency Checks (DBCC).
• Facilitating the use of code management system using Team Foundation Server (TFS).

TECHNICAL SKILLS:

SQL Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Profiler, Sybase 12.5 ASE.

Languages: C, C++, SQL, T-SQL, PL/SQL, HTML, CSS, AJAX, XML

Operating Systems: WINDOWS 95/2000/2003/ XP/VISTA/7/8/8.1/UNIX, LINUX.

Databases: MS-SQL Server 2012/2008 R 2/2008/2005/2000 , MS-Access 2007/2010, Teradata and AS400

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), dashboards tools, web tools.Scripting: HTML, DHTML, XML, Shell Scripting, Power Shell 2.0.

Reporting Tools: SSRS, SSAS, Crystal Reports, Report Builder 3.0., Pyramid, Tableau. Power View

BI Tools: Power BI Desktop, Power Query Power View, Power Pivot, Power Maps

DB Utilities and design tools: SQL Server Management Utility, SQL Profiler, Query Analyzer, MDX scripting.

Application Software: Visual Studio 2008/2012/2012 , SharePoint, SQL dialect, MS Office Tools, TFS.

Methodologies: Agile, Waterfall.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

MS SQL Server Developer/SSRS/SSIS/BI Developer

Responsibilities:

• Primary responsibility are designing, developing and implementing SSRS reporting for Business Intelligence, Financial and Operational Reporting for the enterprise.
• Designed and development of SSRS reports based upon SSAS cubes and other warehousing objects.
• Maintain internal SSRS dashboard reports for immediate management, business analysts and direct clients.
• Work as a part of Database Management team to ensure data security and best practice adherence for all corporate data.
• Engage in performance tuning of SQL queries and Stored Procedures and provide continuous improvements in BI services.
• Assure integrity of all solutions developed through co-ordination of testing and adherence to company standards and procedures.
• Performing requirements gathering/documentation and logical/physical design of data augmentation processes and coordinate implementation of requested enhancements for the applications.
• Responsible for data management and conversion activities such as Data Assessment, cleansing, extracting, migrating and reconciliation of data using SSIS.
• Create SSIS packages to Load data into Enterprise Data Warehouse (Teradata).
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency.
• Work independently to manage, prioritize and respond to changing deadlines.
• Perform other job related duties and responsibilities that may be assigned from time to time.

Environment: MS SQL Server 2012/2008R2, MS SQL Server reporting services (SSRS), MS SQL Server integration services (SSIS), T-SQL.

Confidential, Arden Hills

SQL Server SSIS/SSRS Developer

Responsibilities:

• Created the project documents, right from the design to the development.
• Developed Data warehouse and reporting solutions using the Microsoft Business Intelligence based tools, services and support (SSIS, SSAS and SSRS).
• Provided on-going support for client in relation to existing reports with respect to their requirements.
• Worked closely with the testing team to create unit test scripts and monitor issues using the ticketing system.
• Designing and developing SQL Server 2008 Databases, Tables, Stored procedures, Views, Triggers.
• Created use cases, user guides, programmer documentation, application administration, and process flow diagrams.
• Created the Table and Matrix reports as per the requirements.
• Written Common Table Expressions (CTE) and used analytical functions while writing stored procedures.
• Performed complex joins to extract data from various tables in the databases
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Fixing the performance related issues in the existing SSRS reports, from database design and report query areas.
• Worked on design, develop test and deployment areas of SSRS report development. And involved in client-project meetings for gathering the business requirements.
• Used the SQL server profiler for tracking run time parameters, user information, execution time etc.
• Performed data conversions from flat files into a normalized database structure.
• Worked on project specification documents, participated in data analysis meeting etc.
• Implemented package configurations, logging, scheduling, error handling, variables etc. while creating the packages.
• Excellent analytical and problem solving skills.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Created Clustered and Non Clustered Indexes on tables, views, and columns.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction, transformation and loading.
• Involved in the SSAS cube design, to create partitions, processing the cube using SSIS package and displaying the data using Excel source.
• Actively involved in improving System Performance by tuning SQL queries and stored procedures by using SQL Profiler, and Index Tuning Wizard.
• Developed and modified complex stored procedure based processes supporting ETL processes in a Data Warehousing environment as well as creating reports in Reporting Services and other data related tasks.
• Worked with customers and/or analysts to define and/or review business requirements for new ETL processes and reports. Design and develop ETL processes and reports that meet team standards and use consistent methodology and development approach. Performed comprehensive unit testing of all work.
• Created and maintain technical designs, data dictionaries, and systems operations documentation.
• Performed data validation before loading different type of data files on daily basis as per defined by business user and worked with monthly new project deployment.
• Used SSIS to transform and load data into SQL database via FTP from XML files, MS Excel as source data
• SQL Enhancement/New Report by adding new data source system for production and scheduled job for the process
• Worked for Functional and Technical design to speed up the process and query optimization.
• Completed change request work to load data with extra columns to understand details data and started new import source to process the data. Worked for Data Truncation and reload as per the requirement to change in import for data quality.
• Executes dashboard and automation for repetitive processing tasks, as well as offers support to upgrade and modify automation.

Environment: MS SQL Server 2008, Oracle 11g, SSIS, SSAS, SSRS, MS Visual Studio 2008, Visual Basic/VBScript, T-SQL, SQL Profiler, SQL Server Management Studio, MS Excel, MS Office, Unix Shell Scripting, Agile software development.

Confidential, Jackson, MI

SQL Server BI Developer

Responsibilities:

• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008.
• Installed SQL Server 2008 and Management tools using SQL Server Setup Program.
• Created SSIS packages for the extracting, transforming and loading the data from SQL Server 2008 and flat files.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012.
• Convert all existing DTS package of MS SQL by adding extra SSIS task.
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Responsible for creating database objects like table, views, store procedure, triggers etc) to provide structure to store data and to maintain database efficiently.
• Created Views and Index Views to reduce database complexities for the end users.
• Perform T-SQL tuning and optimizing queries using SQL server 2008/2012.
• Created indexed generic views to facilitate easy user interface implementation, security, and triggers on them to facilitate consistent data entry into the database.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the legacy databases to SQL server.
• Create complex scripts to do chucking and massaging of legacy data in staging area of SSIS package.
• Schedule Jobs to run SSIS package in night feed to DSS system for fresh day data.
• Wrote standard & complex SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Created demo reports for cash management system form old reports for validation of the data in new database.
• Modified old crystal reports by adding new business requirements using SSRS.
• Created useful user defined functions and multifaceted stored procedures for reporting purposes.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.
• Created Documentation for the packages and scripts and job created to migrate data from legacy system to SQL Server 2012
• Extensively involved in Developing Components for Presentation Layer, Business Layer and Data Layer for Windows based application.
• Build Data Controls and User Controls using C# and are used in UI design.
• Run Import/export wizard to provide CSV and Excel files to mangers for the particular records they want for different meetings.
• Configure Report Manger and run reports on weekly and daily basis.

Environment: SQL Server 2005/2008, SQL Server Integration Services, MS Visio, MS Excel 2003, MS Access 2003, Enterprise Manager, Management Studio, MS SQL Query Analyzer, SQL Profiler and SSRS and Crystal report 9.0, .Net 4.0, WCF, HTML5,Javascript,Asp.net.

Confidential, Boston, MA

MS SQL Server/SSRS/ SSIS Developer

Responsibilities:

• Migrated databases from SQL 2005 to SQL 2008 in production and test environments.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for new and existing applications.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Designed, developed, modified and enhanced the database structures and database objects.
• Used conditional formatting to change the behaviour of the report depending upon the requirement.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Created several SSIS packages in Microsoft Visual Studio 2005/2008.
• Transferred data into various formatted files and immediately notified to business users only on a successful run.
• Tuned several slow running queries in Production. Implemented Indexes to achieve time performance.
• Used config files in SSIS to ease the process of moving the packages across servers (development to production)

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008, MS Excel, MS Windows Server 2003, Mercurial Version Control, Oracle 10g/9i.

Confidential

MSBI Developer

Responsibilities:

• Created stored procedures, user-defined functions, and triggers to implement business logics and data integrity.
• Created UDF, views, tables and generated TSQL script for application.
• Created various type of reports in SSRS with features such as document map, actions, conditional formatting.
• Created dashboards, sub reports, drilldown reports, summary reports, and matrix reports in SSRS.
• Created user defined functions in SSRS using VB script.
• Designed an advanced ETL architecture for the overall data transfer between the OLTP to OLAP with the help of SSIS.
• Developed SSIS packages for data profiling and data cleansing.
• Designed data mappings between sources and staging targets utilizing Star Schema.
• Implemented logic for incremental load using checksum and timestamp functions.
• Implemented the master/child package models to ensure only the master package is scheduled, consequently firing other packages to reduce complexity.
• Resolved SSIS package errors utilizing error logs, breakpoints, checkpoints, and data viewers.
• Enhanced the performance of SSIS packages by configuring several properties / features at control and data flow level.
• Incorporated parameters to configure package properties to migrate SSIS packages from development/testing to production environments.
• Created SQL agent jobs for automating execution of SSIS packages on production server.
• Designed and developed SSAS cube with KPIs, aggregation, calculated members, and partition for reporting.
• Created analytical reports/dashboards from multidimensional modelsto identify critical KPIs utilizing Power BI.
• Collaborated with the project manager and design architect to outline business requirements utilizing JRD sessions.
• Developed TableauReports from various entities like Financial, Transactions, Accounts, Performance, Telecom and Retail operations.
• Participated in JAD sessions to discuss business requirement documents and drafted a functional/non-functional requirements document.
• Facilitated detailed analysis and strategic planning within the organization with analytical reports.
• Tested the data with complex queries, joins and sub queries.
• Deployed reports on report server/SharePoint server and resolved deployment related issues.
• Established report delivery schedules by configuring standard/data driven subscriptions.

Environment: SQL Server 2008/2005, T-SQL, SSMS, MS Excel, Erwin, SSIS, SSAS, SSRS, SharePoint, Power BI, Power View, TFS, DTA, SQL Profiler