We provide IT Staff Augmentation Services!

Sql Server/bi Developer Resume

Rochester, NY

SUMMARY

  • Over 7 years of IT Professional experience in Development, Client Analysis, Database Design and Presentation using SQL Server 2008/2008R2/2012 and BI (Business Intelligence) tools such as SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
  • Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension, Tables, worked with high volume databases with partitioned data.
  • In depth experience in Business Intelligence Technologies and Database with Extensive Knowledge in ETL Process and Reporting Services using SQL server SSIS and SSRS.
  • Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, stored procedures, user defined functions, indexes, CTE and triggers using SQL Servers to facilitate efficient data manipulation and data consistency.
  • Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Query Optimization, Reporting, Designing logical/physical databases and Troubleshooting.
  • Expert at Creation and maintenance of Databases, creating Roles and managing user permissions, security and resolving deadlocks.
  • Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs, Drill Down, Drill Through, Cascading, Parameterize reports using SSRS in Business intelligence development studio (BIDS)
  • Experience in generating on-demand and scheduled reports for business analysis or management decision using (SSRS)
  • Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file, MS Access to data warehouse.
  • Data Loading Experience in SQL Server using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
  • Data analysis and data migration by using SSIS packages.
  • Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
  • Deployed and processed SSAS cubes daily or weekly to update information using SQL Agent.
  • Experienced in Cube designing in Business Intelligence Development Studio to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, roles, calculations using MDX, actions, partitions, perspectives, data-mining.

TECHNICAL SKILLS

  • SQL Server
  • SQL Server Management Studio (SSMS)
  • SQL Server Business Intelligence Development Studio(BIDS)
  • SQL Server Analysis Services (SSAS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • C#
  • T-SQL
  • MS Visual Studio
  • SQL Server DTS
  • SQL Profiler
  • Database Engine Tuning Adviser
  • QuickBooks
  • MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

SQL Server/BI Developer

Responsibilities:

  • Worked as a developer in creating stored procedures, triggers, function, tables, and other SQL joins and statements for applications.
  • Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions.
  • Fine-tuned DML, DDL scripts with lock hints for improving the performance.
  • Created reports on fraud Modi Operandi and most common products ordered. The report also contains information like the country and the internet domain from which the M.O. has emerged.
  • These reports are updated weekly and all the risk investigators are warned about such patterns. Whenever a new pattern is found, it is updated in the list.
  • Created SSIS packages both design and code to process data to target databases.
  • Executed data conversion ETL packages and generated the appropriate execution reports.
  • Developed stored procedures, views, and other objects required to transform, translate, retain aggregate data for complex data conversion requirement
  • Extracted data from various data sources such as MS Excel, XML, Flat files into SQL server
  • Used various transformations and different kinds of control flow tasks to process the data.
  • Configured packages event logs.
  • Scheduled the system and user database backups and restored them whenever necessary.
  • Designed and maintained various types of reports using SSRS SQL server reporting services like parameterized, drilldown and cascading reports.
  • Included report design and coding for standard tabular type reports, including drill down and drill through functionality and graphical presentations such as charts, gauge and map report.
  • Created the structure of the model and cube in SSAS and modified dimensions, measures, built hierarchy and perspectives.
  • Designed partitions in Cubes on time for improvement in performance using SSAS.
  • Used Data-Mining tools in SSAS to make prediction, scenario analysis to simulate the life expectations of the clients and market inflation, therefore can calculate the estimated total expenses so that can get the monthly payment and the final yield.

Environment: SQL Server, Windows Server, SSAS, SSIS, SSRS, Visual Studio, T-SQL, MS Office, SQL Profiler, Database Engine Tuning Adviser.

Confidential, Harrisburg, PA

SQL Server BI Developer

Responsibilities:

  • Wrote SQL queries to creating Stored Procedures, triggers, function, tables, and other SQL joins and statements for applications.
  • Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
  • Extracted data from various data source including OLE DB, Excel, flat files and XML using multiple transformations provided by SSIS such as data conversion, conditional split, bulk insert, merge.
  • Created SSIS packages to extract data from OLTP to OLAP data warehouse databases, and scheduled jobs to call the packages.
  • Involved in configuring and creating SSIS solutions for ETL and Data Migration services, and in managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
  • Created report based on those developed cubes and designed and maintained view and stored procedure to retrieve data from data warehouse to create corresponding data set for the Reporting Services (SSRS)
  • Experience in generating reports like tabular, chart, matrix, parameterized and drill through reports using SSRS. And built advanced reports using query parameters, report parameters, user access restrictions, filters.
  • Designed and implemented facts, dimensions and OLAP cubes using dimensional data modeling in SQL Server that maintained data.
  • SSRS reports helped in updating the existing documentation in a timely manner with new issues and solutions. These reports helped the customer care associates in solving the issues with which the customer calls in and pitching for contextual sales.
  • Involved in scheduled reports on a weekly basis that was generated every Friday containing the details of weekly sales for our location for assessing the business for that week.
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
  • Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
  • Developed User Defined Functions, indexes to generate the distinct data based on the type of the customer base.
  • Defined measure groups and further tuned dimensions attributes for a cube, created and deployed cubes to an instance of analysis services on the development server.
  • Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schema and Snow Flake Schema for developing Cubes using MDX.
  • Modified dimensions in the cube, created hierarchy and relationships among attributes, wrote SQL expressions to define named calculation.
  • Wrote MDX queries to define calculations including calculated members, named sets. Created Key Performance Indicators (KPIs) to evaluate the business.

Environment: SQL Server, SSRS, SSAS, SSIS, SQL Server Agent, T-SQL, MDX, Database Engine Tuning Adviser, Query Analyzer, MS Office, SQL Profiler.

Confidential, Paramus, NJ

SQL Server BI Developer

Responsibilities:

  • Developed backup restore scripts for SQL Server as needed.
  • Involved in Disaster recovery, database maintenance plan and Implemented replication.
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Involved in Performance tuning and Query Optimization.
  • Used Active-X scripting in SSIS for transformation of data into staging tables and performed multitask data pump
  • Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS). Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS. Designed and implemented stylish report layouts.
  • Identified and worked with Parameters for parameterized reports in SSRS 2005 and BIRT.
  • Deployed the generated reports in PDF format and in SSRS 2005 and BIRT
  • Designed and developed different type of reports including: tabular forms, matrix form, conditional, list items, charts and sub reports, drill down reports.
  • Developed advanced reports with functions, formula, parameterized reports, sub reports, cross tabs, ranking and conditional formatting.
  • Scheduled the reports to run on a daily and weekly basis and then review in Excel Spread Sheet
  • Created OLAP models based on dimension and facts for efficient loads of data based on Star Schema structure.
  • Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
  • Used Data-Mining tools in SSAS to make prediction, scenario analysis to simulate the future price of the company so that can make the best decision.

Environment: SQL Server, SSRS, SSAS, SSIS, SQL Profiler, Query Analyzer, MS Office, Database Engine Tuning Adviser.

Confidential

SQL Server Report Developer

Responsibilities:

  • Improved performance by creating Indexes and identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
  • Created complex stored procedures, triggers, functions, indexes, views implement business rules.
  • Gathered functional requirements and business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
  • Generated ad-hoc reports using SSRS.
  • Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
  • Designed and developed different type of reports including: tabular forms, matrix form, conditional, list items, charts and sub reports, drill down reports.
  • Developed advanced reports with functions, formula, parameterized reports, sub reports, cross tabs, ranking and conditional formatting.
  • Scheduled the reports to run on a daily and weekly basis and then review in Excel Spread Sheet
  • Responsible for designing, creating and deploying the reports.
  • Worked on existing OLTP system and created facts, dimensions, data models, star schema representation for the data mart of OLTP and OLAP databases.

Environment: SQL Server, SSAS, SSRS, MS Office. Database Engine Tuning Adviser.

Confidential

SQL Server Developer

Responsibilities:

  • Wrote stored procedures, functions, triggers, indexes to insert, update and captured the data
  • Created and scheduled Jobs using SQL Server Agent. And created alerts for error reporting.
  • Communicating with clients to understand the needs for website design and branding
  • Working on the design process relating to the front-end (client side) design of a website including writing mark up. Creating wireframes and sitemaps for websites and presenting the ideas to clients using Adobe Photoshop and Illustrator CS4
  • Writing and editing content Designing webpage layout using Adobe Dream Weaver CS4
  • Determining technical requirements, updating websites and Creating back up files
  • Testing things such as the complete functionality of forms or other scripts, last minute compatibility issues (Viewing differences between different web browsers), ensuring that the site is optimized to be viewed properly
  • Creating databases and tables using T-SQL queries to store the data from clients and also creating database objects like functions, stored procedure, Clustered and Non-clustered Indexes using MS SQL 2005
  • Developed Drilldown, Parameterized, Charts and Gauge reports in SSRS with the help of other team members
  • Also created cashed, dashboard and snapshot reports for the analysis of data for clients to help them in taking complex decisions

Environment: SQL Server, MS Office, Database Engine Tuning Advisor, SQL Profiler.

Hire Now