We provide IT Staff Augmentation Services!

Sql/etl/ Bi Developer Resume

Silver Spring, MD

SUMMARY:

  • Looking for a SQL /ETL/ /BI Developer position in a dynamic technology - oriented company where I can demonstrate my expertise and also stay current with trending technologies in SQL and BI Development
  • Highly energetic and experienced SQL database/ BI developer with more than 6years of experience able to analyze business requirements for design and implementation of databases. I have ample experience in the extraction of data from multiple sources, transforming and deploying them using Microsoft tools. I have a good knowledge and experience in the development of cubes using SSAS. I also have experience in the development of reports using SSRS. More specifically:
  • 6+ years of experience as SQL/BI/ETL Developer and Business Analyst
  • Analyzed requirements and transform them into technical designs.
  • Planning, modeling, designing, developing, implementing, and maintaining Microsoft SQL Server 2016/2014/2012/2008 databases
  • Working expertise in complex query design, stored procedures, views and functions
  • In-depth knowledge of T-SQL including complex SQL queries
  • Solid understanding of RDBMS principles, database design and normalization
  • Strong experience in index design and T-SQL performance tuning techniques and T-SQL coding methods and best practices
  • Proficient in data modeling tools database diagrams, Erwin, lucid charts
  • Experience in software development life cycle in Agile(scrum), waterfall
  • Experience in Data modeling (Dimensional & Relational) concepts like Star-Schema, Snowflakes modeling, fact and dimension tables, Pivot Tables, modeling data at all the three levels: conceptual, logical & physical
  • Experienced in creating reports using SSRS, Power BI, Tableau for better decision making of the organization
  • Experienced in the development of cubes so that multidimensional analysis of data can be performed
  • Profound experience in data visualization and dashboard creation using Power BI and Tableau
  • Proved ability to thoroughly document and articulate requirements and transmit to teams
  • Worked with team members to identify business requirements, developed data modeling mainly agile and waterfall and implemented data model mainly relational
  • In-depth knowledge and understanding of data warehousing concepts and developed data warehouse and data mart in SQL server 2008R2/2012/2014
  • Experienced with bulk insert and incremental loading of data in to data warehouse
  • Experienced in deployment of integrated and transformed data into SSIDB using project and package level deployment methods and created environmental variables
  • Believe in team work and experience sharing and open minded to learn new technologies and adapt to new environment and with great problem solving and analytical skills

TECHNICAL SKILLS:

  • Language and scripting T-SQL, PL/SQL, Python, XML
  • RDMS SQL Server 2016/2014/2012/2008/ , Oracle 11g/10g/9i and MySQL
  • BI and Data analytics SQL Server Integration Service (SSIS), SSAS, SSRS, Power BI and Tableau
  • Data visualization and analytics tools Power BI, Tableau, Microsoft Excel
  • Operating System Windows, Linux
  • Data Modeling tools Erwin, Lucid chart
  • Cloud service
  • Azure

PROFESSIONAL EXPERIENCE:

SQL/ETL/ BI Developer

Confidential, Silver Spring MD

  • Designed, developed, tested, tuned, and implemented relational database objects with T-SQL.
  • Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles
  • Used multiple join statements to retrieve data from different tables and update tables
  • Transformed data using conditional split and loading it to the target destination mainly using BIDS 2012, SSIS 2014
  • Performed data conversions with Derived Column, Merge, Merge Join, Union All, multicast, lookup and a lot more others
  • Created, manipulate and deploy cubes so as to analyze data from different perspectives in SSAS
  • Performed SQL Server 2012/2014 installation and configuration in development, QA and Production environments
  • Follows SDLC methodologies in performance of all development activities, including design, development, test and quality assurance support for databases and reports
  • Worked closely with Database developers, DBA’s and other BI developers
  • Maintain and develop effective reports of historical performance, including core performance triangles
  • Independently creates or assists in the creation of tracking performance metrics
  • Create business intelligence tools or systems. Assist in design of related databases
  • Create and deploy ETL packages used to translating and structuring data into a model that makes visualizations render fast
  • Act as the liaison between Business Stakeholders, Developers, Infrastructure teams and project management groups
  • Develop in a number of BI reporting using SSRS
  • BI development for multiple technical projects running in parallel
  • Participate in development and implementation of product roadmap
  • Troubleshoot and resolve incidents related to reports, database connectivity and SSIS packages
  • Assists with the development of the data model(s) for the data warehouse. Provides recommendations for all data strategies and out of scope processes
  • Work in an agile environment and contribute to the improvement of our development processes
  • Work with the other IT groups such as Infrastructure, Networks, Web Application Development to design BI solutions for internal and external use
  • Implement process improvements (Automation, Performance tuning, Optimize workflows)

Confidential

Database Developer/Business Analyst

  • Worked on Full life cycle development (SDLC) involving in all stages of development.
  • Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles
  • Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
  • Well experienced in the creation, maintenance of database and keeping referential and entity integrity of the data
  • Joined the development team and database administrators in defining specifications, reporting procedures and formats.
  • Designed and implemented user set- up, end user training materials and testing procedures.
  • Conducted User Acceptance Testing (UAT) of the developed applications along with the end-users.
  • Wrote Ad-Hoc queries and Stored Procedures using SQL Server Management Studio.
  • Reported bugs and interacted with the software development team to resolve issues.
  • Worked very closely with 10 members to achieve daily objectives.
  • Advised business users on options, risks and costs, recommended business priorities, and documented and assessed business requirements to service operation
  • Collaborated with developers on test case design, and utilized QTP testing methods during system software releases to ensure successful project launches
  • Experience in the normalization and denormalization of SQL tables depending on the business requirements
  • Deep understanding of concurrent transactions the challenges faced, the different level of Isolation
  • In depth understanding of transaction faults and the concurrency control mechanisms depending on the business requirements

Hire Now