SUMMARY

• Developed dimensional data model for AD HOC reporting and data analysis used for major business initiatives
• Built and automated data integration ETL workflow used for enterprise data warehousing
• Created data visualizations used for organization operational and finical decisions
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS and SSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, j for the State and Local Agency users.
• Prepared the complete data mapping and Report Definitions for the project which involved many reports.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Worked on MS Access, SQL, Hadoop, Tableau, Business Objects, MS Excel, ODBC connections, data quality experience, software testing, process development

TECHNICAL SKILLS

• RDBMS: SQL Server 2017/2014/2012/2008 R2,MySQL
• Database Tools: SSIS, SSAS, SSRS, Crystal Report
• IDE: Visual Studio, Eclipse, MS Project 2013
• Operating Systems: Windows Server 2000, 2003, 2008, 2012,2014/2016
• Case Tools: MS Visio, Erwin
• Methodology: Agile, Waterfall
• Cloud Experience (Azure, AWS, or Confidential Cloud Platform)
• ASP.Net, XML, Relational Databases, HTML5,C#,OOP

PROFESSIONAL EXPERIENCE

SQL/ BI Developer

Responsibilities

• Gathered business requirements related to data and business intelligence needs, HLD design for the ETL and Reporting requirements.
• Liaise with business subject matter experts in analyzing Business Requirement Document (BRD) and translating them into conceptual data models and schema development to be implemented with T - SQL, ETL and Reporting to develop a solution.
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Optimized the database by creating new tables, various clustered, non-clustered indexes.
• Develop ETL QA processes using data integration tools, scripts, and stored procedures to extract data from multiple systems, applications, and other sources, and load data into enterprise data warehouse.
• Architect data automation testing methodology at different levels (unit, functional, integration, &performance testing).
• Follow established coding standards, perform code reviews, and improve standards to assure compliance
• Maintain and support previously deployed Report and ETL solutions
• Create database object (tables, views, stored procedures, functions and synonyms) to support application team
• Participate in Agile Scrum team and work collaboratively with team members and key stakeholders to gather and validate requirements as well as deliver features/enhancement
• Extracting, analyzing and transforming complex batches of data from multiple internal & external sources
• Excellent oral and written communication skills to interact with other technical team members and non-technical customers

Environment: SQL Server 2016/2014/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Teradata, Database Tuning wizard and Visual Source Safe.

SQL / ETL Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of database, ETL and different reports.
• Worked on developing Tables, Indexes, Views, Complex Stored Procedures, Triggers, Functions, SQL joins and other T-SQL code to implement business rules in SQL Server 2012/2014.
• Wrote T-SQL, designed and modified database objects such as Tables, Stored Procedures, and UDF for SSRS report requirement. collecting information, analyzing statistics, granting rights for database objects, transferring databases, creating and managing partitions, and managing user accounts
• Creating a reusable / repeatable process in SQL Server Integration Services (SSIS) that transforms data into a specific format
• Deploying and executing SSIS Packages using Stored Procedures
• Debugging SSIS Packages in SQL Server Data Tools (SSDT) and deploying to Integration Service Catalog
• Designing, developing, and testing ETL solutions and automating data loading processes
• Participating in all design reviews and requirement sessions as required
• Work with database administrators, network administrators, systems analysts, and software engineers to help resolve problems with ETL and data integration service applications
• Supporting new product development by creating new database architectures and stored procedures
• Developing, troubleshooting and tuning T-SQL scripts
• Excellent follow through and initiative, and ability to complete tasks accurately and on-time
• Strong verbal and writing skills, and the ability to communicate with technical and non-technical staff alike
• Accuracy, Analysis, Business Analyst, Business Intelligence, CMS, Collaboration, Data Analytics, Detail Oriented, Multi-Tasking, SQL
• Familiarity with Word, Visio, Excel and MS project
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions and more using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Proficient in using Table variable, Temp table, Dynamic SQL, Loop, CTE, and various built-in functions in SQL server.
• Developed Tabular, Chart, Matrix, Drill down and Drill through reports using SSRS as well as managed the Subscriptions of the reports.
• Generated Multi Parameterized reports in SSRS allowing users the ability to make selections before executing reports; thus making them user friendly.
• Experience in deployment of the generated SSRS reports through report manager.
• Designed and developed Confidential performance management solutions including Dashboards, Score cards and analysis of SSRS reports using the data from SQL Server 2008.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Extensively used SSRS for creating reports like Sub-reports, Linked reports, Cascaded Parameterized reports, Matrix reports and different types of Graph reports.
• Subscribed many of reports useful for the clients through scheduled Email subscriptions.

Environment: Agile, Automation, Data analysis, Data cleansing, Data conversion, Data mapping, Database, DevOps, ESB, ETL, Enterprise software, Integration, Implementation, Jenkins, Legacy systems, Linux, Microsoft Power BI, Microsoft Windows Azure, Python, SQL Azure, Red Hat Linux, Unix, Web services

SQL Server 2008, SQL Server Reporting Services (SSRS), Microsoft Visio, SQL Profiler, Database Engine Tuning Advisor and Visual Source Safe.

Confidential, Arlington, VA

SQL/SSIS Developer

Responsibilities:

• Involved in the analysis, design, created process flow diagram, coding and publication of customer facing reports.
• Created Complex Stored procedures, Triggers, Indexes, Rules, Integrity constraints, Cursors, Views and ad hoc queries using SQL 2005/2008for the business logic.
• Designed index and optimized queries by using execution plan for performance tuning of the database.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Developed various reports which include Drill down reports, Drill through repots, Cascaded Parameterized reports, Linked Reports, Sub Reports and Matrix reports using SSRS and integrated with Microsoft office Share Point portal. The SharePoint page also contains parameters for enabling the end-users to make filter selections.
• Created reports, metrics, KPIs and scorecard to the customers using SSRS.
• Experience in generating reports like Tabular, Chart, Graph, Parameterized reports using SSRS and deployed the same through report manager.
• Worked on designing and developing Executive Reports like Customer Monthly Report, Reporting Services Integration, Internal Customer facing reports and Internal Managed Security Services Reports.
• New Initiatives to automate many of the Metrics reports useful for the management and delivering it through Scheduled email subscriptions.
• Managed documents in SharePoint portal.
• Involved in the revamp of the existing database, which was primarily aimed at performance enhancement and as a step to streamline the reporting process.
• Defined a streamlined process for the entire development and testing life cycles.
• Arranging a knowledge sharing sessions and bringing up the best practices among the team.

Environment: SQL Server 2005, 2008, SQL Server Reporting Services(SSRS), Microsoft InfoPath, Microsoft SharePoint, MS Visio, Managed HPSD (Internal Tool), SQL Profiler, Database Engine Tuning Advisor, Visual Source Safe and Share Point.

TECHNICAL SKILLS

• Databases: MS SQL Server 2008/2008R2/2012/2017
• ETL Tools: SQL Server Integration Services (SSIS)
• Reporting Tools: SQL Server Reporting Services (SSRS), Report Builder 2.0/3.0, Power BI, tableau
• Data Mining Tools: SQL Server Analysis Services (SSAS) Tabular Model
• Language skills: Transact SQL (T-SQL), My/SQL, PL/SQL, DDL,DML,DCL
• Database Development: T-SQL Stored Procedure Development Experience
• SSIS Developmen t, Data Modeling (Normalization, De-Normalization/dimensional model)