SUMMARY

• Over 6 years of IT experience in Analysis, Design, Development, and Implementation of Database, and Business Intelligence solutions for Data Warehouses and SQL Servers.
• Good knowledge of designing Star, and Snowflake schemas.
• Experience in Conceptual, Logical, and Physical Design of the Database and Data Warehouse.
• Experience indesigning, developing, and deploying Business Intelligence solutions using SSIS,and SSRS.
• Good hands - on experience inwriting Complex SQL Queriesinvolving multiple tablesusing sub-queries and joins in SQL Server Management Studio.
• Extensive experience in T-SQL like developing Stored Procedures, Views, Cursors, and Triggers.
• Experience in importing and exporting data from and to flat files, oracle, CSV files, excel, and different data sources.
• Experience in migration of legacy data by creating various SSIS packages.
• Good hands-on using Control-M for job scheduling and automated data processing.
• Experience in data migrations while updating to new versions and from other data sources.
• Expertise in developing Parameterized, Charts, Graphs, and Dashboard reports like Drill-down, Drill-through, and Cascading reports using Power BI, and SSRS.
• Experience in Database Performance Analyzing, Tuning, and Debugging.
• Experience in Handling Heterogeneous data sources like Oracle, Teradata, and CSV and XML files using SSIS.
• Good Knowledge of the overall data life cycle from designing a database to maintaining thoroughly and using SSMS, SSDT (SSIS, SSAS, SSRS).
• Excellent verbal and written communication skills with a strong focus on customer-facing interaction, customer service, and presentation.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2016, 2014, 2012, Oracle 11g/10g, My SQL.

Database Tools: SQL Server Entreprise Manager, SQL Server Management Studio (SSMS), Microsoft Management Console, SQL Developer, Data Transformation Services (DTS), Data Stage PX 8.1, 7.5.

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Power BI.

Operating Systems: Windows 7/8/8.1/10, Windows XP, 2000, Windows 2003 server.

Programming Languages: SQL, T-SQL, PL/SQL, VB .net.

Design Tools: Erwin 7/4, MS Visio 2007/2010.

BI Tools: SQL Server Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, WI

SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Designing, developing, and maintaining a new database from a conceptual model to a data population.
• Working on Data Extraction, Transformation, and Loading from different data sources using SSIS.
• Designing and developingSSIS Packagesto import and export data fromMS Excel, SQL Server, and Flat files into the SQL Server database using SQL Server Integration Services.
• Involved in the design and implementation of data migration and backup of bulk data from the old repository to the updated one.
• Working with Control-M for job scheduling and automating the tasks like migrations and loading data in bulk.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups, etc.
• Creating T-SQL functions and stored procedures to supply comma-delimited lists and date information.
• Working with the complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages.
• Involved in data migrations from client sources to current design and from other data sources, SSMS for querying.
• Developing various types of complex reports and dashboards.

Environment: SQL Server 2016 Enterprise Edition, SQL Server Data Tools (SSIS, SSRS), .Net framework, T-SQL, Microsoft Office Share Point Server.

Confidential, NJ

SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Working with a team designing and developing databases from scratch.
• Responsible for creating database objects like tables, Views, Store Procedures, Triggers, and Functions to maintain the database efficiently.
• Creating SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to the SQL server.
• Generated reports to retrieve data using database code objects, such as Stored Procedures, views, functions, and multiple T-SQL.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS reports and Power Pivot.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Configured the report viewing security for various users at various levels using SSRS Report Manager.

Environment: MS SQL Server 2008/2012, MS SQL Server Data Tools, Visual Studio 2008, PL/SQL, Microsoft Office Share Point - 2008, VB.Net.

Confidential

SQL Server Developer

Responsibilities:

• Writing SQL Server database procedures, functions, and triggers
• Responsible for overseeing the Quality procedures related to the project
• Developing test plan and test strategy
• Review of the test cases written for unit and integration level
• Integrating the test scripts written for individual units
• Writing Test scripts and functions wherever necessary for various units of the business modules
• Effective coordination between the development team and testing team
• Writing RTMs before the test planning phaseAnalysis of the specifications provided by the users
• Generating reports using crystal reports

Environment: Visual Basic 6.0, Windows 2000 operating system, Microsoft SQL Server 2006 server, Visual Source Safe