Sr. Sql Bi Developer Resume
Overland Park, KS
SUMMARY
- 8+ years of IT Experience in System Design, Development and Support of Microsoft SQL Server2012/2008 R 2/2008/2005/2000 in Development, Data warehouse, Test and Production Environments on various business domains.
- Expertise in design and development of SSIS (ETL) packages.
- Expertise in generating Crystal reports, Ad hoc reports, tabular reports, Matrix reports, Drill - down reports, Cascaded reports, List reports, Parameterized reports, Sub reports and mentoring end user report writers using SSRS
- Experience in Data Schema Design, and Table Design.
- Experience with T-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
- Created and designed various database objects and elements like tables, joins, views, stored procedures, triggers, indexes and partitions.
- Expert in DAX functions.
- Expert in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
- Extensive experience in creating Clustered, Non-Clustered, Covered indexes and indexed views.
- Experience in Using multiple join statements to retrieve data from multiple tables
- Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports
- Robust MS Access and Excel skills with PowerPivot, PivotTable, Pivot Chart, Power View, VLookup functions and formulas.
- Having strong experience in scheduling all the T-SQL jobs to run at particular times.
- Expertise in Creating PowerPivot models and PowerPivot reports, and deploy models into SQL Server SSAS instance. Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database
- Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
- Knowledge and Working on WPF, WF and WCF. Data Base interaction with WCF, web service.
- Deploying the WCF service in IIS and in Windows.
- Experienced in writing complex T-SQL queries using Inner, Outer and Cross Joins.
- Good knowledge in Normalizing and De-normalizing the tables and maintaining Integrity using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
- Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
- Created complex DTS Packages for Data Migration and Transformation.
- Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2012/2008.
- Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
- Extensive experience in Relation Data modelling for creation logical and physical design for databases and proficient in creating E-R diagram using Erwin and Visio.
- Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
- Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
- Generated custom and parameterized reports using SSRS
- Used Team Foundation Server (TFS) for source code management.
- Very Strong on tools such as Erwin Data Modeler, Visio, TFS and have full understanding of the Software Development Life Cycle.
- Optimized indexes to improve queries and analyzed database performance with SQL Profiler.
- Partitioned many tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance
- Expertise in Using Various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
- Provide 24/7 on-call support for the data integration team as per schedule and support job failures and re-runs.
- Excellent communication, analytical and inter personal skills and ability to quickly learn new concepts.
- Ability to work individually as well as in a team, quick learner, self-motivated, out of box thinker with excellent communication and interpersonal skills.
TECHNICAL SKILLS
Relational Databases: SQL Server 2012/ 2008R 2/2008/2005/2000 , MS Access, Oracle
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, SQL Server Profiler.
Database Design Tools and Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical and Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, Denormalization
Languages: T-SQL, PL/SQL, HTML, XML, SQL, Java,.net,C#,VB.NET
Operating Systems: Windows 98/NT/2000/XP, Windows Server 2003/2008, UNIX, LINUX
ETL Tools: SSIS, DTS, PowerPivot, Power BI
Data Modeling Tool: Erwin, Microsoft Visio 2000/2003
Application Packages: MS Office, MS Outlook (Microsoft Office Suite)
Web technologies: WCF, WPF
PROFESSIONAL EXPERIENCE
Confidential, Overland Park, KS
Sr. SQL BI Developer
Responsibilities:
- Installed and Configured Microsoft SQL Server 2008/2012.
- Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to Data warehouse (SQL server).
- Developed Tabular reports, Crystal reports, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
- Developed complex canned reports using SQL Server 2012/2008 Reporting Services (SSRS)
- Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
- Create PowerPivot models and PowerPivot reports, and deploy models into SQL Server SSAS instance.
- Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database.
- Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
- Performed all SDLC phases related to extraction, transform, and loading (ETL) processes by using SQL Server Integration Services (SSIS) and SQL Server stored procedures in MS SQL Server 2005 and 2008 environments
- Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
- Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
- Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
- Worked on Cross platforms like SAS (Statistical Analysis System) to SQL server, Transformed the SAS Macros to SSIS.
- Designed tabular models to hold data which can be easily used for generating power views.
- Implemented row level security in tabular model this deals with restricting data based on user.
- Implemented complex calculations in tabular model using DAX.
- Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
- Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
- Expertise in developing Ad-Hoc, Drill down, Drill through and Dashboard reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS).
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
- Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
- Planned, Configured, Installed, Maintained SQL Server in environment of Multi-Node Cluster with Mulch-instances.
- Configured and Monitored Database Mirroring for Application Development environment.
- Involved in ETL architecture enhancements to increase the performance using query optimizer.
- Involved in power pivot modelling such as building and maintaining power views
- Established Inner Join, Outer Join and created Indexes whenever necessary.
- Performed ETL Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
- Maintained Batch logging, Error logging tables and handled errors using Event handlers in SSIS
- Generated custom and parameterized reports using SSRS.
- Created reports that call sub reports in SSRS
- Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
- Worked with Web Focus Reports and transformed them to SQL Reports
- Worked with Development teams in relation to application tuning
- Involved in the Database design (Logical Data Modeling and Physical Data Modeling) of the system.
- Worked with Clear Case and Autosys applications for version control
- Generating scripts using Erwin and Created and Altering the Databases
Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services 2005/2008/2012 , SQL Server Analysis Services, MS CRM 3.0/4.0, Windows Server 2003, PowerPivot, Power BI,SQL Profiler, SQL Clustering, Oracle, SAN, Source Control Management System, Index Tuning Wizard Visual Studio, HTML, Java Script, System Monitor/Performance Monitor, ASP.NET, Query Analyzer, VB.Net, C#, Unisys, Wintel, Event Viewer, SDLC, Data Warehousing, Data Transformation Services (DTS), TFS.
Confidential, Baltimore, PA
Sr. SQL BI Developer
Responsibilities:
- Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system of ATT
- Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
- Design/Build Extract Transform Load procedures in SQL Server Integration Services.
- Created tables, views, indexes, stored procedures, triggers and provide constraints and user defined rules and defaults.
- Used multiple join statements to retrieve data from multiple tables
- Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
- Develop and maintain functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required
- Written T-SQL Procedures using temp tables, cursors, sub queries and functions
- Extensively used Insert/Update and Delete triggers and created views for generating reports
- Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
- Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
- Monitored performance and optimized SQL queries for maximum efficiency.
- Created indexed views and appropriate indexes to reduce the running time for complex queries.
- Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLookup and formulas, built PivotTables and Pivot Charts using PowerPivot skill
- Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
- Maintained Batch logging, Error logging tables and handled errors using Event handlers in SSIS
- Involved in performing migration of DTS packages to SSIS packages.
- Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS
- Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
- Used Team Foundation Server (TFS) for source code management and bug tracking.
- Expert in creating Star schema cubes using SSAS.
- Extensively worked on OLAP cubes using SSAS.
- Created and Managed OLAP Cubes using SSAS.
- Created SQL server Analysis Projects using MS SQL Server 2012.
- Created dimensions, measures, MDX functions, KPIs, Perspectives, Partitions, Roles, and Actions.
- Created and modified various Stored Procedures used in the application using T-SQL.
- Used Event Handlers and script component for Error and Exception Handling in SSIS packages.
- Scheduled, maintained, and supported the distribution and access to SSRS reports through Report Server
- Created and managed databases for clients as well as systems to provide import of client data, and reporting of finalized data
- Provide 24/7 on-call support for the data integration team as per schedule and support job failures and re-runs.
Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services 2005/2008/2012 , MS CRM 3.0/4.0, Windows Server 2003, T-SQL,ETL,SSRS,SSIS,SSAS,.NET Framework, C#, ASP.NET, Windows 7, HTML, XML, MS Excel, MS Access, TFS, Remedy, Wintel, Visual Studio, HTML, Java Script, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, SQL Clustering, Oracle, SAN, Source Control Management System, Index Tuning Wizard, SDLC, Data Warehousing, Data Transformation Services (DTS), TFS.
Confidential, Houston, TX
Sr. SQL BI Developer
Responsibilities:
- Gathered end user requirements, developed applications and different Audit functionalities depending on the requirement acting for both system analyst and an application developer
- Developed high Level Design of ETL DTS Package in MS SQL Server 2005 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
- Created SSIS packages to migrate data from Oracle 8i to MS SQL Server 2005.
- Create the clustered/non-clustered indexes on tables; Trace out for any table required any indexes and determine the type of index on it.
- Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain event like INSERT, UPDATE and DELETE.
- Involved in database designing using Normalization.
- Developed high Level Design of ETL DTS Package in MS SQL Server 2005 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
- Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks
- Place the huge table/non-clustered index on the separate file group to improve the performance.
- Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
- Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
- Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
- Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
- Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
- Used Team Foundation Server (TFS) for all the source code maintenance needs.
- Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and adding calculations using MDX.
- Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages
- Worked in Data modeling, creating star and snowflake schemas in SSAS.
- Provide 24/7 on-call support for the data integration team as per schedule and support job failures and re-runs.
Environment: MS SQL Server2005/2000, SSRS, SSIS, ADO, T-SQL, MS Visual Studio 2005, DTS, Crystal Reports 9.0 Stored Procedures, HTML, XML, IIS 6.0, TFS
Confidential
SQL Developer
Responsibilities:
- Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
- Using SQL to query Databases Performing various validations and mapping activities
- Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution
- Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
- Conducted Performance tuning/MS SQL server development - SQL Profiler and PerfMon, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
- Designed and developed various complex reports.
- Build a common utility frame work to handle all the exceptions in a Business process.
- Using Excel and VBA in the development of robust and flexible reporting systems.
- Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS.
- Worked on loading data from various data sources using MS Data Transformation Services (DTS).
- Generated reports that can handle dynamic grouping and dynamic sorting.
- Involved in performance tuning of the database and T-SQL queries using Explain Plan.
- Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
Environment: SQL Server 2000, Windows 2003/2000 Server, Data Warehousing, C, CPP, C#, .NET, Rational Rose Enterprise
Confidential
Jr.SQL Developer
Responsibilities:
- Extracted and collected data to create needed reports.
- Collaborated with the application developers in data modeling and E-R design of the systems
- Created, modified, maintained and optimized SQL server database
- Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
- Used DDL and DML for writing triggers, stored procedures, and data manipulation.
- Created tables, indexes, sequences, constraints, triggers and procedures.
- Managing of databases objects like Tables, views, indexes etc.
- Implementing Backups and restoring when necessary.
- Developed replication and failover schema taking a local database and building scalability and fault tolerance that will support a world warehousing application.
- Developed Bash script to back up the MySQL database via mysqldatadump sending confirmation on completion.
- Also created, modified, maintained and optimized SQL server database.
- 24x7 Production support.
Environment: Windows 2000, SQL Server 7.0/2000, Enterprise Manager, SQL Profiler, DTS, T-SQL, BCP, Replication
