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