SUMMARY

• Over 7+ years of experience in Database Design, Development and Support of MS SQL Server in Production and Development.
• Strong technical knowledge in MS SQL server development and Microsoft BI Tools.
• Experience in building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters.
• Strong working experience on SQL Server including SSIS, Performance tuning, reporting, designing logical/physical databases and Troubleshooting.
• Experience in creating tables, stored procedures, views, triggers, functions, indexes, data integrity, data dictionaries, and relational database models.
• Expertise in design, development, testing and support of ETL process for large scale Data warehousing using SQL server, SQL server integration services (SSIS/DTS), SQL server reporting services (SSRS) and Analysis services (SSAS).
• Experience in SQL Server OLAP database development including KPIs, Data mining, working with changing dimensions.
• Expert in creating databases and various SQL server objects like schemas, tables, indexes, indexed view as per the specifications and requirements to meet the business functionality.
• Expertise in creating complex Stored Procedures (Dynamic and static), effective User - Defined functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Hands on experience with analyzing query plans, extended Stored Procedures, managing indexes to provide quick results for Applications.
• Experience in creating complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server and Transformation.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps).
• Experience converting SSRS reports to Power BI. Expert in creating multiple types of reports using tools likePower BIandSSRS.
• Experience in Full Software Development Life Cycle (SDLC) including Analysis, Design and Review of Business and Software Requirement Specifications; Development, Testing as per agile software development methodology.

TECHNICAL SKILLS

Relational Databases: MS SQL Server, Oracle, MS Access.

Reporting Tools: SSRS, Report Builder

Database Tools: SQL Server Business Intelligence Development studio(BIDS), SQL Server Management Studio, Analysis Services (SSAS), Visual Studio, Query Analyzer, Tableau, SQL Profiler, TFS.

Languages: SQL, T-SQL, PL/SQL.

Web Technologies: HTML, XML, XSL.

Data Modeling Tools: ETL, Visio, Microsoft Office Suite.

BI Tools: SSIS, SSAS, SSRS, Power BI (Power Query, Power Pivot, Power View, Power Map).

Operating Systems: Windows, UNIX, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, MD

BI Developer

Responsibilities:

• Interface with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.
• Designed SSIS Packages in SQL Server to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files to SQL Server Database.
• Involved in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Mart and OLAP technologies.
• Build and deploy end to end ETL Process to load data into Data warehouse from flat files and source SQL databases using SSIS.
• Deployed web embedded power BI dashboards refreshed using gateways by using workspace and data source.
• Worked on performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in working with SSAS in creating data sources, data source views, named queries, cubes, roles, calculated columns, dimensions and deploying of analysis services projects.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Used Microsoft Power BI, Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Scheduled and monitored SSRS report subscription and deliveries such as Email Delivery and File Share Delivery as required.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Environment: SQL Server, T-SQL, SQL Profiler, SSIS, SSRS, SSAS, Oracle, Query Analyzer, Power BI, Power Pivot, Windows, MS Excel.

Confidential, MN

BI Developer

Responsibilities:

• Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
• Designed, developed, and maintained reports and multi - level dashboards in Tableau.
• Built interactive dashboards and stories using Tableau Desktop for accuracy in report generation applying advanced tableau functionality:parameters, actions, and tooltip changes.
• Worked on designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Developed Tableau reports including highlight tables, stacked bars, side byside bars, symbol maps, filled maps, heat maps.
• Optimized current pivot table reports using Tableau and proposed an expanded set of views in the form of interactive dashboards using linegraphs, bar charts, heat maps, tree maps, trend analysis, Pareto charts and bubble chartsto enhance data analysis.
• Worked with R functions and R models in Tableau.
• UsedETL process to Extract, Transformand Load the data into stage area and data warehouse
• Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.

Environment: Tableau Desktop 10.x/9.x/8.x, Tableau Server 10.x/9.x, MySQL, ETL, SSRS, SharePoint, SQL Server and Windows.

Confidential

SQL Developer

Responsibilities:

• Involved in Setting up new MS SQL Server instances and databases.
• Involved in Capacity planning of MS SQL Servers. Implemented and maintained database security.
• Going through the clients' requirements and coming up with database design and application architecture along with stored procedures.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Designed new job process, new database maintenance plans, DTS packages and did performance tuning of the existing processes. Troubleshoot and minimize production down issues.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method. Monitor failed and long running MS SQL Server jobs.
• Data conversions and data loads from various databases and file structures.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server, Transact-SQL, Enterprise Manager, Query Analyzer, Oracle, PL/SQL.

Confidential

MS SQL & BI Developer

Responsibilities:

• Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
• Created stored procedures using Common Table Expression (CTE) and various types of UDF functions
• Generated multiple Enterprise reports from SQL Server Database (OLTP) and SQL Server Analysis
• Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports etc.
• Developed complex Stored Procedures and views to generate various Drill-through reportsparameterized reports and linked reports using SSRS.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading
• Prompts, fund Reports, sub-reports, charts, Pie charts, conditional and dynamic reports using SSRS.
• Worked on all types of report types like tables, matrixes, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Developed, monitored, deployed, Scheduled, and executed SSIS Packages using SQL Server Agent.
• Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, MulticastingConditional, Split, Derived columns etc.

Environment: SQL Server 2014, Enterprise Manager, Management Studio, SQL Profiler, SQL Query AnalyzerMS SQL Server DTS, SSIS, SSRS, MS SQL Server Analysis Services (SSAS).