SUMMARY

• Business Intelligence experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server, SSIS, SSAS and SSRS.
• Experience in Confidential, Transportation and Mortgage domains with expertise in installation, configuration and administrationof MS SQL Server .
• Strong experience in using the Microsoft Suite (Management Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS))
• Extensive experience in BI suite - using integration services (SSIS) for ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports.
• Experience in creating complex SSIS and DTS packages for ETL purposes. Data Migration, Data Conversions, Data Extraction/Transformation/Loading (ETL) using DTS and SQL Scripts.
• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
• Strong experience in client interaction and understanding business applications, Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Highly experienced with the Full Life Cycle and Methodology for implementing OLAP (Online Analytical Processing) data warehouses and business intelligence reporting systems.
• Some Google Cloud Platform experience

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/2003/XP/Vista, Windows 7/8/10

Database Tools: SQL Server Management Studio (SSMS), SQL Profiler, Query Analyzer, DTS Designer

BI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio

Languages: T-SQL, Basic Python Programming

OLAP Tools: SSAS, SSRS

Source Control Tools: Visual Source Safe (VSS), Team Foundation Server 2010 (TFS), Tortoise SVN

ETL Tools: SQL Server Integration Services (SSIS), DTS, SQL Server Import/Export Wizard

Report Tools: SQL Server Reporting Services (SSRS), Tableau

Data Modeling: SQL Server Analysis Services (SSAS)

Job Scheduler: SQL Server Agent

Domain: Confidential, Transportation, Mortgage

Office Tools: MS Word, PowerPoint, MS Excel, Outlook

Cloud: Google Cloud Platform

PROFESSIONAL EXPERIENCE

Confidential

Software Engineering Advisor/ TSQL Developer

Responsibilities:

• Worked extensively in SQL Server Management Studio to write complex T - SQL queries to create Stored Procedures and views to satisfy business requirements.
• Often tasked to build a reporting table that consist many complex metrices to optimize and simplify tableau dashboards.
• Delivered a reporting table that shows trend in metrics by computing slope over several points by writing code for a linear regression on SQL-server.
• Identified, tested and resolved database and T-SQL performance issues to ensure data optimization for queries that take longer execution time.
• Enhanced performance using by rebuilding and reorganizing the indexes at regular intervals to avoid index fragmentation and improve better performance.
• Assist in the identification of data integrity problems and recommend strategic solutions.
• Follow Agile Methodology to keep track of projects and maintaining schedule by using JIRA and JIRA Align
• Worked with various users to assist in the creation of reports and meaningful data analysis for end users.
• Provided support as required to ensure the availability and optimized performance of developed applications and visualizations for both external and internal users.
• Developed a strong understanding of the business and associated systems to support customers’ strategic objectives.
• Met professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner.
• Developed and managed effective working relationships with other groups and personnel.
• Recommended enhancements and modifications to optimize business intelligence processes.
• Monitoring nightly jobs and investigate if there is any failure and fix the problem before the next run time.
• On call productions support: investigate and fix issues related to the production reports that users facing every day.
• Maintained and optimized existing databases, monitored database performances and growth, performance tuning.
• Proficient in creating SSIS Packages to validate, extract, transform and load data to data warehouse databases using OLE DB, SQL Server Connection from heterogeneous sources (Excel, Flat file, Data) by using multiple transformations.
• Used advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, Merge join).
• Worked on configuring, deploying and scheduling SSIS packages.
• Worked on Application integration.

Environment: SQL Server 2012 - SQL Server 2016, MS Excel, Visual Basic, BIDS

Confidential

T-SQL DEVELOPER/DATA ANALYST/BI DEVELOPER

Responsibilities:

• Designing relational database and data warehouse as per business and report requirements.
• Proficient in creating SSIS Packages for integrating data using OLE DB, SQL Server Connection from heterogeneous sources (Excel, CSV, Oracle, Flat file, Data, XML and Zip file) by using multiple transformations.
• Assist in the identification of data integrity problems and recommend strategic solutions.
• Worked on configuring, deploying and scheduling SSIS packages across different environments.
• Built efficient SSIS packages for processing dimension and fact tables with complex transformations to accommodate Type I, II and III SCDs using Merge.
• Designed, built and processed Analysis Services Cubes with complex names and calculated measures and calculations.
• Successfully implemented the POC of Power Pivot using MS-SQL Database and Microsoft Excel as sources.
• Designed and built reliable SSIS packages with detailed error handling and notification techniques to maintain integrity and notify responsible parties in the event of an error.
• Maintained and optimized existing databases, monitored database performances and growth, performance tuning, generate reports according to the business requirements using SQL Server Reporting Service (SSRS) and populated data warehouses using SQL Server Integration Service (SSIS).
• Follow Agile Methodology to keep track of projects and maintaining schedule by conducting daily scrums and bi-weekly sprints.
• Analyzed business requirements and wrote T - SQL queries and created several SSRS reports based on the requirements.
• Took leadership in troubleshooting and query tuning efforts of the company’s SSRS Reports.
• Worked extensively in SQL Server Data Tools and SQL Server Management Studio.
• Deployed various SSRS reports in report manager and created subscriptions and automated deliveries based on schedule and/or on demand.
• Worked with various users to assist in the creation of reports and meaningful data analysis for end users.
• Provided support as required to ensure the availability and optimized performance of developed applications and visualizations for both external and internal users.
• Developed a strong understanding of the business and associated systems to support customers’ strategic objectives.
• Met professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner.
• Developed and managed effective working relationships with other departments, groups and personnel.
• Recommended enhancements and modifications to optimize business intelligence processes.
• Monitoring nightly jobs and investigate if there is any failure and fix the problem before the next run time.
• On call productions support: investigate and fix issues related to the production reports that users facing every day.
• Frequently check the ticketing system and fix if there are any bugs reported by the BA or users.
• Followed Confidential while transferring data
• Extensively worked with Electronic Medical Records (EMR)

Environment: SQL Server 2012 - SQL Server 2016, MS Excel, Visual Basic, BIDS

Confidential

T-SQL DEVELOPER / DATA ANALYST

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes
• Involved in creating new databases, performance tuning, deploying, scheduling and creating reports. This included ETL of data from flat file and excel sources using SSIS, writing T-SQL backup and create various operational, drill-through and dynamic reports using SSRS.
• Responsible for the requirement, design, development, test, and implementation of complex data warehousing projects
• Worked with business projects team in the daily activities of production support with SQL platform
• Designing and implementing a Data Migration system to integrate data from various data sources into a SQL Server 2012 database
• Transformed database objects from one server to others server using SSIS.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Followed Data Management processes and procedures to meet system audits and provided input to the creation of data definitions, business rules and data access methods.
• Worked as a team member with other technical staff, such as networking to ensure connectivity and compatibility between systems.
• Created SSIS Packages by using advanced tools (i.e. Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Troubleshooting of processes, issues, and errors in SSIS Packages to improve performance.

Environment: SQL Server 2016 - SQL Server 2019, MS Excel, Visual Basic, BIDS

Confidential

T-SQL DEVELOPER/DATA ANALYST/BI DEVELOPER

Responsibilities:

• Design Database architecture and SSIS packages to integrate Property management data for various clients.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
• Used advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, Aggregations, Multicasting).
• Enhanced performance using optimization techniques-normalization and indexing
• Performance tuning of Queries and Stored Procedures.
• Designed various SSRS reports as requested by the client
• Created and developed Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created Dashboards, Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Database development utilizing Microsoft SQL Server OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation, and Loading). Database Administration including, backups, recovery, database maintenance.
• Query tuning based on query execution plans, statistics, and profiling
• Coded optimization objects including hierarchical flattening functions, strategic indexes, and staging tables as well as data and file partitioning
• Worked with Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Proficient in SSIS process design architecting the flow of data from various sources to target.
• Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Used efficient task objects/connections/workflows in packages based on data volumes and data sources.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance
• Created XML schemas to update user tables and system objects for company data dictionary
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements

Environment: SQL Server 2012 - SQL Server 2016, MS Excel, Visual Basic, BIDS