SUMMARY

• Over 10+ 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 domain.
• Participated actively in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, go live and Post Go Live Support.
• Experience in different phases of Project Life Cycle (Analysis, Design, Implementation, Testing, and Debugging new/existing client - server-based applications.
• Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Expert in designing (development) and deployment of SSIS package from various sources like MS access, oracle, Excel, Confidential sql server, flat file, and XML.
• Proficient in performing various SSIS data transformation task such as Look-ups, Fuzzy Look-ups, Aggregate Functions, Merge Join, Conditional Spilt, Data Conversion, Derived Column, Event Handlers, and Error Handlers etc.
• Proficient in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS packages using SQL server agent.
• 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.
• Expert in Designing and deploying reports on the portal as per the end user requests using web interface and report manager.
• Experience in reporting services configuration manager to configure and maintain Report Manager, Report server, Send emails to the end user, and Scheduling reports.
• Very Good experience in Creating OLAP cubes, Drill Down reports and Sub Reports using SSAS SQL server analysis Services.
• Proficient in Data mining models, deploying and Processing SSAS objects.
• Good Understanding of Data marts, Data warehouse, Operational Data Store (ODS), OLAP, Data modeling like Dimensional data modeling, Start Schema Modeling, Snow-Flake Modeling, Fact and Dimensional table using SSAS.
• Proficient with T-SQL (DDL, DML, DCL, and TCL) in implementing Complex Stored Procedure, Indexes, Views, Table Variables, Triggers, Nested Queries, Joins, Cursors, and user and system defined functions
• Excellent experience in MS SQL Server database and ETL capabilities using SQL Server Business Intelligence Studio (BIDS) and SQL Server Management Studio (SSMS).
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Experience in creating visualizations and reports using Power BI.
• Experience in using Team Foundation Server tool.
• Collaborated with Business Analysts, Web development team and End-users on database solutions.
• Excellent problem solving, multitasking, business analytical and critical thinking with the ability to work on fast based environment.
• Good experience of implementing iterative Software Development Life Cycle (SDLC) using waterfall and Scrum Methodologies.

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

Snr. DB Developer

Responsibilities:

• Gathered end user’ Confidential requirements, Developed Logical Model, and implemented requirements using SQL server 2016.
• Worked on Subscribers, Publications for Replication scripts.
• Created sql scripts for initial and incremental loads into production of all the tables.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Worked on script task, containers to logically execute the SSIS package to improve performance and execution time.
• Worked closely with Upstream and downstream teams to make sure the system doesn't break and for a smooth flow through of changes.
• Thorough understanding of Impact analysis to make sure the flow of data doesn't break from the dependency system.
• Handled Offshore and took the responsibility of the DB team to sync up with other developers, QA and Business analysts of the team.
• Interacting with Business Analysts and Developers in identifying the requirements, designing and implementing the Database Schema.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Interacted with various Businesses, Management and IT units and analyzed business & functional requirements.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Developed packages in SSIS with error handling.
• Submitted and participated in daily defect review meetings emphasis was to help reduce the quantity of defects not being detected prior to UAT.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
• Implemented the project using Agile/SCRUM methodology.

Environment: SQL Server 2016, T-SQL, SSAS, SSIS, 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.
• 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.
• 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.

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: s: 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.
• 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: s: 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: s: 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