We provide IT Staff Augmentation Services!

Ms Bi Developer Resume

Milwaukee, WI

SUMMARY

  • Around 8 +years of experience in SQL Administration, Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2005/2008/R2/2012 Denali for both OLTP & Data warehousing(SSIS,SSAS,SSRS) applications in various business domains.
  • Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
  • Involved in relational data modeling and multi-dimensional modeling using Denormalization, Fact tables, Dimension tables, Star schema for OLAP systems.
  • Expert in SSIS script transformations using C# Script and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
  • Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
  • Designed Multidimensional and Tabular cubes using SSAS.
  • Creating reports using Netezza.
  • Created Calculated Members in the cube for additional functionalities.
  • Created/ Used MDX queries for accessing Cubes and used the data in SSRS reports.
  • Used SSAS Cubes for creating reports in SSRS and Customized SSAS cubes according the Clients requirement.
  • Strong knowledge of Data Warehousing methodologies and concepts, including star and snowflake schemas, ETL processes, dimensional modeling and reporting tools.
  • Experience in deploying created reports in various sources like Share points, Reporting servers.
  • Performed daily tasks including backup and restore usingtools likeSQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
  • Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Experience working in Waterfall and Agile development methodologies.
  • Self-Motivated with Excellent communication skills with a strong focus on Client oriented service and ability to work excellently as an individual and also as part of a team with minimum amount of supervision.
  • Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
  • Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
  • Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 2005/2008/2012.
  • Experience in creating maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.

TECHNICAL SKILLS

Languages: Transact SQL, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML.

Databases: SQL Server 2012/2008R 2/2008/2005/2000 ,MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

ETL Tools: DTS, SSIS

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2013/2007/2003/2000

Operating Systems: Windows / 98/2000/2003/ XP/7

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

MS BI Developer

Responsibilities:

  • Dealt with various internal teams of cyber security department for understanding the each business user’s requirement.
  • Designed various SSIS packages for load the data into Data Warehouse from different sources like flat files, excel documents.
  • Managed Package Configurations in SQL Server along with environment variable configuration to efficiently deploy Unit Tested Packages from Test/Development Environment to Production Environment.
  • Involved in relational data modeling and multi-dimensional modeling using Denormalization, Fact tables, Dimension tables, Star schema for OLAP systems.
  • Designed logical data model for a data Warehouse that accumulates and share the data among various internal team in IRM team.
  • Developed Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables, Error handling during the ETL process and scheduling the SSIS Packages using SQL jobs.
  • Created various Tabular, drill down, Cross Tab type Operational level reports for various teams in financial and cyber security teams using SSRS.
  • Created datasets using stored procedures and reports using multi value parameters
  • Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
  • Created Various Executive level management reports using SSRS, Power View Information Risk Management team.
  • Created and managed schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.
  • Optimized the performance of various SQL stored procedures using SQL profiler to improve the latency of reports pushed daily to management.
  • Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.
  • Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Environment: SQL server 2012, Visual Studio 2010 shell, SQL server management studio, SQL jobs, MS Dynamics 2013, MS excel 2013, MS Access 2013, Power view, Share point server 2010.

Confidential, Austin, Texas

MS SQL Developer (SSIS, SSAS, SSRS)/DBA

Responsibilities:

  • Involved in gathering Requirements from the Business and worked as a part of Data Modeling Process.
  • Continues Interaction with the business for the Data delivery and Data quality.
  • Performed ETL (SSIS) from various data sources like Data warehouse, Oracle, Excel, CSV, Text files and various client servers.
  • Monitored space usage, and adjust database as needed.
  • Monitored/created backup operations, and schedules manual backups as needed.
  • Developed various Stored Procedures and implemented different business logics, Filters to pull required data from sources.
  • Rebuilding indexes for the migrated tables and improved the table retrieving process by performance tuning
  • Maintain SQL Server Login administration, Backups and recovery plans.
  • Develop/Deploy SSIS packages in SQL Server 2008/R2.
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
  • Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Maintained Database performance/tuning by using various optimizing tools such as Performance Monitor, SQL Profiler and Other Red Gate Tools.
  • Performed various deployments and releases using REDGATE tools.
  • Immensely worked on Stored Procedures, Functions, Index’s and monitoring the Performance of all the Databases.
  • Established and enforced all database standards
  • Work with OPS to resolve production issues.
  • Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created SSAS Multidimensional Cubes for analysis.
  • Every third to fourth week, be on-call and support any database related issue (24x7).

Environment: MS SQL Server 2008/R2,BI,REDGATE, Visual studio, BMC Workflow,C#, XML, SQL Profiler, Nagios, ARIC, ERWIN, Version One, Agile Methodology.

Confidential, NEW YORK, NY

SQL Server Developer/ SSIS / SSRS

Responsibilities:

  • Responsible for creating the reports based on the requirements using SSRS 2005.
  • Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
  • Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
  • Participated in the Normalization and De-Normalization of database along with creating and managed clustered and non-clustered indexes to improve database performance.
  • Designed SSIS packages that could run on various environments by creating various types of XML and SQL Server configuration files for the variables being used in the packages.
  • Extensivelyused SSIS Import/Export Wizard, for performing the ETL operations and actively supported business users for change requests.
  • Extensively used for loop Containers and foreach loop containers to perform dynamic tasks in SSIS.
  • Monitored performance andoptimized SQL queriesfor maximum efficiency and planned the completeBack-up of various Databasesfor disaster recovery scenarios.
  • Identified and added thereport parameters; uploaded reports on to the report manager and organized them in folders.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
  • Deployedthe generated reports on to the server and fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005, MS Excel, Window XP, Toad.

Confidential, Columbia,MD

MS SQL Developer (SSIS/SSRS)/DBA

Responsibilities:

  • Developed various T-SQL queries, Stored Procedures for data retrieval, maintenance and testing.
  • Developed various SSIS packages for managing current and historical data using various transformations.
  • Developed complex SSRS reports involving Sub Reports.
  • Design and implement Master Data Services (MDS).
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
  • Automated the Batch Processing and Version Validation.
  • Created and published various Business rules to validate master data to ensure Data Accuracy and completeness.
  • Involved in updating the servers from 2005 to 2008R2.
  • Coordinated with platform hosting vendor(s) DBAs to ensure proper support maintenance, and tuning of various databases
  • Monitored space usage, and adjust database as needed.
  • Monitored backup operations, and schedules manual backups as needed.
  • Created and scheduled SSIS packages to pull data from SQL Server and exported to various data Sources like Excel Spreadsheets, Flat File etc and vice versa.
  • Used various control flow tasks like For Loop, Execute package/SQL tasks, Script task, send mail task etc. and different data flow tasks.
  • Worked on SSIS script task, look up transformations, persistent lookups and data flow tasks using T-SQL and Visual Basic (VB) scripts.
  • Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints Integral part of the Warehouse team for the Design, Development and functioning of cube.
  • Developed the performance of the server and creating new reporting jobs according the clients need.
  • Developed star schema’s and snow flake schema for various clients in AMS.
  • Developed MDX queries to extract data from Cubes to create reports.
  • Worked in Production environment and resolved the tickets in time to deliver the requirements.
  • Directed resource/capacity planning for systems/databases by monitoring databases, checkpoints, and back-ups.

Environment: MS SQL Server 2008R2/DENALI, SSIS, SSAS, MDS, VULCAN, EXCEL, Visual Studio, TFS.

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Created and developed the stored procedures, triggers to handle complex business rules, Historical data and audit analysis.
  • Conducted database management, performance measurement and tuning for new and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
  • Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
  • Created and administered multiple development, training and production databases.
  • Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
  • Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL clustering, quality assurance including database consistency check.
  • Responsible for creating standards and operating procedures to maintain all databases.
  • Worked with development teams in the design of physical databases and in modification.
  • Responsible for database security of the operational and developmental application system databases.
  • Expertise in dealing with the data on Property and Causality insurances.

Environment: MS SQL Server 2005, T-SQL, SQL Server Enterprise Manager, SQL Profiler, ExcelData Import, DBMS, C.

Hire Now