SUMMARY

• More than 11 years of experience as Confidential BI developer, database developer and data analyst with Confidential SQL Server 2016/2014/2012/2008 R2/2008/2005, SSIS/SSRS/SSAS, OLTP, OLAP (Different environment such as Production, UAT, and development) and Power BI in various domains.
• Participated actively in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, go live and Post Go Live Support.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes forlarge - scaleDataWarehouses usingDataTransformation Services (DTS) and SSIS with MS SQL
• Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Optimizing long running ETL packages by using different mechanisms.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Migrateddatain various formats like text files, Excel spreadsheets etc. to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience loading 1TB of data from multiple sources converted from text fields to database data types, transferred over the network, and inserted into a single destination server involving multiple partitions
• Experience working on huge data, millions of records in a table.
• Sound knowledge ofDataMarts, OperationalDataStore (ODS), OLAP, dimensionalDataModeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables) using Analysis Services.
• Experience in Providing the cube level security (Datalevel, Column level)
• Expert in creating various types of complex reports using SSRS (SQL server reporting services) such as Drill-Down, Parameterized, Cascading, Conditional, Matrix, Ad-hoc, Sub-Reports, and Charts.
• Extensive knowledge in Administering, Managing and Troubleshooting Reporting services.
• Efficient in creating Sub-Queries and Joins for complex queries linking multiple tables and Exception Handlers.
• Expertise in Mergingdatafrom various HeterogeneousDatasources, Populating Dimension and Fact tables inDatawarehouses andDataMarts, Cleaning and Standardizingdataloaded into OLTP and OLAP databases using SSIS.Created shared dimension tables, measures, hierarchies, levels and aggregations on MS OLAP/ Analysis Server (SSAS).
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Hands-on development experience working with large volume db. Strong knowledge of table partitions, high performance loading and data processing. Practical experience to decide between DB vs. ETL processing OR both.
• Experience in using Team Foundation Server tool.
• Excellent problem solving, multitasking, business analytical and critical thinking with the ability to work on fast based environment.

TECHNICAL SKILLS

Modeling Tool: MS Visio

Methodologies: SDLC Waterfall, Scrum, Agile methodology.

BI Tool: SSIS, SSAS, SSRS, Report Builder 2.0/3.0, Power BI

Database Tools: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), Team Foundation Server.

GUI /Tools: MS Word, MS Excel, MS PowerPoint.

Database & Query Tools: SQL Server 2014/2012/2008/ R2/2005, Oracle 10g, MS Access.

Operating Systems: DOS 6.22, Windows 98/95, Windows XP, UNIX, Windows 2007.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. MSBI/ Power BI Developer

Responsibilities:

• ES XF uses data from a variety of source databases which contain data pertaining to a large variety of content sets including Financials, estimates, Equity prices and Company ownership. So, created SSIS packages to export huge data containing over 10 million records into Sql server database which has 10 partitions including PRIMARY FILE GROUP.
• Worked on Subscribers and Publications as part of Replication scripts. Data is delivered into the XF feeds databases through replication set up on the tables containing data to delivered via XF.
• Involved in Analyzing, designing, building & testing of OLAP cubes withSSASand in adding calculations using MDX.
• Optimized MOLAP Cubes by partitioning them, Designing Aggregations, implementing Hierarchies and Calculated Members.Worked on MDX queries to access Cubes.
• Extensively worked on ETL to transform data and load it into the DWH.
• Real-time replication transfers the source data tables to XF environment servers and these tables have CDC in place. So, worked on CDC as part of it.
• XF delivers this data to clients in subscribed ‘packages’. Each package typically has two forms - full and transactional delivery. So, worked on delivery packages using SSIS features.
• Utilized GoldenGate for data replication where data is originated from both Oracle and SQL Server data sources.
• Configured data partitioning/table partitioning on large tables containing millions of rows in Data ware house databases for better performance and performed Data Compression on large tables to reduce the Database size.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS 2012.
• Created complex sql scripts to implement Initial load and Incremental load of tables.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
• Worked on SSRS 2016 to build parameterized, drill- down, interactive reports and dashboards for Business users to make decisions.
• The XF metadata is used by the ES XF Engine to generate the feeds, to populate the FeedConfig file that is distributed with the data files, to create and maintain data tables etc. Worked on the implementation logic to achieve it.
• Implemented the project using Agile/SCRUM methodology.

Environment: SQL Server 2016, T-SQL, SSAS, TFS, SSIS, SSRS, VSTS.

Confidential, Pittsburgh, PA

Sr. MSBI Developer

Responsibilities:

• Designed, developed and tested variousPowerBIvisualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• As aPowerBISME responsible for the design, development and production support of interactive data visualizations used across the company.
• Migrated data between different heterogeneous sources such as flat file, Excel and SQL Server using SSIS, BCP and Bulk Insert. Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources.
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard.
• Excellent SQL skills for daily testing of data using various SQL queries.
• Created calculated columns, wrote complex measures using Data Analysis Expression Language (DAX)
• Proficient in workwith large volumes of data (millions to billions of rows)
• Managed PowerBIPortal - Data refreshes / User management and set up gateway data refresh.
• Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, Table Calculations.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by usingPowerBI.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Optimize various SQL queries to make the reports run faster.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
• Create nested, conditional subgroups and formatting features in reports.
• Create Sub reports called from the main report to implement the business logic.
• Generate reports with parameters, sub reports, cross tabs, charts.

Environment: SQL Server 2016, T-SQL, SSIS, SSRS, Power BI, VSTS, Jira

Confidential, Oaks, PA

Sr. MS BI Developer

Responsibilities:

• Gathered end user’ Confidential requirements, Developed Logical Model, and implemented requirements using SQL server 2012/2008 R2.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Worked closely with project stakeholders and staff to understand requirement specifications new applications and redesigning existing applications.
• Prepared project Progress Report and Status Reports and submitted it to Top management on weekly basis.
• Created Data Flow Diagram (DFD) and Flow Charts to display the flow of information in the new system.
• Developed SQL scripts for administration task.
• Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Imported data from different databases (oracle, MS access etc.), build and scheduled packages, and defined integration flow using SSIS (SQL server Integration Services).
• Created ETL (Extract, Transform, and Load) packages to validate and load data in to data warehouse, database, and data marts.
• Designed and implemented parameterized, drill-through, drill-down and tabular reports using SSRS.
• Developed crossed reports, sub-reports and matrix in SSRS.
• Implementing customer scenarios in test environment providing best practices, good withAzure service model andAzureResource Model.
• Good understanding onAzureArchitectural components, Good understand and Experience onAzureVarious Services.
• Created complex queries to build the dataset required for developing the SSRS reports.
• Implemented/Developed multi parameterized reports using Report Builder and SSRS allowing users to make selections before executing the reports and making it more users friendly.
• Created different visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables.
• Provided 2 weeks training as a part of knowledge transfer on SSRS and SSIS to the client in order to modify existing and develop their own ad-hoc reports and SSIS package.
• Designed, developed and implemented database systems and Stored Procedures based on Client requirements.
• Involved in database Schema Design, development and executed stored procedures Using Batch files.
• Built integrated reporting tools (Using Confidential Power BI) with data from Sales, Marketing, and Finance systems.
• Implemented the project using Agile/SCRUM methodology.

Environment: SQL Server 2014/2012, T-SQL, Windows 7, SSRS, SSAS, SSIS, Jira, Power BI, Azure, MS Visio, Team Foundation Server (TFS).

Confidential, Oaks, PA

DB Team Lead

Responsibilities:

• Created Data Flow diagrams and flow charts to display the flow of information in the system and make users understand the functionalities.
• Worked with design and admin team to design physical database and its modifications.
• Responsible for project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
• Performed Data Analysis and Data profiling using SQL on various sources.
• Collaborated with fellow team members through Team Foundation Server (TFS) for effective project management, which includes work issues and track on the update of versions.
• Designed/build/deployed the SSIS package to import data from different data sources and performed ETL process before loading the data in to data warehouse using SQL server integration services (SSIS).
• Created ETL SSIS packages both design and code to process data to client databases.
• Created SSIS template for developing SSIS packages to dynamically deploy the packages into the development, Testing, and production environments.
• Worked with Team Foundation Server (TFS) to report source code for Packages in Visual Studio 2012.
• Created different formats of the reports using SSRS as per the end user and business requirements.
• Worked on Confidential Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Performed system testing for the SSIS packages and SSRS reports.
• Used Notification services to generate error messages and notify users through e-mails.
• Participate in service operational reviews, ensuring SLA’ Confidential are met as per Clients Requirement.
• Design, develop and implement database systems and store procedures based on client requirements.
• Ensure data quality and integrity in databases by DBCC command.
• Designed physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for warehouse system.
• Worked on DBA task such as providing access, established ODBC connection.

Environment: SQL Server 2012 R2, T-SQL, Windows 7, SSRS, SSIS, Team Foundation Server (TFS), Power BI, MS Visio, SharePoint, Jira, SCRUM.

Confidential, Redmond, WA

Sr SQL/BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Documentation of developed BI solution as a part of knowledge transformation.
• Analysis of business requirement and various source systems for data and metadata information.
• Responsible for preparing technical specification based on functional requirement.
• Prepared unit test cases based on functional and technical specifications.
• Performed Data Analysis and Data profiling using SQL on various sources.
• Implemented and executed SSIS 2008 packages to import/export data from the different source to perform the ETL process.
• Used different SSIS transformations such as RecordSet destination, For Each Loop container, Multicast Transformation, Derived Column Transformation to create new column, Conditional Split Transformation to split data flow using Business Intelligence Development Studio (BIDS).
• Created SSIS package which implements Data Profiling using SSIS Expressions, Variables, Expressions and SQL Server based Package configurations
• Modified the existing SSIS packages to increase the performance of the packages.
• Experience in DAX language for calculations and data analysis on data in power pivot and Power BI.
• Used Power BI for interactive visualizations and Data Analysis purposes with SSBI capabilities.
• Created and modified the existing SSRS reports based on T-SQL using Business Intelligence Development studio (BIDS).
• Used and defined reports Parameters, created Parameter Cascading to populate sub-reports, drill down reports, and drill through reports.
• Created PerformancePoint based Dashboards having Web Parts of SSRS Report, Pie Chart, Funnel Chart, and bar charts.
• Expert in Implement, deploy and configureAzurewebsites, configure diagnostics, monitoring and analytics onAzurePlatform along with scale and resilience forAzureWeb sites.
• Reviewed, performed unit and system testing, and fixed bugs for SSIS package, and reports using SQL 2008 Business Intelligence Development studios.
• Identify improvements to the services provided, based on the SLA and KPI data collected.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Created store procedure, functions, views, index to handle database automation task.
• Developed Database structures, store procedures, DDL triggers and user defined functions to optimize the database performances.
• Experience with KPI reporting and dashboards to support decision-making and performance tracking process.

Environment: SQL Server 2014, Power BI, T-SQL, SSRS, SSAS, SSIS, Azure.

Confidential

Sr SQL Developer/Analyst

Responsibilities:

• Gathered requirements and prepared business requirement documents (BRD).
• Analysis of the requirements and providing estimation.
• Development of new process.
• Unit Testing.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
• Created Database Objects - Tables, Indexes, Views, User defined functions, CTEs, Cursors, Triggers, Stored Procedure and Constraints.
• Worked on Deploying Packages and providing security while deploying.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Tuned, monitored and maintained SQL Server Jobs.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.

Environment: SQL Server 20012, BIDS, T-SQL

Confidential

SQL Developer

Responsibilities:

• Analysis of the requirements and providing estimation.
• Development of new process.
• Unit Testing.
• Checking the coding standards using checklists.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Tuned, monitored and maintained SQL Server Jobs.
• Implemented database management techniques that include backup/restore, import/export and generated scripts.
• Involved in Query Optimization, Performance Tuning and rebuilding the indexes at regular intervals for better performance.
• Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
• Worked in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• DefinedCalculated members,named sets and executed other script commandsusingMDXexpressions.
• Developed many small and complex packages to perform ETL Operations.
• Worked on Deploying Packages and providing security while deploying.
• Experience in maintaining SQL Server jobs and involved in developing\maintaining SSIS packages and SSAS cubes.
• Used Dimensions, Measure Groups, Calculations, Key Performance Indicators (KPI), Partitions, Perspectives and Actions while developing SSAS Cubes.
• Supporting customer ad-hoc requests.

Environment: s: SQL Server 2012, BIDS, T-SQL

Confidential

SQL Developer

Responsibilities:

• Analysis of the requirements and providing estimation.
• Development of new process.
• Unit Testing.
• Checking the coding standards using checklists.
• Implementing new enhancements in the existing functionality meeting given timelines and with agreed service levels
• Develop SQL Server Agent jobs and packages to populate data.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Created and manipulated many small and Complex packages to perform ETL operations.
• Supporting customer ad-hoc requests.

Environment: Windows Server 2008, SQL Server 2008, SSRS, SQL Server Management Studio

Confidential

SQL Developer

Responsibilities:

• Analysis of the requirements and providing estimation.
• Unit Testing.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Worked on Deploying Packages and providing security while deploying.
• Tuned, monitored and maintained SQL Server Jobs.

Environment: Windows Server 2005, SQL Server 2005, SSRS