Sr.sql/msbi Developer/modeler/power Bi Resume
Rocky Hill, CT
SUMMARY:
- Around 8 years IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development, and Support of MS SQL Server 2008/2008R2/2012/2014 in Production, Testing and Development
- Experience with 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 with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
- Experience in coordinating with 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 2008, 2008R2, 2012, 2014.
- Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2008/2008R2/2012/2014 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 2008, 2008R2, 2012 and 2014 on Virtual Machines.
- Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
- Expert in developing SSIS packages.Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, 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 SSMS on SQL Server 2005/2008/2008 R2/2012/2014 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
- Experience in designing various Data Visualization Dashboards, gathering customer requirements, writing test cases, preparing analytical reports to help users to identify critical KPI's and partnering with developers to ensure full understanding of internal/external customer needs.
- Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
- Extensively worked on Creating, Populating, and maintaining Data marts. Thorough knowledge 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 (SSAS) using SQL Server 2005/2008/2012.
- Good Knowledge working with 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:
Languages: VB.Net, SQL, Web Services - C#, C, C++, Java
Operating Systems: Windows (XP NT 3.x- 4.0 200 ) and UNIX
Databases: MS SQL Server (2014, 2012, 2008, 2005, 7.0, 6.5, 6.0), MS Access, DTS, DB2
Reporting: Crystal Report, SQL Server 2014 Reporting Services (SSRS), Power BI, Qlik View
DBATools: SQL, Erwin, TOAD, T-SQL, VMware, PL/SQL
PROFESSIONAL EXPERIENCE:
Confidential, Rocky Hill, CT
Sr.SQL/MSBI Developer/Modeler/Power BI
Responsibilities:
- Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.
- Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.
- Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
- Worked on Azure/SQL on Premise Replication/ geo replication.
- Deployed Azure/SQL databases and other SQL settings using PowerShell.
- Continuous Integration through VSTS/TFS for tracking work items, code, build, deployment and release processes.
- Create technical design spec for changes, new features and/or enhancements of Azure SMDS Runners using OneNote, MS Word etc. Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default .
- Extensive hands on experience with SSIS to build huge packages which involves sourcing the data from a Tab Delimited Text Files, DB2, XML, Excel files and Flat Files and setting up the Variables and Parameters and mapping the obtained result sets to a Map Network Drive which uses the Merge Scripts.
- Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
- Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task. Actively involved in deploying and scheduling packages.
- Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
- Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
- Created Excel Reports, Power BI by connecting to various SQL server databases and improved the efficiency of these large reports.
- Added required measures, calculated columns, keeping unnecessary columns hidden from reporting view in Power BI application.
- Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
- Created power shell scripts to deploy the datasets, pipelines and linked services. Created power shell scripts to clean up the datasets and run the pipelines on demand.
- Involved in designing and developing packages for a Data Warehousing and Data Migration projects using Integration services (SSIS) on different Data Sources.
- Research and investigate key business problems through quantitative analyses of utilization, healthcare and cost data.
- Built new MDS (Master data services) and data warehouse application for business users and Migrated data from old data warehouse to new data warehouse. Developed and maintained Crystal reports as per the user requirement.
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
- Provided and defend conclusions and recommendations to customer based on results of analysis.
- Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.
- Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of software development lifecycle.
Environment: SQL Server 2016, Windows 2003/2016 Server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, ERWIN, TFS.
Confidential, Charlotte, NC
MS SQL Server Developer/BI Developer (SSIS/SSAS/SSRS Developer)
Responsibilities:
- This project was designed to perform new and renewal business on loans based on the details like company contact activities, financial accounts, and transfer data from different databases to SQL Server. My role in the project includes designing new database schema, extracting data, performing various transformations and then loading all the relevant data into a data mart and generate reports to analyze the company performance.
- Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
- Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
- Involved in error handling of SSIS packages by evaluating error logs.
- Successfully extracted, transformed and loaded data into data warehouse.
- Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
- Created tabular, matrix, chart, drill down reports, parametric reports, cascaded reports, dashboards and score card reports (SSRS) according to the business requirement.
- Designed, developed, and tested Qlik View scripts to import data.
- Worked on creating proper star schema data model for dashboard.
- Extensively used Custom Visuals from Power BI Custom Visuals Blog to meet the requirements.
- Shared Power BI reports using Content Packs, Email Share.
- Deployed and managed various Power BI reports in Power BI Service.
- Created Power BI gateways for data refresh to Source files or Source Databases.
- Developing the Power BI Dashboards; interactive Reports for the top management business users.
- Knowledge in creating cubes, perspectives, KPI's, deploying, processing and maintaining using SSAS.
- Design, Develop, Test, debug and implement Qlik View solutions based upon specified requirement.
- Extract transform and load data from multiple sources into Qlik View applications .
- Created reports by dragging data from cubes and wrote MDX scripts.
- Performed the migration of procedures, tables with and without data and other database objects between different environments
- Used SSIS 2013 to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data into OLAP databases
- Working on extracting the logs from cosmos using Scope.
- Developing the reports using POWER BI, Power Pivot and SSRS and SSIS, SSAS and Cosmos. Adding the feeds and scheduling the jobs
- Extracting the Data from Different data sources to Big Data platform cosmos and Transform the data to Dimensions and Facts.
- Improved the performance of long running views and stored procedures.
- Using SQL Server Integration Services (SSIS) to populate data from various data sources Developed web based front-end screens using MS FrontPage, HTML and Java Script. Actively designed the database to fasten certain daily jobs, stored procedures.
- Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
- Create, manage SQL Server AZURE Databases.
- Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers
- Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only the required data.
- Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
- Tuned the queries using Execution plan, to get index seek from table scan and index scan. Improved the performance of many queries by 90%.
- Worked with Erwin data modeling tool
- Created Database objects including Tables, Views, Stored Procedures and User Defined Functions.
- Created Schemas, indexes, Triggers (after and instead of triggers).
- Extensively involved in writing database scripts.
Environment: SQL Server 2014, SQL Server Management Studio (SSMS), Microsoft Visual Studio 2013, SQL Server Integration Services (SSIS), SSAS, HTML, Qlik view, SQL Server reporting services (SSRS), Cosmos, IIS, VB.Net, Erwin, MS Excel.
Confidential, Washington DC
SQL Server Developer
=Responsibilities:
- Working as SQL Server Analyst / ETL Analyst using SQL Server 2012 for CMH Project.
- Source Controlling using IBM Rational Clear Case
- Developing and Management Database for Collateral Management and Hedging
- Writing Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
- Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
- Create / Manage Table Indexes, Query Tuning, Performance Tuning, Deadlock Management
- Defect tracking and closing by using HP Quality Center
- Design and Deploy SSIS Packages
- Creating SSIS Packages, Configure SSIS packages for different environments using DTS Configure.
- Created and Scheduled Weekly Qlik view custom reports extensions to distribute on email using NPrinting.
- Produce CSV, utilize CSV files as part of ETL Process
- Used .Net Scripts in SSIS
- Produce XML Files for Tibco (Real Time Data Transfer)
- SSIS Error Handling, Event Handling, Logging, Batch Checks for data accuracy
- Code deployments / configurations/ config management in various environments
- Implement Security, Roles, Logins, and Permissions
- Extract-Transform-Load data into SQL Server 2012 Normalized database from various sources
- Maintain Users / Roles / Permissions, Security
- Scheduling SSIS packages using Autosys, writing JIL Scripts
- Enhance existing applications to meet new business requirements
- L3 Production Support on Rotation basis
- Enhance existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
- Capacity Planning DBs, Disk Requirements
- Deploy the code in various environments i.e. DEV/SIT/UAT
- Create and maintain DB Change Log to track the state of the DB in each environment (Dev, Test, UAT, Pre-Prod)
Environment: SQL Server2012, VB.NET, Oracle 11g, Microsoft Visual studio 2013, Clear Case 7.1, Autosys, Qclick view, Share Point, SQL Server 2012 Integration Services, Quality Center 10.0, Compass Point
Confidential, Glen Allen, VA
Senior SQL Developer/Modeler
=Responsibilities:
- Generate Dash Board Reports for Internal Users using SQL Server 2008 R2 Reporting Services and Dundas Reporting
- Application Testing, Debugging SIT, UAT, Test Clusters, Test Load Balancers
- App Testing in Development, Production, DR
- UML Use Case diagrams, Conceptual Flow Diagrams, ER Diagrams by reverse engineering the databases using Visio 2007
- Deploy various reports on SQL Server 2008 Reporting Server
- Tuning the Databases, Auditing, Dynamic Management Views
- Database Capacity Planning, Maintenance Plans, Backup, Restore
- Data Modeling, Conceptual/Logical/Physical Modeling
- Create and maintain database for Incident, Problem Tracking, Metrics
- Working with SQL, and T-SQL
- Design Reports as of Internal User needs
- Access SharePoint Server using Web Services to deploy reports on Reporting Server
- Working with Stored Procedures, functions, triggers, Views
- Involved in creating tables, stored procedures, indexes
- Creating and Maintain users
- Creating / Running jobs with SSIS packages
- Design, Creating and Deploying various SSIS Packages (for ETL - Extraction, Transformation, Loading)
- Configuring the Database Mail, Mail Operators using SQL Server 2005
- Creating Jobs, Job Notifications
- Involved in creating calculated members, named set, advanced KPI'S for SSAS cubes.
- General Day to Day Database Administration
- Importing Data from various sources like DB2, Oracle, Excel, XML
- Developed UNIX shell scripts to run the SQL scripts to generate reports and sending out email.
- Prepared Technical Documentation.
- Performance tuning of SQL queries consisting of many tables with large amount of data.
- Created Packages, Procedures and Functions that extensively used PL/SQL cursors, user defined object types and exception handling.
- Extract the Data from Cosmos to SQL layer, and Build SSAS Cubes
- Ensuring Data Consistency, Analyzing the Data
- Detailed Documentation of all the existing and new processes, Create and Update Data Dictionaries
- Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions
Environment: SQL Server 2008 R2, SharePoint 2010, .NET, Windows XP, Excel, XML, DB2, Oracle, Reporting Services (SSRS), PL/SQL, Integration Services (SSIS), SSAS
Confidential
SQL Developer
Responsibilities:
- Participated in developing Logical design of database incorporating business logic and user requirement and building entity relationship (ER) diagrams.
- Experienced in writing T-SQL scripts, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS).
- Created Data migration utilities (Import & Export, Bulk Insert) from text to SQL Server.
- Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
- Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
- Involved in migration and transformation of data from one server to another server.
- Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
- Participated in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL Server Analysis Services (SSAS).
- Created Data marts for Staging and Production databases for Operational Data Stores (ODS).
- Analyzed multidimensional cubes in SQL Server Analysis Services (SSAS) by using slicing and dicing.
- Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders.
- Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS.
- Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
Environment: MS SQL Server 2008/2005, Excel (pivot tables), SSIS, SSAS, SSRS, T-SQL, VB Script, Visual studio 2005, Erwin, Windows Server 2003.