SUMMARY

Microsoft SQL/BI developer with 6+ years of experience in designing, development, and implementation of client - server/database applications utilizing MSSQL Server. Experience within multiple industries includes finance, insurance and healthcare.

TECHNICAL SKILLS

SDLC: Agile, Scrum, Waterfall, and Spiral

Databases: SQL Server, Teradata, Mongo DB

Data Modeling: ER-win, MS Visio

Collaboration Tools: SharePoint, Jira

Programming Language: Python

Integration Services: SSIS

Reporting Services: SSRS, Tableau

Development Tools: BIDS, SSDT, SSMS

Source Control: Team Foundation Server (TFS), SVN

PROFESSIONAL EXPERIENCE

Confidential, Corona, CA

SQL Developer II

Responsibilities:

• Created various SQL server objects such as stored procedures, functions and views as per the logic to be implemented.
• Created complex stored procedures to feed reports.
• Redesigned and tuned existing stored procedures, UDF, views to improve the performance of the queries utilizing execution plans. Optimized queries to use various indexes such as clustered, non-clustered (covering and filtered).
• Created functions to calculate interests for late payments which were done wrong in past 8 years.
• Developed SSIS packages to generate member, claim, and provider information for different healthcare providers.
• Implemented new reporting requirements utilizing functionality such as drill down, drill through, cascaded parameters.
• Created various SSRS reports such as linked reports, parameterized reports, sub-reports as demanded by business users.
• Improved the performance of reports by optimizing data sets, making use of report caching and snapshots

Tools: and Environment: Microsoft SQL Server 2016, SSMS, T-SQL, SSIS, SSRS, SVN

Confidential, Costa Mesa, CA

SQL BI Developer

Responsibilities:

• Designed and documented monthly database build and release process to streamline the deployment process.
• Developed multitude of database objects to support business (complex stored procedures, user defined functions, views and tables).
• Optimized queries to use various indexes such as clustered, non-clustered (covering and filtered).
• Designed SSIS packages to extract, transform and load data from multiple input sources such as SQL Server OLTP, text based files and excel with multiple sheets into SQL Server 2012 database and Teradata database.
• Modified existing integration services packages as per new logic and conducted unit testing to validate the logic.
• Adapted logging (SSIS and custom) options in SSIS packages to assist in debugging packages on production server.
• Added error row redirections, error precedence constraints, event handlers and send mail task functionality to packages for handling run time errors.
• Collaborated with database admin to validate and verify the functionality of SSIS packages.
• Optimized functionality of SSIS packages with buffer management, parallelism and utilizing properties such as max concurrent executables.
• Created multitude of Tableau reports (worksheets) utilizing visuals such as pie charts, heat maps, symbol maps, tree maps per business requirements.
• Optimized existing Tableau extract source in company Tableau Server by replace join and Data Source filter logic with View in SQL Server database.
• Developed tableau dashboards utilizing data mapping/integration features such as data blending, cross database joins.
• Wrote special calculated field with LOD expression finding aggregation result based on data source level.
• Supported production environment for issues with database objects, SSIS packages and reports.

Tools: and Environment: Microsoft SQL Server 2012, SSMS, T-SQL, SSIS, SSRS, Tableau, Teradata, SharePoint, TFS

Confidential, Aliso Viejo, CA

Data Integration Developer

Responsibilities:

• Collaborated with analysts and business users to translate functional specifications into technical designs for implementation and deployment.
• Created various OLTP database objects such as procedures, functions, triggers, and indexes utilizing T-SQL
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Optimized T-SQL scripts and stored procedures to feed reports and implemented ETL logic for faster loading and processing.
• Involved in performance tuning of queries utilizing indexes and execution plan.
• Designed SSIS packages to extract, transform and load data from multiple input sources such as SQL Server OLTP, text based files and excel with multiple sheets into SQL Server 2012 staging database.
• Involved in optimizing and debugging ETL packages at Control Flow and Data Flow level along with making proper use of transactions and checkpoints.
• Implemented error handling in SSIS packages utilizing event handlers, row redirects, and utilized loggings to log runtime information for effective debugging of packages.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Created Tableau scorecards, dashboards utilizing stack bars, bar graphs, scattered plots, geographical maps.
• Performed calculations and applied complex, compound calculations to large, complex data sets utilizing Tableau
• Created complex reports dat include multiple data sources and stores procedures with nested tabular and matrix forms and formatted the reports utilizing the Global variables and expressions (conditional formatting)
• Collaborated TFS to keep track of the history, merging code between the different versions of the software.

Tools: and Environment: Microsoft SQL Server 2008R2/2012, BIDS, SSMS, T-SQL, SSIS, SSRS, Tableau, SharePoint, TFS

Confidential, Lowell, MA

SQL Developer

Responsibilities:

• Collaborated with the business users to capture business requirements.
• Developed a Conceptual model utilizing Erwin based on business requirements.
• Designed standards for database tables, columns, procedures, and views
• Designed and optimized stored procedures to perform data profiling and auditing in the pre-staging database.
• Identified tables dat were populated with duplicates and wrote scripts to remove duplicates and sync data as required.
• Developed scripts to manage the metadata of the database model and recognize referential integrity and other constraints.
• Created clustered and non-clustered indexes on tables ensuring the efficiency and latency of queries.
• Designed mappings between sources to operational staging
• Designed SSIS packages to extract, transform and load data from multiple input sources into SQL Server 2008R2 Staging Database, and utilize various transformations.
• Supported production environment for issues with database objects, SSIS packages

Tools: and Environment: MS SQL Server 2008R2, BIDS, SSIS, Erwin, SharePoint, TFS, Jira