Senior Bi Developer Resume
5.00/5 (Submit Your Rating)
Silver Spring, MD
Objectives
- With over ten years (10+) of IT Experience specifically as Database designer, SQL and BI developer, I am looking to work as SQL and Business Intelligence Developer in a technology - oriented company where I can demonstrate my caliber and technical abilities to design, test, and deploy SQL and BI solutions as well as provide solutions to data analytic issues.
SUMMARY
- Extensive experiences and expertise in building Relational Databases design and implementation.
- Wide spectrum ability to work and communicate with varied professionals.
- Sound knowledge of quantitative and statistical methods, Econometrics (Statistical Economics), Math (applied math for social studies as well as for science and engineering), Excel, Math-Lab and Mathematica, Regression analysis, curve fitting or prediction.
- In general, exiled expertise in translating reporting and analytical needs into technical solutions with strong management and leadership skills to work in team.
TECHNICAL SKILLS
Operating Systems: Windows NT/95/98/XP//2000/Server 2003, Linux/Unix
Databases: MS-SQL Server 2005/2008/2012/2016 , Oracle 12c, Microsoft Access.
BI Tools: Microsoft SSIS, SSAS, SSRS, Power BI and Tableau.
Languages: T-SQL, Oracle SQL, ASP.net C#, C, C++, Phyton, Java, and C#
DB Modeling Tools: MS Visio, draw.io, Lucid Chart
PROFESSIONAL EXPERIENCE
Senior BI Developer
Confidential, Silver Spring, MD
Responsibilities:
- Developed various SQL objects such as Databases, Tables, Views, Stored Procedure, User Defined Functions, Triggers, and wrote complex queries using Joins, Aggregate Functions, Sub-queries, Derived tables and CTEs.
- Optimized the performance of queries by reducing the query coins.
- Analyzed business requirements and built conceptual, logical, and physical data models that describe all the data and relationships between the data
- Created queries to provide ad hoc reports, analysis, and datasets based on business needs.
- Built and deployed SSIS packages for data extraction and loading including such transformations as Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Merge Transformation, Percentage Sampling, Row count, Script Component, Sort, Multicast and Data Conversion Transformation.
- Worked on transitioning database and report packages from Development and Test Environments to Production.
- Developed Relational Databases as well as Multidimensional OLAP data warehouses
- Developed various types of reports like Charts, Filters, Sub-reports, drill down, Drill through, tabular, matrix and parameterized reports using SSRS, and dashboards in Power BI, as well as Tableau.
- Worked on Agile Projects with multiple sprints cycles and scrum meetings, JIRA.
Senior SQL / BI Developer and Admin
Confidential
Responsibilities:
- Installed, upgraded, and configured Microsoft SQL Server 2005/2008/2012/2016 . Restored databases.
- Designed, created, tested, and implemented databases. Created clustered / non-clustered index, unique / check constraints, views, stored procedure, Triggers, and schemas
- Developed many SSIS, SSAS, and SSRS packages and deployed, configured, scheduled on MS SQL Integration Services Catalogs.
- Employed knowledge of OLTP (Online Transactional Processing) data, Staging table, Operational Data Store (ODS), Data marts, Data warehousing, OLAP (Online Analysis Processing), Dimensional Data Modeling, Star Schema, and Snow-flake schema, Fact and Dimension tables.
- Install, configure, and deploy MS SQL Server 2012/2014 and perform capacity planning, performance turning, monitoring, troubleshooting and optimization of databases
- Designing and running system load testing, escalating application problems to vendors
- Standardize and manage Database Administrator procedures for monitoring database testing, archiving, and optimizing
- Maintenance and support of SQL server Mirroring, Log shipping, Clustering, and other methods of disaster recovery
