SUMMARY:

• Around 9+ years of total professional experience as a MS SQL BI Developer, ETL Developer in various industrial domains like Insurance, Finance, Banking and Health Care.
• Experience in developing BI Applications utilizing SQL Server, BI Stack, Power BI and Tableau.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting inSQLServer with expertise on data normalization.
• Conversant with all phases of the Software Development Life Cycle (SDLC) especially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.
• Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools etc.
• Good understanding in Database and Data warehousing concepts (OLTP & OLAP).
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experienced inSQLServerReporting Services (SSRS),SQLServerIntegration Services (SSIS), Data Transformation Services (DTS) andSQLServerAnalysis Services (SSAS).
• Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MSSQLServerSQLtools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP.
• Used VB scripts in the script task in SSIS packages.
• Developed dashboards and key Performance Indicators (KPI) withSQLServerReporting Services (SSRS) and PowerBI.
• Worked on PowerBIand prepared dashboards using Tableau to make it more attractive.
• Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications.
• Highly knowledgeable in Designing, Developing and deploying various kinds of reports using SSRS using relational data.
• Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Scheduled & distributed reports in multiple formats usingSQLServerReporting Services (SSRS) in Business Intelligence Development Studio.
• Expertise inSQLServerAnalysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Experience in Reporting services, Power BI (Dashboards Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services.
• Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little .

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, Unix

Languages: C, Python 2.7, UML, Visual C++ 6.0, VB 6.0, C#.Net, VB.Net, PL/SQL, TSQL, R programming and Java EE.

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), Power BI, SAP BI 7.4.

Database: MS SQL Server 2012/2008, Oracle 10g/9i/8i, MYSQL, IBM DB2 7.1/8.0 and MongoDB

Reporting Tools: SSRS 2012/2008, Crystal Reports XI/X/9/8, Power BI, Excel, Qlikview and Tableau

Web Services: SOAP 1.2 and REST 2.0

Web Technologies: HTML, XML, JavaScript, Angular JS, PHP, Shell Scripting, jQuery

Methodologies: Agile, waterfall and Scrum.

Tools: Eclipse 4.2, SAS, UML Rational Rose, Visio, MS Word, MS Excel, MS Access and MS Project

Web/Application Servers: IBM Web Sphere 6.1, JBoss 3.2.x, Apache Tomcat 6.0, Microsoft IIS 6.0

Cloud Environments: Azure, AWS and Google Cloud.

PROFESSIONAL EXPERIENCE:

Sr. MS SQL BI Developer / Power BI Developer

Confidential, Allendale, NJ

Responsibilities:

• Experienced in all stages of BI project & support work (requirements and logical design, physical design, implementation, testing and deployment, maintenance & support)
• Expertise in data gathering, research and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs
• Solid experience in database design or integration experience with SQL Server databases
• Excellent verbal and written communication skills
• Exposure to MS SQL 2008 and SQL 2012 databases
• Hand on experience in writing SSIS packages & exposure to SSRS and SSAS.
• Converted Data Transformation Services (DTS) application toSQLServerIntegrated Services (SSIS) as assigned.
• Designed SSIS Packages to extract, transform, load (ETL) existing data intoSQLServerfrom different environments for the SSAS cubes. Configured Email Alerts for unsuccessful completion of Scheduled Jobs.
• Possess knowledge of Data Warehousing and Business Intelligence concepts, Dimensional Modeling.
• Should have expertise on Database designing Tools, Data Modeling skills
• Responsible for maintaining cubes using SSAS and populate cubes with data.
• Performance tuning of the SQL Server.
• Used ServiceNow for resolving incident tickets and creating change management tickets for production changes.
• Worked in developing Tabular model for Dashboard and Generating the power view Reports.
• Create Power BI dashboard reports as per the business requirements from the legacy reports.
• Monitor and maintain SQL jobs and Power BI reports for data accuracy and worked on performance improvement of the reports.
• Used Microsoft PowerBIPower Query to extract data from external sources.
• Worked on Data visualization and Data analyzation using PowerBI
• Developed custom reports and developed them onserverusingSQLServerReporting Services (SSRS). Generated periodic reports based on the statistical analysis of the data usingSQLServer Reporting Services (SSRS).
• Back end Experience in MSSQLServerdevelopment, writing T-SQLstored procedures, views, triggers, cursors, UDFs.
• Responsible for providing 24x7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.

Environment: MSSQLServer2016/2014,SQLServerIntegration Services (SSIS),SQLServer Reporting Services (SSRS), Power BI, Business Intelligence Development Studio (BIDS),SQLServerAnalysis Services (SSAS), SVN (source control), MS Visual Studio.NET, C #, TFS, Visual Studio 14.0/VB.net, VB Script, ETL and Windows 2012Server, ServiceNow.

Senior MSBI Developer

Confidential, Houston, TX

Responsibilities:

• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to centralizedSQLServerdatabases usingSQLServerIntegration Services (SSIS) to overcome transformation constraints.
• Converted Data Transformation Services (DTS) application toSQLServerIntegrated Services (SSIS) as assigned.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using ofSQLServerIntegration Services (SSIS). Created Pivot tables using Power Pivot and power Query.
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse.
• Different data flow and control flow tasks in Business intelligence studios using SSIS.
• Debugged SSIS Packages using Data Viewers and 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-SQLinSQLServer2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views and DML Triggers to support ETL packages. Preparing Dashboards using calculations, parameters in Tableau.
• Performed Provider analysis and gave useful Insights about deposit details from the PowerBIdashboards. Created report schedules on Tableauserver.
• Responsible for creating connections to the Oracle Database for the Source and target tables in Informatica to create the sessions. Creating reports usingSQLReporting Services (SSRS) for customized and ad-hoc Queries.
• Developed dashboard reports using Reporting Services, Report Model using Report Builder.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart and matrix report). Created drill down and drill up in worksheets in tableau.
• Designed SSIS Packages to extract, transform, load (ETL) existing data intoSQLServerfrom different environments for the SSAS cubes. Configured Email Alerts for unsuccessful completion of Scheduled Jobs.
• Used Performance Monitor andSQLProfiler to optimize queries and enhance the performance of database servers.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MSSQLServer.
• Experienced in working with agile methodology.
• Used Microsoft PowerBIPower Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Worked on PowerBIand prepared dashboards using Tableau to make it more attractive.
• Experienced in Data visualization and Data analyzation using PowerBI.
• Installed On premise data gateway and scheduled daily data refresh in PowerBI.
• Created Calculated Columns and Measures in PowerBIand Excel depending on the requirement using DAX queries.

Environment: MSSQLServer2016/2014,SQLServerIntegration Services (SSIS),SQLServer Reporting Services (SSRS), Business Intelligence Development Studio (BIDS),SQLServerAnalysis Services (SSAS), Power BI, SVN (source control), Tableau, Informatica, MS Visual Studio.NET, C #, TFS (SharePoint), Visual Studio 14.0/VB.net, VB Script and Windows 2012Server.

Sr. SQL BI (SSIS, SSAS, SSRS) Developer

Confidential, Houston, TX

Responsibilities:

• Conducted DB management, Performance measurement and Performance tuning for new databases by usingSQLProfiler, Data Engine Tuning Advisor and Index Tuning Wizard.
• Designed Star Schema (identification of facts, measures and dimensions) and Snowflake Schema.
• Development and Creation of Complex Stored Procedures, Triggers and Functions.
• Fine-tuning Stored Procedures to improve the performance by removing the unnecessary cursors.
• Usage of Active Directory to identity management design for providing strong authentication and authorization for internal and external websites.
• Management of T-SQL Views, Cursors, Index statistics, Tables and query optimization using execution plan for tuning the database.
• Implemented different types of constraints on the tables.
• Usage of Try, Catch and error for exception handling.
• Development of physical and logical data modeling tools such as Erwin and ER/Studio.
• Generation of periodic reports based on statistical analysis of data usingSQLServerReporting Services (SSRS).
• Creation of Cross Tab Reports, Drill-down, Drill-through and Sub-Reports using RDL.
• Used PowerBIPower Pivot to develop data analysis prototype, and used Power View, Power Map and Power Pivot to visualize reports.
• Used Microsoft PowerBIPower Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Managed upgradation of DTS packages to SSIS packages.
• Used the SSIS Import/Export, migrate the Heterogeneous Databases such as Access database, Oracle and flat files toSQLserver2014.
• Worked in developing Tabular model for Dashboard and Generating the power view Reports.
• ConfiguredSQLmail agent for sending automatic emails when a SSIS package is failed or succeed.
• Developed multi-dimensional objects (cubes, Dimensions) using SSAS.
• Expert in creating Star schema cubes using SSAS.
• Involved in analyzing, designing, building & testing of OLAP cubes with SSAS 2014.
• Responsible for maintaining cubes using SSAS and populate cubes with data.
• Involved in development of ASP.NET/ C# /SQLServerWeb Applications.
• Installed and ConfiguredSQLServerActive/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.
• Responsible for providing 24X7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Configured replication servers and transactional replication between production & standbyserverfor disaster recovery.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: SQLserver 2008/2012/2014 Enterprise Edition, SSRS, SSIS, SSAS, PowerBI, .NET Framework, C#, ASP.NET, ADO.NET, Oracle 11g/10g, Visio, MS IIS, XML, MS Excel, Access and Visual Source safe.

MS SQL BI Developer

Confidential

Responsibilities:

• Involved in writing scripts for the client's requirements for reporting purposes.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion ofSQLServerIntegration Services (SSIS).
• Responsible for deploying/scheduling SSIS packages as per schedule.
• Published migrated data using SSIS (SQLServerIntegration Services), DTS Wizard (Data Transformation Services) Tool through data flow tasks, look up transformations and script tasks.
• Developed theSQLServerIntegration Services (SSIS) packages to transform data fromSQL2008 to MSSQL2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially usingSQLServerAgent job.
• Back end Experience in MSSQLServerdevelopment, writing T-SQLstored procedures, views, triggers, cursors, UDFs.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data fromSQLServerand exported to Excel Spreadsheets and vice versa.
• Experience in SSIS script task, look up transformations and data flow tasks using T-SQLand Visual Basic (VB) scripts. Created ETL packages using SSIS to extract data from different data sources reformats the data and load the reformatted data into destination tables.
• Used Scripts task for Data Flow and Error Handling in SSIS.
• Generated Monthly, Yearly, Quarterly and daily reports inPOWERBI.
• Worked and Joining the query's and merging the tables inPOWERBI.
• Used reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS 2012.
• Developed several stored procedures to handle large amount of data manipulation.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder,SQL ServerReporting Services (SSRS) 2008/2012
• Interacted with the Business Admin and gather the requirements and analyzed them.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Written queries for the drill down reports and deployed the generated reports on to theserverusing MSSQLServerReporting Services (SSRS).
• Purchasing, setting up, and configuring a TableauServerand MS-SQL2012serverfor Data warehouse purpose.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data intoSQLServerfrom different environments for the SSAS cubes.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) usingSQLServerAnalysis Services (SSAS).

Environment: SQLServer2008/2012, SSIS, SSRS, SSAS, T-SQL, Access, Tableau, TableauServer, Excel, Visual Studio, Data Analyzer, Business Objects 6.5, ER Win 4.0, Visual Studio.NET 1.1, IIS, ASP, C#, Oracle 9i.

SQL BI Developer

Confidential, Birmingham, AL

Responsibilities:

• Extracted data from various sources likeSQLServer2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• Developed free-form reports using reports using MS-SSRS tool for consulting multiple reports into single report delivered in .pdf format to the power users.
• Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Worked on SSIS (DTS, DTSX) packages for Data Integration Services. Used SSIS to produce a Data Mart for reporting.
• Extensively used System variables and created User-Defined variables for SSIS packages.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Developed custom reports and developed them onserverusingSQLServerReporting Services (SSRS). Generated periodic reports based on the statistical analysis of the data usingSQLServer Reporting Services (SSRS).
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Created reports using stored procedure and experience in building reports on Analysis Services cubes (SSAS).
• Worked with Report Builder 2.0, Report Models and Ad Hoc reports and worked with Tableau desktop, Tableauserverand Tableau reader in various versions of Tableau.
• Managing the ReportServercontents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: SQLServer2012/2008 R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS. SSAS, OLAP, XML, SharePoint, Agile, Visual Studio 2010, .Net Framework 3.5, Window 8

SQL BI Developer

Confidential

Responsibilities:

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MSSQL Serverby using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, ExecuteSQLTask, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors usingSQLServerIntegration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share PointServerwith SSRS and deploying SSRS reports on to Share PointServer.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Create and edit alerts on Reports, as per User request.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Provide on call support after reports are deployed to production.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Worked with development teams in the design of physical databases and in modification.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies.
• Experience in writing T-SQLscripts, dynamicSQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.

Environment: SQLServer2008 Enterprise Edition,SQL, Enterprise manager, Crystal Reports, UML, VB.NET, MS PowerPoint, MS Project, Oracle.

SQL Developer

Confidential

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQLin Development and Production environment forSQLServer.
• CreatedSQLscripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts.
• Involved in performance tuning and monitoring of both T-SQLand PL/SQLblocks.
• Wrote T-SQLprocedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Involved in performance tuning using indexing (Cluster Index, NonCluster index) tables.
• Performance tuning ofSQLqueries and stored procedures usingSQLProfiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Involved in regression testing, evaluating the response times, and resolving the connection pooling issues.

Environment: SQLServer2008, T-SQL, PL/SQL, TOAD, Forms 6i and reports 6i.