We provide IT Staff Augmentation Services!

Buisness Data Analyst/ Data Modeler Resume

Redmond, WA

SUMMARY:

  • About 8+ years of experience in IT environment with primary skill on the Analysis, Design, Development, Implementing and Testing Client/server application using Confidential SQL Server and Business Intelligence suite SSIS, SSRS, and SSAS in various domains like HealthCare, Banking and Insurance as SQL MSBI Developer /Data Modeler .
  • Experience in understanding and analyzing the ERP systems .
  • Experience in Gathering the Requirements from the Business Stakeholders and align it to the Business process
  • Experience in Data Modeling, data mapping, Data profiling, De duplication in legacy systems .
  • Logical and Physical Design of Databases and Data marts, Normalization and building Referential Integrity Constraints for OLTP and OLAP.
  • Source to target mapping using excel. Analysis of the source data - SAP SD/FICO/PD, analyzing the logic, coming up with the transformations and passing it to the developers to use as reference of the business logic and requirements.
  • Experience in Relational Data Modeling, data mapping in legacy systems -Logical and Physical Design of Databases, Normalization and building Referential Integrity Constraint s.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012.
  • Expertise in developing reports, packages and cubes in SQL Server 2005/2008/2008 r2 /2012 BIDS, SSMS TOOLS.
  • Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, CTE, Triggers, cursors, Sub queries.
  • Written stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects and so on
  • Experience in using the DMVS, DMFS, INFORMATION SCHEMA, and SYSTEM VIEWS and in built GLOBAL VARIABLES for the instant analysis.
  • SQL Server 2005/2008/2012 OLAP database development including KPIs, Data mining, working with changing dimensions .
  • Experience in Configuring the Deployment Environment in PROD and QA for SSRS and SSIS
  • Good at ETL (SSIS), Data and Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes .
  • Hands-on experience working with data management strategies as well as with metadata, data quality, data change management, data profiling and ET coupled with master data management technical knowledge.
  • Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Creating SSIS Packages and involved in Package configurations and deployments between Development and Production servers.
  • Developing reports in SSRS on SSMS-SQL SERVER MANAGEMENT STUDIO.
  • Sound Experience and understanding of SSAS, OLAP cube development using SSMS.
  • Report management, Report delivery and Report security.
  • Experience in writing Distributed Queries between SQL Servers in SSMS.
  • Worked in Data modeling, creating star and snowflake schemas in SSAS.
  • Expertise in generating reports - (Ad hoc, Real time and Near Real time) using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot, Power BI
  • Strong experience in creating various reports like Drill through, Drill down, Sub reports, lined reports, Tablix, matrix reports and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports.
  • Implemented Side by Side Migration of MS SQL SERVER 2000/ /2008r2/2012.
  • Extensive experience in data migration between homogenous and heterogeneous system using various tools (DTS, SSIS, BCP, Bulk Insert, ActiveX).
  • Expert in SSIS Packages for OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) using transformations.
  • Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, activity monitor, Event viewer for performance analysis.
  • Expert in Performance tuning of the SQL queries .
  • Experience in administrative activates comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
  • Migration experience with DTS to SSIS 2008 and experience with data modeling techniques, logical and physical database design.
  • Experience in scheduling and deploying reports on report manager.
  • Using the Power BI,Tableau created Dashboards, Score Cards and attached to the Relational Databases to generate Ad-hoc reports and Real time reports .
  • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
  • Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
  • Comprehensive knowledge of MS SQL stored procedures, ETL, SSIS and SSRS along with SharePoint integration .
  • Involved in all phases of Software Development Life Cycle (SDLC), database design, RDBMS, data warehousing, data modeling concepts and software quality management
  • Strong experience in mentoring with team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS:

Databases: SQL server 2000/2005/2008 R2/2012/2014, MS Access

Languages: Transact- SQL, SQL, HTML, C.

Operating Systems: Windows NT/98/ 2000/XP/Vista/2003, MS-DOS

BI TOOLS: SSAS, (SSRS), MDX, Crystal Reports, Tableau, Power BI

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, ADF(AZUREDATAFACTORY)

Other Tools: Confidential Visual Source Safe, Confidential Office, MS Visio.

Data Modeling Tools: Confidential Visio, ERWIN .ER STUDIO

Server Tools: SQL server Management Studio (SSMS), SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler,TOAD

Programming languages: C,SQL,PL/SQL,T-SQL,.NET,C#,Python

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server 2008/2012 Analysis Services and SQL Reporting services, DTS, ProClarity, SQL AZURE DATAWAREHOUSE.

Application Tools: Change point, Clarify, GRM, SAP, Majeline, PES, MDM, BigData, AzureDataLake

Version Controlling Tools: TFS, Share point 2016

PROFESSIONAL EXPERIENCE:

Buisness Data analyst/ Data Modeler

Confidential, Redmond, WA

Responsibilities:

  • Ability to Define and Interpret business requirements in collaboration with the product manager for complex analysis and data integration projects from an SAP to Non-SAP system.
  • Aggregate data from different Modules SAP ERP - SD /FICO/PD, BigData and perform analysis as per business requirements.
  • Thorough Understanding on the SAP SD structures at Table level and Extractor level and Align the requirements according to the Business requirements.
  • Able to identify potential problems through advanced analysis techniques and develop appropriate test cases to assure effective testing of the application.
  • Form Hypotheses, then analyze data to independently test the ideas
  • Work with data architects to translate requirements into Business Requirement Documents, Technical Specifications and Functional Specifications and assist in data and output validation.
  • Maintain Comprehensive documentation of business processes, analytics design, measure definitions, data integration and usability to assist with the development of enterprise level data concepts and metadata.
  • Demonstrates Good understanding of Functional Business Processes, and ways in which data structure and quality can support such processes.
  • Conducted and participated in the JAD sessions (Joint Application Design)
  • Worked as a Data analyst for SAP,BigData provided data, works directly with internal business and technical teams (database and applications support) as well as outside technology service providers to identify the system integration requirements.
  • Understanding the data model, Data Extract, data profiling, de-duplication of data, data mapping, Source to Target mapping, look ups and transformations in excel, working with the development team to meet business requirements and logic.
  • Master Data Management and Data Governance and coordinating with the users to gather business requirements
  • Creating the Conceptual Data Model as per the Business process flow in Confidential Visio.
  • Creating the Logical Data Model and Physical data model with ER studio and POWER BI Desktop for OLTP and OLAP.
  • Identified the Cardinality and the Relationship between the Entities and Attributes in the Data modelling or Designing are accurate to built a Physical data model for an OLTP.
  • Involved with the Business Key Stakeholders in Understanding the Measures and Metrics defined
  • Created SSAS Tabular Model with the Row level security design implementation based on the Measures and KPI defined .
  • Performed the Process Operations (Refreshing the Data or recalculating the calculated data ) using the SQL Server Management Studio (SSMS) and also scheduled by Using Script.
  • Involved in creating the Tabular Cubes.
  • Involved in modelling the Snow Flake Schema/Star Schema for the Downstream data marts.
  • Built Self-serve BI application by the Power Pivot excel on the Tabular Model.
  • Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform and worked on Change Data Capture, used script task for customizing
  • Created checkpoints and configuration files in SSIS packages and migrating to various environments
  • Oversees the programming, testing and implementation of the system integration strategy.
  • Performed Performance tuning of the SQL queries to increase the speediness in running query and generate the data accordingly by imposing proper Indexes and Creating Subqueries.
  • Perform data profiling on elements, entities, and entity relationship.
  • Perform data reconciliation, Data Extract
  • Identify elements for metadata standardization
  • Establish element, entity, and entity relationship matching and reconciliation rules.
  • Establish rules for merging records
  • Participate in the discovery, documentation and presentation of rules, issues, metadata, and business/technical decision.
  • Developed and analyzes technical reports from data warehouse as a part of Enterprise Reporting using the Power BI desktop.
  • Designing, developing and deploying various kinds of Ad-hoc/RealTime reports using SSRS/POWER BI using relational and multidimensional data in SSMS
  • Built Dash Boards and Score cards using the Power BI-Power View, Power query.
  • Have also created different tabular and 1-D and 3-D charts in SSRS reports.
  • Worked on different kind’s issues like format issue, data issue, and alignment issues to generate the reports in correct format without fail and satisfied business users.
  • Expert in generating Drilldown reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, charts in SSRS 2005/2008/2012.
  • Performed the Unit Testing, Integration Testing and Reconciliation of the data.
  • Version Controlling of the documents have done through Share point 2016.

Environment: SAP,MS SQL Server Management Studio 2014, Query Analyzer, SQL Profiler, ER STUDIO, Visual source Safe, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Erwin, Power BI, Share point 2016,SSMS

Sr. SQL BI DEVELOPER/ DataAnalyst

Confidential, COLUMBIA, SC

Responsibilities:

  • Gathered functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
  • Experienced on writing complex queries, performance tuning and optimized SQL queries using T-SQL, SQL Profiler in SQL Server 2005.
  • Monitored Performance and Optimized SQL Queries for maximum efficiency.
  • Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.
  • Perform DBCC checks to ensure the physical consistency of the database and objects.
  • Implemented transactional replication among different servers to have high availability of the data.
  • Created DDL, DML scripts, stored procedures, CTE according to the requirement and designed ad hoc queries on the database tables.
  • Created views/indexed views consisting of computed columns to facilitate easy user interface.
  • Created and Implemented triggers in T- SQL to facilitate consistent data entry into the database
  • Develop, maintain, implement and support all SSIS development & production efforts. ETL development for data warehouse data marts daily refresh and real time reporting, utilizing both SSIS and DTS packages using SQL Server 2005 and 2008.
  • Creating the Conceptual Data Model as per the Business process flow in Confidential Visio.
  • Creating the Logical Data Model and Physical data model with ER studio and POWER BI Desktop for OLTP and OLAP.
  • Identified the Cardinality and the Relationship between the Entities and Attributes in the Data modelling or Designing are accurate to built a Physical data model for an OLTP.
  • Involved with the Business Key Stakeholders in Understanding the Measures and Metrics defined
  • Created SSAS Tabular Model with the Row level security design implementation based on the Measures and KPI defined .
  • Created the packages based on mapping document using SQL Server Integration Services (SSIS).
  • Using SSIS 2005, building high performance data integration solutions including Extraction, Transformation and Load (ETL) packages .
  • Loading multi format data from various sources like flat-file , Excel , MS Access , Oracle etc. using SSIS and performing file system operation.
  • Deploying and scheduling SSIS packages and jobs using SQL Server Agent .
  • Create jobs, Alert and schedule DTS/SSIS Packages and SSRS to generate reports.
  • Working with reporting team in Designing, Developing and Deploying Reports in SSRS.
  • Designed and architected Report Layout including both simple and complex report using SSRS 2005.
  • Involved in Creating the Dashboards and Real time Reports using POWER BI .
  • Studying the structure of RDBMS to develop multi dimension Objects ( Cubes , Dimension ) using SSAS .
  • Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
  • Practical involvement in creating dimensions using STAR and SNOWFLAKE schema.

Environment: Windows server 2007, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, Share point 2016

BI DEVELOPER

Confidential, Nashville, TN.

Responsibilities:

  • Involved in analysis of Report design requirements and actively participated and interacted with Project Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
  • Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
  • Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS).
  • Excellent report creation skills using Confidential SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder in SSSMS.
  • Created SQL Server Reports based on the requirements using SSRS 2012.
  • Created queries using TOAD on an Oracle Database using PL/SQL language.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
  • Created complex reports which involve more number of groupings and multi-value parameters.
  • Developed reports like Claim Statements, Fee Bills Transactions and some end user request reports on periodic basis.
  • Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
  • Giving inputs to the team.
  • Created multiple reports with drop down menu option having complex groupings within the report.
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix.
  • Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Troubleshooting performance issues and fine-tuning queries and stored procedures.
  • Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
  • Scheduling the SSIS packages and Jobs.
  • Involved in deployment of SSRS reports on the SharePoint Portal.
  • Perform responsibilities of building testing environment and testing scripts by referring the technical specifications
  • Assigned the tasks of performing regression testing of facets application
  • Perform Claims validation of facets application as required
  • Handle the tasks of preparing test cases and test scripts of various facets modules.
  • Responsible for running test scripts for facets applications and modules
  • Perform defect analysis for failed test cases and develop solutions for the same by coordinating with developers.
  • Worked very closely with Business Customers, End Users and resolved any business process related issues.
  • Work in TFS version controlling environment.

Environment: Windows server 2007, IIS 6.0, MS SQL Server- 2012/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, TFS, TOAD, Oracle 11g.

SR. SQL BI DEVELOPER

Confidential, BOSTON, MA

RESPONSIBILITIES:

  • Worked in AGILE methodology in development of Database Objects in SQL Server 2005/2008/ 2008 R2/2012.
  • Filtered and cleansed bad data from legacy system using complex Transact- SQL statements in staging area, and implemented various constraints for data consistency.
  • Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
  • Performed Data Modeling in ER Studio Data Architect 9.0 in the initial stages of the project.
  • Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
  • Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
  • Extensively used BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2005 and 2008R2.
  • Developed SSIS packages and SSRS reports in SQL Server 2008/ 2008 R2/2012.
  • Performed data cleansing by creating tables to eliminate the dirty data and implemented Error Logging using SSIS.
  • Developed Packages using most of the Tasks, Containers and Transformations in SSIS.
  • Created SSIS packages to do incremental data load between PROD and QA.
  • Strong background in Data Warehousing principles and methodologies.
  • Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
  • Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
  • Created Report Models for building Ad hoc reports using SSRS.
  • Created and managed roles for security in Reports.
  • Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes .
  • Installed SQL SERVER 2008/2008r2/2012/2014 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64 bit system .
  • Designed, Setup and Documented the Transactional Replication on multi TB database for the reporting purpose.
  • Met SLA’s fine tuning the SSRS and long running ETL queries.
  • Regularly supported service packs and hot fixes for both clustered and standalone SQL Server.
  • Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Worked in SVN version controlling environment.

Environment: : SQL Server /2012/2008 R2/2008, T-SQL, Excel, MS Access, Confidential BI, Windows Server 2008, Visual Studio, Query Analyzer, SQL Server Profiler 2008, SVN Version controlling.

SQL SERVER/MSBI DEVELOPER

Confidential, GLEN ALLEN, VA

Responsibilities:

  • Developed SQL queries to Insert, Update and Delete data in Database.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Developed, monitored and deployed SSIS packages .
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
  • Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
  • Responsible for fine tuning of the database, troubleshooting, memory management.
  • Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
  • Created reports based on database usage and perform capacity planning.
  • Responsible for creating user groups and assigning permissions.
  • Optimized stored procedures and indexed query using Index Tuning Wizard.
  • Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2008.
  • Created DTS packages to transfer objects from development server to production.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
  • Setup and maintained Linked Servers.
  • Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
  • Generated Ad-Hoc reports as per the client requirements using Report Builder.
  • Generated various SSRS Reports based on requirements.
  • Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008 R2/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports.

SQL SERVER DEVELOPER

Confidential

Responsibilities:

  • Involved in Physical and Logical design of the databases.
  • Developed DTS Packages to transfer the data between SQL server database and files.
  • Created and maintained Data Transformation Service (DTS) packages for migrating data.
  • Scheduled Jobs for DTS packages.
  • Used BCP/Bulk Insert to publish table output to text files.
  • Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions and Stored Procedures.
  • Used all Declarative Constraints for maintaining Data Integrity.
  • Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Implemented Auditing using triggers.
  • Created schema objects, rules and granted roles to the users.
  • Used SQL Profiler to debug T-SQL and slow running queries.
  • Monitored the Database Performance using execution plans and Index tuning.
  • Optimized the query performance with modifications in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.
  • Involved in scheduling backups of databases and logs and restoring them when necessary.

Environment: MS SQL Server 2000/2005, T-SQL, Windows 2000 server, Windows NT 4.0.

Hire Now