We provide IT Staff Augmentation Services!

Sr. Sql Bi Developer Resume

3.00/5 (Submit Your Rating)

Deerfield, IL

SUMMARY

  • 8 + years of IT experience in MS SQL Server 2012/2008R2/2005/2000 Database Developer in Windows Environment.
  • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools.
  • Proven experience wif SQL Programming, SSIS, DTS, and SSRS and SSAS.
  • Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS.
  • Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources, legacy systems and load into various Business Entities.
  • Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
  • Created & formatted cross - tab, conditional, drill-down, summary, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports.
  • Experience in Analyzing SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
  • Experience developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and deploying and Processing SSAS objects.
  • I has a good experience into creating and maintaining reports using wif SSRS
  • Five years experience in SSRS reports, SSAS OLAP cubes, dashboards or scorecards based on business requirements.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 20012/2008R 2/2008/2005.
  • Experience in creating and maintaining Database objects in SQL SERVER 2012/2008 in SQL Server Management Studio.
  • I has a experience in writing MDX queries using SSAS .
  • Migration of SSRS reports from SQL 2005 to SQL 2008.
  • Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and TEMPeffective experienced in implementation of strong referential integrity and auditing by teh use of triggers and SQL Scripts.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS and SSIS Packages.
  • Experience in optimizing teh database by creating various clustered, non-clustered indexes and indexed views.
  • Experience in Backup and Restore wif SQL Safe and scheduling those backups. Good SQL Server administration skills including user authorizations, Database creation, Tables, indexes.
  • Highly experienced in all aspects of system development life cycle such as requirement analysis, design, development, testing, implementation, deployment & maintenance of projects.
  • Excellent Communication and interpersonal skills ensuring smooth communication wif all stakeholders across teh delivery chain.
  • Experiences in designing and developing BI applications wif more than 12 TB in size data warehouses.

TECHNICAL SKILLS

Operating System: Windows 2000, Windows Server 2003, Windows server 2008.

Databases: SQL Server 2008/2005/2000 , PL/SQL, Oracle 11g/8.0i, Microsoft Access 2000/8.0.

Languages: C#.Net, VB.Net, XML, ASP.NET, T-SQL.

Scripting Languages: HTML, XML, Java Scripting, VB Scripting.

Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, ETL & Reporting SSRS 2005/2008, and SSIS 2005/2008, SSAS .

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

Version & Defect Control: Microsoft TFS, MS VSS, Synergy, HP Quality Center & Jira.

Others: MS Office, Erwin, Crystal Reports XI, Visio, Microsoft Business Intelligence Studio, Service Oriented Architecture (SOA) SQL Server Notification Services, SQL Server 2000/2005 Analysis Services (SSAS), Visual web developer, MS FrontPage, Windows Scripting Host.

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

Sr. SQL BI Developer

Responsibilities:

  • Involved in requirements gathering, analysis, design, development, change management.
  • Developed backup restore scripts for SQL Server as needed.
  • Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
  • Created and managed complex batch jobs.
  • Involved in writing MDX queries and performance optimization of teh SSAS cubes.
  • Created complex queries for database auditing purposes.
  • Designed and implemented user log in and security.
  • Creating reports using wif SSRS like (charts, flow, diagrams. etc..)
  • Performed Index analysis for tables and came up wif more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
  • Evolved in teh creation and maintenance of index using Index Tuning Advisor wizard, Query optimizer, and selected teh best indexing plan to be deployed.
  • Data migration using ETL Tools in DTS.
  • Used to write customer reports using SSRS and SQL queries to access data base
  • Thorough analysis and testing of database objects & T-SQL statements before deployment to teh production server.
  • Creating MDX queries using SSAS in oracle business suite.
  • Used to design cubes on data wif SSAS.
  • Implemented multidimensional cubes wif MDX calculations to support analysis needs and fast data retrieval
  • Created complex ETL Strategies to populate teh Data warehouse/Data-mart facts and dimensions.
  • Used multiple transformations including Fuzzy lookups and Fuzzy grouping in teh data cleansing process.
  • Assisted in teh scheduling and teh deployment of teh reports and assisted in uploading files to a report server catalog from teh report manger.
  • Scheduled packages and different maintenance tasks using MS jobs.
  • Used Notification services mainly to manage packages on success, completion and failure of deployments and other tasks.

Environment: SQL Server 2012, T-SQL, SQL Server 2012 Reporting Service, SSAS, VSS, Windows 2012 Server, Query Analyzer, SQL Profiler.

We'd love your feedback!