Run reports every month and distributed them to respective users through mailing server subscriptions and SharePoint server.
Developed dynamic General Ledger(GL) Reports: Gross Margin, Net Revenue, Operating Expenses, Summarized Reports based on the Profit Center suing SSRS/Tableau. Used Tableau to design and create tableau visualization using Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Chart, Box Plots, Waterfall Chart, Geographic Visualization and local and global filters regarding the business and client requirement. Used SQL Server Reporting Services(SSRS) to design and develop solutions to support business intelligence reports including Sub-Reports, Snapshot Reports, Parameterized Reports, Drill-down Reports, and Drill through Reports. Developed ETL packages in SSIS to ensure data quality and data consistency using Lookup, Execute SQL task, Sequence Container, Breakpoint, and Checkpoint. Developed initial load/incremental load ETL packages, Staging Data ETL packages, Package Test Script, and Reports Requirements/Unit Testing Document and Synchronized these packages/document onto SharePoint Server. Developed SQL Server Integration Services(SSIS) ETL Packages and other back-end processes to support system integration and ETL process to facilitate the creation and population of Enterprise Data Warehouse(EDW). Wrote T-SQL queries to create Store Procedures, User-Defined Functions, Indexed Views, and DML Trigger to facilitate ETL processes in SQL Server 2012. Involved in gathering requirements from business and IT managers and created documentation template and documented project requirements MS SQL/Business Intelligence Developer (SSMS/SSIS/SSRS) Project Management Tools: JIRA, SharePoint Reporting Tools: SQL Server Reporting Service(SSRS), Tableau 8/9/10, IBM Cognos, PowerBIĮTL: SQL Server Integration Service (SSIS), Data Transformation Services, SQL Server Data Tools(SSDT) RDBMS/OLTP: SQL 2008/2008R2/2012/2014, Oracle 9i/10g, AccessData Warehouse/OLAP SQL Server Analysis Services(SSAS) Familiar with Agile and Waterfall SDLC methodologies and worked with cross-functional team environments. Passion for exploring new technology, strong social responsibility, outstanding interpersonal communication, problem solving, documentation and business analytical skills. Implementing Data blending, Replace references and customized queries in Tableau Proficient in Developing Dashboards using Tableau and user stories to deliver insights and advanced visualization. #MS SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO PROFESSIONAL#
Professional skill in Tableau visualization using Bubble Char, Tree Maps, Funnel Charts, Dual Axis, Box Plots, Waterfall Charts, Geographic visualization and local and global filter that meet client’s requirements.Experienced in designing and deploying tabular reports, drill-down reports, drill through reports, multicolumn reports, linked reports and parameterized reports by using SQL SSRS.Proficient in T-SQL, Query optimization, creation of Views, Triggers, User-defined functions, Store Procedures and Dynamic-queries and in using CTE, Temp table, Table Variable and View as well as Subquery and join.Profound understanding of Enterprise Data Warehouse(EDW) concepts including OLTP/OLAP, Dimension/Fact tale, Top-down/Bottom-Models, Star/Snowflake schemas.Ability in Error Logging, Exception handling and Custom Logging for SSIS package, Performance tuning in SSIS package.Implementing incremental data load using Slowly Changing Dimension(SCDs), Change Tracking and Change Data Capture(CDC) Professional experience in implementing initial data load using Bulk Insert Task, Fast Load, and Bulk Copy Program.Expertise in creating, documenting, and deploying ETL package under both Package Deployment Model and Project Deployment Model using SQL Server Integration Services(SSIS) to load data from source to destination.
Experienced in data Extraction, Transformation and Loading(ETL) between homogenous and Heterogeneous Systems using SSIS of MS SQL Server.Strong understanding of logical and physical Database design and development, data conversion and Normalization concept.
7 years of professional experience as a MS SQL server/ETL/BI developer in designing and developing T - SQL queries, ETL package, and business reports using SSMS, SSIS and SSRS
0 kommentar(er)
