PROFESSIONAL SUMMARY:

• Experienced MS Business Intelligence Developer with 7+ years of experience working with BI applications such as SSMS, SSIS, SSRS, SSAS in Development, Test and Production Environments. A wide experience working in different industry domains such as healthcare, service, insurance and finance.
• SQL/ETL Developer having 7+ years of IT experience in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
• Experience in Information Technology with a strong background in Database development and Data warehousing using MS SSIS/SSAS/SSRS.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2016/2014/2012/2008 R2/2008.
• 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)
• Experience in report development using SSRS and creating various types of reports like Dashboard, Drill Down/Through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in SQL server MDS 2012 features including hierarchies, granular security, transactions, data versioning, and business rules.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV and flat files, MS Access, SAS, Oracle, DB2, SalesForce, CRM) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Derived Column, Merge, Merge Join and Union all.
• Experience in working with Web services to handle SQL connections.
• Strong skills on deploying and operating large scale cloud infrastructure and application services in AWS, Azure, SAP, Oracle Cloud, Google Cloud, IBM Software and other Cloud providers
• Strong knowledge with Host Scripting to automate routine tasks.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience in Performance Tuning and Query Optimization.
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts and SSRS Reports with PPS.
• Experience in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Expert in creating Parameterized Reports.
• Hands on experience in creating Star Schemas and Snow Flake Schemas.
• Excellent analytical, communication and interpersonal skills and proficient in writing and presenting complex technical concepts, comfortable working independently and with different size of teams.
• Proficient in Software Development Life Cycle (SDLC) process, which includes RUP, Agile and Waterfall methodologies.
• 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.
• Involved in designing and populating data in data warehouse and Cubes (OLAP) using SSAS and SSIS.
• Data Modeler with strong Conceptual, Logical and Physical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents and queries
• Migrated on-premise SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments.

TECHNICAL SKILLS:

OS: Windows XP/7/10, Windows Server 2016/12/08, UNIX/LINUX

Databases: SQL Server 2016/14/12/08 R2, Oracle 11g/8.0i, MS Access 2000/8.0, Teradata 14.0, DB2

Languages: T-SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, MYSQL, HTML, ASP.NET, .NET Frame Work, C#, C, C++, JavaScript

Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script

ETL & Reporting: SSDT 2016/14/12, BIDS 2008R2/08, SQL Server Integration Services (SSIS 2016/ 2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2 R2), PowerBI, SQL Server Analysis Services (SSAS)

Others: MS Office, Crystal Reports XI, Visio, Service Oriented Architecture (SOA), SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, DataStage, Informatica, Hadoop, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, Synergy, HP Quality Center & Jira, Master Data management, Data Quality Services

EXPERIENCE:

Sr.BI Developer

Confidential

Responsibilities:

• As a key member of BI team, delivered the best results to the developmental needs, accomplished successful outcomes by working with SQL, SSIS, SSRS and Power BI.
• Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments.
• Designed SSIS packages and Azure Data Factory pipelines to Extract, Transfer and Load (ETL) existing data into Data Warehouse from different source environments such as ERP, CRM, Azure, AWS, and other systems.
• Supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.
• Gathered, analyzed and documented business requirements and business rules by working directly with end users.
• Strong experience with SQL Server and T-SQL in implementing, maintaining developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands.
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.
• Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into SQL Server from different environment.
• Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling and Error Handling.
• 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.
• Created various types of reports such as sub reports, Tablix and Matrix using SQL Server Reporting Services and created Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created reports on both cascading and standard parameters.
• Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors.
• Worked on Power BI in creating dashboards and reports and visualizing data.
• Used Microsoft Power BI Power 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.
• Used Power Query to acquire data, developed calculated columns and measures using DAX in Power BI desktop for designing rich visuals using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map.
• Shared with user groups, scheduled and maintained the Power BI reports published to the Power BI Service.
• Created SSIS Packages by using advance transformations (i.e., Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate) and used Custom components such as Audit on Pre-Execute, Audit on Post-Execute and Statistics Logging Component.
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for each Loop Container to loop over a Directory to load inbound files coming daily.
• Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
• Created different type of reports which include: Chart report, Sub report, Drill-down report, Drill- through report and parameterized report and deployed and scheduled them in Report Manager to generate all daily, weekly, monthly and quarterly Reports.

BI Developer

Confidential, Waltham, MA

Responsibilities:

• Actively participated in daily scrum meetings, sprint planning/grooming sessions, and discussed new requested features/user-stories/tasks with Business Analysts and updated the status of tasks assigned on Jira.
• Played a main role in the Migration Project, where all data from Legacy SAP Business Warehouse (BW) has been migrated to MS SQL Server Enterprise Data Warehouse (EDW), as well as, all SAP Business Objects Reports have been migrated to Power BI Services Platform.
• Actively participated in development of SSIS ETL packages and underlining complex Stored Procedure to migrate historical data piece of the project from SAP System to MS SQL Server and develop SSIS packages with incremental load logic from all upstream CRM Source Systems.
• Wrote complex SPs/UDFs to clean ‘dirty’ data while migration/transformation from old system to new EDW.
• Contributed to develop the conceptual/logical/physical data modeling of the current EDW, identified the fact tables and it is related dimension (dim) tables and coded them with FK/PK relationships and applied appropriate constraints to ensure the quality and integrity of the data warehouse.
• Developed over 10 separated complex SSAS Tabular Models to supports reports in the areas like Demographics, Income and Expense, Instructor Qualification, Device Utilization, Opportunity Management, Reservation, Endorsements & Checks, and Pricing.
• Developed descriptive and user-friendly Self-Service Models for end users to create their own PBI Dashboards /Reports per their own needs.
• Migrated/re-developed/enhanced over 30 dashboards/reports from SAP Business Objects platform into Power BI Service. Mainly used Direct Query method connecting to above mentioned SSAS Tabular Models as a source. Developed measures with complex dynamic DAX queries to calculate all the required KPIs requested.
• Wrote Power Query (M) scripts to make sure the SSAS Tabular Models are sourcing only the needed data and to improve performance, i.e., smartly used aggregations instead of brining all the underlining data, removed unneeded columns, and filtered unnecessary old data by brining only data for the last 4-5 per end user agreement.
• Created several .rdl reports with Power BI Report Builder to meet the specific requirements of the end users which could not be satisfied by PBI Desktop/Services, i.e., the Managerial Report was supposed to be a single continuous page, with the ability to export to PDF as a continues page.
• Applied row level securities in all Power BI Reports and assigned AD Groups, created Run Books and scheduled and monitored data source refreshes accordingly.
• Handled all the weekly deployment from DEV to QAT/UAT/PROD environments.
• On demand bases provided non-standard and ad-hoc reports requested by management.

Business Intelligence Developer

Confidential, Atlanta, GA

Responsibilities:

• Played a key role in Sprint Planning for Agile Methodology, Feature grooming, and calculated Users Story Points and helped with Backlog prioritization. Performed code reviews for Pull Requests via Azure DevOps and participated in application architecture and design and other phases of SDLC.
• Strong experience with SQL Server and T-SQL in implementing, maintaining developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands.
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures. Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Built reports for different domains such as Finance, Accounting, Management, and other client teams.
• Created Power BI reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. Created reports on both cascading and standard parameters. Worked on Power BI in creating dashboards and reports and visualizing data.
• Accounting Reports included Year-To-Date, Month-To-Date, Period Close reports, Transaction and Snapshot reports for General Ledger, Budget reports, etc.
• Used various formatting techniques and features like interactive sorting, grouping, slicer, bookmarks, RLS, PLS and many others to create user friendly reports.
• Helped clients to convert Excel reports for Accounting Department into Power BI reports by automating the whole lifecycle of report generation. Generated OLTP database objects. designed Data Warehouse. Created ETL processes to automated data flow.
• Built efficient SSIS packages/ADF2 pipelines for processing Fact and Dimension tables with complex transformations by maintaining SCD Type 2/SCD Type 1 historical data.
• Imported data into Synapse using different mechanisms like SSIS, Polybase, Azure Data Factory and stored the imported data in a columnar format to enable distributed querying capabilities to improve performance of OLAP workloads.
• Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and developed and maintained databases across both on-premise and cloud deployments.
• Provided support and guidance to other members of the BI team on separate projects.
• Provided technical documentation for the developed solutions.

SQL / BI Developer

Confidential, Dallas/TX

Responsibilities:

• Used Team Foundation Server to report bugs and to maintain product backlog items. Setup various Team Projects into different Team Project Collections in TFS environment. Tested the data with complex queries, joins and sub queries.
• Developed tables, views, indexes, CTEs, functions and advanced queries for databases. Created complex stored procedures, functions, cursors, and SQL joins for applications. Created Indexes and maintained fill factor for fast and efficient reporting process.
• Involved in performance tuning and monitoring T-SQL blocks. Created the deployment scripts after the development is done for every project.
• Used SQL Server Profiler to monitor for long running queries and tune them to improve performance.
• Developed SSIS packages to bring data from SQL Server, Oracle, Excel, XML, and Flat Files into SQL db. Worked on tasks like Execute SQL, ftp, Send mail, for each loop container, derived column, conditional split.
• Used script task to write C# code to satisfy business rules. Created packages with error handling and used package configurations for deployment. Developed packages to send E mail alert and log into SQL table for any issues (on error).
• Created and Deployed the SSIS packages and scheduled the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Used the Bulk Copy Program (BCP) to load large volumes of data from files into tables.
• Created SSIS packages to transfer data across heterogeneous data sources. Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
• Worked extensively on system analysis, designing, development, implementation, testing of projects.
• Automated manual process using Advanced ETL such as auto extract data from Smartsheet and load it into SQL server using Script task and merge statement.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement using SQL Server Reporting Services (SSRS).
• Involved in Creation of Dimensions using Star and Snowflake Schema in SQL Server Analysis Services (SSAS).
• Involved in defining the source to target data mappings, business rules and data definitions.
• Created Joins and sub-queries for complex queries having multiple tables from different databases involved, daily supported the system wide replication tasks including monitoring, alerting, and problem resolution.