Data Analyst

PROFESSIONAL SUMMARY

●*+ years of IT Experience in Business Intelligence /Data Warehouse(SSIS/SSRS) MSSQL Server 2017/2016/2014/2012/2008R2/2008 Database & Visual Studio 2013/2016/2018 SSRS

●Extensive experience with SQL server and T-SQL in constructing database objects: Stored procedure, triggers, user defined functions, views, indexes, joining multiple tables.

●Worked on all phases of data warehouse development lifecycle, from gathering requirements to design implementation, testing, and support data warehouse and data mart entities. Building a DW from the ground up.

●Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Data Stage and ETL package design, and RDBM systems like SQL Servers 2012/2014/2016,

●Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.

●I have very good financial and health care experience in my previous projects in creating Chart reports, Drill down and Drill through Reports by passing parameters in SQL Server Reporting Services (SSRS).

●Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS),

●Worked on Tableau, development of dashboards and publishing the reports on 9.0 and 9.3 Tableau Server.

●Hands on experience in using software like Jira System Dashboard, Agile Methodology, VSS, Rational clear case and (TFS) Team Foundation Server and SFTP server.

●Extensive knowledge in Tuning SQL queries and improving the query performance.

●Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts.

●Expert in creating traditional as well as Web-based interactive reports using SSRS.

●In-depth knowledge of Transact-SQL (DDL and DML).

●Experience in optimizing the database by creating various Clustered, Non-clustered indexes.

●Expert in creating Chart reports, Drill down and Drill through Reports by passing parameters in SQL Server Reporting Services (SSRS).

●Experienced with converting excel and Crystal reports to SSRS reports and migrate crystal reports to higher versions.

●Adept in report design, table/query design and automation utilizing VBA modules.

●Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.

●Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages.

●Experience in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports, (SQL Server Analytical Services) objects and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).

●RDBMS experience, including SQL programming, data analysis and data verification and validation

●Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau

●Worked on Jira and Scrum Methodology as well as on SDLC procedures in the implementation of project workflow

●Knowledgeable in planning and implementing MS SQL Server Security, DBA and database Permissions.

●Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

●A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

HIGHER EDUCATION & CERTIFICATION

●Health related physical fitness trainer certificate

●Human resource management certificate

●BSC Degree in M.I.S from Unity university

●BA Degree in Management from Unity university

SKILLS

RDBMS / Databases

MS SQL Server 2016,2014,2012,2008/2005/2000, Oracle 8i /10g/11g MS-Access 97-2007

Languages

T-SQL, Visual Basic 6.0, HTML, C, C++,Visual Studio 2013,2012, MS SharePoint, MS Team Foundation Server (TFS), Data Analyst (RDBMS & SQL)

Operating Systems

Windows 10/7/XP/2000/NT/98/95, MS DOS 6.2

Windows Server 2014/2012/2008/2003

Modeling Tools

Microsoft Visio 2003, Erwin 3.x

Reporting Tools

SQL Server Reporting Services ( SSRS ), Tableau, Crystal Reports 8/10

Integration Services

SQL Server Integration Services (SSIS),Data Transformation Services ( DTS

Analysis Service

SQL Server Analysis Services (SSAS)

Database Tools

MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor ( DTA )

Internet Tools

Internet Information Server ( IIS 5.0 / 6.0 ), FTP, TCP/IP

Other Tools

Maintenance

Microsoft Office 2003/2007,2013 Tableau, Agile Methodology

Maintaining computer hardware, software networking problem

PROFESSIONAL EXPERIENCE

MARILAND STATE March 2019 to Present

SSIS/SSRS/Data Analyst (RDBMS & SQL)/ BI Developer

Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.

Extracted data from internal data warehouse system to SSRS

Tracked trouble ticket request for request made by end users

Created ad-hoc reports

Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization

Analyzed data models, data relationships, and dependencies for greatest optimization

Designed and developed stored procedures, queries and views necessary to support SSRS reports

Performed functional and performance QA testing

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS and Tableau reports and dashboard, supported more than 20 client companies' general business reports and administration processes.

Developed different type of reports including: Valuation reports, Client Contact Report, Accounting Statement Report, Auction report, file transfer reports by using SSRS and Tableau 9.0 and 9.3 and SQL Server 2013/2014.

Scheduled and managed daily/weekly/monthly operational and management reports based on the business requirements.

Created and maintained SSIS ETL packages to extract data from different systems, Like PostgresSQL and load variety of large volume data into data warehouse from different sources like flat file, Excel file.

Developed parameterized reports which were used for making current and future business decisions.

Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.

Created reports that projected business goals for future.

Used table variables and Common Table Expressions (CTEs).

Worked closely with the offshore team to coordinate tasks with onsite and offsite team members in finding solutions to arising problems.

Identify the associated Store Procedures and parameters used for the reports

Followed a priority based and Involved in job scheduling and alerts and provided 24x7 production support.

Ally Bank, Charlotte, NC November 2017to JAN 2019

SSIS/SSRS/Data Analyst (RDBMS & SQL)/Tableau Developer

Created database objects such as Tables, Views, Stored Procedures, Triggers, Indexes and functions

Implemented complex business logic with Store procedures, User Defined Functions, Views and wrote T-SQL batches with CTE (Common Table Expressions) for recursive operations

Created complex T-SQL queries, stored procedures for data extraction. Applied various business logic to scrub/clean/validate/convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user defined functions, and ad-hoc queries.

Involved in modifying the Existing Data ware house and add new Data Points for Data Analysis

Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

RDBMS (SQL, Oracle, DB2,MS Access) Database Administration / Application Design and Development -- Implementation, Design, Administration, DB security, Performance Tuning, Data Modeling, migration, 24 / 7 On-Call. Extensive OEM, DDL/DML design / data quality analysis / ETL work. SQL- Query optimization expertise, including data integrity analysis for application customization testing, and creating analytical metrics.

Install and maintain SQL Server 2008 R2 and 2012 database and SSRS on multiple Servers

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once

Designed number of SSIS packages for data transfer between flat files, XML, Sales Force, Oracle, MYSQL and SQL Server using different transformations like Lookup, Derived Column, Merge Join, Fuzzy Lookup, Script Component

Migrate and upgrade databases from older versions to 2012

Created SSIS Templates for developing SSIS Packages, Implemented SQLServer configurations and error handling in SSIS Packages

Involved in deploying SSIS Packages to production from different environments and scheduling and administrating SSIS Packages, wrote best practices for deploying SSIS Package to Production

Involved in gathering requirements for EDW and designed the work flow diagrams and wrote the best practices and naming standards

Proficient in Tableau 8.x/7.x/ 6.x (Desktop, Server, Public, Mobile), Micro Strategy 9.x/8.x product suite (Desktop, Intelligence Server, Narrowcast Server).

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Involved in developing graphs using appropriate transformations for implementing the business logics in data loading

Involved in testing the SQL Scripts for report development and Tableau reports

Designed the dimensions and facts using Star Schema

Created materialized views as per business requirements and wrote number of stored procedure and dynamic SQL.

Involved in implementation of Master Data Services through Data Quality Services, Designed the SSIS packages move the data between MDS and EDW

Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.

Built compelling, interactive dashboards in Tableau that answer key business questions

Designed SSIS Packages to cleanse, remove duplicates and matching data through Data Quality Services

Creating Back up Strategies and implementing Disaster Recovery

Atlanta GA State July 2016 to November 2017

BI Developer/ SSRS Developer

Designing solution for Consolidating Different data sources

Created SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file and XML in order to create and maintain a centralized database.

Created complex stored procedures to generate reports using SSRS

Applying strategies for data acquisition, ODS implementation, and archive Process

Designed and built relational databases.

Worked in pulling data and deal with heterogeneous sources and optimize the data extraction and conversion process using SSIS.

Migrating Databases from SQL Server 2008 to SQL Server 2012

Created MDS/MDM for master data and also implement Data Cleansing and Data Quality.

Experience in creating Ad hoc reporting universes using Business Objects Universe Designer.

Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.

Installed and Upgraded from SQL Server 2008 to SQL Server 2012 on Various Servers.

Implement Logging to track and create ETL dash boards to monitor the ETL Process

Creating and modifying Business Intelligence analytical reports using Tableau.

Error Handling and Auditing implemented in SSIS to track down the data discrepancies

Experience working with Share Point 2010 lists in using them as interface for users

Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.

Excellent T-SQL Programming skills in creating stored procedures, executing, debugging, problem analysis & troubleshooting, functions, triggers, and creating solutions.

Involved in Performance tuning of databases and help user in efficient reporting

Developed high level design of ETL Package in MS SQL Server 2008 for integrating data from heterogeneous sources such as Excel, CSV, Oracle, flat file and Text Format Data.

Built reports using SSRS and helped develop efficient reporting solutions and setting up subscriptions as needed for SSRS

Optimize SSIS Packages to fine tune the data loads and reduce the data load time and come up with Best Strategies in the data load process

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

Implementing Partitioning and Back up Strategy and security policies

Environment: MS SQL Server 2005/2008 R2/ SQL Server 2012, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL server Analysis Services 2008,Tableau Desktop(Desktop, Server), Microsoft Visual Studio, Tableau, SQL Server Management Studio, MS Excel, T-SQL, ERWIN

SATCOM Institute of Technology Addis Ababa, Ethiopia October 2014 to July 2016

SQL Developer/ SSRS Developer

Created the Data warehouse Architecture, Data Model and setting up the Best Practices

Built the Source to Mapping document based on Subject areas for ETL Data Integration initiative

Creating the Star Schema from analyzing the underlying requirements of the Data warehouse

Worked on building/modeling the Enterprise Data Model

Dimensional Data Modeling adhering to Ralph Kimball Methodology

Creating stored procedures, End to End Solution for bringing the data from multiple source systems into Data Ware house

Created Several Types of reports using SSRS like Parameterized, Drill Down and Drill through Reports

Created the Data warehouse Architecture, Data Model and setting up the Best Practices

Built the Source to Mapping document based on Subject areas for ETL Data Integration initiative

Creating the Star Schema from analyzing the underlying requirements of the data ware house

Created the Design Documents and Pop Specifications for the Process.

Gathered the Business Requirements for automating the reconciliation of numbers for every quarter

Created Logical and Physical Data Models for ODS

Developed Data Flow Diagrams

Created ODS(Operational Data Store) for consolidating the data from various data sources like Under Writing Work Station, Claims Work Station and IRIS by using SSIS as ETL tool

Followed the Agile methodology to develop fine tune and deliver with Constant Partner Ship from Business user

Very Good Experience in Performance Point Server which Involves monitoring Analytics and Planning Components

Contact this candidate