SUMMARY:

• Over 5+ years of IT industry experience in using Microsoft SQL Server 2012 for data design, Data migration, Business Intelligence & Over 10 years in Finance and Accounting.
• Hands - on knowledge in Confidential dashboard development with skills in Data Analytics and Data Visualization using Confidential Desktop and Cloud services
• Strong analytical and problem-solving skills along with inter-personnel communication skills as well as ability to acquaint to fast changing environments.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Building dashboards with Microsoft Confidential using Confidential Desktop and Cloud account.
• Optimizing Microsoft Confidential dashboards with a focus on usability, performance, flexibility, testability, and standardization
• Writing queries and transformations with T-SQL, creating RBAC security with Confidential and building and organizing DAX calculations.
• Designing and implementing a variety of Confidential reports such as Parameterized, Drilldown, Drill through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements.
• Designed Charts with lines, Bar Graphs and Columns to generate reports with cumulative totals.
• Utilized Tableau to design dynamic dashboards and stories using data from SQL Server, Excel and CSV data sources
• Deployed Confidential packages across multiple development environments located on different servers.
• Created new Confidential packages using SSDT 2012
• Configured Integration Services catalogs to hold deployed packages in SSMS 2012
• Troubleshoots failed packages and provide immediate solution
• Involved in database architecture designing to store historical data used for reporting.
• Automated Confidential packages using SQL Job Agent and configured notifications and alerts in case of package failure.
• Created and developed database objects such as tables, indexes, views, stored procedures, User Defined Functions (UDFs), triggers, and T-SQL code with proper grants to all the users and roles using SSMS 2008.
• Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
• Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using Confidential transformations.
• Worked with various Dataflow transformations like Merge Join, Audit, Lookup, Union All, Merge, Aggregate, OLEDB Command and Conditional Split while designing Confidential Packages.
• Involved in maintaining Data consistency and Data Integrity with various constraints like Unique, Check, Primary Key and Default.
• Worked with different Control flow tasks in creating Confidential packages such as Data Flow Task, For Each Loop containers with Execute SQL and Script Tasks.

DEVELOPER

Confidential, Dallas, TX

Responsibilities:

• Designing and implementing a variety of Confidential reports such as Parameterized, Drilldown, Drill through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements.
• Designed Charts with lines, Bar Graphs and Columns to generate reports with cumulative totals.
• Utilized Tableau to design dynamic dashboards and stories using data from SQL Server, Excel and CSV data sources
• Deployed Confidential packages across multiple development environments located on different servers.
• Created new Confidential packages using SSDT 2012
• Configured Integration Services catalogs to hold deployed packages in SSMS 2012
• Troubleshoots failed packages and provide immediate solution
• Involved in database architecture designing to store historical data used for reporting.
• Automated Confidential packages using SQL Job Agent and configured notifications and alerts in case of package failure.
• Created and developed database objects such as tables, indexes, views, stored procedures, User Defined Functions (UDFs), triggers, and T-SQL code with proper grants to all the users and roles using SSMS 2008.
• Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
• Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using Confidential transformations.
• Worked with various Dataflow transformations like Merge Join, Lookup, Union All, Merge, Aggregate, OLEDB Command and Conditional Split while designing Confidential Packages.
• Involved in maintaining Data consistency and Data Integrity with various constraints like Unique, Check, Primary Key and Default.
• Worked with different Control flow tasks in creating Confidential packages such as Data Flow Task, For Each Loop containers with Execute SQL and Script Tasks.

DATA WAREHOUSE ARCHITECT

Confidential, Duluth, GA

Responsibilities:

• Built business intelligence and data visualization dashboards using various technologies such as Microsoft Confidential BI, Confidential View, Confidential Query, Confidential Map and Tableau
• Delivered enterprise, web-enabled reports using Confidential .
• Implemented JIRA, a ticket tracking system for the company and client.
• Implemented Database project solution for deploying database objects.
• Created reports as per user requirements using MS Reporting Services 2012.
• Created report models using the report model designer to support Ad hoc reporting.
• Involved in requirement gathering, analysis, design, development & deployment.
• Provided support to the application developers on the application databases.
• Configured and deployed different reports to the servers using SQL Server 2012 Confidential
• Created complex stored procedures, triggers, cursors, tables, and views, using T-SQL.
• Experienced in T-SQL design, coding, testing and implementation.
• Developed and optimized stored procedures, views, and user-defined functions for the application.
• Developed custom scripts and stored procedures for data import and manipulation in T-SQL.
• Used cascaded parameters to generate report from different Data Sets.
• Involved with T-SQL query optimization to increase the performance of the report.