We provide IT Staff Augmentation Services!

Sr. Sql Business Intelligence Developer/analyst Resume

Los Angeles, CA

SUMMARY

  • 7 years of Professional experience in the IT industry as a MS SQL Server Developer and Systems Analyst using Microsoft SQL server 2012/2008R 2/2008/2005/2000 in Banking, Finance, Insurance, and Health Care Domains.
  • Business Analyst skills - Understanding of Rational Unified Process (RUP), Unified Modeling Language (UML), Software Development Life Cycle (SDLC), Object Oriented Analysis and Design Concepts (OOAD), Business Process Re-engineering (BPR), Test Lifecycle, Data Modeling, Service Oriented Architecture (SOA). Information Technology Information Library (ITIL), Business Intelligence (BI), Prototyping, Agile and extreme programming methodologies.
  • Good experience in conducting Joint Application Development (JAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a projects exposure to the forces of change.
  • Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
  • Extensive experience in Performance Monitoring and Tuning of SQL Statements, Sub Queries, Joins, Cursors and Functions.
  • Excellent T-SQL Queries, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, Also created Indexed Views, complex Stored Procedures, CDC, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
  • Experience in Data Modeling (Logical and Physical Design of Databases) using Visio/Erwin, Normalization and building Referential Integrity Constraints.
  • Experience in Data Modeling, Database Design, Programming and Implementation of Client-Server Applications & Database systems using MSSQL 2005/2008/2012 for both OLTP (Batch Processing, Online Processing) & Business Intelligence (SSIS, SSAS, SSRS) applications.
  • Expert in working with the Business Intelligence Development Studio (BIDS), which includes SSIS, SSRS.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
  • Involved in building Dimensional Cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS),
  • Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2008/2012
  • Experienced in Extraction, Transformation and Loading (ETL) process using DTS, MS-SSIS application tools.
  • Expert in generating Drilldown reports, Parameterized reports, Linked reports, Sub reports and filters, charts in SSRS 2008/2012.
  • Excellent communication skills, analytical skills, understand business requirements in various domains.
  • Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2005/2008/2012.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2005/2008/2008 R2,Access 2003/2007,OLTP/OLAP, DB2

Languages: T-SQL,MDX,VB Script

Developer Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, DTS Import/Export, Visual Studio 2005/2008/2010.

ETL Tools: Data Transformation Services(DTS),SQL Server Integration Services (SSIS)

Analysis Tools: SQL Server Analysis Services (SSAS)

Reporting Tools: SQL Server Reporting Services (SSRS), Cosmos

Operating systems: Windows Vista/XP/2007/2008

MS Office: Microsoft Word/Excel/Access/PowerPoint

Methodologies: Rational Unified Process (RUP), Waterfall, Agile/Scrum & SDLC

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Case), UML, MS Visio

Testing Tools: Rational Clear Quest, Mercury Test Director

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr. SQL Business Intelligence Developer/Analyst

Responsibilities:

  • Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.
  • Used questionnaire, surveys, JAD sessions and Brainstorming sessions as requirement elicitation techniques. Framed a detailed agenda for JAD. Facilitated JAD sessions. Took aggressive efforts towards completion and finalization of documentation towards the end of JAD sessions.
  • Assisted the data analyst in resolving issues with Data modeling and Data Mapping (such as understanding the fields and its attribute).
  • Worked on Reports as simple as just Data Dump forms a table to as complex as reports with Multiple Tablix within same report with various functionality like Drill through, Parameterized and Chart reports.
  • Designed and implemented variety of reports (Parameterized, Drilldown, Sub-Reports, Drill Trough, Matrix, Linked, and Chart Report) and also involved in Optimization of those reports.
  • Helped HR department in creating a report with year to year and month to month summary using Matrix functionality.
  • Performed requirement walkthroughs with the testing team to develop testing strategies and test plans such that test cases reflect user needs.
  • Created Drilldown report to show different HR measures such as Hirecount, HeadCount, Terminations, and Turnover etc for various hierarchies such as Division, Region, District, Category, sub-category, Job-Function, Job-Title etc with summary after each hierarchy.
  • Built a report to compare data in two Different Sources. The main report displayed a summary of number total of differences as per column with drill through functionality to the detail report of the records with difference in that particular column.
  • Built a SSIS package to develop Staging Tables which would hold the required data for larger reports, to save the report processing time each time the reports is being accessed by the users, as all the calculations will already be performed by SSIS package in the non-business hours every day.
  • Worked with various control flow tasks of SSIS including Data Flow Task, Execute SQL Task, etc including Container Tasks like For Loop Container and Foreach Loop Container and used Sequence Container to manage various tasks.
  • Converted the FOXPRO code to SQL and then built report out of that.
  • Developed reports using Global Variables and Expressions that assisted in making the reports Dynamic so that it displayed the results based on the Input Parameters.
  • Held the authority to manage the Security of the developed reports in the development environment by providing different kinds Access to different people depending on the role of the users in the report like Browser Access, Content Manager Access etc.
  • Created Menu Reports i.e. a report that would provide menu of reports that comes under same group, and which would direct user to the specific report they click on.
  • Created various kinds of Chart Reports such as Bar Chart, Line Chart, and Pie Chart. Also created complex chart report with two axes (primary and secondary axes) to show data with various data types/formats such as Hire count and Turnover in various chart formats within same graph.
  • Worked on scheduling automatic run of the reports using Subscription and deliver the reports to the business users, in various formats and with various messages using expressions, as per the business requirement.
  • Managed the bigger report to use Snapshot Report feature to save the processing time of the reports which are being continuously accessed by different users.

Environment: MS SQL Server 2008R2, DB2, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (SSIS, SSRS), MS Office 2010, MS Visio 2007.

Confidential, Phoenix, AZ

Sr. SQL Business intelligence Developer /Analyst

Responsibilities:

  • Helped the Prep team with Pre- Prep Activities and Prep Activities to begin with the SCRUM process and kept a track of the entire process using Green Hopper tool for managing backlogs, planning sprints and tracking the team through the entire release process.
  • Helped sorting the reviewed user stories into product backlogs prioritizing them on the basis of the business requirements.
  • Involved in analyzing the business rules for data conversion in order to build a high level architecture of database objects in MS SQL Server 2008.
  • Created and Altered Tables, User-Defined Functions, Stored-Procedures and triggers to support the Data Conversion Process.
  • Developed data mapping documents between Legacy, Production, and User Interface Systems.
  • Created packages with PL/SQL Scripts in SQL Integration Services to import record sets from different oracle systems into SQL Server as staging database.
  • Applied various Data Transformations like conditional split, data conversion, derived columns and lookups to source data.
  • Implemented various Control Flow Tasks such as For Loops, For Each Loops, Execute SQL tasks and Scripts tasks to support the Data Conversion process as per the business rules.
  • Implemented different Error handlers and Event handlers to debug issues related to data transformation.
  • Built a post-conversion Data Verification Process in SQL Server staging dB to generate and compare counts by different grouping methods on gas trading deals between source and target oracle systems.
  • Built Tabular Reports with data sets imported from source/target oracle systems in SQL Reporting Services to compare various attributes of physical and financial gas trading records.
  • Deployed packages from MS SQL staging dB to different test environments for testing and then to production.
  • Written complex stored procedures with Temp tables, CTEs and Table-Valued Functions to filter out records from source systems based on the business rules.
  • Created User-Defined Functions with multiple string, row, and rank and date functions to be used as derived columns while building Reports.
  • Created SQL Integration packages with T-SQL Scripts and VBScripts to validate data between source, staging and target systems before the Conversion process.
  • Implemented Query optimization techniques to improve the performance of Data Validation, Data Conversion and Data Verification processes.
  • Created PL/SQL Scripts to support a process that compares configuration data between different oracle test environments.
  • Facilitated Daily Scrum meetings and Scrum of Scrums, keeping track of what was done the day before and what is to be done that day.

Environment: MS SQL Server 2012, 2008 R2, SQL Server Integration Services (SSIS), SSRS, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, C#, ASP.Net.

Confidential, San Antonio,TX

Sr. SQL Business Intelligence Developer/Analyst

Responsibilities:

  • Conducted feasibility analysis for new/ upcoming projects in the Derivatives space, drive requirements gathering by leading JAD sessions, functional analysis & design of end-to-end business work flow reports.
  • Co-ordinate with the technical team to translate business requirements into technical design, perform business process analysis, design and modeling with UML, perform system integration testing and assist users throughout the UAT phase of the project.
  • Prepared Business Requirement Documents (BRD), Functional & Non functional requirement Documents. (FRD & NFRD), process flows, business & system use cases.
  • Created Parameterized reports, Drill down and Drill through reports by using SSRS
  • Created reports in SSRS 2008 and maintained them. Also was responsible for supporting and updating existing reports to new versions of SQL.
  • Scheduled daily, weekly and monthly reports and was responsible for any changes and maintenance.
  • Redesigned new reports based on the existing Crystal Reports with new parameters and also with addition of additional conditions.
  • Designed different kinds of reports from scratch depending upon the requirements of the markets.
  • Created reports with logos, pictures and graphs which project the business differences among various markets.
  • Created reports by writing codes using cursors and also made changes to the existing codes in SSRS 2005.
  • Implementation of client side validations using ASP.NET validation controls.
  • Developed and managed the formal Software Development Life Cycle (SDLC) Methodology which includes Configuration Management, Requirements Management, UML Analysis and Design for development of new reports.
  • Worked actively as a part of a team and was part of releases.

Environment: MS SQL Server 2012/ 2008/2008 R2,DB2, TSQL,PL-SQL, SQL Server 2008/2008R2 Management Studio, SQL Server Integration Services(SSIS),SQL Server Reports(SSRS), Oracle,Stored Procedures,MS Office 2010,ASP.NET,C#

Confidential, Boston MA

Sr. BI Developer SSIS/SSRS

Responsibilities:

  • Developed and modified database objects including tables, views, constraints, functions, triggers, user defined rules and stored procedures to provide systematic review, analysis, and evaluation of financial data to identify principal sources of risk as it relates to hedging, pricing, pooling and other focus-areas within the Enterprise Risk-Management Division.
  • Developed Ad hoc T- SQL queries to meet requirements from business analyst, Operations Analysts, and Financial analyst.
  • Migrated data using SSIS, DTS, BCP, Bulk Insert and/or Replication.
  • Created ETL processes through SSIS and responsible for loading Data from different input sources to main Database.
  • Created ETL processes using Microsoft DTS and SSIS to maintain and update data about official document and research, and created customized reports from related document.
  • Created script task to perform specific ETL jobs by using C#.
  • Developed data extractions of company databases using SQL queries for financial analysis.
  • Identified and managed Data Source and Data Source views for SSIS, SSAS, and SSRS Project.
  • Created cubes and performed data mining using the fact table and the dimension.
  • Created MDX script for Calculation processes in Cube using SSAS.
  • Analyzed, designed and developed data marts, data views.
  • Created ad hoc report in order to identify unusual trends and activity.
  • Created complex financial trend and data analysis reports for decision-making management, using Performance point service to integrate SSRS reports and Power Pivot to create report in SSRS.
  • Generated reports using Crystal Reports.
  • Scheduled Jobs and Alerts using SQL Server Agent.

Environment: SQL Server, Visual Studio 2005/2008 (.Net, C#), Windows 2000/2003, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, T-SQL, Query Analyzer, SQL-Profiler, SQL Server Enterprise Manager.

Confidential, Philadelphia, PA

Sr. SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Supported development staff about database related issues.
  • Transferred data between Development, Testing and Production databases.
  • Used Normalization techniques to create and modify data model.
  • Designed DDL/DML queries and other database objects including triggers, stored procedures, indexes and view to manage database.
  • Created views and stored procedures for front-end application.
  • Created SSIS Packages to import different forms of health care claims data files from external contractors and export to SQL server tables.
  • Analyzed the Data quality, Data validating, Data mapping on claims specific data.
  • Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database with SQL server Export Utility.
  • Developed OLAP cubes using SSAS and defined measure groups for the functional analysis.
  • Generated MDX queries to create calculated measures that meet business requirement.
  • Created and deployed reports and report models for internal and external customers and support their specific requirements using SSRS.
  • Deployed the SSRS reports in Microsoft office share point server 2007 (Moss2007).
  • Created Dashboards and reporting services web parts using Moss 2007.
  • Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Created datasets using stored procedures and reports using multi value parameters
  • Created sub reports, bar charts and matrix reports

Environment: MS SQL Server 2005/2008, MS Visual Studio 2005/2008, Windows, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, Share point 2007, T-SQL.

Confidential, Hartford, CT

SQL Server Developer/BI Developer

Responsibilities:

  • Analyzed the requirements and selected the dimensions based on the analysis requirements.
  • Designed Tables, Constraints, Views, and Indexes, and created the Cubes for Business Intelligence.
  • Involved in writing Test Plans for SQL Stored Procedures and User Defined Functions.
  • Created Views to facilitate easy User Interface Implementation and Triggers on them to facilitate consistent data entry into the database.
  • Developed the ETL Process to load the data from the mainframe production databases to the Oracle database models.
  • Involved in High-Level Documentation for SQL Server Database Design, Periodic Data Refresh, and Database Upgrades. And finally set standard, guidelines, and best practices based on the documentation.
  • Executed Database Tuning, Performance Planning, Back Up Planning, and Database Administration.
  • Participated in the Normalization and De-Normalization of database along with creating and managed Clustered and Non-Clustered Indexes to improve database performance.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of the database servers.
  • Involved in writing scripts for Data Staging, Uploading, and Cleanup process.
  • Designed SSIS packages dynamically that could run on various Environments by creating XML and SQL Server Configuration Files.
  • Created Interlinked SSIS Packages by using Parent-Package Variables.
  • Experience in SSIS Script Task, Look Up Transformations and Data Flow Tasks using T- SQL and (VB) Scripts.
  • Developed OLAP model based on Dimension and Facts for efficient loads of data mainly based on Star Schema.
  • Created the New Dimensions, Shared Dimensions, and Time Dimensions and implemented those dimensions while generating Cubes from SSAS.
  • Hold responsibility for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX Queries, Perspectives, KPI’s, Scorecards and Dashboards.
  • Created Partitions and designed various Storage Modes to increase the performance of cubes using SSAS.
  • Involved in Scheduling, Creating Snapshots, Creating Report Subscriptions and Data Driven Subscriptions.
  • Developed MDX Scripts to create datasets to generate various reports which included Interactive Drill Down Reports and Report Models.
  • Documented all processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio, TSQL, Business Intelligence Development Studio (SSRS/SSIS/SSAS), Oracle 9i, XML, Windows 2003 Server, Microsoft, SQL Profiler, OLAP.

Confidential, Voorhees, NJ

SQL Server BI Developer

Responsibilities:

  • Worked with the Business users to gather requirements for developing reports on Customer Service/ Call Center Data from various sections of the organization.
  • Created Stored Procedures to process Data loaded onto SQL Server from IBM AS400 database and CSV files generated from AS400 Queries.
  • Developed a few individual ETL Packages to load data from AS400 databases/CSV files based on the business requirements to develop a report.
  • Worked with mostly with Data Flow Task, For Each Loop, Execute SQL Task, Analysis Services Process Task and Configuration files in SQL Server Integration Services.
  • Built SSAS Cubes for a few reports which required Data browsing in a 3-dimensional way on Microsoft Excel for the business users.
  • Developed around 8-10 less complex reports and 2-3 complex reports with SSRS R2 on top of a relational database and also SSAS Cubes.
  • Developed Cubes with multiple Fact/Dimension tables, Attributes, Hierarchies, Calculations, Roles and built configurations to deploy to different Servers
  • Used various new features provided with BIDS R2 edition in SQL Server Reporting Services to provide additional functionalities and easy navigation for the end users.
  • Designed a Dynamic Report Menu, which is specific to the business user browsing the report on the Company’s report server using a back-end model on SQL Database Engine.
  • Involved in trouble shooting issues with report manager security and settings during the reports deployment onto QA and Production environments.
  • Written documents those provide steps to Deploy Database Scripts, ETL Packages, SQL Server Agent Jobs, SSAS Cubes and also Reporting Solutions pertaining to an individual business report onto QA/Production.
  • Built reports, which were combination of Drill through, Drill Down, Sub-Reports, Charts, Matrix, Tabular, and Cascaded Parameterized functions.
  • Provided Production support for major deployment of ETL Packages, Cubes and SSRS Reports.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio, TSQL, Business Intelligence Development Studio (SSRS/SSIS/SSAS), Oracle 9i, XML, Windows 2003 Server, Microsoft, SQL Profiler, OLAP.

Hire Now