We provide IT Staff Augmentation Services!

Ms Sql Server Ssrs/ssis Developer/bi Developer Resume

5.00 Rating

Los Angeles, CA

SUMMARY

  • Over 8 years of IT experience as MS SQL Server Developer 2014/2012/2008 R 2/2008/2005/2000 and MS Access in various Industry verticals like Insurance, Telecommunication and Bank.
  • Strong experience in Stored Procedure, User Defined Function, TSQL coding, Performance Tuning and Query Optimization.
  • Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
  • Wrote and modified stored procedures/Triggers (DML/DDL) to implement complex business rule.
  • Involved in developing stored procedures, triggers for the application.
  • Expertise in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.
  • Extensive Knowledge in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages. Familiar with Metadata knowledge and experience in creating E-R Diagram
  • Expert in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema
  • Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2008/2005 (SSRS).
  • Enhanced various existingMSAccess2007 database applications. Migration ofMSAccess2003 databases toMSAccess2007.Enhanced existing and designed newMSAccess2007 tables, queries, forms, reports, macros, modules and switchboards.
  • Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.
  • Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQLDatabases MS SQL Server Denali,2012,2008R2,2008,2005,2000,Oracle 9i/10g (SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Visual Studio, Crystal Reports.

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques.

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio,Crystal Reports, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

MS SQL Server SSRS/SSIS Developer/BI Developer

Responsibilities:

  • Planned, defined and designed data based on business requirement and provided documentation.
  • Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
  • Analyzed the existing data and performed the appropriate changes from SQL Server 2008 to SQL Server 2014 by following the Normalization standards to maintain data consistency and by performing data validation. Providing technical support for users via trouble ticket system.
  • Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes.
  • Creating user accounts and appropriate privileges as well as maintainingdatabasesecurity
  • Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate).
  • Enhanced various existingMSAccess2007 database applications. Migration ofMSAccess2003 databases toMSAccess2007.
  • Created Dynamic SSIS packages using complex expressions, variables and control flow components such as ForEach Loop, For Loop to loop over a Directory to load inbound files coming daily.
  • Enforced the Business Rules to filter bad data from the system by using Complex T-SQL Statements, and implemented various Constraints and Triggers for Data Consistency.
  • Responsible for creating the reports based on the requirements using SSRS 2008.
  • Created different type of reports which include: Cross-tab, Conditional, Sub report, Drill-down and Parameterized and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports.
  • Monitoring performance and optimizing SQL queries for maximum efficiency
  • Deployed and upload the SSRS reports to SharePoint Server for the end users and Involved in Enhancements and modifications
  • Administrated the created Reports by assigning permission to the valid user for executing the reports.
  • Extensive knowledge of Metadata and experience in creating E-R Diagram.
  • Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.

Environment: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Business Object 3.1, Microsoft Excel

Confidential, MASON, OH

MS SQL Server SSRS/SSIS Developer/ Data Analyst

Responsibilities:

  • DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access, DB2 and transform and then load intoDimension and Fact tables in Data Warehouse using SSIS.
  • Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
  • Interact with the Enterprise Data Warehouse team to facilitate and document the data mapping to the Reporting SQL Server environment.
  • Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table. Migration ofMSAccess2003 databases toMSAccess2007.
  • Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.
  • Provided design, implementation and maintenance for custom reports and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
  • Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008.
  • Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports. Troubleshooting and Performance Tuning in SQL Server..
  • Worked with project manager and technical leads for resolution of technical issues..
  • Worked on formatting SSRSreports using the Global variables and expressions.
  • Createdparameterized reports, Drill downandDrill throughreports using SSRS.
  • Diagnoses and resolved data mart access and performance issues

Environment: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, SSAS

Confidential, Plano, TX

SQL Developer/BI Developer/Data Analyst

Responsibilities:

  • Created SSIS package to export and import data fromSQLServer to Access, text and Excel file. Used Event Handlers for Exception Handling in SSIS packages
  • Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services
  • Modified the existingSQLqueries according to the requests and executed them to check the performance.
  • Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional data Modeling principles in SSAS
  • Created data flow model using MS Visio
  • Used SQL Server Profiler to trace the slow running queries and the server activity
  • Scheduled Jobs and Alerting using SQL Server Agent
  • Created stored procedures, views, triggers, user defined functions to in corporate the flow of business.
  • Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS. Troubleshooting and Performance Tuning in SSRS.
  • Created SSRS reports to retrieve data using Stored Procedures that accept parameters
  • Performed daily tasks including backup and restore by using MS SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Windows 2003/2000 and T-SQL.

Confidential, Portland, ME

SQL Server Developer

Responsibilities:

  • Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.
  • Designed and modeled Microsoft SQL Server 2005 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2000 data warehouse and data marts.
  • Used SSIS packages to roll our data to Live Tables and to Processing Database. AsDatabaseAdministratorin full-service event-management company I was responsible for managing and maintaining databases entry in Access, Excel and had responsibilities to assist in events organization and preparation.
  • Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
  • Configure the SSIS Package for run time Parameters and Configured file
  • Develop the Documents for Logging/Error Handling for SSIS Packages
  • Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
  • Schedule Package using SQL Server Job for weekly/monthly basis.
  • Used Checkpoint for avoiding re-executes Package from the first task.
  • Develop the Slowly Changing Transformation to maintain the Historical Data.
  • Handling the errors during data moving and Sequencing the task as per requirements.
  • Perform T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2005.
  • Migrated some Crystal reports to SSRS reports manually. Troubleshooting and Performance Tuning in SSIS.
  • XML result set from Stored Procedures to create custom XML file for third party data export.
  • Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.

Environment: SSIS, MS SQL Server 2008, Windows 2003

Confidential

SQL Server Developer

Responsibilities:

  • Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.
  • Designed and modeled Microsoft SQL Server 2005 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2000 data warehouse and data marts.
  • Used SSIS packages to roll our data to Live Tables and to Processing Database.As Database Administrator in full-service event-management company I was responsible for managing and maintaining databases entry in Access, Excel and had responsibilities to assist in events organization and preparation.
  • Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager Configure the SSIS Package for run time Parameters and Configured file
  • Develop the Documents for Logging/Error Handling for SSIS Packages
  • Integrate the SSIS package, converting all existing DTS packages of MS SQL by adding extra SSIS task.
  • Schedule Package using SQL Server Job for weekly/monthly basis.
  • Used Checkpoint for avoiding re-executes Package from the first task.
  • Develop the Slowly Changing Transformation to maintain the Historical Data.
  • Handling the errors during data moving and Sequencing the task as per requirements.
  • Perform T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2005.
  • Migrated some Crystal reports to SSRS reports manually. Troubleshooting and Performance Tuning in SSIS.
  • XML result set from Stored Procedures to create custom XML file for third party data export.
  • Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.

Environment: SSIS, MS SQL Server 2008, Windows 2003

We'd love your feedback!