SUMMARY

• 7 years of experience in the analysis, design, development, implementation, testing, and maintenance of database applications in SSRS, SSIS .
• Having good knowledge of SDLC process and excellent analytical, developing and problem - solving skills.
• Experience in data modeling by using normalization techniques and building referential integrity constraints.
• Created SQL Server objects like tables, stored procedures, views, joins, set joins, indexes, functions using T-SQL.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS .
• Good knowledge of performance tuning, query optimization by using indexes & few tips to improve performance to execute complex quires fast. Used display estimated execution plan tools for the same.
• Extensively used reporting services to develop the tabular, matrix, gauge, dashboards, sub reports, parameterized reports, drill down & drill through reports as per the business requirements.
• Extensively used grouping, cascading parameters, paging, column freezing and complex expressions to develop the reports. Deployed SSRS reports and data sources from SQL server data Tools to SSRS reporting server.
• Managed all the published reports using report manager . Controlling the user permissions to access the reports at site level, folder level and report level access.
• Created and maintained standard and data-driven subscriptions to auto generate the reports snapshots at the scheduled time for the given users via email.
• Involved in complete ETL processing of extracting the data, transforming the data and Loading the data using SSIS package executables and transformations .
• Used transformations like data conversion, derived column, conditional split, merge join, look up etc. in SSIS packages . Worked with Agile Programming Methodologies, Waterfall methodologies, Scrum and TDD .
• Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes ( Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema ) using SSAS .
• Experience in RDBMS Concepts, Database Management Systems, Database Physical, Logical design, Data Mapping, Table normalization and Data Modeling.
• Created SSIS packages for data migration from different sources to different destinations like SQL server, oracle, MS access, excel, XML and flat file.
• Having good knowledge of using variables and expressions in packages. Used variables in execute SQL task, script task, for each loop logic, error handling, and precedence constraints.
• Experience of scheduling the SSIS packages execution in SQL server agent (Jobs) and tracking the execution of packages and configuring the email notifications through SQL server agent.
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, S QL Server Analysis Services (Tabular Model), MS Excel etc., to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and P ower Map to visualize reports
• Published Power BI Reports in the required originations and Made P ower BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Design and develop dashboards, KPI scorecards, charts, pivot tables, reports, and reporting systems according to the business requirements.
• Used Power BI Gatewa ys to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data into power pivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Having the ability to work in a fast-paced environment, good team player and can work independently and having strong interactive skill to communicate with end user and development team.

TECHNICAL SKILLS

Programming Skills: T-SQL, C, HTML, CSS, ASP.NET, VB, C#

RDBMS: MS SQL Server, MS Access, Teradata.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, SQL Query Analyzer, ETL, SQL Enterprise Manager, Solution Explorer, Analysis Manager, Reporting Server.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS),PowerBI, Visual Studio Crystal Reports

Operating Systems: UNIX, LINUX, Windows7/ NT & Windows 9x and MS-DOS

S ystems familiarity: OLTP, DSS, OLAP, MDX

Languages: T-SQL, MS SQL, MDX, C/C++, Java, VB, VBA, HTML, XML

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server/T-SQL/SSIS/SSRS/PowerBI Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options. Provided tech team support for data warehouse.
• Designed and developed stored procedures that accept parameters, queries, views, User-defined function, and CTE's necessary to support SSRS reports . Developed and delivered dynamic reporting solutions using SSRS .
• Modified Store Procedure and formulated basic coding and scripting to be utilized for reports.
• Used Joins and Sub-queries for complex queries that involved multiple table from different databases and identified relationship among them. Created and maintained various SSRS report for the business users.
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse .
• Responsible for data cleansing operation for data warehouse in staging environment and identified issue and fix them before entering data in a Data Warehouse.
• Modified the existing SSIS package to meet the changes in user's' requirements.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases . Created various SSIS packages and ETL processes based on the business requirement.
• Responsible for extracting data from various source system like Excel, CSV file, Flat File, SQL server, Banner based on requirement. Analyzed data models, data relationships, and dependencies for greatest optimization.
• Created SSIS package to load data from staging environment to data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, and Slowly Changing Dimension.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the Database on Daily basis using SQL Server Agent. Modified the existing SSIS package to meet the changes in user's' requirements.
• Created various kind of SSRS reports such as parameterized report, sub report, Drill Down report, and Drill Through report for the business users. Created subscription in SSRS to deliver reports to a PDF or excel format.
• Create team specific agile process flow in JIRA to move tasks from one activity to another.
• Worked with Software Development Life Cycle, RDBMS, and Data Warehouse & Data Modeling concepts.
• Created Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Worked with various tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance .
• Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys . Developed ETL programs using to implement the business requirements.
• Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and UDF . Created reports which retrieve data using Stored Procedures that accept parameters.
• Developed and optimized database structures, Stored Procedures, Indexes, Views, and UDF, Common Table Expression (CTEs) to support Power BI and SSRS report .
• Created various SSRS reports like drill down, sub reports, parameterized, multi-valued and various adhoc reports through Report model creation.
• H ighly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, CTE, user profiles, relational database models and data integrity, SQL joins and query writing .
• Managed ETL for extraction, transformation, and loading of data to the destination data mart.
• Developed mappings utilizing SSIS to transform data from multiple sources: Excel, Flat File, and SQL Server to OLTP database. Implemented Incremental loading using checksum and CDC .
• Implemented SSIS packages with loggings and event handlers for error handling.
• Worked on implementing transactions for billing details and checkpoints in the packages for optimizing the performance. Designed the OLAP cube using SSAS for hospital drug analysis.
• Restructured ETL packages with optimized queries and proper transformations for faster data loading.
• Deployed SSIS packages from development server to production server utilizing project deployment model.
• Generated parameterized, cascading parameterized, drill down, and drill through reports.
• Created reports using Power BI if data getting from Azure cloud and web services .
• Optimized embedded queries or stored procedures that generate reports.
• Extensively working in loading fact and dimension tables in Data warehouse .
• Developed T-SQL queries and stored procedures with multiple parameters to created data Sets for reports
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions. ETL development was done using SSIS .
• Design and develop dynamic advanced T-SQL, PL/SQL, MDX queries, VB.NET Scripts, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications. Integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server .
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS 2005/2008 . Involved in Migration of SSRS 2005 to 2008 .
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse . Created packages to migrate data from different data sources to data warehouse .
• Worked on Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files etc. Developed stored procedures to use in SSRS report using dynamic SQL and T-SQL .
• Developed SSIS packages using various Control and Data Flow items to Transform and Load Data using SSIS .
• Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and Modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Created complex stored procedures to use as datasets for Report Design, to generate Adhoc reports using SSRS .
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Expert in creating and developing Power BI Dashboards in to rich look.
• Created Dax Queries to generated computed columns in Power BI.
• Creating Row level securi ty with power bi and integration with power bi service portal.
• Developed profit analysis reports and dashboards by products and customers.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Worked on all types of transformations that are available in Power bi query editor.
• Scheduled Automatic refres h and scheduling refresh in power bi service.
• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
• Created reports using time intelligence calculations and functions.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Executed dashboard setups and data manipulation using DAX.

Environment: MS SQL Server 2008, XP, T-SQL, SSAS, SQL Profiler, Microsoft Dynamics, Agile, Report Builder, T-SQL, SSRS, SSIS, Visual Studio 2005/2008, SSDT, VB script XML, Crystal Reports, Excel.

Confidential

SQL BI Developer

Responsibilities:

• Efficiently used Microsoft SQL server 2005/2008/2008 R2 SQL server management studio.
• Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis. Elicited business requirements through interviews, surveys, prototyping and observations.
• Prepared BRDs (Business Requirement Documents) supporting documents containing essential business elements, detailed definitions, & description of the relationships, to analyze and document business data requirements. Reviewed and Analyzed the Business and Functional Requirement Documents.
• Used SQL server business Intelligence Development Studio to design SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
• Prepared functional specification documents and managed any changes in user requirements with change requests and by keeping track of the requirements through traceability.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server 2005/2008 environment.
• Generated reports using SQL server Reporting Services, and created user friendly templates, indexes, using xml
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications. Developed SQL queries to validate data in tables based on business requirements.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS . Extensive use of T-SQL DDL and DML commands for various applications.
• Developed DTSX packages to extract, transform and load into Campaign database from OLTP database using of SSIS . Created Pivot tables using Power Pivot and power Query . Created report schedules on Tableau server .
• Worked with various SSIS control flow tasks and data transformation tasks as part of ETL .
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in Business intelligence studio using SSIS .
• Debugged SSIS Packages using Data Viewers, Breakpoints . Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views and DML Triggers to support ETL packages . Preparing Dashboards using calculations, parameters in Tableau.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting . Good working knowledge on Agile Projects .
• Implementing an extra level of security by creating views and creating stored procedures to query the confidential data. Worked in development of ETL, maintain and support the enterprise data warehouse system .
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SSRS .
• Analyzed the functional specs provided by the business users and created technical specification documents.
• Active part in maintenance of data cubes for OLAP . Involved in migration of crystal reports to SSRS 2008 .
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports using SSRS 2008 .
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, S QL Server Analysis Services (Tabular Model), MS Excel etc., to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and P ower Map to visualize reports
• Published Power BI Reports in the required originations and Made P ower BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Design and develop dashboards, KPI scorecards, charts, pivot tables, reports, and reporting systems according to the business requirements.
• Used Power BI Gatewa ys to keep the dashboards and reports up to date.
• Created Triggers, Views for Audit and security purposes. Created different types of User-defined functions.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments .
• Worked with POWER SHELL to automate SSIS Package and create report in Excel.
• Involving in creating the packages by using Control Flows, Data Flows and script tasks .
• Scheduling the ETL jobs to run some of them daily and some of them are monthly once
• Fixing the defects in QC as per the tester comments. Launching the report builder for ADHOC reports .
• Worked on Back-end in SQL Server development, writing complex queries, stored procedures, views, triggers, cursors, UDFs. Generating reports using linked reports, sub reports and filters in SQL server reporting services .
• Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams .
• Experience in SQL joins, sub queries , tracing and performance tuning for better running of queries.

E nvironment: Windows server 2005, MS SQL Server 2005/2008, Business Intelligence Development studio (SSRS and SSIS), Microsoft.NET, T-SQL, MS Office Access 2003, VBScript, Erwin and Visio.