Sql Business Intelligence Developer Resume
CaliforniA
SUMMARY
- Having 6 Years of Experience in IT, with 4+ years as Database Developer & Administrator and 2+ years as Systems/ Network Administrator. Well versed and Experienced in Microsoft SQL Server 2014/2017, SSIS/SSRS/SSAS for both OLTP and OLAP (Data warehousing) environments, Business Intelligence(BI) Project Development, Implementation and Administration from end to end by usingMicroStrategy9.x/8.x Product Suites includingMicroStrategyDesktop, Web, Architect, Administrator, Intelligence Server. Network installation & Security and Computer Hardware Configurations respectively.
- Experience in creating database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T - SQL in Development and Production environment for SQL Server 2016 R2.
- Experience in writing Stored Procedure/T SQL coding, Performance Tuning and Triggers.
- Having Good Knowledge on E-R Models in OLTP.
- Expert inExtraction, Transforming and Loading the data by extract data fromExcel File and Flat File sources and load into various Business Entities.
- Proven proficiency at Data Transformations like Derived Column, Conditional Split, Merge join, Lookup, Execute SQL Task to load data into Data Warehouse.
- Expertise in Developing SSIS packages, good exposure of usage various tasks, error handling, Event handlers, configuring packages and deployment of packages.
- Maintaining the Log and Audit information n the SQL tables.
- Ability to create Subreports and Linked Reports using SSRS Queries and develop Report Structure with data definition, report layout and report definition language.
- Created simple and complex reports by customizing look and feel by using various report models and pass the parameters according to business user's request.
- Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
- Having good knowledge on creation and scheduling of SQL server agent jobs to run daily ETL.
- Having good working exposure on creation and processing of cubes.
- Having good working exposure on create analytical reports using cubes.
- Having knowledge on writing MDX queries.
- Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
TECHNICAL SKILLS
Databases: SQL Server 2014/2008/, Tableau,MS Access,DB2,UDB,TeradataOracle 7.x/8i/9i/10g/11g
Reporting Tools: SQL Server Reporting Services (SSRS) 20017/2012/2008 , SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Data Transformation Services (DTS), Visual Studio 2017/18 POWER BI, Tableau, Excel, Smartsheet
Languages: SQL, T-SQL, PL/SQL,VBScript, JavaScript, .Net 3.5 (VB.Net & C#.Net)
Operating Systems: Windows 98/NT/2000/XP, UNIX (Solaris/Linux/AIX), Windows Server 2003/2008….
Web Technologies: HTML, XML, CSS, AJAX,JQUERY
Network Topologies: TCP/IP, FTP, SMTP
PROFESSIONAL EXPERIENCE
Confidential, CALIFORNIA
SQL Business Intelligence Developer
Responsibilities:
- My role in project is to perform test scenarios and tan test cases and created test data for testing the application. Actively involved in functional, unit and integration testing in agile methodology. Created and executed test cases, test scripts based on ETL Mapping document theirfore extract data, securely transmit it to a data Warehouse, standardize the content, and generate reports. The project includes around 10-12 data sources whose data is merged together and put into a single database using various business logics to develop a complex cube with various perspectives and measure groups.
- Installed SQL Server 2017 on development and production servers setting up databases, users, roles and permissions.
- Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Getpivotdata, Dashboards), Power View, Power Map and Heat Map
- Upgraded all SQL Server 2016 to SQL Server 2018 without any service interruption.
- Involved in the normalization and denormalization of the databases.
- Tested/Found the defects in Backend DWH staging tables, Facts and Front-End Cubes and reports.
- Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2018.
- Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor
- Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
- Generated Complex reports in Cognos 11.1 report studio including Drill Down reports from DMR modeled Framework model.
- Created Dashboards to present critical company data in a single report.
- Created list reports & cross tab reports using cognos 11.1
- Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio
- Experience in developing Framework Manager Models and analyzed those models in analysis studio.
- Gatheird and analyzed business requirements from users and business community.
- Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
- Created Sophisticated Reports using Report Studio.
- Tested/Found the defects in Backend DWH staging tables, Facts and Front-End Cubes and reports.
Environment: Informatica, Oracle 11g, SQL Server, TOAD, QTP, data validation (DVO), Oracle SQL Developer, PL/SQL, Teradata, Congo’s, Agile/Scrum, SQL, Rally, MS Outlook, MYSQL,MS Office, Windows 7, Unix.
Confidential, CHICAGO
SQL Business Intelligence Developer
Responsibilities:
- My role in project is to create page views, so that Based on the page views and shopping cart data, reports were created by using SSIS tools, where ETL exists to support the reporting and analytical requirements. Where ETL tool is implemented with supporting role in mind Statistical information like average orders, sales per unique visitors, customers behaviors were also reported. which help to improve customer service end goal is to handle project to meet requirements
- Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
- Involved in project planning, scheduling for database module with project managers. I Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
- ETL tool used for source data into respective target tables to build the required data marts and Used Performance Point Server to create reports, scorecards and dashboards.
- Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
- Reviewed and developed data models and database designs with development teams
- Performed DBA tasks through Enterprise Manager, Query Analyzer, Import Export wizard
- Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
- Developed custom PowerShell script to tie into the filesystem watcher .net class and mimic the functionality of a document management solution, managing documents and complex permissions that are typically not possible
- Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
- Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
- Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
- Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
- Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
- Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
- Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
- Provided via the phone, application support. Developed and tested Windows command files and SQL Server queries for Production database monitoring in 24/7 support.
- Good exposure in running jobs in enterprise manager using job scheduling tool.
Environment: MS SQL Server 2005/2008, MS Visual Studio 2005, Windows 2000/2003, SSIS, SSAS, MDX
Confidential, Dallas
SQL Business Intelligence Developer
Responsibilities:
- Worked along with the BearingPoint (BE) team as an SQL Server developer with responsibilities such as the design, document, development, enhancement and support of the project. Where Confidential Virus Scan and related security products and services, including the Intrashelf, Intercept, and Found stone brands.
- Involved in gathering requirements, performing source system analysis and development of ETL jobs to populate data from the transactional data source to the target Data warehouse. skilled in Managing the work for creating SQL data sets for Tableau recurring and Ad-hoc Reports.Created ad-hoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports worked directly with stakeholders for requirements gathering and developing various decision making Dashboards.
- New project according to BA cards worked on health care project Gatheird the Requirements for Enhancement of Electronic Lab Reporting Dashboard and implemented the timely status/error messages in the Dashboard
- Involved in testing for contract set-up, enrollment and claims processing for four new managed care contracts for Medicaid mental and physical health providers.
- Involved in intensive system level testing of analyzing the HL7 messages coming out and in of EPIC Bridges.
- Responsible for the mainframes that receive the HL7 message in pre-approved format from the middleware as disclosed in the documentation.
- Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
- Created parameterized reports, Drill down and Drill through reports using SSRS
- Created maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS even scheduled various reports in Oracle Roast like Tabular Reports, Matrix Reports & Parameterized Reports using SSRS
- Worked on Data modeling, creating star and snowflake schemas in SSAS.
- Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
- Scheduled .dtsx packages execution to load data into Fact Tables using SQL Server Agent
- Creation of SSRS Reports to generate various Drill-down, Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
- Responsible for Deployment of the SSRS reports and creating Subscriptions (Data Driven and Standard) to various business users.
- Performance Tuning of SQL queries, Stored Procedures SQL Profiler, resolving Deadlocks and long running queries by checking appropriate changes to Isolation levels.
Environment: MS Windows, Quality Center, Rhapsody version 2.3.1, 2.5.1,HL7, SQL, MS Visio, MS Project, MS Office (PowerPoint, MS Word, MS EXCEL), Web 2.0, SQL, Oracle, SDLC, Agile, MS-Project 2010
Confidential
SQL Business Intelligence Developer
Responsibilities:
- My role in project to Develop best practices for database design and development activities and designed database systems based on the end user's requirements. The scope of the system is to view data into a structured format and designed to provide valuable information for their project dis is done by pulling the data from different sources and exploring the processed data into reports in different formats and hence helping their business decision making process
- Installing, configuring, administering and securing production servers, Even Setup new MS SQL Server instances and databases.
- Capacity planning of MS SQL Servers. And Implement to maintain database security...
- Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
- When errors occur, and vast cases sometimes solved issues by Troubleshoot and minimize production down issues.
- Running DBCC consistency checks, and fixing data corruption in application databases.
- Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
- Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
- Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
- Data conversions and data loads from various databases and file structures.
- Monitor failed and long running MS SQL Server jobs.
- Maintaining User account administration for Different domains.
Environment: SQL Server 7.0, Transact-SQL, Enterprise Manager, Query Analyzer, MS-ACCESS 2000
