Sql Server Data

Mohit Ashrit

Cell- 559-***-**** ******.*****@*****.***

PROFESSIONAL SUMMARY :

IT Professional with around 2 Years Experience in Microsoft and Oracle Backend Technologies.

Extensive experience in disciplined SDLC, Data Modeling, TSQL Query, SQL Server Management Studio, ETL Tool such as SSIS and C# Scripts for various purposes.

Hands on Experience in Creating, Modifying and Maintaining Dashboards using Tableau and DOMO.

Extensive hands on experience in creating and maintaining reports using SSRS.

Good understanding of SCHEMA and Object Model.

Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box along with Capacity to work Independantly.

SKILLS and ABILITIES:

Data Modeling Tools : ER-Win, MS Visio

RDBMS : MS SQL Server 2012/2008 R2/2008, Oracle SQL developer, MS ACCESS

Business Intelligence : BIDS/SSDT, SSIS, SSRS, Tableau, DOMO

Programming Languages : TSQL, C#.net, ASP.NET

Analytical Tool : MS Excel

WORK EXPERIENCE

BI / Data Analyst

DirecTV – AT & T [Aug 2015 – Present ]

Work Duties:

Involved in designing and optimizing various SQL database objects like tables (schemas), views, User Defined functions (UDF), indexes and using SQL Profiler and ORACLE developer.

Created and designed UML diagrams using MS Visio.

Designed and created Data Mapping Document (DMD) by analyzing various data sources and mapping it to the data mart schema.

Supported the Architecture and design of Data Warehouse, Data Marts and BI Reports.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Oracle) and loaded the data into target data sources by performing different kinds of transformations using ETL in DOMO

Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.

Implemented error & failure handling in SSIS packages using event handlers, row redirects, checkpoints, and used loggings for monitoring the execution.

Used C# Scripts to Write MessageBox in the Custom Logging Feature in SSIS Package.

Used script task and Script component to design C# script to deal with the flat files.

Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.

Created and Maintained Database in MS ACCESS .

Created DOMO scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using Charts functionality in DOMO to help create Visuals for Budget Forecasting Data.

Worked on motion chart, Bubble chart, Drill down analysis using DOMO.

Created What-If Analysis using parameter and Calculation Beast mode function for different measures.

Uploaded and automated Dataflows using DOMO Workbench.

Designed KTLO Budget Forecast database to support the Financial Budget Allocation Data and decision-making.

Involved in implementing proper package configuration features and finally securing the packages by using password and encryption methods

Performed V-lookup, Macros on pivot tables in MS Excel .

BI Data Analyst

California Creative Solutions, San Diego [FEB 2015 – July 2015 ]

Work Duties:

Involved in designing and optimizing various T-SQL database objects like tables (schemas), views, stored procedures, User Defined functions (UDF), indexes and triggers using Management Studio and SQL Profiler.

Created stored procedures, Triggers, User defined Functions, Views for both Online and Batch requests handling business logic and functionality of various Modules.

Designed and created Data Mapping Document (DMD) by analyzing various data sources and mapping it to the data mart schema.

Supported the Architecture and design of Data Warehouse, Data Marts and BI Reports.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Oracle) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.

Implemented error & failure handling in SSIS packages using event handlers, row redirects, checkpoints, and used loggings for monitoring the execution.

Used C# Scripts to Write MessageBox in the Custom Logging Feature in SSIS Package.

Used script task and Script component to design C# script to deal with the flat files.

Optimized the performance of slow executing SSIS packages by making changes as Control Flow and Data Flow like avoiding blocking transformations, increasing buffer size.

Involved in implementing proper package configuration features and finally securing the packages by using password and encryption methods

Generated various types of reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports, Cascading Parameterized Reports, Chart Reports, Linked Reports and Sub Reports in SSRS..

Experience in working with filter, Hierarchy, Calculation, drill through action, Group, Sets in Tableau Desktop.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop

Created What-If Analysis using parameter and Calculation tableau for different measures.

Used Power Pivot and created various analytical reports and Dashboards to help managers to identify critical KPIs and facilitate strategic planning in the organization.

Environment: SQL Server 2012,SSMS, SSIS,SSRS, ER-Win, BIDS, TFS, Flat Files, Oracle, SQL Profiler, DTA, C#, Tableau

SQL BI/ Report INTERN

NevonProjects, India [JAN 2013 - July2013 ]

Work Duties:

Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).

Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.

Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Implemented indexes on tables and views for optimum performance tuning.

Designed CTEs for code management in complex stored procedures.

Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Optimized the performance of queries with modification in TSQL code, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary with Profiler and Execution Plans.

Involved in dimensional data modeling and story boarding ETL processes.

Designed the ETL process using SSIS Packages which the data sources include Flat files, Access, and Excel.

Wrote C# Scripts in Custom Loggings to Provide MessageBox in the SSIS Package.

Created reports with the help of SSRS and presentations to meet business requirements.

Generated various reports like parameterized and linked reports from the cubes.

Created several calculated members, KPI’s as well as perspectives in support of analytical applications and dashboards

Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Experience in working with filter, Hierarchy, Calculation, drill through action, Group, Sets in Tableau Desktop.

Environment: Microsoft SQL Server 2008/2008 R2, SSIS, SSRS ER-Win, BIDS, Access, Flat Files, Excel, Profiler, C#, Tableau

EDUCATION:

Bachelor Degree in Computer Science California State University- Fresno [Dec 2014]

COURSEWORK :

Software Engineering, Software Testing, Data Structure & Algorithms, Data Warehousing, Operating Systems, Internet Technology, Computer Organization, Network Security, Parallel Processing.

Contact this candidate