SUMMARY:

• More than eight years of Progressive work experience in IT, specifically designing and developing BI dolutions, ETL Packages, Data Visualizations and as a Business Analyst
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables, and aggregating data into meaningful information
• Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving several tables and Triggers
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience SQL Server Installation, Configuration, Creating Logins and Database Users, Setting up DR stategy and Avalability Options
• Experience in creating and managing fragmentation of Indexes to achieve better query performance, performance tuning and Query Optimization.
• Working Knowledge of Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS)
• Proven experience developing Tableau and Power BI dashboards, scorecards and BI solutions that provided visibility for the senior leadership and the business in achieving better service quality, workforce management and business process optimizations
• Good understanding of (SDLC) software development life cycle processes and principles
• Excellent analytical and with a bility to learn new skills fast and being able to adapt to change fast, driving advantage from new tools and processes. Self motivated, able to handle multiple priorities and excellent time management skills
• Excelllent communication and facilitation skills with the ability to gain consensus across multiple teams and proven team players

TECHNICAL SKILLS:

DBMS Technologies:: SQL Server 2008 R2, 2012, 2014 and 2016; PostgreSQL 9.0 - 9.6

Operating Systems:: Windows Server 2008R2/2012; Windows 7/10; Linux: Ubuntu and Redhat

Programming/Scripting Languages:: T-SQL, C#, Python

BI Tools:: SSIS, SSAS, SSRS

Data Visualization and Analytics tools: Power BI, Tableau and Microsoft Excel

Web Technologies and Data Formats: HTML, XML and JSON

Data Modeling tools: ERWIN, Visio, Draw.io, Lucid Chart, Toad

Office Tools: Microsoft office Word, Excel, Power Point; Open Office and Google Docs

Cloud Services: AWS, Azure

PROFESSIONAL EXPERIENCE:

SQL/BI Developer

Confidential, Silver Spring, MD

• Prepared and reviewed technical design documents for ETL Development
• Worked with business users to gather and compile reporting and data ETL requirements
• Design/Develop complex queries efficiently as per the given business requirements.
• Loaded flat files(4GB) data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Created complex Transact-SQL Queries, stored procedures, views, triggers, sub-queries and joins
• Generated reports using SQL server reporting services (SSRS) that inclues matrix and tabular, drill down, drill through, and parameterized reports based on the requirements.
• Created report snapshots and cache for better performance.
• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
• Perform /Coordinated end to end Migration process in Test and Production Environments
• Created Scripts for Data Flow task to fetch data from server and load it into database through Script component.
• Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
• In collaboration with Production DBAs, scheduled Jobs that runs SSIS packages periodically for data loading and alerting using SQL Server Agent
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Working very closely with data quality team to identifying and resolving issues related to data quality raised by lines of business users
• Worked with a team of Tableau developers and participated in building and publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Installed and setup Tableau desktop for test environment
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Documentation of all the processes involved in maintaining databases for future reference
• Received multiple spot and best project performance awards for project task timely completions, cost savings, inovative ideas and cross team volunteering as business needs
• Knowledge sharing and training to internal and external users

BI and Database Developer

Confidential

• Worked with business users and stakeholders to identify Business Requirements and drivers for Template change
• Performed GAP analysis comparing the Business Content & reporting/modeling requirements
• Converted Functional Requirements into Technical Specifications
• Created and maintained stored procedures, views, triggers and constrains to implement the database consistency and integrity
• Performed all development activities required for delivery of BI solutions including ETL, data modeling, SSAS cube development, solution deployment and maintenance
• Worked with datasets with over hundreds of millions of records
• Developing customized reports using SSRS, and scheduled daily and weekly reports
• Create spreadsheet reports using Excel (Pivot Tables, vlookups)
• Participated in query optimization, performance tuning and knowledge sharing activities

Database Developer and Business Analyst

Confidential

• Worked with a team of software Engineers and Database Developers in collecting application requirements and followed SDLC processes in analyzing, designing and creating ER diagrams and data models
• Collaborated with the designers and advisors in an effort to map out and document the exact system requirements
• Identified, communicated, and coordinated with all affected stakeholders for projects, requirement gathering both internal and external
• Isolated gaps between the technical requirements and business requirements
• Analyzed the architecture to determine if the technology requirements are available to ensure infrastructure capacity to meet the business needs
• Served as the liaison between the end users and software development team by participating in system testing, data validation, collection and documentation of software bug reports
• Installed and Configured SQL Server 2008R2/ 2012 following organizational guidelines for development and test environments
• Created database objects, tables functions, views, stored procedures and triggers based on the database design document, performed operational tests and moved to test environment
• Worked on extracting, transforming and loading data using SSIS 2008 Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS