Sr. Sql Bi Developer Resume
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.