SUMMARY

• 5 years of professional experience with knowledge in Data Modeling, Data Warehouse, ETL, T - SQL Development, MS Business Intelligence Tools like (SSIS, SSAS, and SSRS) in SQL Server 2012/ 2014/ 2016/ 2017/ 2019.
• Adept in SSIS direct and indirect configuration (XML, SQL Server) set up, SSIS audit and logging, error handling, and performance tuning of SSIS Packages.
• Adept knowledge in creating calculated members and KPIs using basic MDX expressions.
• Configured snapshot replication for reporting, user acceptance test, and development servers.,
• Experience optimizing SSAS using the flight recorder to log queries submitted to the Analysis Services Engine and perform usage-based optimization to improve the pre-calculated aggregates for reports.
• Expert knowledge and experience authoring, managing, and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Expertise with data cleansing operations using SSIS transformations and T-SQL scripts to normalize the data and remove and identify potential problem points when moving information into a data warehouse.
• Involved in all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Bulk Insert, and SSIS and creating Master-Child Packages in SSIS using Kimball methodology.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler, and SQL Server Debugger.
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions,Extract, Transform and Load (ETL)solutions for Data warehousing applications.
• Proficient in writing T-SQL queries for creatingTables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models, andData Integrityin observing Business Rules.
• Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension Tables, worked with high volume databases with partitioned data.
• Thorough knowledge of working with database maintenance including using Database Management Views, Dynamic Management Functions, and DBCC commands to improve table fragmentation and index performance.
• Used expressions to calculate, group, filter, parameterize and format the contents of a report.
• Well-versed in creating OLTP relational data models and OLAP dimensional models using ER-Win.
• Well-versed in designing complex reports like Drill-Down reports, Drill-Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports, and Dashboard Reports using SSRS based on client requirements.
• Worked on accommodating and facilitating Joint Application Development (JAD) sessions, documented, analyzed, and synthesized the results as a part of the business requirements.,
• Worked on mapping documents creation and development for Data migration, import, and Incremental load.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

TECHNICAL SKILLS

Operating Systems: Windows XP, Vista,7, Windows Server 2003/2008/R2/2012/2016

Database Packages: SQL Server 2012/2014/2016/2017/2019 , MS Access

BI Tools: BIDS/SSDT, SSMS, SSIS/SSAS/SSRS, SharePoint, TFS, Power Pivot, Power View

Data Modeling: Erwin, MS Visio

SDLC Methodologies: Water Fall Model, Agile, SCRUM

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

SQL/ETL Developer

Responsibilities:

• Created several reports using SSRS such as Drill Through reports, Linked, and sub reports.
• Managed very large reports that return a large volume of records and optimized their performance using techniques such as Cascading Parameters and Filters.
• Devised dashboards to contain drill-down capabilities to view requested user information through summary reports and trend charts.
• Scheduled jobs like backups and restoring of databases using the SQL Server Job Agent.
• Gathered requirements from the client, Perform Gap Analysis and Facilitate JAD Sessions.
• Was responsible for analyzing various dimensions and facts that could be included in Data Warehouse design using the best-suited Star Schema and created a logical and physical model of DW in design software like ER-Win.
• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front-end application.
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Was responsible for identifying sources, and creating a staging database, and data warehouse (Facts and Dimensions).
• Managed the entire ETL process involving the extraction, analysis, transformation, loading, and presentation of information to the end users.
• Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.
• Created complex SSIS packages to pull data from Excel and flat files to SQL server
• Implemented various SSIS features like loggings, transactions, checkpoints, deployment, and configuration on a designed end-to-end ETL strategy so that the developed packages could be optimized to the fullest depth.
• Implemented the Master Child Package Model for easier maintenance and better performance.
• Implemented package configurations in the development, test, and production environments.
• Was responsible for securing the entire database with various types of encryption techniques along with the use of certificates.
• Implemented appropriate high-availability solutions like log-shipping and mirroring which best suited the business needs according to the functionality and the budget requirements.

Confidential, Torrance, CA

SQL/ Data Warehouse Developer

Responsibilities:

• Used SSIS Packages to extract transform and load data from multiple input sources like Excel files, Production SQL Servers (2005/2000), and Oracle into the data mart in an optimized way.
• Incorporated Error Redirection during ETL Load in SSIS Packages. Involved in Unit testing and System Testing of ETL Process.
• Generated ad-hoc Reports using SQL 2005/2008 Server Reporting Services to validate the information inserted into the warehouse after refreshing it.
• Performed Functional and Regression Validation on SSRS Reports which implements drill down/drill up, Sub reports, and validated the Security on SSRS reports.
• Created a Document Map to navigate to the section of the report.
• Created many complexes stored procedures and used them in Reporting Services directly to generate reports on the fly.
• Created Dashboards, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.
• Created various data-driven subscriptions on a monthly and quarterly basis for different reports based on requirements.
• Used Erwin tool for dimensional modeling (Snowflake schema). Forward Engineered Data Model of data mart to SQL 2008 Server.
• Participated in meetings to develop conceptual database design, improve functionality, and achieve optimal performance and development strategy.
• Designed and implemented data warehouse to data-mart using a Top-down approach.
• Created T-SQL scripts to generate all the tables and relationships based on the finalized ER Diagram.
• Created triggers and audit tables to capture the incremental data from OLTP and created complex stored procedures to perform data profiling in the pre-staging database.
• Worked on parent-child architecture on database objects including SPs, UDFs, and tables with development.
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Involved in the creation of scheduled jobs for Extracting, transforming, and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.
• Involved in dimensional data modeling and storyboarding ETL processes.
• Responsible for identifying sources, creating a staging database, data warehouse dimensional modeling (Facts and Dimensions).

Confidential, Los Angeles, CA

SQL Server Developer

Responsibilities:

• Created ER diagrams and performed normalization on them to ensure faster querying.
• Ensured data consistency by creating a primary key, foreign keys, and appropriate constraints.
• Optimized SQL queries using SQL profiler, indexed views, and indexes.
• Wrote complex queries, stored procedures, UDFs in support of the ETL processes, front-end applications, and reports.
• Created DDL and DML triggers to maintain database integrity
• Used BCP utility and bulk insert for transferring data between SQL server and flat files.
• Created ETL process using SSIS for populating data store in SQL Server 2005.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005.
• Performed various transformations like conditional split, and sorting, and included data about the environment using the audit transformation.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assisted end users with the development of complex Ad Hoc queries.
• Facilitated data retrieval and manipulation through the implementation of Views, Procedures, Triggers, and Cursors.
• Successfully implemented indexes on tables and views for optimum performance tuning.
• Supported some business-specific relationships, and advanced constraints by embedding triggers on tables.
• Set up scheduled Jobs and alerts for updates and backups.
• Involved in designing of shift-based reports, chart reports (line and column), and parameterized reports for performance analysis.
• Set up report delivery schedules and report backup schedules by configuring subscriptions and snapshots respectively.
• Designed strategies for securing the reports created depending upon the level of sensitivity of the information that the report contained.