PROFESSIONAL SUMMARY:

• Microsoft Business Intelligence and Data Warehouse developer with over 7+ years of experience in IT, BI and Data warehouse lifecycle using SQL server tools SSIS, SSRS and T SQL,
• Experience in design and development of SSIS packages to Extract, Transform and Load data from heterogeneous sources excel, flat files, Raw File, ADO Net to data warehouse (OLAP) according to user requirements and coordinating across various phases of Software Development Life cycle, Engaged in Database Design, Development and Maintenance of OLTP system.
• Strong command over the creation of various Database objects like Tables, Views, Indexes, Stored Procedures, Functions and User Defined Data types.
• Experience in Deploying and Monitoring ETL packages in SQL Server by job scheduling the flow of packages from Development Server to Test and Production Server.
• Proficient in optimizing SQL queries, performance tuning using SQL Profiler as well as understanding execution plans.
• Experience in creating various reports like Tabular, Matrix, Drill down, Drill - through, Parameterized, Cascading, Conditional, Chart, Sub Reports and Deploying Reports in report server.
• Ability in Business intelligence, software development, testing and maintenance focused on Jira and Power BI
• Coherent with Data Profiling, Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing.
• Expert in Unit Testing, System Integration Testing, Performance Tuning, and In-depth knowledge in Tuning SQL Queries and improving Query performance.
• Worked closely with the Project/Program Managers, Business Analyst, Data/ETL in determining the exact business rules and functionalities required for deliverables.
• Good knowledge in Multi-tier and Cross-platform environments; strong analytical and leadership qualities with excellent communication skills.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling, and reporting tools.
• Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, UML, Waterfall, and Project Management Methodologies.
• Well versed with Tuning SQL Queries & Stored Procedures to improve performance
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Excellent Analytical, Problem-solving Skills, and Communication Skills, a Motivated Team-player with Excellent Inter-Personal

TECHNICAL SKILLS:

RDBMS: SQL Server 2008/2008R 2/ 2012/2014/2016/2017/2019

Database /ETL Tools: SSIS, IBM DataStage, SSRS

Reporting: SQL Server Reporting Services (SSRS), Report Builder, Tableau, Power BI, QlikView.

Languages: VB.NET, C#, C++, T-SQL, Java, XSLT, ESQL, Python, PowerShell, Hadoop

MSOffice: Microsoft Office Tools, VisioOperating Systems: Windows Server 2008, 2008R2, 2012 and 2016

Database: Oracle, SQL Server, MYSQL, DB2

Operating System: Windows, Linux/Unix

PROFESSIONAL EXPERIENCE:

Confidential, Saint Paul, MN

ETL Developer/Power BI

Responsibilities:

• Worked on Design, build, and maintain SQL queries, triggers, tables, stored procedures, functions, views, user profiles, data dictionaries and data integrity.
• Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active, script task, xml task and various transformations
• Developed and maintained ETL (Extract, Transform and Load) mappings to extract the data
• Aggressively worked with the team to review data for extracting, formatting, and loading into the destination tables from a flat file received from the government.
• Strong in data housing concepts, Star Schema, and snowflakes Schema Methodologies
• Created complex functions, Scripts, Stored procedures, and triggers to support application
• Data flow from DHS SSIS major import process and four data feeds to applications at Confidential, Data Dictionary, Data Flow, and Data Use (functional and application interface).
• Working with business team to analyze mapping constraints, preparing technical design.
• Excellent Experience design and maintain source to target mapping and prepare implementation documents to support processes to refresh the target database with data from multiple sources.
• Developed Tabular, drill down, parameterized, cascaded, and sub-reports using SSRS.
• Reviewing query performance and optimizing code, Designing, and coding database table to store the application data.
• Created Parameterized Report, Dashboard Report and Sub Report by Year, Quarter, Month, and Week.
• Experience working onlegacy applications, financial systems, so improving data availability and integrity of downloads from State (Oracle) to the country's SQL server
• Reverse engineer existing source databases to understand the data design and perform detailed source data analysis.
• Create and maintain SSIS/SSDT packages to load data from various sources, as well as generate output extracts to external entities.
• Create and maintain database objects, enforce constraints, and create validation rules around data maintained in MS SQL databases for custom functionality.
• Experience Develop and maintain the production notification process to efficiently track and report the status of automated jobs.
• Tune existing SQL code for improved performance,Interact and coordinate with the business teams as part of requirements gathering and analysis and conduct design review meetings.

Environment: SQL Server 2017, SQL Server 18, SSDT, SSRS, FTP, Azure, JIRA, Power Bi, WINDOWS 10, VISUAL STUDIO 2017, VISUALSTUDIO 2019, MS SQL Server 2016, MS Access, Microsoft Team Foundation Server (TFS), Git, Jira, QlikView, GitHub, Dev ops.

Confidential, McLean, VA

SQL Developer /Power Bi

Responsibilities:

• Responsible for the whole project life cycle of Maintenance and Support Group which includes gathering the tickets generated by the business users and resolves the tickets raised by delivering of time solutions.
• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Involved in gathering requirements, performing source system analysis and development of ETL jobs to populate data from the transactional data source to the target Data warehouse.
• Working with different databases for data analysis and creating reports using SSRS.
• Created Dax Queries to generate computed columns in Power BI, also applied DAX calculated measures and columns.
• Developed processes based on technical specifications and development standards.
• Worked with application developers to create optimized queries.
• Improved the performance of the T- SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Experience in using profilers, Index Tuning Wizard, and performance monitor to monitor SQL Server.
• Developing and Designing tables and procedures for new modules added for application enhancements.
• Used Test driven approach for developing the application and implemented the unit tests using Python unit test framework.
• Fixed any issues related to database performance and provide corrective measures, Create schemas, table and procedures.
• Priorities projects effectively with respect to performance and company goals and tight deadlines.
• Strong aptitude for project development, management, and organization.
• Self-starter with an ability to work independently or as part of a team or lead a team.
• Monitor job performances to ensure processes run according to schedule and troubleshoot/ resolve issues as needed, create application integration and data transformation using SSIS packages and developed reports using SSRS, TABLEAU and POWER BI.
• I specialize in Microsoft Power BI to create a report using datasets and Power Bi desktop tools to understand the data in depth Table indexes, fine-tuned procedures/ SQL queries for maximum efficiency.
• Provided via the phone, application support. Developed and tested Windows command files and SQL Server queries for Production database monitoring in support.
• Good exposure in running jobs in enterprise manager using job scheduling tool.
• Experienced in Microsoft Power BI, Power BI Pro, Power Query, Power Pivot, Power BI Service, Power BI Desktop, Microsoft Excel Pivot Table, and data models to gather information from multiple sources and deliver information to the end user.

Environment: SQL Server 2017, SQL Server 18, SSDT, SSRS, FTP, Azure, JIRA, Power Bi, WINDOWS 10, VISUAL STUDIO 2017, VISUALSTUDIO 2019, MS SQL Server 2016, MS Access, Microsoft Team Foundation Server (TFS), Git, Jira, QlikView, GitHub.

Confidential, Chicago IL

SQL / BI Developer

Responsibilities:

• Worked on gathering business requirements from different databases and interacting with end clients to understand data.
• Azure will design, develop, and implement Data Ingestion and Data Consumption solutions that meet
• Worked with different types of reports pie chart, bar graph, Semi - pie reports, Table report, matrix report linked reports, click through reports, sub reports and Ad hoc reports.
• Analyzing and visualizing the data to provide better business solutions.
• Participating in Daily stand up Agile and Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Acted as intermediates between the Account, Finance team, and Offshore Lease wave team.
• Worked with Quality Control team to identify and address further issues detected during the data replication process. Reconciliation report was executed at the end of every data load process to provide counts and fallout statistics.
• Developed Dashboard Visualizations, cross tables, Bar charts, Waterfall, Tree map and complex reports which involves custom Controls and Custom Expressions using bars, lines and pies, maps, scatter plots, Gantts, bubbles, histograms, bullets, heat maps and highlight table.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T- SQL Scripting and Jobs.
• Created and modified various Stored Procedures used in the application using T- SQL.
• Scheduled and maintain packages by daily, weekly, and monthly using SQL Server Agent in SSMS.
• Develop SQL based solutions to handle requirements from developers in the SQL Server 2012 back-end databases.
• Maintain and tune production and development SQL Server 2012 databases through maintenance plans and backup procedures.
• Worked to write and modify Store procedure to implement business logic in facet extension and interface application.
• Aggressively worked with the team to review data for extracting, formatting, and loading into the destination tables from a flat file received from the government, using SQL Server, EXCEL, and MySQL.
• Created complex functions, Scripts, Stored procedures, and triggers to support application development.
• Experience in writing complex expressions to calculate, parameterize, group, filter and format the contents of a report for Business users.

Environment: SQL Server 2017S SDT, SSRS), FTP, Power Bi, JIRA, WINDOWS 10, VISUAL STUDIO 2017, VISUAL STUDIO 2017, MS SQL Server 2016, MS Access, Microsoft Team Foundation Server (TFS), Agile Scrum, Web Services, T- SQL, SQL Analyzer and Enterprise Manager and SQL Agent, BI Development Studio 2015.

Confidential - Basking Ridge, NJ

MS SQL/BI Developer

Responsibilities:

• Working with business team to analyze mapping constraints, preparing technical design document to demonstrate Proof of Concept for the audit trail process and ETL framework.
• Worked in full cycle software development projects, analyzing requirements, designing, and developing packages to perform ETL process, which required Data Extraction from unclassified database, manipulating the data to meet the new business rules on the target site and loading into the classified database, testing, implementing, and supporting the applications.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Developed and maintained ETL mappings to extract the data from different source database.
• Worked to implement and modify Index, Functions, views, triggers, and stored procedures and enforced business rules via checks and constraints.
• Experienced on configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Maintained ETL strategies while extracting data from different sources such as SQL Server, flat files and Excel.
• Involved in Database migrations from legacy systems, SQL server to Oracle.
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server. Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports by Ad-hoc Reports using SQL Server Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Administrated and scheduled mailing subscriptions on SSRS reporting server.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures, and,
• Ability to perform duties in a very fast-paced environment and ability to learn new technology.

Environment: SQL Server 2014(SSDT) (SSIS, SSRS), FTP, SSIS, WINDOWS 10, VISUAL STUDIO 2012, MS SQL Server 2012, MS Access, Microsoft Team Foundation Server (TFS).