OBJECTIVE:

Highly motivated in database and reporting technologies. Proficient in database development life cycle including data modeling, database coding, testing, and implementation and develop data visualizations/dashboards. And have a strong problem solving skill and can work independently and in group with good enthusiasm to learn from others.

SUMMERY

• 5+ years of experience as SQL/BI Developer
• Experience on planning, modeling, designing, developing, implementing, and maintaining Microsoft SQL Server 2008/2012/2014/2017 databases.
• Experience in different phase of Software Development Life Cycle (SDLC).
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server.
• Experience in creating different reports, like Drill Down, Highlighted and Tabular reports.
• Experience in Data modeling with MS Visio and Confidential.
• Performed data cleansing using different transformations within SSIS packages.
• Implemented OLAP Cubes, Facts and Dimensions for providing summarized and aggregate views of large set of data.
• Extracted data using SSIS from OLTP to OLAP systems, identified various data sources and established the connections using SSIS and constructed data source view.
• Implemented error and failure handlings within SSIS packages using event handlers, row redirects, check points, custom logs to monitor execution.
• Experience at creating Package Level Security on SSIS.
• Experience in Data migration, transformation, and integration.
• Experience on developing Data Visualizations and Dashboards using Power BI and Tableau.
• Experience in designing and implementing data warehouse and data mart using Microsoft SQL Server Integration Services(SSIS), Analysis Services(SSAS), Reporting Service(SSRS) 2008R 2/2012/2014/2017.
• Improved the performance of reports by optimizing datasets, making use of report caching and snapshots
• Designed and generated SSAS cubes for data analysis, deploying and processing SSAS objects.
• Experience with Agile development methodologies.
• Experience in T - SQL programming (DDL, DML, and DCL) skills like creating Stored Procedures, User Defined Functions, indexes, Views, Tables, Triggers and writing complex queries.
• Experience on design data warehouse tables based on star/snowflake data modeling schema for data reporting and analytics.
• Able to maintain current knowledge of relevant technology, programming skills, hardware, and applications.
• Proven experience of effortlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.
• Good problem solving, judgment and decision making skill.

TECHNICAL SKILLS:

Languages, Scripting: T-SQL, PL/SQL, Python, Java script, Java, C#, HTML, XML, CSS

CMS: WordPress and Joomla

RDMS: SQL Server 2008/2012/2014/2016, Oracle 11g

BI: Power BI and Tableau

Networking: TCP/IP, LAN, WAN topologies, DNS, DHCP

Tools and Utilities: SSMS, SQL Server Enterprise Manager, Visual Studio, MS Dynamic 365

Database Integration tools: Ms SQL(SSIS), Kingswaysoft

Data Modelling tools: Erwin, Toad, LucidChart, Visio

Operating Systems: Windows

Virtualization: VMWare

PROFESSIONAL EXPERIENCE:

SQL Developer

Confidential, Reston, VA

Responsibilities:

• Creating CRUD inside Store Procedure for required table.
• Scheduling Job that runs during the evening to update specific task using row by row level.
• Maintaining Store Procedure on production or development level.
• Create Transactional and Nested Transactional Store Procedure.
• Improve the performance of a Store Procedure.
• Using Merge Statement for Update, Delete, Insert on Target Table.
• Review complex Store Procedure.
• Participating with business analysis to gather requirements for design and implementation of database.
• Used multiple join statements to retrieve data and update the table.
• Work on upgrading databases and migrating data to different databases.
• Experience in working in SCRUM/Agile development process model.
• Worked closely with Quality Assurance and .Net Developers to identify and resolve issues.
• Using SSIS to transfer data from heterogeneous source to targeted database.
• Giving grant for specified user for Insert, Update, Delete, Select…
• Creating indexes to reduce the running time for complex queries.
• Normalize and De-Normalize of existing tables for faster query retrieval.
• Create Databases, Tables, Views, Stored Procedures, Triggers, Functions and other T-SQL code to implement business rules.

Environment: - SQL Server 2017 Enterprise, Visual Studio(SSDT) 2017, Erwin9.2, Office 2016

SQL/BI Developer

Confidential, Fort Mill, SC

Responsibilities:

• Designed and implemented tables, stored procedures views and functions.
• Maintained SQL scripts, indexes and queries for analysis and reporting.
• Analyze and develops a logical data model.
• Edit scripts on SSIS using Visual Studio IDE( C#) to display popup message as we run SSIS packages.
• Implemented Error Handling in SSIS packages and notified process results to various users and business units.
• Perform data cleansing using different transformations within SSIS packages.
• Designed and generated SSAS cubes for data analysis, deploying and processing SSAS objects.
• Extracting data from OLTP to OLAP systems, identified various data sources and established the connections using SSIS and constructed data source view.
• Created Visualizations, Dashboards with interactive views, trends and drill down on Tableau.
• Performed data extraction, transformation, and loading (ETL) between heterogeneous sources using SSIS.
• Deployed SSIS Package into production and scheduled SSIS jobs through SQL Server Agent.

Environment: : Tableau, MS SQL Server 2014, SQL Visual studio 2014, SSIS, SSRS, SSAS and MS Office , ERwin 9.2

SQL /ETL Developer

Confidential

Responsibilities:

• Worked with business users and stakeholders to understand business processes, project requirements document
• Responsible for enhancement of daily ETL Packages from excel files and OLE DB sources.
• Designed and Developed ETL packages for data pipeline.
• Demonstrated strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions.
• Design application according to business requirements and used stored procedure, function, triggers to implement required functionalities.
• Created complex SSIS packages which loaded multiple files using for each loop containers, and utilized a wide-variety of data transformations, including conditional splits, data conversions, derived column, merge joins, script components, etc.
• Implemented Error Handling in SSIS packages and notified process results to various users and business units.
• Created Visualization and Dashboard on Power BI
• Created executive-level dashboards used by upper management to gauge sales performance on a daily, monthly, quarterly, and annual basis by product type and brand.
• Identified problem areas performed troubleshooting when execution errors occurred and Deployed reports to Report Manager.

Environment: : MS SQL Server 2014, SQL Visual studio 2014, SSIS, SSRS, SSAS, Power BI, MS Office , ERwin 9.2

SQL Developer

Confidential

Responsibilities:

• Involved in complete Software Development Lifecycle (SDLC).
• Created complex SQL stored procedures, Triggers, Functions, Views, Indexes
• Installed SQL Server Management tools using SQL Server Setup Program.
• Participated with business analysis to gather requirements for design and implementation of database.
• Used both System and User-Defined functions to enhance the functionality of T-SQL code.
• Developed Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created and deployed SSIS packages using various Transformations
• Provided IT support, Network Installation(cabling), patch and crimp cables for small to medium companies.
• Performed data cleansing and validation to figure out reportable data based on the requirements.

Environment: : Microsoft SQL Server 2008, Visual Studio2010, ERwin, T-SQL