SUMMARY:

• Highly analytical and skilled ETL/SQL developer with practical experience of +6 years with a Strong background in business intelligence system design planning and strategy implementation.
• I’ve designed, developed and maintained data warehouse including, gathering business requirements, transforming them into technical requirements, logical and physical data modeling, configuring ETL work flow to populate fact and dimension tables.
• I’ve been a team lead and responsible for creating SSIS package to extract, transform and load data from different sources to the data base and prepare reports by using SSRS/power BI/Tableau where necessary.
• Experience in creating database, tables, indexes, complex queries, stored procedures, triggers, user defined functions, temp tables, complex joins, T - SQL, MS SQL Server 2005/2008/2008 R2/2012/2014
• Hands on experience on identifying and resolving performance issues using SQL profiler, database tuning advisor , DBBC commands and execution plans.
• Experienced in building parameterized stored procedure to support application team.
• Experienced in converting functional requirements into T-SQL scripts and materialized views.
• Experienced in dimensional data modeling including start and snow flake schema
• Experience in BI Semantic-layer modeling and cloud databases.
• Well versed on implementing slowly changing dimensional using SSIS package
• Experienced in denormalization process and grain identification
• Designed a new database model for public school library project.
• Experienced in writing T SQL script to sync staging data to Dim and Fact tables
• Well versed on building SSIS package for file management and data flow
• Excellent in building SSIS package to integrate data from various sources into a DW
• Strong experience in creating, configuring, deploying and testing SSIS packages
• Experienced in data profiling and transformations using SSIS
• Expertise in creating reports through SQL Server reporting services (SSRS)
• Experienced in configuring and managing report subscriptions.
• Excellent in building C-level Dashboards using Power BI
• Well versed in configuring and managing dataset refresh on Power BI service.
• Hands on experience managing in users on report server and Power BI service.
• Hands on experience on configuring Power BI Work Space.
• Experienced using Agile project management tools like Trello and JIRA
• Experienced working on Agile projects with multiple sprints cycles and scrum meetings.
• Hands on experience working on water fall projects with full SDLC
• Expert on installing and configuring MS SQL Servers
• Hands on experience in configuring SQL Server Reporting service
• Expert in configuring MS SQL Integration Service Catalogue
• Experience in Database optimization using SQL profiler, Database tuning adviser and window performance monitor
• Experienced in partitioning, Creating and managing portioned tables indexes

SOFT SKILLS:

• Excellent Communication Skill, Ability to Work Under Pressure, Decision Making, Time Management
• Self-motivation, Conflict Resolution, Leadership, Adaptability, Teamwork, Creativity

TECHNICAL SKILLS:

Database: MS SQL Server Data Warehousing, T-SQL Scripting

ETL: SSIS, Import and Export

SSIS: Package Development and Implementation

Reporting: SSRS, Power BI, Tableau Report, Dashboard and stories

Modeling: Oracle SQL Modeler

Relational and dimensional data model Collaboration: Slack, WebEx Remote Work and Team Collaboration

Project Management: Trello

Agile and Water Fall: MS Office Excel, Power Point, Word, Access DB

Soft Ware Language skills: Transactional SQL (T-SQL), My/SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

SQL/ETL/ Power BI Developer

Responsibilities:

• Hands on Experience on writing DAX formulas KPIs on power BI
• Experience on hosting and sharing dashboards on the cloud
• Experience creating Relationships, Measures, Calculated Columns, Tooltips in the Power BI .
• Experience in publishing power BI desktop reports built in report view to the power BI service.
• Experience in using Agile project management tools like Trello and JIRA
• Excellent troubleshooting and problem-solving skills
• Expertise in ANSI SQL coding and standards
• Experience on relational (ANSI standard) database performance tuning
• Experienced working on Agile projects with multiple sprints cycles and scrum meetings.
• Hands on experience working on water fall projects with full SDLC
• Defines, prepares and executes migration packages for new ETL objects.
• Create and produce ad hoc reports for the business as needed and per cyclical schedules
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports
• Troubleshoot ETL issues, validate result sets, implement process improvements & resolve daily reporting automation issues
• Performed backups and restores and resolved server job failures.
• Produced documentation for all kinds of reports and SSIS packages.
• Participated in data designing architecture, data model and mapping process to load data based on business requirement
• Worked in optimizing T-SQL DB, tables, views, stored procedures, user defined functions, indexes and triggers.
• Participated in designing Data Warehouse schema such as star schema and snowflake by using ERwin
• Consolidated data from various sources into a common data warehouse for reporting and analysis purpose using ETL
• Developed and deployed SSIS packages using proper control and data flow elements with error handling.
• Enhanced and deployed SSIS Packages from development server to production server
• Identified and resolved issues related to SSIS package configuration and deployment.
• Maintained data integrity by performing data validation checks.
• Wrote complex T-SQL queries and used stored procedures, triggers and modified existing ones.
• Modeled dimension and fact table using star schema
• Created simple and complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS).
• Developed interactive and static reports, sub reports, drill through, drilldown reports using various features like Matrix, Table, Charts, Graphs and Dashboard.
• Created report crucial stored procedures and functions to support reporting dataset manipulation.
• Wrote queries for drill down reports to get the dataset required to build the report.
• Designed and deployed reports in MS SQL Server environment using SSRS report services configuration manager.
• Formatting the reports, writing costumed codes and using them in the expressions.
• Performed database recovery and backup tasks on daily and weekly basis.
• Generated reports using Tableau and power BI

Confidential

SQL/BI Developer

Responsibilities:

• Designed and Developed database modelling including conceptual, logical and physical by using oracle data modeler.
• BI semantic-layer modeling and Experience with cloud databases
• Worked on the complete life cycle of the project from design to implementation.
• Designed the business requirements and system requests based on the user requirements.
• Involved in designing, reviewing, and creating Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Performed data conversions from various files into a normalized database structure.
• Created check constraints to maintain data integrity.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables for reporting purpose
• Extracted data from diverse data sources such as CSV, Excel and Text file from Client servers and through FTP
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Involved in ETL Design documents review
• Extensively used package configuration to migrate SSIS package from one environment to another Implemented Event Handlers and Error Handling in SSIS packages
• Scheduled SSIS Packages daily and weekly Basis.
• Developed Standard Reports, Sub Reports, Cross Tab Reports, drill down Reports, used various Charts and graphs like Bar Chart, Line graphs, Pie
• Scheduled reports and exported in various format for decision makers
• Created Ad-hoc reports using Report Builder and maintained Report Manager for SSRS.
• Provided disaster recovery procedures and policies for backup and recovery of Databases.
• Extensively involved in knowledge transfer for the documentation team for the development activities
• Produced reports using Tableau and power BI

Confidential

SQL Database/BI/ETL Developer

Responsibilities:

• Involved in the full Software Development Lifecycle (SDLC) phases
• Constructed high performance ETL for data warehouse
• Designed Extract Transform Load (ETL) process to populate the data warehouse using SSIS
• Maintained SSIS package for loading data from multiple databases to data warehouse dimension tables and fact tables.
• Deployed SSIS packages and scheduled job in SQL Server Agent for automation.
• Migrated SSIS packages from development to test to Production environments using SSIS XML Configuration files and deployment wizard
• Developed SSIS packages with monitoring features and logging
• Involved in creation of dimensions using STAR and SNOW FLAKE Schema
• Designed cubes with star schema using SQL Server Analysis Services (SSAS)
• Defined relationships between Measure groups and Dimensions
• Created SSAS Cubes, Facts and Dimension tables and then applied various services like KPI's, Partitions, Calculated Members and actions
• Developed SSAS Cubes and export them out as pivot tables in Excel for analysis purpose
• Participated in designing in developing MDX Queries in order to perform drilldown reports and for calculating measures
• Created and maintained SSRS report using OLTP data, OLAP multidimensional data, and SSAS Cubes
• Developed query for generating drill down reports in SSRS.
• Implement report parameters, a report layout, interactivity in a report created by using an SSAS data source
• Prepared Ad-hoc reports through report builders and published through Report Manager, Tableau is also used.
• Generated Snapshot, Drill Down, and parameterized reports using SSRS
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS
• Setting catches and snapshots on the server, ensuring security like distribute and change different security roles for users, scheduling the reports delivery to clients email or shared files.
• Implemented Table, Views, Function, Stored Procedures and Triggers for load data and validation purpose
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.

Confidential

BI/ETL Developer

Responsibilities:

• Highly involved in all activities related to development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS
• Vigorously involved in client meetings in requirement gathering and development updates
• Loaded data to the interface tables from multiple data sources such as MS Access, Oracle, Text files and Excel Spreadsheets
• Created SSIS Sequence container to load dimension and fact table for data warehouse
• Created common and various dynamic SSIS package using Variables, Expressions, and Package Configurations to populate the data warehouse
• Used SSIS to create ETL packages to validate, extract, transform and load data to data mart and data warehouse databases
• Configured and deployed SSIS solutions; Customized dimensions and measures
• Monitored SSIS packages with SSIS log and event handler
• Implemented dimensions, storage design and processing options in a cube
• Modified existing dimensional and fact table and relationships. Configured report execution and delivery
• Applied perspectives and KPI using calculated measures based on requirements.
• Configured permissions and roles and diagnose and resolve performance issues in SSAS
• Designed, developed and deployed reports like: drilldown, drill through and parameterized reports using SSRS.
• Generated various reports like: Cascade type, Tabular, drill down reports using Expressions, Functions & Tableau.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report
• Build effective queries for high-performance reporting and rendered them to PDF and Excel
• Worked in designing and optimizing T-SQL DB objects tables, stored procedures, user defined functions, using Management Studio