Bi Developer Resume
Washington, DC
SUMMARY:
- Over 4 years of experience in the IT industry with in depth knowledge of system analysis, requirement gather and specification, software design, development and complete SDLC.
- Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 20 /2014.
- Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
- Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
- Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
- Experience in Developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
- Excellent Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
- Experience in database server performance tuning and optimization of Complex SQL queries
- Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users
- Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
- Excellent Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
- Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
- Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
- 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.
- Experience in configuring SSIS packages using package Logging, Breakpoints, Checkpoints and Event handling to fix the errors.
- Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
- Proficient in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
- Hands on experience in troubleshooting database issues.
- Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
- Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables .
- Well-versed with implementing different Replication Models like Snapshot, Merge, Transactional and Database Mirroring .
- Highly adaptable in quickly changing technical environments with very strong organizational and analytical skills.
- Experience in implementing software development life cycle policies and procedures.
- Expertise in managing and supporting multiple projects per iteration.
- Strong leadership and communication skills.
TECHNICAL SKILLS:
Scripting: PowerShell Scripting, Biml Scripting, DOS Scripting
Tools: and Technology SQL Server Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS), Oracle 11g, SQL*Plus, TOAD, Erwin Data Modeler.
Databases: SQL Server 2012/2008R2,2005 Oracle 11g/10g/9i, Amazon RDS, Teradata,DB2
ETL Tools: Informatica PowerCenter 9.5/ Oracle Warehouse Builder/ SQL Server Integration Services (SSIS)
Methodologies: ER/Multidimensional Modeling (Star/Snowflake), Data Warehouse Lifecycle
Reporting: SQL Server Reporting Services, Report Builder 3.0, Tableau, Crystal Reports
Languages: Visual Basic.NET, C#, C++, Java, JS, T-SQL, PL\SQL,XML, JSON
Operating Systems: UNIX, Windows Server 2000, 2003, 2007, 2010 and 2012.
PROJECT EXPERIENCE:
Confidential, Washington, DC
BI Developer
Environment: SSIS, SSRS, MS SQL Server 2016/2012/2008 , C#, Visual studio 2016, MS Access, MS Excel, MS Office Access 2013, DB2, Oracle 12c,SAS. CRM 2011, UX8, Tableau Desktop10
Responsibilities:
- Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server 2016 and MS SSRS 2012.
- Involved in CRM upgrade project and migration from Business Objects to Tableau.
- Configuring, customizing and providing technical support to corporate CRM systems
- Created, implemented and maintained a reporting suite of over 180 standard reports while also customizing many reports to meet individual client needs.
- Created drill down, drill through, sub and linked reports using MS SSRS 2012 as well as managed the subscription of the reports.
- Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
- Provided MS SSRS 2012 training to clients in order for them to develop their own ad-hoc reports.
- Converted MS SSRS 2012 based reports to CRM 2016 UX based reports.
Confidential
SQL Developer/ Data Analyst
Environment: SSIS, SSRS, MS SQL Server 2014/2012/2008 , C#, Visual studio 2016, MS Access, MS Excel, MS Office Access 2013, DB2, Oracle 12c,SAS,Tableau .
Responsibilities:
- Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
- Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
- Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
- Involved in defining the source to target data mappings, business rules and data definitions.
- Responsible for defining the key identifiers for each mapping/interface.
- Responsible for defining the functional requirement documents for each source to target interface.
- Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
- Reverse engineered all the Source Database's using Erwin.
- Documented data quality and traceability documents for each source interface.
- Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
- Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
- Worked with internal architects in the development of current and target state data architectures
- Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
- Used data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW)
Confidential, Rochester, NY
SQL Developer / Data Analyst
Environment: SQL Server 2012/2014, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server 2012, XML, MS Visual Source Safe, Oracle 9i and11g, Visual Studio Team Foundation Server 2012, Talend, Agile Development and Powercenter ETL 9.5.1 ASP.NET, C# .Net 3.5 framework, ColdFusion
Responsibilities:
- Studied in-house requirements for the Data warehouse to be developed
- Conducted one-on-one sessions with business users to gather data warehouse requirements
- Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
- Helped in the design of the Architecture of the Data Warehouse and helped in performance tuning of the database.
- Developed a Conceptual model using Erwin based on requirements analysis
- Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
- Involved in migration from Oracle 9i to SQL Server 2012.
- Designed, Developed and Deployed packages in SQL server environment using SSIS-2012.
- Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.
- Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server
- Designed, modified and troubleshoot SSIS packages.
- Worked with clients to document requirements and develop custom implementations of the data warehouse, including custom ETL processes, SSAS cubes, reports and dashboards.
- Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2012/2014 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests
- Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Microsoft integration service to load it into a single data warehouse repository.
- Deployed and process the cubes, partitions into analysis services server as and when required.
- Developed procedures/protocols on database planning and implementation, database security aspects, database auditing, Backup and restore modality.
- Review the current procedure of backup and restoration, and introduced the differential back up into the system and periodic restoration of backups.
- Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
- Overall follow-up of the system and user support to address any issues and plan for potential problems in advance.
Confidential, Houston, TX
BI Developer/SQL Developer
Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, FTPMicrosoft Reporting Services, MicroStrategy
Responsibilities:
- Worked on multiple projects with different business units including Delta, United and American Airlines.
- Gather the various reporting requirement from the business analysts.
- Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
- Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
- Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
- Normalized data fields to meet the business requirements and specifications to build a data marts for various departments into a metadata.
- Designed and implemented cubes across multiple data marts using OLAP methods in Business Object for users to access reporting as its needed.
- Maintained ETL jobs for OLAP cubes. Executed and supported ETL using MS-SQL Server and Informatica.
- Creating and administer Database objects - tables, views, indexes, procedures for implementing some application functionality at the database side for performance improvement.
- Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
- Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX
- Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically
- Regular Monitoring of SQL server, analyzing the logs, Troubleshooting SQL Server Problems such as SQL Server service, Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems.
- Creating and administer Database objects - tables, views, indexes, procedures for implementing some application functionality at the database side for performance improvement.
- Implementation of backup and recovery strategies. Perform Full, Differential and Transaction Log Backups. Restore them whenever necessary