Business Analyst Ssis

Naveed MD

SQL BI Developer Email: ***********@*****.*** Mobile: 657-***-****

PROFESSIONAL SUMMARY:

Over 4 years of experience working on SQL server integration services, SQL server reporting services, SQL server Analysis Services and TSQL Development.

Good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.

Experience with Relational and Dimensional data modeling using ERWIN, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach.

Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2016/2014/2012/2008.

Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using Power BI SQL Server 2016/2014/2012/2008, DTS, SSIS, SSAS and SSRS 2012/2014/2016.

Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

Experience in Creating Tables, Views, Triggers, Stored Procedures, Power BI User Defined Functions and other T- SQL statements for various applications.

Worked Extensively on ETL process using SSIS package.

Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.

Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.

Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.

Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.

Extensive experience working with SAP Cubes and DSO`s and ETL Process.

Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

TECHNICAL SKILLS

Languages

C, C++, JAVA, C#.NET, T-SQL

Database

MS-SQL Server 2008/2012/2014

Operating Systems

Windows XP/NT/2005/2008/2014

Web Technologies

JSP, Servlets, ASP.NET, HTML, XML

Developer Tools

SSIS, SSRS, SSAS, SAP BW, Power BI, Business Objects.

Other Tools

Ajax, Apache, Tabular Model, MAP Reduce, HIVE, PIG and TABLEAU

Client: AT& T Atlanta, GA. Jun ‘19 – Present

Role: SQL BI Developer

Responsibilities:

Worked with Business Analyst in Gathering the Business Requirements and analyzing to design and create the database.

Created SSIS packages for data conversion using Data Conversion Transformation.

Created package configurations for dynamic connection string to enhance the ease of package deployment, implemented Event Handlers and Error Handling in SSIS packages.

Developed the SQL Server Integration Services (SSIS) packages to transform data as well as created interface stored procedures used in SSIS to load/transform data to the database.

Created SSIS packages to Oracle and other SQL Server instances in SSIS 2014/2016.

Created database maintenance plans and deleting of history data using SSIS packages.

Deployed SSIS packages and Reports to Production Servers.

Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.

Transform the data from the staging database and perform the transformation using the Data Flow Tasks.

Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.

Experience in developing reports using SSRS 2016 and SSRS 2012.

Performed the task of data transfer from files in remote server to folders in another server using FTP.

Generated reports from the cubes by connecting to Analysis server from SSRS.

Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.

Defined Key Performance Indicators (KPI’s) metrics to create scorecards.

Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).

Created SSIS Packages to move files from one location to another using FTP Task.

Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.

Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements.

Worked on Data Warehouse Modeling with SQL Server Analysis Services (SSAS).

Involved in automating SSIS Packages using SQL Server Agent Jobs. Generated Parameterized reports, Sub reports, Drill down and Drill through reports using SQL Server Reporting Services (SSRS) working along with MDX queries.

Involved in Analyzing, Designing and testing of OLAP cubes with SQL Server Analysis Services (SSAS) 2014.

Debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.

Developed dashboards with Power BI which display key KPIs for business analysis and decision making.

Published reports on Power BI services, shared dashboards utilizing within the office 365.

Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.

Optimized queries by using Execution Plan for better tuning of the database.

Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Having worked on configuring and developing Power BI dashboards.

Experience in refreshing dataset using Power BI gateway.

Worked on Data transformations, Data Migration/ Data Conversion to extract data from SQL Server Databases.

Worked on Data Migration activities such as extracting, migrating, validation of data.

Created SQL scripts for tuning and scheduling.

Created extensive stored procedures and updated tables and triggers as per the changes in the requirement.

Involved in debugging and testing of reports in SQL Server Reporting Services (SSRS).

Environment: SQL Server 2012/2008/2008R2 Enterprise Edition, VB Script,,XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Tableau.

Client: Visa, Littleton, CO Aug ‘18– May ‘19

Role: BI Developer (Intern)

Responsibilities:

Interacted with business resources on a daily basis for analyze business processes, requirements progress and deliverables.

Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Dataflow.

Created SSIS packages for File transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.

Created packages using the various control flow task such as data flow task, execute SQL task.

Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014.

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Generated monthly reports and budget analysis to drive forecast production plan with SQL Server Reporting Services (SSRS).

Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Implementation of Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.

Created Stored Procedures, Triggers and User Defined Functions to support the front-end application.

Created Triggers (Instead of and After) for Auditing Purpose.

Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Created Jobs using SQL Server agent to automatically run the stored procedures in scheduled time.

Worked on de-bugging package execution using break points in control flow and data viewer in data flow.

Worked on importing and exporting data from MS-Access Database and XML to SQL Server Database.

Developed, created and implemented complex ETL strategy to grab the data from OLTP, perform various transformations and dump the incremental data into Data Mart.

Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Optimized ETL packages using various SSIS features at Control Flow and Data Flow level.

Designed, deployed and maintained various SSRS Reports in SQL Server 2008 and 2012.

Used Dynamic SQL extensively in T-SQL increasing usability of code and also used dynamic query to create parameterized, cascading parameterized reports, drill down, drill through and Tab reports

Generated daily, weekly, monthly, subscription reports for the analysis of managers & end-users using SSRS.

Optimized packages minimizing use blocking transformations, adjusting buffer size, parallel executing packages in control flow, and using proper event handing, loggings and check points.

Used XML nas SQL server package configuration in deploying packages to production environment.

Involved in De-Normalization of existing tables for faster query retrieval.

Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.

Experience in Using and maintaining the Visual Source Safe for version control.

Created Complex Views and complex functions to expose the columns as per the client requirement.

Scheduled and monitored various jobs like package execution and cube processing using the SQL Server Agent.

Automate the backup and the recovery strategies for the Production environments.

Implemented DB maintenance plans by appropriately re-indexing the indexes to resolve fragmentation.

Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.

Environment: SQL Server 2008R2/2008/2005, T-SQL, SQL Integration Services(SSIS), SQL Reporting (SSRS), SSAS, Business Intelligence Studio, Visual Studio 2008, Erwi4.0, SharePoint, MOSS2007, C#, HTML, Visual Source Safe (VSS),

Client: SunraySys Solutions Pvt Ltd - India Nov 15 – Jun 17

Role: MSBI Developer

Responsibilities:

Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs

Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.

Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS

Installed, configured and maintained SQL Server Integration Services (SSIS).

Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.

Experience with the Share point 2007 to upload the SSIS packages in to Web portal.

Participated in requirement gathering, cube design, application design, SSAS development, training operational users.

Implemented SQL Server OLAP services (SSAS) for building the data cubes.

Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.

Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.

Developed reports using SSRS and published as PDF, Excel, and CSV formats.

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Designing and building data load procedures using MS SQL Server.

Designed and implemented Stored Procedures and Triggers for automating tasks.

Configured product meta-data tables to support client data reporting needs.

Incremental and full database recovery with experience of complex recovery scenarios.

Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries

Environment: SQL Server 2005/2008, MS Analysis Service SSAS Developer 2008, MS Project, MS Access 2000 & Windows 2K platform.

Contact this candidate