SUMMARY

• Microsoft BI developer with over 5+ years of extensive experience in database design, development and administration with MS SQL Server versions 2016/2012/2008 R2/2008 using SSIS, SSRS, SSAS & Power BI at Healthcare, Mortgage, Construction and Retail companies.
• Business Intelligence experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server 2008R2/2012/2014, SSIS, SSAS and SSRS.
• Expertise in Power BI development.
• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
• Strong experience in client interaction and understanding business applications, Optimization and Tuning.
• In - depth technical knowledge with sharp analytical skills to analyze complex business problems and develop, deploy Information Technology solutions that enhance efficiency and productivity.
• Technical experience with design and hands-on programming on diverse technology platforms including RDBMS, Cube design & development, ETL engines, BI Scorecards and dashboards.
• Experience in Project Management and Software Development lifecycle including analysis of business function, software design, specifications and software development, testing and documentation, and planning for redesign or transition to another platform.
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert and Error Handling in SSIS
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

TECHNICAL SKILLS

Platforms: Windows (2000, XP, Vista,7,8), MS SQL Server 2016/ 2012/2008 R2/2008, MS Access

Languages: T-SQL, XML, DAX, Visual Basic.

Applications / BI Tools: Microsoft Data Transformation Services (DTS), SQL Server Integration (SSIS), SQL Server Reporting (SSRS), SQL Server Analysis (SSAS), SQL Server Business Intelligence Development Studio (BIDS), MS Access, SQL SERVER, MS Visio, SQL Profiler, Query Optimizer, DTS Designer, SQL Server Agent, MS Excel, Power BI

Work Flow Tools: MS Visio Visual Source Safe (VSS), Team Foundation Server 2010 (TFS).

Miscellaneous: Visible Analysis and Troubleshooting.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server SSIS/Power BI Developer

Responsibilities:

• Gathered requirements from the user community, write Functional Design Specifications and design documents for development.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Used advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, Aggregations, Multicasting).
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Designed enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.
• Enhanced performance using optimization techniques-normalization and indexing.
• Experience in creating data visualization solution and report dashboard using Power bi.
• Performed tuning of Queries and Stored Procedures as well as ETL packages.
• Created and developed Dashboards, Tabular, Matrix reports (crosstab or pivot), Charts, Graphs, Drill Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Analyzed business requirements, created business/process flow charts, database flow charts and reporting tool database for Research Revenue Management tracking.
• Designed, developed and implemented test plans, user documentation and completing projects on schedule.
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Designed, developed and implemented Power BI Dashboards, Custom reports, Scorecards & KPI Reports using data from different sources like SQL Server, Excel, CSV, Share point.
• Expertise in writing DAX functions in Power BI and Power Pivot.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Designed and created data extracts, supporting SSRS, Power BI or other visualization tools reporting applications.
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Configured and maintained Report Manager and Report Server for SSRS & Power BI , Deployed and Scheduled the Reports in Report Manager.

Environment: SQL Server 2008 R2, SQL Server 2012 and latest, MS Excel, Visual Basic, Power BI, BIDS.

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• Database development utilizing Microsoft SQL Server OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation, and Loading). Database Administration including, backups, recovery, database maintenance.
• Handled development for reporting team involving coding, security, code reviews, metadata implementation, and replication troubleshooting
• Performed the extraction, presentation and analysis of mortgage information to develop new solution that support business needs.
• Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modelling, Snow flake modeling for fact and Dimension tables.
• Coded optimization objects including hierarchical flattening functions, strategic indexes, and staging tables as well as data and file partitioning.
• Created Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Worked with Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Configured packages with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations, KPI’s, perspectives and roles.
• Build the SSIS packages to load the Data into Staging, ODS and dimensional model.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance
• Created XML schemas to update user tables and system objects for company data dictionary
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements
• Served as a team member in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform.
• Applied security to reports on item and folder level.

Environment: SQL Server 2008 R2/2012, Visual studio 2008/2012, Microsoft Access, BIDS.

Confidential

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes
• Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases from various sources like Text Files, XML Files, Excel and Access.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Look Up, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Designed, developed and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub Reports, Gauges, Pie Chart, Bar Chart
• Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Scheduled the reports to run on daily and weekly basis in report manager and email them to managers and analysts to review in excel spread-sheet.

Environment: SQL Server 2016/2014/2012/2008, SSIS, SSRS, BIDS, Excel, Notepad++, XML