Msbi Developer (ssis, Ssrs, Ssas) Resume
Addison, TX
SUMMARY
- Around 5+years of IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2017,2016,2015,2008, in Production, Testing and Development
- Experience wif software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
- Extensive experience in interacting wif business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
- Experience in coordinating wif users in gathering source data files, defining data elements, business rules, data and process flow documentation, prepare High level and Low level design documents.
- Experience in installation, configuration of MS SQL Server 2017, 2016, 2015, 2012, 2008R2 and 2012.
- Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2016/200 /2008 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
- Knowledge of Relational Database Management systems.
- Experience in Database Backup, Recovery and Disaster Recovery procedures.
- Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
- Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
- Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
- Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
- Install and Configure SQL Server 2016, 2015, 2012, 2008, 2008R2 on Virtual Machines.
- Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.
- Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using onSQLServer 2008/2012,2016,2017 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
- Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks
- Extensively worked on Creating, Populating and maintaining Data marts. Thorough noledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
- Having experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.
- Good experience in creating SQL Server Analysis Projects using SQL Server 2017/2016/2012/2008.
- Good Knowledge working wif Facts, Dimensions, Multi-Dimensional Cubes.
- Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.
- Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.
- Experience in Data Modeling using Erwin Design Tool
- Knowledge of Networking Concepts and Object Modeling Technology.
- Good interpersonal, Analytical and Communication skills
- Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.
- Experience in Object Oriented Analysis concept implementation, design, and programming technical skills.
TECHNICAL SKILLS
Relational Database Management Systems (RDBMS): SQL Server 2008/R2, 2014, 2016, 2017, 2018, Oracle
ETL Tools: Import/Export Wizard, Microsoft SQL Server Integration Service (SSIS), and InformaticaReporting Tools SSRS, MS Excel, Power Business Intelligence, and Tableau.
Analytical Tools: SSAS - multidimensional and tabular model
Programming Languages: C#, ASP.NET, T-SQL, PL/SQL, MDX, and DAX.
Web Technologies: HTML, CSS,JAVASCRIPT
Cloud Technologies: Azure SQL Database
Methodologies: Agile, Scrum, Waterfall
Other Tools: TFS (Team Foundation Server), Visual Studio 2013, GitHub, and JIRA (JQL queries)
PROFESSIONAL EXPERIENCE
Confidential, Addison, TX
MSBI Developer (SSIS, SSRS, SSAS)
Responsibilities:
- Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
- Excellent Experience in monitoring SQL Server Performance tuning in SQL Server
- Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS.
- Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
- Experienced in Building Cubes and Dimensions wif different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
- Thorough noledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
- Good working noledge on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
- Experience in creating Ad hoc reports and reports wif complex formulas and to query the database for Business Intelligence.
- Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using Drill-down, Drill-through And Cascading reports using SSRS.
- Flexible, enthusiastic and project oriented team player wif excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
Environment: MS SQL Server 2016, Visual Studio 2017/2019, SSIS, Actian Data Connect, CozyRoc, Share point, MS Access, Team Foundation server, Git.
Confidential, San Diego, California
SQL Developer
Responsibilities:
- Create and maintain database for Server Inventory, Performance Inventory.
- Worked in Agile Scrum Methodology wif daily stand up meetings, great noledge working wif Visual SourceSafe for Visual studio 2010 and tracking the projects using Trello.
- Generated Drill through and Drill down reports wif Drop down menu option, sorting the data, and defining subtotals in Power BI.
- Used Data warehouse for developing Data Mart which for feeding downstream reports, development of User Access Tool using which users can create ad-hoc reports and run queries to analyze data in the proposed Cube.
- Experience in creating packages to transfer data between ORACLE, MS ACCESS, FLAT FILES, Excel Files, to SQL SERVER 2008R2 using SSIS.
- Deployed the SSIS Packages and created jobs for efficient running of the packages.
- Expertise in creating ETL packages using SSIS to extract data from heterogeneous database and then transform and load into the data mart.
- Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
- Great Expertise in Deploying SSIS Package to Production and used different types of Package configurations to export various package properties to make package environment independent.
- Experienced wif SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
- Developed stored procedures and triggers to facilitate consistent data entry into the database.
- Shared data outside using Snowflake to quickly set up to share data wifout transferring or developing pipelines.
- Used Snowflake to set up an Insights-as-a-Service platform.
- Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
- Wrote complex SQL Queries using multiple joins for creating Adhoc reports using Report builder based on the requirements.
- Designed SSRS reports wif sub reports, dynamic sorting, defining data source and subtotals for the report.
- Deployed SSRS reports to Report Manager and created linked reports, snapshots and subscriptions for the reports and worked on scheduling of the reports.
- Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
- Worked wif T-SQL to create Tables, Views, and triggers and stored Procedures.
Environment: Windowsserver, MSSQLServer 2014, SSIS, SSAS, SSRS, SQLProfiler, Power BI, C#, Performance PointServer, MS Office, SharePoint
Confidential, Irving, TX
SQL Server Developer
Responsibilities:
- Working as SQL Server Analyst / Developer / DBA using SQL Server 2012, 2015, 2016.
- Created jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
- Manage and update the Erwin models - Logical/Physical Data Modeling for Consolidated Data Store (CDS),
- Actuarial Data Mart (ADM), Reference DB according to the user requirements.
- Source Controlling, environment specific script deployment tracking using TFS
- Export the current Data Models into PDF out of Erwin and publish them on to SharePoint for various users.
- Developing, Administering, and Managing corresponding databases: Consolidated Data Store, Reference
- Database (Source for the Code/Values of the Legacy Source Systems), and Actuarial Data Mart
- Writing Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), Create and maintain
- Physical Structures.
- Working wif Dynamic Management Views, System Views for Indexing and other Performance Problems
- Analyze the Legacy Data, Import the data into Reference DB dat was verified and published by DMRB (Data
- Management Review Board)
- Liaison wif ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.
- Creating ETL mappings using Informatica Power Center
- Day to Day maintenance of databases, Staging, Backup / Restores of databases.
- Deployment of Scripts in different environments according to Configuration Management, Playbook requirements
- Create / Manage Files/File group - Table/Index association
- Query Tuning, Performance Tuning.
- Defect tracking and closing by using Quality Center
- Maintain Users / Roles / Permissions.
- Capacity Planning, Disk Requirements
- Creating Range and Hash(by using MOD function) Table Partitioning, Index management
- Create and maintain Change Log to track the state of the in each environment
Environment: SQL Server 2008/2012 Enterprise Edition, SSRS, SSIS, T-SQL, Windows Server 2003, Performance Point Server 2007, C/C++, Oracle 10g, PL/SQL, Visual SourceSafe, visual Studio 2010