SUMMARY:

• Leveraging Microsoft Business intelligence tools such as SSIS,SSSRS and SSAS to create intelligent solutions to business problems and insight into legacy data creating Data Warehouse and Reports as well as complex ETL Solutions and inplimenting Design patterns and principles including Kimball Methedology, Star Schemas, Agile Methedology, Scrum and adhering to a full Software Development Life Cycle including Requirement gathering, Relationship management and Delivey.

PROFESSIONAL EXPERIENCE:

BI DataWarehouse Developer/DBA

Confidential - Kannapois, NC

Responsibilities:

• Create and Debug Complex SSIS packages
• Created Synonyms to connect to Azure Database for CRM dynamics
• Used Merge replication between multiple plants and resolved confilicts between locations
• Used Multi-Valued and Inline User Defined Functions
• Heavily Used CTEs to process data for ETL sources and stored procedures
• Backup and restored Datawarehouse and set up high-Availability
• Create Package Configurations for easy Deployment procedures.
• Creating and modifying BI Framework for dynamic package execution and manipulation
• Creating SSIS Jobs to run in multiple environments
• Worked on troubleshooting and problem solving of MS SQL development.
• Troubleshooting package failures and errors.
• Configuring TFS, BIDS Helper and Report Server and connection managers.
• Backup and restoring Datawarehouse
• Kimball Methedology to create star schema and snow flake schemas creating Dimentions, facts, slowly changing dimentions, capturing type1, type2 and type3 changes
• Creating Pie Charts, Donut Charts and Graphs Using Power BI from sources like SQL Server Data, Flat files and Excel sources to publish highly interactive reports.
• Used SSRS to create and deploy Charts, guages
• Create Interactive maps and reports using Dundas.
• Worked on troubleshooting and problem solving of MS SQL development.
• Spearheaded improvement and maintenance of the databases to include rollout and upgrades
• Administered implementation and release of database changes according to agreed timescales and costs. Maintained development / test / production environments along with the controls associated with each environment.
• Administered, Configured and Monitored SSRS Report Server
• Developed SSRS models using Visual Studio 2008/12 Business Intelligence tool
• Developed, executed, documented, and maintained appropriate BI procedures and MDX scripting.
• Managed and implemented SSIS packages to do the nightly refresh of data.
• Performed ad hoc queries and maintained query governance. Developed and implemented change management processes for the BI platform.
• Met regularly with business clientele to review change requests and produce operational reports.

Environment: SQL Server 2000/2008/2012 (Reporting Services), Windows 2003/2008, Visual Studio 2008, Visual Source Safe 6.0, Visio, SQL/TSQL

Business Intelligence Developer /DBA

Confidential, Baltimore, MD

Responsibilities:

• Create and Debug Complex SSIS packages
• Create Package Configurations for easy Deployment procedures.
• Developed procedures, functions and packages to implement the system’s business logic using TSQL
• Worked on Database Backup/Restore in development, test and production environments.
• Worked on troubleshooting and problem solving of MS SQL development.
• Troubleshooting package failures and errors.
• Spearheaded improvement and maintenance of the databases to include rollout and upgrades
• Administered implementation and release of database changes according to agreed timescales and costs. Maintained development / test / production along with the controls associated with each environment.
• Clean up duplicate data all the way from Data warehouse to origination legacy systems.
• Create reports using SQL Server Reporting Services (SSRS) utilizing MDX queries and ACTIONS.
• Developed procedures, functions and packages to implement the system’s business logic using TSQL
• Designed complex reports using Cascading parameters, Drill-Through Reports,
• Parameterized Reports and Report Models and ADHOC reports using SQL Server
• Reporting Services (SSRS) based on client requirements using Drllthrough actions in SSAS and MDX
• Experienced in creating, managing, and deploying various types of reports using SQL Server
• Reporting Services and Report Manager and configuring Report Server.
• Reviewed data access controls and provided recommendations in improving the security.
• Worked on Database Backup/Restore in development, test and production environments.
• Answered technical inquiries and responded to troubleshooting requests.
• Assisted with installation, configuration, and troubleshooting of software.
• Wrote and implemented functions and stored procedures using MS SQL Server 2005.
• Developed and published ad hoc reports and added drill through functionality using Report Builder, and created tabular, matrix, graphical and free form reports from multiple data sources (relational and multidimensional) using SQL Server 2005 Reporting Services.
• Analyzed, resolved, and documented findings in support of reported database issues.

Environment: SQL Server 2005/2008/2012 (Integration Services and Reporting Services)