Sql/msbi Developer Resume
Phoenix, AZ
SUMMARY
- 7+ years of wide - ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives in Healthcare, Insurance Academic and Finance industries etc.
- Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
- Experience in integration of various data sources like SQL Server, Oracle, Access DB, DB2 and Flat File, Excel File.
- Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
- Extensively worked on Control Flow Tasks such as For each Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, Send Mail Task.
- Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
- Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
- Hands-on star schemas, snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
- Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries, OLAP Cubes, and deployment and processing SSAS objects.
- Strong skills in writing MDX queries to access cubes in SSAS, and creating feeds from OLTP systems.
- Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.
- Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc).
- Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
- Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.
- Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
- Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
- Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
- Worked on SQL scripts PLSQL, Creating Tables, Clustered/Non Clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement
- Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.
TECHNICAL SKILLS
SQL Server Tools: SQL Server Enterprise Manager,T-SQL, Data Transformation Services (DTS), SQL Server Query Analyzer, SQL Server Agent, SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server 2008 Reporting Services (SSRS), DBCC, BCP, MDX, SQL Server Profiler.
ETL: DTS, SSIS
Reporting Tool: SSRS, Business Objects
Programming Languages: T-SQL, C, C++, Matlab
Databases: MS SQL Server 2005/2008 R2/2012, Oracle 9i/10g/11g, SQL, MySQL & MS Access MS Access 2000/2003
Data Modeling Tool: Erwin, Microsoft Visio 2000/2003/2008
Operating System: Microsoft Windows 95/98/2000/2002/ Vista/7/8
PROFESSIONAL EXPERIENCE
Confidential, Phoenix, AZ
SQL/MSBI Developer
Responsibilities:
- Actively involved in the gathering requirements and analysis of the requirements related to the project and responsible for writing Business Approach Documents (B.A.D) and Technical Documents for new projects.
- Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
- Creating SSIS Package Configurations and maintaining their Tables by editing the values of the variables as per the requirement.
- Closely worked with DBA teams in the maintaining the databases and trouble shoots experiencing from the users
- Trouble Shooting the failed SQL jobs due to errors in the sample processing and fixing them and re-scheduling the SQL Jobs
- Manually running some of the SQL Jobs which generates the Weekly, Monthly and Quarterly reports after making sure that the input data acquired or not.
- Interacting with Managers, Project Directors to plan and execute the project provisions and efforts estimations.
- Worked on Data migration project by validating three source data row by row and field by filed
- Using SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources and legacy system (Oracle, Access, Excel) to centralized SQL Server databases to overcome transformation constraints and limitations.
- Worked on development of SSIS package to generate excel reports individually and consolidated reports by dynamically passing the carrier ids from the SQL Table in Shared Folder to make available to the business users
- Worked on the fixing the bad data in Legacy Tables in batches, Created a logic to validate the data before loading to the clean table and bad data will store in the separate table and in Excel Report and notify by emails and using expressions in SSIS Packages.
- Widely worked on Script Task and expressions such as to check file availability at the run time and notify by the emails and also created a logic using Script Task to pick the certain date range of the files from the share folder and dynamically pass the file names to the Foreach loop container in SSIS
- Worked on re-design of the few SSIS Package which involved very complex logic and more than a hundred tables and tasks and developed simplified version of the Packages.
- Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
- Designed and tested packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, Foreach Loop Container.
- Setting up the Server Connections, File paths, Parameters mapping, and Expressions mapping in SSIS.
- Created and mapped the Various Results, Sets and Variables wherever they are needed in SSIS.
- Extensively worked on the packages created including a variety of transformations, for exampleSlowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.
- Worked on the row count transformation or row count expression and Record set Destination and event handlers control flow to populate the special Log tables withhigh level SSIS packageexecution.
- Worked on Execution of the paths depending on the success, failure or Completion of other tasks with precedence constraints and expressions to determine the workflow.
- Extensively worked on Setting up the Send Mail task on Start, Complete, and Failure of .dtsx package that includes writing the logic to show up the results in the email to quickly verify the cause of the failure in SSIS
- Designed and executed packages which include direction of data flow, Column Mapping, Data dictionary and Metadata Flat file source and Flat file destination, OLEDB Source and OLEDB Destination using SSIS.
- Created package configuration in XML and used to deploy packages into SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
- Worked on development and implementation of SSAS cube dimensions and their deployment and production support.
- Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes
- Worked on Development and implementation of SSRS reports and ran them as per the requirement.
- Responsible for the issues raised from the production and debugging and deploying the updates.
- Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
- Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
- Created Views, Materialized Views to get the values dynamically using joins and other sql queries from the multiple tables.
- Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
- Worked on SQL scripts PLSQL, Creating Tables, Clustered/Non Clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement
- Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.
- Fine-tuned queries to make the reports run faster, worked on query run time analytics.
- Created several Schemas, Tables, Cursers, Triggers and Indexes, Identity Column, Identity Seeding, Calculated Columns as per the requirement.
- Worked in troubleshooting and debugging stored procedures, upgrading existing ones according to new requirements.
- Extensively used Joins to simplify complex queries/sub queries involving multiple tables and also optimized the procedures and Indexes, Cursers and triggers.
- Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.
- Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.
Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, MS VISO, Crystal Reports XI Release, Profiler, Visual Source Safe, Microsoft TFS, BIDS, Visual Studio.
Confidential, Fort Lauderdale, FL
SQL BI Developer
Responsibilities:
- Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
- Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2008/2012.
- Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
- Defined Check constraints, Indexes, and Views.
- Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
- Developed physical data models using ERWIN/ VISIO and created DDL scripts for database schema and objects.
- Developed Query for generating drill down and drill through reports in SSRS 08/12.
- Uploaded reports on to the report manager and organized them into folders.
- Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
- Identified and worked with Parameters for parameterized reports in SSRS 2008/2012.
- Responsible for scheduling the subscription reports with the subscription report wizard.
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
- Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
- Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
- Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
- Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
- Designed and created MDX queries to retrieve data from cubes using SSIS.
- Managed the migration of SQL Server 2005 databases to SQL Server 2008.
Environment: MS SQL Server 2008/2012, DTS, Windows 8, SSMS, Business Intelligence Development Studio(BIDS) 2008/2012, Erwin, MS Visual Source Safe, MS-Visual Studio, Oracle 10g, UNIX,MDX Scripting.
Confidential, Dublin, OH
Senior BI Developer
Responsibilities:
- Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.
- Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.
- Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
- Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
- Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
- Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task. Actively involved in deploying and scheduling packages.
- Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
- Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
- Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
- Performed business data analysis and report creation in support of both ad hoc requests from the customer and to support new development and system maintenance.
- Research and investigate key business problems through quantitative analyses of utilization, healthcare and cost data.
- Provided and defend conclusions and recommendations to customer based on results of analysis.
- Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.
- Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of software development lifecycle.
Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, TFS.
Confidential, Columbus, IN
Business Intelligence Developer
Responsibilities:
- Implementation of data extraction, transformation, and loading (ETL) processes.
- Extensively used Derive Column, Data Conversion, Conditional Split and Aggregate.
- Transforming the data using various tasks and transformations in control flow and data flow.
- Creation of SSIS packages to implement ETL processes to load fact and Dimensions Tables.
- Creation of package configuration to handle data source connection information.
- Creation of Tabular and Matrix reports in SSRS (2008) for Business Analysis Purposes.
- Building and generating reports with the help of Report Builder in the Report manager.
- Deploying and scheduling SSRS Reports in Report Manager and applied subscriptions add securities to the reports.
- Developed and Deployed the SSAS Cubes using SQL Analysis Services (SSAS).
- Created SSAS cubes with Dimensions, Hierarchies, partitions and MDX queries
- Involved in creation of named calculations, members using the MDX queries.
- Involved in writing heavy T-SQL stored procedures, Functions, complex joins
- Involved in performance tuning of stored procedures using the SQL profiler and tuning advisor.
- Involved in scheduling the SSIS packages using the Sql server Job Agent.
Environment: SSIS, SSRS, SSAS, MDX, T-SQL, SQL Server 2008, Windows Server-2007
Confidential
Junior SQL developer
Responsibilities:
- Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
- Developed Database Triggers to enforce Data integrity and Referential Integrity.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
- Defined relationship between tables and enforced referential integrity.
- Involved in Implementation of Database design and Administration of SQL based database.
- Established connectivity to database and monitored systems performances.
- Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
- Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
- Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
- Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
- Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
Environment: SQL Server 2005, Windows Vista, Enterprise Manager, SQL Profiler, SQL Query Analyzer, DTS, T-SQL.