Sql Bi Developer Resume
Atlanta, GA
SUMMARY
- 7 years of Experience in Development, Implementation and Reporting in MS SQL Server 2014/2 R2/2005/2000 with Business Intelligence in SQL Server Integration Services (SSIS),SQLServerAnalysis Services(SSAS) and SQL Server Reporting Services(SSRS).
- Expert in Data Extraction, Transforming and Loading (ETL) using various tools such asSQLServer Integration Services (SSIS), DTS, Bulk Insert and BCP.
- Hands on experience with performing variousSSISdata transformation tasks like Look - ups, Fuzzy Look-ups, Checksum, Conditional Splits and Error Handlers etc.
- CreatedSSISTemplates for developingSSISPackages in such a way that they can be dynamically Knowledge of deploying packages into Development, Testing and Production Environments.
- Extensively usedSSISpackages to Import data from sources like Flat Files, Excel, HTML and Raw Files.
- Extensive experience in creating Jobs, Alerts,SQLMail Agent, and automating DTS/SSIS Packages.
- Experienced in Conversion of Complex DTS Packages toSSISfrom scratch and using third party tools like DTS Xchange.
- Good Knowledge of Data Warehouse architecture and attribute relationships between Fact and Dim tables.
- Experience in Developing and ExtendingSSASCubes, Dimensions and data source views,SSAS-Data Mining Models and Deploying and ProcessingSSASobjects.
- Extensive Knowledge in Creating Relationships, Measures, Partitions, Calculations using DAX and KPIs inSSASTabularmodel.
- Experience in creating and schedulingSSISPackages to perform Dimension and Cube Processing.
- Developed OLAP Cubes by using SQL Server Analysis Services SSAS.
- Experience in gathering Business Requirements and translating them into technical specification and creating reports with respect to business requirement.
- Worked with improving the performance onSQL, TSQL andSSRSprocedures and provided the recommendation onserverrelated tuning issues.
- Working knowledge in performance pointserverin developing dashboards, reports, etc.
- Efficient in creating Joins and Sub-Queries for complex queries involving multiple tables.
- Experience in Normalization/De-normalization Techniques for optimum performance in relational and dimensional database environments.
- Performed Duties like new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects.
- Expertise with scheduling and monitoring jobs usingSQLServerAgent to perform hourly/daily/monthly data loads.
- Excellent communication and interpersonal skills in handling multiple tasks, able take initiative to handle responsibilities independently as well as a member of team.
TECHNICAL SKILLS
Relational Databases: SQL Server 2014/2012/2010/2008 R 2/2008/2005/2000 , MS Access.
Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe and SQL Query Editor.
Languages: T-SQL, HTML, XML, SQL, C#, VB.Net, ASP.Net
Operating Systems: Windows 98/NT/2000/XP, Windows Server 2003/2008, UNIX, LINUX
Web Technologies: HTML, XML, XSL
Application Packages: MS Office, MS Outlook (Microsoft Office Suite)
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, GA
SQL BI Developer
Responsibilities:
- Worked as adeveloperand acquired excellent skill in creating complex Stored Procedures, Functions, and Triggers for automating tasks, Views and complexSQLqueries for applications.
- Managed and resolved design issues during development and production.
- Cleansed and transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files intoSQLServer2014 by using SSIS packages.
- Created ETL packages with different data sources (SQLServer, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
- Experience with Data migration utilities (Import & Export - BCP, Bulk Insert) from flat files toSQL Server.
- Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
- Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX andSQL.
- Create Stored Procedures, User Defined Functions, Views, T-SQLscripting for complex business logic.
- Created Roles forSSASTabularModel provide additional Security at the row-level by using row-level filters Created complexSSAScubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Designed Perspectives and Hierarchies inSSASTabularmodel.
- Writing T-SQLqueries (DDL and DML). CreatingSQLScripts for data loads and Upgrades for data migrations and data validations.
- Created and maintained logins, roles and permissions on theSQLinstances and databases and provided required privileges according to the user's requirements.
- Involved in development, deployment, scheduling, and troubleshooting SSIS packages.
- Involved in complex SSIS package development with MicrosoftBIstandards and Development strategies to pull data from various data sources such as (SQLServer, Excel, and Flat file).
- Worked extensively with Slowly Changing Dimension and lookup Transformation for implementing Inserts and Updates. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2012).
- Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts.
- Manage change control based on customer requirements to according to project work flow.
- Assisted in change/release management and deployed various packages in different lower environments.
Environment: MSSQLServer2014/2012, SSRS, SSAS, SSIS,SQLQuery Analyzer,SQLprofiler, Enterprise Manager, Tableau, HTML, MS Access, Crystal Reports.
Confidential, Richfield, MN
SQL BI Developer
Responsibilities:
- Involved in Normalization of the database and bringing it to 3NF.
- Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
- Extracting and Loading data intoSQLServerDatabase using SSIS.
- Extensively involved in designing the SSIS packages to export data from flat file source toSQL Serverdatabase.
- Created Tabular Reports, Cross Tab Reports and Sub Reports.
- Created SSIS Packages to migrate slowly changing dimensions.
- Experience in creating complex SSIS packages using proper control and data flow elements.
- Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
- Performed the task of data transfer from files in remoteserverto folders in anotherserverusing FTP.
- Created database maintenance plans and deleting of history data using SSIS packages.
- Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS).
- Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
- Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.
- Building KPI reports for the cubes and optimizing the reports.
- Involved in partitioning of cubes to increase the performance of cubes (SSAS).
- Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.
- Excellent report creation skills using MicrosoftSQLServer2012/2008R2 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
- CreatedSQLServerReports based on the requirements using SSRS 2008.
- UsingSQLserverreporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
- Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
- Designed, Build the Dimensions, cubes with star schema usingSQLServerAnalysis Services (SSAS).
- Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
- Developed reports and deployed them onserverusingSQLServerReporting Services (SSRS).
- Rendered the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.Create parameterized Reports using Charts, Cross-Tab and Sub-report types.
Environment: Windowsserver2003, IIS 5.0, MSSQLServer-2012/2008R2, Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS,SQLProfiler, OLAP, OLTP, Erwin, Performance Point Sever, MS Excel.
Confidential, Nashville, TN
SQL BI Developer
Responsibilities:
- Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables,SQLjoins and other T-SQLcode to implement business rules for Tableau reports and SSRS reports.
- Implemented different types of constraints on tables for consistency.
- Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
- Created several SSIS packages for extracting data from data bases likeSQL, DB2 and load those data into tables inSQLserverto create final Roster report.
- Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS.
- Documented design and development works for creating views, stored procedures or SSIS packages pertaining to Izenda or Tableau reports deployment, uploaded reports into SharePoint site.
- Worked on various mingle tasks for different sprints contributing for hyper loop process and Bullet train.
- Created differentSQLjobs and maintained those jobs in the production.
- Performed tune to optimizeSQLqueries usingSQLprofiler and query analyzer.
- Worked on deploying the code and unit testing in different team environments.
- Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
- Created complex Stored Procedures, Triggers, Tables and otherSQLJoins and Statements for Applications by using T-SQL.
- Develop staging tables and created indexes in the destination table in order to make the ETL process faster than expected.
- Worked on Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
- Wrote MDX queries and KPI's usingSQLserver2008/2012 SSAS.
- Created org Hierarchy for the process of authorization and authentication for accessing Tableau reports by end user.
Environment: MS-SQLServer2012/2008R2/ MS-SQLServerReporting Services, MS-SQL ServerIntegration Services, WindowsServer2012, VB.NET, ASP.NET, MS-SQLServerAnalysis Services, T-SQL, MDX, Source Safe, Team FoundationServer.
Confidential
SQL Developer
Responsibilities:
- Involved in installation and configuration ofSQLserver2005 onServers.
- Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
- Implement and maintain database security.
- Implemented trigger and stored procedures and enforced business rules via checks and constraints.
- Fine tuned Stored Procedures using Execution Plan in T-SQLfor better performance.
- Going through the clients' requirements and coming up with database design and application architecture.
- Troubleshoot and minimize production down issues.
- Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
- Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
- Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
- Data conversions and data loads from various databases and file structures.
- Monitor failed and long running MSSQLServerjobs.
- Monitor, tune, and analyze database performance and allocateserverresources to achieve optimum database performance.Maintaining User account administration for Different domains.
Environment: MSSQLServer 2014/2012/2008 R2/2008, SSIS, Visual Studio 2005, VB.net 2005.
Confidential
Jr MS SQL Developer
Responsibilities:
- Created tables, views, indexes based on the requirements
- Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
- Involved in designing of Conceptual Logical Model and Physical Model.
- Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
- Developed Database Triggers to enforce Data integrity and additional 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.
- 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: MS SQL Server 2000/2005, T-SQL, DTS, TOAD, Microsoft Visual Source Safe, MS Visio, MS Projects.