Alexandria, VA *****
firstname.lastname@example.org, Tel: 571-***-****
Open for Public Trust Clearance
Experience: 4+ years of experience in various technological practices in analyzing, developing and implementing applications that support business processes.
4+ years of SQL Server Architecture Database applications implementation experience with ETL Business Intelligence and Reporting.
Key Traits: Strong Analytical ability, Problem Solving Skills with Communications Skills. Committed to meeting objectives. Team Player, Fast Learner with great willingness to go the extra mile. Adept in handling multiple tasks. Experienced in working closely with Senior Management and Executives.
•Fluent in T-SQL programming language: creating and managing database objects, stored procedures, triggers, views and user defined functions.
•Skilled in writing sub-queries, CTEs, derived tables and joins for complex queries involving multiple tables.
•Skilled in design, development and maintenance of enterprise data warehouse
•Skilled in creating SSIS ETL (Extract/Transform/Load) packages using proper control and data flow elements with error handling
•Skilled in enhancing, deploying and troubleshooting SSIS Packages from development server to production server
•Excellent in developing SSRS reports, dashboards, ad-hoc reports with functionality such as Drill Down, Drill through, and Parameters
•Ability to meet deadlines, and produce effective results, while working both independently and with teams
•Involved in requirements gathering, analysis, design, development, change management, deployment
•Experience in agile methodology
•Flexible and versatile to adapt to any new environment and work on any project
•Languages: SQL, C#
•Databases: SQL SERVER 2014/2012/2008 R2
•Tools: MS Office Suite, MS Visio, Gliffy, Visual Studio, ERWIN, Red gate 9.0
•Development tools: SSMS, SSDT, BIDS, MS Excel, SSRS, Power BI, Crystal Reports
Parallon Nashville, TN 05/18 to Date
BI SQL Developer
•Created stored procedures, user defined functions, views, triggers,common table expressions (CTE) and indexes
•Created ETL packages to validate, extract, transform and load data to data warehouse and data mart
•Used various transformations like derived column, merge join, union all, conditional split, multicast, data conversion and look up.
•Fixed errors by using event handling, precedence constraints, break points, check points and logging
•Connected various data sources in Power BI service using On-Premises Gateway connection.
•Cleanses data by using query editor in Power BI
•Created dashboard, tabular reports, matrix reports, chart reports, parameterized reports, sub reports, Ad-hoc reports, drill down reports as well as interactive reports by using Power BI and SSRS
• Created POWER BI visualizations and dashboards as per the requirements.
•Used DAX to create formula to develop reports visualization by using Power BI
•Created Workspace and Published reports using Power BI Service
CONDUENT Morrisville, NC 05/17 -04/18
•Created visualization, Dashboard, sub reports, matrix, charts, and drill down, Ad Hoc reports by using SSRS and Power BI
•Wrote SQL query to generate various kinds of reports
•Created and scheduled complex SSIS packages for transferring data from multiple sources into SQL Server, and Excel by using SSIS and DTS of SQL Server
•Created databases, tables, views, cluster/non-cluster index, unique/check constraints
•Created and executed T-SQL stored procedures, functions, triggers, cursors, and other SQL joins
•Created datasets and visualizations from SQL, Excel and CSV files as a source
•Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
•Used DAX to generate aggregate reports in Power BI
•Developed and maintained multiple Power BI dashboards/reports and content packs
•Used Power BI, Power Pivot to develop data analysis prototype, and used Power View, Power Map to visualize reports
•Published the finished dashboards, reports in Report Server for the use of report consumers
Jomex International Fairfax Station, VA 04/14 – 03/17
•Created Entity Relationship (ER) Diagrams to the proposed database by using gliffy
•Created database objects such as tables, views, stored procedures, triggers etc
•Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
•Identified columns for Primary Keys in all the tables at the design time and create them.
•Created functions to provide custom functionality as per the requirements
•Designed, developed, and tested dashboard, visualization, tabular, matrix and chart reports as per the user requirement by using Visual Studio, Power BI, and BIDS
• Worked on adding tiles to the dash boards, images to the dashboards using Power BI services
•Created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, etc.
•Created Static and Dynamic Row-Level-Security in Power BI Desktop and assigned roles to users via service
•Working with import and direct query, creating calculated columns and measures in Power BI.
•Hands on Experience in using DDL, DQL, and DML
•Design, develop and deploy SSIS packages by using visual studio
Hanze University of Groningen Groningen, Netherlands